I_RO_SAFTMatlDocHeader

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_RO_SAFTMatlDocHeader.
-- 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_RO_SAFTMatlDocHeader AS
SELECT
  _Matdoc.MaterialDocument AS MaterialDocument,
  _Matdoc.MaterialDocumentYear AS MaterialDocumentYear,
  _Matdoc.CompanyCode AS CompanyCode,
  _Matdoc.CreatedByUser AS CreatedByUser,
  _Matdoc.PostingDate AS PostingDate,
  _Matdoc.DocumentDate AS DocumentDate,
  _AccountingDocumentText.AccountingDocumentTypeName AS AccountingDocumentTypeName
INNER JOIN I_AccountingDocument AS _AccountingDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_RO_SAFTDocumentTypeMap AS _DocumentMap ON /* join condition not captured in parsed metadata */
INNER JOIN I_Product AS _Product ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RO_SAFTGoodsService AS _GoodsService ON _GoodsService.MaterialType = _Product.ProductType  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentText ON _AccountingDocumentText.AccountingDocumentType = _Matdoc.AccountingDocumentType AND _AccountingDocumentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType1 ON _MovementType1.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType1.Plant = _Matdoc.Plant AND _MovementType1.TargetGLAccount = '' AND _MovementType1.AccountingDocumentType = _Matdoc.AccountingDocumentType AND _MovementType1.DebitCreditCode = _Matdoc.DebitCreditCode AND _MovementType1.ValuationClass = ''  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType2 ON _MovementType2.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType2.Plant = _Matdoc.Plant AND _MovementType2.TargetGLAccount = '' AND _MovementType2.AccountingDocumentType = _Matdoc.AccountingDocumentType AND _MovementType2.DebitCreditCode = '' AND _MovementType2.ValuationClass = ''  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType3 ON _MovementType3.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType3.Plant = _Matdoc.Plant AND _MovementType3.TargetGLAccount = '' AND _MovementType3.AccountingDocumentType = '' AND _MovementType3.DebitCreditCode = '' AND _MovementType3.ValuationClass = ''  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType4 ON _MovementType4.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType4.Plant = _Matdoc.Plant AND _MovementType4.TargetGLAccount = '' AND _MovementType4.AccountingDocumentType = '' AND _MovementType4.DebitCreditCode = _Matdoc.DebitCreditCode AND _MovementType4.ValuationClass = ''  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType5 ON _MovementType5.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType5.Plant = '' AND _MovementType5.TargetGLAccount = '' AND _MovementType5.AccountingDocumentType = '' AND _MovementType5.DebitCreditCode = '' AND _MovementType5.ValuationClass = ''  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType6 ON _MovementType6.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType6.Plant = _Matdoc.Plant AND _MovementType6.TargetGLAccount = '' AND _MovementType6.AccountingDocumentType = _Matdoc.AccountingDocumentType AND _MovementType6.DebitCreditCode = _Matdoc.DebitCreditCode AND _MovementType6.ValuationClass = _Matdoc.ValuationClass  -- association [0..1]
;