relation between tables

[Former Member]

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 (<b>VEKP-EXIDV</b>)

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

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

regards,

siri.

[Former Member]

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]

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.