SAP ABAP Table IUSFGFDERIVE (Derivation of US Federal government fields)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM (Application Component) Funds Management
     ⤷ FMFG_E (Package) US Federal Government budgetary ledger account derivation

Basic Data

Table Category	INTTAB	Structure
Structure	IUSFGFDERIVE	Table Relationship Diagram
Short Description	Derivation of US Federal government fields

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	POSTING_DATE	☐	ADATU	DATUM	DATS	8	0	Date for beginning of validity
2	BDGT_SUBTYPE	☐	BP_SUBVO	BP_SUBVO	CHAR	4	0	Budget Subtype	TBP4A
3	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
4	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
5	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
6	KBLNR_9	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	*
7	KBLPOS_9	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
8	EBELN_9	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
9	EBELP_9	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
10	FMCMMTSTR_9	☐	FMCMMTSTR	FMCMMTSTR	CHAR	62	0	FM Commitment String For Budgetary Ledger
11	FM_FINUSE	☐	FM_FINUSE	FM_FINUSE	CHAR	16	0	Application of Secondary Source Funds	FMFUSE
12	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
13	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
14	ORDNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
15	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
16	CNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
17	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
18	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
19	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
20	FUND_TYPE	☐	FM_FUNDTYPE	FM_FUNDTYPE	CHAR	6	0	FM Fund Type	FMFUNDTYPE
21	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
22	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
23	.INCLUDE	☐				0	0	Other than FACTS1 and FACTS2
24	AGNCY_LCTN_CODE	☐	FMFG_ALC	FMFG_ALC	CHAR	8	0	Agency Location Code	FMFGT_ALC
25	SGL_ACCOUNT	☐	FM_SGL_ACCOUNT	FM_SGL_ACCOUNT	CHAR	4	0	SGL Account, US Federal Government
26	.INCLUDE	☐				0	0	Fields for US Federal government FACTS1
27	FLG_CUSTODIAL	☐	FM_FLG_CUSTODIAL	FM_FLG_CUSTODIAL	CHAR	1	0	Custodial Indicator
28	FLG_COVERED	☐	FM_FLG_COVERED	FM_FLG_COVERED	CHAR	1	0	Covered Indicator
29	FLG_ENTITY	☐	FM_FLG_ENTITY	FM_FLG_ENTITY	CHAR	1	0	Entity Indicator
30	FLG_EXCHANGE	☐	FM_FLG_EXCHANGE	FM_FLG_EXCHANGE	CHAR	1	0	Exchange Indicator
31	FLG_FEDERAL	☐	FM_FLG_FEDERAL	FM_FLG_FEDERAL	CHAR	1	0	Federal Indicator
32	BDGT_FUNC_CLSS	☐	FM_BDGT_FUNC_CLSS	CHAR3	CHAR	3	0	Classification of Data According to Major Purpose
33	BUREAU	☐	FM_BUREAU	FM_BUREAU	CHAR	2	0	Federal Bureau
34	BUSINESS_LINE	☐	FM_BUSINESS_LINE	FM_BUSINESS_LINE	CHAR	2	0	Business Line
35	FGDPRTMNT	☐	FM_DEPARTMENT	FM_DEPARTMENT	CHAR	2	0	Federal Department
36	FGDPRTMNT_PART	☐	FM_DEPARTMENT_PARTNER	FM_DEPARTMENT	CHAR	2	0	Federal Department Partner
37	FUND_ACC_SYMBL	☐	FM_MAIN_ACCT	FM_MAIN_ACCT	CHAR	4	0	Treasury Account Symbol - Main Account
38	.INCLUDE	☐				0	0	Fields for US Federal government FACTS2
39	FLG_DEFINITE	☐	FM_FLG_DEFINITE	FM_FLG_DEFINITE	CHAR	1	0	Definite/Indef indicator
40	FLG_APPORT	☐	FM_FLG_APPORT	FM_FLG_APPORT	CHAR	1	0	Apportionment Category
41	FLG_AVAIL	☐	FM_FLG_AVAIL	FM_FLG_AVAIL	CHAR	1	0	Availability Time
42	FLG_REIMBUR	☐	FM_FLG_REIMBUR	FM_FLG_REIMBUR	CHAR	1	0	Reimbursable
43	FLG_AUTHOR	☐	FM_FLG_AUTHOR	FM_FLG_AUTHOR	CHAR	1	0	Authority Type
44	FLG_BORROW	☐	FM_FLG_BORROW	FM_FLG_BORROW	CHAR	1	0	Borrowing Source
45	FLG_BEA	☐	FM_FLG_BEA	FM_FLG_BEA	CHAR	1	0	BEA Category
46	FLG_PARTNER	☐	FM_FLG_PARTNER	FM_FLG_PARTNER	CHAR	1	0	Transaction Partner
47	COHORT	☐	FM_COHORT	FM_COHORT	CHAR	4	0	Reporting Year for Cohort
48	PUBLAW	☐	FM_PUBLAW	FM_PUBLAW	CHAR	20	0	Public Law Cited
49	LEGIS	☐	FM_LEGIS	FM_LEGIS	CHAR	1	0	Type of Legislation
50	TRANSFER_AGCY_9	☐	FMFG_TRANSFER	FMFG_TRANSFER	CHAR	2	0	Transfer Agency	FMUSFGF2_TRANS
51	TRANSFER_ACCT_9	☐	FMFG_TRAN_ACCT	FMFG_TRAN_ACCT	CHAR	4	0	Transfer Account	FMUSFGF2_TRANS
52	YEAR_BDGT_AUTH_9	☐	FMFG_YR_BUD_AUTH	FMFG_YR_BUD_AUTH	CHAR	4	0	Year of Budget Authority
53	FLG_ADVANCE_9	☐	FMFG_FLG_ADVANCE	FMFG_FLG_ADVANCE	CHAR	1	0	Advanced Flag
54	DEFENSE_INDIC_9	☐	FMFG_DEFENSE_INDICATOR	FMFG_DEFENSE_INDICATOR	CHAR	3	0	Defense Indicator
55	PROG_REPT_CAT	☐	FMFG_PROGRAM_REPORT_CATEGORY	FMFG_PROGRAM_REPORT_CATEGORY	CHAR	3	0	Program Reporting Category Posted	FMFGF2PRC
56	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
57	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
58	FLG_PYA	☐	FMFG_FLG_PYA	FMFG_FLG_PYA	CHAR	1	0	Prior Year Adjustment flag
59	APPOR_CAT_B_DETAIL	☐	FMFG_APPORTDTL		CHAR	3	0	Apportionment Detail
60	APPOR_CAT_B_TXT	☐	FMFG_APPORTTEXT		CHAR	25	0	Apportionment Text
61	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IUSFGFDERIVE	AGNCY_LCTN_CODE	FMFGT_ALC	ALC
2	IUSFGFDERIVE	BDGT_SUBTYPE	TBP4A	SUBVO
3	IUSFGFDERIVE	FM_FINUSE	FMFUSE	FINUSE
4	IUSFGFDERIVE	FUND_TYPE	FMFUNDTYPE	FUND_TYPE
5	IUSFGFDERIVE	PROG_REPT_CAT	FMFGF2PRC	PROG_REPT_CAT
6	IUSFGFDERIVE	PROJK	PRPS	PSPNR
7	IUSFGFDERIVE	TRANSFER_ACCT_9	FMUSFGF2_TRANS	TRANSFER_ACCOUNT	KEY	1	CN
8	IUSFGFDERIVE	TRANSFER_AGCY_9	FMUSFGF2_TRANS	TRANSFER_AGENCY	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	462A