R_InboundDeliveryItemTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_DeliveryDocumentItem | InboundDeliveryItem | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_DeliveryDocumentItem | _Extension | $projection.InboundDelivery = _Extension.DeliveryDocument and $projection.InboundDeliveryItem = _Extension.DeliveryDocumentItem |
| [0..*] | R_InbDelivItemSerialNumberTP | _SerialNumber | |
| [0..*] | R_InbDelivItemTextTP | _ItemText | |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA