C_SDDocMultiLevelProcFlowDEX
Data Extraction for Multi-Level Process Flow
C_SDDocMultiLevelProcFlowDEX (Consumption)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.
Sales Document · Sales
C_SDDocMultiLevelProcFlowDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for Multi-Level Process Flow" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentMultiLevelProcFlow) and exposes 27 fields with key field DocRelationshipUUID. Part of development package VDM_SD_DEX.
SAP Help Documentation
| Category | Sales Documents |
|---|---|
| Data Category | Consumption |
| Status | New |
| Corresponding DataSource | 2CCSDMLPROCFLOWDEX |
Purpose
This CDS view shows the relationships between your SD documents and allows you to extract this data to SAP Business Warehouse (SAP BW) or other external systems. It is based on the CDS view SD Document Multi-Level Process Flow ( I_SDDocumentMultiLevelProcFlow ). For further details, for example, attributes, and measures, see the link to the documentation for the CDS view SD Document Multi-Level Process Flow below. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .
Prerequisites
To enable an SAP BW/4HANA system to extract data from your SAP S/4HANA Cloud Public Edition system, you need to create a communication user and set up a communication arrangement for that user. For details, see Extracting Data Through CDS Views to SAP BW/4HANA .
SAP Business Warehouse (SAP BW) Extraction
Data extraction type Full (physical deletions are possible in source tables) Delta-enabled with Change Data Capture (CDC) Corresponding DataSource (Extractor) Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .
This CDS view shows the relationships between your SD documents and allows you to extract this data to SAP Business Warehouse (SAP BW) or other external systems. It is based on the CDS view SD Document Multi-Level Process Flow ( I_SDDocumentMultiLevelProcFlow ). For further details, for example, attributes, and measures, see the link to the documentation for the CDS view SD Document Multi-Level Process Flow below. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .
Prerequisites
To enable an SAP BW/4HANA system to extract data from your SAP S/4HANA Cloud Public Edition system, you need to create a communication user and set up a communication arrangement for that user. For details, see Extracting Data Through CDS Views to SAP BW/4HANA .
SAP Business Warehouse (SAP BW) Extraction
Data extraction type Full (physical deletions are possible in source tables) Delta-enabled with Change Data Capture (CDC) Corresponding DataSource (Extractor) Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .
SAP API Hub
| Category | Consumption |
|---|---|
| State | C1 |
| Line of Business | Sales |
| Application Component | SD-ANA-2CL |
| Capabilities | Data Source for Data Extraction |
| Extensible (Key User) | No |
| Extensible (Developer) | No |
| Release State (Key User) | Released |
| Release State (Developer) | Released |
| Package | Sales for SAP S/4HANA Cloud Public Edition |
| Description | <p>This CDS view shows the relationships between your SD documents and allows you to extract this data to SAP Business Warehouse (SAP BW) or other external systems. It is based on the CDS view SD Document Multi-Level Process Flow(I_SDDocumentMultiLevelProcFlow). </p> <p>For further details, for example, attributes, and measures, see the link to the documentation for the CDS view SD Document Multi-Level Process Flow below. </p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p> |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SDDocumentMultiLevelProcFlow | I_SDDocumentMultiLevelProcFlow | from |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.representativeKey | DocRelationshipUUID | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.sapObjectNodeType.name | SalesDocument | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| Metadata.allowExtensions | true | view | |
| ObjectModel.modelingPattern | #NONE | view | |
| Analytics.dataCategory | #FACT | view | |
| Analytics.dataExtraction.enabled | true | view | |
| AbapCatalog.sqlViewName | CSDMLPROCFLOWDEX | view | |
| EndUserText.label | Data Extraction for Multi-Level Process Flow | view |
Fields (27)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | DocRelationshipUUID | DocRelationshipUUID | SD Unique Document Relationship Identification | |
| PrecedingDocument | PrecedingDocument | Preceding sales and distribution document | ||
| PrecedingDocumentItem | PrecedingDocumentItem | Preceding Item of an SD Document | ||
| PrecedingDocumentCategory | PrecedingDocumentCategory | SD Document Category of Reference SD Document | ||
| SubsequentDocument | SubsequentDocument | Subsequent Sales and Distribution Document | ||
| SubsequentDocumentItem | SubsequentDocumentItem | Subsequent Item of an SD Document | ||
| SubsequentDocumentCategory | SubsequentDocumentCategory | Document Category of Subsequent Document | ||
| ProcessFlowLevel | ProcessFlowLevel | Level of the document flow record | ||
| CreationDate | CreationDate | Record Creation Date | ||
| CreationTime | CreationTime | Time of Change | ||
| LastChangeDate | LastChangeDate | Last Changed On | ||
| QuantityInBaseUnit | QuantityInBaseUnit | Referenced quantity in base unit of measure | ||
| RefQuantityInOrdQtyUnitAsFloat | RefQuantityInOrdQtyUnitAsFloat | Referenced quantity in sales unit (float) | ||
| RefQuantityInBaseUnitAsFloat | RefQuantityInBaseUnitAsFloat | Referenced quantity in base unit of measure (float) | ||
| BaseUnit | BaseUnit | Base Unit of Measure | ||
| OrderQuantityUnit | OrderQuantityUnit | Sales Unit | ||
| SDFulfillmentCalculationRule | SDFulfillmentCalculationRule | Quantity is calculated positively, negatively or not at all | ||
| NetAmount | NetAmount | Reference Value | ||
| StatisticsCurrency | StatisticsCurrency | Transaction Currency | ||
| TransferOrderInWrhsMgmtIsConfd | TransferOrderInWrhsMgmtIsConfd | ID: MM-WM Transfer Order Confirmed | ||
| WarehouseNumber | WarehouseNumber | Warehouse Number / Warehouse Complex | ||
| MaterialDocumentYear | MaterialDocumentYear | Material Document Year | ||
| BillingPlan | BillingPlan | Billing Plan Number / Invoicing Plan Number | ||
| BillingPlanItem | BillingPlanItem | Item for billing plan/invoice plan/payment cards | ||
| _BaseUnit | _BaseUnit | |||
| _OrderQuantityUnit | _OrderQuantityUnit | |||
| _StatisticsCurrency | _StatisticsCurrency |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view C_SDDocMultiLevelProcFlowDEX.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CSDMLPROCFLOWDEX
CREATE VIEW C_SDDocMultiLevelProcFlowDEX AS
SELECT
DocRelationshipUUID,
PrecedingDocument,
PrecedingDocumentItem,
PrecedingDocumentCategory,
SubsequentDocument,
SubsequentDocumentItem,
SubsequentDocumentCategory,
ProcessFlowLevel,
CreationDate,
CreationTime,
LastChangeDate,
QuantityInBaseUnit,
RefQuantityInOrdQtyUnitAsFloat,
RefQuantityInBaseUnitAsFloat,
BaseUnit,
OrderQuantityUnit,
SDFulfillmentCalculationRule,
NetAmount,
StatisticsCurrency,
TransferOrderInWrhsMgmtIsConfd,
WarehouseNumber,
MaterialDocumentYear,
BillingPlan,
BillingPlanItem
FROM I_SDDocumentMultiLevelProcFlow
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA