I_FldLogsMaterialBatch

DDL: I_FLDLOGSMATERIALBATCH SQL: IFLDMATBAT Type: view BASIC

Interface for material batch

I_FldLogsMaterialBatch is a Basic CDS View that provides data about "Interface for material batch" in SAP S/4HANA. It reads from 1 data source (marc) and exposes 3 fields with key fields Material, Plant.

Data Sources (1)

SourceAliasJoin Type
marc _mat from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFLDMATBAT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Interface for material batch view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Material marc matnr Vehicle Model
KEY Plant marc werks Receiving Plant
IsInternalBatchManaged marc xchar HU assignment

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_FldLogsMaterialBatch.
-- 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: IFLDMATBAT

CREATE VIEW I_FldLogsMaterialBatch AS
SELECT
  _mat.matnr AS Material,
  _mat.werks AS Plant,
  _mat.xchar AS IsInternalBatchManaged
FROM marc AS _mat
;