Offsetting account Table in SAP

• J_3RKAID
  Table for Activate Automatic Offsetting Account Determination
  Table Type : TRANSP
  Package : J3RF_RU_CN
  Module : FI-LOC
• J_3RKNEWGLLEDGER
  Table for Activate non-leading ledger for Offsetting Account Syst.
  Table Type : TRANSP
  Package : J3RK
  Module : FI-LOC
• /SAPPCE/TPNV01K
  Table for Construction Progress Report: Definition Offsetting Account
  Table Type : TRANSP
  Package : /SAPPCE/PNV
  Module : PS-REV-CPR

• DFKKOPK_SHORT
  Table for Offsetting Items for FI-CA Document - Extracts
  Table Type : TRANSP
  Package : FKKB
  Module : FI-CA
• J_3R_INVDIFF
  Table for Offsetting inventory differences of goods
  Table Type : TRANSP
  Package : J3RALF
  Module : FI-LOC
• T5G26
  Table for OSP-Related Data for SSP Offsetting
  Table Type : TRANSP
  Package : PB08
  Module : PA-PA-GB
• TBKKG32
  Table for Transaction Type Offsetting Posting Inter. Initiated PT
  Table Type : TRANSP
  Package : FKBA
  Module : IS-B-BCA-MD-PR
• TCACS_OFFS
  Table for Comn: Offsetting
  Table Type : TRANSP
  Package : CACSCC
  Module : ICM
• TCACS_OFFS_T
  Table for Comn: Name of Offsetting Types
  Table Type : TRANSP
  Package : CACSCC
  Module : ICM
• TKKVUVFRI
  Table for Clearing: Offsetting Intervals Prior to Due Date
  Table Type : TRANSP
  Package : ISCDFUN
  Module : FS-CD
• ACCRAC
  Table for Assignment of Acr./Def. G/L Account to Accruals Account
  Table Type : TRANSP
  Package : ACCR
  Module : FI
• BKK600
  Table for Account Hierarchy: Account Relationships
  Table Type : TRANSP
  Package : FKBR
  Module : IS-B-BCA-MD

• BKK610
  Table for Account Hierarchy: Assignment of Root Account to Tree Number
  Table Type : TRANSP
  Package : FKBR
  Module : IS-B-BCA-MD
• BSACC_HIST_GRP
  Table for Account Groups for Account History
  Table Type : TRANSP
  Package : FIN_BS_DIALOG
  Module : FI-GL-GL
• BSACC_HIST_GRPT
  Table for Account Groups for Account History
  Table Type : TRANSP
  Package : FIN_BS_DIALOG
  Module : FI-GL-GL
• CRMC_ACC_MAP
  Table for Assignment of Account Assignment Group to Account
  Table Type : TRANSP
  Package : CRM_LEASING_SRM
  Module : CRM-LAM-BTX
• CRMD_ACC_PL_ATTR
  Table for Account Planning account plan attributes
  Table Type : TRANSP
  Package : CRM_ACCOUNT_PLANNING
  Module : CRM-ACP-APL
• ICRC02
  Table for Account Groups for G/L Account Reconciliation
  Table Type : TRANSP
  Package : FBAS
  Module : CRM
• ICRC03
  Table for Account Groups for G/L Account Reconciliation - Name
  Table Type : TRANSP
  Package : FBAS
  Module : CRM
• ICRC04
  Table for Account Groups for G/L Account Reconciliation - User Assgnmt
  Table Type : TRANSP
  Package : FBAS
  Module : CRM
• IDCN_ALGACCGRP
  Table for Account Level Hierarchy: Account Levels
  Table Type : TRANSP
  Package : ID-FI-CN
  Module : FI-LOC
• IDCN_ALGACCGRPT
  Table for Account Level Hierarchy: Account Levels (Text)
  Table Type : TRANSP
  Package : ID-FI-CN
  Module : FI-LOC
• IDCN_ALGACCHIER
  Table for Account Level Hierarchy: Account Level Hierarchy (Top Level)
  Table Type : TRANSP
  Package : ID-FI-CN
  Module : FI-LOC
• IDCN_ZJFSKIPACC
  Table for Skip G/L Account from P&L Account Closing Posting (China)
  Table Type : TRANSP
  Package : ID-FI-CN
  Module : FI-LOC

• IDCN_ZJFSKIPACCT
  Table for Skip G/L Account from P&L Account Closing Posting (Text)
  Table Type : TRANSP
  Package : ID-FI-CN
  Module : FI-LOC
• J_3RKPAI
  Table for Account priorities for account pairs
  Table Type : TRANSP
  Package : J3RK
  Module : FI-LOC
• KOMU
  Table for Account Assignment Templates for G/L Account Items
  Table Type : TRANSP
  Package : FFE
  Module : FI
• PKOMU
  Table for Personal Account Assignment Templates for G/L Account Items
  Table Type : TRANSP
  Package : FFE
  Module : FI
• T033D
  Table for Account Determination: Account Determination Key Names
  Table Type : POOL
  Package : FBAS
  Module : CRM
• T033J
  Table for Account Determination: Account Symbol Descriptions
  Table Type : POOL
  Package : FBAS
  Module : CRM
• T033O
  Table for Account Determination: Account Determination Key Values
  Table Type : POOL
  Package : FBAS
  Module : CRM
• T687
  Table for Account Determination: Account Key
  Table Type : POOL
  Package : FBD
  Module : CRM
• T687T
  Table for Account Determination: Account Key Texts
  Table Type : POOL
  Package : FBD
  Module : CRM
• TACEPSRULE
  Table for ACE Account Determination: Account Determination Rule
  Table Type : TRANSP
  Package : ACE-PS
  Module : FI-GL-GL-ACE
• TACEPSRULET
  Table for ACE Account Determination: Account Determination Rule
  Table Type : TRANSP
  Package : ACE-PS
  Module : FI-GL-GL-ACE
• TACEPSSYM
  Table for ACE Account Determination: Account Symbol
  Table Type : TRANSP
  Package : ACE-PS
  Module : FI-GL-GL-ACE
• TACEPSSYMT
  Table for ACE Account Determination: Account Symbol
  Table Type : TRANSP
  Package : ACE-PS
  Module : FI-GL-GL-ACE
• TICL832
  Table for Entity Table: G/L Account (Chart of Accts and Coll.Account)
  Table Type : TRANSP
  Package : ICL_LAE
  Module : FS-CM
• TIVEXFIREPSYMB
  Table for Replacement of Account Symbol with FI Account
  Table Type : TRANSP
  Package : RE_EX_FI
  Module : RE-FX-RA
• TIVSCTRANSACC
  Table for Assignment of Clearing Account to Cost Account
  Table Type : TRANSP
  Package : RE_SC_BC
  Module : RE-FX-SC
• TJF20
  Table for Convert Bank Clearing Account to Interim Account (Bank Rtns)
  Table Type : TRANSP
  Package : JSD
  Module : IS-M
• TJL26
  Table for IS-M/SD: Conversion of Clearing Account - Real G/L Account
  Table Type : TRANSP
  Package : JSD
  Module : IS-M
• TKSKA
  Table for Account classification for account intervals
  Table Type : POOL
  Package : KBAS
  Module : CRM
• TRAC_ACCSYMB
  Table for Account Determination: Account Symbols
  Table Type : TRANSP
  Package : FTR_ACCOUNTING_ADAPTOR
  Module : FIN-FSCM-TRM-TM-AC
• TZB27
  Table for Assignment of G/L account to account group
  Table Type : TRANSP
  Package : FVVD_PAYMENT
  Module : FS-CML-AC-RPM
• TZB43
  Table for Account Clearing: Checks at Customer Account Level
  Table Type : TRANSP
  Package : FVVD_PAYMENT
  Module : FS-CML-AC-RPM
• WRFT_PREPAY_ACCT
  Table for Account Determination: Prepayment Clearing Account
  Table Type : TRANSP
  Package : WRF_INVOICEVERIFICATION_PREPAY
  Module : MM-IV-LIV
• /DSD/RP_DRVKTOKD
  Table for Define Account Group as Account Group for Driver
  Table Type : TRANSP
  Package : /DSD/RP
  Module : LE-DSD-RP
• A087
  Table for Taxes: Plant, Account Assignment and Origin
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A088
  Table for Taxes: Material, Plant, Account Assignment and Origin
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• AAACC_EXCL
  Table for Exception Table for Account Assignment Settings in FI-AA
  Table Type : TRANSP
  Package : AA_BAS_CUS
  Module : FI-AA
• ISP_KVSLV
  Table Data element for IS-M: Account Key for Offsetting Entry to G/L Account
• KTOSL_MG
  Table Data element for Account Key: Offsetting Account for Material Adjustment
• RR_SAKRR_KEY
  Table Data element for Clearing account key (offsetting account)
• GKOAR
  Table Data element for Offsetting Account Type
• GKONT
  Table Data element for Offsetting Account Number
• BKK_CGLACC
  Table Data element for Offsetting Account General Ledger Transfer BCA ->FI
• BKK_CGSBER
  Table Data element for Business Area Offsetting Account Transfer BCA->FI
• RL_OFFPOTYPE
  Table Data element for Offsetting account posting type
• MWVKO_KK
  Table Data element for Account for offsetting tax posting in down payments
• GKART
  Table Data element for Offsetting Account Type
• KTAUFG
  Table Data element for Offsetting account for revaluation
• KTAUNG
  Table Data element for Offsetting account: Revaluation of ordinary depreciation

Offsetting account related terms

Definitions

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.