Retreving purchasing group

[Former Member]

Hi,

i'm trying to retrieve VMI purchasing group based on product and location which can be viewed under snp2 tab under product master. let me know if i can retreive the value directly from DB tables.

Regards,

kumar

[Former Member]

Hi Kumar

the field name is /SAPAPO/VEGRP that you can find in table /SAPAPO/MATLOC. But, the Product location in these tables are in GUIDS unlike in R3

You might have to write a Query in SQ02 and use MATID and LOCID keys from /SAPAPO/MATKEY and /SAPAPO/LOC and /SAPAPO/MATLOC to get a full read of these values.

If it is a one time extract, You can also use MASSD (carefully) to read these values

[Former Member]

Hi Kumar - if you are unable to use guids (ie you are not developing) then there is a view /sapapo/v_matloc where you can enter product and location to view the vegrp field.

Hope this helps.