/CCIS/PROFTAXA SAP table for – Actual Line Items Table for General Ledger

Here we would like to draw your attention to /CCIS/PROFTAXA table in SAP. As we know it is being mainly used with the SAP FI-SL (Special Purpose Ledger in FI) component which is coming under FI module (Financial Accounting). /CCIS/PROFTAXA is a SAP standard transp table used for storing Actual Line Items Table for General Ledger related data in SAP. It comes under the package /CCIS/TAX.

SAP /CCIS/PROFTAXA table

Table /CCIS/PROFTAXA technical data

Table/CCIS/PROFTAXA
Data storingActual Line Items Table for General Ledger
ModuleFI
Sub ModuleFI-SL
SAP Package/CCIS/TAX
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP /CCIS/PROFTAXA 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 /CCIS/PROFTAXA table.

  • RCLNT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RYEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • DOCNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : General ledger: Technical fields
    Its a key field.
  • RLDNR : Ledger in General Ledger Accounting
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : General ledger: SAP additional account assignment
    Its a key field.
  • RBUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • DOCLN : Six-Character Posting Item for Ledger
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : General ledger: Transaction attributes
  • ACTIV : FI-SL Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • RMVCT : Transaction type
    Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : RTCUR + RUNIT
  • 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
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • .INCLUDE : General ledger: Technical fields
  • 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
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : General ledger: Main account assignment
  • RACCT : Account Number
    Its data type is CHAR (Character String) with field length 10
  • COST_ELEM : Cost Element
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : General ledger: SAP additional account assignment
  • 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
  • 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 : Division Number
    Its data type is CHAR (Character String) with field length 5
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : General ledger: Sender SAP additional account assignment
  • 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
  • .INCLUDE : Value Fields of GL Line Items Table
  • TSL : Value in Transaction Currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL : Value in Local Currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL : Value in Group Currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL : Value in Another Currency
    Its data type is CURR (Currency Field) with field length 23
  • MSL : Quantity
    Its data type is QUAN (Quantity field) with field length 23
  • WSL : Value in Original Transaction Currency (Document Currency)
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : Mandatory Fields of a GL Actual Line Item Table
  • DRCRK : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • POPER : Posting period
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RWCUR : Currency key of the original transaction currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • GJAHR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BELNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • BSCHL : Posting Key
    Its data type is CHAR (Character String) with field length 2
  • BSTAT : Document Status
    Its data type is CHAR (Character String) with field length 1
  • LINETYPE : Item category
    Its data type is CHAR (Character String) with field length 5
  • XSPLITMOD : Item changed by document splitting
    Its data type is CHAR (Character String) with field length 1
  • USNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes