Advertising:

Tables

From SAP Knowledge Base
Revision as of 13:39, 5 January 2025 by Unirab (talk | contribs) (→‎Forms)

Database tables in SAP are the backbone of the system's data storage and management. They organize and store all types of data required for business processes, and they allow SAP modules to interact with each other by sharing information across tables. Understanding the structure and usage of these tables is crucial for both system consultants and developers, as it enables efficient data management, report generation, and system customization.

Compare first CDS views for selecting data: CDS_Views

Development

Forms

Name Purpose More Details Notes
TNAPR Find printprogram for form Keys / Fields / Foreign Key Relationships
FPCONTEXT Assignment of forms and interfaces Keys / Fields / Foreign Key Relationships
FPINTERFACE Assignment of forms and interfaces Keys / Fields / Foreign Key Relationships

Materials Management

Procurement / Purchasing

Purchase Order

Name Purpose More Details Notes
EKKO Purchasing document header Keys / Fields / Foreign Key Relationships
EKPO Purchasing document item Keys / Fields / Foreign Key Relationships
EKET Purchasing document delivery schedules Keys / Fields / Foreign Key Relationships
EKKN Account assignment in purchasing document Keys / Fields / Foreign Key Relationships
EKES Vendor confirmations Keys / Fields / Foreign Key Relationships

This is a wiki created in the spare time of a private person working in the SAP ERP area. The aim is to collect knowledge for the own use. The wiki is maintained to the best of knowledge and belief.
All products shown, including in form of screenshots, belong to SAP SE. Their trademarks are, among others: SAP®,ABAP®,SAP Fiori®,SAP HANA®,SAP NetWeaver®,SAP® R/3®,SAP S/4HANA®,SAP S/4HANA® Cloud