Mmim_MatDocFlowStatusPI

DDL: MMIM_MATDOCFLOWSTATUSPI SQL: MMIMMDOCFLWSTAPI Type: view
3 Fields 1 Data Sources

Status of Physical Inventory Documents

Mmim_MatDocFlowStatusPI is a CDS View that provides data about "Status of Physical Inventory Documents" in SAP S/4HANA. It reads from 1 data source (ikpf) and exposes 3 fields with key fields PhysicalInventoryDocument, FiscalYear.

Data Sources (1)

SourceAliasJoin Type
ikpf ikpf from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName MMIMMDOCFLWSTAPI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Status of Physical Inventory Documents view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
DataAging.noAgingRestriction true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PhysicalInventoryDocument
KEY FiscalYear ikpf gjahr Settlement Year
Status ikpf dstat Print Status

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_MatDocFlowStatusPI.
-- 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: MMIMMDOCFLWSTAPI

CREATE VIEW Mmim_MatDocFlowStatusPI AS
SELECT
  cast(ikpf.iblnr as pi_item_document preserving type) AS PhysicalInventoryDocument,
  ikpf.gjahr AS FiscalYear,
  ikpf.dstat AS Status
FROM ikpf
;

Learn More