I_CustomerReturnItemTP

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 I_CustomerReturnItemTP.
-- 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 I_CustomerReturnItemTP AS
SELECT
  CustomerReturnItem.CustomerReturn AS CustomerReturn,
  CustomerReturnItem.CustomerReturnItem 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.ItemGrossWeight AS ItemGrossWeight,
  CustomerReturnItem.ItemNetWeight AS ItemNetWeight,
  CustomerReturnItem.ItemWeightUnit AS ItemWeightUnit,
  CustomerReturnItem.ItemVolume AS ItemVolume,
  CustomerReturnItem.ItemVolumeUnit AS ItemVolumeUnit,
  CustomerReturnItem.NetAmount AS NetAmount,
  CustomerReturnItem.TransactionCurrency AS TransactionCurrency,
  CustomerReturnItem.ProductionPlant AS ProductionPlant,
  CustomerReturnItem.Plant AS Plant,
  CustomerReturnItem.StorageLocation AS StorageLocation,
  CustomerReturnItem.ShippingPoint AS ShippingPoint,
  CustomerReturnItem.DeliveryPriority AS DeliveryPriority,
  CustomerReturnItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  CustomerReturnItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  CustomerReturnItem.ProfitCenter AS ProfitCenter,
  CustomerReturnItem.IncotermsClassification AS IncotermsClassification,
  CustomerReturnItem.IncotermsTransferLocation AS IncotermsTransferLocation,
  CustomerReturnItem.IncotermsLocation1 AS IncotermsLocation1,
  CustomerReturnItem.IncotermsLocation2 AS IncotermsLocation2,
  CustomerReturnItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  CustomerReturnItem.RetsMgmtProcess AS RetsMgmtProcess,
  CustomerReturnItem.RetsMgmtProcessItem AS RetsMgmtProcessItem,
  CustomerReturnItem.ReturnReason AS ReturnReason,
  CustomerReturnItem.RetsMgmtProcessingBlock AS RetsMgmtProcessingBlock,
  CustomerReturnItem.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  CustomerReturnItem.ReturnsMaterialHasBeenReceived AS ReturnsMaterialHasBeenReceived,
  CustomerReturnItem.CustRetItmCustomerText AS CustRetItmCustomerText,
  CustomerReturnItem.CustRetItmInspectionText AS CustRetItmInspectionText,
  CustomerReturnItem.ReturnsRefundType AS ReturnsRefundType,
  CustomerReturnItem.ReturnsRefundProcgMode AS ReturnsRefundProcgMode,
  CustomerReturnItem.ReturnsRefundExtent AS ReturnsRefundExtent,
  CustomerReturnItem.PrelimRefundIsDetermined AS PrelimRefundIsDetermined,
  CustomerReturnItem.ReturnsRefundRjcnReason AS ReturnsRefundRjcnReason,
  CustomerReturnItem.ReplacementMaterial AS ReplacementMaterial,
  CustomerReturnItem.ReplacementMaterialQuantity AS ReplacementMaterialQuantity,
  CustomerReturnItem.ReplacementMaterialQtyUnit AS ReplacementMaterialQtyUnit,
  CustomerReturnItem.ReplacementMaterialIsRequested AS ReplacementMaterialIsRequested,
  CustomerReturnItem.ReplacementMatlSupplyingPlant AS ReplacementMatlSupplyingPlant,
  CustomerReturnItem.NextPlantForFollowUpActivity AS NextPlantForFollowUpActivity,
  CustomerReturnItem.ReturnsTransshipmentPlant AS ReturnsTransshipmentPlant,
  CustomerReturnItem.Supplier AS Supplier,
  CustomerReturnItem.SupplierRetMatlAuthzn AS SupplierRetMatlAuthzn,
  CustomerReturnItem.SuplrRetMatlAuthznIsRequired AS SuplrRetMatlAuthznIsRequired,
  CustomerReturnItem.CustomerRetMatlInspResultCode AS CustomerRetMatlInspResultCode,
  CustomerReturnItem.NextFllwUpActivityForMatlInsp AS NextFllwUpActivityForMatlInsp,
  CustomerReturnItem.RetMatlInspResultCode AS RetMatlInspResultCode,
  CustomerReturnItem.ProductIsInspectedAtCustSite AS ProductIsInspectedAtCustSite,
  CustomerReturnItem.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  CustomerReturnItem.CRMLogicalSystem AS CRMLogicalSystem,
  CustomerReturnItem.CRMObjectUUID AS CRMObjectUUID,
  CustomerReturnItem.CRMObjectID AS CRMObjectID,
  CustomerReturnItem.CRMObjectType AS CRMObjectType,
  CustomerReturnItem.RetsMgmtItmLogProcgStatus AS RetsMgmtItmLogProcgStatus,
  CustomerReturnItem.RetsMgmtItmCompnProcgStatus AS RetsMgmtItmCompnProcgStatus,
  CustomerReturnItem.RetsMgmtItmProcgStatus AS RetsMgmtItmProcgStatus,
  CustomerReturnItem.ReturnsDocumentStatus AS ReturnsDocumentStatus,
  CustomerReturnItem.ReturnsDocumentApprovalStatus AS ReturnsDocumentApprovalStatus,
  CustomerReturnItem.ReferenceSDDocument AS ReferenceSDDocument,
  CustomerReturnItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  CustomerReturnItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  CustomerReturnItem.SDProcessStatus AS SDProcessStatus,
  CustomerReturnItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  CustomerReturnItem.CustomerReturnType AS CustomerReturnType,
  CustomerReturnItem.SalesOrganization AS SalesOrganization,
  CustomerReturnItem.DistributionChannel AS DistributionChannel,
  CustomerReturnItem.OrganizationDivision AS OrganizationDivision
FROM R_CustomerReturnItemTP
;