Friends need help

Former Member — Fri, 08 Jun 2007 04:44:08 GMT

I need to fetch company code for outbound movement of material.

currently I am picking up LIKP-KKBER for that,

But sometimes its not mainted so I am not getting Company code. So is there any other table from which I can get this.

Please not its only for movement types 601, 901, and 931

thanks

Re: Friends need help

Former Member — Fri, 08 Jun 2007 04:48:22 GMT

Hi,

Yes..there are two options..

1) use LIKP-VKORG to get the company code from the table TVKO..

SELECT SINGLE * FROM TVKO WHERE VKORG = LIKP-VKORG.

WRITE: / 'Company code', TVKO-BUKRS.

2) Use the table MSEG to get the company code for that material document.

SELECT SINGLE * FROM MKPF WHERE XBLNR = LIKP-VBELN.

SELECT SINGLE * FROM MSEG WHERE MBLNR = MKPF-MBLNR.

WRITE: / 'Company code', MSEG-BUKRS.

Thanks,

Naren