10-03-2008 9:47 AM
hi all.....
i want to setct some data from table vbrp ,vbrk and vbfa .
on selection screen i have vbrk-vbeln and vbfa-erdat i hav written one code for tht but thts not working can nybdy plz help me in this..
parameter : p_vbeln type vbrk-vbeln ,
p_erdat type vbfa-erdat .
*--start of selection events
start-of-selection.
*--SELECTING THE DATA FROM DATABASE INTO INTERNAL TABLE
SELECT v1~vbeln AS vbeln
v1~kunag AS kunag
v1~vkorg AS vkorg
v1~netwr AS netwr
v2~ntgew AS ntgew
v2~matnr AS matnr
v3~erdat AS erdat
INTO CORRESPONDING fields of table it_data1
FROM vbrk AS v1
INNER JOIN vbrp AS v2
ON v1vbeln = v2vbeln
INNER JOIN vbfa AS v3
ON v1vbeln = v3vbeln
WHERE v1~vbeln eq p_vbeln .
loop at it_data1 into wa_data where erdat ne p_erdat.
delete it_data1 from wa_data.
endloop.
end-of-selection.
thanks in advance.....
10-03-2008 9:50 AM
Hi
Pls check in VBFA table, whether it is available in VBELN or VBELV
Regards
MD
10-03-2008 9:50 AM
Use this,
SELECT v1~vbeln
v1~kuna
v1~vkorg
v1~netwr
v2~ntgew
v2~matnr
v3~erdat
INTO CORRESPONDING fields of table it_data1
FROM vbrk AS v1
INNER JOIN vbrp AS v2
ON v1vbeln = v2vbeln
INNER JOIN vbfa AS v3
ON v1vbeln = v3vbeln
WHERE v1~vbeln eq p_vbeln
Regards,
Midhun Abraham
Edited by: Midhun Abraham on Oct 3, 2008 10:51 AM
10-03-2008 9:50 AM
Hi
Pls check in VBFA table, whether it is available in VBELN or VBELV
Regards
MD
10-03-2008 10:07 AM
hi madhan....
yes its in vbelv i hav changed tht but the thing is data is not coming through ...
what is the problem in the select query....
10-03-2008 10:26 AM
Hi
Pls let me know, how the select querry looks like, after modification
Regards
MD
10-03-2008 10:12 AM
Hi,
have u checked in debugging , by setting a break point at select statement.
bcoz it may happens, u r deleting the data from internal table
by
delete it_data1 from wa_data.
revert back if any issues,
regards
Naveen
10-03-2008 10:23 AM
hi naveen,
yes i hav tried debugging tht query but i m not able to understand y its not selecting ny data.....
i hav commented tht deleting part then too no data is being selected...
10-03-2008 10:34 AM
Hi,
I have tried ur program in my system.
select querry is working fine i.e i can see the data in the interrnal table.
i am sure that the data is being deleted by the delete statement.
moreover check whether the data u entered in the selection screen exits in the database.
Revert back...
regards,
Naveen
10-03-2008 10:24 AM
I am not sure if this help, you may try this:
WHERE v1~vbeln IN p_vbeln .
If your vbeln is in range (i.e. you see two boxes with for that parameters in the selection screens), you need to use IN to check value instead of eq
10-03-2008 10:30 AM
Hi
WHERE v1~vbeln eq p_vbeln .
change to
WHERE v1~vbeln like p_vbeln and see, whether it works
MD
10-03-2008 10:44 AM
How have you defined your itab ?
You query looks perfectly ok , even if you use vbeln or vbelv it wont matter , it depends on the requirement.
So have you defined your itab correctly ?
for example :
data : begin of itab occurs 0,
vbeln like vbrk-vbeln,
kunag like vbrk-kunag,
netwr like vbrk-netwr,
ntgew like vbrp-ntgew,
matnr like vbrp-matnr,
erdat like vbfa-erdat,
end of itab.
regards,
Advait