R_OutboundDeliveryTP

DDL: R_OUTBOUNDDELIVERYTP Type: view_entity TRANSACTIONAL

Outbound Delivery - TP

R_OutboundDeliveryTP is a Transactional CDS View that provides data about "Outbound Delivery - TP" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 104 fields with key field OutboundDelivery. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument I_DeliveryDocument from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_DeliveryDocument _Extension $projection.OutboundDelivery = _Extension.DeliveryDocument
[0..*] R_OutboundDeliveryItemTP _Item
[1..*] R_OutboundDeliveryPartnerTP _Partner
[0..*] R_OutboundDeliveryTextTP _Text

Annotations (10)

NameValueLevelField
EndUserText.label Outbound Delivery - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name OutboundDelivery view
ObjectModel.representativeKey OutboundDelivery view
Metadata.ignorePropagatedAnnotations true view

Fields (104)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery
ShipToParty ShipToParty
SoldToParty SoldToParty
Supplier Supplier
ReceivingPlant ReceivingPlant
CustomerGroup CustomerGroup
Warehouse Warehouse
WarehouseGate WarehouseGate
WarehouseStagingArea WarehouseStagingArea
HandlingUnitInStock HandlingUnitInStock
TotalNumberOfPackage TotalNumberOfPackage
RouteSchedule RouteSchedule
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
BillOfLading BillOfLading
GoodsMovementSlipNumber GoodsIssueOrReceiptSlipNumber
TransportationGroup TransportationGroup
ShipmentBlockReason ShipmentBlockReason
ShippingCondition ShippingCondition
ShippingType ShippingType
SpecialProcessingCode SpecialProcessingCode
MeansOfTransport MeansOfTransport
MeansOfTransportType MeansOfTransportType
MeansOfTransportRefMaterial MeansOfTransportRefMaterial
ExternalTransportSystem ExternalTransportSystem
FactoryCalendarByCustomer FactoryCalendarByCustomer
HeaderGrossWeight HeaderGrossWeight
HeaderNetWeight HeaderNetWeight
HeaderWeightUnit HeaderWeightUnit
HeaderVolume HeaderVolume
HeaderVolumeUnit HeaderVolumeUnit
IsExportDelivery IsExportDelivery
HeaderBillingBlockReason HeaderBillingBlockReason
InternalFinancialDocument InternalFinancialDocument
DepreciationInPercent DepreciationPercentage
PaymentGuaranteeProcedure PaymentGuaranteeProcedure
TransactionCurrency TransactionCurrency
StatisticsCurrency StatisticsCurrency
DeliveryDocumentBySupplier DeliveryDocumentBySupplier
ExternalIdentificationType ExternalIdentificationType
ShippingPoint ShippingPoint
SalesOrganization SalesOrganization
SalesOffice SalesOffice
SalesDistrict SalesDistrict
CreatedByUser CreatedByUser
LastChangedByUser LastChangedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangeDate LastChangeDate
DeliveryVersion DeliveryVersion
DeliveryPriority DeliveryPriority
DeliveryBlockReason DeliveryBlockReason
DeliveryDocumentType DeliveryDocumentType
SDDocumentCategory SDDocumentCategory
CompleteDeliveryIsDefined CompleteDeliveryIsDefined
OrderCombinationIsAllowed OrderCombinationIsAllowed
DocumentDate DocumentDate
PickDate PickingDate
PickTime PickingTime
TransportationPlanningDate TransportationPlanningDate
TransportationPlanningTime TransportationPlanningTime
LoadingDate LoadingDate
LoadingTime LoadingTime
PlannedGoodsMovementDate PlannedGoodsIssueDate
PlannedGoodsMovementTime
DeliveryDate DeliveryDate
DeliveryTime DeliveryTime
BillingDocumentDate BillingDocumentDate
IntercompanyBillingDate IntercompanyBillingDate
ActualGoodsMovementDate ActualGoodsMovementDate
ActualGoodsMovementTime
ProofOfDeliveryDate ProofOfDeliveryDate
ProofOfDeliveryTime ConfirmationTime
ShippingLocationTimeZone ShippingLocationTimeZone
ReceivingLocationTimeZone ReceivingLocationTimeZone
OverallPickStatus OverallPickingStatus
OverallWarehouseActivityStatus OverallWarehouseActivityStatus
OverallPickConfStatus OverallPickingConfStatus
OverallPackingStatus OverallPackingStatus
OverallGoodsMovementStatus OverallGoodsMovementStatus
OverallDelivReltdBillgStatus OverallDelivReltdBillgStatus
TransportationPlanningStatus TransportationPlanningStatus
DistrStatusByDecentralizedWrhs DistrStatusByDecentralizedWrhs
OverallProofOfDeliveryStatus OverallProofOfDeliveryStatus
OverallIntcoBillingStatus OverallIntcoBillingStatus
TotalCreditCheckStatus TotalCreditCheckStatus
OverallDeliveryProcessStatus OverallSDProcessStatus
TotalBlockStatus TotalBlockStatus
OverallDelivConfStatus OverallDelivConfStatus
HdrGeneralIncompletionStatus HdrGeneralIncompletionStatus
HeaderDelivIncompletionStatus HeaderDelivIncompletionStatus
HeaderPickIncompletionStatus HeaderPickgIncompletionStatus
HeaderPackingIncompletionSts HeaderPackingIncompletionSts
HdrGoodsMvtIncompletionStatus HdrGoodsMvtIncompletionStatus
HeaderBillgIncompletionStatus HeaderBillgIncompletionStatus
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts
OvrlItmPackingIncompletionSts OvrlItmPackingIncompletionSts
OvrlItmPickIncompletionSts OvrlItmPickingIncompletionSts
OvrlItmDelivIncompletionSts OvrlItmDelivIncompletionSts
OvrlItmGdsMvtIncompletionSts OvrlItmGdsMvtIncompletionSts
DeliveryIsInPlant DeliveryIsInPlant
_Item _Item
_Partner _Partner
_Text _Text
@EndUserText.label: 'Outbound Delivery - TP'
@AccessControl.authorizationCheck: #MANDATORY
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}
@ObjectModel: {
    usageType: {
        dataClass:      #TRANSACTIONAL,
        serviceQuality: #B,
        sizeCategory:   #L
    },
    sapObjectNodeType.name: 'OutboundDelivery',
    semanticKey: ['OutboundDelivery'],
    representativeKey: 'OutboundDelivery'
}
@Metadata.ignorePropagatedAnnotations: true
define root view entity R_OutboundDeliveryTP
  as select from I_DeliveryDocument
  composition [0..*] of R_OutboundDeliveryItemTP    as _Item
  composition [1..*] of R_OutboundDeliveryPartnerTP as _Partner
  composition [0..*] of R_OutboundDeliveryTextTP    as _Text

  //Extensibility

  association [0..1] to E_DeliveryDocument          as _Extension on $projection.OutboundDelivery = _Extension.DeliveryDocument
{
      // Key fields

  key cast(DeliveryDocument as outbound_delivery preserving type)   as OutboundDelivery,

      // Partner

      ShipToParty,
      SoldToParty,
      Supplier,
      ReceivingPlant,
      CustomerGroup,

      // Warehouse

      Warehouse,
      WarehouseGate,
      WarehouseStagingArea,
      HandlingUnitInStock,
      TotalNumberOfPackage,

      // Shipment

      RouteSchedule,
      IncotermsClassification,
      IncotermsTransferLocation,
      BillOfLading,
      GoodsIssueOrReceiptSlipNumber                                 as GoodsMovementSlipNumber,
      TransportationGroup,
      ShipmentBlockReason,
      ShippingCondition,
      ShippingType,
      SpecialProcessingCode,
      MeansOfTransport,
      MeansOfTransportType,
      MeansOfTransportRefMaterial,
      ExternalTransportSystem,
      FactoryCalendarByCustomer,

      // Weight and Volume

      @Semantics.quantity.unitOfMeasure: 'HeaderWeightUnit'
      HeaderGrossWeight,
      @Semantics.quantity.unitOfMeasure: 'HeaderWeightUnit'
      HeaderNetWeight,
      HeaderWeightUnit,
      @Semantics.quantity.unitOfMeasure: 'HeaderVolumeUnit'
      HeaderVolume,
      HeaderVolumeUnit,

      // International Trade

      @Semantics.booleanIndicator: true
      IsExportDelivery,

      // Financial Processing

      HeaderBillingBlockReason,
      InternalFinancialDocument,
      DepreciationPercentage                                        as DepreciationInPercent,
      PaymentGuaranteeProcedure,
      TransactionCurrency,
      StatisticsCurrency,

      // Organization

      DeliveryDocumentBySupplier,
      ExternalIdentificationType,
      ShippingPoint,
      SalesOrganization,
      SalesOffice,
      SalesDistrict,

      // Document Editing

      @Semantics.user.createdBy: true
      CreatedByUser,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      @Semantics.systemDate.createdAt: true
      CreationDate,
      @Semantics.systemTime.createdAt: true
      CreationTime,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,
      DeliveryVersion,

      // Control

      DeliveryPriority,
      DeliveryBlockReason,
      DeliveryDocumentType,
      SDDocumentCategory,
      CompleteDeliveryIsDefined,
      OrderCombinationIsAllowed,

      // Dates

      DocumentDate,
      PickingDate                                                   as PickDate,
      PickingTime                                                   as PickTime,
      TransportationPlanningDate,
      TransportationPlanningTime,
      LoadingDate,
      LoadingTime,
      PlannedGoodsIssueDate                                         as PlannedGoodsMovementDate,
      cast(GoodsIssueTime as le_wauhr preserving type)              as PlannedGoodsMovementTime,
      DeliveryDate,
      DeliveryTime,
      BillingDocumentDate,
      IntercompanyBillingDate,
      ActualGoodsMovementDate,
      cast(ActualGoodsMovementTime as le_wauhr_ist preserving type) as ActualGoodsMovementTime,
      ProofOfDeliveryDate,
      ConfirmationTime                                              as ProofOfDeliveryTime,
      ShippingLocationTimeZone,
      ReceivingLocationTimeZone,

      // Status

      OverallPickingStatus                                          as OverallPickStatus,
      OverallWarehouseActivityStatus,
      OverallPickingConfStatus                                      as OverallPickConfStatus,
      OverallPackingStatus,
      OverallGoodsMovementStatus,
      OverallDelivReltdBillgStatus,
      TransportationPlanningStatus,
      DistrStatusByDecentralizedWrhs,
      OverallProofOfDeliveryStatus,
      OverallIntcoBillingStatus,
      TotalCreditCheckStatus,
      OverallSDProcessStatus                                        as OverallDeliveryProcessStatus,
      TotalBlockStatus,
      OverallDelivConfStatus,
      HdrGeneralIncompletionStatus,
      HeaderDelivIncompletionStatus,
      HeaderPickgIncompletionStatus                                 as HeaderPickIncompletionStatus,
      HeaderPackingIncompletionSts,
      HdrGoodsMvtIncompletionStatus,
      HeaderBillgIncompletionStatus,
      OvrlItmGeneralIncompletionSts,
      OvrlItmPackingIncompletionSts,
      OvrlItmPickingIncompletionSts                                 as OvrlItmPickIncompletionSts,
      OvrlItmDelivIncompletionSts,
      OvrlItmGdsMvtIncompletionSts,
      DeliveryIsInPlant,

      // Associations

      _Item,
      _Partner,
      _Text
}
where
  SDDocumentCategory = 'J'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENT"
],
"ASSOCIATED":
[
"R_OUTBOUNDDELIVERYITEMTP",
"R_OUTBOUNDDELIVERYPARTNERTP",
"R_OUTBOUNDDELIVERYTEXTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/