Fi - g/l account balance and open/line item Table in SAP

• DKOKP
  Table for Open Item Account Balance Audit Trail
  Table Type : TRANSP
  Package : FREP
  Module : CRM
• DKOKS
  Table for Open Item Account Balance Audit Trail Master Record
  Table Type : TRANSP
  Package : FREP
  Module : CRM
• JBRSART
  Table for Balance Type for Characterizing an Account Balance
  Table Type : TRANSP
  Package : JBRC
  Module : IS-B-RA

• LDLBC
  Table for Takts/no. of ind. capacities per line segment line balance
  Table Type : TRANSP
  Package : LALD
  Module : PP
• TRM021
  Table for Account Balance: Line-Layout Variant for Display Level 1
  Table Type : TRANSP
  Package : EEFO_FICA
  Module : IS-U-CA
• TRM022
  Table for Account Balance: Line Layout Variant for Display Level 2
  Table Type : TRANSP
  Package : EEFO_FICA
  Module : IS-U-CA
• DBERDLB
  Table for Reference of a Print Doc. Line Item to a Bill.Doc. Line Item
  Table Type : TRANSP
  Package : EE22
  Module : IS-U-IN
• T021
  Table for Fields for Line Item and Document Line Layout
  Table Type : POOL
  Package : FBAS
  Module : CRM
• TDACCOUNTDETS
  Table for Account Determination Open Item Transfer Posting
  Table Type : TRANSP
  Package : FVVD
  Module : FS-CML
• TDACCOUNT_DET_S
  Table for Account Determination Open Item Transfer Posting
  Table Type : TRANSP
  Package : FVVD
  Module : FS-CML
• CACS00_DOCSEDT
  Table for Line Item Detail Line
  Table Type : TRANSP
  Package : CACSCC
  Module : ICM
• GLE_FI_ITEM_ORIG
  Table for ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)
  Table Type : TRANSP
  Package : AC_INT_ECS_PER_APPL
  Module : AC-INT

• LBVALID
  Table for Validity of a Line Balance in iPPE
  Table Type : TRANSP
  Package : CPPEBAL
  Module : AP-PPE
• LDLBH
  Table for Line balance/planned rate header record
  Table Type : TRANSP
  Package : LALD
  Module : PP
• LDLBP
  Table for Line balance items
  Table Type : TRANSP
  Package : LALD
  Module : PP
• LINEBAL
  Table for Line Balance Versions in iPPE
  Table Type : TRANSP
  Package : CPPEBAL
  Module : AP-PPE
• PRBAL
  Table for iPPE Relationships: Line Balance
  Table Type : TRANSP
  Package : CPPEBAL
  Module : AP-PPE
• ELACCZ
  Table for Loyalty Account Line Item
  Table Type : TRANSP
  Package : EE01
  Module : IS-U-MD
• FMBUDSTA
  Table for Budgetary ledger account derivation: Open items/Actuals bdgt
  Table Type : TRANSP
  Package : FMFG_E
  Module : PSM-FM
• BKK50
  Table for Account balance
  Table Type : TRANSP
  Package : FKBK
  Module : IS-B-BCA-MD
• BKK54
  Table for Account Balance of Hierarchies
  Table Type : TRANSP
  Package : FKBK
  Module : IS-B-BCA-MD
• CRMC_FICA_SPLI
  Table for FI-CA Account Balance Splits
  Table Type : TRANSP
  Package : CRM_FICA_CUST
  Module : CRM-IC-FCA
• CRMC_FICA_SPLI_T
  Table for FI-CA Account Balance Splits Text Table
  Table Type : TRANSP
  Package : CRM_FICA_CUST
  Module : CRM-IC-FCA
• DFKKBRPOPNOT
  Table for Balance Reporting: Noticed Contract Account Document Items
  Table Type : TRANSP
  Package : FKK_ID_XX
  Module : FI-CA

• DFSCIHISTIOB
  Table for Balance Int. Calculation at Contract Account Level: History
  Table Type : TRANSP
  Package : FSCR
  Module : FI-CAX
• EEFO01
  Table for Settings for Account Balance in CIC
  Table Type : TRANSP
  Package : EE_CRM_CIC
  Module : CS-CI-CIC
• FMFGF2FADT
  Table for (FACTS II) Account Balance Definition Table
  Table Type : TRANSP
  Package : FMFG_E
  Module : PSM-FM
• JBRAMOUNT
  Table for RM: Account Balance Summarization in Base Portfolio
  Table Type : TRANSP
  Package : JBR
  Module : IS-B-RA
• JBRKON
  Table for RM: Account Balance Summarization in Base Portfolio
  Table Type : TRANSP
  Package : JBR
  Module : IS-B-RA
• JBR_US_ACCT
  Table for Balance Sheet Account Key
  Table Type : TRANSP
  Package : JBA_US
  Module : IS-B-SA-ALM
• MYLAUFCUST
  Table for Customizing for Balance Sheet Valuation Delta Run by Account
  Table Type : TRANSP
  Package : MRY
  Module : MM-IM-VP
• MYLAUFHD
  Table for Run for Balance Sheet Values by Account
  Table Type : TRANSP
  Package : MRY
  Module : MM-IM-VP
• OIUH_RV_ONAB
  Table for Owners Negative Account Balance
  Table Type : TRANSP
  Package : OIU_H
  Module : IS-OIL-PRA-REV
• T030U
  Table for Account Determ.for Balance Sheet Transfer Postings
  Table Type : TRANSP
  Package : FBAS
  Module : CRM
• T033U
  Table for Account Determ.for Balance Sheet Transfer Postings
  Table Type : POOL
  Package : FBAS
  Module : CRM
• TFK021L
  Table for Account balance: List types
  Table Type : TRANSP
  Package : FKKB
  Module : FI-CA
• TFK021M
  Table for Account balance: List types (description)
  Table Type : TRANSP
  Package : FKKB
  Module : FI-CA
• TFK021_ROLES
  Table for Account Balance Roles
  Table Type : TRANSP
  Package : FKKB
  Module : FI-CA
• TFK021_ROLEST
  Table for Account Balance Role Description
  Table Type : TRANSP
  Package : FKKB
  Module : FI-CA
• TFK021_SNAP
  Table for Account Balance: Current Snapshot
  Table Type : TRANSP
  Package : FKKB
  Module : FI-CA
• TRM001I
  Table for Account Balance: List Types for Bills
  Table Type : TRANSP
  Package : EEFO_FICA
  Module : IS-U-CA
• TRM001S
  Table for Account Balance: Superior List Types
  Table Type : TRANSP
  Package : EEFO_FICA
  Module : IS-U-CA
• UDMCASEATTR10
  Table for Dispute Case Attribute for Account Balance (FI-CA)
  Table Type : TRANSP
  Package : UDM_FICA_CASE
  Module : FIN-FSCM-DM-DM
• CRMM_BUAG_BUPA
  Table for Active Open Item Accounting (FI-AR or FI-CA) for BP
  Table Type : TRANSP
  Package : CRM_BUPA_FRG0130
  Module : CRM-MD-BP-BAG
• DFKKCLMEM
  Table for Management Table for Buffered Open Item Processing
  Table Type : TRANSP
  Package : FKKB
  Module : FI-CA
• DFKKKO
  Table for Header Data in Open Item Accounting Document
  Table Type : TRANSP
  Package : FKKB
  Module : FI-CA
• FAGL_R_SPL_VAL
  Table for Reorganization: Splitting Information of Open Item Values
  Table Type : TRANSP
  Package : FAGL_REORGANIZATION_FW
  Module : FI-GL-REO
• FAGL_SPLINFO_VAL
  Table for Splitting Information of Open Item Values
  Table Type : TRANSP
  Package : FAGL_ONLINE_SPLITTER
  Module : FI-GL
• J_1AOIFWVL
  Table for Open item foreign currency valuation: temp. storage
  Table Type : TRANSP
  Package : J1AI
  Module : CA-GTF-CSC
• SEPM_OIA_CUST_T
  Table for Customizing table for Open Item Analysis
  Table Type : TRANSP
  Package : S_EPM_OIA_DFG_FWK
  Module : BC-SRV-NWD-XBR
• T030D
  Table for Acct Determ.for Open Item Exch.Rate Differences
  Table Type : POOL
  Package : FBAS
  Module : CRM
• SSTYP_EB
  Table Data element for Beginning balance type (F=begin balance, M=interim balance)
• ESTYP_EB
  Table Data element for Ending balance type (F=ending balance, M=interim balance)
• SHKZG_UMSV
  Table Data element for Indicator: Total Balance, Debit Balance or Credit Balance?
• SOWRO
  Table Data element for Special line for open quantity/open value
• FAGL_OIM_BALANCE_XFLAG
  Table Data element for Open Item Management for Zero-Balance Clearing
• BKK_BALNOT_BALANCE
  Table Data element for Balance Shown in the Balance Notification (Account Currency)
• RL_BAL_OLD
  Table Data element for Old Account Balance (Balance Carried Forward)
• LD_LBAL_MAX
  Table Data element for Indicator: balance line to max. load utiliz. of prod. line
• XJSPBV
  Table Data element for IS-M: G/L account line item in bank clearing account
• BRUTTOZEILE
  Table Data element for Blling line item is a gross line item
• ICRCXWBAL
  Table Data element for ICRC: Item Is Open and Cannot Be Assigned Automatically
• NOIVQ_NF
  Table Data element for Value and Quantity-Based Open Item Required

Fi - g/l account balance and open/line item 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.