topic Re: TABLE in Application Development and Automation Discussions

TABLE

Former Member — Tue, 24 Jul 2007 07:44:28 GMT

hi all,

what is the use of table KSSK.

what is the relation between MATNR and OBJEK.

vkr.

Re: TABLE

Former Member — Tue, 24 Jul 2007 07:47:27 GMT

KSSK --is the assignment of OBJECT to CLASS table

Both fields MATNR and OBJEK may be same some times

not always..( of different data types)

<b>Reward points for useful Answers</b>

Regards

Anji

Re: TABLE

Former Member — Tue, 24 Jul 2007 07:49:00 GMT

Table KSSK is the Object to Class allocation table. It will only tell me which classes are associated with a functional location.

What I'm looking for is the Characteristic Values that are associated with the classes allocated to my functional location.

For example, functional location DE-51-110-0082-0083 (this is a school) is assigned classes 10 and 11 in table KSSK.

Class 10 has Characteristics 1 (Square footage) associated with it, with a numeric value. There is an entry in table AUSP, but that numeric value does not appear, field ATWRT is blank.

Class 11 has Characteristic 3 (Board Member Constituency) associated with it, with a value of "District 3" which does appear in ATWRT.

<b>rewards if find useful.</b>

thanks,

Abhay.

Re: TABLE

Former Member — Tue, 24 Jul 2007 07:51:24 GMT

Hi,

It is Allocation Table: Object (vb.matnr) to Class

It is for Characteristics and link to the perticular class.

You can refer: KLAH,KSML

Reward if useful!

Re: TABLE

Former Member — Tue, 24 Jul 2007 07:55:45 GMT

KSSK is Allocation Table: Object to Class

First join the table KSSK with INOB ()

KSSK - MANDT = INOB - MANDT

KSSK - OBJEK = INOB - CUOBJ

KSSK - KLART = INOB - KLART

and then get the corresponding MATNR from INOB table.

reward if useful

anju

Re: TABLE

Former Member — Tue, 24 Jul 2007 07:56:33 GMT

HI reddy,

But here the length of these two are diffrent.

matnr-18.

objek-50.

my prob is i need to fetch CLINT from KSSK based on(where objek eq matnr)this condition.

help me...

vkr.