ESH_N_ACCT_DOC_LINEITEM_BSEG_H

DDL: ESH_N_ACCT_DOC_LINEITEM_BSEG_H SQL: ESH_L_ACCT_SEG_H Type: view

Accounting Document Segment

ESH_N_ACCT_DOC_LINEITEM_BSEG_H is a CDS View that provides data about "Accounting Document Segment" in SAP S/4HANA. It reads from 1 data source (bseg) and exposes 302 fields with key fields bukrs, belnr, gjahr, buzei. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
bseg bseg from

Associations (9)

CardinalityTargetAliasCondition
[1..1] ESH_N_ACCOUNTING_DOC_BKPF _BSEG_H2BKPF $projection.belnr = _BSEG_H2BKPF.belnr and $projection.gjahr = _BSEG_H2BKPF.gjahr and $projection.bukrs = _BSEG_H2BKPF.bukrs
[0..*] ESH_N_PROFIT_CENTER_CEPC _BSEG_H2CEPC $projection.kokrs = _BSEG_H2CEPC.kokrs and $projection.prctr = _BSEG_H2CEPC.prctr
[1..1] ESH_N_COMPANY_COMPANY _BSEG_H2COMPANY $projection.vbund = _BSEG_H2COMPANY.rcomp
[1..1] ESH_N_COMPANY_CODE_OMPANY_CODE _BSEG_H2COMPANY_CODE $projection.bukrs = _BSEG_H2COMPANY_CODE.bukrs
[0..*] ESH_N_COST_CENTER_CSKS _BSEG_H2CSKS $projection.kokrs = _BSEG_H2CSKS.kokrs and $projection.kostl = _BSEG_H2CSKS.kostl
[0..*] dd07t _BSEG_H2DD07T $projection.shkzg = _BSEG_H2DD07T.domvalue_l and _BSEG_H2DD07T.domname = 'SHKZG'
[1..1] ESH_N_KNA1_KNB1_KNB1_CUSTOMER _BSEG_H2KNB1_CUSTOMER $projection.bukrs = _BSEG_H2KNB1_CUSTOMER.bukrs and $projection.kunnr = _BSEG_H2KNB1_CUSTOMER.kunnr
[1..1] tka01 _BSEG_H2TKA01 $projection.kokrs = _BSEG_H2TKA01.kokrs
[1..1] ESH_N_LFA1_LFB1_LFB1_VENDOR _LFB1_CUSTOMER2BSEG_H $projection.lifnr = _LFB1_CUSTOMER2BSEG_H.lifnr and $projection.bukrs = _LFB1_CUSTOMER2BSEG_H.bukrs

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ESH_L_ACCT_SEG_H view
EndUserText.label Accounting Document Segment view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
AbapCatalog.compiler.compareFilter true view

Fields (302)

KeyFieldSource TableSource FieldDescription
KEY bukrs bukrs
KEY belnr belnr
KEY gjahr gjahr
KEY buzei buzei
buzid buzid
augdt augdt
augcp augcp
augbl augbl
bschl bschl
koart koart
umskz umskz
umsks umsks
zumsk zumsk
shkzg shkzg
gsber gsber
pargb pargb
mwskz mwskz
qsskz qsskz
dmbtr dmbtr
wrbtr wrbtr
kzbtr kzbtr
pswbt pswbt
pswsl pswsl
txbhw txbhw
txbfw txbfw
mwsts mwsts
wmwst wmwst
hwbas hwbas
fwbas fwbas
hwzuz hwzuz
fwzuz fwzuz
shzuz shzuz
stekz stekz
mwart mwart
qsshb qsshb
kursr kursr
gbetr gbetr
bdiff bdiff
bdif2 bdif2
valut valut
zuonr zuonr
sgtxt sgtxt
zinkz zinkz
vbund vbund
bewar bewar
altkt altkt
vorgn vorgn
fdlev fdlev
fdgrp fdgrp
fdwbt fdwbt
fdtag fdtag
fkont fkont
kokrs kokrs
kostl kostl
projn projn
aufnr aufnr
vbeln vbeln
vbel2 vbel2
posn2 posn2
anln1 anln1
anln2 anln2
anbwa anbwa
bzdat bzdat
pernr pernr
xhres xhres
xkres xkres
xopvw xopvw
xcpdd xcpdd
xsauf xsauf
xspro xspro
xfakt xfakt
xuman xuman
xanet xanet
xinve xinve
xauto xauto
xncop xncop
xzahl xzahl
saknr saknr
hkont hkont
kunnr kunnr
lifnr lifnr
filkd filkd
xbilk xbilk
gvtyp gvtyp
hzuon hzuon
zfbdt zfbdt
zterm zterm
zbd1t zbd1t
zbd2t zbd2t
zbd3t zbd3t
zbd1p zbd1p
zbd2p zbd2p
skfbt skfbt
sknto sknto
wskto wskto
zlsch zlsch
zlspr zlspr
zbfix zbfix
hbkid hbkid
bvtyp bvtyp
nebtr nebtr
mwsk1 mwsk1
dmbt1 dmbt1
wrbt1 wrbt1
mwsk2 mwsk2
dmbt2 dmbt2
wrbt2 wrbt2
mwsk3 mwsk3
dmbt3 dmbt3
wrbt3 wrbt3
rebzg rebzg
rebzj rebzj
rebzz rebzz
rebzt rebzt
zollt zollt
zolld zolld
landl landl
diekz diekz
samnr samnr
abper abper
vrskz vrskz
vrsdt vrsdt
disbn disbn
disbj disbj
wverw wverw
anfbn anfbn
anfbj anfbj
anfbu anfbu
anfae anfae
blnbt blnbt
blnkz blnkz
blnpz blnpz
mschl mschl
mansp mansp
madat madat
manst manst
maber maber
esrnr esrnr
esrre esrre
esrpz esrpz
klibt klibt
qsznr qsznr
qbshb qbshb
qsfbt qsfbt
navhw navhw
navfw navfw
matnr matnr
werks werks
menge menge
meins meins
erfmg erfmg
erfme erfme
bpmng bpmng
bprme bprme
ebeln ebeln
ebelp ebelp
elikz elikz
vprsv vprsv
bwkey bwkey
rewrt rewrt
rewwr rewwr
bonfb bonfb
bualt bualt
psalt psalt
nprei nprei
spgrp spgrp
spgrm spgrm
spgrt spgrt
stceg stceg
egbld egbld
eglld eglld
rpacq rpacq
rdiff rdiff
rdif2 rdif2
prctr prctr
xhkom xhkom
vname vname
recid recid
vptnr vptnr
vertt vertt
vertn vertn
depot depot
txjcd txjcd
dabrz dabrz
popts popts
fipos fipos
kstrg kstrg
nplnr nplnr
aufpl aufpl
aplzl aplzl
projk projk
paobjnr paobjnr
pasubnr pasubnr
spgrs spgrs
xegdr xegdr
lnran lnran
hrkft hrkft
dmbe2 dmbe2
dmbe3 dmbe3
dmb21 dmb21
dmb22 dmb22
dmb23 dmb23
dmb31 dmb31
dmb32 dmb32
dmb33 dmb33
mwst2 mwst2
mwst3 mwst3
navh2 navh2
navh3 navh3
sknt2 sknt2
sknt3 sknt3
bdif3 bdif3
rdif3 rdif3
hwmet hwmet
glupm glupm
xragl xragl
uzawe uzawe
lokkt lokkt
fistl fistl
geber geber
stbuk stbuk
txbh2 txbh2
txbh3 txbh3
pprct pprct
xref1 xref1
xref2 xref2
kblnr kblnr
kblpos kblpos
sttax sttax
fkber fkber
obzei obzei
rfzei rfzei
ccbtc ccbtc
kkber kkber
empfb empfb
xref3 xref3
dtws1 dtws1
dtws2 dtws2
dtws3 dtws3
dtws4 dtws4
gricd gricd
gityp gityp
xpypr xpypr
kidno kidno
absbt absbt
idxsp idxsp
linfv linfv
kontl kontl
txdat txdat
agzei agzei
pycur pycur
pyamt pyamt
bupla bupla
secco secco
lstar lstar
cession_kz cession_kz
prznr prznr
ppdiff ppdiff
ppdif2 ppdif2
ppdif3 ppdif3
penlc1 penlc1
penlc2 penlc2
penlc3 penlc3
penfc penfc
grant_nbr grant_nbr
sctax sctax
fkber_long fkber_long
srtype srtype
intreno intreno
measure measure
auggj auggj
ppa_ex_ind ppa_ex_ind
docln docln
segment segment
psegment psegment
hktid hktid
kstar kstar
xlgclr xlgclr
taxps taxps
pays_prov pays_prov
pays_tran pays_tran
mndid mndid
xfrge_bseg xfrge_bseg
pgeber pgeber
pgrant_nbr pgrant_nbr
budget_pd budget_pd
pbudget_pd pbudget_pd
perop_beg perop_beg
perop_end perop_end
fastpay fastpay
ignr_ivref ignr_ivref
prodper prodper
branch_id branch_id
_BSEG_H2BKPF _BSEG_H2BKPF
_BSEG_H2CEPC _BSEG_H2CEPC
_BSEG_H2COMPANY _BSEG_H2COMPANY
_BSEG_H2COMPANY_CODE _BSEG_H2COMPANY_CODE
_BSEG_H2CSKS _BSEG_H2CSKS
_BSEG_H2DD07T _BSEG_H2DD07T
_BSEG_H2KNB1_CUSTOMER _BSEG_H2KNB1_CUSTOMER
_BSEG_H2TKA01 _BSEG_H2TKA01
_LFB1_CUSTOMER2BSEG_H _LFB1_CUSTOMER2BSEG_H
-- Enterprise Search help view 
-- This CDS view represents node BSEG_H of search model ACCT_DOC_LINEITEM_H of search software component SAPAPPLH.
-- This CDS view represents: Accounting Document Segment.
-- CSS component (relevant to Customer Incidents): FI-GL
-- Package: BSESH_FI_GL
-- Software Component: S4CORE
@AbapCatalog.sqlViewName: 'ESH_L_ACCT_SEG_H'
@EndUserText.label: 'Accounting Document Segment'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #INHERITED
@AbapCatalog.compiler.compareFilter: true
define view ESH_N_ACCT_DOC_LINEITEM_BSEG_H
as select from bseg

  association [1..1] to ESH_N_ACCOUNTING_DOC_BKPF      as _BSEG_H2BKPF          on $projection.belnr     = _BSEG_H2BKPF.belnr          and
                                                                                   $projection.gjahr     = _BSEG_H2BKPF.gjahr          and
                                                                                   $projection.bukrs     = _BSEG_H2BKPF.bukrs
  association [0..*] to ESH_N_PROFIT_CENTER_CEPC       as _BSEG_H2CEPC          on $projection.kokrs     = _BSEG_H2CEPC.kokrs          and
                                                                                   $projection.prctr     = _BSEG_H2CEPC.prctr
  association [1..1] to ESH_N_COMPANY_COMPANY          as _BSEG_H2COMPANY       on $projection.vbund     = _BSEG_H2COMPANY.rcomp
  association [1..1] to ESH_N_COMPANY_CODE_OMPANY_CODE as _BSEG_H2COMPANY_CODE  on $projection.bukrs     = _BSEG_H2COMPANY_CODE.bukrs
  association [0..*] to ESH_N_COST_CENTER_CSKS         as _BSEG_H2CSKS          on $projection.kokrs     = _BSEG_H2CSKS.kokrs          and
                                                                                   $projection.kostl     = _BSEG_H2CSKS.kostl
  association [0..*] to dd07t                          as _BSEG_H2DD07T         on $projection.shkzg     = _BSEG_H2DD07T.domvalue_l    and
                                                                                   _BSEG_H2DD07T.domname = 'SHKZG'
  association [1..1] to ESH_N_KNA1_KNB1_KNB1_CUSTOMER  as _BSEG_H2KNB1_CUSTOMER on $projection.bukrs     = _BSEG_H2KNB1_CUSTOMER.bukrs and
                                                                                   $projection.kunnr     = _BSEG_H2KNB1_CUSTOMER.kunnr
  association [1..1] to tka01                          as _BSEG_H2TKA01         on $projection.kokrs     = _BSEG_H2TKA01.kokrs
  association [1..1] to ESH_N_LFA1_LFB1_LFB1_VENDOR    as _LFB1_CUSTOMER2BSEG_H on $projection.lifnr     = _LFB1_CUSTOMER2BSEG_H.lifnr and
                                                                                   $projection.bukrs     = _LFB1_CUSTOMER2BSEG_H.bukrs

{
  key bukrs,
  key belnr,
  key gjahr,
  key buzei,
  buzid,
  augdt,
  augcp,
  augbl,
  bschl,
  koart,
  umskz,
  umsks,
  zumsk,
  shkzg,
  gsber,
  pargb,
  mwskz,
  qsskz,
  dmbtr,
  wrbtr,
  kzbtr,
  pswbt,
  pswsl,
  txbhw,
  txbfw,
  mwsts,
  wmwst,
  hwbas,
  fwbas,
  hwzuz,
  fwzuz,
  shzuz,
  stekz,
  mwart,
  qsshb,
  kursr,
  gbetr,
  bdiff,
  bdif2,
  valut,
  zuonr,
  sgtxt,
  zinkz,
  vbund,
  bewar,
  altkt,
  vorgn,
  fdlev,
  fdgrp,
  fdwbt,
  fdtag,
  fkont,
  kokrs,
  kostl,
  projn,
  aufnr,
  vbeln,
  vbel2,
  posn2,
  anln1,
  anln2,
  anbwa,
  bzdat,
  pernr,
  xhres,
  xkres,
  xopvw,
  xcpdd,
  xsauf,
  xspro,
  xfakt,
  xuman,
  xanet,
  xinve,
  xauto,
  xncop,
  xzahl,
  saknr,
  hkont,
  kunnr,
  lifnr,
  filkd,
  xbilk,
  gvtyp,
  hzuon,
  zfbdt,
  zterm,
  zbd1t,
  zbd2t,
  zbd3t,
  zbd1p,
  zbd2p,
  skfbt,
  sknto,
  wskto,
  zlsch,
  zlspr,
  zbfix,
  hbkid,
  bvtyp,
  nebtr,
  mwsk1,
  dmbt1,
  wrbt1,
  mwsk2,
  dmbt2,
  wrbt2,
  mwsk3,
  dmbt3,
  wrbt3,
  rebzg,
  rebzj,
  rebzz,
  rebzt,
  zollt,
  zolld,
  landl,
  diekz,
  samnr,
  abper,
  vrskz,
  vrsdt,
  disbn,
  disbj,
  wverw,
  anfbn,
  anfbj,
  anfbu,
  anfae,
  blnbt,
  blnkz,
  blnpz,
  mschl,
  mansp,
  madat,
  manst,
  maber,
  esrnr,
  esrre,
  esrpz,
  klibt,
  qsznr,
  qbshb,
  qsfbt,
  navhw,
  navfw,
  matnr,
  werks,
  menge,
  meins,
  erfmg,
  erfme,
  bpmng,
  bprme,
  ebeln,
  ebelp,
  elikz,
  vprsv,
  bwkey,
  rewrt,
  rewwr,
  bonfb,
  bualt,
  psalt,
  nprei,
  spgrp,
  spgrm,
  spgrt,
  stceg,
  egbld,
  eglld,
  rpacq,
  rdiff,
  rdif2,
  prctr,
  xhkom,
  vname,
  recid,
  vptnr,
  vertt,
  vertn,
  depot,
  txjcd,
  dabrz,
  popts,
  fipos,
  kstrg,
  nplnr,
  aufpl,
  aplzl,
  projk,
  paobjnr,
  pasubnr,
  spgrs,
  xegdr,
  lnran,
  hrkft,
  dmbe2,
  dmbe3,
  dmb21,
  dmb22,
  dmb23,
  dmb31,
  dmb32,
  dmb33,
  mwst2,
  mwst3,
  navh2,
  navh3,
  sknt2,
  sknt3,
  bdif3,
  rdif3,
  hwmet,
  glupm,
  xragl,
  uzawe,
  lokkt,
  fistl,
  geber,
  stbuk,
  txbh2,
  txbh3,
  pprct,
  xref1,
  xref2,
  kblnr,
  kblpos,
  sttax,
  fkber,
  obzei,
  rfzei,
  ccbtc,
  kkber,
  empfb,
  xref3,
  dtws1,
  dtws2,
  dtws3,
  dtws4,
  gricd,
  gityp,
  xpypr,
  kidno,
  absbt,
  idxsp,
  linfv,
  kontl,
  txdat,
  agzei,
  pycur,
  pyamt,
  bupla,
  secco,
  lstar,
  cession_kz,
  prznr,
  ppdiff,
  ppdif2,
  ppdif3,
  penlc1,
  penlc2,
  penlc3,
  penfc,
  grant_nbr,
  sctax,
  fkber_long,
  srtype,
  intreno,
  measure,
  auggj,
  ppa_ex_ind,
  docln,
  segment,
  psegment,
  hktid,
  kstar,
  xlgclr,
  taxps,
  pays_prov,
  pays_tran,
  mndid,
  xfrge_bseg,
  pgeber,
  pgrant_nbr,
  budget_pd,
  pbudget_pd,
  perop_beg,
  perop_end,
  fastpay,
  ignr_ivref,
  prodper,
  fs_product_group,
  branch_id,
  datasource_id,
  _BSEG_H2BKPF,
  _BSEG_H2CEPC,
  _BSEG_H2COMPANY,
  _BSEG_H2COMPANY_CODE,
  _BSEG_H2CSKS,
  _BSEG_H2DD07T,
  _BSEG_H2KNB1_CUSTOMER,
  _BSEG_H2TKA01,
  _LFB1_CUSTOMER2BSEG_H
}