FMCFSIF_TR SAP (Selected Open FI Documents (Settlement)) Table details

Dictionary Type: Table
Description: Selected Open FI Documents (Settlement)




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




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

FMCFSIF_TR is a standard SAP Table which is used to store Selected Open FI Documents (Settlement) data and is available within R/3 SAP systems depending on the version and release level.

The FMCFSIF_TR table consists of various fields, each holding specific information or linking keys about Selected Open FI Documents (Settlement) data available in SAP. These include FMBELNR (Document Number of FM Line Item), FIKRS (Financial Management Area), FMBUZEI (Number of a posting line in a TR-FM line item), RLDNR (Ledger).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP FMCFSIF_TR table 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
MANDTClient MANDTCLNT3T000MANDT
FMBELNRDocument Number of FM Line Item FM_BELNRCHAR10ALPHABELNR
FIKRSFinancial Management Area FIKRSCHAR4FM01FIKRSFIK
FMBUZEINumber of a posting line in a TR-FM line item FM_BUZEINUMC3NUMC03
RLDNRLedger RLDNRCHAR2Assigned to domainALPHARLDNRGLNH_T881
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
STUNRNumber that clearly identifies the line key in database FM_STUNRCHAR16CHAR16
XREALCheckbox XFELDCHAR1XFELD
TWAERTransaction Currency TWAERCUKY5Assigned to domainWAERSFWS
FKBTRBalance carried forward in local currency HSLVT9CURR17(2) WERTV9
TRBTRBalance carried forward in transaction currency TSLVT9CURR17(2) WERTV9
BUKRS_REFCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
GJAHR_REFFiscal year for FI document number FM_KNGJAHRNUMC4GJAHRGJAHRGJR
BELNR_REFFI document number FM_KNBELNRCHAR10ALPHABELNRBLN
BUZEI_REFDocument item for FI document number FM_KNBUZEINUMC3BUZEI
WRTTPValue Type CO_WRTTPCHAR2CO_WRTTP
CFSTATFM Commitment Carryforward: Status FM_CFSTNUMC2FM_CFST
CPUDTSELDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMSELTime of Entry CPUTMTIMS6UZEIT
UNAMESELUser Name UNAMECHAR12UNAME
CPUDTCFDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMCFTime of Entry CPUTMTIMS6UZEIT
UNAMECFUser Name UNAMECHAR12UNAME
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
FONDSFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
FIPEXCommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
FAREAFunctional Area FM_FAREACHAR16Assigned to domainFKBERFBE
FISTL_EFunds Center FISTLCHAR16Assigned to domainFISTLFIS
FONDS_EFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
FIPEX_ECommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
FAREA_EFunctional Area FM_FAREACHAR16Assigned to domainFKBERFBE
GJAHR_EReceiver year FM_CF_GJAHR_ENUMC4GJAHRGJAHRGJV
CFRULEFM carryforward rule (FYC) FM_CFRULECHAR10FM_CFRULECFR
FLG_ACCheckbox XFELDCHAR1XFELD
GNJHRYear of Cash Effectivity GNJHRNUMC4GJAHRGJAHRGNJHR
CFLEVCarryforward level FM_CFLEVCHAR1FM_CFLEV
STATSFunds Management Statistical Indicator FM_STATSCHAR1FM_STATS
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC

Key field Non-key field



How do I retrieve data from SAP table FMCFSIF_TR using ABAP code

The following ABAP code Example will allow you to do a basic selection on FMCFSIF_TR to SELECT all data from the table
DATA: WA_FMCFSIF_TR TYPE FMCFSIF_TR.

SELECT SINGLE *
FROM FMCFSIF_TR
INTO CORRESPONDING FIELDS OF WA_FMCFSIF_TR
WHERE...

How to access SAP table FMCFSIF_TR

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