FMLV_QBEWH_CKMLCR_SALKV

DDL: FMLV_QBEWH_CKMLCR_SALKV SQL: FMLVQBEWHCR Type: view

CompatView for SALKV in QBEWH

FMLV_QBEWH_CKMLCR_SALKV is a CDS View that provides data about "CompatView for SALKV in QBEWH" in SAP S/4HANA. It reads from 6 data sources and exposes 7 fields with key fields kalnr, bdatj, lfmon, bdatj, lfmon.

Data Sources (6)

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

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FMLVQBEWHCR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CompatView for SALKV in QBEWH view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY kalnr ckmlcr kalnr ProdCostEst.No.
KEY bdatj bdatj Year Cur.Period
KEY lfmon Current Period
kalnr ProdCostEst.No.
KEY bdatj qbewh lfgja Year Cur.Period
KEY lfmon qbewh lfmon Current 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_QBEWH_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: FMLVQBEWHCR

CREATE VIEW FMLV_QBEWH_CKMLCR_SALKV AS
SELECT
  cr.kalnr AS kalnr,
  bdatj,
  right(poper, 2) AS lfmon,
  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 */
INNER JOIN qbewh AS qh ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): fmlt_price
;