1. SAP Tutorial
  2. FI Module

/CCIS/PROFTAXT SAP table for – Totals Table for General Ledger

Here we would like to draw your attention to /CCIS/PROFTAXT 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/PROFTAXT is a SAP standard transp table used for storing Totals Table for General Ledger related data in SAP. It comes under the package /CCIS/TAX.

SAP /CCIS/PROFTAXT table

Table /CCIS/PROFTAXT technical data

Table/CCIS/PROFTAXT
Data storingTotals 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/PROFTAXT 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/PROFTAXT 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
  • OBJNR00 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR01 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR02 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR03 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR04 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR05 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR06 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR07 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR08 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DRCRK : Debit/Credit Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RPMAX : Period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .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
  • .INCLUDE : General ledger: Technical fields
  • RLDNR : Ledger in General Ledger Accounting
    Its data type is CHAR (Character String) with field length 2
  • .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
  • .INCLUDE : General ledger: SAP additional account assignment
  • RBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • .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 : Data Fields of a GL Totals Table
  • .INCLUDE : Field Group TSL
  • TSLVT : Balance carried forward in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL01 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL02 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL03 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL04 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL05 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL06 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL07 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL08 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL09 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL10 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL11 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL12 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL13 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL14 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL15 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL16 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : Field Group HSL
  • HSLVT : Balance carried forward in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL01 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL02 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL03 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL04 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL05 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL06 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL07 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL08 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL09 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL10 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL11 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL12 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL13 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL14 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL15 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL16 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : Field Group KSL
  • KSLVT : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL01 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL02 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL03 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL04 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL05 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL06 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL07 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL08 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL09 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL10 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL11 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL12 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL13 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL14 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL15 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL16 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : Field Group OSL
  • OSLVT : Balance carried forward in fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL01 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL02 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL03 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL04 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL05 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL06 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL07 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL08 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL09 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL10 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL11 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL12 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL13 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL14 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL15 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL16 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : Field Group MSL
  • MSLVT : Balance carried forward of quantity
    Its data type is QUAN (Quantity field) with field length 23
  • MSL01 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL02 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL03 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL04 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL05 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL06 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL07 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL08 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL09 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL10 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL11 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL12 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL13 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL14 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL15 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL16 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • .INCLUDE : Additional Data Fields of a G/L Totals Table
  • 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

    • /CCIS/PROFTAXT related tables

    • /CCIS/PROFTAX07 : Object Table Number:07
    • /CCIS/PROFTAXA : Actual Line Items Table for General Ledger
    • /CCIS/PBU18P : PBU18: Plan line item table
    • /CCIS/PROFTAX05 : Object Table Number:05
    • /CCIS/PROFTAX01 : Object Table Number:01
    • /CCIS/PROFTAX03 : Object Table Number:03
    • /CCIS/PROFTAXP : Plan Line Items Table for General Ledger
    • /CCIS/PROFTAX04 : Object Table Number:04
    • /CCIS/PROFTAX06 : Object Table Number:06
    • /CCIS/PBU18O : PBU18: Object table
    • /CCIS/PBU18C : PBU18: Object table 2
    • /CCIS/PROFTAX08 : Object Table Number:08
    • /CCIS/PROFTAX00 : Object Table Number:00
    • /CCIS/PROFTAXT : Totals Table for General Ledger
    • /CCIS/PROFTAX02 : Object Table Number:02
    • /CCIS/PBU18T : PBU18: Summary table x
    • /CCIS/PBU18A : PBU18: Actual line item table

    Related References

    Related Tutorials

    /CCIS/PROFTAXP SAP table for – Plan Line Items Table for General Ledger

    /CCIS/PROFTAXP table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of Plan...

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

    /CCIS/PROFTAXA table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of Actual...

    FAGLFLEXT SAP table for – General Ledger: Totals

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

    FAGLFLEXT_BAK SAP table for – General Ledger: Totals

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

    /CCIS/PBU18T SAP table for – PBU18: Summary table x

    /CCIS/PBU18T table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of PBU18:...

    /CCIS/PBU18P SAP table for – PBU18: Plan line item table

    /CCIS/PBU18P table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of PBU18:...

    FAGLFLEXP SAP table for – General Ledger: Plan Line Items

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

    «
    »