Mmim_MatDocRvsdDocFlow

DDL: MMIM_MATDOCRVSDDOCFLOW SQL: MMIMMDOCRVSDFLOW Type: view
2 Fields 2 Data Sources

Material Documents Doc. Flow Reversed

Mmim_MatDocRvsdDocFlow is a CDS View that provides data about "Material Documents Doc. Flow Reversed" in SAP S/4HANA. It reads from 2 data sources (Mmim_MatDocCancDoclow, matdoc) and exposes 2 fields with key fields MaterialDocument, MaterialDocumentYear.

Data Sources (2)

SourceAliasJoin Type
Mmim_MatDocCancDoclow cancel inner
matdoc mat from

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName MMIMMDOCRVSDFLOW view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Material Documents Doc. Flow Reversed view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument Mmim_MatDocCancDoclow MaterialDocument Material Doc.
KEY MaterialDocumentYear matdoc sjahr Reversed Doc Year

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_MatDocRvsdDocFlow.
-- 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: MMIMMDOCRVSDFLOW

CREATE VIEW Mmim_MatDocRvsdDocFlow AS
SELECT
  cancel.MaterialDocument AS MaterialDocument,
  mat.sjahr AS MaterialDocumentYear
FROM matdoc AS mat
INNER JOIN Mmim_MatDocCancDoclow AS cancel ON /* join condition not captured in parsed metadata */
;

Learn More