2007 Jul 24 8:44 AM
hi all,
what is the use of table KSSK.
what is the relation between MATNR and OBJEK.
vkr.
2007 Jul 24 8:47 AM
Hi
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
2007 Jul 24 8:47 AM
Hi
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
2007 Jul 24 8:56 AM
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.
2007 Jul 24 8:49 AM
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.
2007 Jul 24 8:51 AM
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!
2007 Jul 24 8:55 AM
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