cancel
Showing results for 
Search instead for 
Did you mean: 

tables for the fields present in ie02 transaction in pm module

Former Member
0 Kudos

Hi,

Please guide me the tables for the fields present in ie02 transaction of pm module. i am new to the pm module.

Regards,

Mastan.

Accepted Solutions (1)

Accepted Solutions (1)

former_member208398
Active Contributor
0 Kudos

Hello Mastan,

Generally I use the following methods:

1. F1 help, technical information.

2. SCN search, generally I find all the necessary table fields have been discussed till date.

3. SQL trace through ST05.

4. Go to SE11, input the structure name and click on display. Press Ctrl + Shift + F5 'Display Object List'. Then I use the hierarchy on left and find the database tables, and search each of them along with the field name.

Please try these methods, they have helped me a lot till date.

Good Luck,

Rajen

Former Member
0 Kudos

Hi Rajen Madan,

Thank You Madan.You have helped a lot. Could you please provide me the logic for the Class, Which is present in ie02,General Tab. I got the below structure


class field  find structure ITOBATTR (KLASSE). please help me. Then i can close the thread. please help me Madan.


Regards,

Mastan.



Former Member
0 Kudos

Mastan,

Follow the below tables for class with Equipment assignment.

AUSP

ITOB

In AUSP put the equipment number as object ID, you will get all the classification details in that.

former_member208398
Active Contributor
0 Kudos

Mastan,

This is related to equipment to class link.

KSSK-KLART = 002 (generally, equipment class),KSSK-OBJEK = (leading 0's + Equipment number, total 18 character); extract KSSK-CLINT.

KLAH - CLINT = KSSK - CLINT, KLAH - KLART = KSSK-KLART, extract KLAH-CLASS.

Also check AUSP table to get characteristic values.

All of these were already available in SCN.

Best Regards,

Rajen

Former Member
0 Kudos

Hi Rajen Madan,

Thank You alot. You have given excellent help to me in each and every field. The answers you have given for every field is correct. The total blog you have given is working fine. Thanks a lot Madan.

And thanks to all Anupam sharma and caetano almeida , SP. I am closing this thread.

Answers (3)

Answers (3)

Anupam1143
Active Contributor
0 Kudos

Hi Mastan,

I hope if you would have searched the forum then you will get a lot of threads on the same topic.Anyways please check this document:

http://wiki.scn.sap.com/wiki/display/ERPLO/Useful+Tables+-+PM+Module

Regards,

Anupam Sharma

Former Member
0 Kudos

Hi Anupam sharma, Rajen Madan and caetano almeida,

Thanks for the reply.

I am not able to find the table for standard text key field in IE02 transaction. i am getting EFHM Structure. In this i am getting this field. i want to get the report with input equipment number. This equipment number getting from EQUI table. please guide me the logic from EQUI to Standard text key.

2) And table for sort field and Location in IE02 getting from ILOA table. But this fields, i am getting with input object type only. But i want to write the logic with euipment number from EQUI table to sort field and Location.For this How to write the logic, please guide me.

3) table for work center field present in ie02. I am having the structure ITOBATTR. please guide me the logic for the workcenter and equipment number from EQUI table. Iam attaching the below screenshots of IE02 for fields.

Regards,

Mastan.

former_member208398
Active Contributor
0 Kudos

Hello Mastan,

Location:

EQUZ-ILOAN = ILOA - ILOAN, extract ILOA-STORT.

Sort Field:

EQUZ-ILOAN = ILOA - ILOAN, extract ILOA-EQFNR.

Work Center:

EQUZ-ILOAN = ILOA- ILOAN, extract ILOA-PPSID. ILOA-PPSID = CRHD-OBJID. Extract CRHD-ARBPL.

Please try again with single equipment master with all fields maintained. Search for the field name obtained from F1 in the relevant tables like EQUI, EQUZ, ILOA etc.

Best Regards,

Rajen

Message was edited by: Rajen Madan

Former Member
0 Kudos

Thank you very much Rajen Madan,

The logic you have given is correct and at the same time may i know the logic for standard text key field. which is rounded in screenshot. I am trying for that and got EFHM structure- KTSCH and class field find structure ITOBATTR (KLASSE). please help me.

Regards,

Mastan.

former_member208398
Active Contributor
0 Kudos

Hello Mastan,

CRVE_B, input equipment number, extract CRVE_B-OBJTY and CRVE_B-OBJID.

CRVE_B-OBJTY = CRFH-OBJTY, CRVE_B-OBJID = CRFH-OBJID. Extract CRFH-KTSCH.

Please share the spreadsheet that you are preparing (you can attach in XML format), will be helpful.

Kindly update/ close the thread if your query has been answered.

Best Regards,

Rajen

former_member208398
Active Contributor
0 Kudos

Hello,

Please search in the forum more before posting a discussion thread.

Along with the suggestions that you will get from the forum, go to SE16N, in the table name field provide EQ* and press F4.

Take one equipment master and map the fields in a spreadsheet. That can be very useful.

Best Regards,

Rajen

Caetano
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Mastan

There is an easy way to find out the table for a transaction.

- Go to transaction ST05 and activate the SQL trace.

- Run the transaction.

- Go back to ST05 and check the trace results to find which tables were selected.

BR

Caetano