topic Re: please help out in Application Development and Automation Discussions

please help out

Former Member — Sat, 27 Jan 2007 05:49:12 GMT

Hi all,

my selection screen consists of following filelds:

billing document no:(vbrk-vbeln) -->obligatory

vat regestration no: (vbrk-stceg)

billing date(vbrk-fkdat)

company code (t001-bukrs) --> obligatory.

the requirement is,by giving the billing document no. and company code as input,i should get the data in rest of the two fields dynamically.

Waiting for reply.

regards

akmal

Re: please help out

anversha_s — Sat, 27 Jan 2007 05:55:44 GMT

hi,

you can fill these fields in.

At selection-screen

Event.

use simple select queries and fill the above fields inside this event.

Regards

Anver

Re: please help out

Former Member — Sat, 27 Jan 2007 06:00:55 GMT

write code like this

at selection-screen on p_bukrs. <or vbeln>

select single stceg fkdat into p_stceg p_fkdat where vbeln = p_vbeln and bukrs = p_bulrs.

just put that code and after giving entry in those fields press enter and check whether the data is filled to rest of two fields or not.

here all the things are parameters.

regards

shiba dutta

Re: please help out

Former Member — Sat, 27 Jan 2007 09:31:59 GMT

Hi,

In the

At Selection-screen on p_bukrs . [ assuming co.code is a parameter field ]

clear: p_stceg, p_fkdat.

select single stceg fkdat into (p_stceg,p_fkdat)

from vbrk where vbeln = p_vbeln

and bukrs = p_bukrs. [ chk if vbrk has co.cde]

Regards

Subramanian

Re: please help out

Former Member — Sat, 27 Jan 2007 11:19:53 GMT

Hello Akmal,

Check the following code

PARAMETERS: p_bukrs LIKE t001-bukrs OBLIGATORY,

p_vbeln TYPE vbrk-vbeln OBLIGATORY,

p_stceg LIKE vbrk-stceg MODIF ID dis,

p_fkdat LIKE vbrk-fkdat MODIF ID dis.

TABLES: VBRK.

AT SELECTION-SCREEN OUTPUT.

LOOP AT SCREEN.

IF screen-group1 = 'DIS'.

screen-input = 0.

MODIFY SCREEN.

ENDIF.

ENDLOOP.

AT SELECTION-SCREEN ON P_vbeln.

SELECT SINGLE stceg INTO p_stceg FROM vbrk WHERE vbeln = p_vbeln

AND bukrs = p_bukrs.

SELECT SINGLE FKDAT INTO p_FKDAT FROM vbrk WHERE vbeln = p_vbeln

AND bukrs = p_bukrs.

This will work out.

Reward point if helped.

Best Regards

Renjan