What is MLDOC_UCB_EXTRACT in SAP S/4HANA?

MLDOC_UCB_EXTRACT is a cds CDS view in SAP S/4HANA. MLDOC with joined UCB all records It contains 32 fields.

Which tables does MLDOC_UCB_EXTRACT read from?

MLDOC_UCB_EXTRACT reads data from: mldoc_extract, mldoc_extract, mldocucb_extract, mldocucb, mldocucb.

MLDOC_UCB_EXTRACT

DDL: MLDOC_UCB_EXTRACT Type: view_entity Package: FCML4H_UCB

32 Fields 5 Data Sources

MLDOC with joined UCB all records

MLDOC_UCB_EXTRACT is a CDS View that provides data about "MLDOC with joined UCB all records" in SAP S/4HANA. It reads from 5 data sources (mldoc_extract, mldoc_extract, mldocucb_extract, mldocucb, mldocucb) and exposes 32 fields with key fields kalnr, jahrper, docref, curtp, ucb_method. Part of development package FCML4H_UCB.

Data Sources (5)

Source	Alias	Join Type
mldoc_extract	doc	from
mldoc_extract	doc	union_all
mldocucb_extract	mldocucb_extract	union_all
mldocucb	ucb	inner
mldocucb	ucb	inner

Annotations (6)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	MLDOC with joined UCB all records	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (32)

Key	Field	Source Table	Source Field	Description
KEY	kalnr	mldoc_extract	kalnr	ProdCostEst.No.
KEY	jahrper	mldoc_extract	jahrper	Year / Period
KEY	docref	mldoc_extract	docref	Orig.docum.num.
KEY	curtp	mldocucb	curtp	Valuation Area
KEY	ucb_method	mldocucb	ucb_method	Breakdown Method
KEY	svrel	mldocucb	svrel	Relev. f. Stock Val.
	rldnr	mldoc_extract	rldnr	Ledger (Compat.)
	waers	mldocucb	waers	Transaction Currency
	tot			Total Value
	fix			Standard ledger
	kalnraskalnr
KEY	jahrper	mldoc_extract	jahrper	Year / Period
KEY	docref	mldoc_extract	docref	Orig.docum.num.
KEY	curtp	mldoc_extract	curtp	Valuation Area
KEY	ucb_method	mldocucb	ucb_method	Breakdown Method
KEY	svrel	mldocucb	svrel	Relev. f. Stock Val.
	rldnr	mldoc_extract	rldnr	Ledger (Compat.)
	waers	mldoc_extract	waers	Transaction Currency
	quant_tot			Quantity
	quant_fix			Fixed Value
KEY	jahrper		jahrper	Year / Period
KEY	docref		docref	Orig.docum.num.
KEY	curtp		curtp	Valuation Area
KEY	ucb_method		ucb_method	Breakdown Method
KEY	svrel		svrel	Relev. f. Stock Val.
	rldnr		rldnr	Ledger (Compat.)
	waers		waers	Transaction Currency
	quant_tot		quant_tot	Quantity
	quant_fix		quant_fix	Fixed Value
	tot		tot	Total Value
	fix		fix	Standard ledger
	persisted

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 MLDOC_UCB_EXTRACT.
-- 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.

CREATE VIEW MLDOC_UCB_EXTRACT AS
SELECT
  doc.kalnr AS kalnr,
  doc.jahrper AS jahrper,
  doc.docref AS docref,
  ucb.curtp AS curtp,
  ucb.ucb_method AS ucb_method,
  ucb.svrel AS svrel,
  doc.rldnr AS rldnr,
  ucb.waers AS waers,
  cast('0' as ml4h_total) AS tot,
  cast('0' as ml4h_fix) AS fix,
  ' ' as persisted AS kalnraskalnr,
  cast('0' as fucb_quantity) AS quant_tot,
  cast('0' as fucb_quantity) AS quant_fix,
  'X' AS persisted
FROM mldoc_extract AS doc
INNER JOIN mldocucb AS ucb ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): mldoc_extract, mldocucb_extract
;

Depth:

MLDOC_UCB_EXTRACT view_entity