Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SMARTFORMS

Former Member
0 Likes
608

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

5 REPLIES 5
Read only

Former Member
0 Likes
564

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

Read only

0 Likes
564

hi Sai,

Use select Statements using KUNNR as a primary field ..

Regars,

Santosh

Read only

Manohar2u
Active Contributor
0 Likes
564

Link between KNA1-KUNNR and VBAK-KUNNR.

Regds

manohar

Read only

Former Member
0 Likes
564

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

Read only

Former Member
0 Likes
564

hi

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