on 05-23-2016 12:09 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.