topic Re: Specific tables behind IW38 in Application Development and Automation Discussions

Specific tables behind IW38

former_member295881 — Mon, 05 Nov 2012 13:13:51 GMT

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.

Re: Specific tables behind IW38

Former Member — Mon, 05 Nov 2012 14:57:36 GMT

Hi,

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

Thanks,

Anubhav

Re: Specific tables behind IW38

former_member295881 — Mon, 05 Nov 2012 15:14:48 GMT

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?

Re: Specific tables behind IW38

RaymondGiuseppi — Mon, 05 Nov 2012 15:15:46 GMT

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

Re: Specific tables behind IW38

Former Member — Mon, 05 Nov 2012 15:44:24 GMT

Hi,

Didnt you get VAPLZ in AUFK??

Append Structure - AD02AUFK has two fields one being VAPLZ.

Thanks,

Anubhav

Re: Specific tables behind IW38

former_member295881 — Mon, 05 Nov 2012 15:51:32 GMT

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

Re: Specific tables behind IW38

Former Member — Mon, 05 Nov 2012 16:31:13 GMT

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

Re: Specific tables behind IW38

former_member295881 — Mon, 05 Nov 2012 17:30:01 GMT

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

Re: Specific tables behind IW38

Former Member — Mon, 05 Nov 2012 18:17:09 GMT

Glad it worked!!

Thanks,

Anubhav