TIVXCMSSCHEME SAP table for – Settlement Schema

Here we would like to draw your attention to TIVXCMSSCHEME table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). TIVXCMSSCHEME is a SAP standard transp table used for storing Settlement Schema related data in SAP. It comes under the package RE_XC_RA_MS.

SAP TIVXCMSSCHEME table

Table TIVXCMSSCHEME technical data

TableTIVXCMSSCHEME
Data storingSettlement Schema
ModuleRE
Sub ModuleRE-FX
SAP PackageRE_XC_RA_MS
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-FIN
Table CategoryTRANSP

SAP TIVXCMSSCHEME 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 TIVXCMSSCHEME table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SCHEME : Settlement Schema
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • CALCYEARFROM : From Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CALCYEARTO : To Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ISEXTERN : Settlement Schema Is Used in the Application
    Its data type is CHAR (Character String) with field length 1
  • DELETED : Deletion Indicator: OBSOLETE
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Field String for Maintenance of User Data
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10