FMLV_MLAUFKEPHH_UCT

DDL: FMLV_MLAUFKEPHH_UCT SQL: FMLAUFKEPHHUCT Type: view

History table for summarized MLAUFKEPH data w. correct CURTP

FMLV_MLAUFKEPHH_UCT is a CDS View that provides data about "History table for summarized MLAUFKEPH data w. correct CURTP" in SAP S/4HANA. It reads from 2 data sources (finsv_unique_cvtyps, mlaufkephldh) and exposes 138 fields with key fields mlvnr, vgabe, gjahr, belnr, buzei.

Data Sources (2)

SourceAliasJoin Type
finsv_unique_cvtyps curr left_outer
mlaufkephldh mld from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FMLAUFKEPHHUCT view
EndUserText.label History table for summarized MLAUFKEPH data w. correct CURTP 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

Fields (138)

KeyFieldSource TableSource FieldDescription
KEY mlvnr mlvnr ML Transactn No
KEY vgabe vgabe Transact. Type
KEY gjahr gjahr Settlement Year
KEY belnr belnr SD Document
KEY buzei buzei Posting View Item
KEY kalnr kalnr ProdCostEst.No.
KEY sumdno sumdno Sum Mat doc
KEY keart keart Type of CCS
KEY mlcct mlcct Sing/Multilevel
KEY kkzst kkzst Lower Level/Level
KEY patnr patnr Partner number
KEY dipa dipa Direct Partner
KEY curtp finsv_unique_cvtyps curtype Currency Type
storno storno Reversal
cpudt cpudt Imported On
cputm cputm Time
waers waers Transaction Currency
kst001 kst001 Cost Field
kst002 kst002 Cost Field
kst003 kst003 Cost Field
kst004 kst004 Cost Field
kst005 kst005 Cost Field
kst006 kst006 Cost Field
kst007 kst007 Cost Field
kst008 kst008 Cost Field
kst009 kst009 Cost Field
kst010 kst010 Cost Field
kst011 kst011 Cost Field
kst012 kst012 Cost Field
kst013 kst013 Cost Field
kst014 kst014 Cost Field
kst015 kst015 Cost Field
kst016 kst016 Cost Field
kst017 kst017 Cost Field
kst018 kst018 Cost Field
kst019 kst019 Cost Field
kst020 kst020 Cost Field
kst021 kst021 Cost Field
kst022 kst022 Cost Field
kst023 kst023 Cost Field
kst024 kst024 Cost Field
kst025 kst025 Cost Field
kst026 kst026 Cost Field
kst027 kst027 Cost Field
kst028 kst028 Cost Field
kst029 kst029 Cost Field
kst030 kst030 Cost Field
kst031 kst031 Cost Field
kst032 kst032 Cost Field
kst033 kst033 Cost Field
kst034 kst034 Cost Field
kst035 kst035 Cost Field
kst036 kst036 Cost Field
kst037 kst037 Cost Field
kst038 kst038 Cost Field
kst039 kst039 Cost Field
kst040 kst040 Cost Field
kst041 kst041 Cost Field
kst042 kst042 Cost Field
kst043 kst043 Cost Field
kst044 kst044 Cost Field
kst045 kst045 Cost Field
kst046 kst046 Cost Field
kst047 kst047 Cost Field
kst048 kst048 Cost Field
kst049 kst049 Cost Field
kst050 kst050 Cost Field
kst051 kst051 Cost Field
kst052 kst052 Cost Field
kst053 kst053 Cost Field
kst054 kst054 Cost Field
kst055 kst055 Cost Field
kst056 kst056 Cost Field
kst057 kst057 Cost Field
kst058 kst058 Cost Field
kst059 kst059 Cost Field
kst060 kst060 Cost Field
kst061 kst061 Cost Field
kst062 kst062 Cost Field
kst063 kst063 Cost Field
kst064 kst064 Cost Field
kst065 kst065 Cost Field
kst066 kst066 Cost Field
kst067 kst067 Cost Field
kst068 kst068 Cost Field
kst069 kst069 Cost Field
kst070 kst070 Cost Field
kst071 kst071 Cost Field
kst072 kst072 Cost Field
kst073 kst073 Cost Field
kst074 kst074 Cost Field
kst075 kst075 Cost Field
kst076 kst076 Cost Field
kst077 kst077 Cost Field
kst078 kst078 Cost Field
kst079 kst079 Cost Field
kst080 kst080 Cost Field
kst081 kst081 Cost Field
kst082 kst082 Cost Field
kst083 kst083 Cost Field
kst084 kst084 Cost Field
kst085 kst085 Cost Field
kst086 kst086 Cost Field
kst087 kst087 Cost Field
kst088 kst088 Cost Field
kst089 kst089 Cost Field
kst090 kst090 Cost Field
kst091 kst091 Cost Field
kst092 kst092 Cost Field
kst093 kst093 Cost Field
kst094 kst094 Cost Field
kst095 kst095 Cost Field
kst096 kst096 Cost Field
kst097 kst097 Cost Field
kst098 kst098 Cost Field
kst099 kst099 Cost Field
kst100 kst100 Cost Field
kst101 kst101 Cost Field
kst102 kst102 Cost Field
kst103 kst103 Cost Field
kst104 kst104 Cost Field
kst105 kst105 Cost Field
kst106 kst106 Cost Field
kst107 kst107 Cost Field
kst108 kst108 Cost Field
kst109 kst109 Cost Field
kst110 kst110 Cost Field
kst111 kst111 Cost Field
kst112 kst112 Cost Field
kst113 kst113 Cost Field
kst114 kst114 Cost Field
kst115 kst115 Cost Field
kst116 kst116 Cost Field
kst117 kst117 Cost Field
kst118 kst118 Cost Field
kst119 kst119 Cost Field
kst120 kst120 Cost Field
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_MLAUFKEPHH_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: FMLAUFKEPHHUCT

CREATE VIEW FMLV_MLAUFKEPHH_UCT AS
SELECT
  mlvnr,
  vgabe,
  gjahr,
  belnr,
  buzei,
  kalnr,
  sumdno,
  keart,
  mlcct,
  kkzst,
  patnr,
  dipa,
  curr.curtype AS curtp,
  storno,
  cpudt,
  cputm,
  waers,
  kst001,
  kst002,
  kst003,
  kst004,
  kst005,
  kst006,
  kst007,
  kst008,
  kst009,
  kst010,
  kst011,
  kst012,
  kst013,
  kst014,
  kst015,
  kst016,
  kst017,
  kst018,
  kst019,
  kst020,
  kst021,
  kst022,
  kst023,
  kst024,
  kst025,
  kst026,
  kst027,
  kst028,
  kst029,
  kst030,
  kst031,
  kst032,
  kst033,
  kst034,
  kst035,
  kst036,
  kst037,
  kst038,
  kst039,
  kst040,
  kst041,
  kst042,
  kst043,
  kst044,
  kst045,
  kst046,
  kst047,
  kst048,
  kst049,
  kst050,
  kst051,
  kst052,
  kst053,
  kst054,
  kst055,
  kst056,
  kst057,
  kst058,
  kst059,
  kst060,
  kst061,
  kst062,
  kst063,
  kst064,
  kst065,
  kst066,
  kst067,
  kst068,
  kst069,
  kst070,
  kst071,
  kst072,
  kst073,
  kst074,
  kst075,
  kst076,
  kst077,
  kst078,
  kst079,
  kst080,
  kst081,
  kst082,
  kst083,
  kst084,
  kst085,
  kst086,
  kst087,
  kst088,
  kst089,
  kst090,
  kst091,
  kst092,
  kst093,
  kst094,
  kst095,
  kst096,
  kst097,
  kst098,
  kst099,
  kst100,
  kst101,
  kst102,
  kst103,
  kst104,
  kst105,
  kst106,
  kst107,
  kst108,
  kst109,
  kst110,
  kst111,
  kst112,
  kst113,
  kst114,
  kst115,
  kst116,
  kst117,
  kst118,
  kst119,
  kst120,
  cast( '01' as fins_ml_sdm_version ) AS sdm_version
FROM mlaufkephldh AS mld
LEFT OUTER JOIN finsv_unique_cvtyps AS curr ON /* join condition not captured in parsed metadata */
;