Exchange Rates / Unit of Measures in SAP BW

If you got this type of error:
If i go through No SID found for value 'LOT' of characteristic 0BASE_UOM
Message no. BRAIN070
Diagnosis:
Characteristic value LOT does not exist in the master data table of characteristic 0BASE_UOM. Therefore, this value could not be transformed into the internal SID.

 Procedure:

 Check whether the value is correct or not. If it is correct, you need to generate the associated master data. Note: For characteristics 0FISCPER and 0FISCYEAR, there must be a corresponding fiscal year variant (see table T009). In addition, there must be units in table T006 and currencies in the table TCURC.

This occurs during data extraction from ECC via this Datasource:0FI_GL_4 Line Items.

 Check whether the Unit of Measure exist in the Source System (R/3 or ECC). If it exists,
entries in T006 - Units of Measurement table in both ECC and BW Side.

If the UOM exists in Source system, doesn't exist in BW, have to bring them using Source system Transfer Global Settings, else maintain in Source System to transfer to SAP BW.












Select Unit of Measure & Update tables Radio buttons, execute it, before that go to system menu -->Status, Copy and the program name highlighted, Schedule a job periodically in SE36 t.code using this program:RSIMPCUST on BW Server to fetch UOM/Ex.Currencies from Source System.

So, run the job daily to Sync of master data. Will not get this issue again.

 

Comments

Mohamed Aslam said…
excellent blog ....
its like a helping hand for beginners like me..
thanks a lot...
August 9, 2012 at 10:14 AM
Anonymous said…
Thanks for sharing this Information. Got to learn new things from your Blog on SAP HANA

http://thecreatingexperts.com/category/sap-hana-training-in-chennai/

contact 8122241286
August 2, 2017 at 5:18 PM
Post a Comment

Popular posts from this blog

One stage stop to know all about BW Extractors-Part1

Image
Types of Extractors:               Application specific BW content extractors: Lo Extraction: Logistics refers to the process of getting a product or service to its desired location upon request which involves transportation, purchasing, warehousing etc. Main areas in logistics are: Sales and Distribution (SD) : application 11, 13, 08 (in LBWE T-code) Materials Management (MM) : application 03, 02 Logistics Execution (LE) : application 12 Quality Management : application 05 Plant Maintenance (PM) : application 04, 17 Customer Service (CS) : application 18 Project System (PS) : application 20 SAP Retail : application 40,43,44,45 How the data extraction happens? Extraction can be done using either Full update/delta update. Full load: Incase of l...
Read more

COPA Extraction Step By Step in SAP BW

Image
COPA Extraction Step by Step: SAP R/3 or SAP ECC: 1. SAP R/3 or ECC goto T.Code KEB0 , In Function: Select Create  Control Parameters: Provide a New CO-PA DataSource Name:1_CO_PA%CL%ERK 2. Select your O perating C oncern, e.g.,IDES. 3. Select radio button Costing-based or Account-based as OC . 4.Select field names for partitioning.e.g. BUKRS (Company Code), Check 5.Click on Info Catalog (F7) 6. Select the Characteristics & Value fields & Keyfigures 7. Select the Package/Development Class for Workbench request 8. Edit your DataSource to select/Hide fields, Save. Datasource created successfully. 9. Extractor Checker or RSA3, extraction. SAP BW:   1. Replicate DataSource 2. Assign InfoSource 3. Transfer all the datasource elements to an InfoSource 4. Activate InfoSource 5. Create a InfoCube (Copy Str from InfoSource) 6. Create Dimension & Define and Assign it. 7. Check & Activate. 8. Create Transformati...
Read more

How does a datasource communicates "DELTA" with BW?

Image
SAP R/3 or ECC DataSource Delta mechanism for SAP BW/BI What is Delta? It is a feature of the extractor which refers to the changes(new/modified entries)occured in the source system. How to identify? In ROOSOURCE table, key in the data source name and check the field "DELTA". If the field is left blank,it implies that the datasource is not delta capable. The field 0RECORDMODE in BW determines how a record is updated in the delta process. Now the question is how this delta will be brought to BW? Using one of the following ways: ABR: After before and Reverse image AIE: After image ADD: Additive image ABR: After before and Reverse image Example: Logistics What is it? Once a new entry was posted or an exiting posting was changed at R/3 side, an after image shows the status after the change, a before image shows the status before the change with a negative sign and the reverse image also shows the negative sign next to the record while indic...
Read more