R_InboundDeliveryItemTP

DDL: R_INBOUNDDELIVERYITEMTP Type: view_entity TRANSACTIONAL

Inbound Delivery Item - TP

R_InboundDeliveryItemTP is a Transactional CDS View that provides data about "Inbound Delivery Item - TP" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocumentItem) and exposes 130 fields with key fields InboundDelivery, InboundDeliveryItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocumentItem InboundDeliveryItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] E_DeliveryDocumentItem _Extension $projection.InboundDelivery = _Extension.DeliveryDocument and $projection.InboundDeliveryItem = _Extension.DeliveryDocumentItem
[0..*] R_InbDelivItemSerialNumberTP _SerialNumber
[0..*] R_InbDelivItemTextTP _ItemText

Annotations (9)

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

Fields (130)

KeyFieldSource TableSource FieldDescription
KEY InboundDelivery
KEY InboundDeliveryItem
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangeDate LastChangeDate
ActualDeliveredQtyInBaseUnit
OrderQuantityUnit DeliveryQuantityUnit
ActualDeliveredQtyInOrderUnit
PutawayQuantityInBaseUnit
PutawayQuantityInOrderUnit
QuantityIsFixed QuantityIsFixed
OriginalDeliveryQuantity OriginalDeliveryQuantity
BaseUnit BaseUnit
DeliveryToBaseQuantityDnmntr DeliveryToBaseQuantityDnmntr
DeliveryToBaseQuantityNmrtr DeliveryToBaseQuantityNmrtr
ItemGrossWeight ItemGrossWeight
ItemNetWeight ItemNetWeight
ItemWeightUnit ItemWeightUnit
ItemVolume ItemVolume
ItemVolumeUnit ItemVolumeUnit
PutawayStatus PickingStatus
WarehouseActivityStatus WarehouseActivityStatus
PutawayConfirmationStatus PickingConfirmationStatus
PackingStatus PackingStatus
GoodsMovementStatus GoodsMovementStatus
ProofOfDeliveryStatus ProofOfDeliveryStatus
DeliveryRelatedBillingStatus DeliveryRelatedBillingStatus
IntercompanyBillingStatus IntercompanyBillingStatus
DeliveryItemProcessStatus SDProcessStatus
ItemGeneralIncompletionStatus ItemGeneralIncompletionStatus
ItemDeliveryIncompletionStatus ItemDeliveryIncompletionStatus
ItemPutawayIncompletionStatus 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
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
DistributionChannel DistributionChannel
Division Division
DeliveryGroup DeliveryGroup
DeliveryDocumentItemCategory DeliveryDocumentItemCategory
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
_SerialNumber _SerialNumber
_ItemText _ItemText
_Delivery _Delivery
@EndUserText.label: 'Inbound Delivery Item - TP'
@AccessControl.authorizationCheck: #MANDATORY
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}
@ObjectModel: {
    usageType: {
        dataClass:      #TRANSACTIONAL,
        serviceQuality: #B,
        sizeCategory:   #XL
    },
    semanticKey: ['InboundDelivery', 'InboundDeliveryItem'],
    representativeKey: 'InboundDeliveryItem'
}
@Metadata.ignorePropagatedAnnotations: true
define view entity R_InboundDeliveryItemTP
  as select from I_DeliveryDocumentItem as InboundDeliveryItem
  composition [0..*] of R_InbDelivItemSerialNumberTP as _SerialNumber
  composition [0..*] of R_InbDelivItemTextTP         as _ItemText

  association        to parent R_InboundDeliveryTP   as _Delivery  on  $projection.InboundDelivery     = _Delivery.InboundDelivery

  //Extensibility

  association [0..1] to E_DeliveryDocumentItem       as _Extension on  $projection.InboundDelivery     = _Extension.DeliveryDocument
                                                                   and $projection.InboundDeliveryItem = _Extension.DeliveryDocumentItem
{
      // Key

      @ObjectModel.foreignKey.association: '_Delivery'
  key cast(DeliveryDocument as inbound_delivery preserving type) as InboundDelivery,
  key cast(DeliveryDocumentItem as inbound_delivery_item preserving type) as InboundDeliveryItem,

      // Admin

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

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      cast(ActualDeliveredQtyInBaseUnit as le_lgmng2 preserving type)      as ActualDeliveredQtyInBaseUnit,
      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_INBDLV_PUTAWAY_QTY'
      cast( 0.00 as pikmg_bu )      as PutawayQuantityInBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @ObjectModel.virtualElement:true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_LE_RAP_INBDLV_PUTAWAY_QTY'
      cast( 0.00 as pikmg )         as PutawayQuantityInOrderUnit,
      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 PutawayStatus,
      WarehouseActivityStatus,
      PickingConfirmationStatus     as PutawayConfirmationStatus,
      PackingStatus,
      GoodsMovementStatus,
      ProofOfDeliveryStatus,
      DeliveryRelatedBillingStatus,
      IntercompanyBillingStatus,
      SDProcessStatus               as DeliveryItemProcessStatus,
      ItemGeneralIncompletionStatus,
      ItemDeliveryIncompletionStatus,
      ItemPickingIncompletionStatus as ItemPutawayIncompletionStatus,
      ItemGdsMvtIncompletionSts,
      ItemPackingIncompletionStatus,
      ItemBillingIncompletionStatus,
      
      @Semantics.booleanIndicator: true
      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,

      // 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,

      // Organization

      DistributionChannel,
      Division,
      DeliveryGroup,
      DeliveryDocumentItemCategory,

      // 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,      

      /*Compositions*/
      _SerialNumber,
      _ItemText,

      /*Association*/
      _Delivery

}
where
  _Delivery.SDDocumentCategory = '7';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENTITEM",
"R_INBOUNDDELIVERYTP"
],
"ASSOCIATED":
[
"R_INBDELIVITEMSERIALNUMBERTP",
"R_INBDELIVITEMTEXTTP",
"R_INBOUNDDELIVERYTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/