Skip to Content
0
Nov 04, 2020 at 03:32 AM

Load Account dimension properties that are not as fields in BW

47 Views

1. I am loading the account dimension from the ERP through the infobject in BW “0GL_ACCOUNT”. Actually, I have already managed to upload the required account structure. However, I have tried loading some properties using conversion files, but I have the following drawback. I should clarify that these properties that I am trying to load are not in BW, such as ACCTYPE and other properties 2. When executing the master data integration, it appears successfully, but when viewing the property, it is arriving filled with data that I don't need and I don't know how to avoid this.

Using the following transform file

Using the conversion file, I need only the accounts that are in the External field when embedding the account dimension in this "Typelim" property to be stored with the corresponding Elimination code.

Using the following conversion file

When we execute the data integration, we enter the Account dimension to verify that the components have been saved.

I appreciate any help you can give me or guide me

Any comments or question do not hesitate to contact me,

Diego Rozo

Attachments

tf-account.jpg (92.8 kB)
cf-account.jpg (126.5 kB)