SAP FVD_IF_IA_BSID Accounting: Secondary Index for Customers Table data and field list

FVD_IF_IA_BSID is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Accounting: Secondary Index for Customers" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FVD_IF_IA_BSID TYPE FVD_IF_IA_BSID.

The FVD_IF_IA_BSID table consists of various fields, each holding specific information or linking keys about Accounting: Secondary Index for Customers data available in SAP. These include BUKRS (Company Code), KUNNR (Customer Numbers), UMSKS (Special G/L Transaction Type), UMSKZ (Special G/L Indicator)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

FVD_IF_IA_BSID structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP FVD_IF_IA_BSID structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FVD_IF_IA_BSID table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
KUNNR	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
UMSKS	Special G/L Transaction Type	UMSKS	CHAR	1			UMSKS
UMSKZ	Special G/L Indicator	UMSKZ	CHAR	1	Assigned to domain		UMSKZ
AUGDT	Clearing Date	AUGDT	DATS	8			DATUM
AUGBL	Document Number of the Clearing Document	AUGBL	CHAR	10		ALPHA	BELNR
ZUONR	Assignment Number	DZUONR	CHAR	18			ZUONR
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
BLDAT	Document Date in Document	BLDAT	DATS	8			DATUM
CPUDT	Day On Which Accounting Document Was Entered	CPUDT	DATS	8			DATUM
WAERS	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
XBLNR	Reference Document Number	XBLNR1	CHAR	16			XBLNR1
BLART	Document Type	BLART	CHAR	2	Assigned to domain		BLART	BAR
MONAT	Fiscal Period	MONAT	NUMC	2			MONAT
BSCHL	Posting Key	BSCHL	CHAR	2	Assigned to domain		BSCHL
ZUMSK	Target Special G/L Indicator	DZUMSK	CHAR	1	Assigned to domain		UMSKZ
SHKZG	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
GSBER	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
MWSKZ	Tax on sales/purchases code	MWSKZ	CHAR	2	Assigned to domain		MWSKZ
DMBTR	Amount in Local Currency	DMBTR	CURR	13(2)			WERT7
WRBTR	Amount in document currency	WRBTR	CURR	13(2)			WERT7
MWSTS	Tax Amount in Local Currency	MWSTS	CURR	13(2)			WERT7
WMWST	Tax amount in document currency	WMWST	CURR	13(2)			WERT7
BDIFF	Valuation Difference	BDIFF	CURR	13(2)			WRTV7
BDIF2	Valuation Difference for the Second Local Currency	BDIF2	CURR	13(2)			WRTV7
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
PROJN	Old: Project number : No longer used --> PS_POSNR	PROJN	CHAR	16			PROJN
AUFNR	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
ANLN1	Main Asset Number	ANLN1	CHAR	12	Assigned to domain	ALPHA	ANLN1	AN1
ANLN2	Asset Subnumber	ANLN2	CHAR	4	Assigned to domain	ALPHA	ANLN2	AN2
SAKNR	G/L Account Number	SAKNR	CHAR	10	Assigned to domain	ALPHA	SAKNR	SAK	C_SAKNR
HKONT	General Ledger Account	HKONT	CHAR	10	Assigned to domain	ALPHA	SAKNR
FKONT	Financial Budget Item	FIPLS	NUMC	3			FIPLS
FILKD	Account Number of the Branch	FILKD	CHAR	10		ALPHA	MAXKK
ZFBDT	Baseline Date for Due Date Calculation	DZFBDT	DATS	8			DATUM
ZTERM	Terms of Payment Key	DZTERM	CHAR	4			ZTERM
ZBD1T	Cash discount days 1	DZBD1T	DEC	3			ZBDXT
ZBD2T	Cash discount days 2	DZBD2T	DEC	3			ZBDXT
ZBD3T	Net Payment Terms Period	DZBD3T	DEC	3			ZBDXT
ZBD1P	Cash Discount Percentage 1	DZBD1P	DEC	5(3)			PRZ23
ZBD2P	Cash Discount Percentage 2	DZBD2P	DEC	5(3)			PRZ23
SKFBT	Amount Eligible for Cash Discount in Document Currency	SKFBT	CURR	13(2)			WERT7
SKNTO	Cash discount amount in local currency	SKNTO	CURR	13(2)			WERT7
WSKTO	Cash discount amount in document currency	WSKTO	CURR	13(2)			WERT7
ZLSCH	Payment Method	DZLSCH	CHAR	1	Assigned to domain		ZLSCH
ZLSPR	Payment Block Key	DZLSPR	CHAR	1	Assigned to domain		ZAHLS	SPE
ZBFIX	Fixed Payment Terms	DZBFIX	CHAR	1			ZBFIX
HBKID	Short Key for a House Bank	HBKID	CHAR	5	Assigned to domain		HBKID
BVTYP	Partner Bank Type	BVTYP	CHAR	4			BVTYP
REBZG	Number of the Invoice the Transaction Belongs to	REBZG	CHAR	10		ALPHA	BELNR
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	REBZJ	NUMC	4		GJAHR	GJAHR
REBZZ	Line Item in the Relevant Invoice	REBZZ	NUMC	3			BUZEI
SAMNR	Invoice List Number	SAMNR	NUMC	8			SAMNR
ANFBN	Document Number of the Bill of Exchange Payment Request	ANFBN	CHAR	10		ALPHA	BELNR
ANFBJ	Fiscal Year of the Bill of Exchange Payment Request Document	ANFBJ	NUMC	4		GJAHR	GJAHR
ANFBU	Company Code in Which Bill of Exch.Payment Request Is Posted	ANFBU	CHAR	4	Assigned to domain		BUKRS
ANFAE	Bill of Exchange Payment Request Due Date	ANFAE	DATS	8			DATUM
MANSP	Dunning block	MANSP	CHAR	1	Assigned to domain		MANSP
MSCHL	Dunning key	MSCHL	CHAR	1	Assigned to domain		MSCHL
MADAT	Last dunned on	MADAT	DATS	8			DATUM
MANST	Dunning level	MAHNS_D	NUMC	1			MAHNS
MABER	Dunning Area	MABER	CHAR	2	Assigned to domain		MABER
XNETB	Indicator: Document posted net ?	XNETB	CHAR	1			XFELD
XANET	Indicator: Down payment in net procedure ?	XANET	CHAR	1			XFELD
XCPDD	Indicator: Address and bank data set individually	XCPDD	CHAR	1			XFELD
XINVE	Indicator: Capital Goods Affected?	XINVE	CHAR	1			XFELD
XZAHL	Indicator: Is the posting key used in a payment transaction?	XZAHL	CHAR	1			XFELD
MWSK1	Tax Code for Distribution	MWSKX	CHAR	2	Assigned to domain		MWSKZ
DMBT1	Amount in Local Currency for Tax Distribution	DMBTX	CURR	13(2)			WRTV7
WRBT1	Amount in foreign currency for tax breakdown	WRBTX	CURR	13(2)			WRTV7
MWSK2	Tax Code for Distribution	MWSKX	CHAR	2	Assigned to domain		MWSKZ
DMBT2	Amount in Local Currency for Tax Distribution	DMBTX	CURR	13(2)			WRTV7
WRBT2	Amount in foreign currency for tax breakdown	WRBTX	CURR	13(2)			WRTV7
MWSK3	Tax Code for Distribution	MWSKX	CHAR	2	Assigned to domain		MWSKZ
DMBT3	Amount in Local Currency for Tax Distribution	DMBTX	CURR	13(2)			WRTV7
WRBT3	Amount in foreign currency for tax breakdown	WRBTX	CURR	13(2)			WRTV7
BSTAT	Document Status	BSTAT_D	CHAR	1			BSTAT
VBUND	Company ID of trading partner	RASSC	CHAR	6	Assigned to domain	ALPHA	RCOMP	PGS
VBELN	Billing Document	VBELN_VF	CHAR	10	Assigned to domain	ALPHA	VBELN	VF
REBZT	Follow-On Document Type	REBZT	CHAR	1			REBZT
INFAE	Inverted Date for Net Due Date	INFAE	CHAR	8			CHAR08
STCEG	VAT Registration Number	STCEG	CHAR	20			STCEG
EGBLD	Country of Destination for Delivery of Goods	EGBLD	CHAR	3	Assigned to domain		LAND1
EGLLD	Supplying Country for Delivery of Goods	EGLLD	CHAR	3	Assigned to domain		LAND1
RSTGR	Reason Code for Payments	RSTGR	CHAR	3	Assigned to domain		RSTGR
XNOZA	Indicator: Account is not counted	XNOZA	CHAR	1			XFELD
VERTT	Contract Type	RANTYP	CHAR	1			RANTYP
VERTN	Contract Number	RANL	CHAR	13		ALPHA	RANL	RAN
VBEWA	Flow Type	SBEWART	CHAR	4	Assigned to domain		SBEWART
WVERW	Bill of exchange usage type	WVERW	CHAR	1			WVERW
PROJK	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	NUMC	8	Assigned to domain	KONPR	PS_POSNR
FIPOS	Commitment Item	FIPOS	CHAR	14	Assigned to domain		FIPOS	FIP
NPLNR	Network Number for Account Assignment	NPLNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	NET
AUFPL	Routing number of operations in the order	CO_AUFPL	NUMC	10			AUFPL
APLZL	Internal counter	CIM_COUNT	NUMC	8			CIM_COUNT
XEGDR	Indicator: Triangular deal within the EU ?	XEGDR	CHAR	1			XFELD
DMBE2	Amount in Second Local Currency	DMBE2	CURR	13(2)			WERT7
DMBE3	Amount in Third Local Currency	DMBE3	CURR	13(2)			WERT7
DMB21	Amount in Second Local Currency for Tax Breakdown	DMB2X	CURR	13(2)			WRTV7
DMB22	Amount in Second Local Currency for Tax Breakdown	DMB2X	CURR	13(2)			WRTV7
DMB23	Amount in Second Local Currency for Tax Breakdown	DMB2X	CURR	13(2)			WRTV7
DMB31	Amount in Third Local Currency for Tax Breakdown	DMB3X	CURR	13(2)			WRTV7
DMB32	Amount in Third Local Currency for Tax Breakdown	DMB3X	CURR	13(2)			WRTV7
DMB33	Amount in Third Local Currency for Tax Breakdown	DMB3X	CURR	13(2)			WRTV7
BDIF3	Valuation Difference for the Third Local Currency	BDIF3	CURR	13(2)			WRTV7
XRAGL	Indicator: Clearing was Reversed	XRAGL	CHAR	1			XFELD
UZAWE	Payment Method Supplement	UZAWE	CHAR	2	Assigned to domain		UZAWE
XSTOV	Indicator: Document is flagged for reversal	XSTOV	CHAR	1			XFELD
MWST2	Tax Amount in Second Local Currency	MWST2	CURR	13(2)			WERT7
MWST3	Tax Amount in Third Local Currency	MWST3	CURR	13(2)			WERT7
SKNT2	Cash Discount Amount in Second Local Currency	SKNT2	CURR	13(2)			WERT7
SKNT3	Cash Discount Amount in Third Local Currency	SKNT3	CURR	13(2)			WERT7
XREF1	Business partner reference key	XREF1	CHAR	12			CHAR12
XREF2	Business partner reference key	XREF2	CHAR	12			CHAR12
XARCH	Indicator: Document already archived ?	XARCH	CHAR	1			XFELD
PSWSL	Update Currency for General Ledger Transaction Figures	PSWSL	CUKY	5	Assigned to domain		WAERS
PSWBT	Amount for Updating in General Ledger	PSWBT	CURR	13(2)			WERT7
LZBKZ	State Central Bank Indicator	LZBKZ	CHAR	3	Assigned to domain		LZBKZ
LANDL	Supplying Country	LANDL	CHAR	3	Assigned to domain		LAND1
IMKEY	Internal Key for Real Estate Object	IMKEY	CHAR	8			IMKEY
VBEL2	Sales Document	VBELN_VA	CHAR	10	Assigned to domain	ALPHA	VBELN	AUN
VPOS2	Numeric field: Length 6	NUM06	NUMC	6			NUM06
POSN2	Sales Document Item	POSNR_VA	NUMC	6	Assigned to domain		POSNR	APO
ETEN2	Delivery Schedule Line Number	ETENR	NUMC	4	Assigned to domain		ETENR
FISTL	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
GEBER	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
DABRZ	Reference Date for Settlement	DABRBEZ	DATS	8			DDAT
XNEGP	Indicator: Negative posting	XNEGP	CHAR	1			XFELD
KOSTL	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
RFZEI	Payment Card Item	RFZEI_CC	NUMC	3			NUM03
KKBER	Credit control area	KKBER	CHAR	4	Assigned to domain		KKBER	KKB
EMPFB	Payee/Payer	EMPFB	CHAR	10		ALPHA	MAXKK
PRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
XREF3	Reference key for line item	XREF3	CHAR	20			CHAR20
QSSKZ	Withholding Tax Code	QSSKZ	CHAR	2	Assigned to domain		QSSKZ
ZINKZ	Exempted from interest calculation	DZINKZ	CHAR	2			ZINKZ
DTWS1	Instruction key 1	DTAT16	NUMC	2	Assigned to domain		DTWSX
DTWS2	Instruction key 2	DTAT17	NUMC	2	Assigned to domain		DTWSX
DTWS3	Instruction key 3	DTAT18	NUMC	2	Assigned to domain		DTWSX
DTWS4	Instruction key 4	DTAT19	NUMC	2	Assigned to domain		DTWSX
XPYPR	Indicator: Items from Payment Program Blocked	XPYPR	CHAR	1			XFELD
KIDNO	Payment Reference	KIDNO	CHAR	30			CHAR30
ABSBT	Credit management: Hedged amount	ABSBT	CURR	13(2)			WERT7
CCBTC	Payment cards: Settlement run	CCBTC	CHAR	10		ALPHA	CCBTC
PYCUR	Currency for Automatic Payment	PYCUR	CUKY	5	Assigned to domain		WAERS
PYAMT	Amount in Payment Currency	PYAMT	CURR	13(2)			WERT7
BUPLA	Business Place	BUPLA	CHAR	4	Assigned to domain		J_1BBRANCH
SECCO	Section Code	SECCO	CHAR	4	Assigned to domain		SECCO		SECCO_ABA
CESSION_KZ	Accounts Receivable Pledging Indicator	CESSION_KZ	CHAR	2	Assigned to domain		CESSION_KZ
PPDIFF	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)	PPDIFF	CURR	13(2)			WRTV7
PPDIF2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)	PPDIF2	CURR	13(2)			WRTV7
PPDIF3	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)	PPDIF3	CURR	13(2)			WRTV7
KBLNR	Document Number for Earmarked Funds	KBLNR_FI	CHAR	10	Assigned to domain	ALPHA	KBLNR	KBL
KBLPOS	Earmarked Funds: Document Item	KBLPOS	NUMC	3	Assigned to domain		KBLPOS	KBP
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
GMVKZ	Item is in Execution	FM_GMVKZ	CHAR	1			FM_GMVKZ
SRTYPE	Type of Additional Receivable	FM_SRTYPE	CHAR	2			FM_SRTYPE
LOTKZ	Lot Number for Requests	PSO_LOTKZ	CHAR	10		ALPHA	LOTKZ	LOT
FKBER	Functional Area	FKBER	CHAR	16	Assigned to domain		FKBER	FBE
INTRENO	Internal Real Estate Master Data Code	VVINTRENO	CHAR	13			VVINTRENO
PPRCT	Partner Profit Center	PPRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PPC
BUZID	Identification of the Line Item	BUZID	CHAR	1			CHAR1
AUGGJ	Fiscal Year of Clearing Document	AUGGJ	NUMC	4		GJAHR	GJAHR
HKTID	ID for account details	HKTID	CHAR	5	Assigned to domain		HKTID
KONTT	Account Assignment Category for Industry Solution	KONTT_FI	CHAR	2			KONTT_FI
KONTL	Acct assignment string for industry-specific acct assignmnts	KONTL_FI	CHAR	50			CHAR50
UEBGDAT	Date	DATUM	DATS	8			DATUM
VNAME	Joint Venture	JV_NAME	CHAR	6	Assigned to domain	ALPHA	JV_NAME	JVV
EGRUP	Equity group	JV_EGROUP	CHAR	3	Assigned to domain	ALPHA	JV_EGROUP	GJE
BTYPE	Payroll Type	JV_BILIND	CHAR	2	Assigned to domain	ALPHA	JV_BILIND

Key field

Non-key field

< FVD_IF_IA_ADDFLOWS - Investor Contract: Additional Flows (Interface) FVD_IF_IA_CAPITALS_GET - Loans: Read Capital Amounts and Accounting Indicators >

How do I retrieve data from SAP structure FVD_IF_IA_BSID using ABAP code?

As FVD_IF_IA_BSID is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FVD_IF_IA_BSID as there is no data to select.

How to access SAP table FVD_IF_IA_BSID

Within an ECC or HANA version of SAP you can also view further information about FVD_IF_IA_BSID and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).