F2_Mmim_Batchmat_Vh

DDL: F2_MMIM_BATCHMAT_VH SQL: F2MMIMBATCHMATVH Type: view

Help-View for batches with material

F2_Mmim_Batchmat_Vh is a CDS View that provides data about "Help-View for batches with material" in SAP S/4HANA. It reads from 1 data source (F_Mmim_Matdoc) and exposes 3 fields with key fields Batch, Material, Plant.

Data Sources (1)

SourceAliasJoin Type
F_Mmim_Matdoc F_Mmim_Matdoc from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName F2MMIMBATCHMATVH view
EndUserText.label Help-View for batches with material view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Batch Batch Lot No.
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area

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 F2_Mmim_Batchmat_Vh.
-- 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: F2MMIMBATCHMATVH

CREATE VIEW F2_Mmim_Batchmat_Vh AS
SELECT
  Batch,
  Material,
  Plant
FROM F_Mmim_Matdoc
;