topic Re: MARC-SOBSK pulling? in Application Development and Automation Discussions

MARC-SOBSK pulling?

Former Member — Fri, 04 May 2007 21:16:48 GMT

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.

Re: MARC-SOBSK pulling?

Former Member — Fri, 04 May 2007 21:21:11 GMT

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

Re: MARC-SOBSK pulling?

Former Member — Fri, 04 May 2007 22:20:03 GMT

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.

Re: MARC-SOBSK pulling?

Former Member — Fri, 04 May 2007 23:11:24 GMT

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

Re: MARC-SOBSK pulling?

Former Member — Fri, 04 May 2007 23:13:00 GMT

ThanQ.

Let me try.

Re: MARC-SOBSK pulling?

Former Member — Sat, 05 May 2007 00:25:58 GMT

ThanQ.