My SAP World

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...

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...