1. Home
  2. Resources
  3. SAP Tables
  4. BSEG_ALV - Document Overview: Document Item Display in ALV Grid Control

SAP Table BSEG_ALV

Document Overview: Document Item Display in ALV Grid Control

BSEG_ALV (Document Overview: Document Item Display in ALV Grid Control) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BSEG_ALV to other SAP tables.

BSEG_ALV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS_ALV CHAR 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
DOCLN DOCLN for ALV Grid Control DOCLNALV CHAR 6 0
AUGBL Document Number of the Clearing Document AUGBL CHAR 10 0
BSCHL Posting Key BSCHL TBSL CHAR 2 0
HKONT General Ledger Account HKONT CHAR 10 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
UMSKZ Special G/L Indicator UMSKZ T074U CHAR 1 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
GSBER Business Area GSBER TGSB CHAR 4 0
PARGB Trading partner's business area PARGB TGSB CHAR 4 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
QSSKZ Withholding Tax Code QSSKZ T059Q CHAR 2 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
DMBTR Amount in Local Currency DMBTR CURR 13 2
VALUT Value date VALUT DATS 8 0
ZUONR Assignment Number DZUONR CHAR 18 0
SGTXT Item Text SGTXT CHAR 50 0
VBUND Company ID of trading partner RASSC T880 CHAR 6 0
KOSTL Cost Center KOSTL CHAR 10 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
VBELN Billing Document VBELN_VF VBUK CHAR 10 0
VBEL2 Sales Document VBELN_VA VBUK CHAR 10 0
POSN2 Sales Document Item POSNR_VA VBUP NUMC 6 0
ETEN2 Delivery Schedule Line Number ETENR VBEP NUMC 4 0
XSKRL Indicator: Line item not liable to cash discount? XSKRL CHAR 1 0
X Yes
NULL No
XZAHL Indicator: Is the posting key used in a payment transaction? XZAHL CHAR 1 0
X Yes
NULL No
SAKNR G/L Account Number SAKNR SKB1 CHAR 10 0
FILKD Account Number of the Branch FILKD CHAR 10 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
ZBD1T Cash discount days 1 DZBD1T DEC 3 0
ZBD2T Cash discount days 2 DZBD2T DEC 3 0
ZBD3T Net Payment Terms Period DZBD3T DEC 3 0
ZBD1P Cash Discount Percentage 1 DZBD1P DEC 5 3
ZBD2P Cash Discount Percentage 2 DZBD2P DEC 5 3
ZLSCH Payment Method SCHZW_BSEG T042Z CHAR 1 0
ZLSPR Payment Block Key DZLSPR T008 CHAR 1 0
ZBFIX Fixed Payment Terms DZBFIX CHAR 1 0
NULL No fixing
1 1st cash disc.percentage rate or cash disc.amount is fixed
2 2nd cash discount percentage rate is fixed
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
REBZZ Line Item in the Relevant Invoice REBZZ NUMC 3 0
SAMNR Invoice List Number SAMNR NUMC 8 0
ANFBN Document Number of the Bill of Exchange Payment Request ANFBN CHAR 10 0
MSCHL Dunning key MSCHL T040 CHAR 1 0
MANSP Dunning block MANSP T040S CHAR 1 0
MANST Dunning level MAHNS_D NUMC 1 0
MABER Dunning Area MABER CHAR 2 0
WERKS Plant WERKS_D T001W CHAR 4 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
SPGRP Blocking reason: price SPGRP CHAR 1 0
X Yes
NULL No
SPGRM Blocking reason: quantity SPGRM CHAR 1 0
X Yes
NULL No
SPGRT Blocking Reason: Date SPGRT CHAR 1 0
X Yes
NULL No
SPGRG Blocking reason: order price quantity SPGRG CHAR 1 0
X Yes
NULL No
SPGRV Blocking reason: project budget SPGRV CHAR 1 0
X Yes
NULL No
SPGRQ Manual Blocking Reason SPGRQ CHAR 1 0
X Yes
NULL No
RSTGR Reason Code for Payments RSTGR T053R CHAR 3 0
PRCTR Profit Center PRCTR CHAR 10 0
VNAME Joint Venture JV_NAME CHAR 6 0
EGRUP Equity group JV_EGROUP CHAR 3 0
BTYPE Payroll Type JV_BILIND CHAR 2 0
RECID Recovery Indicator JV_RECIND CHAR 2 0
VPTNR Partner account number JV_PART CHAR 10 0
VERTT Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
VERTN Contract Number RANL CHAR 13 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
FIPOS Commitment Item FIPOS CHAR 14 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
AUFPL Task list number for operations in order AUFPL_CH NUMC 10 0
APLZL General counter for order APLZL_CH NUMC 8 0
UZAWE Payment Method Supplement UZAWE T042F CHAR 2 0
FISTL Funds Center FISTL CHAR 16 0
GEBER Fund BP_GEBER CHAR 10 0
STBUK Tax Company Code STBUK CHAR 4 0
XREF1 Business partner reference key XREF1 CHAR 12 0
XREF2 Business partner reference key XREF2 CHAR 12 0
EMPFB Payee/Payer EMPFB CHAR 10 0
XREF3 Reference key for line item XREF3 CHAR 20 0
PYCUR Currency for Automatic Payment PYCUR TCURC CUKY 5 0
PYAMT Amount in Payment Currency PYAMT CURR 13 2
BUPLA Business Place BUPLA J_1BBRANCH CHAR 4 0
SECCO Section Code SECCO SECCODE CHAR 4 0
KKBER Credit control area KKBER CHAR 4 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
KBLNR Document Number for Earmarked Funds KBLNR_FI CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
PPRCT Partner Profit Center PPRCTR CHAR 10 0
BEWAR Transaction Type RMVCT CHAR 3 0
FDLEV Planning level FDLEV CHAR 2 0
FDGRP Planning Group FDGRP CHAR 10 0
ANBWA Asset Transaction Type ANBWA CHAR 3 0
BZDAT Asset value date BZDAT DATS 8 0
PERNR Personnel Number PERNR_D NUMC 8 0
XINVE Indicator: Capital Goods Affected? XINVE CHAR 1 0
X Yes
NULL No
HZUON Assignment Number for Special G/L Accounts HZUON CHAR 18 0
SKFBT Amount Eligible for Cash Discount in Document Currency SKFBT CURR 13 2
HBKID Short Key for a House Bank HBKID CHAR 5 0
BVTYP Partner Bank Type BVTYP CHAR 4 0
LZBKZ State Central Bank Indicator LZBKZ CHAR 3 0
LANDL Supplying Country LANDL CHAR 3 0
ABPER Settlement period ABPER_RF ACCP 6 0
VRSKZ Insurance indicator VRSKZ CHAR 1 0
VRSDT Insurance date VRSDT DATS 8 0
ESRNR ISR Subscriber Number ESRNR CHAR 11 0
ESRRE ISR Reference Number ESRRE CHAR 27 0
ESRPZ ISR Check Digit ESRPZ CHAR 2 0
QSZNR Certificate Number of the Withholding Tax Exemption QSZNR CHAR 10 0
QBSHB Withholding Tax Amount (in Document Currency) QBSHB CURR 13 2
QSFBT Withholding Tax-Exempt Amount (in Document Currency) QSFBT CURR 13 2
MATNR Material Number MATNR CHAR 18 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
STCEG VAT Registration Number STCEG CHAR 20 0
EGBLD Country of Destination for Delivery of Goods EGBLD CHAR 3 0
EGLLD Supplying Country for Delivery of Goods EGLLD CHAR 3 0
VBEWA Flow Type SBEWART CHAR 4 0
XNEGP Indicator: Negative posting XNEGP CHAR 1 0
X Yes
NULL No
GRICD Activity Code for Gross Income Tax J_1AGICD_D CHAR 2 0
GRIRG Region (State, Province, County) REGIO CHAR 3 0
GITYP Distribution Type for Employment Tax J_1ADTYP_D CHAR 2 0
KIDNO Payment Reference KIDNO CHAR 30 0
FKBER_LONG Functional Area FKBER CHAR 16 0
HWAER Local Currency HWAER CUKY 5 0
WAERS Currency Key WAERS CUKY 5 0
RF05A_UBAZW Currency Key AZWAE CUKY 5 0
KOBEZ Account Description KOBEZ CHAR 30 0
KTONR Account Number KTONR_AV CHAR 10 0
AZBET Display Amount AZBET_F05A CURR 17 2
AZSTE Display Tax Amount AZSTE_F05A CURR 15 2
HKBEZ Name of the General Ledger Account HKBEZ CHAR 20 0
VORNR Operation/Activity Number VORNR CHAR 4 0
XCORR Indicator: Correct Item? XCORR CHAR 1 0
X true
- false
NULL unknown
PSWBT Amount for Updating in General Ledger PSWBT CURR 13 2
PSWSL Update Currency for General Ledger Transaction Figures PSWSL CUKY 5 0
LOKKT Alternative account number in company code ALTKT_SKB1 CHAR 10 0
DISBN Number of Bill of Exchange Usage Document (Discount Doc.) DISBN CHAR 10 0
FASTPAY PPA Fast Pay Indicator FMFG_FASTPAY_FLG CHAR 1 0
X Yes
NULL No
PPA_EX_IND PPA Exclude Indicator EXCLUDE_FLG CHAR 1 0
X Yes
NULL No
PEROP_BEG Billing Period of Performance Start Date FM_PEROP_FI_LOW DATS 8 0
PEROP_END Billing Period of Performance End Date FM_PEROP_FI_HIGH DATS 8 0
MARKED_ALV Marking of Position to Be Corrected MARKED_ALV CHAR 1 0
PROJK_EXT Individual Structural Element (WBS Element) in Ext. Format PROJK_EXT CHAR 24 0
SEGMENT Segment for Segmental Reporting FB_SEGMENT CHAR 10 0
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT CHAR 10 0
PFKBER Partner Functional Area SFKBER CHAR 16 0
PGEBER Partner Fund FM_PFUND CHAR 10 0
PGRANT_NBR Partner Grant GM_PGRANT_NBR CHAR 20 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
KTOSL Transaction Key KTOSL CHAR 3 0
XAUTO Indicator: Line item automatically created XAUTO CHAR 1 0
X Yes
NULL No
PKOSTL Sender cost center SKOST CHAR 10 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
PBUDGET_PD FM: Partner Budget Period FM_PBUDGET_PERIOD CHAR 10 0
DMBE2 Amount in Second Local Currency DMBE2 CURR 13 2
HWAE2 Currency Key of Second Local Currency HWAE2 CUKY 5 0
DMBE3 Amount in Third Local Currency DMBE3 CURR 13 2
HWAE3 Currency Key of Third Local Currency HWAE3 CUKY 5 0
TAXPS Tax document item number TAX_POSNR NUMC 6 0
RE_BUKRS Cash Ledger: Company Code for Expense/Revenue FAGL_RE_BUKRS CHAR 4 0
RE_ACCOUNT Cash Ledger: Expense or Revenue Account FAGL_RE_ACCOUNT CHAR 10 0
PRODPER JVA_PROD_MONTH ACCP 6 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0

BSEG_ALV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BSEG_ALV AUFNR BSEG_ALV MANDT AUFK Order master data MANDT
BSEG_ALV AUFNR BSEG_ALV AUFNR AUFK Order master data AUFNR
BSEG_ALV BSCHL BSEG_ALV MANDT TBSL Posting Key MANDT
BSEG_ALV BSCHL BSEG_ALV BSCHL TBSL Posting Key BSCHL
BSEG_ALV BUPLA BSEG_ALV BUPLA J_1BBRANCH Business Place BRANCH
BSEG_ALV BUPLA BSEG_ALV MANDT J_1BBRANCH Business Place MANDT
BSEG_ALV BUPLA BSEG_ALV BUKRS J_1BBRANCH Business Place BUKRS
BSEG_ALV EBELN BSEG_ALV MANDT EKKO Purchasing Document Header MANDT
BSEG_ALV EBELN BSEG_ALV EBELN EKKO Purchasing Document Header EBELN
BSEG_ALV EBELP BSEG_ALV MANDT EKPO Purchasing Document Item MANDT
BSEG_ALV EBELP BSEG_ALV EBELN EKPO Purchasing Document Item EBELN
BSEG_ALV EBELP BSEG_ALV EBELP EKPO Purchasing Document Item EBELP
BSEG_ALV ETEN2 BSEG_ALV POSN2 VBEP Sales Document: Schedule Line Data POSNR
BSEG_ALV ETEN2 BSEG_ALV ETEN2 VBEP Sales Document: Schedule Line Data ETENR
BSEG_ALV ETEN2 BSEG_ALV MANDT VBEP Sales Document: Schedule Line Data MANDT
BSEG_ALV ETEN2 BSEG_ALV VBEL2 VBEP Sales Document: Schedule Line Data VBELN
BSEG_ALV GSBER BSEG_ALV GSBER TGSB Business Areas GSBER
BSEG_ALV GSBER BSEG_ALV MANDT TGSB Business Areas MANDT
BSEG_ALV MANDT BSEG_ALV MANDT T000 Clients MANDT
BSEG_ALV MANSP BSEG_ALV MANSP T040S Blocking reasons for dunning notices MANSP
BSEG_ALV MANSP BSEG_ALV MANDT T040S Blocking reasons for dunning notices MANDT
BSEG_ALV MSCHL BSEG_ALV MANDT T040 Dunning keys MANDT
BSEG_ALV MSCHL BSEG_ALV MSCHL T040 Dunning keys MSCHL
BSEG_ALV MWSKZ BSEG_ALV MANDT T007A Tax Keys MANDT
BSEG_ALV MWSKZ T005 KALSM T007A Tax Keys KALSM
BSEG_ALV MWSKZ BSEG_ALV MWSKZ T007A Tax Keys MWSKZ
BSEG_ALV PARGB BSEG_ALV MANDT TGSB Business Areas MANDT
BSEG_ALV PARGB BSEG_ALV PARGB TGSB Business Areas GSBER
BSEG_ALV POSN2 BSEG_ALV MANDT VBUP Sales Document: Item Status MANDT
BSEG_ALV POSN2 BSEG_ALV VBEL2 VBUP Sales Document: Item Status VBELN
BSEG_ALV POSN2 BSEG_ALV POSN2 VBUP Sales Document: Item Status POSNR
BSEG_ALV PYCUR BSEG_ALV MANDT TCURC Currency Codes MANDT
BSEG_ALV PYCUR BSEG_ALV PYCUR TCURC Currency Codes WAERS
BSEG_ALV QSSKZ BSEG_ALV QSSKZ T059Q Withholding Tax QSSKZ
BSEG_ALV QSSKZ BSEG_ALV MANDT T059Q Withholding Tax MANDT
BSEG_ALV QSSKZ T001 LAND1 T059Q Withholding Tax LAND1
BSEG_ALV RSTGR BSEG_ALV MANDT T053R Classification of Payment Differences MANDT
BSEG_ALV RSTGR BSEG_ALV BUKRS T053R Classification of Payment Differences BUKRS
BSEG_ALV RSTGR BSEG_ALV RSTGR T053R Classification of Payment Differences RSTGR
BSEG_ALV SAKNR BSEG_ALV BUKRS SKB1 G/L account master (company code) BUKRS
BSEG_ALV SAKNR BSEG_ALV SAKNR SKB1 G/L account master (company code) SAKNR
BSEG_ALV SAKNR BSEG_ALV MANDT SKB1 G/L account master (company code) MANDT
BSEG_ALV SECCO BSEG_ALV MANDT SECCODE Section Code MANDT
BSEG_ALV SECCO BSEG_ALV BUKRS SECCODE Section Code BUKRS
BSEG_ALV SECCO BSEG_ALV SECCO SECCODE Section Code SECCODE
BSEG_ALV UMSKZ BSEG_ALV MANDT T074U Special G/L Indicator Properties MANDT
BSEG_ALV UMSKZ BSEG_ALV KOART T074U Special G/L Indicator Properties KOART
BSEG_ALV UMSKZ BSEG_ALV UMSKZ T074U Special G/L Indicator Properties UMSKZ
BSEG_ALV UZAWE BSEG_ALV MANDT T042F Payment method supplements MANDT
BSEG_ALV UZAWE BSEG_ALV UZAWE T042F Payment method supplements UZAWE
BSEG_ALV VBEL2 BSEG_ALV MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
BSEG_ALV VBEL2 BSEG_ALV VBEL2 VBUK Sales Document: Header Status and Administrative Data VBELN
BSEG_ALV VBELN BSEG_ALV VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
BSEG_ALV VBELN BSEG_ALV MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
BSEG_ALV VBUND BSEG_ALV VBUND T880 Global Company Data (for KONS Ledger) RCOMP
BSEG_ALV VBUND BSEG_ALV MANDT T880 Global Company Data (for KONS Ledger) MANDT
BSEG_ALV WERKS BSEG_ALV MANDT T001W Plants/Branches MANDT
BSEG_ALV WERKS BSEG_ALV WERKS T001W Plants/Branches WERKS
BSEG_ALV ZLSCH BSEG_ALV MANDT T042Z Payment Methods for Automatic Payment MANDT
BSEG_ALV ZLSCH T001 LAND1 T042Z Payment Methods for Automatic Payment LAND1
BSEG_ALV ZLSCH BSEG_ALV ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
BSEG_ALV ZLSPR BSEG_ALV MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
BSEG_ALV ZLSPR BSEG_ALV ZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
BSEG_ALV ZZREGION SYST MANDT ZREG User Defined Regions MANDT
BSEG_ALV ZZREGION BSEG_ALV ZZREGION ZREG User Defined Regions ZZREGION
BSEG_ALV ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
BSEG_ALV ZZSPREG BSEG_ALV ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
BSEG_ALV ZZSTATE * T005S Taxes: Region (Province) Key LAND1
BSEG_ALV ZZSTATE BSEG_ALV ZZSTATE T005S Taxes: Region (Province) Key BLAND
BSEG_ALV ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
BSEG_ALV ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT
BSEG_ALV ZZUSERFLD1 BSEG_ALV ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1