How to get work center list by plant

[Former Member]

Hi,

Is there BAPI for work centre list?

I wrote a SQL statement to get the list as below:

select H.WERKS as PlantCode,

          H.ARBPL as WorkCenter,

          H.VERWE as Category,

          D.KTEXT as Description,

          H.AEDAT_GRND as LastModifiedDate

from tid.CRHD H

left join tid.CRTX D on D.OBJID = H.OBJID

where H.MANDT='800'

   and D.MANDT='800'

   and D.SPRAS='E'

   and IsNull(H.ARBPL,'')<>''

   and H.WERKS='1000'      --PlantCode

order by H.WERKS, H.ARBPL

I need this list, but I don't know how to get this result using JCo3.

Any suggestions?

[Former Member]

Hi,

As per your reply it seems that you have already written code to get the list in ABAP. Create Function Module and copy this whole code there.

After then enable  FM as a RFC FM. This RFC FM you can call from you JCO.

Best Regards,

Utkarsh