v_fml_accnt_det

DDL: FML_ACCNT_DETERM SQL: FMLV_ACCNT_DET Type: view
6 Fields 2 Data Sources

Account determination for material inventory

v_fml_accnt_det is a CDS View that provides data about "Account determination for material inventory" in SAP S/4HANA. It reads from 2 data sources (t030, t030r) and exposes 6 fields.

Data Sources (2)

SourceAliasJoin Type
t030 t from
t030r tr inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName FMLV_ACCNT_DET view
ClientDependent true view
AbapCatalog.compiler.CompareFilter true view
EndUserText.label Account determination for material inventory view

Fields (6)

KeyFieldSource TableSource FieldDescription
mandt t030 mandt Editing Client
ktopl t030 ktopl G/L Chart of Accounts
bwmod t030 bwmod Val.Grpg Code
xbwmo t030r xbwmo Valuation Mod.
bklas t030 bklas Valuation Class
konts t030 konts Sales Reduction (Dr)

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 v_fml_accnt_det.
-- 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: FMLV_ACCNT_DET

CREATE VIEW v_fml_accnt_det AS
SELECT
  t.mandt AS mandt,
  t.ktopl AS ktopl,
  t.bwmod AS bwmod,
  tr.xbwmo AS xbwmo,
  t.bklas AS bklas,
  t.konts AS konts
FROM t030 AS t
INNER JOIN t030r AS tr ON /* join condition not captured in parsed metadata */
;

Learn More