FMLV_F4_MARV

DDL: FMLV_F4_MARV SQL: FMLVF4MARV Type: view
7 Fields 3 Data Sources

Select relevant fiscal period

FMLV_F4_MARV is a CDS View that provides data about "Select relevant fiscal period" in SAP S/4HANA. It reads from 3 data sources (marv, marv, marv) and exposes 7 fields with key field bukrs.

Data Sources (3)

SourceAliasJoin Type
marv m from
marv m union
marv m union

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FMLVF4MARV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Select relevant fiscal period view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY bukrs marv bukrs Value
BDATJ
bukrsasbukrs
BDATJ
bukrsasbukrs
BDATJ
POPER

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 FMLV_F4_MARV.
-- 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: FMLVF4MARV

CREATE VIEW FMLV_F4_MARV AS
SELECT
  m.bukrs AS bukrs,
  cast ( m.lfgja as bdatj) AS BDATJ,
  cast ( substring(m.lfmon, 1, 2) as poper) as POPER AS bukrsasbukrs,
  cast ( substring(m.vjmon, 1, 2) as poper) AS POPER
FROM marv AS m
-- UNION with additional select branch(es): marv
;

Learn More