Top SAP © Tables - list for the Accounts Receivable Module FI-AR
View table content with transaction SE16, SE16N or SE16H (with HANA-Database) and tablestructure with SE11




Masterdata    

TableTable - NameS/4HANA -Table and general Notes
KNA1 General Data in Customer Master In Logical Database BRF DDF SD_KUSTA VC1 VC2 VDF WTY.
KNATCustomer Master Record (Tax Groupings)
KNB1 Customer Master (Company Code) In Logical Database BRF DDF VDF.
KNB4 Customer Payment History In Logical Database BRF DDF.
KNB5 Customer master (dunning data) In Logical Database BRF DDF.
KNBK Customer Master (Bank Details) In Logical Database BRF DDF.
KNBWCustomer master record (withholding tax types) X
KNEXCustomer Master: Legal Control - Sanctioned Party List
TIBAN IBAN In Logical Database IBAN.

Business Partner    

TableTable - NameS/4HANA -Table and general Notes
BUT000 Business Partner: General data I Field TYPE for the Business Partner category: 1 = Person, 2 = Organization, 3 = Group. In Logical Database REBP UKM_BUPA.
BUT020Business Partner: AddressesIn Logical Database REBP.
BUT0BKBP: Bank Details
BUT100 Business Partner: Roles In Logical Database REBP.
CVI_CUST_LINK Assignment Between Customer and Business Partner Linked to table BUT000 via the field Partner_GUID.

Transactional Data    

TableTable - NameS/4HANA -Table and general Notes
BKPF Accounting Document Header In Logical Database BMM BRF BRM DDF KDF SDF.
BSAD Accounting: Secondary Index for Customers (Cleared Items)
BSEC One-Time Account Data Document Segment In Logical Database BRM.
BSID Accounting: Secondary Index for Customers For open items migration Accounts Receivable. In Logical Database DDF VDF.
KNC1Customer master (transaction figures)Total postings/sales per CompanyCode/customer/year.
REGUH Settlement data from payment program In Logical Database PYF.
REGUP Processed items from payment program In Logical Database PYF.
VBKPF Document Header for Document Parking
VBSEGD Document Segment for Customer Document Parking

Additional tables for Transactional Data in New General Ledger    

TableTable - NameS/4HANA -Table and general Notes
BSEG_ADD Entry View of Accounting Document for Additional LedgersWhen the document is not relevant for the leading ledger.
FAGL_SPLINFOSplittling Information of Open Items
FAGLFLEXA General Ledger: Items
FAGLFLEXPGeneral Ledger: Plan Line Items
FAGLFLEXT General Ledger: Totals

New Finance tables in S/4 for Transactional Data     

TableTable - NameS/4HANA -Table and general Notes
ACDOCA Universal Journal Entry Line ItemsOSS-Note 3128916 - FI documents has 999 limit of line item in S/4 HANA ?.
ACDOCPPlan Data Line Items

Taxes    

TableTable - NameS/4HANA -Table and general Notes
T007ATax Keys
T007BTax Processing in Accounting
T007STax Code Names

Periodic Processing    

TableTable - NameS/4HANA -Table and general Notes
T001BPermitted Posting PeriodsEdit with transaction OB52.

Customizing - Tables    To go to the IMG customizing entry, enter the table name in transaction SM30, click on 'Customizing' and then on 'Continue w/o Specifying Project'.

TableTable - NameS/4HANA -Table and general Notes
NRIV Number Range Intervals Edit with transaction SNUM. For FI documents the object name = 'RF_Beleg', value subobject is the company code. Maintain number intervals directly via transaction FBN1.
T003 Document Types for Finance In table T003 is the number of the number range. Edit with transaction OBA7.
T077DCustomer account groups
T077XAccount Group Names (Table T077D)

Report here a missing table...


Additional tables for the following modules:

FI          FI-GL          FI-AP          FI-BL          FI-AA          CO          CO-OM-CEL          CO-OM-CCA          CO-OM-OPA          CO-PC          EC-PCA          RE-FX          RE-FX-LA           SD          MM          MM-PUR          QM          PM          PP          PP-PI          PS          PA                                        AP-MD-BP          






Top T-codes - list for the Accounts Receivable Module FI-AR ©
View table content with transaction SE16, SE16N or SE16H (with HANA-Database) and tablestructure with SE11


Periodic Processing    

TransactionTransaction - NameNotes
F-51Post with Clearing
F.13Automatic Clearing without Currency

Customizing - Transactions    

TransactionTransaction - NameNotes
O7F1Clearing field selection conditions
OBA7C FI maintain table T003
OBY6C FI Maintain Table T001
XDN1Number Ranges (Customer)