P_MaterialLedgerDocumentItem

DDL: P_MATERIALLEDGERDOCUMENTITEM SQL: PMLDOCITEM Type: view BASIC Package: FINS_ML_DOCUMENT
43 Fields 1 Data Sources

Material Ledger document item

P_MaterialLedgerDocumentItem is a Basic CDS View that provides data about "Material Ledger document item" in SAP S/4HANA. It reads from 1 data source (mlit) and exposes 43 fields with key fields belnr, kjahr, posnr. Part of development package FINS_ML_DOCUMENT.

Data Sources (1)

SourceAliasJoin Type
mlit mlit from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMLDOCITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY belnr belnr SD Document
KEY kjahr kjahr Year
KEY posnr posnr WBS Element
bukrs bukrs Value
bwkey bwkey Valuation Area
kalnr kalnr ProdCostEst.No.
urzeile urzeile Item
matnr matnr Vehicle Model
bwtar bwtar Valuation Type
meins meins Valuation Unit
spart spart Source supplier
gsber gsber Business Area
bwmod bwmod Val.Grpg Code
ktopl ktopl G/L Chart of Accounts
mlast mlast Price Determ.
psart psart Item type
belnr_ea belnr_ea Document Number
kjahr_ea kjahr_ea Document Year
belnr_ma belnr_ma Document Number
kjahr_ma kjahr_ma Document Year
aschema aschema MatlUpdateStr.
ptyp ptyp Visibility (I/E/V/C)
ptyp_kat ptyp_kat Cat-Process Cat
ptyp_bvalt ptyp_bvalt PrcCat-Pr/Cnalt
ptyp_proc ptyp_proc Proc.-Proc.Cat.
bewartgrp bewartgrp Mvmt Type Group
kategorie kategorie Charc Category
bvalt bvalt PrcrmntAlt/Proc
process process Trans.
csplit csplit Apportionment
vbeln vbeln SD Sched. Agmt
vbelp vbelp Schd. Agmt Item
pspnr pspnr WBS Element
lifnr lifnr Vendor no.
kzbws kzbws Valuation
xobew xobew Vendor stk val.
sobkz sobkz Special Stock
xabrerr xabrerr Obsolete
belnr_cons belnr_cons Document Number
kjahr_cons kjahr_cons Document Year
belnr_wip belnr_wip Document Number
kjahr_wip kjahr_wip Document Year
prctr prctr Profit Centers

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 P_MaterialLedgerDocumentItem.
-- 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: PMLDOCITEM

CREATE VIEW P_MaterialLedgerDocumentItem AS
SELECT
  belnr,
  kjahr,
  posnr,
  bukrs,
  bwkey,
  kalnr,
  urzeile,
  matnr,
  bwtar,
  meins,
  spart,
  gsber,
  bwmod,
  ktopl,
  mlast,
  psart,
  belnr_ea,
  kjahr_ea,
  belnr_ma,
  kjahr_ma,
  aschema,
  ptyp,
  ptyp_kat,
  ptyp_bvalt,
  ptyp_proc,
  bewartgrp,
  kategorie,
  bvalt,
  process,
  csplit,
  vbeln,
  vbelp,
  pspnr,
  lifnr,
  kzbws,
  xobew,
  sobkz,
  xabrerr,
  belnr_cons,
  kjahr_cons,
  belnr_wip,
  kjahr_wip,
  prctr
FROM mlit
;

Learn More