Top SAP © Tables 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
KNZAPermitted Alternative Payer
TIBAN IBAN In Logical Database IBAN.

Business Partner    

TableTable - NameS/4HANA -Table and general Notes
ABUSINESSPARTNERBusinesspartnerOnly available in S/4. Shows supplier-, customer- and business-partner relationship.
BP001FS-Specific Attributes; OrganizationGeneral financial services information for the organisation-BP, e.g. for the trading partner.
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.
IBUPACUSTOMERView for the customer - business partnerOnly available in S/4.

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 a missing table or a suggestion for improvement here...


Additional tables for the following modules at Erp-Top.com:

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 Transaction - List Accounts Receivable Module FI-AR ©


Masterdata    

TransactionTransaction - NameNotes
BPMaintain Business PartnerMenu Extras Create/Change to see the BP grouping used for the Business Partner
MDS_LINKSGet the Mapped Cust/Vend/BP

Periodic Processing    

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

Customizing - Tables  - Transactions   

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