Master tables for Order

[Former Member]

Hi,

In creation of MAINTENANCE ORDER, I need to create a Search help for Work Center and Plant based on :

1. Order type

2. Planning plant

3. Business area

Could you help me out by letting me know what are the master tables having these fields.

Regards,

Srilakshmi B

[Former Member]

Hi Lakshmi,

there is a standard Search help called RMAN_PRSP_ARBPL which is having work center ARBPL and plant WERKS as the fields. you can use the same for your requirement using MODIF ID.

For order master tables AUFK AFRV AFKO

Regards

SHiva

[gopi_narendra]

* Validate Work Centre
  if not ZES_PO_ITEM-ST_ARBPL is initial.
    clear : T399X.
    select single * from T399X where WERKS = ZES_PO_ITEM-ST_SWERK
                                 and AUART = ZES_PO_ITEM-ST_AUART.

    if SY-SUBRC = 0.

      call function 'CR_WORKSTATION_READ_ROUTING'
        exporting
          ARBPL = ZES_PO_ITEM-ST_ARBPL
          DATE  = SY-DATUM
          PLNTY = T399X-PLNTY
          WERKS = ZES_PO_ITEM-ST_SWERK."L_SWERK. "Changed on 27th Feb

      if SY-SUBRC <> 0.
        message E138(ZSM) with 'Work Centre not maintained for plant' ZES_PO_ITEM-ST_IWERK.
      endif.
    endif.
  endif.

Regards

Gopi

[Former Member]

Hi Lakshmi,

there is a standard Search help called RMAN_PRSP_ARBPL which is having work center ARBPL and plant WERKS as the fields. you can use the same for your requirement using MODIF ID.

For order master tables AUFK AFRV AFKO

Regards

SHiva

[Former Member]

Hi,

The fields

1. Order Type &

2. Business area

are present in the table AUFK.

U can find the above 2 fields in that table.

Thank you,

Chandra Prakash