topic smartforms problem in Application Development and Automation Discussions

smartforms problem

Former Member — Fri, 05 Jan 2007 18:35:17 GMT

Hi,

i have developed a form with zprogram for driver program. I am having trouble in displaying the fields which i wanted to populate in the form

My primary key is vttk-tknum (transportation number)

and my select statements are like this

BEGIN OF SLK OCCURS 0

INCLUDE STRUCTURE VTRLK.

END OF SLK.

SELECT VBELN FROM VBAK

INTO (VBAK-VBELN)

WHERE VBELN = SLK-VBELN.

SELECT SINGLE NAME1

STREET

HOUSE_NUM1

STR_SUPPL1

CITY1

POST_CODE1

COUNTRY

FROM ADRC

INTO (ADRC-NAME1, ADRC-STREET, ADRC-HOUSE_NUM1, ADRC-STR_SUPPL1, ADRC-CITY1, ADRC-POST_CODE1, ADRC-COUNTRY)

WHERE ADDRNUMBER = SLK-ADDRNUMBER.

SELECT SINGLE NAME1

LAND1

ORT01

REGIO

STRAS

FROM KNA1

INTO (KNA1-NAME1,KNA1-LAND1,KNA1-ORT01,KNA1-REGIO,KNA1-STRAS)

WHERE KUNNR = SLK-KUNNR.

can some one help me in this ?

Re: smartforms problem

Former Member — Fri, 05 Jan 2007 19:10:43 GMT

Hi,

Can you explain the problem in displaying fields in detail ?

Regards,

Mukul

Re: smartforms problem

Former Member — Fri, 05 Jan 2007 19:26:35 GMT

say i need to display fields of KNA1, for input parameter vttk-tknum, when i select these fields using this select statement its giving me different KNA1 field values rather than one i required.

Re: smartforms problem

Former Member — Fri, 05 Jan 2007 19:34:44 GMT

Hi,

Can u plese tell me what are the fields u need to pick up ?

Regards,

Mukul

Re: smartforms problem

Former Member — Fri, 05 Jan 2007 19:38:25 GMT

NAME1,

STRAS,

MCOD2

MCOD3

LAND1

TELF1

TELFX

FOR KNA1

namev, name1 for knvk table

name1, street, house_num1, str_suppl1, city1, country post_code1 for adrc table

vbeln for vbak table

/cwm/pikmg, /cwm/pikme for lips table