I_SDDOCUMENTMULTILEVELPROCFLOW

CDS View

SD Document Multi Level Process Flow

I_SDDOCUMENTMULTILEVELPROCFLOW is a CDS View in S/4HANA. SD Document Multi Level Process Flow. It contains 15 fields. 38 CDS views read from this table.

Used by 38 CDS view(s) 15 fields

CDS Views using this table (38)

ViewTypeJoinVDMDescription
A_CmplSubsqntProcessFlow view_entity from CONSUMPTION CMH Subsequent Documents entity
A_SubsqntBillgDocForSelfBillg view inner COMPOSITE Subsequent Billing Document
C_InhRepairProcessFlow view inner CONSUMPTION Transaction History of In-House Repair Item
C_PrecdgCustomerReturnItem view inner CONSUMPTION Preceding Customer Return Item
C_PrecdgSalesOrderItem view inner CONSUMPTION Preceding Sales Order Item
C_PT_SAFTSlsInvoiceItmRef view inner CONSUMPTION SAF-T PT Sales Invoice Item References
C_PT_SAFTSlsItemRef view_entity inner CONSUMPTION Sales Invoices Line References - Cube
C_PT_SAFTWorkingDocItemRef view inner CONSUMPTION SAF-T PT WorkingDocument Item References
C_RelatedBillingDocumentItem view inner CONSUMPTION Subsequent Billing Document Item
C_SDDocMultiLevelProcFlowDEX view from CONSUMPTION Data Extraction for Multi-Level Process Flow
C_SlsDocReltdBillgDocItm view inner CONSUMPTION Related Billing Document for Sales Document
C_SubsqntCreditMemoReqItem view inner CONSUMPTION Subsequent Sales Order Without Charge Item
C_SubsqntCustomerReturnItem view inner CONSUMPTION Subsequent Customer Return Item
C_SubsqntCustRetDeliveryItem view inner CONSUMPTION Subsequent Outbound Delivery Item
C_SubsqntOutbDeliveryItem view inner CONSUMPTION Subsequent Outbound Delivery Item
C_SubsqntSalesOrder view inner CONSUMPTION Subsequent Sales Order
C_SubsqntSalesOrderItem view inner CONSUMPTION Subsequent Sales Order Item
C_SubsqntSOWithoutChargeItem view inner CONSUMPTION Subsequent Sales Order Without Charge Item
I_CmplProcessFlowPreceding view_entity from COMPOSITE Hierarchy data provider for CMH
I_CmplProcessFlowSubsequent view_entity from COMPOSITE Process Flow entity for subsequent docs
I_ComplaintProcessFlowBasic view_entity from COMPOSITE Complaint Process Flow StatusBasic
I_ExcessRqmtAcctAssgdAggrgdQty view from BASIC Agg Qty of Purch Ord created per Acct Assgd Sales Doc Item
I_PT_SDFlowInvoiceAsDelivery view from COMPOSITE Sales Process flow Invoice as delivery
I_RFM_SlsContrDocFlowWthSign view from COMPOSITE Sale Contract signed Qty
I_SalesDocItmPrecdgProcFlow view_entity from COMPOSITE Preceding Process Flow of Sales Doc Item
I_SalesDocItmSubsqntProcFlow view_entity from COMPOSITE Subsequent Process Flow of Sls Doc Item
I_SalesDocumentPrecdgProcFlow view_entity from COMPOSITE Preceding Process Flow of Sales Document
I_SalesDocumentSubsqntProcFlow view_entity from COMPOSITE Subsequent Process Flow of Sales Doc
I_SDDocumentProcessFlow view from BASIC SD Document Process Flow
I_VE_StRpBPAndWhldgTaxItem view left_outer COMPOSITE Venezuela Business Partner VAT and Withholding Tax Items
P_Bprrbsdflow view from BASIC RRB SD Document Flow
P_BusSolnOrdSlsOrdFlwLvl6 view inner CONSUMPTION Solution Order Sales Order Flow: Level 6
P_BusSolnOrdSlsOrdFlwLvl71 view inner CONSUMPTION Solution Order Sales Order Flow: Level 71
P_GteeMBillgItmsRRBBilled view inner COMPOSITE GM Billing - Resource Related Billing - Billed
P_PAYREQNSONUMBER view from COMPOSITE Private view for purchasing order lines
P_PL_SAFTGdsMvtBillDocument view from COMPOSITE SAFT PL Goods Movement Billing Document
P_RFM_SlsOrdPrgrsMntrProcFlow view from COMPOSITE Sales Order Process Flow
P_SDDocumentPurchOrdProcFlow view from COMPOSITE Process FLow for Sales Order and Purchase Order Relationship

Fields (15)

KeyField CDS FieldsUsed in Views
KEY DocRelationshipUUID DocRelationshipUUID 17
KEY PrecedingDocument PrecedingDocument,SalesDocument 20
KEY PrecedingDocumentCategory PrecedingDocumentCategory,SDDocumentCategory 9
KEY PrecedingDocumentItem PrecedingDocumentItem,SalesDocumentItem 16
KEY SubsequentDocument SalesDocument,SubsequentDocument 14
KEY SubsequentDocumentCategory SDDocumentCategory,SubsequentDocumentCategory 9
KEY SubsequentDocumentItem SalesDocumentItem,SubsequentDocumentItem 11
BaseUnit BaseUnit 1
CreationDate CreationDate 5
CreationTime CreationTime 5
LastChangeDate LastChangeDate 5
ProcessFlowLevel ProcessFlowLevel 6
QuantityInBaseUnit QuantityInBaseUnit 1
SDFulfillmentCalculationRule SDFulfillmentCalculationRule 1
StatisticsCurrency StatisticsCurrency 1 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
    representativeKey: 'DocRelationshipUUID',
    usageType: {
        dataClass: #TRANSACTIONAL,
        serviceQuality: #B,
        sizeCategory: #XL
    },
    supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ],
    modelingPattern: [ #ANALYTICAL_DIMENSION ]
}
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'SD Document Multi Level Process Flow'
@Analytics:{dataCategory:#DIMENSION}
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AbapCatalog.sqlViewName: 'ISDDOCMLPROCFLOW'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@Metadata.allowExtensions:true


define view I_SDDocumentMultiLevelProcFlow
  as select from vbfa
  association [0..1] to I_UnitOfMeasure     as _BaseUnit           on $projection.BaseUnit = _BaseUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure     as _OrderQuantityUnit  on $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure
  association [0..1] to I_Currency          as _StatisticsCurrency on $projection.StatisticsCurrency = _StatisticsCurrency.Currency
  association [0..1] to I_GoodsMovementType as _GoodsMovementType  on $projection.GoodsMovementType = _GoodsMovementType.GoodsMovementType

{
      //Key

  key vbfa.ruuid                                                   as  DocRelationshipUUID,

      //Preceding

      vbfa.vbelv                                                   as  PrecedingDocument,
      vbfa.posnv                                                   as  PrecedingDocumentItem,
      vbfa.vbtyp_v                                                 as  PrecedingDocumentCategory,

      //Subsequent

      vbfa.vbeln                                                   as  SubsequentDocument,
      vbfa.posnn                                                   as  SubsequentDocumentItem,
      vbfa.vbtyp_n                                                 as  SubsequentDocumentCategory,

      //Process Flow Level

      vbfa.stufe                                                   as  ProcessFlowLevel,

      //Admin

      @Semantics.systemDate.createdAt: true
      vbfa.erdat                                                   as  CreationDate,
      vbfa.erzet                                                   as  CreationTime,
      @Semantics.systemDate.lastChangedAt: true
      vbfa.aedat                                                   as  LastChangeDate,

      //Quantity of subsequent document

      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      vbfa.rfmng                                                   as  QuantityInBaseUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      vbfa.rfmng_flo                                               as  RefQuantityInOrdQtyUnitAsFloat,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      vbfa.rfmng_flt                                               as  RefQuantityInBaseUnitAsFloat,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_BaseUnit'
      vbfa.meins                                                   as  BaseUnit,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_OrderQuantityUnit'
      vbfa.vrkme                                                   as  OrderQuantityUnit,
      vbfa.plmin                                                   as  SDFulfillmentCalculationRule,

      //Pricing of subsequent document

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

      //Pick Pack Load

      vbfa.taqui                                                   as  TransferOrderInWrhsMgmtIsConfd,

      // Delivery related fields

      vbfa.lgnum                                                   as  WarehouseNumber,
      vbfa.mjahr                                                   as  MaterialDocumentYear,
      @ObjectModel.foreignKey.association: '_GoodsMovementType'
      vbfa.bwart                                                   as  GoodsMovementType,

      // Billing Plan related fields

      vbfa.fplnr                                                   as  BillingPlan,
      vbfa.fpltr                                                   as  BillingPlanItem,

      _BaseUnit,
      _OrderQuantityUnit,
      _StatisticsCurrency,
      _GoodsMovementType
}

Learn More