BSEG_ADD

Transparent Table Application Table
161 Fields 11 CDS Views

Entry View of Accounting Document for Additional Ledgers

BSEG_ADD is an SAP database table in S/4HANA. Entry View of Accounting Document for Additional Ledgers. It contains 161 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
FACVD_GLLGMC_WLI_03 view left_outer OPEN ITEMS
FACVD_GLMC_OIT view union_all GL Open Items select to clearing
FACVD_GLMC_OIT_04 view union_all GL Open Items to be cleared
fgl_lib_c view_entity union_all LIB Base View
FINS_CNV_CONVERSION_BSEG_ADD view from Currency Conversion: View Conv BSEG_ADD
fiscds_bsegadd_p view from Projection on BSEG_ADD
fiscds_litb_gl_01 view union_all Line Item Browser: DDL Source
FISCDS_TRK_DOC_03 view from Change History for Ledger View
FISCDS_TRK_DOC_03 view union Change History for Ledger View
P_Bseg_Add view from BASIC
P_Bseg_Add_Com1 view from BASIC

Fields (161)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY belnr BELNR_D Document Number
KEY gjahr GJAHR Fiscal Year
KEY buzei BUZEI6 Item
bstat BSTAT_D Document Status
buzid BUZID Line Item ID
bschl BSCHL Posting Key
koart KOART Account type
shkzg SHKZG Debit/Credit
mwskz MWSKZ Tax Code
dmbtr BF_DMBTR Amount in local currency
wrbtr BF_WRBTR Amount in transaction currency
fcsl FINS_VFCCUR12 Amount in FunctCrcy
rfccur FINS_CURRFC Functional Currency
ktosl KTOSL Transaction
valut VALUT Value date
zuonr DZUONR Assignment
sgtxt SGTXT Text
vbund VBUND Company ID
bewar BEWAR Cons.Trans.Type
altkt BILKT_SKA1 Group Account Number
vorgn VORGN Transact. Type
kokrs KOKRS CO Area
kostl KOSTL Cost Center
aufnr AUFNR Order
anln1 ANLN1 Asset
anln2 ANLN2 Sub-number
anbwa ANBWA Ast Transaction Type
xauto XAUTO Auto. created
xncop XNCOP Indicator: Items Cannot Be Copied?
hkont HKONT G/L Acct
xbilk XBILK Balance sheet acct
gvtyp GVTYP P&L state. acct
matnr MATNR Material
werks WERKS_D Plant
menge MENGE_D Quantity
meins MEINS Base Unit
prctr PRCTR Profit Center
vname JV_NAME Joint venture
recid JV_RECIND Recovery Ind.
egrup JV_EGROUP Equity group
vptnr JV_PART Partner
txjcd TXJCD Tax Jur.
fipos FIPOS Commitment item
kstrg KSTRG Cost Object
nplnr NPLNR Network
aufpl AUFPL_CH TaskList No.Ops
aplzl APLZL_CH Counter
projk PS_PSP_PNR WBS Element
paobjnr RKEOBJNR Profit. segment
pasubnr RKESUBNR Subnumber
dmbe2 BF_DMBE2 LC2 Amount
dmbe3 BF_DMBE3 LC3 Amount
lokkt ALTKT_SKB1 Altern. Account
fistl FISTL Funds Center
geber BP_GEBER Fund
pprct PPRCTR Partner PC
xref1 XREF1 Reference Key 1
xref2 XREF2 Reference Key 2
kblnr KBLNR_FI Earmarked funds
kblpos KBLPOS Document Item
obzei OBZEI Original Item
xnegp XNEGP Negative Postg
xref3 XREF3 Reference Key 3
kontt KONTT_FI Acct Assmt Cat.
kontl KONTL_FI Acct assignment
bupla BUPLA Business place
secco SECCO Section Code
lstar LSTAR Activity Type
prznr CO_PRZNR Business Process
grant_nbr GM_GRANT_NBR Grant
fkber FKBER Functional Area
measure FM_MEASURE Funded Program
segment FB_SEGMENT Segment
psegment FB_PSEGMENT Partner Segment
gsber GSBER Business Area
pgeber FM_PFUND Partner Fund
pgrant_nbr GM_GRANT_PARTNER Partner Grant
budget_pd FM_BUDGET_PERIOD Budget Period
pbudget_pd FM_PBUDGET_PERIOD Par. BudPer
pswsl PSWSL G/L Currency
pswbt BF_PSWBT G/L Amount
dummy_incl_eew_cobl CFD_DUMMY Dummy
pfkber SFKBER Partner FArea
rebzg REBZG Invoice Ref.
rebzj REBZJ Fiscal Year
rebzz REBZZ Item
rebzt REBZT Follow-On Doc. Type
xlgclr XLGCLR OI Mgmt by LedgerGrp
augdt AUGDT Clearing
augcp AUGCP ClearingEntDate
augbl AUGBL Clrng doc.
auggj AUGGJ Clrg Fiscal Yr
agzei AGZEI Clearing Item
rdiff RDIFF Diff. Realized
rdif2 RDIF2 Diff.Realized 2
rdif3 RDIF3 Diff.Realized 3
xragl XRAGL Reverse Clearing
kstar KSTAR Cost Element
pargb PARGB Trdg Part.BA
bwkey BWKEY Valuation Area
bwtar BWTAR_D Valuation Type
vertt RANTYP Contract Type
vertn RANL Contract Number
vbewa SBEWART Flow Type
vbeln VBELN_VF Billing Doc.
vbel2 VBELN_VA Sales Document
posn2 POSNR_VA Item
eten2 ETENR Schedule Line
ebeln_logsys EBELN_LOGSYS LogSys of PurchDoc
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
zekkn DZEKKN Account Assgmt No.
gkont GKONT Offsetting Acct
gkart GKOAR Offst.Acct Type
ghkon GHKONT G/L Offsetting Acct
buzei_sender BUZEI_SENDER Sender Item
_dataaging DATA_TEMPERATURE Data Aging
acrobjtype ACR_OBJ_TYPE Accrual Object Type
acrlogsys ACR_LOGSYS Logical Syst. AcrObj
acrobj_id ACR_OBJ_ID Accrual Object
acrsobj_id ACR_SUBOBJ_ID Accrual Subobject
acritmtype ACR_ITEM_TYPE Accrual Item Type
acrrefobj_id ACR_REFOBJ_ID Acr. Reference ID
acrvaldat ACR_VALUE_DATE Accrual Value Date
valobjtype VAL_OBJ_TYPE Type of Fin.Val.Obj.
valobj_id VAL_OBJ_ID Fin Valuation Object
valsobj_id VAL_SUBOBJ_ID Fin.Val.Sub.Object
netdt NETDT Due On
risk_class UKM_RISK_CLASS Risk Class
sdm_version FINS_SDM_VERSION_BSEG SDM Versioning
hbkid HBKID House Bank
hktid HKTID Account ID
re_bukrs FAGL_RE_BUKRS Company Code
re_account FAGL_RE_ACCOUNT Ex/Rv A/c in CL
bdif2 BDIF2 Valuation Diff. 2
bdif3 BDIF3 Valuation Diff. 3
bdiff BDIFF Valuation Diff.
ccbtc CCBTC Settlement
dabrz DABRBEZ Reference date
fkont FIPLS Fin.Budget
imkey IMKEY Real Estate Key
intreno VVINTRENO RE code
mwst2 MWST2 LC2 Tax
mwst3 MWST3 LC3 Tax
mwsts MWSTS LC Tax
ppdif2 PPDIF2 Diff. Realized
ppdif3 PPDIF3 Diff. Realized
ppdiff PPDIFF Diff. Realized
prodper JV_PRODPER Prod.Month
projn PROJN not in use
qsskz QSSKZ WTax Code
rfzei RFZEI_CC Payt Card Item
uzawe UZAWE Pmnt Meth. Sup.
wmwst WMWST Tax Amount
wverw WVERW Usage
xopvw XOPVW OI Management
zfbdt DZFBDT Baseline Date
bdgt_account PSM_BDGT_ACCOUNT Budget Account
bdgt_account_cocode PSM_BDGT_ACCOUNT_COCODE Company Code for Budget Account

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Entry View of Accounting Document for Additional Ledgers
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BSEG_ADD (
    MANDT,                -- Client [MANDT]
    BUKRS,                -- Company Code [BUKRS]
    BELNR,                -- Document Number [BELNR_D]
    GJAHR,                -- Fiscal Year [GJAHR]
    BUZEI,                -- Item [BUZEI6]
    BSTAT,                -- Document Status [BSTAT_D]
    BUZID,                -- Line Item ID [BUZID]
    BSCHL,                -- Posting Key [BSCHL]
    KOART,                -- Account type [KOART]
    SHKZG,                -- Debit/Credit [SHKZG]
    MWSKZ,                -- Tax Code [MWSKZ]
    DMBTR,                -- Amount in local currency [BF_DMBTR]
    WRBTR,                -- Amount in transaction currency [BF_WRBTR]
    FCSL,                 -- Amount in FunctCrcy [FINS_VFCCUR12]
    RFCCUR,               -- Functional Currency [FINS_CURRFC]
    KTOSL,                -- Transaction [KTOSL]
    VALUT,                -- Value date [VALUT]
    ZUONR,                -- Assignment [DZUONR]
    SGTXT,                -- Text [SGTXT]
    VBUND,                -- Company ID [VBUND]
    BEWAR,                -- Cons.Trans.Type [BEWAR]
    ALTKT,                -- Group Account Number [BILKT_SKA1]
    VORGN,                -- Transact. Type [VORGN]
    KOKRS,                -- CO Area [KOKRS]
    KOSTL,                -- Cost Center [KOSTL]
    AUFNR,                -- Order [AUFNR]
    ANLN1,                -- Asset [ANLN1]
    ANLN2,                -- Sub-number [ANLN2]
    ANBWA,                -- Ast Transaction Type [ANBWA]
    XAUTO,                -- Auto. created [XAUTO]
    XNCOP,                -- Indicator: Items Cannot Be Copied? [XNCOP]
    HKONT,                -- G/L Acct [HKONT]
    XBILK,                -- Balance sheet acct [XBILK]
    GVTYP,                -- P&L state. acct [GVTYP]
    MATNR,                -- Material [MATNR]
    WERKS,                -- Plant [WERKS_D]
    MENGE,                -- Quantity [MENGE_D]
    MEINS,                -- Base Unit [MEINS]
    PRCTR,                -- Profit Center [PRCTR]
    VNAME,                -- Joint venture [JV_NAME]
    RECID,                -- Recovery Ind. [JV_RECIND]
    EGRUP,                -- Equity group [JV_EGROUP]
    VPTNR,                -- Partner [JV_PART]
    TXJCD,                -- Tax Jur. [TXJCD]
    FIPOS,                -- Commitment item [FIPOS]
    KSTRG,                -- Cost Object [KSTRG]
    NPLNR,                -- Network [NPLNR]
    AUFPL,                -- TaskList No.Ops [AUFPL_CH]
    APLZL,                -- Counter [APLZL_CH]
    PROJK,                -- WBS Element [PS_PSP_PNR]
    PAOBJNR,              -- Profit. segment [RKEOBJNR]
    PASUBNR,              -- Subnumber [RKESUBNR]
    DMBE2,                -- LC2 Amount [BF_DMBE2]
    DMBE3,                -- LC3 Amount [BF_DMBE3]
    LOKKT,                -- Altern. Account [ALTKT_SKB1]
    FISTL,                -- Funds Center [FISTL]
    GEBER,                -- Fund [BP_GEBER]
    PPRCT,                -- Partner PC [PPRCTR]
    XREF1,                -- Reference Key 1 [XREF1]
    XREF2,                -- Reference Key 2 [XREF2]
    KBLNR,                -- Earmarked funds [KBLNR_FI]
    KBLPOS,               -- Document Item [KBLPOS]
    OBZEI,                -- Original Item [OBZEI]
    XNEGP,                -- Negative Postg [XNEGP]
    XREF3,                -- Reference Key 3 [XREF3]
    KONTT,                -- Acct Assmt Cat. [KONTT_FI]
    KONTL,                -- Acct assignment [KONTL_FI]
    BUPLA,                -- Business place [BUPLA]
    SECCO,                -- Section Code [SECCO]
    LSTAR,                -- Activity Type [LSTAR]
    PRZNR,                -- Business Process [CO_PRZNR]
    GRANT_NBR,            -- Grant [GM_GRANT_NBR]
    FKBER,                -- Functional Area [FKBER]
    MEASURE,              -- Funded Program [FM_MEASURE]
    SEGMENT,              -- Segment [FB_SEGMENT]
    PSEGMENT,             -- Partner Segment [FB_PSEGMENT]
    GSBER,                -- Business Area [GSBER]
    PGEBER,               -- Partner Fund [FM_PFUND]
    PGRANT_NBR,           -- Partner Grant [GM_GRANT_PARTNER]
    BUDGET_PD,            -- Budget Period [FM_BUDGET_PERIOD]
    PBUDGET_PD,           -- Par. BudPer [FM_PBUDGET_PERIOD]
    PSWSL,                -- G/L Currency [PSWSL]
    PSWBT,                -- G/L Amount [BF_PSWBT]
    DUMMY_INCL_EEW_COBL,  -- Dummy [CFD_DUMMY]
    PFKBER,               -- Partner FArea [SFKBER]
    REBZG,                -- Invoice Ref. [REBZG]
    REBZJ,                -- Fiscal Year [REBZJ]
    REBZZ,                -- Item [REBZZ]
    REBZT,                -- Follow-On Doc. Type [REBZT]
    XLGCLR,               -- OI Mgmt by LedgerGrp [XLGCLR]
    AUGDT,                -- Clearing [AUGDT]
    AUGCP,                -- ClearingEntDate [AUGCP]
    AUGBL,                -- Clrng doc. [AUGBL]
    AUGGJ,                -- Clrg Fiscal Yr [AUGGJ]
    AGZEI,                -- Clearing Item [AGZEI]
    RDIFF,                -- Diff. Realized [RDIFF]
    RDIF2,                -- Diff.Realized 2 [RDIF2]
    RDIF3,                -- Diff.Realized 3 [RDIF3]
    XRAGL,                -- Reverse Clearing [XRAGL]
    KSTAR,                -- Cost Element [KSTAR]
    PARGB,                -- Trdg Part.BA [PARGB]
    BWKEY,                -- Valuation Area [BWKEY]
    BWTAR,                -- Valuation Type [BWTAR_D]
    VERTT,                -- Contract Type [RANTYP]
    VERTN,                -- Contract Number [RANL]
    VBEWA,                -- Flow Type [SBEWART]
    VBELN,                -- Billing Doc. [VBELN_VF]
    VBEL2,                -- Sales Document [VBELN_VA]
    POSN2,                -- Item [POSNR_VA]
    ETEN2,                -- Schedule Line [ETENR]
    EBELN_LOGSYS,         -- LogSys of PurchDoc [EBELN_LOGSYS]
    EBELN,                -- Purchasing Doc. [EBELN]
    EBELP,                -- Item [EBELP]
    ZEKKN,                -- Account Assgmt No. [DZEKKN]
    GKONT,                -- Offsetting Acct [GKONT]
    GKART,                -- Offst.Acct Type [GKOAR]
    GHKON,                -- G/L Offsetting Acct [GHKONT]
    BUZEI_SENDER,         -- Sender Item [BUZEI_SENDER]
    _DATAAGING,           -- Data Aging [DATA_TEMPERATURE]
    ACROBJTYPE,           -- Accrual Object Type [ACR_OBJ_TYPE]
    ACRLOGSYS,            -- Logical Syst. AcrObj [ACR_LOGSYS]
    ACROBJ_ID,            -- Accrual Object [ACR_OBJ_ID]
    ACRSOBJ_ID,           -- Accrual Subobject [ACR_SUBOBJ_ID]
    ACRITMTYPE,           -- Accrual Item Type [ACR_ITEM_TYPE]
    ACRREFOBJ_ID,         -- Acr. Reference ID [ACR_REFOBJ_ID]
    ACRVALDAT,            -- Accrual Value Date [ACR_VALUE_DATE]
    VALOBJTYPE,           -- Type of Fin.Val.Obj. [VAL_OBJ_TYPE]
    VALOBJ_ID,            -- Fin Valuation Object [VAL_OBJ_ID]
    VALSOBJ_ID,           -- Fin.Val.Sub.Object [VAL_SUBOBJ_ID]
    NETDT,                -- Due On [NETDT]
    RISK_CLASS,           -- Risk Class [UKM_RISK_CLASS]
    SDM_VERSION,          -- SDM Versioning [FINS_SDM_VERSION_BSEG]
    HBKID,                -- House Bank [HBKID]
    HKTID,                -- Account ID [HKTID]
    RE_BUKRS,             -- Company Code [FAGL_RE_BUKRS]
    RE_ACCOUNT,           -- Ex/Rv A/c in CL [FAGL_RE_ACCOUNT]
    BDIF2,                -- Valuation Diff. 2 [BDIF2]
    BDIF3,                -- Valuation Diff. 3 [BDIF3]
    BDIFF,                -- Valuation Diff. [BDIFF]
    CCBTC,                -- Settlement [CCBTC]
    DABRZ,                -- Reference date [DABRBEZ]
    FKONT,                -- Fin.Budget [FIPLS]
    IMKEY,                -- Real Estate Key [IMKEY]
    INTRENO,              -- RE code [VVINTRENO]
    MWST2,                -- LC2 Tax [MWST2]
    MWST3,                -- LC3 Tax [MWST3]
    MWSTS,                -- LC Tax [MWSTS]
    PPDIF2,               -- Diff. Realized [PPDIF2]
    PPDIF3,               -- Diff. Realized [PPDIF3]
    PPDIFF,               -- Diff. Realized [PPDIFF]
    PRODPER,              -- Prod.Month [JV_PRODPER]
    PROJN,                -- not in use [PROJN]
    QSSKZ,                -- WTax Code [QSSKZ]
    RFZEI,                -- Payt Card Item [RFZEI_CC]
    UZAWE,                -- Pmnt Meth. Sup. [UZAWE]
    WMWST,                -- Tax Amount [WMWST]
    WVERW,                -- Usage [WVERW]
    XOPVW,                -- OI Management [XOPVW]
    ZFBDT,                -- Baseline Date [DZFBDT]
    BDGT_ACCOUNT,         -- Budget Account [PSM_BDGT_ACCOUNT]
    BDGT_ACCOUNT_COCODE,  -- Company Code for Budget Account [PSM_BDGT_ACCOUNT_COCODE]
    PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, BUZEI)
);

Learn More