ESH_N_ACCT_DOC_LINEITEM_BSEG_H

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 ESH_N_ACCT_DOC_LINEITEM_BSEG_H.
-- 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: ESH_L_ACCT_SEG_H

CREATE VIEW ESH_N_ACCT_DOC_LINEITEM_BSEG_H AS
SELECT
  bukrs,
  belnr,
  gjahr,
  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,
  branch_id
FROM bseg
LEFT OUTER JOIN ESH_N_ACCOUNTING_DOC_BKPF AS _BSEG_H2BKPF ON belnr = _BSEG_H2BKPF.belnr AND gjahr = _BSEG_H2BKPF.gjahr AND bukrs = _BSEG_H2BKPF.bukrs  -- association [1..1]
LEFT OUTER JOIN ESH_N_PROFIT_CENTER_CEPC AS _BSEG_H2CEPC ON kokrs = _BSEG_H2CEPC.kokrs AND prctr = _BSEG_H2CEPC.prctr  -- association [0..*]
LEFT OUTER JOIN ESH_N_COMPANY_COMPANY AS _BSEG_H2COMPANY ON vbund = _BSEG_H2COMPANY.rcomp  -- association [1..1]
LEFT OUTER JOIN ESH_N_COMPANY_CODE_OMPANY_CODE AS _BSEG_H2COMPANY_CODE ON bukrs = _BSEG_H2COMPANY_CODE.bukrs  -- association [1..1]
LEFT OUTER JOIN ESH_N_COST_CENTER_CSKS AS _BSEG_H2CSKS ON kokrs = _BSEG_H2CSKS.kokrs AND kostl = _BSEG_H2CSKS.kostl  -- association [0..*]
LEFT OUTER JOIN dd07t AS _BSEG_H2DD07T ON shkzg = _BSEG_H2DD07T.domvalue_l AND _BSEG_H2DD07T.domname = 'SHKZG'  -- association [0..*]
LEFT OUTER JOIN ESH_N_KNA1_KNB1_KNB1_CUSTOMER AS _BSEG_H2KNB1_CUSTOMER ON bukrs = _BSEG_H2KNB1_CUSTOMER.bukrs AND kunnr = _BSEG_H2KNB1_CUSTOMER.kunnr  -- association [1..1]
LEFT OUTER JOIN tka01 AS _BSEG_H2TKA01 ON kokrs = _BSEG_H2TKA01.kokrs  -- association [1..1]
LEFT OUTER JOIN ESH_N_LFA1_LFB1_LFB1_VENDOR AS _LFB1_CUSTOMER2BSEG_H ON lifnr = _LFB1_CUSTOMER2BSEG_H.lifnr AND bukrs = _LFB1_CUSTOMER2BSEG_H.bukrs  -- association [1..1]
;