Skip to Content
0

SAP HANA XS - Issue with $Batch(Unable to Insert the data into tables and not able to debug).

Mar 28, 2017 at 12:31 PM

35

avatar image
Former Member

Hi,

I am using $batch option to insert the multiple records into multiple tables (like Header and Item).I am running the service from POSTMAN client,the status is showing as 202 but no entries created in tables and not triggering in debug mode from postman client.

Can you please help and suggest how we can proceed.

Find the attachment for $batch payload.

Here is the requirement:

I need your suggestion on the below requirement.

We have three tables with common key ‘PURCHASEORDERID’, created association between these three and we will get the data (Header, Item and ItmMat) from UI at one shot (submit the data in one payload).

Now that data need to be process and insert into respective tables (we will have multiple records in Item and ItmMat). Can you please suggest how to proceed? and share any example if you have.

Tables:

"workshop.exercises.g001::PurchaseOrder.Header"

"workshop.exercises.g001::PurchaseOrder.Item"

"workshop.exercises.g001::PurchaseOrder.ItmMat"

Example:

Header-

PURCHASEORDERID HISTORY.CREATEDBY CURRENCY GROSSAMOUNT NETAMOUNT TAXAMOUNT 300000001 USHI EUR 345 231 23 300000002 USHI EUR 678 525 45

Item-

PURCHASEORDERID PURCHASEORDERITEM QUANTITY PRODUCT CURRENCY GROSSAMOUNT NETAMOUNT TAXAMOUNT 300000001 10 2 EUR 567 231 23 300000002 20 5 EUR 987 525 45

ItmMat-

PURCHASEORDERID ITEM MATERIAL QUANTITY PRODUCT CURRENCY GROSSAMOUNT NETAMOUNT TAXAMOUNT 300000001 10 9076521 4 EUR 567 231 23 300000002 20 9076523 3 EUR 987 525 45

Thanks,batch-postman.txt

10 |10000 characters needed characters left characters exceeded
Former Member

Hi Shadow

I am also facing same problem 202 accept & unable debug from postman.

Do you have any idea to resolved the issue

can you please response to how to resolved 202 accept

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers