on 07-08-2013 12:51 PM
Hello Bi Experts,
I have a doubt concerning values that I can write under 0unit. For eg.
This is my data which I want to load it as TD to DSO.
char IO | char IO | keyf IO | keyf IO Keyf IO
PROD NU | PROD NAME | PROD COST | PRD QUAN PUR | UNIT | TOTAL COST | CURRENCY
PRD001 | OIL | 18 | 5 | LITRES | | INR
THIS IS SAMPLE DATA WHERE I AM TRYING TO USE LITRES UNDER 0UNIT INFOOBJECT.
When I try to extract the data, i get an error message stating that LIT is not an english language. Sometimes, If I use units like KG and LItres, KG will get displayed but not the litres, instead of litres, I get to see ******.
Could anyone explain what I need to do in order to get Litres accepted under 0unit. The alternative that I try is I choose PRD QUAN PUR as numc keyf and make unit as char IO. It is only then I get to see the data as desired in the final output.
Please help!
Many thanks in advance.
Cheers!!!
Hi Adrian,
These are base tables for units - T006 and T006A. if you maintain the required units in this table, then you can use them where you need.
If you have access to maintain at bw side tables, you can enter values at T006/6a or at SBIW, search for units. you may get the link, there also you can do the same.
Without maintaining in base tables it won't allow you to use.
As per the 0UNIT info object length you need to define at table level LIT or LT.
Normally units and currencies are maintained by functional team at ecc side. BW team will transfer into bw side by using respective setting at RSA1, source source system link.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you guys,
It was of great help from you'll. I am looking into it and will let you'll know if any help required.
Many Thanks,
Adrian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The reason is, you are not having entry LIT or LT in your SID table i.e, /BI0/SUNIT.
To avoid this kind of errors, first you should load the master data then transactional data.
If you are maintained LITRES at ECC side then you wil not get any issues.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You have to check your units in T006 and T006A tables.
Is your system is unicode compliant? You have to "transfer global settings" on your source system right click. Regarding unicode, you can check the connection parameters in source system right click in RSA1.
Load master data first and then transaction data.
Regards,
Suman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
11 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.