cancel
Showing results for 
Search instead for 
Did you mean: 

which field combination makes unique key between vbap and mseg

Former Member
0 Kudos

Hi

i have to join vbap and mseg.Matnr is one common field but not unique key.

with matnr , on which fied i could put join to make unique key combination .

Regards,

ranu

Edited by: ranu sharma on Oct 3, 2009 11:48 AM

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

There are some fields which are inc ommon between VBAP & MSEG like,

WERKS, LGORT, VBELN, KDAUF

VBAP-VBELN is equal to MESG-KDAUF.

please check those fields, MSEG is the table for theMaterial document created after the PGI, The data will flow to Material document from both sales order and delivery.

regards,

santosh

Former Member
0 Kudos

HI,

VBAP-VBELN = MSEG-KDAUF

REGARDS

RAJ.

Former Member
0 Kudos

vbeln is reapeting many times in vbap.

I want 1 to 1 relationship between vbap and mseg or vbep and mseg.

Former Member
0 Kudos

Combination of MSEG-KDPOS and MSEG-KDAUF with VBAP-VBELN and VBAP-POSNR.

If this is not your requirement, then not possible is the answer.

Lakshmipathi
Active Contributor
0 Kudos

Check in SQVI where it will automatically table join the unique fields.

thanks

G. Lakshmipathi