P_MLACDOCAEXTRACT

DDL: P_MLACDOCAEXTRACT SQL: PMLACDOCAEXTRACT Type: view BASIC Package: FINS_ML_VDM
18 Fields 1 Data Sources

ACDOCA Extract Table for Material Ledger

P_MLACDOCAEXTRACT is a Basic CDS View that provides data about "ACDOCA Extract Table for Material Ledger" in SAP S/4HANA. It reads from 1 data source (acdoca_m_extract) and exposes 18 fields with key fields belnr, docln, fiscyearper, rldnr, rbukrs. Part of development package FINS_ML_VDM.

Data Sources (1)

SourceAliasJoin Type
acdoca_m_extract acdoca_m_extract from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMLACDOCAEXTRACT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ACDOCA Extract Table for Material Ledger view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY belnr belnr SD Document
KEY docln docln Matching Document Line Item
KEY fiscyearper fiscyearper Period/Year
KEY rldnr rldnr Ledger (Compat.)
KEY rbukrs rbukrs Company Code
KEY kalnr kalnr ProdCostEst.No.
matnr matnr Vehicle Model
bwtar bwtar Valuation Type
bwkey bwkey Valuation Area
ml_sobkz ml_sobkz Special Stock
ml_kdauf ml_kdauf SD Doc of Inv.
ml_kdpos ml_kdpos SD Item of Inv.
ml_lifnr ml_lifnr Vendor of Inv.
ml_pspnr ml_pspnr WBSElem of Inv.
vmsl vmsl Val. quantity
hsl hsl Local Crcy Amt
ksl ksl GrpCurr
osl osl Other Crcy Amnt

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_MLACDOCAEXTRACT.
-- 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: PMLACDOCAEXTRACT

CREATE VIEW P_MLACDOCAEXTRACT AS
SELECT
  belnr,
  docln,
  fiscyearper,
  rldnr,
  rbukrs,
  kalnr,
  matnr,
  bwtar,
  bwkey,
  ml_sobkz,
  ml_kdauf,
  ml_kdpos,
  ml_lifnr,
  ml_pspnr,
  vmsl,
  hsl,
  ksl,
  osl
FROM acdoca_m_extract
;

Learn More