fcml4h_cds_mldochd

DDL: FCML4H_CDS_MLDOCHD SQL: FCML4H_MLDOCHD Type: view
65 Fields 2 Data Sources

CKMLHD x MLDOC

fcml4h_cds_mldochd is a CDS View that provides data about "CKMLHD x MLDOC" in SAP S/4HANA. It reads from 2 data sources (mldoc, ckmlhd) and exposes 65 fields.

Data Sources (2)

SourceAliasJoin Type
mldoc doc left_outer
ckmlhd hd from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FCML4H_MLDOCHD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label CKMLHD x MLDOC view

Fields (65)

KeyFieldSource TableSource FieldDescription
matnr ckmlhd matnr Vehicle Model
bwkey ckmlhd bwkey Valuation Area
bwtar ckmlhd bwtar Valuation Type
sobkz ckmlhd sobkz Special Stock
kzbws ckmlhd kzbws Valuation
xobew ckmlhd xobew Vendor stk val.
vbeln ckmlhd vbeln SD Sched. Agmt
posnr ckmlhd posnr WBS Element
pspnr ckmlhd pspnr WBS Element
lifnr ckmlhd lifnr Vendor no.
mlast ckmlhd mlast Price Determ.
kalnr ckmlhd kalnr ProdCostEst.No.
docref mldoc docref Orig.docum.num.
curtp mldoc curtp Valuation Area
rldnr mldoc rldnr Ledger (Compat.)
runref mldoc runref Costing Run Ref.
jahrper mldoc jahrper Year / Period
jahrper_wip mldoc jahrper_wip Year / Period of WIP
current_per mldoc current_per Curr. Year / Period
xabr mldoc xabr Costing Doc.
glvor mldoc glvor Bus.transaction
vgart mldoc vgart Transactn Type
posart mldoc posart Item type
categ mldoc categ Category
ptyp mldoc ptyp Visibility (I/E/V/C)
bewartgrp mldoc bewartgrp Mvmt Type Group
bvalt mldoc bvalt PrcrmntAlt/Proc
process mldoc process Trans.
pkalnr mldoc pkalnr CE No. of Output
quant mldoc quant Trans. Qty Val. Unit
meins mldoc meins Valuation Unit
stval mldoc stval Trs. Invent. Value
prd mldoc prd Price Difference
kdm mldoc kdm Exch.Rate Diff.
tpprd mldoc tpprd Prdif fr. Tansf.Pr.
altval mldoc altval Alt. Inventory Value
waers mldoc waers Transaction Currency
lbkum mldoc lbkum Valuated stock
salk3 mldoc salk3 Total Value
salkv mldoc salkv Value/MA price
stprs mldoc stprs Standard price
pvprs mldoc pvprs Per. Unit Price
peinh mldoc peinh Unit of measure
xekrel mldoc xekrel Rel. f. Purch. Acct.
plqty mldoc plqty Price Limiter Qty
markup mldoc markup Markup/markdown
vkwrt mldoc vkwrt SalVal inc. VAT
vksal mldoc vksal Value at Sales Price
eqnum mldoc eqnum Field
timestamp mldoc timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
budat mldoc budat Posting Date
cyclenr mldoc cyclenr Cycle Number
aufnr mldoc aufnr SettlementOrder
aufps mldoc aufps Order item no.
belnr mldoc belnr SD Document
kjahr mldoc kjahr Year
posnr_doc mldoc posnr WBS Element
awtyp mldoc awtyp Reference Document Type
wasys mldoc awsys Logical System
aworg mldoc aworg Refer. Org.Unit
awref mldoc awref Reference Doc.
awitem mldoc awitem Ref. Doc. Line Item
awitgrp mldoc awitgrp Ref. Item Group
usnam mldoc usnam User Name
tcode mldoc tcode Undefined range (can be used for patch levels)

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 fcml4h_cds_mldochd.
-- 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: FCML4H_MLDOCHD

CREATE VIEW fcml4h_cds_mldochd AS
SELECT
  hd.matnr AS matnr,
  hd.bwkey AS bwkey,
  hd.bwtar AS bwtar,
  hd.sobkz AS sobkz,
  hd.kzbws AS kzbws,
  hd.xobew AS xobew,
  hd.vbeln AS vbeln,
  hd.posnr AS posnr,
  hd.pspnr AS pspnr,
  hd.lifnr AS lifnr,
  hd.mlast AS mlast,
  hd.kalnr AS kalnr,
  doc.docref AS docref,
  doc.curtp AS curtp,
  doc.rldnr AS rldnr,
  doc.runref AS runref,
  doc.jahrper AS jahrper,
  doc.jahrper_wip AS jahrper_wip,
  doc.current_per AS current_per,
  doc.xabr AS xabr,
  doc.glvor AS glvor,
  doc.vgart AS vgart,
  doc.posart AS posart,
  doc.categ AS categ,
  doc.ptyp AS ptyp,
  doc.bewartgrp AS bewartgrp,
  doc.bvalt AS bvalt,
  doc.process AS process,
  doc.pkalnr AS pkalnr,
  doc.quant AS quant,
  doc.meins AS meins,
  doc.stval AS stval,
  doc.prd AS prd,
  doc.kdm AS kdm,
  doc.tpprd AS tpprd,
  doc.altval AS altval,
  doc.waers AS waers,
  doc.lbkum AS lbkum,
  doc.salk3 AS salk3,
  doc.salkv AS salkv,
  doc.stprs AS stprs,
  doc.pvprs AS pvprs,
  doc.peinh AS peinh,
  doc.xekrel AS xekrel,
  doc.plqty AS plqty,
  doc.markup AS markup,
  doc.vkwrt AS vkwrt,
  doc.vksal AS vksal,
  doc.eqnum AS eqnum,
  doc.timestamp AS timestamp,
  doc.budat AS budat,
  doc.cyclenr AS cyclenr,
  doc.aufnr AS aufnr,
  doc.aufps AS aufps,
  doc.belnr AS belnr,
  doc.kjahr AS kjahr,
  doc.posnr AS posnr_doc,
  doc.awtyp AS awtyp,
  doc.awsys AS wasys,
  doc.aworg AS aworg,
  doc.awref AS awref,
  doc.awitem AS awitem,
  doc.awitgrp AS awitgrp,
  doc.usnam AS usnam,
  doc.tcode AS tcode
FROM ckmlhd AS hd
LEFT OUTER JOIN mldoc AS doc ON /* join condition not captured in parsed metadata */
;

Learn More