Table Relationship In SAP

Table Relationship In SAP

Today I want to teach you how to find SAP table relationships, this is very useful for functional analyst to make a good program specification and also it can help ABAPer to look at the table relationships also.
The TCODE we’ll be using is SE11.
1. EXECUTE TCODE SE11 and enter the table name that you want to look at the relationship, in this tutorial I want to see table relationships between table EQUZ and ILOA, so I just type in the EQUZ table name and click on the display button.

Read more »

Table Relationship In SAP

Today I want to teach you how to find SAP table relationships, this is very useful for functional analyst to make a good program specification and also it can help ABAPer to look at the table relationships also.
The TCODE we’ll be using is SE11.
1. EXECUTE TCODE SE11 and enter the table name that you want to look at the relationship, in this tutorial I want to see table relationships between table EQUZ and ILOA, so I just type in the EQUZ table name and click on the display button.

Read more »

SAP Query – What is SAP Query

In this tutorial, you will learn about SAP Query, this tool will allow you to display data from SAP database tables in a report list format.
What is SAP Query?
SAP Query is just like any other query that is using SQL syntax to create reports from one or more database tables. The query output of SAP Query can be displayed in a grid or list format, it can also be displayed on the screen using SAP Graphics, you can also download the report into various file types such as Excel even flat file.
SAP Query consists of 3 main components, which are:
1. User Groups:
User groups is a collection of users that are doing similar tasks, so if you change some queries in a certain user groups then it will be reflected to all users within the user groups.
TCODE: SQ03

Read more »