SAP Table BSID - Accounting: Secondary Index for Customers

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BUKRS X BUKRS CHAR 3 4 0 T001 Company Code
KUNNR X KUNNR CHAR 7 10 0 KNA1 Customer Number
UMSKS X UMSKS CHAR 17 1 0 Special G/L Transaction Type
UMSKZ X UMSKZ CHAR 18 1 0 Special G/L Indicator
AUGDT X AUGDT DATS 19 8 0 Clearing Date
AUGBL X AUGBL CHAR 27 10 0 Document Number of the Clearing Document
ZUONR X DZUONR CHAR 37 18 0 Assignment Number
GJAHR X GJAHR NUMC 55 4 0 Fiscal Year
BELNR X BELNR_D CHAR 59 10 0 Accounting Document Number
BUZEI X BUZEI NUMC 69 3 0 Number of Line Item Within Accounting Document
BUDAT BUDAT DATS 72 8 0 Posting Date in the Document
BLDAT BLDAT DATS 80 8 0 Document Date in Document
CPUDT CPUDT DATS 88 8 0 Day On Which Accounting Document Was Entered
WAERS WAERS CUKY 96 5 0 TCURC Currency Key
XBLNR XBLNR1 CHAR 101 16 0 Reference Document Number
BLART BLART CHAR 117 2 0 T003 Document Type
MONAT MONAT NUMC 119 2 0 Fiscal Period
BSCHL BSCHL CHAR 121 2 0 TBSL Posting Key
ZUMSK DZUMSK CHAR 123 1 0 Target Special G/L Indicator
SHKZG SHKZG CHAR 124 1 0 Debit/Credit Indicator
GSBER GSBER CHAR 125 4 0 TGSB Business Area
MWSKZ MWSKZ CHAR 129 2 0 Sales Tax Code
DMBTR DMBTR CURR 131 13 2 Amount in Local Currency
WRBTR WRBTR CURR 138 13 2 Amount in Document Currency
MWSTS MWSTS CURR 145 13 2 Tax Amount in Local Currency
WMWST WMWST CURR 152 13 2 Tax Amount in Document Currency
BDIFF BDIFF CURR 159 13 2 Valuation Difference
BDIF2 BDIF2 CURR 166 13 2 Valuation Difference for the Second Local Currency
SGTXT SGTXT CHAR 173 50 0 Item Text
PROJN PROJN CHAR 223 16 0 Old: Project number : No longer used --> PS_POSNR
AUFNR AUFNR CHAR 239 12 0 AUFK Order Number
ANLN1 ANLN1 CHAR 251 12 0 ANLH Main Asset Number
ANLN2 ANLN2 CHAR 263 4 0 ANLA Asset Subnumber
SAKNR SAKNR CHAR 267 10 0 G/L Account Number
HKONT HKONT CHAR 277 10 0 General Ledger Account
FKONT FIPLS NUMC 287 3 0 Financial Budget Item
FILKD FILKD CHAR 290 10 0 Account Number of the Branch
ZFBDT DZFBDT DATS 300 8 0 Baseline Date for Due Date Calculation
ZTERM DZTERM CHAR 308 4 0 Terms of Payment Key
ZBD1T DZBD1T DEC 312 3 0 Cash Discount Days 1
ZBD2T DZBD2T DEC 314 3 0 Cash Discount Days 2
ZBD3T DZBD3T DEC 316 3 0 Net Payment Terms Period
ZBD1P DZBD1P DEC 318 5 3 Cash Discount Percentage 1
ZBD2P DZBD2P DEC 321 5 3 Cash Discount Percentage 2
SKFBT SKFBT CURR 324 13 2 Amount Eligible for Cash Discount in Document Currency
SKNTO SKNTO CURR 331 13 2 Cash Discount Amount in Local Currency
WSKTO WSKTO CURR 338 13 2 Cash Discount Amount in Document Currency
ZLSCH DZLSCH CHAR 345 1 0 T042E Payment Method
ZLSPR DZLSPR CHAR 346 1 0 Payment Block Key
ZBFIX DZBFIX CHAR 347 1 0 Fixed Payment Terms
HBKID HBKID CHAR 348 5 0 T012 Short Key for a House Bank
BVTYP BVTYP CHAR 353 4 0 Partner Bank Type
REBZG REBZG CHAR 357 10 0 Number of the Invoice the Transaction Belongs to
REBZJ REBZJ NUMC 367 4 0 Fiscal Year of the Relevant Invoice (for Credit Memo)
REBZZ REBZZ NUMC 371 3 0 Line Item in the Relevant Invoice
SAMNR SAMNR NUMC 374 8 0 Invoice List Number
ANFBN ANFBN CHAR 382 10 0 Document Number of the Bill of Exchange Payment Request
ANFBJ ANFBJ NUMC 392 4 0 Fiscal Year of the Bill of Exchange Payment Request Document
ANFBU ANFBU CHAR 396 4 0 T001 Company Code in Which Bill of Exch.Payment Request Is Posted
ANFAE ANFAE DATS 400 8 0 Bill of Exchange Payment Request Due Date
MANSP MANSP CHAR 408 1 0 T040S Dunning Block
MSCHL MSCHL CHAR 409 1 0 Dunning Key
MADAT MADAT DATS 410 8 0 Date of Last Dunning Notice
MANST MAHNS_D NUMC 418 1 0 Dunning Level
MABER MABER CHAR 419 2 0 T047M Dunning Area
XNETB XNETB CHAR 421 1 0 Indicator: Document posted net ?
XANET XANET CHAR 422 1 0 Indicator: Down Payment in Net Procedure?
XCPDD XCPDD CHAR 423 1 0 Indicator: Address and Bank Data Set Individually
XINVE XINVE CHAR 424 1 0 Indicator: Capital Goods Affected?
XZAHL XZAHL CHAR 425 1 0 Indicator: Is Posting Key Used in a Payment Transaction?
MWSK1 MWSKX CHAR 426 2 0 Tax Code for Distribution
DMBT1 DMBTX CURR 428 13 2 Amount in Local Currency for Tax Distribution
WRBT1 WRBTX CURR 435 13 2 Amount in foreign currency for tax breakdown
MWSK2 MWSKX CHAR 442 2 0 Tax Code for Distribution
DMBT2 DMBTX CURR 444 13 2 Amount in Local Currency for Tax Distribution
WRBT2 WRBTX CURR 451 13 2 Amount in foreign currency for tax breakdown
MWSK3 MWSKX CHAR 458 2 0 Tax Code for Distribution
DMBT3 DMBTX CURR 460 13 2 Amount in Local Currency for Tax Distribution
WRBT3 WRBTX CURR 467 13 2 Amount in foreign currency for tax breakdown
BSTAT BSTAT_D CHAR 474 1 0 Document Status
VBUND RASSC CHAR 475 6 0 T880 Company ID of Trading Partner
VBELN VBELN_VF CHAR 481 10 0 Billing Document
REBZT REBZT CHAR 491 1 0 Follow-On Document Type
INFAE INFAE CHAR 492 8 0 Inverted Date for Net Due Date
STCEG STCEG CHAR 500 20 0 VAT Registration Number
EGBLD EGBLD CHAR 520 3 0 T005 Country of Destination for Delivery of Goods
EGLLD EGLLD CHAR 523 3 0 T005 Supplying Country for Delivery of Goods
RSTGR RSTGR CHAR 526 3 0 T053R Reason Code for Payments
XNOZA XNOZA CHAR 529 1 0 Indicator: Account is not counted
VERTT RANTYP CHAR 530 1 0 Contract Type
VERTN RANL CHAR 531 13 0 Contract Number
VBEWA SBEWART CHAR 544 4 0 TZB0A Flow Type
WVERW WVERW CHAR 548 1 0 Bill of Exchange Usage Type
PROJK PS_PSP_PNR NUMC 549 8 0 PRPS Work Breakdown Structure Element (WBS Element)
FIPOS FIPOS CHAR 557 14 0 Commitment Item
NPLNR NPLNR CHAR 571 12 0 AUFK Network Number for Account Assignment
AUFPL CO_AUFPL NUMC 583 10 0 Routing number of operations in the order
APLZL CIM_COUNT NUMC 593 8 0 Internal counter
XEGDR XEGDR CHAR 601 1 0 Indicator: Triangular deal within the EU ?
DMBE2 DMBE2 CURR 602 13 2 Amount in Second Local Currency
DMBE3 DMBE3 CURR 609 13 2 Amount in Third Local Currency
DMB21 DMB2X CURR 616 13 2 Amount in Second Local Currency for Tax Breakdown
DMB22 DMB2X CURR 623 13 2 Amount in Second Local Currency for Tax Breakdown
DMB23 DMB2X CURR 630 13 2 Amount in Second Local Currency for Tax Breakdown
DMB31 DMB3X CURR 637 13 2 Amount in Third Local Currency for Tax Breakdown
DMB32 DMB3X CURR 644 13 2 Amount in Third Local Currency for Tax Breakdown
DMB33 DMB3X CURR 651 13 2 Amount in Third Local Currency for Tax Breakdown
BDIF3 BDIF3 CURR 658 13 2 Valuation Difference for the Third Local Currency
XRAGL XRAGL CHAR 665 1 0 Indicator: Clearing was Reversed
UZAWE UZAWE CHAR 666 2 0 Payment Method Supplement
XSTOV XSTOV CHAR 668 1 0 Indicator: Document is flagged for reversal
MWST2 MWST2 CURR 669 13 2 Tax Amount in Second Local Currency
MWST3 MWST3 CURR 676 13 2 Tax Amount in Third Local Currency
SKNT2 SKNT2 CURR 683 13 2 Cash Discount Amount in Second Local Currency
SKNT3 SKNT3 CURR 690 13 2 Cash Discount Amount in Third Local Currency
XREF1 XREF1 CHAR 697 12 0 Business Partner Reference Key
XREF2 XREF2 CHAR 709 12 0 Business Partner Reference Key
XARCH XARCH CHAR 721 1 0 Indicator: Document already archived ?
PSWSL PSWSL CUKY 722 5 0 TCURC Update Currency for General Ledger Transaction Figures
PSWBT PSWBT CURR 727 13 2 Amount for Updating in General Ledger
LZBKZ LZBKZ CHAR 734 3 0 State Central Bank Indicator
LANDL LANDL CHAR 737 3 0 T005 Supplying Country
IMKEY IMKEY CHAR 740 8 0 Internal Key for Real Estate Object
VBEL2 VBELN_VA CHAR 748 10 0 Sales Document
VPOS2 NUM06 NUMC 758 6 0 Numeric field: Length 6
POSN2 POSNR_VA NUMC 764 6 0 Sales Document Item
ETEN2 ETENR NUMC 770 4 0 VBEP Delivery Schedule Line Number
FISTL FISTL CHAR 774 16 0 Funds Center
GEBER BP_GEBER CHAR 790 10 0 Fund
DABRZ DABRBEZ DATS 800 8 0 Reference Date for Settlement
XNEGP XNEGP CHAR 808 1 0 Indicator: Negative posting
KOSTL KOSTL CHAR 809 10 0 Cost Center
RFZEI RFZEI_CC NUMC 819 3 0 Payment Card Item
KKBER KKBER CHAR 822 4 0 T014 Credit Control Area
EMPFB EMPFB CHAR 826 10 0 Payee/Payer
PRCTR PRCTR CHAR 836 10 0 Profit Center
XREF3 XREF3 CHAR 846 20 0 Reference Key for Line Item
QSSKZ QSSKZ CHAR 866 2 0 T059Q Withholding Tax Code
ZINKZ DZINKZ CHAR 868 2 0 Exempted from Interest Calculation
DTWS1 DTAT16 NUMC 870 2 0 Instruction Key 1
DTWS2 DTAT17 NUMC 872 2 0 Instruction Key 2
DTWS3 DTAT18 NUMC 874 2 0 Instruction Key 3
DTWS4 DTAT19 NUMC 876 2 0 Instruction Key 4
XPYPR XPYPR CHAR 878 1 0 Indicator: Payment Order Exists for this Item
KIDNO KIDNO CHAR 879 30 0 Payment Reference
ABSBT ABSBT CURR 909 13 2 Credit Management: Hedged Amount
CCBTC CCBTC CHAR 916 10 0 Payment cards: Settlement run
PYCUR PYCUR CUKY 926 5 0 TCURC Currency for Automatic Payment
PYAMT PYAMT CURR 931 13 2 Amount in Payment Currency
BUPLA BUPLA CHAR 938 4 0 Business Place
SECCO SECCO CHAR 942 4 0 Section Code
CESSION_KZ CESSION_KZ CHAR 946 2 0 TCESSION Accounts Receivable Pledging Indicator
PPDIFF PPDIFF CURR 948 13 2 Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
PPDIF2 PPDIF2 CURR 955 13 2 Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
PPDIF3 PPDIF3 CURR 962 13 2 Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
KBLNR KBLNR_FI CHAR 969 10 0 KBLK Document Number for Earmarked Funds
KBLPOS KBLPOS NUMC 979 3 0 KBLP Earmarked Funds: Document Item
GRANT_NBR GM_GRANT_NBR CHAR 982 20 0 Grant
GMVKZ FM_GMVKZ CHAR 1002 1 0 Item is in Execution
SRTYPE FM_SRTYPE CHAR 1003 2 0 Type of Additional Receivable
LOTKZ PSO_LOTKZ CHAR 1005 10 0 Lot Number for Requests
FKBER FKBER CHAR 1015 16 0 Functional Area
INTRENO VVINTRENO CHAR 1031 13 0 Internal Real Estate Master Data Code
PPRCT PPRCTR CHAR 1044 10 0 Partner Profit Center
BUZID BUZID CHAR 1054 1 0 Identification of the Line Item
AUGGJ AUGGJ NUMC 1055 4 0 Fiscal Year of Clearing Document
HKTID HKTID CHAR 1059 5 0 T012K ID for Account Details
BUDGET_PD FM_BUDGET_PERIOD CHAR 1064 10 0 FM: Budget Period
PAYS_PROV COM_WEC_PAYMENT_SRV_PROVIDER CHAR 1074 4 0 Payment Service Provider
PAYS_TRAN FPS_TRANSACTION CHAR 1078 35 0 Payment Reference of Payment Service Provider
KONTT KONTT_FI CHAR 1113 2 0 Account Assignment Category for Industry Solution
KONTL KONTL_FI CHAR 1115 50 0 Acct Assignment String for Industry-Specific Acct Assignmnts
UEBGDAT UEBGDAT DATS 1165 8 0 Transfer date of an item to legal dunning proceeding
VNAME JV_NAME CHAR 1173 6 0 T8JV Joint Venture
EGRUP JV_EGROUP CHAR 1179 3 0 T8JF Equity Group
BTYPE JV_BILIND CHAR 1182 2 0 T8JA Payroll Type
PROPMANO REHORECNNRM CHAR 1184 13 0 Mandate, Mandate-Opening Contract

1460367New G/L Roll-out for SCC Japan
382005ALE FIDCC1/2: correction report set/reset clearing
448108ZRFWTCR01: Correction of BSEG-QSSKZ = 'XX' for ext. W/tax
195515Installing ZFINDEX
881598IPD: More than 999 entries in FEBCL
26837MaxDB: Data corruption, error -9026/-9028
1014364New G/L migration: Information, prerequisites, performance
1284291new GL migration: Performance of DB selection (scenario 6)
434645Point-in-time recovery: What must I be aware of?
1257499F110 BTE001820 for invoice-related credit memos
335295RFDKLI20: important program restrictions
417307Extractor package size: Collective note for applications
429060IS-OIL / IS-MINE : Upgrade 4.6C Support Release 2
372902Upgrade R/3 4.6C + CA-JVA 4.62 (w/o uninstalling IS-OIL)
194842Poor performance when you display line items
356865List of possible fields for clearing rules in FI
611040Down payment invoice for Italy
366892List of postings according to KOART
921658FB02: FKBER deleted in index tables
589249DEL-IS-OIL 470: Conversion when upgrading to Enterprise/ECC
852267STO: Unexpectedly long runtimes
832688Contract revision requires the BSEG-ZUONR field
648267FSCM-DM: Open item processing enhancements
200576FI-AP/AR line item extraction with delta update
641977Poor performance
743415Legacy data transfer advance payment
752761BADI implementation for user Replication /w UME4.0
401646New DataSources for Line Items from FI-GL, FI-AP, FI-AR
312149FI: Performance of drill-down balance displays to line items
420894RFWT0020: Report to recreate withholding tax data
675204STO: Timeout with determination of REFCONCEPT (open items)
619071Performance conversion prgm RFFMKONTT - parallel processing
599460RFFMKONTT runtime too long
447805Field changes to SAP R/3 Enterprise Public Services 1.10
156985Reference Note: BTE for dunning
4932384.6: Open item processing: Display additional fields?
209774F4627: Processing open items
377496IS-OIL / IS-MINE : Upgrade 4.6C Support Release 1
392016RFFMS200_OLD: Poor performance
357700Expiring currencies: Balance confirmations
453200Different company codes in exchange statement report
396892DEL-IS-OIL 4.6C: Deleted IS-OIL fields
48814OI processing: Showing additional fields?
321411Enhancement of FI-AP/AR line item reporting
422729User exit for list output for Korean tax invoices
362277Expiring currencies: correspondence
167301Termination in FDFD or report RFFDKU00/RFFDKU20
361593MQ519 in RFEWUC1O due to change in master record
300550Line items: Definition of special fields
310886Line items: Dynamic selections ignored
308164Incnstncy BSEG/index tables after commt item reorg
140512Payment program: termination with F1805
18815Performance during line item display