Hello, How to post data from SAP Data Intelligence into ECP (Cloud ECC Instance) using OData without passing Header and CSRF Token and Content type. As it is not asking in this SAP DI tool. We do connect to ECP via OData with Basic Authentication.
Hello there, thanks for the amazing tutorial. I have got data from a source system in form of JSON stored in HANA CLOUD's JSON collection, create a hdbview over it in BAS. The data is in form nested fields also ( Deep Entity ) where few Fields has further more fields+data inside it to many levels. If I create a Calculation view (CV) over it, it stores them with STRING data type. When I expose this CV with CDS/Service, I am not able to use $expand parameter in API ( to call nested fields ), also it string data type obviously it won't be able to differentiate between fields and their nested data ( as it says no Navigation is defined in service xx ). What is the best way to handle it in this scenario ( we are okay if CV has to be removed ) or in between some other steps can be done before the CV. Thanks a lot.
Hello sir, I tried to create deep entity, but I am getting CSRF token validation failed, I searched sap community help also, based on that I tried to fetch csrf token by get request and pass this token in post request but this also not work, Can you give me any suggestions
I think you should watch ETag video of this series this might resolve your issue if you are unclear about ETag concept and CSRF token .Ideally it should work if you are passing correct CSRF token
CRUD:- Create Read Update Delete Read - /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet + GET => employeeset_get_entityset. /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet(2) + GET => EMPLOYEESET_GET_ENTITY Create :- /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet + POST => employeeset_create_entity Update /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet(6) + PUT => 'EMPLOYEESET_UPDATE_ENTITY' Delete /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet(6) + DELETE => 'EMPLOYEESET_DELETE_ENTITY' Access data through navigation /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders('4969')/Items /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderItems => salesorderitems_get_entityset Read with navigation path /sap/opu/odata/sap/ZSALESORDER_001_SRV/SalesOrderHeaderS + Get =>salesorderheader_get_entityset /sap/opu/odata/sap/ZSALESORDER_001_SRV/SalesOrderHeaderS('4970')/OrderToItem_nav + Get => salesorderitems_get_entityset /sap/opu/odata/sap/ZSALESORDER_001_SRV/SalesOrderItemS => salesorderitems_get_entityset Expand Query option :- /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders?$expand=Items salesorderheader_get_entityset => 100 salesorderitems_get_entityset => 7970 ....100 times /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders('4970')?$expand=Items salesorderheader_get_entity => 4970 salesorderitems_get_entityset => one time If we have implemented this then we have to implement /IWFND/TRACES /IWFND/CACHE_CLEANUP
They are automatically available in the framework, no further actions needed by development. $format /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders?$format=json $expand /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders?$expand=Items $select /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders?$select=SalesOrder,SalesOrg,Vtweg&$format=json $count /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders/$count $links /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders('4970')/$links/Items $value /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders('4970')/Bstnk/ /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders('4970')/Bstnk/$value
Excellent teaching. Thanks for your help.
Glad it was helpful!
Excellent teaching.
Excellent teaching sir. Can you please share the BAPI code I didn't understand how it is updating the data
Sir big fan ... I have one question I want to create deep entity for sales order a2x, using service consumption and odata proxy how to achieve this
Hi..I want BAPI code...Can u please provide BAPI Code.
Hi Ram.. please explain about the get expanded entity method also..
Thanks..
Already explained in below video :-
ruclips.net/video/ucyiByTJQLU/видео.htmlsi=4QYz7Ik6M7dLLZQa&t=3993
Hello,
How to post data from SAP Data Intelligence into ECP (Cloud ECC Instance) using OData without passing Header and CSRF Token and Content type. As it is not asking in this SAP DI tool. We do connect to ECP via OData with Basic Authentication.
Never Came across this kind of scenario.
Hello there, thanks for the amazing tutorial. I have got data from a source system in form of JSON stored in HANA CLOUD's JSON collection, create a hdbview over it in BAS. The data is in form nested fields also ( Deep Entity ) where few Fields has further more fields+data inside it to many levels. If I create a Calculation view (CV) over it, it stores them with STRING data type. When I expose this CV with CDS/Service, I am not able to use $expand parameter in API ( to call nested fields ), also it string data type obviously it won't be able to differentiate between fields and their nested data ( as it says no Navigation is defined in service xx ). What is the best way to handle it in this scenario ( we are okay if CV has to be removed ) or in between some other steps can be done before the CV. Thanks a lot.
This is scenario based Question I hope you got your answer ...
Hello sir, I tried to create deep entity, but I am getting CSRF token validation failed, I searched sap community help also, based on that I tried to fetch csrf token by get request and pass this token in post request but this also not work, Can you give me any suggestions
I think you should watch ETag video of this series this might resolve your issue if you are unclear about ETag concept and CSRF token .Ideally it should work if you are passing correct CSRF token
👍
Can we get next video soon ?
Trying in to show How fiori app current OData service which we have created it will come soon..
Can you please share the notepad file with the URLs
CRUD:- Create Read Update Delete
Read -
/sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet + GET => employeeset_get_entityset.
/sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet(2) + GET => EMPLOYEESET_GET_ENTITY
Create :-
/sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet + POST => employeeset_create_entity
Update
/sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet(6) + PUT => 'EMPLOYEESET_UPDATE_ENTITY'
Delete
/sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet(6) + DELETE => 'EMPLOYEESET_DELETE_ENTITY'
Access data through navigation
/sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders('4969')/Items
/sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderItems => salesorderitems_get_entityset
Read with navigation path
/sap/opu/odata/sap/ZSALESORDER_001_SRV/SalesOrderHeaderS + Get
=>salesorderheader_get_entityset
/sap/opu/odata/sap/ZSALESORDER_001_SRV/SalesOrderHeaderS('4970')/OrderToItem_nav + Get
=> salesorderitems_get_entityset
/sap/opu/odata/sap/ZSALESORDER_001_SRV/SalesOrderItemS => salesorderitems_get_entityset
Expand Query option :-
/sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders?$expand=Items
salesorderheader_get_entityset => 100
salesorderitems_get_entityset => 7970 ....100 times
/sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders('4970')?$expand=Items
salesorderheader_get_entity => 4970
salesorderitems_get_entityset => one time
If we have implemented this then we have to implement
/IWFND/TRACES
/IWFND/CACHE_CLEANUP
They are automatically available in the framework, no further actions needed by development.
$format
/sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders?$format=json
$expand
/sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders?$expand=Items
$select
/sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders?$select=SalesOrder,SalesOrg,Vtweg&$format=json
$count
/sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders/$count
$links
/sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders('4970')/$links/Items
$value
/sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders('4970')/Bstnk/
/sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders('4970')/Bstnk/$value
Without implementation query option :-
$select :-
/sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders?$select=SalesOrder,Auart&$format=json
$count :-
/sap/opu/odata/sap/ZSALESORDER_001_SRV/SalesOrderHeaders/$count
$link :-
/sap/opu/odata/sap/ZSALESORDER_001_SRV/SalesOrderHeaders('764')/$links/Items
value :-
/sap/opu/odata/sap/ZSALESORDER_001_SRV/SalesOrderHeaders('764')/Auart?$format=json
$value
/sap/opu/odata/sap/ZSALESORDER_001_SRV/SalesOrderHeaders('764')/Auart/$value
Can i get the source code
Sorry I Lost OData series code ....
@@SAPTECHNOMANIAC 🙄