I_CUSTOMERRETURNDELIVERY

CDS View

Customer Returns Delivery Document

I_CUSTOMERRETURNDELIVERY is a CDS View in S/4HANA. Customer Returns Delivery Document. It contains 3 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_CustomerReturnDeliveryFS view from CONSUMPTION Returns Delivery Object Page
C_DelivProcFlowReturnsDeliv view from CONSUMPTION Delivery Process Flow - Node Returns Delivery
C_ReturnsDeliveryProcFlow view inner CONSUMPTION Returns Delivery Process Flow
ESH_N_CUSTOMERRETURNDELIVERY view from

Fields (3)

KeyField CDS FieldsUsed in Views
KEY CustomerReturnDelivery ReturnsDelivery 1
OverallPickingStatus OverallPickingStatus 1
ShippingPoint ShippingPoint 1
@ClientHandling.algorithm: #SESSION_VARIABLE                        //Inserted by VDM CDS Suite Plugin

@ObjectModel.compositionRoot: true
@ObjectModel.representativeKey: 'CustomerReturnDelivery'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL                    //or #MIXED or #CUSTOMIZING or #MASTER or #META or #ORGANIZATIONAL or 

@ObjectModel.usageType.serviceQuality: #B                           //or #A or #X or #C or #D

@ObjectModel.usageType.sizeCategory: #L                             //or #S or #M or #XL or #XXL //Inserted by VDM CDS Suite Plugin

//Commented by VDM CDS Suite Plugin:@ObjectModel.representativeKey: 'CustomerReturnDelivery'

//Commented by VDM CDS Suite Plugin:@ObjectModel.compositionRoot: true

@EndUserText.label: 'Customer Returns Delivery Document'
@Analytics: { dataCategory: #DIMENSION, internalName:#LOCAL }
@Analytics.dataExtraction: { enabled: true, 
                             delta.changeDataCapture.mapping: [{
                               role: #MAIN,
                               table: 'LIKP',
                               tableElement: ['VBELN'],
                               viewElement: ['CustomerReturnDelivery']
                             }]
                            } 
@Metadata.allowExtensions: true
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck:#CHECK
@AbapCatalog.sqlViewName: 'ILECUSTRETDELIV'
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: [ #ANALYTICAL_DIMENSION ]
@ObjectModel.sapObjectNodeType.name:'CustomerReturnsDelivery'

define view I_CustomerReturnDelivery
as select from I_DeliveryDocument
//Associations

association[0..*] to I_CustomerReturnDeliveryItem as _Item on $projection.CustomerReturnDelivery = _Item.CustomerReturnDelivery
association[0..1] to I_PutawayStatus as _OverallPutawayStatus on $projection.OverallPutawayStatus = _OverallPutawayStatus.PutawayStatus
//The following shall be removed when the cast bug is fixed.

association[1..*] to I_SDDocumentPartner as _Partner on $projection.CustomerReturnDelivery = _Partner.SDDocument

//Extensibility

association [0..1] to E_DeliveryDocument as _Extension         on $projection.CustomerReturnDelivery = _Extension.DeliveryDocument


{
    //key 

    key cast(DeliveryDocument as customer_return_delivery) as CustomerReturnDelivery,
    
    @Consumption.hidden: true
    DeliveryDocument, // Required for association to _MaterialDocumentHeader


    //category

    @ObjectModel.foreignKey.association: '_DeliveryDocumentType'
    DeliveryDocumentType,

    //admin

    CreatedByUser,
    @Semantics.businessDate.createdAt: true
    CreationDate,
    CreationTime,
    LastChangedByUser,
    @Semantics.businessDate.lastChangedAt: true
    LastChangeDate,

    //Organization

    @ObjectModel.foreignKey.association: '_ShippingPoint'
    ShippingPoint,
    @ObjectModel.foreignKey.association: '_SalesOrganization'
    SalesOrganization,
    @ObjectModel.foreignKey.association: '_SalesOffice'
    SalesOffice,

    //delivery

    CompleteDeliveryIsDefined,
    OrderCombinationIsAllowed,
    @ObjectModel.foreignKey.association: '_DeliveryPriority'
    DeliveryPriority,
    @ObjectModel.foreignKey.association: '_DeliveryBlockReason'
    DeliveryBlockReason,
    @ObjectModel.foreignKey.association: '_Supplier'
    Supplier,
    DeliveryDocumentBySupplier,
    DeliveryIsInPlant,
    @ObjectModel.foreignKey.association: '_ReceivingPlant'
    ReceivingPlant,
    @ObjectModel.foreignKey.association: '_Warehouse'
    Warehouse,
    IsExportDelivery,
    @ObjectModel.foreignKey.association: '_OrderID'
    OrderID,
    @DefaultAggregation: #SUM
    @Semantics.quantity.unitOfMeasure: 'HeaderWeightUnit'
    HeaderGrossWeight,
    @DefaultAggregation: #SUM
    @Semantics.quantity.unitOfMeasure: 'HeaderWeightUnit'
    HeaderNetWeight,
    @Semantics.unitOfMeasure: true
    @ObjectModel.foreignKey.association: '_HeaderWeightUnit'
    HeaderWeightUnit,
    @DefaultAggregation: #SUM
    @Semantics.quantity.unitOfMeasure: 'HeaderVolumeUnit' 
    HeaderVolume, 
    @Semantics.unitOfMeasure: true
    @ObjectModel.foreignKey.association: '_HeaderVolumeUnit'
    HeaderVolumeUnit,
    DocumentDate,
    
    @ObjectModel.foreignKey.association: '_WarehouseExecutionStatus'
    ReadyForWarehouseExecStatus,
      
    @ObjectModel.foreignKey.association: '_DelivAdvncdShipgRcvgRlvnce'
    DelivAdvncdShipgRcvgRlvnce,
     
    //Pick Pack Load

    PickingDate,
    PickingTime,
    TotalNumberOfPackage,
    @ObjectModel.foreignKey.association: '_LoadingPoint'
    LoadingPoint,
    LoadingDate,
    LoadingTime,
    BillOfLading,
    @ObjectModel.foreignKey.association: '_HandlingUnitInStock'
    HandlingUnitInStock,
     
    //shipping

    @ObjectModel.foreignKey.association: '_ShipToParty'
    ShipToParty,
    @ObjectModel.foreignKey.association: '_ShippingType'
    ShippingType,
    DeliveryDate,
    DeliveryTime,
    @ObjectModel.foreignKey.association: '_ShippingCondition'
    ShippingCondition,
    @ObjectModel.foreignKey.association: '_ShipmentBlockReason'
    ShipmentBlockReason,
    TransportationPlanningDate,
    TransportationPlanningTime,
    @ObjectModel.foreignKey.association: '_ProposedDeliveryRoute'
    ProposedDeliveryRoute,
    @ObjectModel.foreignKey.association: '_ActualDeliveryRoute'
    ActualDeliveryRoute,
    RouteSchedule,
    PlannedGoodsIssueDate,
    GoodsIssueTime,
    ActualGoodsMovementDate,
    @ObjectModel.foreignKey.association: '_IncotermsClassification'
    IncotermsClassification,
    IncotermsTransferLocation,
    ExternalTransportSystem,
    @ObjectModel.foreignKey.association: '_TransportationGroup'
    TransportationGroup,
    MeansOfTransport,
    @ObjectModel.foreignKey.association: '_MeansOfTransportType'
    MeansOfTransportType,
    UnloadingPointName,
    ProofOfDeliveryDate,
    ConfirmationTime,
    FactoryCalendarByCustomer,

    //Billing

    BillingDocumentDate,
    @ObjectModel.foreignKey.association: '_HeaderBillingBlockReason'
    HeaderBillingBlockReason,

    //Sales

    @ObjectModel.foreignKey.association: '_SoldToParty'
    SoldToParty,
    @ObjectModel.foreignKey.association: '_CustomerGroup'
    CustomerGroup,
    @ObjectModel.foreignKey.association: '_SalesDistrict'
    SalesDistrict,
    @ObjectModel.foreignKey.association: '_TransactionCurrency'
    TransactionCurrency,  
    
    //Status

    OverallIntcoBillingStatus,
    @ObjectModel.foreignKey.association: '_OverallSDProcessStatus'
    OverallSDProcessStatus,
    @ObjectModel.foreignKey.association: '_TotalBlockStatus'
    TotalBlockStatus,
    @ObjectModel.foreignKey.association: '_OverallDelivConfStatus'
    OverallDelivConfStatus, 
    @ObjectModel.foreignKey.association: '_TransportationPlanningSts'
    TransportationPlanningStatus,   
    @ObjectModel.foreignKey.association: '_OverallPickingConfStatus'
    OverallPickingConfStatus,   
    @ObjectModel.foreignKey.association: '_OverallPickingStatus'
    OverallPickingStatus,  
    @ObjectModel.foreignKey.association: '_OverallPutawayStatus'
    OverallPickingStatus as OverallPutawayStatus,              
    @ObjectModel.foreignKey.association: '_OverallPackingStatus'
    OverallPackingStatus,
    @ObjectModel.foreignKey.association: '_OvrlWarehouseActyStatus'
    OverallWarehouseActivityStatus,
    @ObjectModel.foreignKey.association: '_DistrStatusByDectrlzdWrhs'
    DistrStatusByDecentralizedWrhs,
    @ObjectModel.foreignKey.association: '_OverallGoodsMovementStatus'
    OverallGoodsMovementStatus,
    @ObjectModel.foreignKey.association: '_OverallDelivReltdBillgStatus'
    OverallDelivReltdBillgStatus,
    @ObjectModel.foreignKey.association: '_OverallProofOfDeliveryStatus'
    OverallProofOfDeliveryStatus,
    @ObjectModel.foreignKey.association: '_HdrGeneralIncompletionStatus'
    HdrGeneralIncompletionStatus,
    @ObjectModel.foreignKey.association: '_HeaderDelivIncompletionStatus'
    HeaderDelivIncompletionStatus,
    @ObjectModel.foreignKey.association: '_HeaderPickgIncompletionStatus'
    HeaderPickgIncompletionStatus,
    @ObjectModel.foreignKey.association: '_HeaderPackingIncompletionSts'
    HeaderPackingIncompletionSts,
    @ObjectModel.foreignKey.association: '_HdrGoodsMvtIncompletionStatus'
    HdrGoodsMvtIncompletionStatus,
    @ObjectModel.foreignKey.association: '_HeaderBillgIncompletionStatus'
    HeaderBillgIncompletionStatus,
    @ObjectModel.foreignKey.association: '_OvrlItmGeneralIncompletionSts'
    OvrlItmGeneralIncompletionSts,
    @ObjectModel.foreignKey.association: '_OvrlItmPackingIncompletionSts'
    OvrlItmPackingIncompletionSts,
    @ObjectModel.foreignKey.association: '_OvrlItmPickingIncompletionSts'
    OvrlItmPickingIncompletionSts,
    @ObjectModel.foreignKey.association: '_OvrlItmDelivIncompletionSts'
    OvrlItmDelivIncompletionSts,
    @ObjectModel.foreignKey.association: '_OvrlItmGdsMvtIncompletionSts'
    OvrlItmGdsMvtIncompletionSts,
    @ObjectModel.foreignKey.association: '_OverallChmlCmplncStatus'
    OverallChmlCmplncStatus,
    @ObjectModel.foreignKey.association: '_OverallDangerousGoodsStatus'
    OverallDangerousGoodsStatus,
    @ObjectModel.foreignKey.association: '_OvrlSftyDataSheetSts'
    OverallSafetyDataSheetStatus,
    
    
    //EMCS Integration - Excise Tax

    @ObjectModel.foreignKey.association: '_ExciseTaxStatus'
    EU_DeliveryARCStatus,

   //Associations

   @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
   _Item,
   _Partner,
   //  Category

   _DeliveryDocumentType,
   //  Admin

   _CreatedByUser,
   _LastChangedByUser,
   //  Organization

   _ShippingPoint, 
   _SalesOrganization,
   _SalesOffice,
   //  Delivery      

   _DeliveryPriority,
   _DeliveryBlockReason,
   _Supplier,
   _ReceivingPlant,
   _Warehouse,
   _OrderID,    
   _HeaderWeightUnit,
   _HeaderVolumeUnit,
   //  Pick Pack Load

   _LoadingPoint,
   _HandlingUnitInStock,
   //  Shipping

   _ShipToParty,
   _ShippingType,
   _ShippingCondition,
   _ShipmentBlockReason,
   _ProposedDeliveryRoute,
   _ActualDeliveryRoute,
   _IncotermsClassification,
   _TransportationGroup,
   _MeansOfTransportType,
   //  Billing    

   _HeaderBillingBlockReason,
   //  Sales

   _SoldToParty,
   _CustomerGroup,
   _SalesDistrict,
   _TransactionCurrency,
   //  Status    

   _OverallSDProcessStatus,
   _TotalBlockStatus,
   _OverallDelivConfStatus,
   _TransportationPlanningSts,
   _OverallPickingConfStatus,
   _OverallPickingStatus,
   _OverallPutawayStatus,   
   _OverallPackingStatus,
   _OvrlWarehouseActyStatus,
   _DistrStatusByDectrlzdWrhs,
   _OverallGoodsMovementStatus,
   _OverallDelivReltdBillgStatus,
   _OverallProofOfDeliveryStatus,
   _HdrGeneralIncompletionStatus,
   _HeaderDelivIncompletionStatus,
   _HeaderPickgIncompletionStatus,
   _HeaderPackingIncompletionSts,
   _HdrGoodsMvtIncompletionStatus,
   _HeaderBillgIncompletionStatus,
   _OvrlItmGeneralIncompletionSts,
   _OvrlItmPackingIncompletionSts,
   _OvrlItmPickingIncompletionSts,
   _OvrlItmDelivIncompletionSts,
   _OvrlItmGdsMvtIncompletionSts,
   _MaterialDocumentHeader,
   
   _OverallChmlCmplncStatus,
   _OverallDangerousGoodsStatus,
   _OvrlSftyDataSheetSts,
   _ExciseTaxStatus,

   _WarehouseExecutionStatus,
   _DelivAdvncdShipgRcvgRlvnce
   
   
} where SDDocumentCategory = 'T';                                                                                                                                             
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENT"
],
"ASSOCIATED":
[
"E_DELIVERYDOCUMENT",
"I_ADVSHIPRECEIVERLVNCE",
"I_BILLINGBLOCKREASON",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERGROUP",
"I_CUSTOMERRETURNDELIVERYITEM",
"I_DELIVERYBLOCKREASON",
"I_DELIVERYDOCUMENTTYPE",
"I_DELIVERYPRIORITY",
"I_DISTRSTATUSBYDECTRLZDWRHS",
"I_EXCISETAXSTATUS",
"I_HANDLINGUNITINSTOCK",
"I_HDRBILLGINCOMPLETIONSTATUS",
"I_HDRDELIVINCOMPLETIONSTATUS",
"I_HDRGENINCOMPLETIONSTATUS",
"I_HDRGOODSMVTINCOMPLTNSTATUS",
"I_HDRPACKINGINCOMPLTNSTATUS",
"I_HDRPICKGINCOMPLTNSTATUS",
"I_INCOTERMSCLASSIFICATION",
"I_LOADINGPOINT",
"I_MATERIALDOCUMENTHEADER",
"I_MEANSOFTRANSPORTTYPE",
"I_MFGORDER",
"I_OVERALLDELIVCHMLCMPLNCSTS",
"I_OVERALLDELIVCONFSTATUS",
"I_OVERALLDELIVRELTDBILLGSTS",
"I_OVERALLGOODSMOVEMENTSTATUS",
"I_OVERALLPACKINGSTATUS",
"I_OVERALLPICKINGCONFSTATUS",
"I_OVERALLPICKINGSTATUS",
"I_OVERALLPROOFOFDELIVSTATUS",
"I_OVERALLSDPROCESSSTATUS",
"I_OVRLDELIVDNGRSGDSSTS",
"I_OVRLDELIVSFTYDATASHTSTS",
"I_OVRLITMDELIVINCOMPLETIONSTS",
"I_OVRLITMGDSMVTINCOMPLTNSTS",
"I_OVRLITMGENINCOMPLETIONSTS",
"I_OVRLITMPACKINGINCOMPLTNSTS",
"I_OVRLITMPICKINGINCOMPLTNSTS",
"I_OVRLWAREHOUSEACTYSTATUS",
"I_PLANT",
"I_PUTAWAYSTATUS",
"I_ROUTE",
"I_SALESDISTRICT",
"I_SALESOFFICE",
"I_SALESORGANIZATION",
"I_SDDOCUMENTPARTNER",
"I_SHIPMENTBLOCKREASON",
"I_SHIPPINGCONDITION",
"I_SHIPPINGPOINT",
"I_SHIPPINGTYPE",
"I_SUPPLIER",
"I_TOTALBLOCKSTATUS",
"I_TRANSPORTATIONGROUP",
"I_TRANSPORTATIONPLANNINGSTS",
"I_UNITOFMEASURE",
"I_USER",
"I_WAREHOUSE",
"I_WAREHOUSEEXECUTIONSTATUS"
],
"BASE":
[
"I_DELIVERYDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/