CDS View to Get Billing Document Number and Sales Order Number

[evans_aarons]

Good day!

I would like to ask if there is any available CDS where I can obtain the Billing document number of a specific Sales order. A view where it indicates the specific number of both Sales Order Number & Billing Document Number or Sales Order Number & Invoice Number. I can't seem to find the specific CDS during my own investigation.

Any inputs would be appreciated.

Regards,

Evans Aarons

[AngelaDai]

hi Evans,

Kindly check if cds views below could fulfil your requirements or not.

I_BillingDocumentItem(https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/2485c474abf344b8b25756b2...

I_BillingDocument(https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/116ddcc5a4f244a1a138c4a8...

I_SalesDocument(https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/20fdaf9195e24918ad9b15a9...)

Best regards,

Angela

[evans_aarons]

Hi Angela, Thanks for your input. The issue that we are facing is we need to create a custom CDS View which would give use the value of Orderbacklog Amount i.e Sales Order Amount - Invoiced Amount. Now in order for us to make this possible we need to create a custom CDS view where we can associate 2 to 3 CDS view and this is not possible because I am not able to find any CDS view which has both Sales Order and Billing Document field in One CDS view which would help us to develop the required report. Any suggestions/ideas on this would be appreciated. Regards, Evans