P_DELIVERYPROCFLOWTRANSFORD

CDS View

Delivery Process Flow WM Transfer Order

P_DELIVERYPROCFLOWTRANSFORD is a CDS View in S/4HANA. Delivery Process Flow WM Transfer Order. It contains 7 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 7 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_DeliveryProcFlow view inner CONSUMPTION Delivery Process Flow
P_DelivProcFlowLatestConfDate view from COMPOSITE Latest Warehouse Transfer Order Confirmation Date
P_DelivProcFlowLatestTransfOrd view from COMPOSITE Latest Warehouse Transfer Order
P_DlvNodesForInbDelivProcFlow view inner COMPOSITE
P_InbDelivProcFlowChildren view inner COMPOSITE Inbound Delivery Process Flow Successors
P_OutbDelivProcFlowRelated view inner CONSUMPTION Outbound Delivery Process Flow Predecessor and Successors

Fields (7)

KeyField CDS FieldsUsed in Views
KEY DeliveryDocument DeliveryDocument,InboundDelivery 3
KEY PrecedingDocument PrecedingDocument 4
KEY PrecedingDocumentCategory PrecedingDocumentCategory,SDDocumentCategory 4
KEY SubsequentDocument SubsequentDocument 4
KEY SubsequentDocumentCategory SubsequentDocumentCategory 1
WarehouseNumber WarehouseNumber 4
WrhsMgmtTransferOrder WrhsMgmtTransferOrder 4 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Delivery Process Flow WM Transfer Order'
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PDLVFLOWWMTO'

// Non-cancelled Warehouse Transfer Order

define view P_DeliveryProcFlowTransfOrd as 
  select distinct from I_SDDocumentProcessFlow as Flow // Successor WM Transfer Order

  inner join I_WrhsMgmtTransferOrder
    on  I_WrhsMgmtTransferOrder.WrhsMgmtTransferOrder = Flow.SubsequentDocument
    and I_WrhsMgmtTransferOrder.WarehouseNumber       = Flow.WarehouseNumber
    
  association [1..1] to I_DeliveryDocument as _DeliveryDocument on $projection.DeliveryDocument = _DeliveryDocument.DeliveryDocument
      
{
  key cast(Flow.PrecedingDocument as vbeln_vl) as DeliveryDocument,
  key Flow.PrecedingDocument,
  key Flow.PrecedingDocumentCategory,
  key Flow.SubsequentDocument,
  key Flow.SubsequentDocumentCategory,  
  
  I_WrhsMgmtTransferOrder.WarehouseNumber,
  I_WrhsMgmtTransferOrder.WrhsMgmtTransferOrder,
  I_WrhsMgmtTransferOrder.TransferOrderInWrhsMgmtIsConfd,
  I_WrhsMgmtTransferOrder.WrhsMgmtTransfOrdConfDate,
  
  _DeliveryDocument
} 
  where Flow.SubsequentDocumentCategory = 'Q'  -- WM Transfer Order
    and ( I_WrhsMgmtTransferOrder._WrhsMgmtTransfOrdCanclnSts.TransfOrdInWrhsMgmtIsCanceled = '' or
          I_WrhsMgmtTransferOrder._WrhsMgmtTransfOrdCanclnSts.TransfOrdInWrhsMgmtIsCanceled is null )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SDDOCUMENTPROCESSFLOW",
"I_WRHSMGMTTRANSFERORDER",
"I_WRHSMGMTTRANSFORDCANCLNSTS"
],
"ASSOCIATED":
[
"I_DELIVERYDOCUMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More