Inner join example in SAP-ABAP
Page 1 of 1
Inner join example in SAP-ABAP
- Code:
*&---------------------------------------------------------------------*
*& Report ZSU_INNERJOIN_FOR3
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*
REPORT ZSU_INNERJOIN_FOR3.
tables :mara,marc,mard.
types :begin of t_mar,
matnr type matnr,
mbrsh type mbrsh,
mtart type mtart,
werks type werks_d,
pstat type pstat_d,
lgort type lgort_d,
end of t_mar.
types :tt_mar type standard table of t_mar.
data :lw_mar type t_mar,
lt_mar type tt_mar.
select-options : s_matnr for mara-matnr.
*---------inner ioin to fetch data from mara,marc,mard-----------
select mara~matnr
mara~mbrsh
mara~mtart
marc~werks
marc~pstat
mard~lgort
into table lt_mar
from mara inner join marc on mara~matnr = marc~matnr
inner join mard on marc~matnr = mard~matnr
where mara~matnr in s_matnr.
if sy-subrc = 0.
loop at lt_mar into lw_mar.
write :/ lw_mar-matnr,
lw_mar-mbrsh,
lw_mar-mtart,
lw_mar-werks,
lw_mar-pstat,
lw_mar-lgort.
endloop.
else.
write :/ 'invalid data entered'.
endif.
Similar topics
» Difference between Procedural ABAP and ABAP Objects
» Three tables inner join in SAP
» What is ABAP Objects?
» Wat is an ABAP/4 Query?
» Parameterized constructor in ABAP
» Three tables inner join in SAP
» What is ABAP Objects?
» Wat is an ABAP/4 Query?
» Parameterized constructor in ABAP
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|
Mon Aug 20, 2012 4:37 pm by Admin
» Difference between Type and Like
Thu Jun 07, 2012 2:40 pm by Admin
» How to handle table control fields in Module Pool program?
Wed May 09, 2012 2:41 am by govind
» Three tables inner join in SAP
Thu May 03, 2012 4:47 pm by Uma_ABAP
» Creating table type in ABAP
Sat Apr 28, 2012 9:03 pm by Uma_ABAP
» Creating user defined types and structures in ABAP
Sat Apr 28, 2012 8:55 pm by Uma_ABAP
» Creating Dynamic Internal Table and Dynamic Field catalog in SAP-ABAP
Fri Apr 27, 2012 11:00 am by Admin
» Copy Custom PF-Status from Standard program to Custom Program in ALV
Thu Apr 26, 2012 9:52 pm by Uma_ABAP
» Calculate/find number of working days between two dates in SAP
Tue Apr 24, 2012 2:06 pm by Uma_ABAP