FMLV_CKMLPRKEKO_UCT

DDL: FMLV_CKMLPRKEKO_UCT SQL: FCKMLPRKEKOUCT Type: view Package: FINS_ML_UCT_TABLES

Material Ledger: Cost Component Split (Header) for Prices

FMLV_CKMLPRKEKO_UCT is a CDS View that provides data about "Material Ledger: Cost Component Split (Header) for Prices" in SAP S/4HANA. It reads from 2 data sources (finsv_unique_cvtyps, ckmlprkekold) and exposes 11 fields with key fields kalnr, bdatj, poper, untper, prtyp. Part of development package FINS_ML_UCT_TABLES.

Data Sources (2)

SourceAliasJoin Type
finsv_unique_cvtyps curr left_outer
ckmlprkekold m from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FCKMLPRKEKOUCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Material Ledger: Cost Component Split (Header) for Prices view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY kalnr ckmlprkekold kalnr ProdCostEst.No.
KEY bdatj ckmlprkekold bdatj Year
KEY poper ckmlprkekold poper Posting periods
KEY untper ckmlprkekold untper Value Type
KEY prtyp ckmlprkekold prtyp Type of Price
KEY curtp finsv_unique_cvtyps curtype Currency Type
losgr losgr Cstg Lot Size
meins meins Valuation Unit
elehk elehk Reserve
elehkns elehkns Cost Comp. Str.
sdm_version

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_CKMLPRKEKO_UCT.
-- 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: FCKMLPRKEKOUCT

CREATE VIEW FMLV_CKMLPRKEKO_UCT AS
SELECT
  m.kalnr AS kalnr,
  m.bdatj AS bdatj,
  m.poper AS poper,
  m.untper AS untper,
  m.prtyp AS prtyp,
  curr.curtype AS curtp,
  losgr,
  meins,
  elehk,
  elehkns,
  cast( '01' as fins_ml_sdm_version ) AS sdm_version
FROM ckmlprkekold AS m
LEFT OUTER JOIN finsv_unique_cvtyps AS curr ON /* join condition not captured in parsed metadata */
;