We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-dev] Which Table Stores the Selected Values of a Characteristic in Material Classification?

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from Aritra on Dec 23 at 1:06 AM
Yes, the AUSP gives the required values. I was filtering on just the OBJEK and characteristic ATINN. I also added the LKENZ = space (deletion indicator not set) and was able to arrive at the correct set of selected characteristic values.
Thanks again for your replies.

---------------Original Message---------------
From: Aritra Biswas
Sent: Friday, December 20, 2013 8:44 AM
Subject: Which Table Stores the Selected Values of a Characteristic in Material Classification?

Hi all,

I am in the classification view of material master, looking at the configuration profile. There is a class assigned, and its values are displayed in the 'General' tab below.

On selecting any of the characteristic descriptions, I am able to see the values which have been selected having a check mark against them. I need to know which table stores these 'check marks', so I can fetch the same in a program I am developing.

My current logic is:
Query INOB and get CUOBJ where OBJEK = MATNR
Query KSSK and get CLINT where OBJEK = INOB-OBJEK
Query KSML and IMERK where CLINT = KSSK-CLINT
Query CAWN and fetch ATINN where ATINN = KSML-IMERK

The last query is fetching the characteristic values. Problem is that its fetching ALL the values for every characteristic, whereas I need only the ones that have been selected in the classification.

Regards
Aritra

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2013 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
Aritra  

achievements
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Have a technical question? Need to find IT solutions? Ask your peers in the Toolbox for IT community.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language