C_TransportationOrderEDP

DDL: C_TRANSPORTATIONORDEREDP Type: view_entity CONSUMPTION Package: CLTM_TOR_PRINTING

Transportation Order Email Data Provider

C_TransportationOrderEDP is a Consumption CDS View that provides data about "Transportation Order Email Data Provider" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrder_2) and exposes 17 fields with key field TransportationOrderUUID. It has 2 associations to related views. Part of development package CLTM_TOR_PRINTING.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrder_2 TransportationOrder from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Address_2 _ShipperAddress $projection.ShipperNormalizedAddressID = _ShipperAddress.AddressID and _ShipperAddress.AddressPersonID = ' ' and _ShipperAddress.AddressRepresentationCode = ' '
[1] E_TransportationOrder _Extension $projection.TransportationOrderUUID = _Extension.TransportationOrderUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Transportation Order Email Data Provider view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.modelingPattern #OUTPUT_EMAIL_DATA_PROVIDER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderUUID I_TransportationOrder_2 TransportationOrderUUID
TransportationOrder I_TransportationOrder_2 TransportationOrder
TransportationOrderCatDesc
TranspShipperFullName _ShipperAddress AddresseeFullName
TranspShipperCityName _ShipperAddress CityName
TranspShipperPostalCode _ShipperAddress PostalCode
TranspShipperStreetName _ShipperAddress StreetName
TranspShipperHouseNumber _ShipperAddress HouseNumber
ShipperCountry _ShipperAddress Country
ShipperRegion _ShipperAddress Region
ShipperNormalizedAddressID ShipperAddressID AddressID
TransportationOrderCategory I_TransportationOrder_2 TransportationOrderCategory
TransportationOrderType I_TransportationOrder_2 TransportationOrderType
TranspPurgOrg I_TransportationOrder_2 TranspPurgOrg
TranspPurgGroup I_TransportationOrder_2 TranspPurgGroup
TranspOrdResponsiblePerson I_TransportationOrder_2 TranspOrdResponsiblePerson
TransportationMode I_TransportationOrder_2 TransportationMode 
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl: {
                  authorizationCheck: #MANDATORY,
                  personalData.blocking: #('TRANSACTIONAL_DATA')
                 }

@EndUserText.label: 'Transportation Order Email Data Provider'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@ObjectModel:{
                modelingPattern: #OUTPUT_EMAIL_DATA_PROVIDER,
                usageType:{
                  serviceQuality: #C,
                  sizeCategory: #XL,
                  dataClass: #TRANSACTIONAL
                },
                supportedCapabilities: [ #OUTPUT_EMAIL_DATA_PROVIDER ]
              }

define view entity C_TransportationOrderEDP
  as select from           I_TransportationOrder_2 as TransportationOrder
    left outer to one join I_TranspOrdMainBPAddr   as ShipperAddressID on  TransportationOrder.TransportationOrderUUID  = ShipperAddressID.TransportationOrderUUID
                                                                       and ShipperAddressID.TranspOrdBizPartnerFunction = 'U6'
  // Shipper Address

  association [0..1] to I_Address_2           as _ShipperAddress on  $projection.ShipperNormalizedAddressID    = _ShipperAddress.AddressID
                                                                 and _ShipperAddress.AddressPersonID           = ' '
                                                                 and _ShipperAddress.AddressRepresentationCode = ' '

  association [1]    to E_TransportationOrder as _Extension      on  $projection.TransportationOrderUUID = _Extension.TransportationOrderUUID

{
  key TransportationOrder.TransportationOrderUUID,
      TransportationOrder.TransportationOrder,

      TransportationOrder._TransportationOrderCategory._Text[1: Language=$session.system_language ].TransportationOrderCatDesc,

      // Shipper Address

      _ShipperAddress.AddresseeFullName as TranspShipperFullName,
      _ShipperAddress.CityName          as TranspShipperCityName,
      _ShipperAddress.PostalCode        as TranspShipperPostalCode,
      _ShipperAddress.StreetName        as TranspShipperStreetName,
      _ShipperAddress.HouseNumber       as TranspShipperHouseNumber,
      _ShipperAddress.Country           as ShipperCountry,
      _ShipperAddress.Region            as ShipperRegion,

      // Technical Fields

      ShipperAddressID.AddressID        as ShipperNormalizedAddressID,

      // Needed for Authorization Check

      TransportationOrder.TransportationOrderCategory,
      TransportationOrder.TransportationOrderType,
      TransportationOrder.TranspPurgOrg,
      TransportationOrder.TranspPurgGroup,
      TransportationOrder.TranspOrdResponsiblePerson,
      TransportationOrder.TransportationMode
}

Learn More