P_LogcDocDelivery

DDL: P_LOGCDOCDELIVERY Type: view_entity CONSUMPTION Package: EHDGM_CNS_MARKINGS_AND_LABELS

Log Doc - Delivery

P_LogcDocDelivery is a Consumption CDS View that provides data about "Log Doc - Delivery" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 6 fields with key field DeliveryDocument. Part of development package EHDGM_CNS_MARKINGS_AND_LABELS.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument I_DeliveryDocument from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument
ProdCmplncLogsDocumentCategory
ShippingPoint ShippingPoint
SalesOrganization SalesOrganization
ShippingType ShippingType
CompanyCode _SalesOrganization CompanyCode
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: {
  private: true,
  viewType: #CONSUMPTION
}
define view entity P_LogcDocDelivery
  as select from I_DeliveryDocument

{
  key DeliveryDocument,

      // map to the defined logistic document categories of pc if_ehfnd_logistic_comn_c

      cast ('LF' as ehfnd_log_doc_category) as ProdCmplncLogsDocumentCategory, // Outbound Delivery (EHFND_LOG_DOC_CATEGORY)

      //      cast (

      //          case

      //            when PurchasingDocumentCategory = 'J'

      //              then 'LF' // Outbound Delivery (EHFND_LOG_DOC_CATEGORY)

      //          end as ehfnd_log_doc_category) as ProdCmplncLogsDocumentCategory,


      //Needed for Authorization check

      @ObjectModel.readOnly:true
      @Consumption.hidden: true
      ShippingPoint,
      SalesOrganization,
      ShippingType ,
      @ObjectModel.readOnly:true
      @Consumption.hidden: true
      _SalesOrganization.CompanyCode

}
where
    SDDocumentCategory          =  'J' // if_ehfnd_sd_integration_c=>gc_vbtypl-outbound_delivery

  // filter blocked logistic document

//  and(

//    OverallDangerousGoodsStatus <> 'D' // dom_total_dgsta_le - Blocked – Dangerous Goods Transport Forbidden

//  )