R_CustomerReturnsDeliveryTP

DDL: R_CUSTOMERRETURNSDELIVERYTP Type: view_entity TRANSACTIONAL Package: RAP_LE_RET

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)

SourceAliasJoin Type
I_DeliveryDocument CustomerReturnsDelivery from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_DeliveryDocument _Extension $projection.CustomerReturnDelivery = _Extension.DeliveryDocument
[1..*] R_CustomerReturnsDelivItemTP _Item
[1..*] R_CustRetDelivPartnerTP _Partner
[0..*] R_CustRetDelivTextTP _Text

Annotations (10)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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';