topic select statement in Application Development and Automation Discussions

select statement

Former Member — Mon, 07 Jul 2008 05:24:28 GMT

hi frnds,

in transaction va02 there is a tab on the screen "ADDITIONAL DATA B" having

fields:-

1) Term Start Date: vbak-zzstart

2) Term End Date: vbak-zztend

3) License Type: vbak-zzltype

4) Contract Number: vbak-zzcontno

5) Product Discount: vbak-pdisc

6) Maintenance Discount:vbak-zzmdisc

i want to display the values of this fields on the report with respect to sales ordre number

vbak-vbeln.

plz help me how to write the code for this.

its really urgent i have tried but i cld nt.

thnx

Re: select statement

Former Member — Mon, 07 Jul 2008 05:28:43 GMT

Danial,

select-optoins:s_vbeln for vbak-vbeln.
data:itab lke vbak occers 0 with header line.
select zzstart zztend zzltype
          zzcontno pdisc  zzmdisc from vbak
      into corresponding field of itab where vblen in s_vbeln.

Re: select statement

Former Member — Mon, 07 Jul 2008 05:29:29 GMT

Hi,

GO to the additional tab.

From System-> Status -> select the screen number.

DOuble click this and go to the PBO event. Since this subscreen is in the customer namespace, you can edit the code.

Write a stmt..INCLUDE disp_values. Double click on this and create the include program and write logic to read the values from the tables you need.

Regards,

Subramanian

Re: select statement

Former Member — Mon, 07 Jul 2008 05:34:28 GMT

Hi,

Since this is a SAP standard transaction, you will find these values are saved in ABAP memory.

You have to debug the VA02, to find out which are the parameter IDs that they are using.

For example for material number SAP uses MAT.

Reward if helpful.

regards,

Prosenjit.