MDCV_E_T438M

DDL: MDCV_DDL_T438M SQL: MDCV_V_T438M Type: view
7 Fields 1 Data Sources

Compatibility View for T438M

MDCV_E_T438M is a CDS View that provides data about "Compatibility View for T438M" in SAP S/4HANA. It reads from 1 data source (t438m) and exposes 7 fields with key fields werks, mtart.

Data Sources (1)

SourceAliasJoin Type
t438m t438m from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName MDCV_V_T438M view
EndUserText.label Compatibility View for T438M view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 001 view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY werks t438m werks Receiving Plant
KEY mtart t438m mtart Product Type
baner
constantXkzdrb
defaultXxfat2
defaultspace
exsgt

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 MDCV_E_T438M.
-- 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: MDCV_V_T438M

CREATE VIEW MDCV_E_T438M AS
SELECT
  t438m.werks AS werks,
  t438m.mtart AS mtart,
  case when t438m.baner is null then cast(' ' as baner) else baner end AS baner,
  case when t438m.exsgt is null then cast(' ' as exsgd) else exsgt end AS exsgt
FROM t438m
;

Learn More