C_SDDocMultiLevelProcFlowDEX

DDL: C_SDDOCMULTILEVELPROCFLOWDEX SQL: CSDMLPROCFLOWDEX Type: view CONSUMPTION

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.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentMultiLevelProcFlow I_SDDocumentMultiLevelProcFlow from

Annotations (16)

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
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
PrecedingDocument PrecedingDocument
PrecedingDocumentItem PrecedingDocumentItem
PrecedingDocumentCategory PrecedingDocumentCategory
SubsequentDocument SubsequentDocument
SubsequentDocumentItem SubsequentDocumentItem
SubsequentDocumentCategory SubsequentDocumentCategory
ProcessFlowLevel ProcessFlowLevel
CreationDate CreationDate
CreationTime CreationTime
LastChangeDate LastChangeDate
QuantityInBaseUnit QuantityInBaseUnit
RefQuantityInOrdQtyUnitAsFloat RefQuantityInOrdQtyUnitAsFloat
RefQuantityInBaseUnitAsFloat RefQuantityInBaseUnitAsFloat
BaseUnit BaseUnit
OrderQuantityUnit OrderQuantityUnit
SDFulfillmentCalculationRule SDFulfillmentCalculationRule
NetAmount NetAmount
StatisticsCurrency StatisticsCurrency
TransferOrderInWrhsMgmtIsConfd TransferOrderInWrhsMgmtIsConfd
WarehouseNumber WarehouseNumber
MaterialDocumentYear MaterialDocumentYear
BillingPlan BillingPlan
BillingPlanItem BillingPlanItem
_BaseUnit _BaseUnit
_OrderQuantityUnit _OrderQuantityUnit
_StatisticsCurrency _StatisticsCurrency 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'DocRelationshipUUID'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@Metadata.allowExtensions:true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities:  [ #EXTRACTION_DATA_SOURCE ]

@Analytics: {
    dataCategory: #FACT,
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
            mapping:[
                {
                    table: 'vbfa', role: #MAIN,
                    viewElement: ['DocRelationshipUUID'],
                    tableElement: ['ruuid']
                }               
            ]
        }
    }
 }
 
@AbapCatalog.sqlViewName: 'CSDMLPROCFLOWDEX'
@EndUserText.label: 'Data Extraction for Multi-Level Process Flow'




define view C_SDDocMultiLevelProcFlowDEX
    as select from I_SDDocumentMultiLevelProcFlow
 
{
      //Key

  key  DocRelationshipUUID,

      //Preceding

      PrecedingDocument,
      PrecedingDocumentItem,
      PrecedingDocumentCategory,

      //Subsequent

      SubsequentDocument,
      SubsequentDocumentItem,
      SubsequentDocumentCategory,

      //Process Flow Level

      ProcessFlowLevel,

      //Admin

      @Semantics.systemDate.createdAt: true
      CreationDate,
      CreationTime,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,

      //Quantity of subsequent document

      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      QuantityInBaseUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      RefQuantityInOrdQtyUnitAsFloat,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      RefQuantityInBaseUnitAsFloat,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_BaseUnit'
      BaseUnit,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_OrderQuantityUnit'
      OrderQuantityUnit,
      SDFulfillmentCalculationRule,

      //Pricing of subsequent document

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'StatisticsCurrency'
      NetAmount,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_StatisticsCurrency'
      StatisticsCurrency,

      //Pick Pack Load

      TransferOrderInWrhsMgmtIsConfd,

      // Delivery related fields

      WarehouseNumber,
      MaterialDocumentYear,

      // Billing Plan related fields

      BillingPlan,
      BillingPlanItem,

      _BaseUnit,
      _OrderQuantityUnit,
      _StatisticsCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SDDOCUMENTMULTILEVELPROCFLOW"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_SDDOCUMENTMULTILEVELPROCFLOW"
],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More