I_AlignAcctAssgdSlsItmSl

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_AlignAcctAssgdSlsItmSl.
-- 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: IALIGNAASLSITMSL

CREATE VIEW I_AlignAcctAssgdSlsItmSl AS
SELECT
  _HeaderItem.SalesDocument AS SalesDocument,
  _HeaderItem.SalesDocumentItem AS SalesDocumentItem,
  _Schedule[1:inner].ScheduleLine AS ScheduleLine,
  BillOfMaterial,
  SalesDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldToParty,
  ShipToParty,
  OrganizationBPName1,
  Product,
  _ProductName.ProductName AS ProductName,
  HigherLevelItem,
  ProductOfHigherLevelItem,
  _Product[1:inner].ProductCategory AS ProductCategory,
  _Schedule[1:inner].ScheduleLineCategory AS ScheduleLineCategory,
  _Schedule[1:inner].SalesAccountAssignmentType AS SalesAccountAssignmentType,
  CrossPlantConfigurableProduct,
  _Material.ProdCharc1InternalNumber AS ProdCharc1InternalNumber,
  _Material.ProductCharacteristic1 AS ProductCharacteristic1,
  _Material.ProductCharacteristic2 AS ProductCharacteristic2,
  _Material.ProdCharc2InternalNumber AS ProdCharc2InternalNumber,
  _Material.ProductCharacteristic3 AS ProductCharacteristic3,
  _Material.ProdCharc3InternalNumber AS ProdCharc3InternalNumber,
  SalesOffice,
  SDDocumentReason,
  CreationDate,
  FashionCancelDate,
  DeliveryPriority
FROM I_AlignSlsOrdHdrItm AS _HeaderItem
LEFT OUTER JOIN I_AlignSlsOrdAcctAssgdSl AS _Schedule ON SalesDocument = _Schedule.SalesDocument AND SalesDocumentItem = _Schedule.SalesDocumentItem  -- association [1..*]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Product = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_ProductCategoryText AS _ProductCategory ON productcategory = _ProductCategory.ProductCategory AND _ProductCategory.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _ProdCharc1ValueT ON _Material.ProdCharc1InternalNumber = _ProdCharc1ValueT.CharacteristicInternalID AND _ProdCharc1ValueT.RetailCharacteristicValue = _Material.ProductCharacteristic1 AND _ProdCharc1ValueT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _ProdCharc2ValueT ON _Material.ProdCharc2InternalNumber = _ProdCharc2ValueT.CharacteristicInternalID AND _ProdCharc2ValueT.RetailCharacteristicValue = _Material.ProductCharacteristic2 AND _ProdCharc2ValueT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _ProdCharc3ValueT ON _Material.ProdCharc3InternalNumber = _ProdCharc3ValueT.CharacteristicInternalID AND _ProdCharc3ValueT.RetailCharacteristicValue = _Material.ProductCharacteristic3 AND _ProdCharc3ValueT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductName ON Product = _ProductName.Product AND _ProductName.Language = $session.system_language  -- association [0..1]
;