/A_PurchaseOrder - not able to post multiple line items ( CPI to S4hana Cloud)

[former_member851588]

Hi All,

I am not able to post multiple line items form CPI to S4Hana cloud.

POST <host>/sap/opu/odata/sap/API_PURCHASEORDER_PROCESS_SRV/A_PurchaseOrder

I don't see any issue if we are posting with one line item.

but in case of multiple line items the last line item posted successfully in S4hana.

Regards,

Dogiparthi.

[JulianoRomanato]

Hello pradeep_d001.

How are you? I have excluded the Tag "SAP S/4HANA Cloud" and included the Tag "SAP S/4HANA Cloud Extensibility" for this question, as SAP APIs are related to Extensibility.

Regards.

Juliano Romanato.

[former_member131691]

Hi Dogiparthi

Try with this sample payload having 6 items (reset your master data)

Hope it helps
Kind regards
Brian

POST operation
/sap/opu/odata/sap/API_PURCHASEORDER_PROCESS_SRV/A_PurchaseOrder
content-type application/json

Payload

{

"CompanyCode": "1010",

"PurchaseOrderType": "NB",

"Supplier": "10300001",

"PurchasingOrganization": "1010",

"PurchasingGroup": "001",

"to_PurchaseOrderItem": [

{

"PurchaseOrderItemText": "Multi item test 1",

"Plant": "1010",

"OrderQuantity": "7.000",

"NetPriceAmount": "10.00",

"NetPriceQuantity": "1",

"PurchaseOrderItemCategory": "0",

"AccountAssignmentCategory": "K",

"Material": "TG0011",

"to_AccountAssignment": [

{

"Quantity": "7.000",

"GLAccount": "65008500",

"CostCenter": "10101101"

}

],

"to_ScheduleLine": [

{

"ScheduleLineDeliveryDate": "2022-07-13T00:00:00",

"ScheduleLineOrderQuantity": "7.000"

}

]

},

{

"PurchaseOrderItemText": "Multi item test 1",

"Plant": "1010",

"OrderQuantity": "7.000",

"NetPriceAmount": "10.00",

"NetPriceQuantity": "1",

"PurchaseOrderItemCategory": "0",

"AccountAssignmentCategory": "K",

"Material": "TG0011",

"to_AccountAssignment": [

{

"Quantity": "7.000",

"GLAccount": "65008500",

"CostCenter": "10101101"

}

],

"to_ScheduleLine": [

{

"ScheduleLineDeliveryDate": "2022-07-13T00:00:00",

"ScheduleLineOrderQuantity": "7.000"

}

]

},

{

"PurchaseOrderItemText": "Multi item test 1",

"Plant": "1010",

"OrderQuantity": "7.000",

"NetPriceAmount": "130.00",

"NetPriceQuantity": "1",

"PurchaseOrderItemCategory": "0",

"AccountAssignmentCategory": "K",

"Material": "TG0011",

"to_AccountAssignment": [

{

"Quantity": "7.000",

"GLAccount": "65008500",

"CostCenter": "10101101"

}

],

"to_ScheduleLine": [

{

"ScheduleLineDeliveryDate": "2022-07-13T00:00:00",

"ScheduleLineOrderQuantity": "7.000"

}

]

},

{

"PurchaseOrderItemText": "Multi item test 1",

"Plant": "1010",

"OrderQuantity": "7.000",

"NetPriceAmount": "130.00",

"NetPriceQuantity": "1",

"PurchaseOrderItemCategory": "0",

"AccountAssignmentCategory": "K",

"Material": "TG0011",

"to_AccountAssignment": [

{

"Quantity": "7.000",

"GLAccount": "65008500",

"CostCenter": "10101101"

}

],

"to_ScheduleLine": [

{

"ScheduleLineDeliveryDate": "2022-07-13T00:00:00",

"ScheduleLineOrderQuantity": "7.000"

}

]

},

{

"PurchaseOrderItemText": "Multi item test 1",

"Plant": "1010",

"OrderQuantity": "7.000",

"NetPriceAmount": "130.00",

"NetPriceQuantity": "1",

"PurchaseOrderItemCategory": "0",

"AccountAssignmentCategory": "K",

"Material": "TG0011",

"to_AccountAssignment": [

{

"Quantity": "7.000",

"GLAccount": "65008500",

"CostCenter": "10101101"

}

],

"to_ScheduleLine": [

{

"ScheduleLineDeliveryDate": "2022-07-13T00:00:00",

"ScheduleLineOrderQuantity": "7.000"

}

]

},

{

"PurchaseOrderItemText": "Multi item test 1",

"Plant": "1010",

"OrderQuantity": "7.000",

"NetPriceAmount": "130.00",

"NetPriceQuantity": "1",

"PurchaseOrderItemCategory": "0",

"AccountAssignmentCategory": "K",

"Material": "TG0011",

"to_AccountAssignment": [

{

"Quantity": "7.000",

"GLAccount": "65008500",

"CostCenter": "10101101"

}

],

"to_ScheduleLine": [

{

"ScheduleLineDeliveryDate": "2022-07-13T00:00:00",

"ScheduleLineOrderQuantity": "7.000"

}

]

}

]

}

[former_member851588]

Hi Brain,

i have posted manually via api.sap.com

Try Out | Purchase Order | SAP Business Accelerator Hub

and it is successful. i could see 2 lines for one PO

{
	"PurchaseOrder": "",
	"CompanyCode": "ABcd",
	"PurchaseOrderType": "NB",
	"Supplier": "ABcd",
	"PurchasingOrganization": "ABcd",
	"DocumentCurrency": "GBP",
	"PurchasingGroup": "ABcd",
	"to_PurchaseOrderItem": {
		"results": [
			{
				"PurchaseOrder": "",
				"PurchaseOrderItem": "",
				"PurchaseOrderItemText": "Multi item test 1",
				"ProductType": "2",
				"Plant": "ABcd",
				"OrderQuantity": "1",
				"NetPriceAmount": "10.00",
				"NetPriceQuantity": "1",
				"PurchaseOrderItemCategory": "0",
				"AccountAssignmentCategory": "C",
				"OrderPriceUnit": "EA",
				"PurchaseOrderQuantityUnit": "EA",
				"MaterialGroup": "ABcd",
				"to_AccountAssignment": {
					"results": [
						{
							"PurchaseOrder": "",
							"PurchaseOrderItem": "",
							"AccountAssignmentNumber": "01",
							"ControllingArea": "ABcd",
							"SalesOrderItem": "0030",
							"GLAccount": "ABcd",
							"SalesOrder": "ABcd"
						}
					]
				},
				"to_PurchaseOrderItemNote": {
					"results": [
						{
							"PurchaseOrder": "",
							"PurchaseOrderItem": "",
							"PlainLongText": "LineItem1",
							"TextObjectType": "F01",
							"Language": "EN"
						}
					]
				}
			},
			{
				"PurchaseOrder": "",
				"PurchaseOrderItem": "",
				"PurchaseOrderItemText": "Multi item test 2",
				"ProductType": "2",
				"Plant": "GB13",
				"OrderQuantity": "1",
				"NetPriceAmount": "10.00",
				"NetPriceQuantity": "1",
				"PurchaseOrderItemCategory": "0",
				"AccountAssignmentCategory": "C",
				"OrderPriceUnit": "EA",
				"PurchaseOrderQuantityUnit": "EA",
				"MaterialGroup": "ABcd",
				"to_AccountAssignment": {
					"results": [
						{
							"PurchaseOrder": "",
							"PurchaseOrderItem": "",
							"AccountAssignmentNumber": "01",
							"ControllingArea": "ABcd",
							"SalesOrderItem": "0030",
							"GLAccount": "ABcd",
							"SalesOrder": "ABcd"
						}
					]
				},
				"to_PurchaseOrderItemNote": {
					"results": [
						{
							"PurchaseOrder": "",
							"PurchaseOrderItem": "",
							"PlainLongText": "LineItem2",
							"TextObjectType": "F01",
							"Language": "EN"
						}
					]
				}
			}
		]
	},
	"to_PurchaseOrderNote": {
		"results": [
			{
				"PurchaseOrder": "",
				"TextObjectType": "F01",
				"Language": "EN",
				"PlainLongText": "Header1"
			}
		]
	}
}

However when I do it via CPI, I could see only one line item.

please check the Request and response messages form ODATA Adapter in CPI.

Request and Response xml attached.

odata:CREATE_ENTRY?serviceUri=https://my123456-api.s4hana.ondemand.com:443/sap/opu/odata/sap/API_PURCHASEORDER_PROCESS_SRV&resourcePath=RAW(A_PurchaseOrder)&alias=RAW(Test)&authenticationType=Basic&retrieveAllPages=true&oDataMethod=CREATE_ENTRY&contentType=application/atom+xml∁onentContentType=xml&receiveTimeOut=60000≺oxyType=default&retryOnFailure=false&allowRequestHeaders=false&setErrorResponseBody=true&isKeyAutoGenerated=true&allowResponseHeaders=false&isCSRFEnabled=true&serviceType=HCIOData&allowHttpSuccessPassThrough=true&adapterVersion=1.21.0&validateSystemQueryOption=true&enableTLSSessionReuse=true

Regards,

Dogiparthi