12-27-2005 5:27 AM
Hi All,
How to Find the class type 300 with name equal to configurable material.
Plz Guide the
how to build the query to retrive the data Class type 300 and Configurable material.
Advanced Thankx to your reply
Reward Points
i look forward to your reply
Thanks & Regards
RSK
12-27-2005 5:38 AM
hi
from kssk table based on calss type 300 get the objek.
and objek is nothing but material number in mara.
select single objeck
from kssk
into v_objek
where klart = '300'.
this is the material.
regards
vijay
12-27-2005 6:19 AM
Thank u Vijay,
TABLES : MARA, " Material Master
MAKT, " Material Description
MARC, " Plant Data for Materials
AUSP, " Characteristic Values
CABN, " Characteristic
KSSK, " Allocation Table: Object to Class
KLAH. " Class Header Data
DATA : BEGIN OF T_CHAR OCCURS 0,
LVORM LIKE MARA-LVORM,
MATPOS_MARA LIKE MARA-MTPOS_MARA,
OBJEK LIKE AUSP-OBJEK,
ATINN LIKE AUSP-ATINN,
ATWRT LIKE AUSP-ATWRT,
CLASS LIKE KLAH-CLASS,
KLART LIKE KLAH-KLART,
ATNAM LIKE CABN-ATNAM,
CLINT LIKE KSSK-CLINT,
END OF T_CHAR.
SELECT AUSPOBJEK AUSPATINN AUSPATWRT CABNATNAM
KSSKCLINT KLAHCLASS KLAH~KLART INTO CORRESPONDING FIELDS OF TABLE T_CHAR
FROM MARA INNER JOIN AUSP ON AUSPOBJEK = P_MATNR AND AUSPKLART = '001'
INNER JOIN CABN ON CABNATINN = AUSPATINN
INNER JOIN KSSK ON KSSKOBJEK = AUSPOBJEK
INNER JOIN KLAH ON KLAHCLINT = KSSKCLINT.
i have to developed the above quey,
Is there is any wrong in this query ,
Plz Check and let me know the modfificationes
i look forward to your reply
Thanks & Regards
RSK