C_ReturnRefDocItem_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_ReturnRefDocItem_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: CRTNRDOCITMF1708

CREATE VIEW C_ReturnRefDocItem_F1708 AS
SELECT
  SalesDocumentItem.SalesDocument AS ReturnsReferenceDocument,
  SalesDocumentItem AS ReturnsReferenceDocumentItem,
  SalesDocumentItem.SalesDocument AS SalesDocument,
  SalesDocumentItem,
  cast(SalesDocumentItem.OrderQuantity as original_quantity) AS OrderQuantity,
  SalesDocumentItem.Material AS Material,
  SalesDocumentItem.MaterialGroup AS MaterialGroup,
  SalesDocumentItem.NetAmount AS NetAmount,
  SalesDocumentItem.TransactionCurrency AS Currency,
  SalesDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  SalesDocumentItem.SDDocumentCategory AS SDDocumentCategory,
  SalesDocumentItem.Plant AS ProductionPlant,
  SalesDocumentItem._Plant.PlantName AS PlantName,
  SalesDocumentItem.Batch AS Batch,
  SalesDocumentItem._SalesDocument.RequestedDeliveryDate AS DeliveryDate,
  SalesDocumentItem.MaterialByCustomer AS MaterialByCustomer,
  SalesDocumentItem.OrderQuantityUnit AS ReturnQuantityUnit,
  cast(0 as kwmeng) AS ReturnQuantity,
  SalesDocumentItem.ShippingPoint AS ShippingPoint,
  SalesDocumentItem._SalesDocument.OrganizationDivision AS OrganizationDivision,
  SalesDocumentItem._SalesDocument.SalesOrganization AS SalesOrganization,
  SalesDocumentItem._SalesDocument.DistributionChannel AS DistributionChannel
FROM I_SalesDocumentItem AS SalesDocumentItem
INNER JOIN I_SalesDocument AS SalesDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesDocumentCopyControl AS SalesDocumentCopyControl ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillingDocument AS BillingDocument ON /* join condition not captured in parsed metadata */
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_SDDocumentCategoryText AS _SDDocumentCategoryText ON SDDocumentCategory = _SDDocumentCategoryText.SDDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_ShippingPointText AS _ShippingPointText ON ShippingPoint = _ShippingPointText.ShippingPoint  -- association [0..*]
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..*]
-- UNION with additional select branch(es): I_BillingDocumentItem
;