1. SAP Tutorial
  2. FI Module

PCRRETAILT SAP table for – Totals Table

Here we would like to draw your attention to PCRRETAILT table in SAP. As we know it is being mainly used with the SAP FI-RL (Retail Ledger in FI) component which is coming under FI module (Financial Accounting). PCRRETAILT is a SAP standard transp table used for storing Totals Table related data in SAP. It comes under the package WRTL.

SAP PCRRETAILT table

Table PCRRETAILT technical data

TablePCRRETAILT
Data storingTotals Table
ModuleFI
Sub ModuleFI-RL
SAP PackageWRTL
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • RCLNT : 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
  • RRCTY : Record Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its a key field. Its data type is CHAR (Character String) 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
  • ROBJNR : Object number for objects (account assignment elements)
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • COBJNR : Object number for transaction attributes
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • SOBJNR : Object number for partner objects (accnt assignmnt elements)
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RTCUR : Currency Key
    Its a key field. Its data type is CUKY (Currency key for a currency field) with field length 5
  • RUNIT : Base Unit of Measure
    Its a key field. Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • 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
  • RBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RACCT : Account Number
    Its data type is CHAR (Character String) with field length 10
  • RPRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • RCNTR : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • RFAREA : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • RASAREA_7 : Assortment Area
    Its data type is CHAR (Character String) with field length 18
  • RWBSE_7 : Work Breakdown Structure Element (WBS Element)
    Its data type is CHAR (Character String) with field length 24
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • KOKRS : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • STAGR : Statistical key figure
    Its data type is CHAR (Character String) with field length 6
  • 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
  • KSLVT : Balance carried forward in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL01 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL02 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL03 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL04 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL05 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL06 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL07 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL08 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL09 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL10 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL11 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL12 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL13 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL14 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL15 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL16 : Total of transactions of the period in group 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
  • ASLVT : Balance carried forward of additional quantity
    Its data type is QUAN (Quantity field) with field length 15
  • ASL01 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL02 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL03 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL04 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL05 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL06 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL07 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL08 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL09 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL10 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL11 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL12 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL13 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL14 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL15 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • ASL16 : Total of transactions of period in additional quantities
    Its data type is QUAN (Quantity field) with field length 15
  • AUNIT : Additional unit of measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • CSPRED : Distribution key for currency amounts
    Its data type is CHAR (Character String) with field length 4
  • QSPRED : Distribution key for quantities
    Its data type is CHAR (Character String) with field length 4

    • PCRRETAILT related tables

    • PCRR_AS_AREAT : Check table for PCRRETAILT: Assortment Area RASAREA_7
    • PCRRETAILP : Plan line items table
    • PCRRETAILO : Object Table 1
    • PCRR_AS_AREA : Check table for PCRRETAILT: Assortment Area RASAREA_7
    • PCRRETAILT : Totals Table
    • PCRRETAILC : Object Table 2
    • PCRRETAILA : Actual line item table

    PCRRETAILT related transaction codes under SAP package WRTL

    • RTDE : Retail Ledger: Del. Transaction Data
    • RETAIL_TOTALS : Retail Ledger:Display Totals Records
    • RETAIL_GVTR : Balance C/F Retail Ledger
    • RETAIL_BLOCK : Retail Ledger: Block Company Codes
    • RETAIL_GB01 : Retail Ledger: Post Document
    • RETAIL_VERSIONS : Retail Ledger: Block Company Codes
    • RETAIL_GCU1 : Retail Ledger: Transfer Data from FI
    • RETAIL_GCU6 : Retail Ledger: Transfer CO Plan Data
    • RETAIL_GCU3 : Retail Ledger: Transfer CO Act. Data
    • RETAIL_SUBPOST : Retail Ledger: Allow Subsequent Post
    • RETAIL_ITEMS : Line Items Retail Ledger
    • RETAIL_ACTIVATE : Retail Ledger: Activation

    Related References

    Related Tutorials

    GLT2 SAP table for – Consolidation totals table

    GLT2 table in SAP FI (Consolidation in FI) module. This table is used for storing data of Consolidation totals table....

    FILCT SAP table for – FI-LC: Global totals table with 2 object tables

    FILCT table in SAP FI (Consolidation in FI) module. This table is used for storing data of FI-LC: Global totals...

    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/PROFTAXT SAP table for – Totals Table for General Ledger

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

    GLFLEXT SAP table for – Flexible G/L: Totals

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

    PCRRETAILP SAP table for – Plan line items table

    PCRRETAILP table in SAP FI (Retail Ledger in FI) module. This table is used for storing data of Plan line...

    «
    »