How to display 2 Entity set data at once.

[Former Member]

Hi Experts,

I need to display Material Internal Table and BAPI return Table at one go. How do we achieve this gateway OData.

        [

             "Materialno" : "",

             "MaterialDesc" : "",

             "Plant" : "",

             "Unit" : "",

             "results" :

         ]

     ........

         [

              "Type" : "W",

              "Id" : "MM",

              "Number" : "354",

              "Message" : "XXXXXXXXXXXXXXXXXXXXXXXX",

              "LogNo" : "",

              "LogMsgNo" : "000000",

              "MessageV1" : "",

              "MessageV2" : "",

              "MessageV3" : "",

              "MessageV4" : "",

              "Parameter" : "",

              "Row" : 0,

              "Field" : "",

              "System" : ""

         ]

          ......

Thanks,

Madhu M V

[Andre_Fischer]

Hi Madhu,

you have to adapt your data model so that all the information is contained in one entity type. (for example the header) and the items in a separate entity type. Here you can use $expand to retrieve all values. See also the following discussions. Help generating NW Gateway OData service for Z ... | SCN and  Call mutiple tables data in single OData servic... | SCN

Best Regards,

Andre

[Former Member]

Hi Andre,

Thanks for your response.

I agree, we can have one header and create association with Item and use GET_EXPANDED_ENTITYSET , But If you notice, I have two Internal table (one for Materials and one for Return table). Return and Materials tables should not have any association, but need to be outputed in one go.

How to achieve this?

Thanks,

Madhu M V

[AshwinDutt]

Hello Madhu,

What is the operation which you would like to do with kind of data model ? Sharing that information may help.

Regards,

Ashwin

[EkanshCapgemini]

Hi Madhusudhan,

You can create the association with any common key i.e. with out any referential constraint. Once you are defining the relationship, select the proposed row in the referential constraint screen and delete it and proceed.

Use data provider expand and send both the entities in one expand call.

Regards,

Ekansh