topic Re: SMARTFORMS in Application Development and Automation Discussions

SMARTFORMS

Former Member — Wed, 05 Jul 2006 13:33:33 GMT

how to give link between diffrent tables like kna1,vbak,vbap with in a smart form

Former Member — Wed, 05 Jul 2006 13:36:14 GMT

You will have fetch the data uisng the conditions like this

KNA1-KUNNR = VBAK-KUNNR

VBAK-VBELN = VBAP-EBELN.

You will have to fetch the data using selects and display the data in the form.

Regards,

Ravi

Note : Please mark all the helpful answers

Former Member — Wed, 05 Jul 2006 13:39:34 GMT

hi Sai,

Use select Statements using KUNNR as a primary field ..

Regars,

Santosh

Manohar2u — Wed, 05 Jul 2006 13:40:24 GMT

Link between KNA1-KUNNR and VBAK-KUNNR.

Regds

manohar

Former Member — Wed, 05 Jul 2006 14:07:00 GMT

Hai Sai

you can use Kunnr as key field

that is

select -

where kna1-kunnr = vbak-kunnr and

vbak-vbeln = vbap-vbeln.

Thanks & regards

Sreeni

Former Member — Wed, 05 Jul 2006 14:42:09 GMT

good

you can give the link between two table in this process

go to smart form window

click on global definition

here in the type tag you can give the link between the tables

thanks

mrutyun