SAP ABAP Table FAGL_S_SREP_GET_ACC_ALL_ATTR (All Attributes of the Account)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL (Application Component) General Ledger Accounting
     ⤷ FAGL_REPORTING_EHP3 (Package) Reporting: General Ledger Accounting

Basic Data

Table Category	INTTAB	Structure
Structure	FAGL_S_SREP_GET_ACC_ALL_ATTR	Table Relationship Diagram
Short Description	All Attributes of the Account

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	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
2	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
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	.INCLUDE	☐				0	0	G/L Account Master Record (Chart of Accounts)
6	BILKT	☐	BILKT	SAKNR	CHAR	10	0	Group Account Number	SKA1
7	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
8	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
9	GVTYP	☐	GVTYP	CHAR2	CHAR	2	0	P&L statement account type
10	KTOKS	☐	KTOKS	KTOKS	CHAR	4	0	G/L Account Group	T077S
11	MUSTR	☐	MUSTR	MUSTR	CHAR	10	0	Number of the sample account	SKM1
12	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
13	XLOEV	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
14	XSPEA	☐	XSPEA	XFELD	CHAR	1	0	Indicator: account is blocked for creation ?
15	XSPEB	☐	XSPEB	XFELD	CHAR	1	0	Indicator: Is Account Blocked for Posting?
16	XSPEP	☐	XSPEP	XFELD	CHAR	1	0	Indicator: account blocked for planning ?
17	MCOD1	☐	MCODF	CHAR25	CHAR	25	0	Search Term for Using Matchcode
18	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
19	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
20	SKB1_ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
21	SKB1_ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
22	SKB1_XSPEB	☐	XSPEB	XFELD	CHAR	1	0	Indicator: Is Account Blocked for Posting?
23	SKB1_XLOEB	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
24	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
25	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
26	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	*
27	DATLZ	☐	DATLZ	DATUM	DATS	8	0	Date of the last interest calculation run
28	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	*
29	FDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	*
30	FIPLS	☐	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
31	FSTAG	☐	FSTAG	FSTAG	CHAR	4	0	Field status group	*
32	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
33	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	*
34	KDFSL	☐	KDFSL	KDFSL	CHAR	4	0	Key for Exchange Rate Differences in Foreign Currency Accts	*
35	MITKZ	☐	MITKZ	MITKZ	CHAR	1	0	Account is reconciliation account
36	MWSKZ	☐	SMWSK	SMWSK	CHAR	2	0	Tax Category in Account Master Record
37	STEXT	☐	STEXT_SKB1	TEXT50	CHAR	50	0	G/L account additional text
38	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	*
39	WAERS	☐	WAERS_SKB1	WAERS	CUKY	5	0	Account currency	*
40	WMETH	☐	WMETH	WMETH	CHAR	2	0	Indicator: account managed in external system
41	XGKON	☐	XGKON	XFELD	CHAR	1	0	Cash receipt account / cash disbursement account
42	XINTB	☐	XINTB	XFELD	CHAR	1	0	Indicator: Is account only posted to automatically?
43	XKRES	☐	XKRES	XFELD	CHAR	1	0	Indicator: Can Line Items Be Displayed by Account?
44	XLOEB	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
45	XNKON	☐	XNKON	XFELD	CHAR	1	0	Indicator: Supplement for automatic postings ?
46	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
47	ZINDT	☐	DZINDT	DATUM	DATS	8	0	Key date of the last interest calculation
48	ZINRT	☐	DZINRT	ZINRT	NUMC	2	0	Interest calculation frequency in months
49	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	*
50	ALTKT	☐	ALTKT_SKB1	SAKNR	CHAR	10	0	Alternative Account Number in Company Code	*
51	XMITK	☐	XMITK	XFELD	CHAR	1	0	Indicator: Reconcil.acct ready for input at time of posting?
52	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
53	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
54	XMWNO	☐	XMWNO	XFELD	CHAR	1	0	Indicator: Tax code is not a required field
55	XSALH	☐	XSALH	XFELD	CHAR	1	0	Indicator: Only Manage Balances in Local Currency
56	BEWGP	☐	BEWGP	CHAR10	CHAR	10	0	Valuation Group
57	INFKY	☐	J_1AIFSKS	J_1AIFSKS	CHAR	8	0	Inflation Key	*
58	TOGRU	☐	TOGRU_S	TOGRU	CHAR	4	0	Tolerance Group for G/L Accounts	*
59	XLGCLR	☐	XLGCLR	XFELD	CHAR	1	0	Clearing Specific to Ledger Groups
60	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version	*
61	XERGS	☐	XERGS_011	XFELD	CHAR	1	0	Financial Statement Version Uses Group Chart of Accounts
62	VONKT	☐	VONKT_011Z	BILKT	CHAR	10	0	Account interval lower limit
63	ERGSO	☐	ERGSO_011Z	ERGSL	CHAR	10	0	Debit Item key
64	ERGHB	☐	ERGHB_011Z	ERGSL	CHAR	10	0	Credit Item Key
65	XVERD	☐	XVERD_011Z	XFELD	CHAR	1	0	Indicator: Group balance decides on allocation

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FAGL_S_SREP_GET_ACC_ALL_ATTR	BILKT	SKA1	SAKNR	REF	C	CN
2	FAGL_S_SREP_GET_ACC_ALL_ATTR	FUNC_AREA	TFKB	FKBER	REF
3	FAGL_S_SREP_GET_ACC_ALL_ATTR	KTOKS	T077S	KTOKS	REF	1	CN
4	FAGL_S_SREP_GET_ACC_ALL_ATTR	MUSTR	SKM1	MUSTR	REF	C	CN
5	FAGL_S_SREP_GET_ACC_ALL_ATTR	VBUND	T880	RCOMP	REF	1	CN

History

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