3582860 - Custom view for financial and sales document information - S/4HANA Cloud

In application "Incoming Sales Orders - Flexible Analysis", you are not able to find the financial document information.

 SAP S/4HANA Cloud Public edition

1. Start the application Incoming Sales Orders - Flexible Analysis
2. Run the report
3. Observe, that the field is not fetching any financial document number data

You are not able to find the financial document information, since the query C_SALESORDERITEMQRY doesn't contain the information. 

You need to create your own custom view to fulfill your requirement. There are two important points:

1. The field 'AccountingDocument' in 'I_BillingDocument' contains the financial document number. But note, that accounting document has the additional keys: company code and fiscal year. And there is an association _AccountingDocument, that can be used.
2. The fileds 'SalesDocument' and 'SalesDocumentItem' in 'I_BillingDocumentItem' contains the sales document number information.

The custom view can be started with 'I_BillingDocument', it will be possible to combine financial document and sales document information together.

Fiori - Incoming Sales Orders - Flexible Analysis

financial , document, information, Incoming Sales Orders, Flexible Analysis, C_SALESORDERITEMQRY, query, AccountingDocument, I_BillingDocument, company code, fiscal year, association, _AccountingDocument, SalesDocument, SalesDocumentItem, I_BillingDocumentItem, sales document number, extensibility, custom view , KBA , SD-ANA-2CL , Analytics (Public Cloud) , How To