FMLV_CKMLLACR_UCT

DDL: FMLV_CKMLLACR_UCT SQL: FCKMLLACRUCT Type: view

ML Activity Type: Period Record/Currency Record

FMLV_CKMLLACR_UCT is a CDS View that provides data about "ML Activity Type: Period Record/Currency Record" in SAP S/4HANA. It reads from 2 data sources (finsv_unique_cvtyps, ckmllacrld) and exposes 19 fields with key fields kalnr, bdatj, poper, untper, curtp.

Data Sources (2)

SourceAliasJoin Type
finsv_unique_cvtyps curr left_outer
ckmllacrld m from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FCKMLLACRUCT 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 ML Activity Type: Period Record/Currency Record view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY kalnr ckmllacrld kalnr ProdCostEst.No.
KEY bdatj ckmllacrld bdatj Year
KEY poper ckmllacrld poper Posting periods
KEY untper ckmllacrld untper Value Type
KEY curtp finsv_unique_cvtyps curtype Currency Type
togbtr togbtr Basic Rate Tot.
tofbtr tofbtr Fixed Basic Rt.
togbtrd togbtrd Price Delta
toe toe Price unit OCrcy
waers waers Transaction Currency
togbtr_s togbtr_s Basic Rate Tot.
tofbtr_s tofbtr_s Fixed Basic Rt.
togbtrd_s togbtrd_s Price Delta
toe_s toe_s Price unit OCrcy
waers_s waers_s Currency
bwstrat bwstrat Val.strategy
no_settle no_settle Do Not Consider
saprl saprl SAP Release
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_CKMLLACR_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: FCKMLLACRUCT

CREATE VIEW FMLV_CKMLLACR_UCT AS
SELECT
  m.kalnr AS kalnr,
  m.bdatj AS bdatj,
  m.poper AS poper,
  m.untper AS untper,
  curr.curtype AS curtp,
  togbtr,
  tofbtr,
  togbtrd,
  toe,
  waers,
  togbtr_s,
  tofbtr_s,
  togbtrd_s,
  toe_s,
  waers_s,
  bwstrat,
  no_settle,
  saprl,
  cast( '01' as fins_ml_sdm_version ) AS sdm_version
FROM ckmllacrld AS m
LEFT OUTER JOIN finsv_unique_cvtyps AS curr ON /* join condition not captured in parsed metadata */
;