CDS view I_COMPANYCODE extraction to SAP BW4H

[Tom1-2-3]

Hi experts

We have several company codes. What is new that the master data also have an attribute "language key" which we didn't have in ECC systems, 0COMP_CODE_ATTR. The extraction was quite simple.

Now with this CDS View (IFICOMPANYCODE) we also extract this attribute. Our BW4H is restricted only for DE (German) and EN (English). Transaction RZ11, Parameter 'zcsa/installed_languages'.

Company Codes with other language keys are not extracted to BW. Therefore we are missing serveral company codes in BW4H.

Question:

This is very strange to me, I need to understand how to solve this issue. I think it makes no sense to "open" BW4H for all languages.

Any ideas?

Thanks, tom

[HakanHaslaman]

If you want to extract all company codes regardless of their language key, you could possibly modify the CDS view (IFICOMPANYCODE) to include all language keys in the extraction. I guess you can do this by removing any language key filters or WHERE clauses that restrict the extraction to only DE and EN.

By doing this, all company codes, including those with language keys other than DE and EN should be extracted to BW4H.

But, please note that this may result in additional data being extracted and stored in BW4H, which could impact system performance and storage requirements!

Please, before making any changes to the CDS view, it is recommended to consult with your BW4H and ECC system administrators to understand the potential impact and ensure that it aligns with your system requirements and limitations!

[Tom1-2-3]

Thank you!

But I don't want to filter out company codes with other language codes...I need all company codes independently of language key.

How do I do this?

Regards, tom

[HakanHaslaman]

May you can modify the CDS view (IFICOMPANYCODE) to filter out company codes with language keys other than DE and EN. This can be done by adding a WHERE clause in the CDS view definition.
Alternatively, you can create a separate CDS view specifically for company codes with language keys DE and EN and use it for extraction to BW4H. The solution depends on your requirements and system flexibility.

[Tom1-2-3]

Thank you Hakan, but I don't want to filter out company codes with other language codes...I need all company codes independently of language key. How do I do this? Regards, tom