1. SAP Tutorial
  2. FI Module

PCRRETAILA SAP table for – Actual line item table

Here we would like to draw your attention to PCRRETAILA 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). PCRRETAILA is a SAP standard transp table used for storing Actual line item table related data in SAP. It comes under the package WRTL.

SAP PCRRETAILA table

Table PCRRETAILA technical data

TablePCRRETAILA
Data storingActual line item table
ModuleFI
Sub ModuleFI-RL
SAP PackageWRTL
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP PCRRETAILA 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 PCRRETAILA 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
  • POPER : Posting 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
  • 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
  • TSL : Value in Transaction Currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL : Value in local currency
    Its data type is CURR (Currency Field) with field length 17
  • KSL : Value in group currency
    Its data type is CURR (Currency Field) with field length 17
  • MSL : Quantity
    Its data type is QUAN (Quantity field) with field length 15
  • ASL : Additional Quantity
    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
  • 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 : Reference document number of an accounting document
    Its data type is CHAR (Character String) with field length 10
  • REFRYEAR : Reference fiscal year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REFDOCLN : Six-digit number of the reference posting line
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • REFDOCCT : Reference document category
    Its data type is CHAR (Character String) with field length 1
  • REFACTIV : FI-SL Business Reference 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

    • PCRRETAILA related tables

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

    PCRRETAILA related transaction codes under SAP package WRTL

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

    Related References

    Related Tutorials

    /CCIS/PBU18A SAP table for – PBU18: Actual line item table

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

    FMIA SAP table for – Actual Line Item Table for Funds Management

    FMIA table in SAP FI (Funds Management in FI) module. This table is used for storing data of Actual Line...

    J_3RFTAXRVA SAP table for – Tax Accounting: Actual line item table

    J_3RFTAXRVA table in SAP FI (Localization in FI) module. This table is used for storing data of Tax Accounting: Actual...

    J_3RFTAXRA SAP table for – Tax Accounting: Actual line item table

    J_3RFTAXRA table in SAP FI (Localization in FI) module. This table is used for storing data of Tax Accounting: Actual...

    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...

    FAGLFLEXA SAP table for – General Ledger: Actual Line Items

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

    GLFLEXA SAP table for – Flexible general ledger: Actual line items

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

    «
    »