I_ARunAnlytsSalesReturns

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_ARunAnlytsSalesReturns.
-- 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_ARunAnlytsSalesReturns AS
SELECT
  SalesDocument AS RequirementDocumentNumber,
  SalesDocumentItem AS RequirementDocumentItem,
  cast ( '0000' as etenr) AS SupplyScheduleLine,
  'R' AS AssignedSupplyType,
  'R' AS SupAssgmtSource,
  cast( _SalesDocument.RequestedDeliveryDate as edatu_vbak) AS SupplyDeliveryDate,
  cast( _SalesDocument.RequestedDeliveryDate as edatu_vbak) AS ProductAvailabilityDate,
  cast( _SalesDocument.RequestedDeliveryDate as edatu_vbak) AS RequestedDeliveryDate,
  cast( SalesDocumentItem.OrderQuantity as ovr_conf_so_sl_qty ) AS TotalQuantity,
  cast( SalesDocumentItem.OrderQuantity as abap.quan( 16,3 ) ) AS OpenSupplyQuantity,
  SalesDocumentItem.BaseUnit AS BaseUnit,
  SalesDocumentItem.Material AS Product,
  SalesDocumentItem.MaterialGroup AS ProductGroup,
  SalesDocumentItem.Plant AS Plant,
  SalesDocumentItem.SalesDocumentType AS OrderType,
  marc.MaterialType AS ProductType,
  SalesDocumentItem.RequirementSegment AS StockSegment,
  marc.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  _SalesDocument.SalesOrganization AS SalesOrganization,
  _SalesDocument.DistributionChannel AS DistributionChannel,
  _SalesDocument.OrganizationDivision AS Division,
  SalesDocumentItem.SalesDistrict AS SalesDistrict,
  cast('' as ekorg ) AS PurchasingOrganization,
  cast('' as ekgrp ) AS PurchasingGroup,
  cast('' as charg_d ) AS Batch,
  cast('' as lgort_d ) AS StorageLocation,
  cast('' as kunnr ) AS Customer,
  _SalesDocument.BillingCompanyCode AS CompanyCode,
  SalesDocumentItem.SDDocumentReason AS SDDocumentReason,
  SalesDocumentItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  SalesDocumentItem.NetPriceAmount AS NetPriceAmount,
  SalesDocumentItem.TransactionCurrency AS DocumentCurrency,
  SalesDocumentItem.NetAmount AS NetAmount,
  SalesDocumentItem.RequirementSegment AS RequirementSegment,
  SalesDocumentItem.RequestedQuantityInBaseUnit AS RequestedRqmtQtyInBaseUnit,
  SalesDocumentItem._SalesDocument.SalesOffice AS SalesOffice,
  SalesDocumentItem._SalesDocument.SalesGroup AS SalesGroup,
  SalesDocumentItem._SalesDocument.SoldToParty AS SoldToParty,
  SalesDocumentItem.FashionCancelDate AS FashionCancelDate,
  SalesDocumentItem.ProductSeasonYear AS ProductSeasonYear,
  SalesDocumentItem.ProductSeason AS ProductSeason,
  SalesDocumentItem.ProductCollection AS ProductCollection,
  SalesDocumentItem.ProductTheme AS ProductTheme,
  SalesDocumentItem.ProductCharacteristic1 AS ProductCharacteristic1,
  SalesDocumentItem.ProductCharacteristic2 AS ProductCharacteristic2,
  SalesDocumentItem.ProductCharacteristic3 AS ProductCharacteristic3
FROM I_SalesDocumentItem AS SalesDocumentItem
INNER JOIN I_SupDmndMaterialPlant AS marc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON RequirementDocumentNumber = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON RequirementDocumentNumber = _SalesDocumentItem.SalesDocument AND RequirementDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON ProductGroup = _ProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_Producttype AS _ProductType ON ProductType = _ProductType.ProductType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrg ON SalesOrganization = _SalesOrg.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistrChnl ON DistributionChannel = _DistrChnl.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Divn ON Division = _Divn.Division  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDist ON SalesDistrict = _SalesDist.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
;