BSIS_BAK

Accounting: Secondary Index for G/L Accounts | #transactional | Component: Financial Accounting
Column Name Description
MANDT Client
BUKRS Company Code
HKONT General Ledger Account
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
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
MWST2 Tax 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
MWST3 Tax Amount in Third Local Currency
BDIF3 Valuation Difference for the Third Local Currency
RDIF3 Exchange Rate Difference Realized for 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
Column Name Description
Column Name Description
AUGDT Clearing Date
BUDAT Posting Date in the Document
BLDAT Document Date in Document
ZFBDT Baseline Date for Due Date Calculation
VALUT Value date
DABRZ Reference date for settlement
Column Name Description
SHKZG Debit/Credit Indicator Show values
XOPVW Indicator: Open Item Management? Show values
BSTAT Document Status Show values
WVERW Bill of Exchange Usage Type 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
Column Name Description Domain name
XBLNR Reference Document Number XBLNR1
MONAT Fiscal period MONAT
FKONT Financial Budget Item FIPLS
SGTXT Item Text TEXT50
PROJN Old: Project number : No longer used --> PS_POSNR PROJN
KOSTL Cost Center KOSTL
PRCTR Profit Center PRCTR
RFZEI Payment Card Item NUM03
CCBTC Payment cards: Settlement run CCBTC
XREF3 Reference key for line item CHAR20
IMKEY Internal Key for Real Estate Object IMKEY
INTRENO Internal Real Estate Master Data Code VVINTRENO
GRANT_NBR Grant GM_GRANT_NBR
FKBER Functional Area FKBER
FIPOS Commitment Item FIPOS
FISTL Funds Center FISTL
GEBER Fund BP_GEBER
PPRCT Partner Profit Center PRCTR
BUZID Identification of the Line Item CHAR1
AUGGJ Fiscal Year of Clearing Document GJAHR
UZAWE Payment method supplement UZAWE
SEGMENT Segment for Segmental Reporting FB_SEGMENT
PSEGMENT Partner Segment for Segmental Reporting FB_SEGMENT
PGEBER Partner Fund BP_GEBER
PGRANT_NBR Partner Grant GM_GRANT_NBR
MEASURE Funded Program FM_MEASURE
BUDGET_PD Budget Period FM_BUDGET_PERIOD
PBUDGET_PD FM: Partner Budget Period FM_BUDGET_PERIOD
FIPEX Commitment item - Do not use field - see note 447805 FM_FIPEX
PRODPER Production Month BUPER
QSSKZ Withholding Tax Code QSSKZ
PROPMANO Mandate, Mandate-Opening Contract RECNNR
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • BSIS_BAK.AUFNR == AUFK.AUFNR
  • BSIS_BAK.MANDT == AUFK.MANDT
Transaction type
  • BSIS_BAK.MANDT == T856.MANDT
  • BSIS_BAK.BEWAR == T856.TRTYP
Document Type
  • Document Type
  • Client
  • BSIS_BAK.BLART == T003.BLART
  • BSIS_BAK.MANDT == T003.MANDT
Posting Key
  • BSIS_BAK.MANDT == TBSL.MANDT
  • BSIS_BAK.BSCHL == TBSL.BSCHL
Business Place
  • ?
  • Business Place
  • Client
  • ?
  • BSIS_BAK.[column in domain "BUKRS"] == J_1BBRANCH.BUKRS
  • BSIS_BAK.BUPLA == J_1BBRANCH.BRANCH
  • BSIS_BAK.MANDT == J_1BBRANCH.MANDT
  • BSIS_BAK.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
Business Area
  • BSIS_BAK.MANDT == TGSB.MANDT
  • BSIS_BAK.GSBER == TGSB.GSBER
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • BSIS_BAK.MANDT == T007A.MANDT
  • BSIS_BAK.[column in domain "KALSM_D"] == T007A.KALSM
  • BSIS_BAK.MWSKZ == T007A.MWSKZ
Update Currency for General Ledger Transaction Figures
  • BSIS_BAK.MANDT == TCURC.MANDT
  • BSIS_BAK.PSWSL == TCURC.WAERS
Company ID of Trading Partner
  • BSIS_BAK.MANDT == T880.MANDT
  • BSIS_BAK.VBUND == T880.RCOMP
Currency Key
  • BSIS_BAK.MANDT == TCURC.MANDT
  • BSIS_BAK.WAERS == TCURC.WAERS
Plant
  • BSIS_BAK.MANDT == T001W.MANDT
  • BSIS_BAK.WERKS == T001W.WERKS