RELATION BETWEEN TABLES

Former Member — Wed, 20 Sep 2006 18:44:31 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.

Re: RELATION BETWEEN TABLES

Former Member — Wed, 20 Sep 2006 19:26:41 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.