C_CustomerReturnItemOPg

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 C_CustomerReturnItemOPg.
-- 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 C_CustomerReturnItemOPg AS
SELECT
  ReturnItem.CustomerReturn AS CustomerReturn,
  ReturnItem.CustomerReturnItem AS CustomerReturnItem,
  ReturnItem.HigherLevelItem AS HigherLevelItem,
  cast(ReturnItem.Material as productnumber preserving type) AS Material,
  ReturnItem.Material AS RootBatchProduct,
  cast(ReturnItem.MaterialGroup as productgroup preserving type) AS MaterialGroup,
  ReturnItem.Batch AS Batch,
  cast ('' as charg_d) AS BatchBySupplier,
  _Product.IsBatchManagementRequired AS IsBatchManagementRequired,
  ReturnItem.ReturnReason AS ReturnReason,
  cast('' as return_log_procg_status) AS RetsMgmtItmLogProcgStatus,
  cast('' as val_text) AS RetsMgmtItmLogProcgStatusDesc,
  cast('' as msr_fin_status) AS RetsMgmtItmCompnProcgStatus,
  cast('' as val_text) AS RetsMgmtCompnProcgStatusDesc,
  cast('' as msr_proc_status) AS RetsMgmtItmProcgStatus,
  cast('' as val_text) AS RetsMgmtProcessingStatusDesc,
  cast (ReturnItem.OrderQuantity as menge_pos) AS OrderQuantity,
  ReturnItem.OrderQuantityUnit AS OrderQuantityUnit,
  ReturnItem.BaseUnit AS BaseUnit,
  ReturnItem._OrderQuantityUnit.UnitOfMeasureDimension AS UnitOfMeasureDimension,
  ReturnItem.NetAmount AS NetAmount,
  ReturnItem.TransactionCurrency AS Currency,
  ReturnItem._CustomerReturn.RequestedDeliveryDate AS DeliveryDate,
  ReturnItem._CustomerReturn.CustomerReturnType AS CustomerReturnType,
  cast (ReturnItem.Plant as wsubst_rec_plant) AS ProductionPlant,
  ReturnItem.Plant AS RootBatchPlant,
  _Plant.PlantName AS PlantName,
  ReturnItem.MaterialByCustomer AS MaterialByCustomer,
  ReturnItem.BillOfMaterial AS BillOfMaterial,
  ReturnItem.BOMExplosionDate AS BOMExplosionDate,
  SalesDocumentItemCategory.BillingRelevanceCode AS BillingRelevanceCode,
  ReturnItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  ReturnItem.ReferenceSDDocument AS ReferenceSDDocument,
  ReturnItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  ReturnItem.StorageLocation AS StorageLocation,
  ReturnItem._StorageLocation.StorageLocationName AS StorageLocationName,
  ReturnItem._CustomerReturn.ShippingCondition AS ShippingCondition,
  cast (ReturnItem.ShippingPoint as borgr_wanst) AS ShippingPoint,
  ReturnItem.ReturnsRefundType AS ReturnsRefundType,
  ReturnItem.ReturnsRefundProcgMode AS ReturnsRefundProcgMode,
  ReturnItem._ReturnsRefundProcgMode.ReturnsRefundProcgModeDesc AS ReturnsRefundProcgModeDesc,
  ReturnItem.ReturnsRefundExtent AS ReturnsRefundExtent,
  ReturnItem.RetMatlInspResultCode AS RetMatlInspResultCode,
  ReturnItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  ReturnItem.ReturnsRefundRjcnReason AS ReturnsRefundRjcnReason,
  ReturnItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  ReturnItem._CustomerReturn.LastChangeDateTime AS LastChangeDateTime,
  ReturnItem._CustomerReturn.SalesOrganization AS SalesOrganization,
  ReturnItem._CustomerReturn.DistributionChannel AS DistributionChannel,
  ReturnItem._CustomerReturn.OrganizationDivision AS OrganizationDivision,
  ReturnItem.RetsMgmtProcessingBlock AS RetsMgmtProcessingBlock,
  ReturnItem.ReturnsMaterialHasBeenReceived AS ReturnsMaterialHasBeenReceived,
  ReturnItem.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  cast ('' as objky) AS LinkedSAPObjectKey,
  cast (ReturnItem.CustomerReturnItemUUID as abap.char( 32 )) AS CustomerReturnItemUUID,
  cast ('' as abap.char( 32 )) AS BillOfMaterialItemUUID,
  ReturnItem.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  ReturnItem.RetMatlInspResultCode AS InspectionCode,
  cast('' as msr_at_customer_site) AS ProductIsInspectedAtCustSite,
  ReturnItem.Supplier AS Supplier,
  cast ('' as abap.sstring(75)) AS SupplierAddress,
  cast ('' as ad_addrnum) AS SupplierAddressID,
  ReturnItem.AddressID AS ItemDeliveryAddressID,
  cast ('' as msr_insp_comment) AS CustRetItmInspectionText,
  cast ('' as msr_cust_insp_comment) AS CustRetItmCustomerText,
  '' AS FollowUpActivityIsSupplied,
  ReturnItem.RetsMgmtProcess AS RetsMgmtProcess,
  ReturnItem.RetsMgmtProcessItem AS RetsMgmtProcessItem,
  _ScheduleLine.GoodsMovementType AS GoodsMovementType,
  ReturnItem._CustomerReturn AS _CustomerReturn
FROM I_CustomerReturnItemEnhanced AS ReturnItem
LEFT OUTER JOIN C_CreditMemoRequestItem AS _CustRetCreditMemoReqItem ON CustomerReturn = _CustRetCreditMemoReqItem.ReferenceSDDocument AND CustomerReturnItem = _CustRetCreditMemoReqItem.ReferenceSDDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_SalesOrderWithoutChargeItem AS _OrderWOCharge ON CustomerReturn = _OrderWOCharge.ReferenceSDDocument AND CustomerReturnItem = _OrderWOCharge.ReferenceSDDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_CustRetItemCustomer AS _BusinessPartnersItem ON CustomerReturn = _BusinessPartnersItem.CustomerReturn AND CustomerReturnItem = _BusinessPartnersItem.CustomerReturnItem  -- association [0..*]
LEFT OUTER JOIN I_AllwdPlantsPerSlsOrgVH AS _PlantVH ON ProductionPlant = _PlantVH.Plant AND salesorganization = _PlantVH.SalesOrganization AND distributionchannel = _PlantVH.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN P_CustReturnSubsqntProcg AS _CustReturnSubsqntProcg ON CustomerReturn = _CustReturnSubsqntProcg.CustomerReturn AND CustomerReturnItem = _CustReturnSubsqntProcg.CustomerReturnItem  -- association [0..1]
LEFT OUTER JOIN P_CustRetRefDocItem AS _CustRetRefDocItem ON ReferenceSDDocument = _CustRetRefDocItem.ReturnsReferenceDocument AND ReferenceSDDocumentItem = _CustRetRefDocItem.ReturnsReferenceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnitValueHelp ON OrderQuantityUnit = _QuantityUnitValueHelp.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ProductAlternativeUoM AS _ProductAlternativeUoM ON Material = _ProductAlternativeUoM.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductAlternativeUoM AS _ProductAlternativeUoMVH ON Material = _ProductAlternativeUoMVH.Product AND OrderQuantityUnit = _ProductAlternativeUoMVH.AlternativeUnit  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _ReturnsRefundRjcnReason ON ReturnsRefundRjcnReason = _ReturnsRefundRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN I_ReturnsRefundExtent AS _ReturnsRefundExtent ON ReturnsRefundExtent = _ReturnsRefundExtent.ReturnsRefundExtent  -- association [0..1]
LEFT OUTER JOIN I_ReturnReason AS _ReturnReason ON ReturnReason = _ReturnReason.ReturnReason  -- association [0..1]
LEFT OUTER JOIN I_ReturnsRefundType AS _ReturnsRefundType ON ReturnsRefundType = _ReturnsRefundType.ReturnsRefundType  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON ProductionPlant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_ShippingPointText AS _ShippingPointText ON ShippingPoint = _ShippingPointText.ShippingPoint  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentCategoryText AS _SDDocumentCategoryText ON ReferenceSDDocumentCategory = _SDDocumentCategoryText.SDDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_ReturnReasonText AS _ReturnReasonText ON ReturnReason = _ReturnReasonText.ReturnReason  -- association [0..*]
LEFT OUTER JOIN I_ReturnsRefundTypeText AS _ReturnsRefundTypeText ON ReturnsRefundType = _ReturnsRefundTypeText.ReturnsRefundType  -- association [0..*]
LEFT OUTER JOIN I_ReturnsRefundExtentText AS _ReturnsRefundExtentText ON ReturnsRefundExtent = _ReturnsRefundExtentText.ReturnsRefundExtent  -- association [0..*]
LEFT OUTER JOIN I_RetMatlInspResultCodeText AS _RetMatlInspResultCodeText ON RetMatlInspResultCode = _RetMatlInspResultCodeText.RetMatlInspResultCode  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentRejectionStatusT AS _SDDocumentRejectionStatusT ON SDDocumentRejectionStatus = _SDDocumentRejectionStatusT.SDDocumentRejectionStatus  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentRjcnReasonText AS _SalesDocumentRjcnReasonText ON SalesDocumentRjcnReason = _SalesDocumentRjcnReasonText.SalesDocumentRjcnReason  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON ReturnItem.Product = _ProductPlant.Product AND ReturnItem.Plant = _ProductPlant.Plant  -- association [0..1]
LEFT OUTER JOIN C_CustomerReturnSerialNumber AS _SerialNumbers ON CustomerReturn = _SerialNumbers.CustomerReturn AND CustomerReturnItem = _SerialNumbers.CustomerReturnItem AND Material = _SerialNumbers.Product  -- association [0..*]
LEFT OUTER JOIN I_RetMatlInspResultCode AS _InspectionCodeVH ON InspectionCode = _InspectionCodeVH.RetMatlInspResultCode  -- association [0..1]
LEFT OUTER JOIN I_FollowUpActivityVH AS _FollowUpActivityVH ON CustRetItmFollowUpActivity = _FollowUpActivityVH.CustRetItmFollowUpActivity  -- association [0..1]
LEFT OUTER JOIN I_FollowUpActivityText AS _FollowUpActivityText ON CustRetItmFollowUpActivity = _FollowUpActivityText.CustRetItmFollowUpActivity  -- association [0..*]
LEFT OUTER JOIN I_RetMatlInspResultCodeText AS _InspectionCodeText ON InspectionCode = _InspectionCodeText.RetMatlInspResultCode  -- association [0..*]
LEFT OUTER JOIN C_CustomerReturnSupplierVH AS _SupplierVH ON Supplier = _SupplierVH.Supplier  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_AdvncdReturnsMgmtProcessItem AS _RetsMgmtProcItmWthProcgSts ON RetsMgmtProcess = _RetsMgmtProcItmWthProcgSts.RetsMgmtProcess AND CustomerReturnItem = _RetsMgmtProcItmWthProcgSts.RetsMgmtProcessItem  -- association [0..1]
LEFT OUTER JOIN P_CustRetItemScheduleLine AS _ScheduleLine ON CustomerReturn = _ScheduleLine.SalesDocument AND CustomerReturnItem = _ScheduleLine.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON CustomerReturnItem = _Extension.SalesDocumentItem AND CustomerReturn = _Extension.SalesDocument  -- association [0..1]
;