Very informative tutorial ...Your channel is underrated...Your should have no less than 1 lakh subscribers .....Excellent content with easy explanation .....Thanks a lot sir for all your effort...
Thank you for the tutorials. It would be nice if you could produce one full Fiori project using CDS, CDS annotations, OData and Fiori view app in the future.
Awesome videos Ganesh, and thanks @satishbabar6552 I got the point but now in my customer table when it comes to second customer, I also able to see the first customers record as in navigation property(itab), still something not correct right?
Excellent content and very easy and good explanation for odata beginners. Thanks a lot !! Is there a way I can buy rental system to practice all these. Any insights would be really helpful!
Hi Ganesh, while using navigation HDRTOITEMNAV in debugger we can see the ship details in er_entityset but when it displayed in url it only has header and item ? May i know where ship details are getting deleted?
Hi Ganesh, Good Morning!... How we can declare Date and time fields in entity type and the how we need to fill the et_* internal table with select query can you please explain this because am geeting the 500 error when am trying to fill data and time fileds by using select query.
Hi Sir , when I am executing URI whatever you have provided it's not triggering our particular method(i.e debugging mode ) then what is the issue ? Could you please help on this
If you get success message with 200 as status code then please find the below reasons. 1. Breakpoint in the method might be session - please change to external. 2. If you are using Trusted RFC connection, then they might be disabled the debugging option. 3. Navigation path is case-sensitive, please check.
@@just2shareji data : it_deep_entity type table of zcl_zrm_odata4_deep_mpc_ext=>ST_DEEP, wa_deep_entity like line of it_deep_entity. data : it_head type table of ztest_h, it_item type table of zcl_zrm_odata4_deep_mpc_ext=>TS_SITEM. "ztest_i. data : wa_odata_item type zcl_zrm_odata4_deep_mpc_ext=>TS_SITEM, wa_odata_head type zcl_zrm_odata4_deep_mpc_ext=>TS_SHEAD. BREAK-POINT. CASE IV_ENTITY_SET_NAME. WHEN 'sheadSet'. select * from ztest_h into table it_head. if sy-subrc eq 0. select BUS_ID BUS_COMP MODEL_NAM from ztest_i into table it_item for all entries in it_head where BUS_ID = it_head-BUS_ID. endif. loop at it_head into data(ls_head). MOVE-CORRESPONDING ls_head to wa_deep_entity. LOOP AT it_item into data(ls_item) where bus_id = ls_head-bus_id. MOVE-CORRESPONDING ls_item to wa_odata_item. append wa_odata_item to wa_deep_entity-HDR_TO_ITEM. append wa_deep_entity to it_deep_entity. * CLEAR WA_DEEP_ENTITY. ENDLOOP. endloop. CALL METHOD me->/IWBEP/IF_MGW_CONV_SRV_RUNTIME~COPY_DATA_TO_REF EXPORTING IS_DATA = it_deep_entity CHANGING CR_DATA = er_entityset . ENDCASE.
Bro in debugging am getting crct values but output am getting only header values not item values what to do plz reply 🥹🥹🥹 tried whole day but not getting
Hi sir, could you make a video on how to use shortcuts in sap. Because it will be helpful for us and reduce coding time. Thanks for sharing your knowledge with us.
Dear Sir , I found the another issue as all my items data are coming but for header details only key field values are coming rest header fields are not coming
Do the fields are coming as empty or even the field itself not reflecting? Please drop an Email, would be easy to see any screen shots or piece of code if required.
Mostly all the concepts videos are in one playlist, and it is called "OData Service". Other playlist are SV and QR, this has few quick videos regarding OData.
one Correction, ur code was going loop so when i applied this at last of code in exapnd method, it wasnt going loop CONSTANTS : c_expanded_tech_clauses TYPE string VALUE 'NAVHTOI1,NAVHTOI2'. INSERT c_expanded_tech_clauses INTO TABLE et_expanded_tech_clauses. By the Way, Thanks u very much sir for giving Clarity.
I am following the same step and get the data in header but their is no data in item table. "Aktyp" : "", "Insobject" : "PO-Test01-01", "InsobjectCategory" : "10", "InsobjectDescription" : "Test Policy", "InsobjectExt" : "", "UsernameBusinessCreate" : "", "ObjectReference" : "Product 123", "BasecontractType" : "", "BasecontractId" : "", "BasecontractItemType" : "", "BasecontractItemId" : "", "BasecontractBusinessSystem" : "", "ValidFrom" : "", "Partner" : "", "PartnerExt" : "", "insocreatetopartnernav" : { "results" : [ ] }, } I am getting the data on debugging time in 'insocreatetopartnernav' , but after full execution at sap gateway my 'insocreatetopartnernav' is empty. What are the possible reason for this issue. Thanks
Very informative tutorial ...Your channel is underrated...Your should have no less than 1 lakh subscribers .....Excellent content with easy explanation .....Thanks a lot sir for all your effort...
thank you , this is one of the clearest tuto that i have seen
Welcome, and glad my videos are useful.
Outstanding tutorial, cleared all my doubts on deep entity.. hats off ❤️❤️
Thank you
Great channel and great video
Very helpful video. Exactly what I was looking for.
Thank you.
Thank you for this tutorial.. Very well explained.
Thank you and welcome
great , deep explanation.
Very informative video 👍
Thank you
Thank you for the tutorials. It would be nice if you could produce one full Fiori project using CDS, CDS annotations, OData and Fiori view app in the future.
It's not imp(we can understand) but at 47:46, append wa_deep_entity to it_deep_entity should be one line above i.e in between two endloop.
Thank you for noticing and letting me know... :)
Awesome videos Ganesh, and thanks @satishbabar6552 I got the point but now in my customer table when it comes to second customer, I also able to see the first customers record as in navigation property(itab), still something not correct right?
@@sadullahtanrikulu Probably you need to debug yourself first... and I think you'll get the solution..
Very informative thank you so much .
Nice Video .. Thanks a lot
Excellent content and very easy and good explanation for odata beginners. Thanks a lot !! Is there a way I can buy rental system to practice all these. Any insights would be really helpful!
Thank you.
Please contact:
Nag - +91 99639 23973
Das - +91 98303 17009
Hi Ganesh, while using navigation HDRTOITEMNAV in debugger we can see the ship details in er_entityset but when it displayed in url it only has header and item ? May i know where ship details are getting deleted?
Could you try adding the entity name using IF condition?
nice info brother
Dear Ganesh may I know which software you used for dat flow diagrams?
PPT only.
When am select the Null check box entity type the error will not coming but date and time values was not coming it is comes with value is 'true' .
Hi Ganesh, Good Morning!... How we can declare Date and time fields in entity type and the how we need to fill the et_* internal table with select query can you please explain this because am geeting the 500 error when am trying to fill data and time fileds by using select query.
Nice Explanation
Can we pass parameters to the Associations
like /header/?$expand=item(num=100001) something like this
Hi Sir , when I am executing URI whatever you have provided it's not triggering our particular method(i.e debugging mode ) then what is the issue ? Could you please help on this
If you get success message with 200 as status code then please find the below reasons.
1. Breakpoint in the method might be session - please change to external.
2. If you are using Trusted RFC connection, then they might be disabled the debugging option.
3. Navigation path is case-sensitive, please check.
@@just2shareji could you please elaborate 2 nd point . It's very helpful to us
Thank you Sir , issue resolved..
Thank you for helping
Best one❤ty
Thank you and welcome
How can we add deep entity set (it includes multiple header and items) in this method?
It about data, then this process will take care. If multiple headers, you may try with complex type option.
Thank you so much!
Welcome!!!
Thank you sir, Guru deva namo namaha
Thank you - Sarvam Avane..
can you tell me how to use new syntax for the nested loop
I believe had a video on this, could you please check the ABAP on HANA playlist
hi Sir, I am not getting the values in the item entity set but fields are there
Hope fully, it might get overwrite from other entity set... Did you check in the debugging, and your can use IF condition to avoid the same.
@@just2shareji As I am using case statement so it should no overwrite?
@@just2shareji
data : it_deep_entity type table of zcl_zrm_odata4_deep_mpc_ext=>ST_DEEP,
wa_deep_entity like line of it_deep_entity.
data : it_head type table of ztest_h,
it_item type table of zcl_zrm_odata4_deep_mpc_ext=>TS_SITEM. "ztest_i.
data : wa_odata_item type zcl_zrm_odata4_deep_mpc_ext=>TS_SITEM,
wa_odata_head type zcl_zrm_odata4_deep_mpc_ext=>TS_SHEAD.
BREAK-POINT.
CASE IV_ENTITY_SET_NAME.
WHEN 'sheadSet'.
select * from ztest_h into table it_head.
if sy-subrc eq 0.
select BUS_ID
BUS_COMP
MODEL_NAM from ztest_i into table it_item
for all entries in it_head
where BUS_ID = it_head-BUS_ID.
endif.
loop at it_head into data(ls_head).
MOVE-CORRESPONDING ls_head to wa_deep_entity.
LOOP AT it_item into data(ls_item) where bus_id = ls_head-bus_id.
MOVE-CORRESPONDING ls_item to wa_odata_item.
append wa_odata_item to wa_deep_entity-HDR_TO_ITEM.
append wa_deep_entity to it_deep_entity.
* CLEAR WA_DEEP_ENTITY.
ENDLOOP.
endloop.
CALL METHOD me->/IWBEP/IF_MGW_CONV_SRV_RUNTIME~COPY_DATA_TO_REF
EXPORTING
IS_DATA = it_deep_entity
CHANGING
CR_DATA = er_entityset
.
ENDCASE.
My header data is coming but items are not coming..
@@rajumandi Nope, same for IF & CASE. Any luck in the debugging?
Bro in debugging am getting crct values but output am getting only header values not item values what to do plz reply 🥹🥹🥹 tried whole day but not getting
Hope that might overwrite... keep an IF condition, it make sure the code executes for the particular entity...
Hi sir, could you make a video on how to use shortcuts in sap. Because it will be helpful for us and reduce coding time.
Thanks for sharing your knowledge with us.
Sure, let me make it.
Dear Sir , I found the another issue as all my items data are coming but for header details only key field values are coming rest header fields are not coming
Do the fields are coming as empty or even the field itself not reflecting? Please drop an Email, would be easy to see any screen shots or piece of code if required.
@@just2shareji fields are there but no values...
@@rajumandi Hope I responded through Email.
@@sapabap9977 yes
Hi can i have all odata related videos. please reply.
Mostly all the concepts videos are in one playlist, and it is called "OData Service". Other playlist are SV and QR, this has few quick videos regarding OData.
Iam not clear why you have kept append statement to fill it_deep_entity table after the outer loop.. I think it should be inside the outer loop.
Correct Shiva, and thanks for letting me know. The Append must be inside the outer loop.
Will the output change?
@@sriramkumar8331 the it_deep_entity table gets updated with only one record always that is final record.
Get deep entity set I have created but only one association can be created
Could you please share with some screen shot to my Email me if you have still issues.
Hi can you please explain the pagination also sir
I am not sure, could you please check the playlist for pagination. - we can achieve with TOP and SKIP options.
one Correction, ur code was going loop
so when i applied this at last of code in exapnd method, it wasnt going loop
CONSTANTS : c_expanded_tech_clauses TYPE string VALUE 'NAVHTOI1,NAVHTOI2'.
INSERT c_expanded_tech_clauses INTO TABLE et_expanded_tech_clauses.
By the Way, Thanks u very much sir for giving Clarity.
Thank you Vivek for letting me know this.. Appreciate
I am following the same step and get the data in header but their is no data in item table.
"Aktyp" : "",
"Insobject" : "PO-Test01-01",
"InsobjectCategory" : "10",
"InsobjectDescription" : "Test Policy",
"InsobjectExt" : "",
"UsernameBusinessCreate" : "",
"ObjectReference" : "Product 123",
"BasecontractType" : "",
"BasecontractId" : "",
"BasecontractItemType" : "",
"BasecontractItemId" : "",
"BasecontractBusinessSystem" : "",
"ValidFrom" : "",
"Partner" : "",
"PartnerExt" : "",
"insocreatetopartnernav" : {
"results" : [
]
},
}
I am getting the data on debugging time in 'insocreatetopartnernav' , but after full execution at sap gateway my 'insocreatetopartnernav' is empty.
What are the possible reason for this issue.
Thanks
Please try to have a IF condition on entity name... because the method might call for all the entity..