topic Re: relation between tables in Application Development and Automation Discussions

relation between tables

Former Member — Wed, 20 Sep 2006 18:42:40 GMT

Hi friendz,

i am working on smartform

i need to retreive the data from the below given tables.

i tried to find the relationship between these tables but not able to find .

could u plz suggest me what may b the relation between these three tables.

Must have the ability to print a handling unit label for each completed handling unit printing the following fields:

Handling Unit number (VEKP-EXIDV)

Process order Number (VEVW-OBJKEY or strip the first seven digits of the HU number)

Phase Description (Read AFVGD-LTXA1 for process order number and phase equal last four digits of HU number)

regards,

siri.

Former Member — Wed, 20 Sep 2006 18:43:29 GMT

Hi friendz,

i am working on smartform

i need to retreive the data from the below given tables.

i tried to find the relationship between these tables but not able to find .

could u plz suggest me what may b the relation between these three tables.

Must have the ability to print a handling unit label for each completed handling unit printing the following fields:

Handling Unit number (VEKP-EXIDV)

Process order Number (VEVW-OBJKEY or strip the first seven digits of the HU number)

Phase Description (Read AFVC-LTXA1 for process order number and phase equal last four digits of HU number)

regards,

siri.

Former Member — Wed, 20 Sep 2006 19:27:13 GMT

Hi,

Check the relations...

vewp-venum = vevw-handle

vevw-object = resb-objnr

afvc-aufpl = resb-aufpl

afvc-aplzl = resb-aplzl

afvc-arbid = vevw-object

Regards,

Azaz Ali.