Equipments By Class

[Former Member]

I want to download equipments field EQUNR,Class type Klart and Class Number field Class.

I have tried to use the Equipment Master table EQUI an the Class table KLAH, but i have no way to link these two tables.

Also tried to use logical database EQI but fr small samples its working but is i try to download all equipments its timing out.

Please help with te relean tables or sample code.

[Former Member]

Hi,

Write a join on AUSP,KSML and KLAH tables.

This will give the list of classes assigned to all the equipments.

From AUSP table, we get the equipments(AUSP-OBJEK) and their corresponding characteristics(AUSP-ATINN) by giving KLART = 1.

Using the ATINN, go to KSML table and get Class number(KSML-CLINT) for KSML-IMERK = AUSP-ATINN.

Using CLINT, go to KLAH table and get the class name(KLAH-CLASS)

Reward points if found useful...!

Cheers

Abhishek

[Former Member]

Hi,

Get the EQUNR from EQUI table, if it is not prefixed by zero, use Conversion_exit_alpho_input to prefix zeroes.

pass this EQUNR to the OBJEK field of AUSP table (pass 002 to KLART) and get the ATINN value.

This is the internal value to get the external value, pass this ATINN to the CABN table and get the ATNAM.

Hope this works . Is this what you were looking for.

Regards

Subramanian

[Former Member]

My EQUNR and Object Number are different.So i cannot link EQUI and KLAH or any table with Object number with tte Equnr