I_SDDOCUMENTMULTILEVELPROCFLOW
SD Document Multi Level Process Flow
I_SDDOCUMENTMULTILEVELPROCFLOW is a CDS View in S/4HANA. SD Document Multi Level Process Flow. It contains 16 fields. 38 CDS views read from this table.
CDS Views using this table (38)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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 | |
| C_PrecdgSalesOrderItem | view | inner | CONSUMPTION | |
| C_PT_SAFTSlsInvoiceItmRef | view | inner | CONSUMPTION | SAF-T PT Sales Invoice Item References |
| C_PT_SAFTWorkingDocItemRef | view | inner | CONSUMPTION | SAF-T PT WorkingDocument Item References |
| C_RelatedBillingDocumentItem | view | inner | CONSUMPTION | |
| C_SDDocMultiLevelProcFlowDEX | view | from | CONSUMPTION | Data Extraction for Multi-Level Process Flow |
| C_SlsDocReltdBillgDocItm | view | inner | CONSUMPTION | |
| C_SubsqntCreditMemoReqItem | view | inner | CONSUMPTION | |
| C_SubsqntCustomerReturnItem | view | inner | CONSUMPTION | |
| C_SubsqntCustRetDeliveryItem | view | inner | CONSUMPTION | |
| C_SubsqntOutbDeliveryItem | view | inner | CONSUMPTION | |
| C_SubsqntSalesOrder | view | inner | CONSUMPTION | |
| C_SubsqntSalesOrderItem | view | inner | CONSUMPTION | |
| C_SubsqntSOWithoutChargeItem | view | inner | CONSUMPTION | |
| CIC_DOCUMENT_FLOW | view_entity | left_outer | DocumentFlow entity | |
| I_CmplProcessFlowPreceding | view_entity | from | COMPOSITE | |
| 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_JITOutbCallDelivDocRef | view | from | COMPOSITE | Material Document Reference for 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 |
| P_Bprrbsdflow | view | from | BASIC | |
| 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 | |
| P_PAYREQNSONUMBER | view | from | COMPOSITE | |
| P_PL_SAFTGdsMvtBillDocument | view | from | COMPOSITE | |
| P_RFM_SlsOrdPrgrsMntrProcFlow | view | from | COMPOSITE | |
| P_SDDocumentPurchOrdProcFlow | view | from | COMPOSITE | |
| P_VE_StRpReverseSDDocument | view_entity | inner | COMPOSITE | Venezuela StRp Reverse SD Document |
Fields (16)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DocRelationshipUUID | DocRelationshipUUID | 17 |
| KEY | PrecedingDocument | DeliveryDocument,PrecedingDocument,SalesDocument | 21 |
| KEY | PrecedingDocumentCategory | PrecedingDocumentCategory,SDDocumentCategory | 9 |
| KEY | PrecedingDocumentItem | DeliveryDocumentItem,PrecedingDocumentItem,SalesDocumentItem | 17 |
| 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 | |
| MaterialDocumentYear | MaterialDocumentYear | 1 | |
| 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
{
//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,
// Billing Plan related fields
vbfa.fplnr as BillingPlan,
vbfa.fpltr as BillingPlanItem,
_BaseUnit,
_OrderQuantityUnit,
_StatisticsCurrency
}