MARC-SOBSK pulling?

[Former Member]

Hi Experts,

I need to pull the data of SOBSK, (so its in MARC in table).

I hv MATNR in my hand.

1) Is it enough to hv MATNR to pull the SOBSK values from MARC? <b><i>(select sobsk into my_sosk where matnr = itab-matnr)</i></b>

2) Or WERKS is also mandatory?

3) Any other ideas?

ThanQ.

[Former Member]

Hi,

It depends on the requirement..

If you have plant also ...Then give the plant..As it makes to a full key in the where clause..

Thanks,

Naren

[Former Member]

ThanQ Naren,

No, I dont hv the WERKS-Plants data in my hand (I hv VBELN, POSNR, etc. some VBAK, VBAP, VB Flow table related data). So, What I mean that, If I give only MATNR in WHERE cluse in my SQL, Does it pull correct data from MARC?

ThanQ.

[Former Member]

Hi,

You can still give matnr alone..It will bring you all records for that material..You can choose the first one to get the MARC-SOBSK...

Also if you have VBAP data..you will be having the plant also..VBAP-WERKS.

Thanks,

Naren

[Former Member]

ThanQ.

Let me try.

[Former Member]

ThanQ.