R_InboundDeliveryTP

DDL: R_INBOUNDDELIVERYTP Type: view_entity TRANSACTIONAL Package: RAP_LE_IBD

Inbound Delivery - TP

R_InboundDeliveryTP is a Transactional CDS View that provides data about "Inbound Delivery - TP" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 98 fields with key field InboundDelivery. It has 4 associations to related views. Part of development package RAP_LE_IBD.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument InboundDelivery from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_DeliveryDocument _Extension $projection.InboundDelivery = _Extension.DeliveryDocument
[1..*] R_InboundDeliveryItemTP _Item
[1..*] R_InbDeliveryPartnerTP _Partner
[0..*] R_InboundDeliveryTextTP _Text

Annotations (10)

NameValueLevelField
EndUserText.label Inbound 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 InboundDelivery view
ObjectModel.representativeKey InboundDelivery view
Metadata.ignorePropagatedAnnotations true view

Fields (98)

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

  association [0..1] to E_DeliveryDocument      as _Extension on $projection.InboundDelivery = _Extension.DeliveryDocument

{

      // Key

      @Consumption.semanticObject: 'InboundDelivery'
  key DeliveryDocument                                              as InboundDelivery,

      // Category

      SDDocumentCategory,
      DeliveryDocumentType,
      // Admin

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

      // Organization

      ShippingPoint                                                 as GoodsReceivingPoint,

      // Delivery

      @Semantics.booleanIndicator: true
      CompleteDeliveryIsDefined,
      DeliveryPriority,
      DeliveryBlockReason,
      DeliveryDocumentBySupplier,
      @Semantics.booleanIndicator: true
      DeliveryIsInPlant,
      DeliveryVersion,
      DocumentDate,
      ExternalIdentificationType,
      GoodsIssueOrReceiptSlipNumber                                 as GoodsMovementSlipNumber,
      @Semantics.quantity.unitOfMeasure: 'HeaderWeightUnit'
      HeaderGrossWeight,
      @Semantics.quantity.unitOfMeasure: 'HeaderWeightUnit'
      HeaderNetWeight,
      @Semantics.quantity.unitOfMeasure: 'HeaderVolumeUnit'
      HeaderVolume,
      HeaderVolumeUnit,
      HeaderWeightUnit,
      @Semantics.booleanIndicator: true
      IsExportDelivery,
      MeansOfTransportRefMaterial,
      @Semantics.booleanIndicator: true
      OrderCombinationIsAllowed,
      ReceivingPlant,
      SpecialProcessingCode,
      Supplier,
      Warehouse,
      WarehouseGate,
      WarehouseStagingArea,


      // Pick Pack Load

      TotalNumberOfPackage,
      LoadingDate,
      LoadingTime,
      BillOfLading,
      HandlingUnitInStock,

      // Shipping

      DeliveryDate,
      DeliveryTime,
      ShippingCondition,
      ShippingType,
      ShipmentBlockReason,
      TransportationPlanningDate,
      TransportationPlanningTime,
      RouteSchedule,
      PlannedGoodsIssueDate                                         as PlannedGoodsMovementDate,
      cast(GoodsIssueTime as le_wauhr preserving type)              as PlannedGoodsMovementTime,
      ActualGoodsMovementDate,
      cast(ActualGoodsMovementTime as le_wauhr_ist preserving type) as ActualGoodsMovementTime,
      IncotermsClassification,
      IncotermsTransferLocation,
      ExternalTransportSystem,
      TransportationGroup,
      MeansOfTransport,
      MeansOfTransportType,
      ProofOfDeliveryDate,
      ConfirmationTime                                              as ProofOfDeliveryTime,
      FactoryCalendarByCustomer,
      ShippingLocationTimeZone,
      ReceivingLocationTimeZone,

      // Billing

      IntercompanyBillingDate,
      BillingDocumentDate,
      HeaderBillingBlockReason,
      InternalFinancialDocument,
      PaymentGuaranteeProcedure,
      DepreciationPercentage                                        as DepreciationInPercent,

      // Sales

      CustomerGroup,
      TransactionCurrency,
      StatisticsCurrency,

      // Status

      OverallIntcoBillingStatus,
      OverallSDProcessStatus                                        as OverallDeliveryProcessStatus,
      TotalBlockStatus,
      OverallDelivConfStatus,
      TransportationPlanningStatus,
      OverallPickingConfStatus                                      as OverallPutawayConfStatus,
      OverallPickingStatus                                          as OverallPutawayStatus,
      OverallPackingStatus,
      OverallWarehouseActivityStatus,
      DistrStatusByDecentralizedWrhs,
      OverallGoodsMovementStatus,
      OverallDelivReltdBillgStatus,
      OverallProofOfDeliveryStatus,
      HdrGeneralIncompletionStatus,
      HeaderDelivIncompletionStatus,
      HeaderPickgIncompletionStatus                                 as HeaderPutawayIncompltnStatus,
      HeaderPackingIncompletionSts,
      HdrGoodsMvtIncompletionStatus,
      HeaderBillgIncompletionStatus,
      OvrlItmDelivIncompletionSts,
      OvrlItmGdsMvtIncompletionSts,
      OvrlItmGeneralIncompletionSts,
      OvrlItmPackingIncompletionSts,
      OvrlItmPickingIncompletionSts                                 as OvrlItmPutawayIncompletionSts,
      TotalCreditCheckStatus,
      /* Not to be included in PaaS API - only to filter out deliveries marked for deletion*/
      DeletionIndicator,

      /*Compositions*/
      _Item,
      _Partner,
      _Text

}
where
  SDDocumentCategory = '7' and DeletionIndicator is initial;