SQVI Query using "Alias"

Can we use a table again in SQVI Transaction code?

What is “Alias” in SQVI Transaction Code?

One of my colleague came to me and said I don't know if we can use a table multiple times in SQVI query. I thought there should be something which can help us. We searched and find “Alias” functionality in SQVI. Let's create a SQVI Query using “Alias”.


Objective : Create a query to display Purchase Requisition Number with service details


 Step 1: Execute transaction code SQVI and Enter.



Step 2: Enter Query Name (Start with Z/Y) in selection Screen in Text Box in front of Label Quick View and Click Create Button



Step 3: Enter Title, Comments and select data Source as Table Join from dropdown and keep checked Basis mode radio button and press Enter.


Step 4: Now It will open the Screen where you can insert tables and create join between them. Purchase requisition data exist in EBAN table and Service Data Exists in ESLL table.
As there are more other tables as well which are linked with these table to fetch all data which is built by purchase requisition transactions but I will take only basic details. 



Step 5: Insert EBAN and ESLL tables.


System by default purpose the link based on foreign key relationship

Now the business problem is, Service details are stored with Sub Package of ESLL-PACKNO which is equal to EBAN-PACKNO.

Means to fetch Service details we have to pass EBAN-PACKNO to ESLL-PACKNO After fetching record we have to pass ESLL-SUB_PACKNO to ESLL-PACKNO again. So, we have to refer ESLL two times.

In SQVI we can't insert one table multiple time so here “Alias” functionality help us. 



    Step 6: Click Alias > Click Create Button, enter table name and it's Alias.


   Step 7: Enter continue and Insert Alias table which is the replica of table ESLL. It is not necessary that join proposed by SAP will fulfil your expectation to generate required output. So delete purposed join and drag and drop field to create new join.  



Step 8:  Click Back and Create “Select Screen” and Select Output “List Fields”.


Step 9:  Click Save now Query will create. Click Back and Save Again.


Step 10:  After Save go to  Menu > QuickView > Additional functions > Generate Ptrogram

Step 11:  After generating program, know your program name by 
 Menu > QuickView > Additional functions > Display Report Name



Here program name is: AQAKSYSTQV000234ZMM_PRSERVICES 

Step 12:  Run above program on se38/sa38



So by this we can create SQVI query with same table multiple time using alias, we generated program, and we execute the same program to fetch required display.

Have a nice day.















 







 

Comments

Post a Comment

Popular posts from this blog

Automated Note Search & Customer Code Detection Tool

Image
Introduction Many times we need to find out correct customer code or space where we can add our code to enhance functionality of standard application. Sometimes we got through experience, by google, search at sap blogs and sometimes we debug. But did you heard about “ Automated Note Search & Customer Code Detection Tool ”.  Automated Note Search & Customer Code Detection Tool or you may Say T-Code ANST, which is used to find existing customer code space in standard code flow. Steps:    1. Type Transaction code ANST 2.  Execute Transaction code Now you have different options in selection screen which you may use as per your requirement and business use case. As Example, I want to know the custom code space for ME52N transaction code. 3. Enter Transaction Code and tick customer Code Only check box. 4. Execute the report after putting parameters. As I put ME52N so it will execute the ME52N. 5. Modify some values in transaction and click “ Save ” button. 6. Progr...
Read more
💖 "A Remote Call to the Heart" — A Story of Two ABAPers In the quiet hum of the SAP system landscape, two developers worked side by side— Minu , curious and bright, and Arnav , wise with years and experience. Their connection grew like clean code—structured, meaningful, and waiting to be executed. Minu admired Arnav’s calm, his mastery over Function Modules, the way he debugged life’s problems like he debugged programs. She wanted to say something. To tell him that in the huge data table of her heart, he was the primary key . But feelings, unlike ABAP, don’t always follow syntax. She opened SE37 and created a Function Module called Z_EXPRESS_FEELINGS . But she hesitated—she didn’t know if it would compile in the real world. What if it raised an exception called REJECTION_NOT_HANDLED ? So, she saved it but didn’t execute. Arnav, sensing something in her silences, decided to take the first step. He marked his own heart as remote-enabled . He believed love, like RFCs, c...
Read more