Fml_Relind_Bwkey

DDL: FML_RELIND_BWKEY SQL: FMLV_RELIND_BWKE Type: view

ML Relevant Indicators per Bwkey

Fml_Relind_Bwkey is a CDS View that provides data about "ML Relevant Indicators per Bwkey" in SAP S/4HANA. It reads from 14 data sources and exposes 14 fields.

Data Sources (14)

SourceAliasJoin Type
finsc_ld_cmp f from
t001k k inner
I_Ledger l inner
ckmlct mlb left_outer
ckmlct mlc left_outer
ckmlct mld left_outer
ckmlct mle left_outer
ckmlct mlf left_outer
ckmlct mlg left_outer
ckmlct mlh left_outer
ckmlct mlk left_outer
ckmlct mlo left_outer
ckmlct mlv left_outer
t001 t inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FMLV_RELIND_BWKE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
EndUserText.label ML Relevant Indicators per Bwkey view

Fields (14)

KeyFieldSource TableSource FieldDescription
mandt finsc_ld_cmp mandt Editing Client
rldnr finsc_ld_cmp rldnr Ledger (Compat.)
bukrs finsc_ld_cmp bukrs Value
bwkey t001k bwkey Valuation Area
curtph finsc_ld_cmp curtph Field Name
curtpk finsc_ld_cmp curtpk Field Name
curtpo finsc_ld_cmp curtpo FreeDef Crcy 1
curtpv finsc_ld_cmp curtpv FreeDef Crcy 2
curtpb finsc_ld_cmp curtpb FreeDef Crcy 3
curtpc finsc_ld_cmp curtpc FreeDef Crcy 4
curtpd finsc_ld_cmp curtpd FreeDef Crcy 5
curtpe finsc_ld_cmp curtpe FreeDef Crcy 6
curtpf finsc_ld_cmp curtpf FreeDef Crcy 7
curtpg finsc_ld_cmp curtpg FreeDef Crcy 8

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 Fml_Relind_Bwkey.
-- 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_RELIND_BWKE

CREATE VIEW Fml_Relind_Bwkey AS
SELECT
  f.mandt AS mandt,
  f.rldnr AS rldnr,
  f.bukrs AS bukrs,
  k.bwkey AS bwkey,
  f.curtph AS curtph,
  f.curtpk AS curtpk,
  f.curtpo AS curtpo,
  f.curtpv AS curtpv,
  f.curtpb AS curtpb,
  f.curtpc AS curtpc,
  f.curtpd AS curtpd,
  f.curtpe AS curtpe,
  f.curtpf AS curtpf,
  f.curtpg AS curtpg
FROM finsc_ld_cmp AS f
INNER JOIN t001 AS t ON /* join condition not captured in parsed metadata */
INNER JOIN t001k AS k ON /* join condition not captured in parsed metadata */
INNER JOIN I_Ledger AS l ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlct AS mlh ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlct AS mlk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlct AS mlo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlct AS mlv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlct AS mlb ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlct AS mlc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlct AS mld ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlct AS mle ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlct AS mlf ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlct AS mlg ON /* join condition not captured in parsed metadata */
;