R_OutboundDeliveryItemTP

DDL: R_OUTBOUNDDELIVERYITEMTP Type: view_entity TRANSACTIONAL Package: RAP_LE_OBD

Outbound Delivery Item - TP

R_OutboundDeliveryItemTP is a Transactional CDS View that provides data about "Outbound Delivery Item - TP" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocumentItem) and exposes 134 fields with key fields OutboundDelivery, OutboundDeliveryItem. It has 3 associations to related views. Part of development package RAP_LE_OBD.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocumentItem I_DeliveryDocumentItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] E_DeliveryDocumentItem _Extension $projection.OutboundDelivery = _Extension.DeliveryDocument and $projection.OutboundDeliveryItem = _Extension.DeliveryDocumentItem
[0..*] R_OutbDelivItemSerialNumberTP _SerialNumber
[0..*] R_OutboundDeliveryItemTextTP _ItemText

Annotations (9)

NameValueLevelField
EndUserText.label Outbound Delivery Item - 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 #XL view
ObjectModel.representativeKey OutboundDeliveryItem view
Metadata.ignorePropagatedAnnotations true view

Fields (134)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery
KEY OutboundDeliveryItem
ActualDeliveredQtyInBaseUnit
OrderQuantityUnit DeliveryQuantityUnit Order Quantity Unit
ActualDeliveredQtyInOrderUnit
PickQuantityInBaseUnit
PickQuantityInOrderUnit
QuantityIsFixed QuantityIsFixed
OriginalDeliveryQuantity OriginalDeliveryQuantity
BaseUnit BaseUnit
DeliveryToBaseQuantityDnmntr DeliveryToBaseQuantityDnmntr
DeliveryToBaseQuantityNmrtr DeliveryToBaseQuantityNmrtr
ItemGrossWeight ItemGrossWeight
ItemNetWeight ItemNetWeight
ItemWeightUnit ItemWeightUnit
ItemVolume ItemVolume
ItemVolumeUnit ItemVolumeUnit
PickStatus PickingStatus
WarehouseActivityStatus WarehouseActivityStatus
PickConfirmationStatus PickingConfirmationStatus
PackingStatus PackingStatus
GoodsMovementStatus GoodsMovementStatus
ProofOfDeliveryStatus ProofOfDeliveryStatus
DeliveryRelatedBillingStatus DeliveryRelatedBillingStatus
IntercompanyBillingStatus IntercompanyBillingStatus
EU_DeliveryItemARCStatus EU_DeliveryItemARCStatus
DeliveryItemProcessStatus SDProcessStatus
ItemGeneralIncompletionStatus ItemGeneralIncompletionStatus
ItemDeliveryIncompletionStatus ItemDeliveryIncompletionStatus
ItemPickIncompletionStatus ItemPickingIncompletionStatus
ItemGdsMvtIncompletionSts ItemGdsMvtIncompletionSts
ItemPackingIncompletionStatus ItemPackingIncompletionStatus
ItemBillingIncompletionStatus ItemBillingIncompletionStatus
IsCompletelyDelivered IsCompletelyDelivered
InspectionLot InspectionLot
InspectionPartialLot InspectionPartialLot
Material Material
DeliveryDocumentItemText DeliveryDocumentItemText
MaterialByCustomer MaterialByCustomer
AlternateProductNumber AlternateProductNumber
CustEngineeringChgStatus CustEngineeringChgStatus
BOMExplosion BOMExplosion
HigherLevelItem HigherLevelItem
InternationalArticleNumber InternationalArticleNumber
OriginallyRequestedMaterial OriginallyRequestedMaterial
MaterialGroup MaterialGroup
AdditionalMaterialGroup1 AdditionalMaterialGroup1
AdditionalMaterialGroup2 AdditionalMaterialGroup2
AdditionalMaterialGroup3 AdditionalMaterialGroup3
AdditionalMaterialGroup4 AdditionalMaterialGroup4
AdditionalMaterialGroup5 AdditionalMaterialGroup5
Batch Batch
MaterialIsBatchManaged MaterialIsBatchManaged
ShelfLifeExpirationDate ShelfLifeExpirationDate
ManufactureDate ManufactureDate
BatchClassification BatchClassification
BatchBySupplier BatchBySupplier
HigherLvlItmOfBatSpltItm HigherLvlItmOfBatSpltItm
NumberOfSerialNumbers NumberOfSerialNumbers
ProductConfiguration ProductConfiguration
ProductHierarchyNode ProductHierarchyNode
Plant Plant
StorageLocation StorageLocation
StorageBin StorageBin
StorageType StorageType
Warehouse Warehouse
WarehouseStorageBin
WarehouseStagingArea WarehouseStagingArea
WarehouseStockCategory
ProductAvailabilityDate ProductAvailabilityDate
ProductAvailabilityTime ProductAvailabilityTime
LoadingGroup LoadingGroup
TransportationGroup TransportationGroup
MaterialFreightGroup MaterialFreightGroup
FixedShipgProcgDurationInDays FixedShipgProcgDurationInDays
VarblShipgProcgDurationInDays VarblShipgProcgDurationInDays
ProofOfDeliveryRelevanceCode ProofOfDeliveryRelevanceCode
ReceivingPoint ReceivingPoint
BillingRelevanceCode ItemIsBillingRelevant
ItemBillingBlockReason ItemBillingBlockReason
PaymentGuaranteeForm PaymentGuaranteeForm
BusinessArea BusinessArea
ControllingArea ControllingArea
CostCenter CostCenter
ProfitCenter ProfitCenter
ManufacturingOrder OrderID
ManufacturingOrderItem OrderItem
GLAccount GLAccount
InventoryValuationType InventoryValuationType
IsSeparateValuation IsSeparateValuation
DepartmentClassificationByCust DepartmentClassificationByCust
ReferenceSDDocument ReferenceSDDocument
ReferenceSDDocumentItem ReferenceSDDocumentItem
ReferenceSDDocumentCategory ReferenceSDDocumentCategory
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem
PartialDeliveryIsAllowed PartialDeliveryIsAllowed
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct
SalesDocumentItemType SalesDocumentItemType
SalesGroup SalesGroup
SalesOffice SalesOffice
DistributionChannel DistributionChannel
Division Division
DeliveryGroup DeliveryGroup
DeliveryDocumentItemCategory DeliveryDocumentItemCategory
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangeDate LastChangeDate
GoodsMovementType GoodsMovementType
StockType StockType
IsNotGoodsMovementsRelevant IsNotGoodsMovementsRelevant
GoodsMovementReasonCode GoodsMovementReasonCode
InventorySpecialStockType InventorySpecialStockType
SubsequentMovementType SubsequentMovementType
PrimaryPostingSwitch PrimaryPostingSwitch
ConsumptionPosting ConsumptionPosting
StatisticsDate StatisticsDate
AdditionalCustomerGroup1 AdditionalCustomerGroup1
AdditionalCustomerGroup2 AdditionalCustomerGroup2
AdditionalCustomerGroup3 AdditionalCustomerGroup3
AdditionalCustomerGroup4 AdditionalCustomerGroup4
AdditionalCustomerGroup5 AdditionalCustomerGroup5
IssgOrRcvgStockCategory
IssgOrRcvgMaterial IssgOrRcvgMaterial
IssuingOrReceivingPlant IssuingOrReceivingPlant
IssuingOrReceivingStorageLoc IssuingOrReceivingStorageLoc
IssgOrRcvgBatch IssgOrRcvgBatch
IssgOrRcvgValuationType IssgOrRcvgValuationType
IssgOrRcvgSpclStockCode IssgOrRcvgSpclStockInd
_Delivery _Delivery
_SerialNumber _SerialNumber
_ItemText _ItemText
@EndUserText.label: 'Outbound Delivery Item - 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:   #XL
    },
    semanticKey: ['OutboundDelivery', 'OutboundDeliveryItem'],
    representativeKey: 'OutboundDeliveryItem'
}
@Metadata.ignorePropagatedAnnotations: true
define view entity R_OutboundDeliveryItemTP
  as select from I_DeliveryDocumentItem
  composition [0..*] of R_OutbDelivItemSerialNumberTP as _SerialNumber
  composition [0..*] of R_OutboundDeliveryItemTextTP  as _ItemText

  association        to parent R_OutboundDeliveryTP          as _Delivery on  $projection.OutboundDelivery = _Delivery.OutboundDelivery

  //Extensibility

  association [0..1] to E_DeliveryDocumentItem        as _Extension       on  $projection.OutboundDelivery     = _Extension.DeliveryDocument
                                                                          and $projection.OutboundDeliveryItem = _Extension.DeliveryDocumentItem

{
      // Key fields

      @ObjectModel.foreignKey.association: '_Delivery'
  key cast(DeliveryDocument as outbound_delivery preserving type)          as OutboundDelivery,
  key cast(DeliveryDocumentItem as outbound_delivery_item preserving type) as OutboundDeliveryItem,

      // Quantities

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      cast(ActualDeliveredQtyInBaseUnit as le_lgmng2 preserving type)      as ActualDeliveredQtyInBaseUnit,
      @EndUserText.label: 'Order Quantity Unit'
      DeliveryQuantityUnit                                                 as OrderQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      cast(ActualDeliveryQuantity as le_lfimg2 preserving type)            as ActualDeliveredQtyInOrderUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @ObjectModel.virtualElement:true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_LE_RAP_OBD_PICK_QUANTITY'
      cast( 0.00 as pikmg_bu )                                             as PickQuantityInBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @ObjectModel.virtualElement:true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_LE_RAP_OBD_PICK_QUANTITY'
      cast( 0.00 as pikmg )                                                as PickQuantityInOrderUnit,
      QuantityIsFixed,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      OriginalDeliveryQuantity,
      BaseUnit,
      DeliveryToBaseQuantityDnmntr,
      DeliveryToBaseQuantityNmrtr,

      // Weight and Volume

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      ItemGrossWeight,
      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      ItemNetWeight,
      ItemWeightUnit,
      @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
      ItemVolume,
      ItemVolumeUnit,

      // Item Status

      PickingStatus                                                        as PickStatus,
      WarehouseActivityStatus,
      PickingConfirmationStatus                                            as PickConfirmationStatus,
      PackingStatus,
      GoodsMovementStatus,
      ProofOfDeliveryStatus,
      DeliveryRelatedBillingStatus,
      IntercompanyBillingStatus,
      EU_DeliveryItemARCStatus                                             as EU_DeliveryItemARCStatus,
      SDProcessStatus                                                      as DeliveryItemProcessStatus,
      @EndUserText: {label: 'Gen Incompl Sts (Item)' }
      ItemGeneralIncompletionStatus,
      ItemDeliveryIncompletionStatus,
      ItemPickingIncompletionStatus                                        as ItemPickIncompletionStatus,
      ItemGdsMvtIncompletionSts,
      ItemPackingIncompletionStatus,
      ItemBillingIncompletionStatus,
      IsCompletelyDelivered,

      // Quality Inspection

      InspectionLot,
      InspectionPartialLot,

      // Material

      Material,
      DeliveryDocumentItemText,
      MaterialByCustomer,
      AlternateProductNumber,
      CustEngineeringChgStatus,
      BOMExplosion,
      HigherLevelItem,
      InternationalArticleNumber,
      OriginallyRequestedMaterial,
      MaterialGroup,
      AdditionalMaterialGroup1,
      AdditionalMaterialGroup2,
      AdditionalMaterialGroup3,
      AdditionalMaterialGroup4,
      AdditionalMaterialGroup5,

      // Batch

      Batch,
      MaterialIsBatchManaged,
      ShelfLifeExpirationDate,
      ManufactureDate,
      BatchClassification,
      BatchBySupplier,
      HigherLvlItmOfBatSpltItm,
      NumberOfSerialNumbers,
      ProductConfiguration,
      ProductHierarchyNode,

      // Warehouse

      Plant,
      StorageLocation,
      StorageBin,
      StorageType,
      Warehouse,
      cast(WarehouseStorageBin as le_lgpbe preserving type)                as WarehouseStorageBin,
      WarehouseStagingArea,
      cast(WarehouseStockCategory as le_bestq preserving type)             as WarehouseStockCategory,
      ProductAvailabilityDate,
      ProductAvailabilityTime,

      // Loading and Shipment

      LoadingGroup,
      TransportationGroup,
      MaterialFreightGroup,
      FixedShipgProcgDurationInDays,
      VarblShipgProcgDurationInDays,
      ProofOfDeliveryRelevanceCode,
      ReceivingPoint,

      // Financial Processing

      // Billing Document

      ItemIsBillingRelevant                                                as BillingRelevanceCode,
      ItemBillingBlockReason,
      PaymentGuaranteeForm,
      // Account Assignment

      BusinessArea,
      ControllingArea,
      CostCenter,
      ProfitCenter,
      OrderID                                                              as ManufacturingOrder,
      OrderItem                                                            as ManufacturingOrderItem,
      GLAccount,
      InventoryValuationType,
      IsSeparateValuation,
      DepartmentClassificationByCust,

      // Predecessor Data

      // Order

      ReferenceSDDocument,
      ReferenceSDDocumentItem,
      ReferenceSDDocumentCategory,
      ReferenceDocumentLogicalSystem,
      PartialDeliveryIsAllowed,
      UnlimitedOverdeliveryIsAllowed,
      OverdelivTolrtdLmtRatioInPct,
      UnderdelivTolrtdLmtRatioInPct,
      SalesDocumentItemType,
      SalesGroup,
      SalesOffice,

      // Administration

      // Organization

      DistributionChannel,
      Division,
      DeliveryGroup,
      DeliveryDocumentItemCategory,

      CreatedByUser,
      CreationDate,
      CreationTime,
      LastChangeDate,

      // Control

      GoodsMovementType,
      StockType,
      @Semantics.booleanIndicator: true
      IsNotGoodsMovementsRelevant,
      GoodsMovementReasonCode,
      InventorySpecialStockType,
      SubsequentMovementType,
      PrimaryPostingSwitch,
      ConsumptionPosting,
      StatisticsDate,

      AdditionalCustomerGroup1,
      AdditionalCustomerGroup2,
      AdditionalCustomerGroup3,
      AdditionalCustomerGroup4,
      AdditionalCustomerGroup5,

      // Stock Transfer Posting

      cast(IssgOrRcvgStockCategory as le_umbestq preserving type)          as IssgOrRcvgStockCategory,
      IssgOrRcvgMaterial,
      IssuingOrReceivingPlant,
      IssuingOrReceivingStorageLoc,
      IssgOrRcvgBatch,
      IssgOrRcvgValuationType,
      IssgOrRcvgSpclStockInd                                               as IssgOrRcvgSpclStockCode,

      // Associations

      _Delivery,
      _SerialNumber,
      _ItemText
}
where
  _Delivery.SDDocumentCategory = 'J'