Specific tables behind IW38

[former_member295881]

Hi,

I'm writing a custom report similar to IW38. According to the requriment I need to provide the following filters and then select data (these are also used in TCODE - IW38)

Order Type

Period

Main Work Center

Can anybody tell me table name which contains the above fields from TCODE(IW38).

Many thanks in advance.

[Former Member]

Hi,

Check Order master data table AUFK. Fields AUFNR, AUART, VAPLZ.

Thanks,

Anubhav

[former_member295881]

Hi Anybhav,

Many thanks for your input. In AUFK I only found Order Type AUFK-AUART but not Period and Main Work Center fields. Any clue where they might be?

[Former Member]

Hi,

Didnt you get VAPLZ in AUFK??

Append Structure - AD02AUFK has two fields one being VAPLZ.

Thanks,

Anubhav

[former_member295881]

Yes I just got it but still not sure what are Period dates (From and To) because there is many dates available in tables.

[Former Member]

Hi,

I dont think you'll get these dates directly in SAP. Period specifies a range (to be given in the selection screen) based on which you have to filter data. For example, if your report shows all the orders which were created in a range 01.01.2012 to 31.01.2012 (Period) then use field AUFK-ERDAT in the where condition of the Select statement as below -

Select <fields>

from AUFK

into table <internal table>

where ERDAT >= Period-low (which is 01.01.2012)

and    ERDAT <= Period-high (which is 31.01.2012).

See the F1 help on Period in IW38 -

In the case of notifications and orders, the reference date must fall in the selection period.

The respective reference dates are as follows:

• for notifications, it is the notification date
• for completed orders, it is the reference date of the order completion
• for orders not completed, it is the order start date

Get in touch with your functional that for what type of records you need to filter data based on Period dates. Accordingly use AUFK-ERDAT or AUFK-AEDAT or AUFK-IDAT3 etc.

Hope this brings some clarity now.

Thanks,

Anubhav

Thanks,

Anubhav

[former_member295881]

Anybhav, many thanks for all your input. I must say it's a big help Sir.

[Former Member]

Glad it worked!!

Thanks,

Anubhav

[RaymondGiuseppi]

Check following tables

• AUFK "Order master data"
  • AFIH  "Maintenance order header" (aufnr = aufk-aufnr)
    • ILOA "PM Object Location and Account Assignment" (iloan = afih-iloan)
  • AFKO "Order header data PP orders" (aufnr = aufk-aufnr)
    • AFVC "Operation within an order" (aufpl = afko-aufpl)
  • etc.

Look at definition of fields like AFIH-ADDAT and AUFK-VAPLZ.

For more fields, press F1 on parameter of IW38, display "technical information", note screen field name and perform a where-used in source of RIAUFK20.

Regards,

Raymond