BSID_BAK

Accounting: Secondary Index for Customers | #transactional | Component: Financial Accounting
Column Name Description
MANDT Client
BUKRS FK Company Code
KUNNR FK Customer Number
UMSKS Special G/L Transaction Type
UMSKZ FK Special G/L Indicator
AUGDT Clearing Date
AUGBL Document Number of the Clearing Document
ZUONR Assignment number
GJAHR Fiscal Year
BELNR Document Number of an Accounting Document
BUZEI Number of Line Item Within Accounting Document
Column Name Description
💲 Currency Key (T001.WAERS):
DMBTR Amount in local currency
WRBTR Amount in document currency
MWSTS Tax Amount in Local Currency
WMWST Tax Amount in Document Currency
BDIFF Valuation Difference
SKFBT Amount Eligible for Cash Discount in Document Currency
SKNTO Cash Discount Amount in Local Currency
WSKTO Cash Discount Amount in Document Currency
DMBT1 Amount in Local Currency for Tax Distribution
WRBT1 Amount in Foreign Currency for Tax Breakdown
DMBT2 Amount in Local Currency for Tax Distribution
WRBT2 Amount in Foreign Currency for Tax Breakdown
DMBT3 Amount in Local Currency for Tax Distribution
WRBT3 Amount in Foreign Currency for Tax Breakdown
ABSBT Credit Management: Hedged Amount
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
💲 Currency Key of Second Local Currency (BKPF.HWAE2):
BDIF2 Valuation Difference for the Second Local Currency
DMBE2 Amount in Second Local Currency or Global Currency
DMB21 Amount in Second Local Currency for Tax Breakdown
DMB22 Amount in Second Local Currency for Tax Breakdown
DMB23 Amount in Second Local Currency for Tax Breakdown
MWST2 Tax Amount in Second Local Currency
SKNT2 Cash Discount Amount in Second Local Currency
PPDIF2 Realized Exch. Rate Gain/Loss Second Local Crcy (Part.Pymts)
💲 Currency Key of Third Local Currency (BKPF.HWAE3):
DMBE3 Amount in Third Local Currency or First Freely-Def. Currency
DMB31 Amount in Third Local Currency for Tax Breakdown
DMB32 Amount in Third Local Currency for Tax Breakdown
DMB33 Amount in Third Local Currency for Tax Breakdown
BDIF3 Valuation Difference for the Third Local Currency
MWST3 Tax Amount in Third Local Currency
SKNT3 Cash Discount Amount in Third Local Currency
PPDIF3 Realized Exch. Rate Gain/Loss Third Local Crcy (Part. Pymts)
💲 Update Currency for General Ledger Transaction Figures (PSWSL):
PSWBT Amount for Updating in General Ledger
💲 Currency for Automatic Payment (PYCUR):
PYAMT Amount in Payment Currency
Column Name Description
Column Name Description
AUGDT Clearing Date
BUDAT Posting Date in the Document
BLDAT Document Date in Document
CPUDT Day On Which Accounting Document Was Entered
ZFBDT Baseline Date for Due Date Calculation
ANFAE Bill of Exchange Payment Request Due Date
MADAT Date of Last Dunning Notice
DABRZ Reference date for settlement
UEBGDAT Transfer date of an item to legal dunning proceeding
Column Name Description
SHKZG Debit/Credit Indicator Show values
ZBFIX Fixed Payment Terms Show values
XNETB Indicator: Document posted net ? Show values
XANET Indicator: Down Payment in Net Procedure? Show values
XCPDD Indicator: Address and Bank Data Set Individually Show values
XINVE Indicator: Capital Goods Affected? Show values
XZAHL Indicator: Is Posting Key Used in a Payment Transaction? Show values
BSTAT Document Status Show values
XNOZA Indicator: Account Is Not Counted Show values
VERTT Contract Type Show values
WVERW Bill of Exchange Usage Type Show values
XEGDR Indicator: Triangular Deal Within the EU Show values
XRAGL Indicator: Clearing Was Reversed Show values
XSTOV Indicator: Document Is Flagged for Reversal Show values
XARCH Indicator: Document Already Archived? Show values
XNEGP Indicator: Negative Posting Show values
ZINKZ Exempted from Interest Calculation Show values
XPYPR Indicator: Items from Payment Program Blocked Show values
GMVKZ Item is in Execution Show values
SRTYPE Type of Additional Receivable Show values
Column Name Description Domain name
XBLNR Reference Document Number XBLNR1
MONAT Fiscal period MONAT
ZUMSK Target Special G/L Indicator UMSKZ
SGTXT Item Text TEXT50
PROJN Old: Project number : No longer used --> PS_POSNR PROJN
ANLN1 Main Asset Number ANLN1
ANLN2 Asset Subnumber ANLN2
SAKNR G/L Account Number SAKNR
HKONT General Ledger Account SAKNR
FKONT Financial Budget Item FIPLS
FILKD Account Number of the Branch MAXKK
ZTERM Terms of payment key ZTERM
ZBD1T Cash discount days 1 ZBDXT
ZBD2T Cash discount days 2 ZBDXT
ZBD3T Net Payment Terms Period ZBDXT
ZBD1P Cash discount percentage 1 PRZ23
ZBD2P Cash Discount Percentage 2 PRZ23
BVTYP Partner bank type BVTYP
REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
REBZZ Line Item in the Relevant Invoice BUZEI
SAMNR Invoice List Number SAMNR
ANFBN Document Number of the Bill of Exchange Payment Request BELNR
ANFBJ Fiscal Year of the Bill of Exchange Payment Request Document GJAHR
MANST Dunning Level MAHNS
MABER Dunning Area MABER
MWSK1 Tax Code for Distribution MWSKZ
MWSK2 Tax Code for Distribution MWSKZ
MWSK3 Tax Code for Distribution MWSKZ
VBELN Billing Document VBELN
REBZT Follow-On Document Type REBZT
INFAE Inverted Date for Net Due Date CHAR08
STCEG VAT Registration Number STCEG
VERTN Contract Number RANL
VBEWA Flow Type SBEWART
PROJK Work Breakdown Structure Element (WBS Element) PS_POSNR
FIPOS Commitment Item FIPOS
NPLNR Network Number for Account Assignment AUFNR
AUFPL Routing number of operations in the order AUFPL
APLZL Internal counter CIM_COUNT
XREF1 Business Partner Reference Key CHAR12
XREF2 Business Partner Reference Key CHAR12
IMKEY Internal Key for Real Estate Object IMKEY
VBEL2 Sales Document VBELN
VPOS2 Numeric field: Length 6 NUM06
POSN2 Sales Document Item POSNR
ETEN2 Schedule Line Number ETENR
FISTL Funds Center FISTL
GEBER Fund BP_GEBER
KOSTL Cost Center KOSTL
RFZEI Payment Card Item NUM03
EMPFB Payee/Payer MAXKK
PRCTR Profit Center PRCTR
XREF3 Reference key for line item CHAR20
DTWS1 Instruction Key 1 DTWSX
DTWS2 Instruction Key 2 DTWSX
DTWS3 Instruction key 3 DTWSX
DTWS4 Instruction key 4 DTWSX
KIDNO Payment Reference CHAR30
CCBTC Payment cards: Settlement run CCBTC
KBLNR Document Number for Earmarked Funds KBLNR
KBLPOS Earmarked Funds: Document Item KBLPOS
GRANT_NBR Grant GM_GRANT_NBR
LOTKZ Lot Number for Requests LOTKZ
FKBER Functional Area FKBER
INTRENO Internal Real Estate Master Data Code VVINTRENO
PPRCT Partner Profit Center PRCTR
BUZID Identification of the Line Item CHAR1
AUGGJ Fiscal Year of Clearing Document GJAHR
HKTID ID for Account Details HKTID
BUDGET_PD Budget Period FM_BUDGET_PERIOD
PAYS_PROV Payment Service Provider COM_WEC_PAYMENT_SRV_PROVIDER
PAYS_TRAN Payment Reference of Payment Service Provider COM_WEC_PSP_TRANSACTION_ID
MNDID Unique Reference to Mandate for each Payee ID035
KONTT Account Assignment Category for Industry Solution KONTT_FI
KONTL Acct assignment string for industry-specific acct assignmnts CHAR50
VNAME Joint venture JV_NAME
EGRUP Equity group JV_EGROUP
BTYPE Billing Indicator JV_BILIND
PROPMANO Mandate, Mandate-Opening Contract RECNNR
Master Data Relations Join Conditions
Company Code in Which Bill of Exch.Payment Request Is Posted
  • BSID_BAK.MANDT == T001.MANDT
  • BSID_BAK.ANFBU == T001.BUKRS
Order Number
  • Order Number
  • Client
  • BSID_BAK.AUFNR == AUFK.AUFNR
  • BSID_BAK.MANDT == AUFK.MANDT
Document Type
  • Document Type
  • Client
  • BSID_BAK.BLART == T003.BLART
  • BSID_BAK.MANDT == T003.MANDT
Posting Key
  • BSID_BAK.MANDT == TBSL.MANDT
  • BSID_BAK.BSCHL == TBSL.BSCHL
Company Code
  • Company Code
  • Customer Number
  • Client
  • BSID_BAK.BUKRS == KNB1.BUKRS
  • BSID_BAK.KUNNR == KNB1.KUNNR
  • BSID_BAK.MANDT == KNB1.MANDT
Business Place
  • ?
  • Business Place
  • Client
  • ?
  • BSID_BAK.[column in domain "BUKRS"] == J_1BBRANCH.BUKRS
  • BSID_BAK.BUPLA == J_1BBRANCH.BRANCH
  • BSID_BAK.MANDT == J_1BBRANCH.MANDT
  • BSID_BAK.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
Accounts Receivable Pledging Indicator
  • Accounts Receivable Pledging Indicator
  • Client
  • Company Code
Country/Region of Destination for Delivery of Goods
  • Country/Region of Destination for Delivery of Goods
  • Client
  • BSID_BAK.EGBLD == T005.LAND1
  • BSID_BAK.MANDT == T005.MANDT
Supplying Country/Region for Delivery of Goods
  • Supplying Country/Region for Delivery of Goods
  • Client
  • BSID_BAK.EGLLD == T005.LAND1
  • BSID_BAK.MANDT == T005.MANDT
Business Area
  • BSID_BAK.MANDT == TGSB.MANDT
  • BSID_BAK.GSBER == TGSB.GSBER
Short Key for a House Bank
  • Short Key for a House Bank
  • ?
  • BSID_BAK.MANDT == T012.MANDT
  • BSID_BAK.HBKID == T012.HBKID
  • BSID_BAK.[column in domain "BUKRS"] == T012.BUKRS
Credit control area
  • BSID_BAK.MANDT == T014.MANDT
  • BSID_BAK.KKBER == T014.KKBER
Customer Number
  • BSID_BAK.MANDT == KNA1.MANDT
  • BSID_BAK.KUNNR == KNA1.KUNNR
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • BSID_BAK.LANDL == T005.LAND1
  • BSID_BAK.MANDT == T005.MANDT
State Central Bank Indicator
  • BSID_BAK.MANDT == T015L.MANDT
  • BSID_BAK.LZBKZ == T015L.LZBKZ
Dunning Block
  • BSID_BAK.MANDT == T040S.MANDT
  • BSID_BAK.MANSP == T040S.MANSP
Dunning Key
  • BSID_BAK.MANDT == T040.MANDT
  • BSID_BAK.MSCHL == T040.MSCHL
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • BSID_BAK.MANDT == T007A.MANDT
  • BSID_BAK.[column in domain "KALSM_D"] == T007A.KALSM
  • BSID_BAK.MWSKZ == T007A.MWSKZ
Update Currency for General Ledger Transaction Figures
  • BSID_BAK.MANDT == TCURC.MANDT
  • BSID_BAK.PSWSL == TCURC.WAERS
Currency for Automatic Payment
  • BSID_BAK.MANDT == TCURC.MANDT
  • BSID_BAK.PYCUR == TCURC.WAERS
Withholding Tax Code
  • ?
  • Client
  • Withholding Tax Code
  • BSID_BAK.[column in domain "LAND1"] == T059Q.LAND1
  • BSID_BAK.MANDT == T059Q.MANDT
  • BSID_BAK.QSSKZ == T059Q.QSSKZ
Reason Code for Payments
  • ?
  • Reason Code for Payments
  • Client
  • BSID_BAK.[column in domain "BUKRS"] == T053R.BUKRS
  • BSID_BAK.RSTGR == T053R.RSTGR
  • BSID_BAK.MANDT == T053R.MANDT
Section Code
  • ?
  • Section Code
  • Client
  • BSID_BAK.[column in domain "BUKRS"] == SECCODE.BUKRS
  • BSID_BAK.SECCO == SECCODE.SECCODE
  • BSID_BAK.MANDT == SECCODE.MANDT
Special G/L Indicator
  • Special G/L Indicator
  • ?
  • BSID_BAK.MANDT == T074U.MANDT
  • BSID_BAK.UMSKZ == T074U.UMSKZ
  • BSID_BAK.[column in domain "KOART"] == T074U.KOART
Payment method supplement
  • BSID_BAK.MANDT == T042F.MANDT
  • BSID_BAK.UZAWE == T042F.UZAWE
Company ID of Trading Partner
  • BSID_BAK.MANDT == T880.MANDT
  • BSID_BAK.VBUND == T880.RCOMP
Currency Key
  • BSID_BAK.MANDT == TCURC.MANDT
  • BSID_BAK.WAERS == TCURC.WAERS
Payment Method
  • Payment Method
  • ?
  • BSID_BAK.MANDT == T042Z.MANDT
  • BSID_BAK.ZLSCH == T042Z.ZLSCH
  • BSID_BAK.[column in domain "LAND1"] == T042Z.LAND1
Payment Block Key
  • Payment Block Key
  • Client
  • BSID_BAK.ZLSPR == T008.ZAHLS
  • BSID_BAK.MANDT == T008.MANDT