SAP table BKPF (Accounting Document Header)

SAP table BKPF, known as the "Accounting Document Header," plays a crucial role in the SAP Financial Accounting (FI) module. It stores the header data for financial accounting documents, serving as the primary record for the overarching information of each document. This includes essential fields such as the document number, company code, fiscal year, document date, posting date, and document type. Additionally, BKPF contains information on currency, reference numbers, and reversal status, providing a comprehensive overview that links to detailed line items stored in related tables like BSEG. By consolidating this high-level data, BKPF facilitates efficient management and retrieval of financial transactions within the SAP system.

SAP table BKPF, the "Accounting Document Header," is intrinsically linked to table BSEG, the "Accounting Document Segment." BKPF stores the header information of financial documents, encompassing general data such as document number, company code, fiscal year, and document date. In contrast, BSEG contains detailed line items or segments of these documents, capturing granular transaction data like account numbers, amounts, and specific transaction details. The relationship between BKPF and BSEG is hierarchical, where each entry in BKPF, identified by a unique document number, can correspond to multiple line items in BSEG. This structure allows for efficient organization and retrieval of financial document data, with BKPF providing the summary view and BSEG offering the detailed transactional perspective.

Linking accounting entries with subledgers and other record types in SAP

The fields AWKEY and AWTYP in SAP table BKPF play pivotal roles in linking accounting entries to other records within the SAP system. AWKEY, the "Reference Key," serves as a unique identifier that connects financial transactions in BKPF to corresponding records in other tables across different modules. AWTYP, the "Reference Transaction Type," specifies the type of transaction or document being referenced, further refining the linkage.

When a financial document involves transactions that need to be linked to other records, the combination of AWKEY and AWTYP fields is used to reference the specific documents in other tables. AWKEY provides the unique reference key, while AWTYP indicates the type of transaction or document, such as those related to asset accounting, material management, or other modules. This combination ensures that all financial postings related to various transactions are accurately tracked and easily retrievable for reporting and analysis. By leveraging AWKEY and AWTYP together, users can seamlessly integrate financial accounting data with other processes, providing a comprehensive and detailed view of an organization's financial activities and related records.

SAP table BKPF has 4 primary key fields being MANDT,BUKRS,BELNR,GJAHR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.