topic Re: foregin key relationship in Application Development and Automation Discussions

foregin key relationship

Former Member — Wed, 25 Apr 2007 08:38:20 GMT

for sales order vbeln is foreign key and vbuk is check table.what i say is correct or not plz reply to me.

Former Member — Wed, 25 Apr 2007 08:41:17 GMT

Hi Naga,

u r correct.

Regards,

Prasad

Former Member — Wed, 25 Apr 2007 08:43:20 GMT

Hello

u are right.... VBELN is a field of VBAK... and that field is foreign key of VBUK table....means its check table.

Thanks...

Former Member — Wed, 25 Apr 2007 08:43:21 GMT

Hi,

Maybe like this..

If you see in point of view from VBAK, then VBAK-VBELN was the primary key.

If you see in point of view from VBUK, then VBAK-VBELN was the foreign key for VBUK-VBELN.

Best Regards,

Victor.

Former Member — Wed, 25 Apr 2007 08:43:54 GMT

Naga,

VBELN is a Primary Key and VBUK is the Check table

Pls. reward if useful...

Former Member — Wed, 25 Apr 2007 08:44:01 GMT

Hi Naga,

The VBELN field have the Foreign key Relationship with the VBUK table. So Surely its the check table for the field VBELN.

Thanks.