1. SAP Tutorial
  2. FI Module

FMCFSIF_TR SAP table for – Selected Open FI Documents (Settlement)

Here we would like to draw your attention to FMCFSIF_TR table in SAP. As we know it is being mainly used with the SAP FI-FM (Funds Management in FI) component which is coming under FI module (Financial Accounting). FMCFSIF_TR is a SAP standard transp table used for storing Selected Open FI Documents (Settlement) related data in SAP. It comes under the package FMCF_CORE.

SAP FMCFSIF_TR table

Table FMCFSIF_TR technical data

TableFMCFSIF_TR
Data storingSelected Open FI Documents (Settlement)
ModuleFI
Sub ModuleFI-FM
SAP PackageFMCF_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FMCFSIF_TR Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMCFSIF_TR table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : FI – Key for Funds Management Actual Data
    Its a key field.
  • FMBELNR : Document Number of FM Line Item
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • FIKRS : Financial Management Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • FMBUZEI : Number of a posting line in a TR-FM line item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • RLDNR : Ledger
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • STUNR : Number that clearly identifies the line key in database
    Its a key field. Its data type is CHAR (Character String) with field length 16
  • XREAL : Checkbox
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • TWAER : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FKBTR : Balance carried forward in local currency
    Its data type is CURR (Currency Field) with field length 17
  • TRBTR : Balance carried forward in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • BUKRS_REF : Company Code
    Its data type is CHAR (Character String) with field length 4
  • GJAHR_REF : Fiscal year for FI document number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BELNR_REF : FI document number
    Its data type is CHAR (Character String) with field length 10
  • BUZEI_REF : Document item for FI document number
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • WRTTP : Value Type
    Its data type is CHAR (Character String) with field length 2
  • CFSTAT : FM Commitment Carryforward: Status
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • CPUDTSEL : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTMSEL : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • UNAMESEL : User Name
    Its data type is CHAR (Character String) with field length 12
  • CPUDTCF : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTMCF : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • UNAMECF : User Name
    Its data type is CHAR (Character String) with field length 12
  • FISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • FONDS : Fund
    Its data type is CHAR (Character String) with field length 10
  • FIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • FAREA : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • FISTL_E : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • FONDS_E : Fund
    Its data type is CHAR (Character String) with field length 10
  • FIPEX_E : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • FAREA_E : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • GJAHR_E : Receiver year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CFRULE : FM carryforward rule (FYC)
    Its data type is CHAR (Character String) with field length 10
  • FLG_AC : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • GNJHR : Year of Cash Effectivity
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CFLEV : Carryforward level
    Its data type is CHAR (Character String) with field length 1
  • STATS : Funds Management Statistical Indicator
    Its data type is CHAR (Character String) with field length 1
  • GRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20

    • FMCFSIF_TR related tables

    • FMCFSIO_TR : FI-FM: Selected Open Commitment Documents
    • FMCFB_VRGNGT : FM: Balance Carryfwd Allowed Activities (Language-Dependent)
    • FMCFAAS_TR : TR-FM: Commitments/Budget Carried Forward (Interim Storage)
    • FMFUNDSEL : FIFM: Selected Fund for Closing Operations
    • FMCFAB_TR : TR-FM: Commitments/Budget Carried Forward (Sender+Receiver)
    • FMCFABS_TR : TR-FM: Transferred Commitment/Budget (Senders+Receivers)
    • FMCFB_VRGNG : FM: Permitted Activities for Balance Carryforward
    • FMCFSIF_TR : Selected Open FI Documents (Settlement)
    • FMCFAA_TR : TR-FM: Commitments/Budget Carried Forward

    Related References

    Related Tutorials

    FMCFSIO_TR SAP table for – FI-FM: Selected Open Commitment Documents

    FMCFSIO_TR table in SAP FI (Funds Management in FI) module. This table is used for storing data of FI-FM: Selected...

    FMFUNDSEL SAP table for – FIFM: Selected Fund for Closing Operations

    FMFUNDSEL table in SAP FI (Funds Management in FI) module. This table is used for storing data of FIFM: Selected...

    FMIUR SAP table for – Open Interval Rules for updating FM

    FMIUR table in SAP FI (Funds Management in FI) module. This table is used for storing data of Open Interval...

    FAGL_R_OI_TRACK1 SAP table for – Reorganization: Included Documents for Open Items

    FAGL_R_OI_TRACK1 table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Reorganization:...

    FMIOI SAP table for – Commitment Documents Funds Management

    FMIOI table in SAP FI (Funds Management in FI) module. This table is used for storing data of Commitment Documents...

    KBLPS SAP table for – Earmarked Funds: Value Adjustment Documents

    KBLPS table in SAP FI (Funds Management in FI) module. This table is used for storing data of Earmarked Funds:...

    FMRC07 SAP table for – Results List Documents Bank/Clearing Account Matching FM-FI

    FMRC07 table in SAP FI (Funds Management in FI) module. This table is used for storing data of Results List...

    «
    »