Work Center name in query

[Former Member]

In a query i am making, how do i extract the work center name, that is located in another table? KBED - ARBID is the work center ID (ex. 10000002). how do i link this to another table, which contains the work center name?

[Former Member · Accepted solution]

In Table CHRD_V1 u can get both OBJID - object ID for work centre and ARBPL - Work Centre Code. and KTEXT - Work Centre Name

[Former Member]

you link crhd-objid , you find the work center or if you want against production order then use table s022 , there you find operation no & work center.

thanks

naveen mittal