1. SAP Tutorial
  2. FI Module

J_3RF_BK_TOTALSQ SAP table for – Incoming Totals for Add. Sheets of S/ P Ledgers by Qarters

Here we would like to draw your attention to J_3RF_BK_TOTALSQ 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_3RF_BK_TOTALSQ is a SAP standard transp table used for storing Incoming Totals for Add. Sheets of S/ P Ledgers by Qarters related data in SAP. It comes under the package J3RF.

SAP J_3RF_BK_TOTALSQ table

Table J_3RF_BK_TOTALSQ technical data

TableJ_3RF_BK_TOTALSQ
Data storingIncoming Totals for Add. Sheets of S/ P Ledgers by Qarters
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RF
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_3RF_BK_TOTALSQ 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_3RF_BK_TOTALSQ table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • TYPE_BK : Indicator: Sales or Purchase Ledger
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • GJAHR_BAS : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • MONAT_BAS : Fiscal period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • GJAHR_ADD : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • MONAT_ADD : Fiscal period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DMBTR_TRN : Amount in company code currency
    Its data type is CURR (Currency Field) with field length 15
  • DMBTR_PAY : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • DMBTR_INV : Amount in company code currency
    Its data type is CURR (Currency Field) with field length 15
  • HWBAS_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWBAS2_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWBAS3_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWBAS4_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWBAS5_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWSTE_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWSTE2_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWSTE3_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWSTE4_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWSTE5_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15

    • J_3RF_BK_TOTALSQ related tables

    • J_3RF_CORR_INV : Define Correction Invoices (Russia)
    • J_3RF_REGCUS_REV : Customizing for Reversals for Invoice Registration Journal
    • J_3RFBS_EXCODES : Exteranl codes for FSV-items
    • J_3RT095B : Additional accounts for revaluation
    • J_3RFBS_XMLDEL : Balance sheet forms: XML-tags to be removed
    • J_3RFPRTEXEMP : Exemption codes from property tax payment
    • J_3RF_TP_BSEGORI : Items of Original documents
    • J_3RF_SALE_BOOK : Purchase book line number for sale book position
    • J_3RF_TP_SCRMAT : Materials list for selection group
    • J_3RFSD_RATE_CLC : Enable Down Payments in FC Function for SD Billing Documents
    • J_3RNKS_TBSL : Credit memo posting keys for AuC
    • J_3RF_T052S : Terms of Payment for Splitting by Goods Shelf Life
    • J_3RFPTREGIONT : Regions and districts for property tax
    • J_3RFBS_XMLDELT : Balance sheet forms: XML-tags to be removed:Text table
    • J_3RF_BK_TOTALSQ : Incoming Totals for Add. Sheets of S/ P Ledgers by Qarters
    • J_3RFPROPTYPEST : Property types
    • J_3RF_OPERTYP : Assignment of Operation Type Codes to Tax Codes
    • J_3R0 : Payment with correspondent account
    • J_3RF_TP_PM : Transfer pricing table for pricing method codes
    • J_3RTSE_AUXILIAR : Auxiliary index table for BSEG/TSE

    J_3RF_BK_TOTALSQ related transaction codes under SAP package J3RF

    • J3RFOCCODE : Assign Electronic IDs to Operators
    • J3RFTPTRANPCV : Transaction participant codes
    • J3RFBALANCE : Balance Sheet Key Figures (Russia)
    • J3RTSEAUXILIAV : Links between FI and SD/MM items
    • J3RFDEPRBONUS : Depreciation Bonus Calculation
    • J3RFTRPRDOC : Transfer Pricing Document Types
    • J3RFPURB : Purchase Ledger (Russia)
    • V_J_3RFREGINVOUT : Register Outgoing Invoices
    • J3RFKSLD : Vendor Turnover Balance Sheet
    • J3RTSEMAINT : Secondary Events Table Maintenance
    • J3RFINVOFFLINK : Match Incoming E-Invoices with FI
    • J3RFREGINVK : Vendor Invoice Journal (Russia)
    • J3RFCNT : Maintain Internal Contract Numbers
    • J3RFFCHA : Changes in Equity, Explanations
    • J3RALFINV17 : Act of inventory of vend/cust debts
    • J3RFPVEND : Assign Electronic IDs to Vendors
    • S_EBS_44000512 : Goods Import Declaration (Customs Un
    • J3RFF3S2 : Changes in Equity, Explanations
    • J3RFUM26 : Secondary Events (Russia)
    • J3RFDSLD : Customer Turnover Balance Sheet

    Related References

    Related Tutorials

    J_3RF_BK_TOTALS SAP table for – Incoming Totals for Add. Sheets of Sales/ Purchase Ledgers

    J_3RF_BK_TOTALS table in SAP FI (Localization in FI) module. This table is used for storing data of Incoming Totals for...

    J_1AWITH SAP table for – Withholding transaction data

    J_1AWITH table in SAP FI (Localization in FI) module. This table is used for storing data of Withholding transaction data....

    RFUMSV00_HIST SAP table for – Maintain data for previous VAT return run

    RFUMSV00_HIST table in SAP FI (Localization in FI) module. This table is used for storing data of Maintain data for...

    IDWT_EMPDATA_VE SAP table for – To store the employee data for Venezuela payroll

    IDWT_EMPDATA_VE table in SAP FI (Localization in FI) module. This table is used for storing data of To store the...

    BSEG_ADD SAP table for – Entry View of Accounting Document for Additional Ledgers

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

    FMIT SAP table for – Totals Table for Funds Management

    FMIT table in SAP FI (Funds Management in FI) module. This table is used for storing data of Totals Table...

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

    «
    »