SAP ABAP Table FKACCESS (Record layout for uploading from MS ACCESS data entry)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LC-LC (Application Component) Basic Functions
     ⤷ FKUC (Package) FI-LC Consolidation: Unicode-Capable Objects

Basic Data

Table Category	INTTAB	Structure
Structure	FKACCESS	Table Relationship Diagram
Short Description	Record layout for uploading from MS ACCESS data entry

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	RDIMEN	☐	FC_DIMEN	FC_DIMEN	CHAR	2	0	Dimension	TF150
2	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	*
3	RBUNIT	☐	FC_BUNIT	FC_BUNIT	CHAR	18	0	Consolidation unit	TF160
4	RYEAR	☐	RYEAR	GJAHR	NUMC	4	0	Fiscal year
5	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
6	RITCLG	☐	FC_ITCLG	FC_ITCLG	CHAR	2	0	Consolidation chart of accounts	TF120
7	RITEM	☐	FC_ITEM	FC_ITEM	CHAR	10	0	Financial statement item	TF100
8	RSITYP	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
9	RSITEM	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
10	RBUPTR	☐	FC_BUPTR	FC_BUNIT	CHAR	18	0	Partner unit	TF160
11	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
12	RYACQ	☐	RYACQ	CJAHR	CHAR	4	0	Year of acquisition
13	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
14	HSL	☐	NUMC15	NUMC15	NUMC	15	0	Numerical field, 15 characters long
15	HSIGN	☐	SIGN	SIGN	CHAR	1	0	Debit/Credit Sign (+/-)
16	TSL	☐	NUMC15	NUMC15	NUMC	15	0	Numerical field, 15 characters long
17	TSIGN	☐	SIGN	SIGN	CHAR	1	0	Debit/Credit Sign (+/-)
18	KSL	☐	NUMC15	NUMC15	NUMC	15	0	Numerical field, 15 characters long
19	KSIGN	☐	SIGN	SIGN	CHAR	1	0	Debit/Credit Sign (+/-)
20	MSL	☐	NUMC15	NUMC15	NUMC	15	0	Numerical field, 15 characters long
21	MSIGN	☐	SIGN	SIGN	CHAR	1	0	Debit/Credit Sign (+/-)
22	ADFLD1	☐	ADFLD1	ADFLD1	CHAR	10	0	First additional field for user-defined account assignments	*
23	ADFLD2	☐	ADFLD2	ADFLD2	CHAR	10	0	Second additional field for user-defined account assignments	*
24	ADFLD3	☐	ADFLD3	ADFLD3	CHAR	10	0	Third additional field for user-defined account assignments	*
25	HSL_SE	☐	NUMC15	NUMC15	NUMC	15	0	Numerical field, 15 characters long
26	HSESIGN	☐	SIGN	SIGN	CHAR	1	0	Debit/Credit Sign (+/-)
27	TSL_SE	☐	NUMC15	NUMC15	NUMC	15	0	Numerical field, 15 characters long
28	TSESIGN	☐	SIGN	SIGN	CHAR	1	0	Debit/Credit Sign (+/-)
29	MSL_SE	☐	NUMC15	NUMC15	NUMC	15	0	Numerical field, 15 characters long
30	MSESIGN	☐	SIGN	SIGN	CHAR	1	0	Debit/Credit Sign (+/-)
31	TXT	☐	TXT30	TEXT30	CHAR	30	0	Text
32	CHDIG	☐	CHAR8	CHAR8	CHAR	8	0	Character field, 8 characters long

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FKACCESS	RBUNIT	TF160	BUNIT
2	FKACCESS	RBUPTR	TF160	BUNIT
3	FKACCESS	RDIMEN	TF150	DIMEN
4	FKACCESS	RITCLG	TF120	ITCLG
5	FKACCESS	RITEM	TF100	ITEM
6	FKACCESS	RTCUR	TCURC	WAERS
7	FKACCESS	RUNIT	T006	MSEHI

History

Last changed by/on	SAP	19980505
SAP Release Created in