Big4Guy

Welcome to Big4Guy.com. Big4Guy is an online resource where I will share with you the latest news, insights, knowledge and some experiences as a Big 4 consultant. We will discuss some of the important issues which organisations are facing today in the areas of information security, security and controls in SAP R/3, Oracle Applications, J.D.Edwards, Peoplesoft and various other ERP's. You will also find information on latest complaince regulations like Sarbanes Oxley, Basel II and so on. Big4guy will also attempt to provide valuable resources for individuals interested in examinations the CISA, CISM, CISSP, PMP and various other security certifications considered essential for entry in any Big 4 accounting, auditing and consulting firms. You are invited to post your comments and viewpoints to posts here. I sincerely hope this online journal will be useful to everyone from a budding student to a professional in the accounting, auditing, management and consultancy professions.

Post details: SAP R3 Tables - Concept and Structure of Tables in SAP

03/17/06

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

Comments:

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

Official Websites

Search

Google

Web Big4Guy.com

September 2008
Mon Tue Wed Thu Fri Sat Sun
<<  <   >  >>
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30          

Misc

Syndicate this blog XML

What is RSS?