P_Foundationa

DDL: P_FOUNDATIONA SQL: PFOUNDATIONA Type: view BASIC
44 Fields 1 Data Sources

P_Foundationa is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (acdoca) and exposes 44 fields.

Data Sources (1)

SourceAliasJoin Type
acdoca a from

Annotations (3)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PFOUNDATIONA view

Fields (44)

KeyFieldSource TableSource FieldDescription
rclnt rclnt Client
rldnr rldnr Ledger (Compat.)
gjahr gjahr Settlement Year
rbukrs rbukrs Company Code
belnr belnr SD Document
rcomp b rcomp Trading Partner
rcntr rcntr Cost Center
prctr prctr Profit Centers
rfarea rfarea R FuncArea
rbusa rbusa Business Area
kokrs kokrs Org. Value
segment segment Segment number
pbukrs pbukrs Partner CoCode
rassc rassc Trading Partner
scntr scntr Sender Cost Ctr
pprctr pprctr Partner PC
sfarea sfarea Sender FnArea
sbusa sbusa Trdg Part.BA
psegment psegment Partner Segment
ktopl acdoca ktopl G/L Chart of Accounts
racct racct GL Account From
rmvct rmvct Transact. Type
wsl wsl OrigTrnsCrcyAmt
hsl hsl Local Crcy Amt
ksl ksl GrpCurr
msl msl Stat. KeyFig. Qty
rwcur rwcur Transaction Currency
rhcur rhcur Local Currency
rkcur rkcur Ledger curr.
runit runit Unit/Area
periv acdoca periv FYear Variant
poper poper Posting periods
fiscyearper Period/Year
budat budat Posting Date
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
anbwa anbwa Trans. type
anln1 anln1 Asset
matkl matkl Product Sold Group
kdgrp kdgrp Customer group
vkorg vkorg SD Sales Org.
vtweg vtweg RefDistCh-Cust/Mat.
spart spart Source supplier
ps_pspid ps_pspid Project def.
ps_posid ps_posid WBS Element

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_Foundationa.
-- 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: PFOUNDATIONA

CREATE VIEW P_Foundationa AS
SELECT
  rclnt,
  rldnr,
  gjahr,
  rbukrs,
  belnr,
  b.rcomp AS rcomp,
  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  segment,
  pbukrs,
  rassc,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  psegment,
  a.ktopl AS ktopl,
  racct,
  rmvct,
  wsl,
  hsl,
  ksl,
  msl,
  rwcur,
  rhcur,
  rkcur,
  runit,
  a.periv AS periv,
  poper,
  cast(fiscyearper as fiscalyearperiod) AS fiscyearper,
  budat,
  timestamp,
  anbwa,
  anln1,
  matkl,
  kdgrp,
  vkorg,
  vtweg,
  spart,
  ps_pspid,
  ps_posid
FROM acdoca AS a
;

Learn More