J_3RFTAXRP SAP table for – Tax Accounting: Plan line item table

Here we would like to draw your attention to J_3RFTAXRP table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). J_3RFTAXRP is a SAP standard transp table used for storing Tax Accounting: Plan line item table related data in SAP. It comes under the package J3RF.

SAP J_3RFTAXRP table

Table J_3RFTAXRP technical data

TableJ_3RFTAXRP
Data storingTax Accounting: Plan line item table
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RF
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

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

  • RCLNT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GL_SIRID : Record number of the line item record
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RLDNR : Ledger
    Its data type is CHAR (Character String) with field length 2
  • RRCTY : Record Type
    Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its data type is CHAR (Character String) with field length 3
  • RYEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • RTCUR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RUNIT : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DRCRK : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • RPMAX : Period
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DOCCT : Document Type
    Its data type is CHAR (Character String) with field length 1
  • DOCNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • DOCLN : Six-Character Posting Item for Ledger
    Its data type is CHAR (Character String) with field length 6
  • RBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RTAXOBJ : Tax Object
    Its data type is CHAR (Character String) with field length 21
  • REXPTYPE : Type of Expenses
    Its data type is CHAR (Character String) with field length 1
  • RACTIVTYP : Activity Type
    Its data type is CHAR (Character String) with field length 10
  • RACCT : Account Number
    Its data type is CHAR (Character String) with field length 10
  • RMATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • RMATKL : Material Group
    Its data type is CHAR (Character String) with field length 9
  • RPRODUCT : Product type
    Its data type is CHAR (Character String) with field length 18
  • RANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • RANLN2 : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4
  • RTAXREG : Tax Register Code
    Its data type is CHAR (Character String) with field length 10
  • RTAXROW : Tax Return Row Number
    Its data type is CHAR (Character String) with field length 17
  • RCONTRACT : Contract Number
    Its data type is CHAR (Character String) with field length 18
  • RKTRLAGT : Customer number
    Its data type is CHAR (Character String) with field length 10
  • RDIVISION : Sending Division Number
    Its data type is CHAR (Character String) with field length 5
  • SBUKRS : Company code of partner
    Its data type is CHAR (Character String) with field length 4
  • STAXOBJ : Sending Tax Object
    Its data type is CHAR (Character String) with field length 21
  • SEXPTYPE : Sending Expenses Type
    Its data type is CHAR (Character String) with field length 1
  • SACTIVTYP : Sending Activity Type
    Its data type is CHAR (Character String) with field length 10
  • SACCT : Account number
    Its data type is CHAR (Character String) with field length 10
  • SMATKL : Material group
    Its data type is CHAR (Character String) with field length 9
  • SPRODUCT : Sender product type
    Its data type is CHAR (Character String) with field length 18
  • SCONTRACT : Sending Contract Number
    Its data type is CHAR (Character String) with field length 18
  • SKTRLAGT : Sending Customer number
    Its data type is CHAR (Character String) with field length 10
  • SDIVISION : Sending Division Number
    Its data type is CHAR (Character String) with field length 5
  • TSLVT : Balance carried forward in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL01 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL02 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL03 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL04 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL05 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL06 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL07 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL08 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL09 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL10 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL11 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL12 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL13 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL14 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL15 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TSL16 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • HSLVT : Balance carried forward in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL01 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL02 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL03 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL04 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL05 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL06 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL07 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL08 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL09 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL10 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL11 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL12 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL13 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL14 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL15 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL16 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 17
  • MSLVT : Balance carried forward of quantity
    Its data type is QUAN (Quantity field) with field length 15
  • MSL01 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL02 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL03 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL04 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL05 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL06 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL07 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL08 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL09 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL10 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL11 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL12 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL13 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL14 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL15 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • MSL16 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 15
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • DOCTY : FI-SL Document Type
    Its data type is CHAR (Character String) with field length 2
  • ACTIV : Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WSDAT : Value Date for Currency Translation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REFDOCNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • REFRYEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REFDOCLN : Six-figure number of line item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • REFDOCCT : Document Type
    Its data type is CHAR (Character String) with field length 1
  • REFACTIV : Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • CPUDT : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • USNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWORG : Reference organisational units
    Its data type is CHAR (Character String) with field length 10
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • [ FREE ] SUBSCRIBE
    RECEIVE UPDATES & SAP ARTICLES RIGHT IN YOUR INBOX.