how to get OpenItem (Reference to Items) information for BankPaymentAdvice

[SAPSupport]

Hi,

We want to know how to get OpenItem (Reference to Items) information for BankPaymentAdvice in SAP Cloud Applications Studio?

We checked the corresponding BusinessObject PaymentAdvice in the Repository Explorer and did not find the corresponding node.

Thanks!

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

The information of the Referenced Items would be in PaymentExplanationPaymentExplanation assoication. The PaymentExplanation holds the totals and the associated items store the details of the referenced items. They can use Payment Reference/Invoice References to match the items to invoices already existing in the system. 

Open the PaymentAdvice and note the UUID of the Advice

Use the Query QueryByElements of the BO DuePayment and load the Payment Advice UUID into the field PaymentReceivingBusinessTransactionDocumentReference/UUID/content.

From this Due Payment instance navigate by association to DueClearingExplanationItem (one instance for each invoice in the Advice). In this node, note the ClearedTradeReceivablesPayablesRegisterItemUUID.

Finally, load the BO TradeReceivablesPayablesRegister, node ItemOverview. Use the query QueryByElements and use the ClearedTradeReceivablesPayablesRegisterItemUUID value in the field UUID. This should show the Item elements.

[NicoLiang · Accepted solution]

Based on the BO and Node you provide, we try to build custom API for external systems to query. But both the WebService in the PDI or OData Service, BO TradeReceivablesPayablesRegister can not find node ItemOverview. Please help check the reason for this.