topic Master tables for Order in Application Development and Automation Discussions

Master tables for Order

Former Member — Mon, 18 Jun 2007 04:19:15 GMT

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

Re: Master tables for Order

gopi_narendra — Mon, 18 Jun 2007 04:26:08 GMT

* 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

Re: Master tables for Order

Former Member — Mon, 18 Jun 2007 04:36:25 GMT

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

Re: Master tables for Order

Former Member — Mon, 18 Jun 2007 04:49:31 GMT

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