Relation between EQUI / KSSK / AUSP - need missing link ?

[Former Member]

Hi guys!

I'm playing around with the three mentioned tables.

But i can't find the relation between these tables.

KSSK and AUSP haven an OBJEK as key

EQUI a OBJNR

How can i get to the AUSP and KSSK data with my objnr from the equipment`??

once more, i need the kssk and ausp data, what i have is a equipment key.

I need to know the connections between the tables.

thanks!!

[Former Member · Accepted solution]

But

EQUI-OBJNR not equal KSSK-OBJEK or AUSP-OBJEK

so there must be "something between"

[Former Member · Accepted solution]

Go to Function module

BAPI_OBJCL_GET_KEY_OF_OBJECT.

Enter the Equipment details, and get the OBJEK (Object Key) and the check tables KSSK and AUSP

[Former Member · Accepted solution]

In the BAPI Provide Object table as "EQUI"

[Former Member · Accepted solution]

Are you able to get details now.

[Former Member]

i found it, its all in the table INOB

thanks for your help

[Former Member]

yes thanks, that works.

and do you also know a bapi to convert a OBJEK to a OBJNR of the Equi?

[Former Member]

can you tell me the details for converting the objek to objnr

[Former Member]

Thanks!

but which key i need to read the AUSP and KSSK data, when i have an EquipNr ?

[Former Member]

Or try getting the data with CLFM_SELECT_AUSP.

All required data for selection can be found in KSSK.

Edited by: Maen Anachronos on Oct 9, 2008 10:30 AM

[Former Member]

Have you got the OBJEK (Object number corresponding to the Equipment), if yes then this will be the key to both the tables.

[Former Member]

Hi,

If a class/values is assigned to a material/equipment, a entry is put into KSSK table (meaning that class is assigned), and the respective characteristic values of that material/equipment is stored in AUSP table.

Thanks & Regards,

Navneeth K.