List of standard CDS view to import data in public dimension in SAC

[ni3_sap]

Hello ,

Can you please share list of standard CDS views and queries which can be used to load these public dimension in SAC including hierarchy , attributes and test.

SAP_ALL_REGION Region SAP_ALL_SUPPLIER Supplier SAP_ALL_COMPANYCODE Company Code SAP_ALL_COUNTRY Country SAP_ALL_BUSINESSAREA Business Area SAP_ALL_COMPANY_CODE Legal Entity SAP_ALL_COSTCENTER Cost Center SAP_ALL_PROFITCENTER Profit Center SAP_ALL_SEGMENT Segment SAP_FI_GEN_GLACCOUNT GL Account SAP_ALL_CUSTOMER Customer SAP_ALL_CUSTOMERGROUP Customer Group SAP_ALL_MATERIAL Material SAP_ALL_MATERIALGROUP Material Group SAP_ALL_PLANT Plant

[JohnL]

Hi ni3_sap

What is your data source?

Thanks,

John

[former_member694820]

Hi Nitin,

I have the same requirement to load the public dimensions from S4 system. Do you have any steps and suggestions.

Ex: SAP_FI_GEN_GLACCOUNT, SAP_ALL_BUSINESSAREA etc

Regards,

Krishna.

[Prabhith]

Hello @Nitin Kumar,

I presume you are trying a standard SAC Business content scenario here.

The corresponding documentation should have these CDS / Odata information.

BR, Prabhith

[JohnL]

Hi Nitin,

There is no list of CDS views. Use the view browser:

https://help.sap.com/viewer/6b356c79dea443c4bbeeaf0865e04207/1909.002/en-US/0bde695751505c08e1000000...

You can also see CDS views by LOB in the online help here:

Home/Cross Components/Virtual Data Model and CDS Views in SAP S/4HANA/

https://help.sap.com/viewer/8308e6d301d54584a33cd04a9861bc52/1909.002/en-US/5418de55938d1d22e1000000...

However please follow Prabhith's suggestion on using the SAC Business content. See

https://help.sap.com/doc/f04e1b585e9e40548d4e8de7582c9dfc/release/en-US/Documentation_SAP_SAC_CONT.p...

Also check: https://rapid.sap.com/bp/#/browse/categories/sap_s%254hana/areas/a2z/packageversions/BP_S4H_ANA/S4CL...

HTH

John

[ni3_sap]

Source system in this case is S4HANA 1909 Onpremise.