Hello Friends,
I'm unable to do a simple join thing .. I'm joining AUSP ,KLAH tables . i'm taking OBJEK,ATINN,KLART,ATWRT from AUSP table and KLART ,CLASS from KLAH ..
finally i need OBJEK ,ATINN,KLART,CLASS, ATWRT. ok .
the thing is while i'm joining the two tables ..suppose i have 5 classes for a single class type .and one material will contain only one class.
in result its giving for one material one class type , 5 classes , and one characteristic five times.
how can i find that for that particular material ,that which class we used .. .. so please friends anyone one knows solutions... please let me know..
i don't want to hot code it anywhere.....so ... please give me a solution .
thanks& regards
lavanya.a