ML4H_CDS_MLDOCCCSHD

DDL: ML4H_CDS_MLDOCCCSHD SQL: ML4H_MLDOCCCSHD Type: view Package: FCML4H_DISPLAY
59 Fields 3 Data Sources

CKMLHD x MLDOC x MLDOCCCS

ML4H_CDS_MLDOCCCSHD is a CDS View that provides data about "CKMLHD x MLDOC x MLDOCCCS" in SAP S/4HANA. It reads from 3 data sources (mldocccs, mldoc, ckmlhd) and exposes 59 fields. Part of development package FCML4H_DISPLAY.

Data Sources (3)

SourceAliasJoin Type
mldocccs ccs left_outer
mldoc doc left_outer
ckmlhd hd from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ML4H_MLDOCCCSHD view
AbapCatalog.compiler.compareFilter 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 x MLDOCCCS view

Fields (59)

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
meins mldoc meins Valuation Unit
xekrel mldoc xekrel Rel. f. Purch. Acct.
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)
elesmhk mldocccs elesmhk Cost Comp. Str.
element mldocccs element Target identifier
patnr mldocccs patnr Partner number
dipa mldocccs dipa Direct Partner
svrel mldocccs svrel Relev. f. Stock Val.
mlcct mldocccs mlcct Sing/Multilevel
keart mldocccs keart Type of CCS
waers mldocccs waers Transaction Currency
tot mldocccs tot Total Value
fix mldocccs fix Standard ledger
toll mldocccs totll Tot. Val. Lower Lvl.
fixll mldocccs fixll Fixed Val Lower Lvl

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 ML4H_CDS_MLDOCCCSHD.
-- 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: ML4H_MLDOCCCSHD

CREATE VIEW ML4H_CDS_MLDOCCCSHD 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.meins AS meins,
  doc.xekrel AS xekrel,
  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,
  ccs.elesmhk AS elesmhk,
  ccs.element AS element,
  ccs.patnr AS patnr,
  ccs.dipa AS dipa,
  ccs.svrel AS svrel,
  ccs.mlcct AS mlcct,
  ccs.keart AS keart,
  ccs.waers AS waers,
  ccs.tot AS tot,
  ccs.fix AS fix,
  ccs.totll AS toll,
  ccs.fixll AS fixll
FROM ckmlhd AS hd
LEFT OUTER JOIN mldoc AS doc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mldocccs AS ccs ON /* join condition not captured in parsed metadata */
;

Learn More