What are the different types of tables and Structures in in SAP?


Answer: There are mainly three types of tables and three types of Structures in SAP. I have provided the details of those tables and structures along with examples in this document.

1.Transparent table:

There is a physical table on the database for each transparent table. The names of the physical tables and the logical table definition in the ABAP/4 Dictionary correspond.

All business data and application data are stored in transparent tables.

Ex: Purchase Order Header Data- EKKO

2. Pooled Table:

Pooled tables can be used to store control data (e.g. screen sequences, program parameters or temporary data). Several pooled tables can be combined to form a table pool. The table pool corresponds to a physical table on the database in which all the records of the allocated pooled tables are stored. This is for internal purposes, such as storing control data or update texts etc.

Ex: Material Info Record (Plant-Specific)- A017

3. Cluster Table:

Cluster tables contain continuous text, for example, documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table type. This permits object-by-object storage or object-by-object access. To combine tables in clusters, at least parts of the keys must agree. Several cluster tables are stored in one corresponding table on the database. This is for internal purposes, such as storing control data or update texts etc.

Ex: Accounting Document Segment- BSEG

4. Structure:

A structure (structured type) consists of components (fields) whose types are defined. A component can have an elementary type, a structured type, a table type or reference type

Structures are used specially to define the data at the interface of module pools and screens and to define the types of function module parameters.

Structures that are used more than once can be changed centrally because they were defined centrally. The active ABAP Dictionary makes this change at all relevant locations. ABAP programs or screen templates that use a structure are automatically adjusted when the structure changes.

Ex:  MEPO1220- Fields for Screen 9101

5. Append Structure:

An append structure defines a set of fields that belong to another table or structure but are treated in the correction management as a separate object.

Append structures are used to support modifications.

Ex: ISAUTOLAB- IS AUTOMOTIVE Enhancements in EKPO

6. Generated view Structure:

In activation a structure is generated for a view. This structure serves as interface for the runtime environment. It does not generally appear in the ABAP/4 Dictionary. This is for internal purposes, such as storing control data or update texts etc.

Ex: V_T438M_B- Direct Procurement

We can see the type of table or structure by displaying the details with SE11 T Code for a single entry and for multiple tables or structures, we can get from table SAP Tables-DD02L. Both the methods are explained below

1.Through SE11 Transaction Code:

Input Screen: Input the Table which you want to check and click on display icon as shown below

Output Screen: The table or structure type will be visible as shown in the highlighted box

2. Through Table DD02L: This method will be helpful to know the table types of many tables

Input Screen:

Output Screen:

I hope this document is helpful for you. Provide your feedback. Thanks for viewing the document

Best Regards,

Ganesh Padala

ganesh.sap2015@gmail.com

SAP WM Interview Questions Part 2 by Ganesh Padala


Hi Friends,

I came with one more video where I explained Interview Question along with answer in detail. I hope it will be helpful. Please provide your valuable feedback.

Regards,

Ganesh

SAP WM Interview Questions Part 1 by Ganesh Padala


Hi Friends,

I came with WM Interview Question with detailed explanation. I hope you will get some knowledge from this video. You can watch and provide your valuable comments.

 

 

Best Regards,

Ganesh Padala

Mail: ganesh.sap2015@gmail.com

 

SAP MM Mock Interview 1


Hi Friends,

In this video, I have provided a Mock Interview on SAP MM. In this mock interview, I have covered the areas from Organization Structure and Master Data.

Watch the video at the below link .

 

Visit the blog and share in Social network. And also use the Flipkat, Amazon online links whenever you shop.

 

Thanks and Best Regards,

Ganesh

ganesh.sap2015@gmail.com

How to assign Purchase Value key when we don’t create material master?


Answer:

As we aware that Purchase Value key can be assigned in Purchasing view for material. But Purchase value key can be assigned although we don’t create Material Master with below configuration step where we assign valuation class to Material group.

IMG – Material Management – Purchasing – Material Master – Entry Aids for items without a Material Master

PVK without material masterPVK without material master 2

Follow the blog for new updates and share with your friends to make it useful to many people.  Use Online shopping links in my blog whenever you shop in Flipkart, Amazon etc.

Regards,

Ganesh