A_CustomerReturnItem

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 A_CustomerReturnItem.
-- 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 A_CustomerReturnItem AS
SELECT
  CustomerReturn,
  CustomerReturnItem,
  HigherLevelItem,
  CustomerReturnItemCategory,
  CustomerReturnItemText,
  PurchaseOrderByCustomer,
  PurchaseOrderByShipToParty,
  CorrespncExternalReference,
  CorrespncExtRefByShipToParty,
  UnderlyingPurchaseOrderItem,
  UndrlgPurOrdItmByShipToParty,
  CustomerPurchaseOrderType,
  CustPurOrdTypeByShipToParty,
  Material,
  MaterialByCustomer,
  RequestedQuantity,
  RequestedQuantityUnit,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  TransactionCurrency,
  NetAmount,
  PricingDate,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  MaterialGroup,
  Batch,
  Plant AS ProductionPlant,
  StorageLocation,
  ShippingPoint,
  ShippingType,
  DeliveryPriority,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  CustomerPaymentTerms,
  ProductTaxClassification1,
  ProductTaxClassification2,
  ProductTaxClassification3,
  ProductTaxClassification4,
  ProductTaxClassification5,
  ProductTaxClassification6,
  ProductTaxClassification7,
  ProductTaxClassification8,
  ProductTaxClassification9,
  SalesDocumentRjcnReason,
  ItemBillingBlockReason,
  ProfitCenter,
  _WBSElementBasicData_2.WBSElementExternalID AS WBSElementExternalID,
  RetsMgmtProcess,
  RetsMgmtProcessItem,
  ReturnReason,
  RetsMgmtProcessingBlock,
  CustRetItmFollowUpActivity,
  ReturnsMaterialHasBeenReceived,
  ReturnsRefundType,
  ReturnsRefundProcgMode,
  cast (RetsProdValnIsSuspended as abap.char(1)) AS RetsProdValnIsSuspended,
  ReturnsRefundExtent,
  cast (PrelimRefundIsDetermined as abap.char(1)) AS PrelimRefundIsDetermined,
  ReturnsRefundRjcnReason,
  ReplacementMaterial,
  ReplacementMaterialQuantity,
  ReplacementMaterialQtyUnit,
  cast (ReplacementMaterialIsRequested as abap.char(1)) AS ReplacementMaterialIsRequested,
  ReplacementMatlSupplyingPlant,
  NextPlantForFollowUpActivity,
  ReturnsTransshipmentPlant,
  Supplier,
  SupplierRetMatlAuthzn,
  cast (SuplrRetMatlAuthznIsRequired as abap.char(1)) AS SuplrRetMatlAuthznIsRequired,
  CustomerRetMatlInspResultCode,
  NextFllwUpActivityForMatlInsp,
  RetMatlInspResultCode,
  cast (ProductIsInspectedAtCustSite as abap.char(1)) AS ProductIsInspectedAtCustSite,
  CustRetMatlAuthzn,
  CRMLogicalSystem,
  CRMObjectUUID,
  CRMObjectID,
  CRMObjectType,
  RetsMgmtItmLogProcgStatus,
  RetsMgmtItmCompnProcgStatus,
  RetsMgmtItmProcgStatus,
  ReturnsDocumentStatus,
  ReturnsDocumentApprovalStatus,
  SDProcessStatus,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  SDDocumentRejectionStatus,
  SalesDocumentBasic.SalesDocumentType AS CustomerReturnType,
  SalesDocumentBasic.OrganizationDivision AS OrganizationDivision,
  SalesDocumentBasic.SalesOrganization AS SalesOrganization,
  SalesDocumentBasic.DistributionChannel AS DistributionChannel
FROM I_CustomerReturnItemEnhanced AS Item
LEFT OUTER JOIN I_SalesDocumentBasic AS SalesDocumentBasic ON SalesDocumentBasic.SalesDocument = CustomerReturn  -- association [1..1]
LEFT OUTER JOIN A_CustomerReturn AS _CustomerReturn ON _CustomerReturn.CustomerReturn = CustomerReturn  -- association [1..1]
LEFT OUTER JOIN A_CustomerReturnScheduleLine AS _ScheduleLine ON _ScheduleLine.CustomerReturn = CustomerReturn AND _ScheduleLine.CustomerReturnItem = CustomerReturnItem  -- association [0..*]
LEFT OUTER JOIN A_CustomerReturnSerialNumber AS _SerialNumber ON _SerialNumber.CustomerReturn = CustomerReturn AND _SerialNumber.CustomerReturnItem = CustomerReturnItem  -- association [0..*]
LEFT OUTER JOIN A_CustomerReturnItemPartner AS _Partner ON _Partner.CustomerReturn = CustomerReturn AND _Partner.CustomerReturnItem = CustomerReturnItem  -- association [0..*]
LEFT OUTER JOIN A_CustomerReturnItemText AS _Text ON _Text.CustomerReturn = CustomerReturn AND _Text.CustomerReturnItem = CustomerReturnItem  -- association [0..*]
LEFT OUTER JOIN A_CustomerReturnItemRelatedObj AS _RelatedObject ON _RelatedObject.CustomerReturn = CustomerReturn AND _RelatedObject.CustomerReturnItem = CustomerReturnItem  -- association [0..*]
LEFT OUTER JOIN A_CustomerReturnItemPrcgElmnt AS _PricingElement ON _PricingElement.CustomerReturn = CustomerReturn AND _PricingElement.CustomerReturnItem = CustomerReturnItem  -- association [0..*]
LEFT OUTER JOIN A_CustomerReturnProcessStep AS _ProcessStep ON _ProcessStep.RetsMgmtProcess = RetsMgmtProcess AND _ProcessStep.RetsMgmtProcessItem = CustomerReturnItem  -- association [0..*]
LEFT OUTER JOIN A_CustomerReturnValAddedSrvc AS _ValueAddedService ON _ValueAddedService.CustomerReturn = CustomerReturn AND _ValueAddedService.CustomerReturnItem = CustomerReturnItem  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON CustomerReturn = _Extension.SalesDocument AND CustomerReturnItem = _Extension.SalesDocumentItem  -- association [0..1]
;