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 97 fields with key field InboundDelivery. It has 4 associations to related views.
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 (97)
| 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 | |||
| _Item | _Item | |||
| _Partner | _Partner | |||
| _Text | _Text |
@EndUserText.label: 'Inbound Delivery - TP'
@AccessControl.authorizationCheck: #MANDATORY
@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,
/*Compositions*/
_Item,
_Partner,
_Text
}
where
SDDocumentCategory = '7';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENT"
],
"ASSOCIATED":
[
"R_INBDELIVERYPARTNERTP",
"R_INBOUNDDELIVERYITEMTP",
"R_INBOUNDDELIVERYTEXTTP"
],
"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