Mmim_MatDocDocFlow

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 Mmim_MatDocDocFlow.
-- 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: MMIMMDOCDOCFLOW

CREATE VIEW Mmim_MatDocDocFlow AS
SELECT
  cast(matdoc.ebeln as mmim_preced_doc) AS PrecedingDocument,
  cast('0000' as char4) AS PrecedingDocumentYear,
  cast(matdoc.mblnr as mmim_subsequ_doc) AS SubsequentDocument,
  cast(matdoc.mjahr as char4) AS SubsequentDocumentYear,
  cast(ebelp as char20) AS PrecedingDocumentItem,
  cast(zeile as char20) AS SubsequentDocumentItem,
  matdoc.mblnr AS MaterialDocument,
  matdoc.mjahr AS MaterialDocumentYear,
  cast(zeile as char20) AS MaterialDocumentItem,
  cast('0000' as char4) AS FiscalYear,
  cast('M ' as char2) AS SubsequentDocumentCategory,
  cast('' as bukrs) as CompanyCode AS record_typeMDOCkeyPrecedingDocument,
  cast('M2' as char2) AS PrecedingDocumentCategory,
  cast('' as bukrs) AS CompanyCode
INNER JOIN ekko ON /* join condition not captured in parsed metadata */
INNER JOIN likp ON /* join condition not captured in parsed metadata */
INNER JOIN tvlk ON /* join condition not captured in parsed metadata */
INNER JOIN aufk AS o ON /* join condition not captured in parsed metadata */
INNER JOIN matdoc ON /* join condition not captured in parsed metadata */
INNER JOIN iseg AS pi_document_item ON /* join condition not captured in parsed metadata */
;