on 09-08-2015 12:04 PM
Hi,
There is requirement to covert cost center ID into BPC format. But a simple conversion say 1000 to abc itself is not working.
Below are the details of transformation/ Conversion file that I am using while loading the cost center Master Data.
Transformation :
Conversion File:
Location :
After Import master data, conversion didn't happen :
Transformation file and Conversion file validated successfully and after importing the cost center master data, conversion didn't happen.
Can anyone suggest where I am making mistake?
Thanks,
Bharat
Hi Bharat,
Try to load id and description separately.Your transformation file applicable only for id not for description.Try to load costcenter text data to BPC description.
Khokan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Khokan,
I changed the Line 17 to "ID =COSTCNTR.xls" and it worked.
But in the standard SAP document the format to use conversion file is
Dim_Name=[Team_Name]path\ConversionfileName.xls!sheet_Name
I used in this format only but it didn't worked. Is that information is documented somewhere in sap document?
Hi Bharat,
Which example you are see in sap document this conversion mapping applicable for transaction data only.When we are loading transaction then we give mapping in transformation file dimension name = Bw object name, so conversion file mapping we mentioned dimension name,but when we talking about master data load, we map properties not dimension name if you read sap standard document carefully then you can find the conversion file example for master data loading.
Khokan
Hi Bharat,
What is P_MATERIAL in line 26 of transformation file?
Best Regards,
Deepak
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.