XML Feeds

Search Big4Guy

Custom Search

Sponsored

« Physical Inventory Counts in SAP - Stocktaking in SAP R3 EnvironmentSarbanes Oxley Business Process Cycle - Definition of Business Process Cycle »

SAP R3 Tables - Concept and Structure of Tables in SAP

SAP R3 Tables - Concept and Structure of Tables in SAP

All data in SAP neccesarily sits in tables. A table is nothing but a matirx containing rows and columns which how the database would handle the data. In SAP, each table contains a header. The header defines the fields i.e. columns in the table. Each table also contains data values which are identically configured rows which contain data values. There are normally four types of tables in SAP. Each of these four categories of tables contain the different types of data namely:

- Application Data
- System Control Data
- Organizational Structure Data
- Commercial Data

Another point worth mentioning here is that each data record in SAP contains a primary key and a functional area. The primary helps SAP in uniquely identifying a data record within a table. Examples of tables in SAP would include Table MARA which is the table for material master. KNA1 is the table for customer master. Table LFA1 is vendor master and so on.

Related Posts

Functional Area in SAP
Configuring Sourcelists in SAP MM
SAP PP - Bill of Material BOM
SAP SD - Basics of Sales Documents


1 comment

Comment from: Sriragj [Visitor]
Nice articles. Just spending time on this site itself gives me greater confidence in the subjects. Thanks
03/17/06 @ 07:16

This post has 19 feedbacks awaiting moderation...

Leave a comment


Your email address will not be revealed on this site.

Your URL will be displayed.
(Line breaks become <br />)
(Name, email & website)
(Allow users to contact you through a message form (your email will not be revealed.)