A_MaterialDocumentHeader

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_MaterialDocumentHeader.
-- 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: AMATDOCHEAD

CREATE VIEW A_MaterialDocumentHeader AS
SELECT
  Header.MaterialDocumentYear AS MaterialDocumentYear,
  Header.MaterialDocument AS MaterialDocument,
  Header.InventoryTransactionType AS InventoryTransactionType,
  Header.DocumentDate AS DocumentDate,
  Header.PostingDate AS PostingDate,
  Header.CreationDate AS CreationDate,
  Header.CreationTime AS CreationTime,
  Header.CreatedByUser AS CreatedByUser,
  Header.MaterialDocumentHeaderText AS MaterialDocumentHeaderText,
  Header.ReferenceDocument AS ReferenceDocument,
  Header.VersionForPrintingSlip AS VersionForPrintingSlip,
  Header.ManualPrintIsTriggered AS ManualPrintIsTriggered,
  Header.CtrlPostgForExtWhseMgmtSyst AS CtrlPostgForExtWhseMgmtSyst,
  P_GoodsMovementCode.GoodsMovementCode AS GoodsMovementCode,
  Header.Plant AS Plant,
  Header.StorageLocation AS StorageLocation,
  Header.IssuingOrReceivingPlant AS IssuingOrReceivingPlant,
  Header.IssuingOrReceivingStorageLoc AS IssuingOrReceivingStorageLoc
FROM I_GoodsMovementDocument AS Header
LEFT OUTER JOIN A_MaterialDocumentItem AS _MaterialDocumentItem ON MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear AND MaterialDocument = _MaterialDocumentItem.MaterialDocument  -- association [1..*]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _IssuingOrReceivingStorageLoc ON IssuingOrReceivingStorageLoc = _IssuingOrReceivingStorageLoc.StorageLocation AND IssuingOrReceivingPlant = _IssuingOrReceivingStorageLoc.Plant  -- association [0..1]
;