Advertising:

Tables: Difference between revisions

From SAP Knowledge Base
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
Compare first CDS views for selecting data: https://unirab.org/CDS_Views
{{Template:MetaDesc|A list of database tables for master and transaction data for various areas, e.g.:Materials Management, Sales, Finance or Master Data, Businesspartner and more.}}
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.


= Materials Management =
Compare first CDS views for selecting data: [[CDS_Views]]


== Procurement / Purchasing ==
== Development ==


=== Purchase Order ===
=== Forms ===
{| class="wikitable"
|-
! Name !! Purpose !! More Details !! Notes
|-
| TNAPR || Find printprogram for form || [{{DBTable|TNAPR}} Keys / Fields / Foreign Key Relationships] ||
|-
|}


==== Adobe Forms ====
{| class="wikitable"
{| class="wikitable"
|-
|-
! Name !! Purpose !! Keys !! Table Fields / Foreign Key Relationships !! Notes
! Name !! Purpose !! More Details !! Notes
|-
| FPCONTEXT || Assignment of forms and interfaces  || [{{DBTable|FPCONTEXT}} Keys / Fields / Foreign Key Relationships] ||
|-
| FPINTERFACE|| Assignment of forms and interfaces || [{{DBTable|FPINTERFACE}} Keys / Fields / Foreign Key Relationships] ||
|}
 
== Materials Management ==
 
=== Procurement / Purchasing ===
 
==== Purchase Order ====
 
{| class="wikitable"
|-
|-
| EKKO || Purchasing document header || EBELN || ||
! Name !! Purpose !! More Details !! Notes
|-
| EKKO || Purchasing document header || [{{DBTable|EKKO}} Keys / Fields / Foreign Key Relationships] ||
|-
|-
| EKPO || Purchasing document item || EKKO<br/> EBELP || ||
| EKPO || Purchasing document item || [{{DBTable|EKPO}} Keys / Fields / Foreign Key Relationships] ||
|-
|-
| EKET || Purchasing document delivery schedules || || ||
| EKET || Purchasing document delivery schedules || [{{DBTable|EKET}} Keys / Fields / Foreign Key Relationships] ||
|-
|-
| EKKN || Account assignment in purchasing document || || ||
| EKKN || Account assignment in purchasing document || [{{DBTable|EKKN}} Keys / Fields / Foreign Key Relationships] ||
|-
|-
| EKES || Vendor confirmations || || ||
| EKES || Vendor confirmations || [{{DBTable|EKES}} Keys / Fields / Foreign Key Relationships] ||
|}
|}

Latest revision as of 13:41, 5 January 2025

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

Adobe Forms

Name Purpose More Details Notes
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

Retrieved from "https://unirab.org/index.php?title=Tables&oldid=764"