2006 Oct 31 2:00 AM
Hi,
I am trying to create a report screen with dynamics call....
I have a Sales Order select-option no interval and no extension
then i have few Parameters below such as
Customer Name, Part No, Material...
Whenever i select a SO, the screen will refresh and the value Customer Name, Part No and Material will reflects based on my selected SO.
Any experts can tell me, how can i do this..can it be done in normal report screen or needed dialog programming.............
urgently needed
Thanks
Maybe below is what you are looking for, though the requirement doesnt really make any sense to me.
tables: vbak, vbap.
select-options: s_vbeln for vbak-vbeln no intervals no-extension modif
id ABC.
parameters: p_kunnr like vbak-kunnr,
p_matnr like vbap-matnr.
at selection-screen output.
if not s_vbeln[] is initial.
select a~kunnr b~matnr into (p_kunnr, p_matnr)
from vbak as a
inner join vbap as b
on a~vbeln = b~vbeln
where a~vbeln in s_vbeln.
endselect.
endif.Kind Regards
Eswar
2006 Oct 31 3:05 AM
Maybe below is what you are looking for, though the requirement doesnt really make any sense to me.
tables: vbak, vbap.
select-options: s_vbeln for vbak-vbeln no intervals no-extension modif
id ABC.
parameters: p_kunnr like vbak-kunnr,
p_matnr like vbap-matnr.
at selection-screen output.
if not s_vbeln[] is initial.
select a~kunnr b~matnr into (p_kunnr, p_matnr)
from vbak as a
inner join vbap as b
on a~vbeln = b~vbeln
where a~vbeln in s_vbeln.
endselect.
endif.Kind Regards
Eswar
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |