R_CustomerReturnsDelivItemTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_CustomerReturnsDelivItemTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_CustomerReturnsDelivItemTP AS
SELECT
  cast(DeliveryDocument as customer_return_delivery preserving type) AS CustomerReturnDelivery,
  cast(DeliveryDocumentItem as customer_return_delivery_item preserving type) AS CustomerReturnDeliveryItem,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  cast(ActualDeliveredQtyInBaseUnit as le_lgmng2 preserving type) AS ActualDeliveredQtyInBaseUnit,
  DeliveryQuantityUnit AS OrderQuantityUnit,
  cast(ActualDeliveryQuantity as le_lfimg2 preserving type) AS ActualDeliveredQtyInOrderUnit,
  cast( 0.00 as pikmg_bu ) AS PickQuantityInBaseUnit,
  cast( 0.00 as pikmg ) AS PickQuantityInOrderUnit,
  QuantityIsFixed,
  OriginalDeliveryQuantity,
  BaseUnit,
  DeliveryToBaseQuantityDnmntr,
  DeliveryToBaseQuantityNmrtr,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  PickingStatus AS PickStatus,
  WarehouseActivityStatus,
  PickingConfirmationStatus AS PickConfirmationStatus,
  PackingStatus,
  GoodsMovementStatus,
  ProofOfDeliveryStatus,
  DeliveryRelatedBillingStatus,
  IntercompanyBillingStatus,
  SDProcessStatus AS DeliveryItemProcessStatus,
  ItemGeneralIncompletionStatus,
  ItemDeliveryIncompletionStatus,
  ItemPickingIncompletionStatus AS ItemPickIncompletionStatus,
  ItemGdsMvtIncompletionSts,
  ItemPackingIncompletionStatus,
  ItemBillingIncompletionStatus,
  IsCompletelyDelivered,
  InspectionLot,
  InspectionPartialLot,
  Material,
  DeliveryDocumentItemText,
  MaterialByCustomer,
  AlternateProductNumber,
  CustEngineeringChgStatus,
  BOMExplosion,
  HigherLevelItem,
  InternationalArticleNumber,
  OriginallyRequestedMaterial,
  MaterialGroup,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  Batch,
  MaterialIsBatchManaged,
  ShelfLifeExpirationDate,
  ManufactureDate,
  BatchClassification,
  BatchBySupplier,
  HigherLvlItmOfBatSpltItm,
  NumberOfSerialNumbers,
  ProductConfiguration,
  ProductHierarchyNode,
  Plant,
  StorageLocation,
  StorageBin,
  StorageType,
  Warehouse,
  cast(WarehouseStorageBin as le_lgpbe preserving type) AS WarehouseStorageBin,
  WarehouseStagingArea,
  cast(WarehouseStockCategory as le_bestq preserving type) AS WarehouseStockCategory,
  ProductAvailabilityDate,
  ProductAvailabilityTime,
  LoadingGroup,
  TransportationGroup,
  MaterialFreightGroup,
  FixedShipgProcgDurationInDays,
  VarblShipgProcgDurationInDays,
  ProofOfDeliveryRelevanceCode,
  ReceivingPoint,
  ItemIsBillingRelevant AS BillingRelevanceCode,
  ItemBillingBlockReason,
  PaymentGuaranteeForm,
  BusinessArea,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  OrderID AS ManufacturingOrder,
  OrderItem AS ManufacturingOrderItem,
  GLAccount,
  InventoryValuationType,
  IsSeparateValuation,
  DepartmentClassificationByCust,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  ReferenceDocumentLogicalSystem,
  PartialDeliveryIsAllowed,
  UnlimitedOverdeliveryIsAllowed,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  SalesDocumentItemType,
  SalesGroup,
  SalesOffice,
  DistributionChannel,
  Division,
  DeliveryGroup,
  DeliveryDocumentItemCategory,
  GoodsMovementType,
  StockType,
  IsNotGoodsMovementsRelevant,
  GoodsMovementReasonCode,
  InventorySpecialStockType,
  SubsequentMovementType,
  PrimaryPostingSwitch,
  ConsumptionPosting,
  StatisticsDate,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  cast(IssgOrRcvgStockCategory as le_umbestq preserving type) AS IssgOrRcvgStockCategory,
  IssgOrRcvgMaterial,
  IssuingOrReceivingPlant,
  IssuingOrReceivingStorageLoc,
  IssgOrRcvgBatch,
  IssgOrRcvgValuationType,
  IssgOrRcvgSpclStockInd AS IssgOrRcvgSpclStockCode
FROM I_DeliveryDocumentItem AS CustomerReturnsDeliveryItem
LEFT OUTER JOIN E_DeliveryDocumentItem AS _Extension ON CustomerReturnDelivery = _Extension.DeliveryDocument AND CustomerReturnDeliveryItem = _Extension.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN R_CustRetDelivItemTextTP AS _ItemText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CustRetDelivItemSerialNmbrTP AS _SerialNumber ON /* condition not available in parsed metadata */  -- association [0..*]
;