Interested to Buy Any Domain ? << Click Here >> for more details...
Give the syntax of Inner,outer Join?"
- 7 Answers
- 35237 Views
- Genpact, HCL, Satyam, I also Faced
- E-Mail Answers
Answer Posted / ravi ranjan
*&-----------------------------------*
*& Report ZSELECT_STA *
*& *
*&-----------------------------------*
*& Author : Ravi Ranajn upadhyay *
*& *
*&-----------------------------------*
REPORT zselect_sta.
TABLES: mara.
TYPES:BEGIN OF it_mara,
ernam TYPE mara-ernam,
matnr TYPE mara-matnr,
meins TYPE mara-meins,
burks TYPE ekpo-bukrs,
werks TYPE ekpo-werks,
END OF it_mara.
DATA:its_mara TYPE TABLE OF it_mara,
wa_mara TYPE it_mara.
SELECT m~matnr m~ernam m~meins k~werks k~bukrs
INTO CORRESPONDING FIELDS OF TABLE its_mara
FROM mara AS m inner JOIN ekpo AS k
ON m~matnr = k~matnr.
LOOP AT its_mara INTO wa_mara.
WRITE: / wa_mara-ernam,
wa_mara-matnr,
wa_mara-meins,
wa_mara-burks,
wa_mara-werks.
ENDLOOP.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Explain what is a foreign key relationship? Explain this with the help of an example.
What is the difference between call transaction and session method? : abap bdc
10) How to get Item Header in Sales Order?
How can we upload a text file having delimiters in to legacy system? : abap bdc
What is an Unpack command?
How are the date abd time field values stored in sap?
What are the different types of locks? : abap data dictionary
Explain about interactive report?
what is leave to TRANSACTION?
Which transaction code is used executing a report (type 1 program)? : abap data dictionary
Hi to all abap gurus iam new to abap and my querry is as follows . and i feel so happy if u give exact anwers ? Querry1: i have one page( named "page1" )in my script with three windows(logo,adress,main windows) my requirement is to display some dynamic data in the script that is list of orders of the customer whn u give the customer number in selction-screen .then we can go for main window only to dispaly dynamic data ? or is there any other option ? then what should we give as apage number in the next page attribute in the header information. suppose if i dont give "page1" in the next page attribute as anext page what will happen ? i mean that dynamic data will be displayed or not ? Querry2: one one more querry incase if we have two pages in my layout .in page1 (3 windows as said above ) and page2 ( only logo and address window ) and no main window in page2. now if we give "page2" as next page in the next page attribute of page1 then that dynamic data will be displayed or not ?
What is your approach to find exit and BAdi?
can i use table key and key in an internal table and explain the functionalities of each one and what functionality does it give if both are used for same internal table
What is the difference between native sql & open sql? : abap data dictionary
A field-groups statement or an insert statement reverses storage space and transfers values. State true or false. : abap modularization
