C_CustomerReturnItem_F1708

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_CustomerReturnItem_F1708.
-- 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.
-- SQL view name: CCUSTRTNITMF1708

CREATE VIEW C_CustomerReturnItem_F1708 AS
SELECT
  CustomerReturn,
  CustomerReturnItem,
  Material,
  MaterialGroup,
  ReturnReason,
  Batch,
  ReturnItem._RetsMgmtProcessItem._RetsMgmtProcItmWthProcgSts.RetsMgmtItmLogProcgStatus AS RetsMgmtItmLogProcgStatus,
  cast (ReturnItem._RetsMgmtProcessItem._RetsMgmtProcItmWthProcgSts._RetsMgmtItmLogProcgStatus._Text[1: Language=$session.system_language].RetsMgmtProcessingStatusDesc as return_log_procg_status_desc) AS RetsMgmtItmLogProcgStatusDesc,
  ReturnItem._RetsMgmtProcessItem._RetsMgmtProcItmWthProcgSts.RetsMgmtItmCompnProcgStatus AS RetsMgmtItmCompnProcgStatus,
  ReturnItem._RetsMgmtProcessItem._RetsMgmtProcItmWthProcgSts._RetsMgmtItmCompnProcgStatus._Text[1: Language=$session.system_language].RetsMgmtCompnProcgStatusDesc AS RetsMgmtCompnProcgStatusDesc,
  ReturnItem._RetsMgmtProcessItem._RetsMgmtProcItmWthProcgSts.RetsMgmtItmProcgStatus AS RetsMgmtItmProcgStatus,
  ReturnItem._RetsMgmtProcessItem._RetsMgmtProcItmWthProcgSts._RetsMgmtItmProcgStatus._Text[1: Language=$session.system_language].RetsMgmtProcessingStatusDesc AS RetsMgmtProcessingStatusDesc,
  cast(ReturnItem.OrderQuantity as menge_pos) AS OrderQuantity,
  ReturnItem.OrderQuantityUnit AS OrderQuantityUnit,
  ReturnItem._OrderQuantityUnit.UnitOfMeasureDimension AS UnitOfMeasureDimension,
  ReturnItem.NetAmount AS NetAmount,
  ReturnItem.TransactionCurrency AS Currency,
  ReturnItem._CustomerReturn.RequestedDeliveryDate AS DeliveryDate,
  cast(ReturnItem.Plant as wsubst_rec_plant) AS ProductionPlant,
  _Plant.PlantName AS PlantName,
  ReturnItem.MaterialByCustomer AS MaterialByCustomer,
  ReturnItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  ReturnItem.ReferenceSDDocument AS ReferenceSDDocument,
  ReturnItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  cast( ReturnItem.ShippingPoint as borgr_wanst) AS ShippingPoint,
  ReturnItem._RetsMgmtProcessItem._RetsMgmtProcItmRetOrdExec.ReturnsRefundType AS ReturnsRefundType,
  ReturnItem._RetsMgmtProcessItem._RetsMgmtProcItmRetOrdExec.ReturnsRefundProcgMode AS ReturnsRefundProcgMode,
  ReturnItem._RetsMgmtProcessItem._RetsMgmtProcItmRetOrdExec._ReturnsRefundProcgMode.ReturnsRefundProcgModeDesc AS ReturnsRefundProcgModeDesc,
  ReturnItem._RetsMgmtProcessItem._RetsMgmtProcItmRetOrdExec.ReturnsRefundExtent AS ReturnsRefundExtent,
  ReturnItem._RetsMgmtProcessItem._RetsMgmtProcItmInspExec.RetMatlInspResultCode AS RetMatlInspResultCode,
  SalesDocumentRjcnReason,
  ReturnItem._RetsMgmtProcessItem.ReturnsRefundRjcnReason AS ReturnsRefundRjcnReason,
  SDDocumentRejectionStatus,
  RetsMgmtProcessingBlock,
  ReturnItem._RetsMgmtProcessItem.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  ReturnItem._CustomerReturn.SalesOrganization AS SalesOrganization,
  ReturnItem._CustomerReturn.DistributionChannel AS DistributionChannel,
  cast('' as objky) AS LinkedSAPObjectKey,
  cast( ReturnItem.CustomerReturnItemUUID as abap.char( 32 )) AS CustomerReturnItemUUID
FROM I_CustomerReturnItem AS ReturnItem
LEFT OUTER JOIN I_AllwdPlantsPerSlsOrgVH AS _Plant_VH_F1708 ON ProductionPlant = _Plant_VH_F1708.Plant AND salesorganization = _Plant_VH_F1708.SalesOrganization AND distributionchannel = _Plant_VH_F1708.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnitValueHelp ON OrderQuantityUnit = _QuantityUnitValueHelp.UnitOfMeasure  -- 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_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 E_SalesDocumentItemBasic AS _Extension ON CustomerReturnItem = _Extension.SalesDocumentItem AND CustomerReturn = _Extension.SalesDocument  -- association [0..1]
;