IFMFG_TB_ALV SAP (US Federal: Trial Balance report ALV structure) Structure details

Dictionary Type: Structure
Description: US Federal: Trial Balance report ALV structure




ABAP Code to SELECT data from IFMFG_TB_ALV
Related tables to IFMFG_TB_ALV
Access table IFMFG_TB_ALV




Structure field list including key, data, relationships and ABAP select examples

IFMFG_TB_ALV 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 "US Federal: Trial Balance report ALV structure" 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_IFMFG_TB_ALV TYPE IFMFG_TB_ALV.

The IFMFG_TB_ALV table consists of various fields, each holding specific information or linking keys about US Federal: Trial Balance report ALV structure data available in SAP. These include RYEAR (Fiscal Year), RBUSA (Business Area), SUBLEVL (Sublevel Prefix (SP)), ALTRAID (Allocation Transfer Agency Identifier (ATA)).. 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. .

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


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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
RBUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
RYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
RBUSABusiness Area GSBERCHAR4Assigned to domainGSBERGSB
SUBLEVLSublevel Prefix (SP) FMFG_SUBLEVLCHAR2FMFG_SUBLEVL
ALTRAIDAllocation Transfer Agency Identifier (ATA) FMFG_ALTRAIDCHAR3FMFG_ALTRAID
AGENCIDAgency Identifier (AID) FMFG_AGENCIDCHAR3FMFG_AGENCID
BEGPERBeginning Period of Availability (BPOA) FMFG_BEGPERNUMC4GJAHRFMFG_BEGPER
ENDPEREnding Period of Availability (EPOA) FMFG_ENDPERNUMC4GJAHRFMFG_ENDPER
AVTYPEAvailability Type Code (A) FMFG_AVTYPECHAR1FMFG_AVTYPE
FUND_ACC_SYMBLTreasury Account Symbol - Main Account FM_MAIN_ACCTCHAR4FM_MAIN_ACCT
SUB_ACCTTreasury Account Symbol - Subaccount FM_SUB_ACCTCHAR3FM_SUB_ACCT
SGL_ACCOUNTStandard General Ledger Account for US Federal Government FM_SGL_ACCOUNTCHAR6FM_SGL_ACCOUNTSGL_ACCOUNTFMFG_SGL_ACCOUNT
RACCTAccount Number RACCTCHAR10Assigned to domainALPHASAKNRACC
BEG_AMOUNTBeginning Balance Amount FMFG_BEG_AMOUNTCURR17(2) WERTV9
DR_AMOUNTDebit Amount FMFG_DR_AMOUNTCURR17(2) WERTV9
CR_AMOUNTCredit Amount FMFG_CR_AMOUNTCURR17(2) WERTV9
END_AMOUNTEnding Balance Amount FMFG_END_AMOUNTCURR17(2) WERTV9
RTCURCurrency Key RTCURCUKY5Assigned to domainWAERSFWS
FLG_AUTHORAuthority Type FM_FLG_AUTHORCHAR1FM_FLG_AUTHOR
FLG_REIMBURReimbursable FM_FLG_REIMBURCHAR1FM_FLG_REIMBUR
FLG_APPORTApportionment Category FM_FLG_APPORTCHAR1FM_FLG_APPORT
APPOR_CATB_DTL_9Apportionment Category B Program Code FMFG_APPORTDTLCHAR4
PROG_REPT_CATProgram Reporting Category FMFG_PROGRAM_REPORT_CATEGORYCHAR3FMFG_PROGRAM_REPORT_CATEGORY
FLG_FEDERALFederal/Nonfederal Code FM_FLG_FEDERALCHAR1FM_FLG_FEDERAL
TP_AGENCIDAgency Identifier (AID) for Trading Partner FMFG_TP_AGENCIDCHAR3FMFG_AGENCID
TP_MAIN_ACCTMain Account for Trading Partner FMFG_TP_MAIN_ACCTCHAR4
YEAR_BDGT_AUTH_9Year of Budget Authority FMFG_YR_BUD_AUTHCHAR4FMFG_YR_BUD_AUTH
FLG_AVAILAvailability Time FM_FLG_AVAILCHAR1FM_FLG_AVAIL
FLG_BEABudget Enforcement Act Category FM_FLG_BEACHAR1FM_FLG_BEA
FLG_BORROWBorrowing Source FM_FLG_BORROWCHAR1FM_FLG_BORROW
FLG_EXCHANGEExchange Indicator FM_FLG_EXCHANGECHAR1FM_FLG_EXCHANGE
FLG_CUSTODIALCustodial Indicator FM_FLG_CUSTODIALCHAR1FM_FLG_CUSTODIAL
FLG_ENTITYEntity Indicator FM_FLG_ENTITYCHAR1FM_FLG_ENTITY
BDGT_IMPACTBudgetary Impact FMFG_BDGT_IMPACTCHAR1FMFG_BDGT_IMPACT
FLG_PYAPrior Year Adjustment Code FMFG_FLG_PYACHAR1FMFG_FLG_PYA
COHORTReporting Year for Cohort FM_COHORTCHAR4FM_COHORT
PROGRAM_INDProgram FMFG_PROGRAM_INDCHAR1FMFG_PROGRAM_IND
BETCBusiness Event Type Code FMFG_BETCCHAR10CHAR10
RFUNDFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
BUDGET_PD_9FM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
RFINUSEApplication of Secondary Source Funds FM_FINUSECHAR16Assigned to domainFM_FINUSEFIU
FUND_TYPEFM Fund Type FM_FUNDTYPECHAR6Assigned to domainFM_FUNDTYPE
RFAREAFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
MEASUREFunded Program FM_MEASURECHAR24Assigned to domainFM_MEASUREFM_MEASURE
RFIPEXCommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
RFISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
RPRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
RCNTRCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
RPROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
RORDNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
RVBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
RAGNCY_LCTN_CODEAgency Location Code FMFG_ALCCHAR8Assigned to domainFMFG_ALCFMFG_ALC
BLSTATUS_9Budgetary ledger status FMFG_BLSTATUSCHAR5FMFG_BLSTATUSFMFG_BLSTATUS
FM_AREAFinancial Management Area FIKRSCHAR4Assigned to domainFIKRSFIK
CO_AREAControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
FLG_COVEREDCovered Indicator FM_FLG_COVEREDCHAR1FM_FLG_COVERED
BUREAUFederal Bureau FM_BUREAUCHAR2FM_BUREAU
BUSINESS_LINEBusiness Line FM_BUSINESS_LINECHAR2FM_BUSINESS_LINE
FGDPRTMNTFederal Department FM_DEPARTMENTCHAR2FM_DEPARTMENT
FGDPRTMNT_PARTFederal Department Partner FM_DEPARTMENT_PARTNERCHAR2FM_DEPARTMENT
FLG_DEFINITEDefinite/Indef indicator FM_FLG_DEFINITECHAR1FM_FLG_DEFINITE
FLG_PARTNERTransaction Partner FM_FLG_PARTNERCHAR1FM_FLG_PARTNER
LEGISType of Legislation FM_LEGISCHAR1FM_LEGIS
PUBLAWPublic Law Cited FM_PUBLAWCHAR20FM_PUBLAW
TRANSFER_AGCY_9Transfer Agency FMFG_TRANSFER_AGCYCHAR2Assigned to domainFMFG_TRANSFER
TRANSFER_ACCT_9Transfer Account FMFG_TRANSFER_ACCTCHAR4Assigned to domainFMFG_TRAN_ACCT
FLG_ADVANCE_9Advanced Flag FM_FLG_ADVANCECHAR1FMFG_FLG_ADVANCE
DEFENSE_INDIC_9Defense Indicator FMFG_DEFENSE_INDICATORCHAR3FMFG_DEFENSE_INDICATOR
FMFG_SUBKEY_9Subkey for FMUSFGT FMFG_SUBKEYCHAR10CHAR10

Key field Non-key field



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

As IFMFG_TB_ALV 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 IFMFG_TB_ALV as there is no data to select.

How to access SAP table IFMFG_TB_ALV

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!