ML4H_CDS_MLDOCAHD

DDL: ML4H_CDS_MLDOCAHD SQL: ML4H_MLDOCAHD Type: view
55 Fields 2 Data Sources

CKMLLAHD x MLDOC

ML4H_CDS_MLDOCAHD is a CDS View that provides data about "CKMLLAHD x MLDOC" in SAP S/4HANA. It reads from 2 data sources (ckmllahd, mldoc) and exposes 55 fields.

Data Sources (2)

SourceAliasJoin Type
ckmllahd ahd from
mldoc doc left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ML4H_MLDOCAHD 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 CKMLLAHD x MLDOC view

Fields (55)

KeyFieldSource TableSource FieldDescription
bwkey ckmllahd werks Receiving Plant
docref mldoc docref Orig.docum.num.
curtp mldoc curtp Valuation Area
rldnr mldoc rldnr Ledger (Compat.)
kalnr mldoc kalnr ProdCostEst.No.
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 ML4H_CDS_MLDOCAHD.
-- 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_MLDOCAHD

CREATE VIEW ML4H_CDS_MLDOCAHD AS
SELECT
  ahd.werks AS bwkey,
  doc.docref AS docref,
  doc.curtp AS curtp,
  doc.rldnr AS rldnr,
  doc.kalnr AS kalnr,
  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 ckmllahd AS ahd
LEFT OUTER JOIN mldoc AS doc ON /* join condition not captured in parsed metadata */
;

Learn More