1. SAP Tutorial
  2. FI Module

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

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

SAP J_3RF_BK_TOTALS table

Table J_3RF_BK_TOTALS technical data

TableJ_3RF_BK_TOTALS
Data storingIncoming Totals for Add. Sheets of Sales/ Purchase Ledgers
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RF
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_3RF_BK_TOTALS 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_TOTALS 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_TOTALS related tables

    • J_3RDOPDEB : Secondary index table for VAT
    • J_3RFPRTXAMTR : Property tax amount reduction
    • J_3RFREGCUSEDI : VAT Invoice Journal: Entry Protection
    • J_3RF_TP_GROUPT : Transfer pricing groups definition table
    • J_3RFDEPRGROUPT : Depreciation gropus descriptions of fixed asset Russia
    • J_3RF_ATTRTYP_TT : Attribute types text table
    • J_3RFOKATOT : Classifier of the administrative and territorial division
    • J_3RF_WW_AREA : Depreciation area for Working wear
    • J_3RFPRTXPRIVT : Property tax priviliges
    • J_3RF_TP_LIQCTT : Transfer pricing text table for company liquidation codes
    • J_3RF_DI_PVENDN : Assign Electronic ID to Vendor
    • J_3RF_TAXPERNT : Tax period names text customizing CIS
    • J_3RF_SURP_SW : Customizing for surplus price switching
    • J_3RFDI_DEADLINE : Deadline for Digital Invoices
    • J_3RF_WW_TRANT : Workwear movement type
    • J_3RFPROPTAXV : Property tax values in asset master record
    • J_3RBUE_BK_TXT : Text POOL for EXCTRACT
    • J_3RF_TP_PS : Transfer pricing table for price source codes
    • J_3RF_WRK_GROUP : Assignment fixed-asset classes to material groups in Working
    • J_3RNDSINV : Target use of ingoing invoice positions for AuC

    J_3RF_BK_TOTALS related transaction codes under SAP package J3RF

    • J3RFOS6 : Asset Inventory Cards (Russia)
    • J3RFTPSTATUSV : Status of transaction participants
    • J3RFTAXAMTEST : Tax Depreciation Report (Russia)
    • J3RFTRPRDOC : Transfer Pricing Document Types
    • S_EBS_44000512 : Goods Import Declaration (Customs Un
    • J3RFTPCCPROV : CompanyCategories, LiquidationCodes
    • J3RFWWALLOW : Maintain Workwear quaotas
    • S_EBS_44000565 : Invoice Journal (Russia)
    • J3RF_FCHA : Net wealth calculation
    • J3RFSELB : Sales Ledger (Russia)
    • J3RFSTRDIV : Structural divisions customizing
    • J3RTSEAUXILIAV : Links between FI and SD/MM items
    • J3RF_AN_BALAN : Balance report for anlysis Russia
    • J3RFINVTARG : Redetermination of Invoices (Russia)
    • J3RFREVAL : Fixed Asset Revaluation for Russia
    • J3RTSEMAINT : Secondary Events Table Maintenance
    • J3RFF3 : Changes in Equity, Main Section
    • J3RFF3S1 : Changes in Equity, Explanations
    • J3RFVENDORV : Maint. view of Vendor Data
    • J3RFBAL01 : Balance Sheet Analysis (Russia)

    Related References

    Related Tutorials

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

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

    BEL_JOURNAL SAP table for – Belgium : Sales/Purchase Journal Period Balances

    BEL_JOURNAL table in SAP FI (Localization in FI) module. This table is used for storing data of Belgium : Sales/Purchase...

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

    DFKKHUREPDS SAP table for – Recording Data for Domestic Sales Hungary

    DFKKHUREPDS table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    J_3RF_REGINV_K SAP table for – Incoming invoice journal transp tab for IBOOK

    J_3RF_REGINV_K table in SAP FI (Localization in FI) module. This table is used for storing data of Incoming invoice journal...

    «
    »