C_DelivProcFlowOutbDeliv

DDL: C_DELIVPROCFLOWOUTBDELIV SQL: CDLVPROCFLOBDLV Type: view CONSUMPTION

Delivery Process Flow - Node Outbound Delivery

C_DelivProcFlowOutbDeliv is a Consumption CDS View that provides data about "Delivery Process Flow - Node Outbound Delivery" in SAP S/4HANA. It reads from 2 data sources (C_OverallPickingStatusText, I_OutboundDelivery) and exposes 10 fields with key field OutboundDelivery.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
C_OverallPickingStatusText C_OverallPickingStatusText left_outer
I_OutboundDelivery I_OutboundDelivery from

Parameters (1)

NameTypeDefault
P_Language spras

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CDLVPROCFLOBDLV view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Delivery Process Flow - Node Outbound Delivery view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey OutboundDelivery view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery OutboundDelivery
ShippingPoint ShippingPoint
Language StatusText Language
SDDocumentCategory
OverallGoodsMovementStatus OverallGoodsMovementStatus
OverallPickingStatus I_OutboundDelivery OverallPickingStatus
DeliveryDocumentType
ProcessFlowNodeTitle
ProcessFlowNodeShortTitle
_Language StatusText _Language 
@AbapCatalog.sqlViewName: 'CDLVPROCFLOBDLV'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK 
@EndUserText.label: 'Delivery Process Flow - Node Outbound Delivery'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.representativeKey: 'OutboundDelivery'

define view C_DelivProcFlowOutbDeliv 

with parameters @Consumption.hidden: true
                @Environment.systemField: #SYSTEM_LANGUAGE
                P_Language              :spras
                
as select from I_OutboundDelivery 

    left outer join C_OverallPickingStatusText( P_Language: :P_Language ) as StatusText 
      on I_OutboundDelivery.OverallPickingStatus = StatusText.OverallPickingStatus   
       

{
    //Key

    key OutboundDelivery,
    
    ShippingPoint,
      
    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_Language'
    StatusText.Language,
  
    //Category

    'J' as SDDocumentCategory,

    //Status

    OverallGoodsMovementStatus,
    
   //Attribute 1   

    case when OverallGoodsMovementStatus = 'C'
      then cast(ActualGoodsMovementDate as wadat)
      else cast(PlannedGoodsIssueDate   as wadat)
    end as GoodsIssueDate,
    
    //Attribute 2

    I_OutboundDelivery.OverallPickingStatus,
    
    case when OverallGoodsMovementStatus = 'C'
      then cast('' as bezei)
      else StatusText.OverallPickingStatusDesc           
    end as OverallPickingStatusDesc,
    

   I_OutboundDelivery._DeliveryDocumentType.DeliveryDocumentType,

   I_OutboundDelivery._DeliveryDocumentType._Text[1: Language =  :P_Language].DeliveryDocumentTypeName as ProcessFlowNodeTitle,
   
   I_OutboundDelivery._DeliveryDocumentType._Text[1: Language =  :P_Language].DeliveryDocumentTypeName as ProcessFlowNodeShortTitle,
  
       
    //Associations

    StatusText._Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_OVERALLPICKINGSTATUSTEXT",
"I_DELIVERYDOCUMENTTYPE",
"I_DELIVERYDOCUMENTTYPETEXT",
"I_OUTBOUNDDELIVERY"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[
"C_OVERALLPICKINGSTATUSTEXT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More