C_CustomerReturnItemManageTP

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_CustomerReturnItemManageTP.
-- 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_CustomerReturnItemManageTP AS
SELECT
  cast (CustomerReturnItem.CustomerReturn as msr_returns_order preserving type) AS CustomerReturn,
  cast (CustomerReturnItem.CustomerReturnItem as msr_returns_order_item preserving type) AS CustomerReturnItem,
  CustomerReturnItem.HigherLevelItem AS HigherLevelItem,
  CustomerReturnItem.CustomerReturnItemCategory AS CustomerReturnItemCategory,
  CustomerReturnItem.CustomerReturnItemText AS CustomerReturnItemText,
  CustomerReturnItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CustomerReturnItem.Product AS Product,
  CustomerReturnItem.MaterialByCustomer AS MaterialByCustomer,
  CustomerReturnItem.ProductGroup AS ProductGroup,
  CustomerReturnItem.Batch AS Batch,
  CustomerReturnItem.RequestedQuantity AS RequestedQuantity,
  CustomerReturnItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  CustomerReturnItem.ItemNetWeight AS ItemNetWeight,
  CustomerReturnItem.ItemWeightUnit AS ItemWeightUnit,
  CustomerReturnItem.TransactionCurrency AS TransactionCurrency,
  CustomerReturnItem.NetAmount AS NetAmount,
  CustomerReturnItem.TaxAmount AS TaxAmount,
  CustomerReturnItem.PricingDate AS PricingDate,
  cast(CustomerReturnItem.ProductionPlant as wsubst_rec_plant preserving type) AS ProductionPlant,
  CustomerReturnItem.StorageLocation AS StorageLocation,
  cast(CustomerReturnItem.ShippingPoint as borgr_wanst preserving type) AS ShippingPoint,
  CustomerReturnItem.SDPricingProcedure AS SDPricingProcedure,
  CustomerReturnItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  CustomerReturnItem.ReturnReason AS ReturnReason,
  CustomerReturnItem.RetsMgmtProcessingBlock AS RetsMgmtProcessingBlock,
  CustomerReturnItem.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  cast(CustomerReturnItem.ReturnsMaterialHasBeenReceived as msr_product_received preserving type) AS ReturnsMaterialHasBeenReceived,
  CustomerReturnItem.CustRetItmInspectionText AS CustRetItmInspectionText,
  CustomerReturnItem.ReturnsRefundType AS ReturnsRefundType,
  CustomerReturnItem.ReturnsRefundProcgMode AS ReturnsRefundProcgMode,
  CustomerReturnItem.ReturnsRefundExtent AS ReturnsRefundExtent,
  CustomerReturnItem.RetsProdValnIsSuspended AS RetsProdValnIsSuspended,
  virtual RetsProdValnIsInvisible : boole_d AS virtualRetsProdValnIsInvisibleboole_d,
  CustomerReturnItem.ReplacementMaterial AS ReplacementMaterial,
  CustomerReturnItem.ReplacementMaterialQuantity AS ReplacementMaterialQuantity,
  CustomerReturnItem.ReplacementMaterialQtyUnit AS ReplacementMaterialQtyUnit,
  CustomerReturnItem.Supplier AS Supplier,
  CustomerReturnItem.SupplierName AS SupplierName,
  cast(CustomerReturnItem.ReturnToAddressID as msr_return_to_address preserving type) AS ReturnToAddressID,
  CustomerReturnItem.RetMatlInspResultCode AS RetMatlInspResultCode,
  cast(CustomerReturnItem.ProductIsInspectedAtCustSite as msr_inspection_at_cust_site preserving type) AS ProductIsInspectedAtCustSite,
  CustomerReturnItem.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  CustomerReturnItem.RetsMgmtItmLogProcgStatus AS RetsMgmtItmLogProcgStatus,
  virtual RetsMgmtLogProcgStsCritlty : int1 AS virtualRetsMgmtLogProcgStsCritltyint1,
  CustomerReturnItem.RetsMgmtItmCompnProcgStatus AS RetsMgmtItmCompnProcgStatus,
  virtual RetsMgmtCompnProcgStsCritlty : int1 AS virtualRetsMgmtCompnProcgStsCritltyint1,
  CustomerReturnItem.RetsMgmtItmProcgStatus AS RetsMgmtItmProcgStatus,
  virtual RetsMgmtProcgStsCritlty : int1 AS virtualRetsMgmtProcgStsCritltyint1,
  CustomerReturnItem.CustRetReleaseStatus AS CustRetReleaseStatus,
  virtual CustRetRelStsCritlty: int1 AS virtualCustRetRelStsCritltyint1,
  CustomerReturnItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  virtual SDDocRejectionStsCriticality : int1 AS virtualSDDocRejectionStsCriticalityint1,
  CustomerReturnItem.CustomerReturnType AS CustomerReturnType,
  CustomerReturnItem.SalesOrganization AS SalesOrganization,
  CustomerReturnItem.DistributionChannel AS DistributionChannel,
  CustomerReturnItem.OrganizationDivision AS OrganizationDivision,
  CustomerReturnItem._SDPricingProcedure AS _SDPricingProcedure,
  CustomerReturnItem._ProductGroup AS _ProductGroup,
  CustomerReturnItem._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason
FROM R_CustomerReturnItemTP
LEFT OUTER JOIN I_ProductStdVH AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _Plant ON ProductionPlant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND ProductionPlant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_ReturnReason AS _ReturnReason ON ReturnReason = _ReturnReason.ReturnReason  -- association [0..1]
LEFT OUTER JOIN I_FollowUpActivityVH AS _FollowUpActivity ON CustRetItmFollowUpActivity = _FollowUpActivity.CustRetItmFollowUpActivity  -- association [0..1]
LEFT OUTER JOIN I_ReturnsRefundType AS _ReturnsRefundType ON ReturnsRefundType = _ReturnsRefundType.ReturnsRefundType  -- association [0..1]
LEFT OUTER JOIN I_ReturnsRefundExtent AS _ReturnsRefundExtent ON ReturnsRefundExtent = _ReturnsRefundExtent.ReturnsRefundExtent  -- association [0..1]
LEFT OUTER JOIN I_RetMatlInspResultCode AS _RetMatlInspResultCode ON RetMatlInspResultCode = _RetMatlInspResultCode.RetMatlInspResultCode  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtCompnProcgStatus AS _RetsMgmtItmCompnProcgStatus ON RetsMgmtItmCompnProcgStatus = _RetsMgmtItmCompnProcgStatus.RetsMgmtCompnProcgStatus  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtProcgStatus AS _RetsMgmtItmLogProcgStatus ON RetsMgmtItmLogProcgStatus = _RetsMgmtItmLogProcgStatus.RetsMgmtProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtProcgStatus AS _RetsMgmtItmProcgStatus ON RetsMgmtItmProcgStatus = _RetsMgmtItmProcgStatus.RetsMgmtProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_CustRetReleaseStatus AS _ReleaseStatus ON CustRetReleaseStatus = _ReleaseStatus.CustRetReleaseStatus  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentRejectionStatus AS _SDDocumentRejectionStatus ON SDDocumentRejectionStatus = _SDDocumentRejectionStatus.SDDocumentRejectionStatus  -- association [0..1]
;