BSAD_BCK - Accounting: Secondary index for customers (cleared items)

Accounting: Secondary index for customers (cleared items) information is stored in SAP table BSAD_BCK.
It is part of development package FBAS in software component FI. This development package consists of objects that can be grouped under "Financial Accounting "Basis"".

Fields for table BSAD_BCK

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
BUKRS	Company Code	X	BUKRS	CHAR	8	KNB1
KUNNR	Customer Number	X	KUNNR	CHAR	20	KNA1
UMSKS	Special G/L Transaction Type	X	UMSKS	CHAR	2
UMSKZ	Special G/L Indicator	X	UMSKZ	CHAR	2
AUGDT	Clearing Date	X	AUGDT	DATS	16
AUGBL	Document Number of the Clearing Document	X	AUGBL	CHAR	20
GJAHR	Fiscal Year	X	GJAHR	NUMC	8
BELNR	Document Number of an Accounting Document	X	BELNR_D	CHAR	20
BUZEI	Number of Line Item Within Accounting Document	X	BUZEI	NUMC	6
BUDAT	Posting Date in the Document		BUDAT	DATS	16
BLDAT	Document Date in Document		BLDAT	DATS	16
CPUDT	Day On Which Accounting Document Was Entered		CPUDT	DATS	16
WAERS	Currency Key		WAERS	CUKY	10
XBLNR	Reference Document Number		XBLNR1	CHAR	32
BLART	Document Type		BLART	CHAR	4
MONAT	Fiscal period		MONAT	NUMC	4
BSCHL	Posting Key		BSCHL	CHAR	4
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
GSBER	Business Area		GSBER	CHAR	8
TAX_COUNTRY	Tax Reporting Country/Region		FOT_TAX_COUNTRY	CHAR	6
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4
TXDAT_FROM	Valid-From Date of the Tax Rate		FOT_TXDAT_FROM	DATS	16
DMBTR	Amount in local currency		DMBTR	CURR	12
WRBTR	Amount in document currency		WRBTR	CURR	12
MWSTS	Tax Amount in Local Currency		MWSTS	CURR	12
WMWST	Tax Amount in Document Currency		WMWST	CURR	12
LWSTS	Tax amount in Reporting Currency		LWSTS	CURR	12
BDIFF	Valuation Difference		BDIFF	CURR	12
BDIF2	Valuation Difference for the Second Local Currency		BDIF2	CURR	12
SGTXT	Item Text		SGTXT	CHAR	100
PROJN	Old: Project number : No longer used --> PS_POSNR		PROJN	CHAR	32
AUFNR	Order Number		AUFNR	CHAR	24
ANLN1	Main Asset Number		ANLN1	CHAR	24	IFIMASTFIXASSET
ANLN2	Asset Subnumber		ANLN2	CHAR	8	IFIXASSET
SAKNR	G/L Account Number		SAKNR	CHAR	20
HKONT	General Ledger Account		HKONT	CHAR	20
FKONT	Financial Budget Item		FIPLS	NUMC	6
FILKD	Account Number of the Branch		FILKD	CHAR	20
SKFBT	Amount Eligible for Cash Discount in Document Currency		SKFBT	CURR	12
SKNTO	Cash Discount Amount in Local Currency		SKNTO	CURR	12
WSKTO	Cash Discount Amount in Document Currency		WSKTO	CURR	12
HBKID	Short Key for a House Bank		HBKID	CHAR	10
BVTYP	Partner bank type		BVTYP	CHAR	8
REBZG	Document No. of the Invoice to Which the Transaction Belongs		REBZG	CHAR	20
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)		REBZJ	NUMC	8
REBZZ	Line Item in the Relevant Invoice		REBZZ	NUMC	6
SAMNR	Invoice List Number		SAMNR	NUMC	16
ANFBN	Document Number of the Bill of Exchange Payment Request		ANFBN	CHAR	20
ANFBJ	Fiscal Year of the Bill of Exchange Payment Request Document		ANFBJ	NUMC	8
ANFBU	Company Code in Which Bill of Exch.Payment Request Is Posted		ANFBU	CHAR	8
ANFAE	Bill of Exchange Payment Request Due Date		ANFAE	DATS	16
MANSP	Dunning Block		MANSP	CHAR	2
MSCHL	Dunning Key		MSCHL	CHAR	2
MADAT	Date of Last Dunning Notice		MADAT	DATS	16
MANST	Dunning Level		MAHNS_D	NUMC	2
MABER	Dunning Area		MABER	CHAR	4
XNETB	Indicator: Document posted net ?		XNETB	CHAR	2
XANET	Indicator: Down Payment in Net Procedure?		XANET	CHAR	2
XCPDD	Indicator: Address and Bank Data Set Individually		XCPDD	CHAR	2
XINVE	Indicator: Capital Goods Affected?		XINVE	CHAR	2
XZAHL	Indicator: Is Posting Key Used in a Payment Transaction?		XZAHL	CHAR	2
MWSK1	Tax Code for Distribution		MWSKX	CHAR	4
TXDAT_FROM1	Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack)		FOT_TXDAT_FROMX	DATS	16
TAX_COUNTRY1	Tax Country or Region for Tax Breakdown		FOT_TAX_COUNTRYX	CHAR	6
DMBT1	Amount in Local Currency for Tax Distribution		DMBTX	CURR	12
WRBT1	Amount in Foreign Currency for Tax Breakdown		WRBTX	CURR	12
HIST_TAX_FACTOR1	Historical Factor for calculating Tax Amount		FOT_HIST_FACTOR_FOR_TAX_AMOUNT	D34R	16
MWSK2	Tax Code for Distribution		MWSKX	CHAR	4
TXDAT_FROM2	Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack)		FOT_TXDAT_FROMX	DATS	16
TAX_COUNTRY2	Tax Country or Region for Tax Breakdown		FOT_TAX_COUNTRYX	CHAR	6
DMBT2	Amount in Local Currency for Tax Distribution		DMBTX	CURR	12
WRBT2	Amount in Foreign Currency for Tax Breakdown		WRBTX	CURR	12
HIST_TAX_FACTOR2	Historical Factor for calculating Tax Amount		FOT_HIST_FACTOR_FOR_TAX_AMOUNT	D34R	16
MWSK3	Tax Code for Distribution		MWSKX	CHAR	4
TXDAT_FROM3	Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack)		FOT_TXDAT_FROMX	DATS	16
TAX_COUNTRY3	Tax Country or Region for Tax Breakdown		FOT_TAX_COUNTRYX	CHAR	6
DMBT3	Amount in Local Currency for Tax Distribution		DMBTX	CURR	12
WRBT3	Amount in Foreign Currency for Tax Breakdown		WRBTX	CURR	12
HIST_TAX_FACTOR3	Historical Factor for calculating Tax Amount		FOT_HIST_FACTOR_FOR_TAX_AMOUNT	D34R	16
HIST_TAX_FACTOR	Historical Factor for calculating Tax Amount		FOT_HIST_FACTOR_FOR_TAX_AMOUNT	D34R	16
BSTAT	Document Status		BSTAT_D	CHAR	2
VBUND	Company ID of Trading Partner		RASSC	CHAR	12
VBELN	Billing Document		VBELN_VF	CHAR	20
REBZT	Follow-On Document Type		REBZT	CHAR	2
INFAE	Inverted Date for Net Due Date		INFAE	CHAR	16
STCEG	VAT Registration Number		STCEG	CHAR	40
EGBLD	Country/Region of Destination for Delivery of Goods		EGBLD	CHAR	6
EGLLD	Supplying Country/Region for Delivery of Goods		EGLLD	CHAR	6
RSTGR	Reason Code for Payments		RSTGR	CHAR	6
XNOZA	Indicator: Account Is Not Counted		XNOZA	CHAR	2
VERTT	Contract Type		RANTYP	CHAR	2
VERTN	Contract Number		RANL	CHAR	26
VBEWA	Flow Type		SBEWART	CHAR	8
WVERW	Bill of Exchange Usage Type		WVERW	CHAR	2
PROJK	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16
FIPOS	Commitment Item		FIPOS	CHAR	28
NPLNR	Network Number for Account Assignment		NPLNR	CHAR	24
AUFPL	Routing number of operations in the order		CO_AUFPL	NUMC	20
APLZL	Internal counter		CIM_COUNT	NUMC	16
XEGDR	Indicator: Triangular Deal Within the EU		XEGDR	CHAR	2
DMBE2	Amount in Second Local Currency or Global Currency		DMBE2	CURR	12
DMBE3	Amount in Third Local Currency or First Freely-Def. Currency		DMBE3	CURR	12
DMB21	Amount in Second Local Currency for Tax Breakdown		DMB2X	CURR	12
DMB22	Amount in Second Local Currency for Tax Breakdown		DMB2X	CURR	12
DMB23	Amount in Second Local Currency for Tax Breakdown		DMB2X	CURR	12
DMB31	Amount in Third Local Currency for Tax Breakdown		DMB3X	CURR	12
DMB32	Amount in Third Local Currency for Tax Breakdown		DMB3X	CURR	12
DMB33	Amount in Third Local Currency for Tax Breakdown		DMB3X	CURR	12
BDIF3	Valuation Difference for the Third Local Currency		BDIF3	CURR	12
XRAGL	Indicator: Clearing Was Reversed		XRAGL	CHAR	2
UZAWE	Payment method supplement		UZAWE	CHAR	4	T042F
XSTOV	Indicator: Document Is Flagged for Reversal		XSTOV	CHAR	2
MWST2	Tax Amount in Second Local Currency		MWST2	CURR	12
MWST3	Tax Amount in Third Local Currency		MWST3	CURR	12
SKNT2	Cash Discount Amount in Second Local Currency		SKNT2	CURR	12
SKNT3	Cash Discount Amount in Third Local Currency		SKNT3	CURR	12
XREF1	Business Partner Reference Key		XREF1	CHAR	24
XREF2	Business Partner Reference Key		XREF2	CHAR	24
XARCH	Indicator: Document Already Archived?		XARCH	CHAR	2
PSWSL	Update Currency for General Ledger Transaction Figures		PSWSL	CUKY	10	TCURC
PSWBT	Amount for Updating in General Ledger		PSWBT	CURR	12
LZBKZ	State Central Bank Indicator		LZBKZ	CHAR	6
LANDL	Supplying Country/Region		LANDL	CHAR	6
IMKEY	Internal Key for Real Estate Object		IMKEY	CHAR	16
VBEL2	Sales Document		VBELN_VA	CHAR	20
VPOS2	Numeric field: Length 6		NUM06	NUMC	12
POSN2	Sales Document Item		POSNR_VA	NUMC	12
ETEN2	Schedule Line Number		ETENR	NUMC	8
FISTL	Funds Center		FISTL	CHAR	32
GEBER	Fund		BP_GEBER	CHAR	20
DABRZ	Reference date for settlement		DABRBEZ	DATS	16
XNEGP	Indicator: Negative Posting		XNEGP	CHAR	2
KOSTL	Cost Center		KOSTL	CHAR	20
RFZEI	Payment Card Item		RFZEI_CC	NUMC	6
KKBER	Credit control area		KKBER	CHAR	8	T014
EMPFB	Payee/Payer		EMPFB	CHAR	20
PRCTR	Profit Center		PRCTR	CHAR	20
XREF3	Reference key for line item		XREF3	CHAR	40
QSSKZ	Withholding Tax Code		QSSKZ	CHAR	4
DTWS1	Instruction Key 1		DTAT16	NUMC	4
DTWS2	Instruction Key 2		DTAT17	NUMC	4
DTWS3	Instruction key 3		DTAT18	NUMC	4
DTWS4	Instruction key 4		DTAT19	NUMC	4
XPYPR	Indicator: Items from Payment Program Blocked		XPYPR	CHAR	2
KIDNO	Payment Reference		KIDNO	CHAR	60
ABSBT	Credit Management: Hedged Amount		ABSBT	CURR	12
CCBTC	Payment cards: Settlement run		CCBTC	CHAR	20
PYCUR	Currency for Automatic Payment		PYCUR	CUKY	10
PYAMT	Amount in Payment Currency		PYAMT	CURR	12
BUPLA	Business Place		BUPLA	CHAR	8
SECCO	Section Code		SECCO	CHAR	8
CESSION_KZ	Accounts Receivable Pledging Indicator		CESSION_KZ	CHAR	4	TCESSION
PPDIFF	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)		PPDIFF	CURR	12
PPDIF2	Realized Exch. Rate Gain/Loss Second Local Crcy (Part.Pymts)		PPDIF2	CURR	12
PPDIF3	Realized Exch. Rate Gain/Loss Third Local Crcy (Part. Pymts)		PPDIF3	CURR	12
KBLNR	Document Number for Earmarked Funds		KBLNR_FI	CHAR	20
KBLPOS	Earmarked Funds: Document Item		KBLPOS	NUMC	6
GRANT_NBR	Grant		GM_GRANT_NBR	CHAR	40
GMVKZ	Item is in Execution		FM_GMVKZ	CHAR	2
SRTYPE	Type of Additional Receivable		FM_SRTYPE	CHAR	4
LOTKZ	Lot Number for Requests		PSO_LOTKZ	CHAR	20
FKBER	Functional Area		FKBER	CHAR	32
INTRENO	Internal Real Estate Master Data Code		VVINTRENO	CHAR	26
PPRCT	Partner Profit Center		PPRCTR	CHAR	20
BUZID	Identification of the Line Item		BUZID	CHAR	2
AUGGJ	Fiscal Year of Clearing Document		AUGGJ	NUMC	8
HKTID	ID for Account Details		HKTID	CHAR	10
BUDGET_PD	Budget Period		FM_BUDGET_PERIOD	CHAR	20
PAYS_PROV	Payment Service Provider		COM_WEC_PAYMENT_SRV_PROVIDER	CHAR	8
PAYS_TRAN	Payment Reference of Payment Service Provider		FPS_TRANSACTION	CHAR	70
MNDID	Unique Reference to Mandate for each Payee		SEPA_MNDID	CHAR	70
.INCLUDE				FIN_S_GKONT	0
GKONT	Offsetting Account Number		GKONT	CHAR	20
GKART	Offsetting Account Type		GKOAR	CHAR	2
GHKON	G/L Acct of Offsetting Acct in General Ledger Accounting		GHKONT	CHAR	20
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16
.INCLU--AP				ABSAD_PSO	0
KONTT	Account Assignment Category for Industry Solution		KONTT_FI	CHAR	4
KONTL	Acct assignment string for industry-specific acct assignmnts		KONTL_FI	CHAR	100
UEBGDAT	Transfer date of an item to legal dunning proceeding		UEBGDAT	DATS	16
.INCLU--AP				JVBSAD	0
VNAME	Joint venture		JV_NAME	CHAR	12	T8JV
EGRUP	Equity group		JV_EGROUP	CHAR	6	T8JF
BTYPE	Billing Indicator		JV_BILIND	CHAR	4	T8JA
.INCLU--AP				REPR_BSAD	0
.INCLUDE				REPR_APPEND	0
PROPMANO	Mandate, Mandate-Opening Contract		REHORECNNRM	CHAR	26