How to link structure and table in Smartform

[Former Member]

Hi all.

Can we use structure to get data in Smartform?

I need to create Subcon form. My MM consultant said some data I need to pull from structure.

And from structure, I need to link to its table.

The problem is, I dont know how to link structure and table and how to pull the data.

Can anyone help me regarding this scenario.

Thanks in advance.

az

[Former Member]

Hi ,

We cant get the data from the strucutures, your MM consultant has given it as the reference, Pleas try to find the database field corresponding to that structure field,

One way is please check the value table of the field, it might be usefull

Reward if Usefull

Karthick.

[Former Member]

Hi Karthick.

I know that we cant get data from structure. The consultant said I need to link to related table from the structure.

The problem is, how we'd know which table and field is correct for particular field in structure.

Thanks

az

[Former Member]

hi,

to add to my above create a table in smart form goto main area and create a text then in that write &wa_itab-empno&. here empno is an example it is a field to be retrieved from the database table

regards,

sreelakshmi

[Former Member]

Hi sreelakshmi

Thanks for the steps. I'll try this way and i'll come back if there's any problem.

Thanks so much.

az

[Former Member]

hi,

create a structure and then include the structure in table by using .include.

in smartforms

goto form inter face doble click select tables and declare itab type zemp_det

goto global definitions doble click select global data and declare wa_itab like zemp_det

create a progarm and write the following code.

DATA: itab LIKE zemp_det OCCURS 0 WITH HEADER LINE.

CALL FUNCTION '/1BCDWB/SF00000093'

.

here 1BCDWB/SF00000093 is the fm generated by the smart form then after calling fm assign

TABLES

itab = itab

regards,

sreelakshmi