SAP ABAP Table IFMFGRCN_ITEM_L90 (Structure for item level data from SL 90 provider)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM (Application Component) Funds Management
     ⤷ FMFG_RECON_E (Package) Reconciliation Tool

Basic Data

Table Category	INTTAB	Structure
Structure	IFMFGRCN_ITEM_L90	Table Relationship Diagram
Short Description	Structure for item level data from SL 90 provider

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	.INCLUDE	☐				0	0	Standard fields to be used in Reconciliation drilldown/match
2	.INCLUDE	☐				0	0	Key fields for item identification in drilldown/matching
3	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
4	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
5	AWSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	TBDLS
6	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
7	DOCLN	☐	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
8	CREATEDATE	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
9	CREATETIME	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
10	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
11	AMOUNT	☐	FMFGRCNAMOUNT	WERTV9	CURR	17	2	Reconciliation: Calculated amount for a factor in a rule
12	MATCH_AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
13	MATCH_AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
14	MATCH_AWSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	TBDLS
15	MATCH_DOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
16	MATCH_DOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
17	DOC_TYPE	☐	FMFGRCNDOCTYPE	CHAR4	CHAR	4	0	Reconciliation: generic document type
18	FISC_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
19	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
20	POST_DATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
21	MATCH_FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
22	.INCLUDE	☐				0	0	Reconciliation: fields supported by SL 95 data provider
23	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	*
24	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
25	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	T894
26	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
27	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
28	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
29	RGRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
30	RSPONSORED_PROG	☐	GM_SPONSORED_PROG	GM_SPONSORED_PROG	CHAR	20	0	Sponsored Program	GMSPPROGRAM
31	RSPONSORED_CLASS	☐	GM_SPONSORED_CLASS	GM_SPONSORED_CLASS	CHAR	20	0	Sponsored Class	GMSPCLASS
32	RBDGT_VLDTY_NBR	☐	GM_BDGT_VLDTY_NBR	GM_BDGT_VLDTY_NBR	CHAR	3	0	Budget Validity Number
33	RVALUETYPE_9	☐	GM_VALUETYPE	GM_VALUETYPE	CHAR	2	0	GM Value Type
34	RTRANS	☐	J_VORGANG	J_VORGANG	CHAR	4	0	Business Transaction	TJ01
35	RSTATS_IND	☐	GM_STATS	GM_STATS	CHAR	1	0	Statistical Indicator
36	RGRANTEE_FY_9	☐	GM_GRANTEE_FY	GJAHR	NUMC	4	0	Fiscal Year of Grantee Organization
37	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
38	BDGT_STATE	☐	GM_BDGT_STATE	GM_BDGT_STATE	CHAR	1	0	Workflow State of a Record in the Budget Totals Table
39	RFUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
40	PERIOD	☐	POPER	POPER	NUMC	3	0	Posting period
41	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IFMFGRCN_ITEM_L90	AWSYS	TBDLS	LOGSYS
2	IFMFGRCN_ITEM_L90	AWTYP	TTYP	AWTYP
3	IFMFGRCN_ITEM_L90	COMP_CODE	T001	BUKRS
4	IFMFGRCN_ITEM_L90	CURRENCY	TCURC	WAERS
5	IFMFGRCN_ITEM_L90	LOGSYS	TBDLS	LOGSYS
6	IFMFGRCN_ITEM_L90	MATCH_AWSYS	TBDLS	LOGSYS
7	IFMFGRCN_ITEM_L90	MATCH_AWTYP	TTYP	AWTYP
8	IFMFGRCN_ITEM_L90	RFUND	FMFINCODE	FINCODE
9	IFMFGRCN_ITEM_L90	RSPONSORED_CLASS	GMSPCLASS	SPONSORED_CLASS
10	IFMFGRCN_ITEM_L90	RSPONSORED_PROG	GMSPPROGRAM	SPONSORED_PROG
11	IFMFGRCN_ITEM_L90	RTCUR	TCURC	WAERS
12	IFMFGRCN_ITEM_L90	RTRANS	TJ01	VRGNG
13	IFMFGRCN_ITEM_L90	RVERS	T894	RVERS

History

Last changed by/on	SAP	20110901
SAP Release Created in	600