R_InboundDeliveryTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_DeliveryDocument | InboundDelivery | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_DeliveryDocument | _Extension | $projection.InboundDelivery = _Extension.DeliveryDocument |
| [1..*] | R_InboundDeliveryItemTP | _Item | |
| [1..*] | R_InbDeliveryPartnerTP | _Partner | |
| [0..*] | R_InboundDeliveryTextTP | _Text | |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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;
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