Skip to Content
author's profile photo Nitin Kumar
0
Nitin Kumar

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

Posted on May 14, 2020 at 02:09 PM 156 Views

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
Add a comment
10|10000 characters needed characters exceeded

Comment on This Question

Assigned Tags

Related questions

3 Answers

  • author's profile photo prabhith prabhakaran
    prabhith prabhakaran
    Posted on May 15, 2020 at 03:18 PM
    1

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Nitin Kumar
    Nitin Kumar
    Posted on May 15, 2020 at 08:27 AM
    0

    Source system in this case is S4HANA 1909 Onpremise.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo John Leggio
    John Leggio
    Posted on May 15, 2020 at 03:56 PM
    0

    Hi Nitin,

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

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

    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/5418de55938d1d22e10000000a44147b.html

    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.pdf

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

    HTH

    John

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.