ML4H_CDS_MLIT_CL

DDL: ML4H_CDS_MLIT_CL SQL: V_MLIT_CL Type: view
12 Fields 3 Data Sources

Select all closing documents

ML4H_CDS_MLIT_CL is a CDS View that provides data about "Select all closing documents" in SAP S/4HANA. It reads from 3 data sources (mlhd, mlit, mlpp) and exposes 12 fields.

Data Sources (3)

SourceAliasJoin Type
mlhd h inner
mlit i from
mlpp p inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName V_MLIT_CL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality X view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass TRANSACTIONAL view
EndUserText.label Select all closing documents view

Fields (12)

KeyFieldSource TableSource FieldDescription
kalnr mlit kalnr ProdCostEst.No.
bdatj bdatj Year
poper poper Posting periods
kjahr mlit kjahr Year
belnr mlit belnr SD Document
posnr mlit posnr WBS Element
psart mlit psart Item type
urzeile mlit urzeile Item
budat budat Posting Date
cpudt mlhd cpudt Imported On
cputm mlhd cputm Time
storno mlhd storno Reversal

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_MLIT_CL.
-- 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: V_MLIT_CL

CREATE VIEW ML4H_CDS_MLIT_CL AS
SELECT
  i.kalnr AS kalnr,
  bdatj,
  poper,
  i.kjahr AS kjahr,
  i.belnr AS belnr,
  i.posnr AS posnr,
  i.psart AS psart,
  i.urzeile AS urzeile,
  budat,
  h.cpudt AS cpudt,
  h.cputm AS cputm,
  h.storno AS storno
FROM mlit AS i
INNER JOIN mlhd AS h ON /* join condition not captured in parsed metadata */
INNER JOIN mlpp AS p ON /* join condition not captured in parsed metadata */
;

Learn More