3621002 - Missing Sales Orders in CDS View I_SALESORDER Despite Successful Creation in SAP S/4HANA Cloud Public Edition

Certain sales orders that are successfully created in the system are not visible in the CDS view I_SALESORDER, even though they exist.

SAP S/4HANA Cloud Public Edition

1. Create multiple sales orders.
2. Check the standard CDS view I_SALESORDER to see if all created sales orders are visible.

The standard CDS view I_SALESORDER has a hardcoded filter that restricts the results to Sales Document Category = 'C' which includes only standard sales orders (e.g., type OR). The missing orders (e.g., of type CBFD) fall under category 'I', which are intentionally excluded by design.

1. Option 1: Use CDS View I_SALESDOCUMENT:
   • This broader CDS view includes all sales document categories, including both C, I, and others.
   • Refer to: Sales Document Help Portal
   • This will allow retrieval of all sales order types without the limitation present in I_SALESORDER.
2. Option 2: Create a Custom CDS View:
   • Build a custom CDS view on top of I_SALESDOCUMENT or directly on VBAK, with filtering and fields tailored to specific reporting needs.
   • Refer to: SAP Help – Create Custom CDS Views
   • This option provides full control to include/exclude any document types or fields relevant to business requirements but will require consulting: SAP Note 2706322 – What is Support vs. What is Consulting.

• Refer to: Sales Document Category Community Answer
• Refer to: Sales Order Document Category Community Answer
• Refer to: CDS Views for Sales Help Portal
• Refer to: Sales Document Help Portal

SAP S/4HANA Cloud Public Edition, Public Cloud, missing sales orders, cds view, I_SALESORDER, I_SALESDOCUMENT, SAP S/4HANA Cloud, sales document category, custom cds view, VBAK, sales order types, filtering, reporting needs , KBA , SD-SLS-SO-2CL , Sales Orders (Public Cloud) , Problem