SAP IUSFGFDERIVE Derivation of US Federal government fields Table data and field list

IUSFGFDERIVE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Derivation of US Federal government fields" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_IUSFGFDERIVE TYPE IUSFGFDERIVE.

The IUSFGFDERIVE table consists of various fields, each holding specific information or linking keys about Derivation of US Federal government fields data available in SAP. These include BDGT_SUBTYPE (Budget Subtype), FIKRS (Financial Management Area), HKONT (General Ledger Account), FUND (Fund)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

IUSFGFDERIVE structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP IUSFGFDERIVE structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the IUSFGFDERIVE table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
POSTING_DATE	Posting Date in the Document	BUDAT	DATS	8			DATUM
BDGT_SUBTYPE	Budget Subtype	BP_SUBVO	CHAR	4	TBP4A		BP_SUBVO
FIKRS	Financial Management Area	FIKRS	CHAR	4	Assigned to domain		FIKRS	FIK
HKONT	General Ledger Account	HKONT	CHAR	10	Assigned to domain	ALPHA	SAKNR
FUND	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
KBLNR_9	Document Number for Earmarked Funds	KBLNR_FI	CHAR	10	Assigned to domain	ALPHA	KBLNR	KBL
KBLPOS_9	Earmarked Funds: Document Item	KBLPOS	NUMC	3	KBLP		KBLPOS	KBP
EBELN_9	Purchasing Document Number	EBELN	CHAR	10	Assigned to domain	ALPHA	EBELN	BES	MEKK_C
EBELP_9	Item Number of Purchasing Document	EBELP	NUMC	5	Assigned to domain		EBELP	BSP
FMCMMTSTR_9	FM Commitment String For Budgetary Ledger	FMCMMTSTR	CHAR	62			FMCMMTSTR
FM_FINUSE	Application of Secondary Source Funds	FM_FINUSE	CHAR	16	FMFUSE		FM_FINUSE	FIU
FIPEX	Commitment Item	FM_FIPEX	CHAR	24	Assigned to domain		FM_FIPEX	FPS
FISTL	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
ORDNR	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
VBUND	Company ID of trading partner	RASSC	CHAR	6	Assigned to domain	ALPHA	RCOMP	PGS
CNTR	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
PROJK	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	NUMC	8	PRPS	KONPR	PS_POSNR
GSBER	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
FKBER	Functional Area	FKBER	CHAR	16	Assigned to domain		FKBER	FBE
FUND_TYPE	FM Fund Type	FM_FUNDTYPE	CHAR	6	FMFUNDTYPE		FM_FUNDTYPE
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
MEASURE	Funded Program	FM_MEASURE	CHAR	24	Assigned to domain		FM_MEASURE	FM_MEASURE
FLG_CUSTODIAL	Custodial Indicator	FM_FLG_CUSTODIAL	CHAR	1			FM_FLG_CUSTODIAL
FLG_COVERED	Covered Indicator	FM_FLG_COVERED	CHAR	1			FM_FLG_COVERED
FLG_ENTITY	Entity Indicator	FM_FLG_ENTITY	CHAR	1			FM_FLG_ENTITY
FLG_EXCHANGE	Exchange Indicator	FM_FLG_EXCHANGE	CHAR	1			FM_FLG_EXCHANGE
FLG_FEDERAL	Federal/Nonfederal Code	FM_FLG_FEDERAL	CHAR	1			FM_FLG_FEDERAL
BDGT_FUNC_CLSS	Classification of Data According to Major Purpose	FM_BDGT_FUNC_CLSS	CHAR	3			CHAR3
BUREAU	Federal Bureau	FM_BUREAU	CHAR	2			FM_BUREAU
BUSINESS_LINE	Business Line	FM_BUSINESS_LINE	CHAR	2			FM_BUSINESS_LINE
FGDPRTMNT	Federal Department	FM_DEPARTMENT	CHAR	2			FM_DEPARTMENT
FGDPRTMNT_PART	Federal Department Partner	FM_DEPARTMENT_PARTNER	CHAR	2			FM_DEPARTMENT
FUND_ACC_SYMBL	Treasury Account Symbol - Main Account	FM_MAIN_ACCT	CHAR	4			FM_MAIN_ACCT
FLG_DEFINITE	Definite/Indef indicator	FM_FLG_DEFINITE	CHAR	1			FM_FLG_DEFINITE
FLG_APPORT	Apportionment Category	FM_FLG_APPORT	CHAR	1			FM_FLG_APPORT
FLG_AVAIL	Availability Time	FM_FLG_AVAIL	CHAR	1			FM_FLG_AVAIL
FLG_REIMBUR	Reimbursable	FM_FLG_REIMBUR	CHAR	1			FM_FLG_REIMBUR
FLG_AUTHOR	Authority Type	FM_FLG_AUTHOR	CHAR	1			FM_FLG_AUTHOR
FLG_BORROW	Borrowing Source	FM_FLG_BORROW	CHAR	1			FM_FLG_BORROW
FLG_BEA	Budget Enforcement Act Category	FM_FLG_BEA	CHAR	1			FM_FLG_BEA
FLG_PARTNER	Transaction Partner	FM_FLG_PARTNER	CHAR	1			FM_FLG_PARTNER
COHORT	Reporting Year for Cohort	FM_COHORT	CHAR	4			FM_COHORT
PUBLAW	Public Law Cited	FM_PUBLAW	CHAR	20			FM_PUBLAW
LEGIS	Type of Legislation	FM_LEGIS	CHAR	1			FM_LEGIS
TRANSFER_AGCY_9	Transfer Agency	FMFG_TRANSFER	CHAR	2	FMUSFGF2_TRANS		FMFG_TRANSFER		FM_TRANS_AGENCY
TRANSFER_ACCT_9	Transfer Account	FMFG_TRAN_ACCT	CHAR	4	FMUSFGF2_TRANS		FMFG_TRAN_ACCT
YEAR_BDGT_AUTH_9	Year of Budget Authority	FMFG_YR_BUD_AUTH	CHAR	4			FMFG_YR_BUD_AUTH
FLG_ADVANCE_9	Advanced Flag	FMFG_FLG_ADVANCE	CHAR	1			FMFG_FLG_ADVANCE
DEFENSE_INDIC_9	Defense Indicator	FMFG_DEFENSE_INDICATOR	CHAR	3			FMFG_DEFENSE_INDICATOR
PROG_REPT_CAT	Program Reporting Category	FMFG_PROGRAM_REPORT_CATEGORY	CHAR	3	FMFGF2PRC		FMFG_PROGRAM_REPORT_CATEGORY
LIFNR	Account Number of Vendor or Creditor	LIFNR	CHAR	10	Assigned to domain	ALPHA	LIFNR	LIF	KRED_C
KUNNR	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
FLG_PYA	Prior Year Adjustment Code	FMFG_FLG_PYA	CHAR	1			FMFG_FLG_PYA
APPOR_CAT_B_DETAIL	Apportionment Category B Program Code	FMFG_APPORTDTL	CHAR	4
APPOR_CAT_B_TXT	Apportionment Text	FMFG_APPORTTEXT	CHAR	25
AGNCY_LCTN_CODE	Agency Location Code	FMFG_ALC	CHAR	8	FMFGT_ALC		FMFG_ALC	FMFG_ALC
SGL_ACCOUNT	Standard General Ledger Account for US Federal Government	FM_SGL_ACCOUNT	CHAR	6			FM_SGL_ACCOUNT	SGL_ACCOUNT	FMFG_SGL_ACCOUNT
BDG_IMPACT	Budgetary Impact	FMFG_BDGT_IMPACT	CHAR	1			FMFG_BDGT_IMPACT
PROGRAM_IND	Program	FMFG_PROGRAM_IND	CHAR	1			FMFG_PROGRAM_IND
TP_SUBLEVL	Sublevel Prefix (SP) for Trading Partner	FMFG_TP_SUBLEVL	CHAR	2			FMFG_SUBLEVL
TP_AGENCID	Agency Identifier (AID) for Trading Partner	FMFG_TP_AGENCID	CHAR	3			FMFG_AGENCID
TP_ALTRAID	Allocation Transfer Agency Identifier (ATA) Trading Partner	FMFG_TP_ALTRAID	CHAR	3			FMFG_ALTRAID
TP_BEGPER	Beginning Period of Availability (BPOA) for Trading Partner	FMFG_TP_BEGPER	NUMC	4		GJAHR	FMFG_BEGPER
TP_ENDPER	Ending Period of Availability (EPOA) for Trading Partner	FMFG_TP_ENDPER	NUMC	4		GJAHR	FMFG_ENDPER
TP_AVTYPE	Availability Type Code (A) for Trading Partner	FMFG_TP_AVTYPE	CHAR	1			FMFG_AVTYPE
TP_MAIN_ACCT	Main Account for Trading Partner	FMFG_TP_MAIN_ACCT	CHAR	4
TP_SUB_ACCT	Subaccount for Trading Partner	FMFG_TP_SUB_ACCT	CHAR	3
SUBLEVL	Sublevel Prefix (SP)	FMFG_SUBLEVL	CHAR	2			FMFG_SUBLEVL
AGENCID	Agency Identifier (AID)	FMFG_AGENCID	CHAR	3			FMFG_AGENCID
ALTRAID	Allocation Transfer Agency Identifier (ATA)	FMFG_ALTRAID	CHAR	3			FMFG_ALTRAID
BEGPER	Beginning Period of Availability (BPOA)	FMFG_BEGPER	NUMC	4		GJAHR	FMFG_BEGPER
ENDPER	Ending Period of Availability (EPOA)	FMFG_ENDPER	NUMC	4		GJAHR	FMFG_ENDPER
AVTYPE	Availability Type Code (A)	FMFG_AVTYPE	CHAR	1			FMFG_AVTYPE
SUB_ACCT	Treasury Account Symbol - Subaccount	FM_SUB_ACCT	CHAR	3			FM_SUB_ACCT
FUND_STATUS	FM Fund Status (Unexpired, Expired, Cancelled)	FM_FUND_STATUS	CHAR	1			FM_FUND_STATUS
BETC	Business Event Type Code	FMFG_BETC	CHAR	10			CHAR10
TP_BETC	Business Event Type Code for Trading Partner	FMFG_TP_BETC	CHAR	10
TREASURY_OFFSET	Treasury Offset Program Eligibility	FMFG_TREASURY_OFFSET	CHAR	1
GARNISHMENT	Garnishment	FMFG_GARNISHMENT	CHAR	1
PREPARERID	Preparer ID	FM_PREPARER	CHAR	8
CERTIFIERID	Certifier ID	FMFG_CERTIFIERID	CHAR	8
USERTEMP1	Derivation Rule Value	FMFGDRVALUE	CHAR	32			FMFGDRVALUE
USERTEMP2	Derivation Rule Value	FMFGDRVALUE	CHAR	32			FMFGDRVALUE
USERTEMP3	Derivation Rule Value	FMFGDRVALUE	CHAR	32			FMFGDRVALUE
BUDGET_PD_9	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
RYEAR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
PRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
CO_AREA	Controlling Area	KOKRS	CHAR	4	TKA01		CACCD	CAC
BLDAT	Document Date in Document	BLDAT	DATS	8			DATUM
BLART	Document Type	BLART	CHAR	2	T003		BLART	BAR
DRCRK	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG

Key field

Non-key field

< IUSFGFACTS2 - Fields for US Federal government FACTS2 IUSFGGTAS - Fields for US Federal Government GTAS >

How do I retrieve data from SAP structure IUSFGFDERIVE using ABAP code?

As IUSFGFDERIVE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on IUSFGFDERIVE as there is no data to select.

How to access SAP table IUSFGFDERIVE

Within an ECC or HANA version of SAP you can also view further information about IUSFGFDERIVE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).