C_SDDocMultiLevelProcFlowDEX

DDL: C_SDDOCMULTILEVELPROCFLOWDEX SQL: CSDMLPROCFLOWDEX Type: view CONSUMPTION
27 Fields 1 Data Sources

Data Extraction for Multi-Level Process Flow

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.

SAP Help Documentation

CategorySales Monitoring and Analytics
Data CategoryFact
Corresponding DataSource2CCSDMLPROCFLOWDEX
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
This CDS view is app-independent, and is available for all external consumers. To enable an SAP BW/4HANA system to extract data from your SAP S/4HANA system, you first need to have created a communication user and set up a communication arrangement for that user. For details, see Extracting Data Through CDS Views to SAP BW/4HANA .

Data Extraction
Data extraction type Full (physical deletions are possible in source tables) Delta (change data capture) 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 .

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentMultiLevelProcFlow I_SDDocumentMultiLevelProcFlow from

Annotations (17)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY DocRelationshipUUID DocRelationshipUUID SM Doc Rel UUID
PrecedingDocument PrecedingDocument SD Document
PrecedingDocumentItem PrecedingDocumentItem Item
PrecedingDocumentCategory PrecedingDocumentCategory Prec.Doc.Categ.
SubsequentDocument SubsequentDocument SD Sched. Agmt
SubsequentDocumentItem SubsequentDocumentItem Subsequent Item
SubsequentDocumentCategory SubsequentDocumentCategory Subs.Doc.Categ.
ProcessFlowLevel ProcessFlowLevel Level Number
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
QuantityInBaseUnit QuantityInBaseUnit Quantity
RefQuantityInOrdQtyUnitAsFloat RefQuantityInOrdQtyUnitAsFloat Quantity
RefQuantityInBaseUnitAsFloat RefQuantityInBaseUnitAsFloat Quantity
BaseUnit BaseUnit Unit of Measure
OrderQuantityUnit OrderQuantityUnit Sales Unit
SDFulfillmentCalculationRule SDFulfillmentCalculationRule Pos./Negative
NetAmount NetAmount Stated Amount
StatisticsCurrency StatisticsCurrency Transaction Currency
TransferOrderInWrhsMgmtIsConfd TransferOrderInWrhsMgmtIsConfd Confirmation ID
WarehouseNumber WarehouseNumber Whse Number
MaterialDocumentYear MaterialDocumentYear Material Document Year
BillingPlan BillingPlan Bill. Plan No.
BillingPlanItem BillingPlanItem Item
_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