R_CustomerReturnsDeliveryTP
Customer Returns Delivery - TP
R_CustomerReturnsDeliveryTP is a Transactional CDS View that provides data about "Customer Returns Delivery - TP" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 104 fields with key field CustomerReturnDelivery. It has 4 associations to related views. Part of development package RAP_LE_RET.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_DeliveryDocument | CustomerReturnsDelivery | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_DeliveryDocument | _Extension | $projection.CustomerReturnDelivery = _Extension.DeliveryDocument |
| [1..*] | R_CustomerReturnsDelivItemTP | _Item | |
| [1..*] | R_CustRetDelivPartnerTP | _Partner | |
| [0..*] | R_CustRetDelivTextTP | _Text | |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| ObjectModel.sapObjectNodeType.name | CustomerReturnsDelivery | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.representativeKey | CustomerReturnDelivery | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Customer Returns Delivery - TP | view |
Fields (104)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CustomerReturnDelivery | DeliveryDocument | ||
| 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 |
@VDM: {
lifecycle.contract.type: #SAP_INTERNAL_API,
viewType: #TRANSACTIONAL
}
@ObjectModel: {
sapObjectNodeType.name: 'CustomerReturnsDelivery',
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #B,
sizeCategory: #L
},
semanticKey: ['CustomerReturnDelivery'],
representativeKey: 'CustomerReturnDelivery'
}
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@EndUserText.label: 'Customer Returns Delivery - TP'
define root view entity R_CustomerReturnsDeliveryTP
as select from I_DeliveryDocument as CustomerReturnsDelivery
composition [1..*] of R_CustomerReturnsDelivItemTP as _Item
composition [1..*] of R_CustRetDelivPartnerTP as _Partner
composition [0..*] of R_CustRetDelivTextTP as _Text
//Extensibility
association [0..1] to E_DeliveryDocument as _Extension on $projection.CustomerReturnDelivery = _Extension.DeliveryDocument
{
key DeliveryDocument as CustomerReturnDelivery,
// 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,
//Compositions
_Item,
_Partner,
_Text
}
where
SDDocumentCategory = 'T';
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