how can i fetch the records of 3 tables with a single select
query,without using join.
Answer Posted / fawaz
select mara~matnr from mara.
select vbrk~arktx from vbrk where arktx = mara~matnr.
select ........
endselect
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What are the differences between session method and call transaction method? : abap bdc
What is search help exit? : sap abap data dictionary
PROGRAM TO CREATE INQUIRY IN SD USING BAPI 'BAPI_INQUIRY_CREATEFROMDATA'
While doing bdc exp va01 transaction sometime in the item level data shows only 4 items and other times it will show 6 line items, how will you maintain this kind of screen resolutions scenerio? : abap bdc
data:zxyz type xyz. where xyz is a standard sap structure where it contains data type fields and line type (refer to other structure) fields. my question is how to assign values to field zxyz-str-matnr where str is a structure inside xyz structure.
What are the function modules that are generated when you activate a lockobject? : sap abap data dictionary
What are the different window types in sapscript?
Explain the Inportance of pa40? : abap hr
What are the differences between a database index and a match code? : abap data dictionary
Can there be more than 1 main window in sap script?
What is an rfc?
Where do you find info on new developments in SAP?
From excel to abap - is batch mode possible ? : abap bdc
What is the maximum number of match code id's that can be defined for one match code object ?
Under Data Transfer Portion of ABAP, what do you mean by DX Project