Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am applying map on SAP sales and distribution module tables.
billing header(VBRK) field-
CompanycodeBUKRS.VBRK field name ( which is BUKRS (company code ) of SAP table)
and
Company master- T001
CompanycodeBUKRS.T001(BUKRS)
company master has two field
CompanycodeBUKRS.T001,company name
I have written applymap('[company master]',CompanycodeBUKRS.VBRK) as CompnyName.
But the output is not coming.
What can be the problem ?
Hi Santosh,
When you are giving single quote then there is not need [], if you use the [] then it is also considered as the Dimension name.
Regards,
Jagan.
Can you try this:
Company_Master:
Mapping Load
CompanycodeBUKRS.T001,
company name
From Source;
Then in the table
applymap('Company_Master',CompanycodeBUKRS.VBRK,'Missing: '& CompanycodeBUKRS.VBRK) as CompnyName
Also first Load Company_Master without Mapping prefix and see if that table is looking good(just for testing).
Also there needs to be an exact match between CompanycodeBUKRS.T001 and CompanycodeBUKRS.VBRK, else it will fail.
Even the data format should be same(like both string or both numbers).
remove []
applymap('company master',CompanycodeBUKRS.VBRK) as CompnyName.
Hi Santosh,
don't use a blank in the name of the mapping table.
applymap('company_master',CompanycodeBUKRS.VBRK) as CompnyName.
should i.e. do the job.
RR
[map1 a]:
mapping load * inline [
from, to
1, one
2, two
3, three ] ;
T1:
load
ApplyMap ('map1 a', 2 ) as colok // this works
AutoGenerate 1;
T2:
load
ApplyMap ('[map1 a]', 2 ) as colko // this doesn't
AutoGenerate 1;
applymap('company master',CompanycodeBUKRS.VBRK) as CompnyName.
Replacing [company master] with company master worked.
But I don't know why?
Hi Santosh,
When you are giving single quote then there is not need [], if you use the [] then it is also considered as the Dimension name.
Regards,
Jagan.
Hi Santosh,
Please close this discussion by giving Correct and Helpful answers to the posts which are useful for you. It helps others in finding answers for similar scenarios.
Regards,
Jagan.