SAP ABAP Table FMSPLITA (Actual line item table)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM (Application Component) Funds Management
     ⤷ FMFS_E (Package) Updating/Integration Funds Management (master lang. english)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FMSPLITA	Table Relationship Diagram
Short Description	Actual line item table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	RCLNT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	GL_SIRID	☑	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
3	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
4	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
5	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	T894
6	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
8	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
9	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
10	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
11	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
12	DOCLN	☐	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
13	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
14	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	*
15	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
16	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
17	RPROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
18	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
19	RFISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
20	RFUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
21	RFUND_TYPE	☐	FM_FUNDTYPE	FM_FUNDTYPE	CHAR	6	0	FM Fund Type	*
22	RAUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
23	RGRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
24	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
25	SBUKRS	☐	PBUKRS	BUKRS	CHAR	4	0	Company code of partner	T001
26	SACCT	☐	PRACCT	SAKNR	CHAR	10	0	Partner account number	*
27	SBUSA	☐	PPARGB	GSBER	CHAR	4	0	Trading Partner Business Area of the Business Partner	TGSB
28	SCNTR	☐	PKOSTL	KOSTL	CHAR	10	0	Partner cost center	*
29	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
30	SFUND	☐	BP_P_GEBER	BP_GEBER	CHAR	10	0	Partner Fund	*
31	SGRANT_NBR	☐	GM_GRANT_PARTNER	GM_GRANT_NBR	CHAR	20	0	Partner Grant
32	TSL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
33	HSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
34	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
35	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
36	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
37	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
38	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
39	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
40	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
41	REFRYEAR	☐	REFGJAHR	GJAHR	NUMC	4	0	Reference fiscal year
42	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
43	REFDOCCT	☐	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
44	REFACTIV	☐	REFGLVOR	CHAR4	CHAR	4	0	FI-SL Business Reference Transaction
45	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
46	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
47	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
48	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
49	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
50	WSL	☐	VWCUR12	WERTV12	CURR	23	2	Value in Original Transaction Currency (Document Currency)
51	RWCUR	☐	RWCUR	WAERS	CUKY	5	0	Currency key of the original transaction currency	*
52	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
53	LINETYPE	☐	LINETYPE	LINETYPE	CHAR	5	0	Item category	*
54	XSPLITMOD	☐	XSPLITMOD	XFELD	CHAR	1	0	Item changed by document splitting
55	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
56	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
57	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMSPLITA	AWTYP	TTYP	AWTYP	REF	C	CN
2	FMSPLITA	DOCTY	T889	DOCTY	REF	C	CN
3	FMSPLITA	LOGSYS	TBDLS	LOGSYS	REF	C	CN
4	FMSPLITA	RBUKRS	T001	BUKRS	REF	C	CN
5	FMSPLITA	RBUSA	TGSB	GSBER	REF	C	CN
6	FMSPLITA	RCLNT	T000	MANDT	KEY	1	CN
7	FMSPLITA	RFAREA	TFKB	FKBER	REF	C	CN
8	FMSPLITA	RLDNR	T881	RLDNR	REF	C	CN
9	FMSPLITA	RTCUR	TCURC	WAERS	REF	C	CN
10	FMSPLITA	RVERS	T894	RVERS	REF	C	CN
11	FMSPLITA	SBUKRS	T001	BUKRS	REF	C	CN
12	FMSPLITA	SBUSA	TGSB	GSBER	REF	C	CN
13	FMSPLITA	SFAREA	TFKB	FKBER	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in