SAP ABAP Table FBS_SX_FRS_WORK_STRUC_JOINT (All Data as Flat Version)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL-GL (Application Component) Basic Functions
     ⤷ FBS_SE_GLMASTER_REPLCTN (Package) Services for Proxies

Basic Data

Table Category	INTTAB	Structure
Structure	FBS_SX_FRS_WORK_STRUC_JOINT	Table Relationship Diagram
Short Description	All Data as Flat Version

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	VERSN	☐	FBS_SX_VERSION_JOINT		STRU	0	0
2	VERSN	☐	FBS_SX_VERSION		STRU	0	0
3	.INCLUDE	☐				0	0	General Control Data for Update
4	CONTROL	☐	FBS_T_FLD_CNTRL		REF	0	0
5	DB_ACTION	☐	DB_ACTION	CHAR1	CHAR	1	0	Action on database
6	COMPL_TRANSMISSION	☐	FLAG	FLAG	CHAR	1	0	General Flag
7	KEYY	☐	FBS_S_VRSN_KEY		STRU	0	0
8	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version
9	.INCLUDE	☐				0	0	Master Data: Financial Statement Version
10	T011	☐	T011		STRU	0	0
11	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
12	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version
13	DSPRA	☐	SPRAS	SPRAS	LANG	1	0	Language Key
14	ASPRA	☐	ASPRA	CHAR10	CHAR	10	0	Alternative languages
15	XERGS	☐	XERGS_011	XFELD	CHAR	1	0	Financial Statement Version Uses Group Chart of Accounts
16	KTOPL	☐	KTOPL_011	KTOPL	CHAR	4	0	Financial Statement Version Uses Only One Chart of Accounts
17	AKTVA	☐	AKTVA_011	ERGSL	CHAR	10	0	Item key representing the assets
18	PSSVA	☐	PSSVA_011	ERGSL	CHAR	10	0	Item Key Representing the Liabilities
19	ERGAK	☐	ERGAK_011	ERGSL	CHAR	10	0	Item key representing the line item net loss
20	ERGPA	☐	ERGPA_011	ERGSL	CHAR	10	0	Fin.statement key representing the net profit/yr
21	ERGGV	☐	ERGGV_011	ERGSL	CHAR	10	0	Fin.statement key representing the P+L profit item
22	ZUORD	☐	DZUORD_011	ERGSL	CHAR	10	0	Item key representing the non-assignable accounts
23	XAUTO	☐	XAUTO_011	CHAR01	CHAR	1	0	Indicator: automatically allocate item keys
24	XFBER	☐	XFBER_011	CHAR01	CHAR	1	0	Indicator: assignment of functional areas is permitted
25	ANHNG	☐	ANHNG_011	ERGSL	CHAR	10	0	Item key that represents notes to financial statements
26	VERSN_NAME	☐	FBS_SX_VERSN_NAME		STRU	0	0
27	.INCLUDE	☐				0	0	General Control Data for Update
28	CONTROL	☐	FBS_T_FLD_CNTRL		REF	0	0
29	DB_ACTION	☐	DB_ACTION	CHAR1	CHAR	1	0	Action on database
30	COMPL_TRANSMISSION	☐	FLAG	FLAG	CHAR	1	0	General Flag
31	KEYY	☐	FBS_S_VERSNT_KEY		STRU	0	0
32	.INCLUDE	☐				0	0	Key Fields for Financial Statement Version
33	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version
34	SPRAS	☐	LANGU	SPRAS	LANG	1	0	Language Key
35	.INCLUDE	☐				0	0	Texts of a Financial Statement Version
36	T011T	☐	T011T		STRU	0	0
37	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
38	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key
39	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version
40	VSTXT	☐	VSTXT_011T	TEXT50	CHAR	50	0	Financial Statement Version Name
41	NAMES_COMPLETE	☐	FLAG	FLAG	CHAR	1	0	General Flag
42	ITEMS_COMPLETE	☐	FLAG	FLAG	CHAR	1	0	General Flag
43	ITEM	☐	FBS_SX_VERSN_ITEM_JOINT		STRU	0	0
44	SCVCPC	☐	FBS_SX_VERSN_ITEM_SCVCPC		STRU	0	0
45	.INCLUDE	☐				0	0	General Control Data for Update
46	CONTROL	☐	FBS_T_FLD_CNTRL		REF	0	0
47	DB_ACTION	☐	DB_ACTION	CHAR1	CHAR	1	0	Action on database
48	COMPL_TRANSMISSION	☐	FLAG	FLAG	CHAR	1	0	General Flag
49	.INCLUDE	☐				0	0	Element of a Financial Statement Version
50	KEYY	☐	FBS_S_VERSN_ITEM_KEY		STRU	0	0
51	.INCLUDE	☐				0	0	Key Fields for Financial Statement Version
52	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version
53	ERGSL	☐	ERGSL	ERGSL	CHAR	10	0	Financial Statement Item
54	011SC	☐	FAGL_011SC		STRU	0	0
55	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
56	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version
57	ERGSL	☐	ERGSL	ERGSL	CHAR	10	0	Financial Statement Item
58	SETPR	☐	SETPR_011S	CHAR2	CHAR	2	0	Set name prefix
59	SETVS	☐	SETVS_011S	VERSN_011	CHAR	4	0	Balance sheet version
60	SETNR	☐	SETNR_011S	NUMC06	NUMC	6	0	Set Name Sequence Number
61	011VC	☐	FAGL_011VC		STRU	0	0
62	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
63	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version
64	ERGS1	☐	ERGSO_011Z	ERGSL	CHAR	10	0	Debit Item key
65	ERGS2	☐	ERGHB_011Z	ERGSL	CHAR	10	0	Credit Item Key
66	011PC	☐	FBS_S_011PC		STRU	0	0
67	.INCLUDE	☐				0	0	Fin. Statement Structure: Items in Fin. Statement Structure
68	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
69	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version
70	ID	☐	SEU_ID	SEU_ID	NUMC	6	0	Internal: Node ID
71	TYPE	☐	SEU_TYPE	SEU_TYPE	CHAR	4	0	Node type
72	ERGSL	☐	ERGSL	ERGSL	CHAR	10	0	Financial Statement Item
73	PARENT	☐	SEU_ID	SEU_ID	NUMC	6	0	Internal: Node ID
74	CHILD	☐	SEU_ID	SEU_ID	NUMC	6	0	Internal: Node ID
75	NEXTN	☐	SEU_ID	SEU_ID	NUMC	6	0	Internal: Node ID
76	STUFE	☐	STUFE_F02E	NUM02	NUMC	2	0	Financial statement item hierarchy level
77	SUMME	☐	SUMME_011P	CHAR1	CHAR	1	0	Is the total to be displayed? If yes, where?
78	SIGN	☐	RR_RSIGN	FLAG	CHAR	1	0	Change of sign (+/-)
79	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
80	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name
81	EDGE	☐	FBS_S_HIER_RELATION		STRU	0	0
82	PARENT	☐	ERGSL	ERGSL	CHAR	10	0	Financial Statement Item
83	NEXTN	☐	ERGSL	ERGSL	CHAR	10	0	Financial Statement Item
84	DB_ACTION	☐	DB_ACTION	CHAR1	CHAR	1	0	Action on database
85	011ZC	☐	FBS_S_VERSN_ITEM_011ZC		STRU	0	0
86	.INCLUDE	☐				0	0	General Control Data for Update
87	CONTROL	☐	FBS_T_FLD_CNTRL		REF	0	0
88	DB_ACTION	☐	DB_ACTION	CHAR1	CHAR	1	0	Action on database
89	COMPL_TRANSMISSION	☐	FLAG	FLAG	CHAR	1	0	General Flag
90	.INCLUDE	☐				0	0	Assignment of Financial Statement Element to G/L Account
91	KEYY	☐	FBS_S_VERSN_ITEM_011ZC_KEY		STRU	0	0
92	.INCLUDE	☐				0	0	Key Fields of an Element of the Financial Statement Version
93	.INCLUDE	☐				0	0	Key Fields for Financial Statement Version
94	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version
95	ERGSL	☐	ERGSL	ERGSL	CHAR	10	0	Financial Statement Item
96	VONKT	☐	VONKT_011Z	BILKT	CHAR	10	0	Account interval lower limit
97	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts
98	011ZC	☐	FAGL_011ZC		STRU	0	0
99	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
100	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version
101	ERGSL	☐	ERGSL	ERGSL	CHAR	10	0	Financial Statement Item
102	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts
103	VONKT	☐	VONKT_011Z	BILKT	CHAR	10	0	Account interval lower limit
104	BISKT	☐	BISKT_011Z	BILKT	CHAR	10	0	Account interval upper limit
105	XSOLL	☐	XSOLL_F02E	XFELD	CHAR	1	0	Indicator: Is entry relevant if there is a debit balance?
106	XHABN	☐	XHABN_F02E	XFELD	CHAR	1	0	Indicator: Is entry relevant if there is a credit balance ?
107	XVERD	☐	XVERD_011Z	XFELD	CHAR	1	0	Indicator: Group balance decides on allocation
108	011QT_TAB	☐	FBS_T_VERSN_ITEM_TEXT		TTYP	0	0
109	011FC	☐	FBS_S_VERSN_ITEM_FUNC		STRU	0	0
110	.INCLUDE	☐				0	0	General Control Data for Update
111	CONTROL	☐	FBS_T_FLD_CNTRL		REF	0	0
112	DB_ACTION	☐	DB_ACTION	CHAR1	CHAR	1	0	Action on database
113	COMPL_TRANSMISSION	☐	FLAG	FLAG	CHAR	1	0	General Flag
114	.INCLUDE	☐				0	0	Assignment of Elements to Functional Area
115	KEYY	☐	FBS_S_VERSN_ITEM_FUNC_KEY		STRU	0	0
116	.INCLUDE	☐				0	0	Key Fields of an Element of the Financial Statement Version
117	.INCLUDE	☐				0	0	Key Fields for Financial Statement Version
118	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version
119	ERGSL	☐	ERGSL	ERGSL	CHAR	10	0	Financial Statement Item
120	VONFB	☐	VONFB_011F	FKBER	CHAR	16	0	Functional area interval lower limit
121	011FC	☐	FAGL_011FC		STRU	0	0
122	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
123	VERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version
124	ERGSL	☐	ERGSL	ERGSL	CHAR	10	0	Financial Statement Item
125	VONFB	☐	VONFB_011F	FKBER	CHAR	16	0	Functional area interval lower limit
126	BISFB	☐	BISFB_011F	FKBER	CHAR	16	0	Functional area interval upper limit
127	ZC_COMPLETE	☐	FLAG	FLAG	CHAR	1	0	General Flag
128	QT_COMPLETE	☐	FLAG	FLAG	CHAR	1	0	General Flag
129	FC_COMPLETE	☐	FLAG	FLAG	CHAR	1	0	General Flag

History

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