FMFACTS2TBALV SAP (Trial Balance Structure for ALV) Structure details

Dictionary Type: Structure
Description: Trial Balance Structure for ALV




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




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

FMFACTS2TBALV 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 "Trial Balance Structure for ALV" 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_FMFACTS2TBALV TYPE FMFACTS2TBALV.

The FMFACTS2TBALV table consists of various fields, each holding specific information or linking keys about Trial Balance Structure for ALV data available in SAP. These include RFINUSE (Application of Secondary Source Funds), RFUND (Fund), SGL_ACCOUNT (Standard General Ledger Account for US Federal Government), RACCT (Account Number).. 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 FMFACTS2TBALV 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
RYEARFiscal year RYEARNUMC4GJAHRGJAHRGFY
RFINUSEApplication of Secondary Source Funds FM_FINUSECHAR16Assigned to domainFM_FINUSEFIU
RFUNDFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
SGL_ACCOUNTStandard General Ledger Account for US Federal Government FM_SGL_ACCOUNTCHAR6FM_SGL_ACCOUNTSGL_ACCOUNTFMFG_SGL_ACCOUNT
RACCTAccount Number RACCTCHAR10Assigned to domainALPHASAKNRACC
RFLG_AUTHORAuthority Type FM_FLG_AUTHORCHAR1FM_FLG_AUTHOR
RFLG_DEFINITEDefinite/Indef indicator FM_FLG_DEFINITECHAR1FM_FLG_DEFINITE
RLEGISType of Legislation FM_LEGISCHAR1FM_LEGIS
RPUBLAWPublic Law Cited FM_PUBLAWCHAR20FM_PUBLAW
RFLG_APPORTApportionment Category FM_FLG_APPORTCHAR1FM_FLG_APPORT
RFLG_REIMBURReimbursable FM_FLG_REIMBURCHAR1FM_FLG_REIMBUR
RFLG_AVAILAvailability Time FM_FLG_AVAILCHAR1FM_FLG_AVAIL
RFLG_PARTNERTransaction Partner FM_FLG_PARTNERCHAR1FM_FLG_PARTNER
RFLG_BORROWBorrowing Source FM_FLG_BORROWCHAR1FM_FLG_BORROW
RFLG_BEABudget Enforcement Act Category FM_FLG_BEACHAR1FM_FLG_BEA
RCOHORTReporting Year for Cohort FM_COHORTCHAR4FM_COHORT
HSLVTBalance carried forward in local currency HSLVT9CURR17(2) WERTV9
HSL01Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL02Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL03Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
RBUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
FM_AREAFinancial Management Area FIKRSCHAR4Assigned to domainFIKRSFIK
BUSABusiness Area GSBERCHAR4Assigned to domainGSBERGSB
FAREAFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
RFISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
MEASUREFunded Program FM_MEASURECHAR24Assigned to domainFM_MEASUREFM_MEASURE
BLSTATUS_9Budgetary ledger status FMFG_BLSTATUSCHAR5FMFG_BLSTATUSFMFG_BLSTATUS
FMFG_SUBKEY97_9Subkey for FMUSFGFACTS2T FMFG_SUBKEY97CHAR10CHAR10
TRADE_IDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
TRANSFER_AGCY_9Transfer Agency FMFG_TRANSFERCHAR2Assigned to domainFMFG_TRANSFERFM_TRANS_AGENCY
TRANSFER_ACCT_9Transfer Account FMFG_TRAN_ACCTCHAR4Assigned to domainFMFG_TRAN_ACCT
YEAR_BDGT_AUTH_9Year of Budget Authority FMFG_YR_BUD_AUTHCHAR4FMFG_YR_BUD_AUTH
FLG_ADVANCE_9Advanced Flag FMFG_FLG_ADVANCECHAR1FMFG_FLG_ADVANCE
DEFENSE_INDIC_9Defense Indicator FMFG_DEFENSE_INDICATORCHAR3FMFG_DEFENSE_INDICATOR
PROG_REPT_CAT_9Program Reporting Category (out) FMFG_PROG_REPT_CATCHAR3FMFG_PROGRAM_REPORT_CATEGORY
PROG_REPT_CAT_TXProgram Reporting Category Text FMFG_PROG_REPT_CAT_TEXCHAR25
BUDGET_PD_9FM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
FLG_PYAPrior Year Adjustment Code FMFG_FLG_PYACHAR1FMFG_FLG_PYA
APPOR_CAT_B_DETAILApportionment Category B Program Code FMFG_APPORTDTLCHAR4
APPOR_CAT_B_TXTApportionment Text FMFG_APPORTTEXTCHAR25

Key field Non-key field



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

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

How to access SAP table FMFACTS2TBALV

Within an ECC or HANA version of SAP you can also view further information about FMFACTS2TBALV 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!