R_OutboundDeliveryTP
Outbound Delivery - TP
R_OutboundDeliveryTP is a Transactional CDS View that provides data about "Outbound Delivery - TP" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 104 fields with key field OutboundDelivery. It has 4 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_DeliveryDocument | I_DeliveryDocument | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_DeliveryDocument | _Extension | $projection.OutboundDelivery = _Extension.DeliveryDocument |
| [0..*] | R_OutboundDeliveryItemTP | _Item | |
| [1..*] | R_OutboundDeliveryPartnerTP | _Partner | |
| [0..*] | R_OutboundDeliveryTextTP | _Text | |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Outbound 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 | OutboundDelivery | view | |
| ObjectModel.representativeKey | OutboundDelivery | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (104)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | OutboundDelivery | |||
| ShipToParty | ShipToParty | |||
| SoldToParty | SoldToParty | |||
| Supplier | Supplier | |||
| ReceivingPlant | ReceivingPlant | |||
| CustomerGroup | CustomerGroup | |||
| Warehouse | Warehouse | |||
| WarehouseGate | WarehouseGate | |||
| WarehouseStagingArea | WarehouseStagingArea | |||
| HandlingUnitInStock | HandlingUnitInStock | |||
| TotalNumberOfPackage | TotalNumberOfPackage | |||
| RouteSchedule | RouteSchedule | |||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsTransferLocation | IncotermsTransferLocation | |||
| BillOfLading | BillOfLading | |||
| GoodsMovementSlipNumber | GoodsIssueOrReceiptSlipNumber | |||
| TransportationGroup | TransportationGroup | |||
| ShipmentBlockReason | ShipmentBlockReason | |||
| ShippingCondition | ShippingCondition | |||
| ShippingType | ShippingType | |||
| SpecialProcessingCode | SpecialProcessingCode | |||
| MeansOfTransport | MeansOfTransport | |||
| MeansOfTransportType | MeansOfTransportType | |||
| MeansOfTransportRefMaterial | MeansOfTransportRefMaterial | |||
| ExternalTransportSystem | ExternalTransportSystem | |||
| FactoryCalendarByCustomer | FactoryCalendarByCustomer | |||
| HeaderGrossWeight | HeaderGrossWeight | |||
| HeaderNetWeight | HeaderNetWeight | |||
| HeaderWeightUnit | HeaderWeightUnit | |||
| HeaderVolume | HeaderVolume | |||
| HeaderVolumeUnit | HeaderVolumeUnit | |||
| IsExportDelivery | IsExportDelivery | |||
| HeaderBillingBlockReason | HeaderBillingBlockReason | |||
| InternalFinancialDocument | InternalFinancialDocument | |||
| DepreciationInPercent | DepreciationPercentage | |||
| PaymentGuaranteeProcedure | PaymentGuaranteeProcedure | |||
| TransactionCurrency | TransactionCurrency | |||
| StatisticsCurrency | StatisticsCurrency | |||
| DeliveryDocumentBySupplier | DeliveryDocumentBySupplier | |||
| ExternalIdentificationType | ExternalIdentificationType | |||
| ShippingPoint | ShippingPoint | |||
| SalesOrganization | SalesOrganization | |||
| SalesOffice | SalesOffice | |||
| SalesDistrict | SalesDistrict | |||
| CreatedByUser | CreatedByUser | |||
| LastChangedByUser | LastChangedByUser | |||
| CreationDate | CreationDate | |||
| CreationTime | CreationTime | |||
| LastChangeDate | LastChangeDate | |||
| DeliveryVersion | DeliveryVersion | |||
| DeliveryPriority | DeliveryPriority | |||
| DeliveryBlockReason | DeliveryBlockReason | |||
| DeliveryDocumentType | DeliveryDocumentType | |||
| SDDocumentCategory | SDDocumentCategory | |||
| CompleteDeliveryIsDefined | CompleteDeliveryIsDefined | |||
| OrderCombinationIsAllowed | OrderCombinationIsAllowed | |||
| DocumentDate | DocumentDate | |||
| PickDate | PickingDate | |||
| PickTime | PickingTime | |||
| TransportationPlanningDate | TransportationPlanningDate | |||
| TransportationPlanningTime | TransportationPlanningTime | |||
| LoadingDate | LoadingDate | |||
| LoadingTime | LoadingTime | |||
| PlannedGoodsMovementDate | PlannedGoodsIssueDate | |||
| PlannedGoodsMovementTime | ||||
| DeliveryDate | DeliveryDate | |||
| DeliveryTime | DeliveryTime | |||
| BillingDocumentDate | BillingDocumentDate | |||
| IntercompanyBillingDate | IntercompanyBillingDate | |||
| ActualGoodsMovementDate | ActualGoodsMovementDate | |||
| ActualGoodsMovementTime | ||||
| ProofOfDeliveryDate | ProofOfDeliveryDate | |||
| ProofOfDeliveryTime | ConfirmationTime | |||
| ShippingLocationTimeZone | ShippingLocationTimeZone | |||
| ReceivingLocationTimeZone | ReceivingLocationTimeZone | |||
| OverallPickStatus | OverallPickingStatus | |||
| OverallWarehouseActivityStatus | OverallWarehouseActivityStatus | |||
| OverallPickConfStatus | OverallPickingConfStatus | |||
| OverallPackingStatus | OverallPackingStatus | |||
| OverallGoodsMovementStatus | OverallGoodsMovementStatus | |||
| OverallDelivReltdBillgStatus | OverallDelivReltdBillgStatus | |||
| TransportationPlanningStatus | TransportationPlanningStatus | |||
| DistrStatusByDecentralizedWrhs | DistrStatusByDecentralizedWrhs | |||
| OverallProofOfDeliveryStatus | OverallProofOfDeliveryStatus | |||
| OverallIntcoBillingStatus | OverallIntcoBillingStatus | |||
| TotalCreditCheckStatus | TotalCreditCheckStatus | |||
| OverallDeliveryProcessStatus | OverallSDProcessStatus | |||
| TotalBlockStatus | TotalBlockStatus | |||
| OverallDelivConfStatus | OverallDelivConfStatus | |||
| HdrGeneralIncompletionStatus | HdrGeneralIncompletionStatus | |||
| HeaderDelivIncompletionStatus | HeaderDelivIncompletionStatus | |||
| HeaderPickIncompletionStatus | HeaderPickgIncompletionStatus | |||
| HeaderPackingIncompletionSts | HeaderPackingIncompletionSts | |||
| HdrGoodsMvtIncompletionStatus | HdrGoodsMvtIncompletionStatus | |||
| HeaderBillgIncompletionStatus | HeaderBillgIncompletionStatus | |||
| OvrlItmGeneralIncompletionSts | OvrlItmGeneralIncompletionSts | |||
| OvrlItmPackingIncompletionSts | OvrlItmPackingIncompletionSts | |||
| OvrlItmPickIncompletionSts | OvrlItmPickingIncompletionSts | |||
| OvrlItmDelivIncompletionSts | OvrlItmDelivIncompletionSts | |||
| OvrlItmGdsMvtIncompletionSts | OvrlItmGdsMvtIncompletionSts | |||
| DeliveryIsInPlant | DeliveryIsInPlant | |||
| _Item | _Item | |||
| _Partner | _Partner | |||
| _Text | _Text |
@EndUserText.label: 'Outbound Delivery - TP'
@AccessControl.authorizationCheck: #MANDATORY
@VDM: {
lifecycle.contract.type: #SAP_INTERNAL_API,
viewType: #TRANSACTIONAL
}
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #B,
sizeCategory: #L
},
sapObjectNodeType.name: 'OutboundDelivery',
semanticKey: ['OutboundDelivery'],
representativeKey: 'OutboundDelivery'
}
@Metadata.ignorePropagatedAnnotations: true
define root view entity R_OutboundDeliveryTP
as select from I_DeliveryDocument
composition [0..*] of R_OutboundDeliveryItemTP as _Item
composition [1..*] of R_OutboundDeliveryPartnerTP as _Partner
composition [0..*] of R_OutboundDeliveryTextTP as _Text
//Extensibility
association [0..1] to E_DeliveryDocument as _Extension on $projection.OutboundDelivery = _Extension.DeliveryDocument
{
// Key fields
key cast(DeliveryDocument as outbound_delivery preserving type) as OutboundDelivery,
// Partner
ShipToParty,
SoldToParty,
Supplier,
ReceivingPlant,
CustomerGroup,
// Warehouse
Warehouse,
WarehouseGate,
WarehouseStagingArea,
HandlingUnitInStock,
TotalNumberOfPackage,
// Shipment
RouteSchedule,
IncotermsClassification,
IncotermsTransferLocation,
BillOfLading,
GoodsIssueOrReceiptSlipNumber as GoodsMovementSlipNumber,
TransportationGroup,
ShipmentBlockReason,
ShippingCondition,
ShippingType,
SpecialProcessingCode,
MeansOfTransport,
MeansOfTransportType,
MeansOfTransportRefMaterial,
ExternalTransportSystem,
FactoryCalendarByCustomer,
// Weight and Volume
@Semantics.quantity.unitOfMeasure: 'HeaderWeightUnit'
HeaderGrossWeight,
@Semantics.quantity.unitOfMeasure: 'HeaderWeightUnit'
HeaderNetWeight,
HeaderWeightUnit,
@Semantics.quantity.unitOfMeasure: 'HeaderVolumeUnit'
HeaderVolume,
HeaderVolumeUnit,
// International Trade
@Semantics.booleanIndicator: true
IsExportDelivery,
// Financial Processing
HeaderBillingBlockReason,
InternalFinancialDocument,
DepreciationPercentage as DepreciationInPercent,
PaymentGuaranteeProcedure,
TransactionCurrency,
StatisticsCurrency,
// Organization
DeliveryDocumentBySupplier,
ExternalIdentificationType,
ShippingPoint,
SalesOrganization,
SalesOffice,
SalesDistrict,
// Document Editing
@Semantics.user.createdBy: true
CreatedByUser,
@Semantics.user.lastChangedBy: true
LastChangedByUser,
@Semantics.systemDate.createdAt: true
CreationDate,
@Semantics.systemTime.createdAt: true
CreationTime,
@Semantics.systemDate.lastChangedAt: true
LastChangeDate,
DeliveryVersion,
// Control
DeliveryPriority,
DeliveryBlockReason,
DeliveryDocumentType,
SDDocumentCategory,
CompleteDeliveryIsDefined,
OrderCombinationIsAllowed,
// Dates
DocumentDate,
PickingDate as PickDate,
PickingTime as PickTime,
TransportationPlanningDate,
TransportationPlanningTime,
LoadingDate,
LoadingTime,
PlannedGoodsIssueDate as PlannedGoodsMovementDate,
cast(GoodsIssueTime as le_wauhr preserving type) as PlannedGoodsMovementTime,
DeliveryDate,
DeliveryTime,
BillingDocumentDate,
IntercompanyBillingDate,
ActualGoodsMovementDate,
cast(ActualGoodsMovementTime as le_wauhr_ist preserving type) as ActualGoodsMovementTime,
ProofOfDeliveryDate,
ConfirmationTime as ProofOfDeliveryTime,
ShippingLocationTimeZone,
ReceivingLocationTimeZone,
// Status
OverallPickingStatus as OverallPickStatus,
OverallWarehouseActivityStatus,
OverallPickingConfStatus as OverallPickConfStatus,
OverallPackingStatus,
OverallGoodsMovementStatus,
OverallDelivReltdBillgStatus,
TransportationPlanningStatus,
DistrStatusByDecentralizedWrhs,
OverallProofOfDeliveryStatus,
OverallIntcoBillingStatus,
TotalCreditCheckStatus,
OverallSDProcessStatus as OverallDeliveryProcessStatus,
TotalBlockStatus,
OverallDelivConfStatus,
HdrGeneralIncompletionStatus,
HeaderDelivIncompletionStatus,
HeaderPickgIncompletionStatus as HeaderPickIncompletionStatus,
HeaderPackingIncompletionSts,
HdrGoodsMvtIncompletionStatus,
HeaderBillgIncompletionStatus,
OvrlItmGeneralIncompletionSts,
OvrlItmPackingIncompletionSts,
OvrlItmPickingIncompletionSts as OvrlItmPickIncompletionSts,
OvrlItmDelivIncompletionSts,
OvrlItmGdsMvtIncompletionSts,
DeliveryIsInPlant,
// Associations
_Item,
_Partner,
_Text
}
where
SDDocumentCategory = 'J'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENT"
],
"ASSOCIATED":
[
"R_OUTBOUNDDELIVERYITEMTP",
"R_OUTBOUNDDELIVERYPARTNERTP",
"R_OUTBOUNDDELIVERYTEXTTP"
],
"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