FMLV_XBEW_CKMLCR_SALKV

DDL: FMLV_XBEW_CKMLCR_SALKV SQL: FMLVXBEWCR Type: view

CompatView for XBEW Redirect Tables

FMLV_XBEW_CKMLCR_SALKV is a CDS View that provides data about "CompatView for XBEW Redirect Tables" in SAP S/4HANA. It reads from 5 data sources (ckmlcr, fmlv_logistic_currency, fmlt_price, R_MatlPriceDataMigrationStatus, R_MatlPriceDataMigrationStatus) and exposes 7 fields with key fields kalnr, bdatj, lfmonp, bdatj, lfmonp.

Data Sources (5)

SourceAliasJoin Type
ckmlcr cr from
fmlv_logistic_currency lcurtp inner
fmlt_price n union_all
R_MatlPriceDataMigrationStatus tf inner
R_MatlPriceDataMigrationStatus tf inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FMLVXBEWCR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.serviceQuality #P view
EndUserText.label CompatView for XBEW Redirect Tables view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY kalnr ckmlcr kalnr ProdCostEst.No.
KEY bdatj bdatj To FY
KEY lfmonp poper To Period
kalnr ProdCostEst.No.
KEY bdatj gjahr_to To FY
KEY lfmonp period_to To Period
salkv fmlt_price salkv_compat Value/MA price

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_XBEW_CKMLCR_SALKV.
-- 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: FMLVXBEWCR

CREATE VIEW FMLV_XBEW_CKMLCR_SALKV AS
SELECT
  cr.kalnr AS kalnr,
  bdatj,
  poper AS lfmonp,
  n.salkv_compat AS salkv
FROM ckmlcr AS cr
INNER JOIN R_MatlPriceDataMigrationStatus AS tf ON /* join condition not captured in parsed metadata */
INNER JOIN fmlv_logistic_currency AS lcurtp ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): fmlt_price
;