SAP ABAP Table FAGL_S_ACCOUNT_SEARCH (G/L Account Search)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-GL-GL (Application Component) Basic Functions
     ⤷ FAGL_DOCUMENT_UI (Package) User Interface Logic for Entering and Displaying Documents

Basic Data

Table Category	INTTAB	Structure
Structure	FAGL_S_ACCOUNT_SEARCH	Table Relationship Diagram
Short Description	G/L Account Search

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	T004
3	XBILK	☐	XBILK	XFELD	CHAR	1	0	Indicator: Account is a balance sheet account?
4	SAKAN	☐	SAKAN	CHAR10	CHAR	10	0	G/L account number, significant length
5	BILKT	☐	BILKT	SAKNR	CHAR	10	0	Group Account Number	SKA1
6	GVTYP	☐	GVTYP	CHAR2	CHAR	2	0	P&L statement account type
7	KTOKS	☐	KTOKS	KTOKS	CHAR	4	0	G/L Account Group	T077S
8	MUSTR	☐	MUSTR	MUSTR	CHAR	10	0	Number of the sample account	SKM1
9	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
10	XLOEV	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
11	XSPEA	☐	XSPEA	XFELD	CHAR	1	0	Indicator: account is blocked for creation ?
12	XSPEP	☐	XSPEP	XFELD	CHAR	1	0	Indicator: account blocked for planning ?
13	MCOD1	☐	MCODF	CHAR25	CHAR	25	0	Search Term for Using Matchcode
14	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
15	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
16	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
17	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
18	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	T001S
19	DATLZ	☐	DATLZ	DATUM	DATS	8	0	Date of the last interest calculation run
20	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
21	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
22	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	T035
23	FDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	T036
24	FIPLS	☐	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
25	FSTAG	☐	FSTAG	FSTAG	CHAR	4	0	Field status group	T004F
26	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
27	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
28	KDFSL	☐	KDFSL	KDFSL	CHAR	4	0	Key for Exchange Rate Differences in Foreign Currency Accts	T030S
29	MITKZ	☐	MITKZ	MITKZ	CHAR	1	0	Account is reconciliation account
30	MWSKZ	☐	SMWSK	SMWSK	CHAR	2	0	Tax Category in Account Master Record
31	STEXT	☐	STEXT_SKB1	TEXT50	CHAR	50	0	G/L account additional text
32	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	T056
33	WAERS	☐	WAERS_SKB1	WAERS	CUKY	5	0	Account currency	TCURC
34	WMETH	☐	WMETH	WMETH	CHAR	2	0	Indicator: account managed in external system
35	XGKON	☐	XGKON	XFELD	CHAR	1	0	Cash receipt account / cash disbursement account
36	XINTB	☐	XINTB	XFELD	CHAR	1	0	Indicator: Is account only posted to automatically?
37	XKRES	☐	XKRES	XFELD	CHAR	1	0	Indicator: Can Line Items Be Displayed by Account?
38	XLOEB	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
39	XNKON	☐	XNKON	XFELD	CHAR	1	0	Indicator: Supplement for automatic postings ?
40	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
41	XSPEB	☐	XSPEB	XFELD	CHAR	1	0	Indicator: Is Account Blocked for Posting?
42	ZINDT	☐	DZINDT	DATUM	DATS	8	0	Key date of the last interest calculation
43	ZINRT	☐	DZINRT	ZINRT	NUMC	2	0	Interest calculation frequency in months
44	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
45	ALTKT	☐	ALTKT_SKB1	SAKNR	CHAR	10	0	Alternative Account Number in Company Code	*
46	XMITK	☐	XMITK	XFELD	CHAR	1	0	Indicator: Reconcil.acct ready for input at time of posting?
47	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
48	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
49	XMWNO	☐	XMWNO	XFELD	CHAR	1	0	Indicator: Tax code is not a required field
50	XSALH	☐	XSALH	XFELD	CHAR	1	0	Indicator: Only Manage Balances in Local Currency
51	BEWGP	☐	BEWGP	CHAR10	CHAR	10	0	Valuation Group
52	INFKY	☐	J_1AIFSKS	J_1AIFSKS	CHAR	8	0	Inflation Key	J_1AINFSKS
53	TOGRU	☐	TOGRU_S	TOGRU	CHAR	4	0	Tolerance Group for G/L Accounts	T043S

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FAGL_S_ACCOUNT_SEARCH	BILKT	SKA1	SAKNR	REF	C	CN
2	FAGL_S_ACCOUNT_SEARCH	BUKRS	T001	BUKRS	KEY	1	CN
3	FAGL_S_ACCOUNT_SEARCH	BUSAB	T001S	BUSAB	REF	C	CN
4	FAGL_S_ACCOUNT_SEARCH	FDGRV	T035	GRUPP	REF	C	CN
5	FAGL_S_ACCOUNT_SEARCH	FDLEV	T036	EBENE	REF	C	CN
6	FAGL_S_ACCOUNT_SEARCH	FSTAG	T004F	FSTAG	REF	1	CN
7	FAGL_S_ACCOUNT_SEARCH	FUNC_AREA	TFKB	FKBER	REF
8	FAGL_S_ACCOUNT_SEARCH	HBKID	T012	HBKID	REF	C	CN
9	FAGL_S_ACCOUNT_SEARCH	HKTID	T012K	HKTID	REF	C	CN
10	FAGL_S_ACCOUNT_SEARCH	INFKY	J_1AINFSKS	J_1AIFSKS		1	CN
11	FAGL_S_ACCOUNT_SEARCH	KDFSL	T030S	KDFSL	REF	C	CN
12	FAGL_S_ACCOUNT_SEARCH	KTOKS	T077S	KTOKS	REF	1	CN
13	FAGL_S_ACCOUNT_SEARCH	KTOPL	T004	KTOPL	KEY	1	CN
14	FAGL_S_ACCOUNT_SEARCH	MUSTR	SKM1	MUSTR	REF	C	CN
15	FAGL_S_ACCOUNT_SEARCH	RECID	T8JJ	RECID	REF	C	CN
16	FAGL_S_ACCOUNT_SEARCH	TOGRU	T043S	TOGRU		1	CN
17	FAGL_S_ACCOUNT_SEARCH	VBUND	T880	RCOMP	REF	1	CN
18	FAGL_S_ACCOUNT_SEARCH	VZSKZ	T056	VZSKZ	REF	C	CN
19	FAGL_S_ACCOUNT_SEARCH	WAERS	TCURC	WAERS	REF	1	CN
20	FAGL_S_ACCOUNT_SEARCH	ZUAWA	TZUN	ZUAWA	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	500