T851 SAP table for – Changes in Investments

Here we would like to draw your attention to T851 table in SAP. As we know it is being mainly used with the SAP FI-LC (Consolidation in FI) component which is coming under FI module (Financial Accounting). T851 is a SAP standard transp table used for storing Changes in Investments related data in SAP. It comes under the package FKUC.

SAP T851 table

Table T851 technical data

TableT851
Data storingChanges in Investments
ModuleFI
Sub ModuleFI-LC-LC
SAP PackageFKUC
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RLDNR : Ledger
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • RVERS : Version for changes in investments
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • RCOMP : Investor
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • RASSC : Investee
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • RYEAR : Fiscal year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • PERID : Period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • SEQNR : Sequence number (2-digit)
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • ITEM : Investment item
    Its data type is CHAR (Character String) with field length 10
  • RMVCT : Transaction type: Investments
    Its data type is CHAR (Character String) with field length 3
  • UCOMP : Company for transfer posting
    Its data type is CHAR (Character String) with field length 6
  • VALDB : Indicator: Read value from database
    Its data type is CHAR (Character String) with field length 1
  • TXT : Description of activity
    Its data type is CHAR (Character String) with field length 30
  • SIGN : Sign indicating changes in investment
    Its data type is CHAR (Character String) with field length 1
  • CHAHO : Change in investment percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • BKVLC : Investment book value in local currency
    Its data type is CURR (Currency Field) with field length 15
  • EXTYP : Exchange rate indicator
    Its data type is CHAR (Character String) with field length 1
  • EXCHA : Exchange rate
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • IQERT : Exchange rate entered at indirect quotation
    Its data type is CHAR (Character String) with field length 1
  • BKVRC : Investment book value in group currency
    Its data type is CURR (Currency Field) with field length 15
  • PCNT1 : Change in investment share
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PCNT2 : Change in investment (w/voting rights)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PCNT3 : Change in investment (w/o voting rights)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PCNT4 : Change in investment (retained)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • KZ_PCNT : Indicator: Deviating shares
    Its data type is CHAR (Character String) with field length 1
  • NV2LC : Par book value – voting
    Its data type is CURR (Currency Field) with field length 15
  • NV3LC : Par book value w/o voting rights
    Its data type is CURR (Currency Field) with field length 15
  • KZCON : Indicator: Control
    Its data type is CHAR (Character String) with field length 1
  • RLEVL : Posting level
    Its data type is CHAR (Character String) with field length 1