SAP Knowledge Base Article - Public

3568260 - Financial document field not fetching data in the "Incoming Sales Orders - Flexible Analysis" app in SAP S/4HANA Cloud Public Edition

Symptom

While using the "Incoming Sales Orders - Flexible Analysis" app, the field Financial Document is populated as "Not Performed", not fetching any data. The requirement would be to show the financial document number.

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

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

Cause

The "Incoming Sales Orders - Flexible Analysis" app uses the query C_SALESORDERITEMQRY.

In the Query Browser, the label Financial Document is derived from FinDocCreditCheckStatus. The technical information for the field FinDocCreditCheckStatus is as follows:

Status of Credit Check Against Financial Document

Component Type  Data Type
cmpsi                  char(1)  

The field comes from I_SalesDocumentBasic. If the information cannot be seen for the field in the application, it means that the field value is empty in the basic view, as the application displays data directly. And the field Financial Document doesn't represent the financial document number.

Resolution

Refer to the following help documentations. The application does not provide any financial information, so a custom query needs to be built to fulfill the requirement.

Keywords

SAP S/4HANA Cloud Public Edition, Incoming Sales Orders, Flexible Analysis, Query, C_SALESORDERITEMQRY, Query Browser, Label, Financial Document, FinDocCreditCheckStatus,  I_SalesDocumentBasic, Empty, Financial Document Number, Credit Blocked Delivery Document, Analytical, F1249 , KBA , SD-ANA-2CL , Analytics (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions