I_MaterialLedgerDocument

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_MaterialLedgerDocument.
-- 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: IMLDOCHEADER

CREATE VIEW I_MaterialLedgerDocument AS
SELECT
  belnr AS MaterialLedgerDocument,
  kjahr AS MaterialLedgerDocumentYear,
  vgart AS MaterialLedgerTransactionType,
  ldgrp AS LedgerGroup,
  awtyp AS ReferenceDocumentType,
  awref AS ReferenceDocument,
  cast(aworg as fis_aworg preserving type) AS ReferenceDocumentContext,
  cast(awsys as fis_awsys preserving type) AS ReferenceDocumentLogicalSystem,
  storno AS IsReversalDocument,
  cast(bldat as fis_bldat preserving type) AS DocumentDate,
  cast(cpudt as fis_cpdat preserving type) AS CreationDate,
  cast(cputm as ttet_dt_cr_time preserving type) AS CreationTime,
  cast(usnam as vdm_createdbyuserid preserving type) AS CreatedByUser,
  tcode AS ExecutedTransaction,
  cast(glvor as fins_custbttype preserving type) AS BusinessTransactionType,
  logsys AS LogicalSystem,
  bktxt AS DocumentHeaderText,
  kongr AS MatlPrChgAcctDetnDiffntnRsn
FROM P_MaterialLedgerDocumentHeader
LEFT OUTER JOIN I_MatlPrChgAcctDetnDiffntnRsnT AS _Text ON MatlPrChgAcctDetnDiffntnRsn = _Text.MatlPrChgAcctDetnDiffntnRsn  -- association [0..*]
;