P_Bseg_Add_Com1

DDL: P_BSEG_ADD_COM1 SQL: PFIBSEGADDCOM1 Type: view BASIC
121 Fields 1 Data Sources 1 Associations

P_Bseg_Add_Com1 is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (bseg_add) and exposes 121 fields with key fields bukrs, belnr, gjahr, buzei. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
bseg_add bseg_add from

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_BKPF_COM _P_BKPF_COM $projection.bukrs = _P_BKPF_COM.bukrs and $projection.belnr = _P_BKPF_COM.belnr and $projection.gjahr = _P_BKPF_COM.gjahr

Annotations (8)

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

Fields (121)

KeyFieldSource TableSource FieldDescription
KEY bukrs bukrs Value
KEY belnr belnr SD Document
KEY gjahr gjahr Settlement Year
KEY buzei buzei Posting View Item
buzid buzid Line Item ID
augdt augdt Clearing
augcp augcp ClearingEntDate
augbl augbl Clrng doc.
bschl bschl Posting Key
koart koart Account type
shkzg shkzg Returns
gsber gsber Business Area
pargb pargb Trdg Part.BA
mwskz mwskz Tax Code
qsskz qsskz WTax Code
ktosl ktosl Transaction
valut valut Value date
zuonr zuonr Finance Project
sgtxt sgtxt Text
vbund vbund Trading Partner
bewar bewar Transact. Type
altkt altkt Group Account Number
vorgn vorgn Transaction
fkont fkont Fin.Budget
kokrs kokrs Org. Value
kostl kostl Substitute CC
projn projn WBS Element
aufnr aufnr SettlementOrder
anln1 anln1 Asset
anln2 anln2 Sub-number
anbwa anbwa Trans. type
xopvw xopvw OI Management
xauto xauto Auto. Item Keys
xncop xncop Indicator: Items Cannot Be Copied?
hkont hkont Transfer acct
xbilk xbilk Checkbox
gvtyp gvtyp P&L state. acct
zfbdt zfbdt Payment date
rebzg rebzg Invoice Ref.
rebzj rebzj Fiscal Year
rebzz rebzz Item
rebzt rebzt Follow-On Doc. Type
wverw wverw Usage
matnr matnr Vehicle Model
werks werks Receiving Plant
bwkey bwkey Valuation Area
bwtar bwtar Valuation Type
prctr prctr Profit Centers
vname vname Volatility Name
recid recid Statistical Key Figure Item
egrup egrup Equity group
vptnr vptnr Partner
vertt vertt Contract Type
vertn vertn Int. dist. key
vbewa vbewa Flow Type
txjcd txjcd Tax Jurisdict.
imkey imkey Real Estate Key
dabrz dabrz Reference date
fipos fipos Commitment item
kstrg kstrg Cost Objects
nplnr nplnr Network
aufpl aufpl TaskList No.Ops
aplzl aplzl Plan No.f.Oper.
projk projk WBS Element
paobjnr paobjnr Profit. segment
pasubnr pasubnr Subnumber
xragl xragl Reverse clrg
uzawe uzawe Pmnt Meth. Sup.
lokkt lokkt Local Acct No.
fistl fistl Funds Center
geber geber Fund
pprct pprct Partner PC
xref1 xref1 Reference Key 1
xref2 xref2 Reference Key 2
kblnr kblnr Earmarked funds
kblpos kblpos Document Item
fkber fkber Functional Area
obzei obzei Original Item
xnegp xnegp Reversl Posting Type
rfzei rfzei Payt Card Item
ccbtc ccbtc Settlement
xref3 xref3 Third Reference
kontt kontt Acct Assmt Cat.
kontl kontl Acct assignment
agzei agzei Clearing Item
bupla bupla Business place
secco secco Section Code
lstar lstar Activity Type
prznr prznr Sender BProc
grant_nbr grant_nbr Receiver Grant
intreno intreno Source Object
measure measure obsolete
auggj auggj Clrg Fiscal Yr
segment segment Segment number
psegment psegment Partner Segment
pfkber pfkber Partner FArea
kstar kstar Settlement CE
xlgclr xlgclr OI Mgmt by LedgerGrp
netdt netdt Due On
gkont gkont Offsetting Acct
gkart gkart Offst.Acct Type
ghkon ghkon G/L Offsetting Acct
pgeber pgeber Partner Fund
pgrant_nbr pgrant_nbr Partner Grant
budget_pd budget_pd Rec BudPer
pbudget_pd pbudget_pd Par. BudPer
prodper prodper Production Month
re_bukrs re_bukrs Company Code
re_account re_account Ex/Rv A/c in CL
bdgt_account bdgt_account Budget Account
h_hwaer _P_BKPF_COM hwaer Local Currency
h_waers _P_BKPF_COM waers Transaction Currency
pswsl pswsl G/L Currency
h_hwae2 _P_BKPF_COM hwae2 Local curr. 2
h_hwae3 _P_BKPF_COM hwae3 Local curr. 3
rfccur rfccur Functional Currency
meins meins Valuation Unit
menge menge WarrCountValue
nbritm
bstat bstat Document Status
buzei_sender buzei_sender Sender Item

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_Bseg_Add_Com1.
-- 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: PFIBSEGADDCOM1

CREATE VIEW P_Bseg_Add_Com1 AS
SELECT
  bukrs,
  belnr,
  gjahr,
  buzei,
  buzid,
  augdt,
  augcp,
  augbl,
  bschl,
  koart,
  shkzg,
  gsber,
  pargb,
  mwskz,
  qsskz,
  ktosl,
  valut,
  zuonr,
  sgtxt,
  vbund,
  bewar,
  altkt,
  vorgn,
  fkont,
  kokrs,
  kostl,
  projn,
  aufnr,
  anln1,
  anln2,
  anbwa,
  xopvw,
  xauto,
  xncop,
  hkont,
  xbilk,
  gvtyp,
  zfbdt,
  rebzg,
  rebzj,
  rebzz,
  rebzt,
  wverw,
  matnr,
  werks,
  bwkey,
  bwtar,
  prctr,
  vname,
  recid,
  egrup,
  vptnr,
  vertt,
  vertn,
  vbewa,
  txjcd,
  imkey,
  dabrz,
  fipos,
  kstrg,
  nplnr,
  aufpl,
  aplzl,
  projk,
  paobjnr,
  pasubnr,
  xragl,
  uzawe,
  lokkt,
  fistl,
  geber,
  pprct,
  xref1,
  xref2,
  kblnr,
  kblpos,
  fkber,
  obzei,
  xnegp,
  rfzei,
  ccbtc,
  xref3,
  kontt,
  kontl,
  agzei,
  bupla,
  secco,
  lstar,
  prznr,
  grant_nbr,
  intreno,
  measure,
  auggj,
  segment,
  psegment,
  pfkber,
  kstar,
  xlgclr,
  netdt,
  gkont,
  gkart,
  ghkon,
  pgeber,
  pgrant_nbr,
  budget_pd,
  pbudget_pd,
  prodper,
  re_bukrs,
  re_account,
  bdgt_account,
  _P_BKPF_COM.hwaer AS h_hwaer,
  _P_BKPF_COM.waers AS h_waers,
  pswsl,
  _P_BKPF_COM.hwae2 AS h_hwae2,
  _P_BKPF_COM.hwae3 AS h_hwae3,
  rfccur,
  meins,
  menge,
  cast( cast(1 as abap.dec( 12, 0 )) as fis_nbritm ) AS nbritm,
  bstat,
  buzei_sender
FROM bseg_add
LEFT OUTER JOIN P_BKPF_COM AS _P_BKPF_COM ON bukrs = _P_BKPF_COM.bukrs AND belnr = _P_BKPF_COM.belnr AND gjahr = _P_BKPF_COM.gjahr  -- association [1..1]
;

Learn More