Skip to Content
author's profile photo Former Member
Former Member

How to create nested NRDM structures in sap bods

Hi Experts,

can anyone please explain the purpose and how to create the nested NRDM structures in query transform

and when we unnest the NRDM structure

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2014 at 07:51 AM


    Nested structures cannot be avoided when you are handling web services, XML files , XML messages , SAP ERP data etc... In all these scenarios data will be in the form of child and parent relationships where NRDM structure will be present.

    We can create or fetch the metadata for NRDM structure in BODS.

    In order to fetch the NRDM structure the better example we can have is any XML file which you can get from an SAP ERP source.Where IDOC or BAPI will have NRDM structure involved in them, that reuires the data must be created in a format similar to the IDOC or BAPI . This involves the creation of NRDM .

    For creation of NRDM either you can use a Query transform

    1.You can create a nested structure in Query transform by right clicking the output schema.

    2. Then you can add the number of columns according to the requirement.


    1. Directly importing from a source which is having similar format as needed for the requirement.

    The reverse of creating a NRDM will be unnesting the nested structure where the data will be converted in to flat and child parent hierarchy will be removed.

    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.