topic Re: Display Output in Application Development and Automation Discussions

Display Output

Former Member — Tue, 27 Dec 2005 05:27:34 GMT

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

Re: Display Output

Former Member — Tue, 27 Dec 2005 05:38:52 GMT

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

Re: Display Output

Former Member — Tue, 27 Dec 2005 06:19:57 GMT

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 AUSP_{OBJEK AUSP}ATINN AUSP_{ATWRT CABN}ATNAM

KSSK_{CLINT KLAH}CLASS KLAH~KLART INTO CORRESPONDING FIELDS OF TABLE T_CHAR

FROM MARA INNER JOIN AUSP ON AUSP_{OBJEK = P_MATNR AND AUSP}KLART = '001'

INNER JOIN CABN ON CABN_{ATINN = AUSP}ATINN

INNER JOIN KSSK ON KSSK_{OBJEK = AUSP}OBJEK

INNER JOIN KLAH ON KLAH_{CLINT = KSSK}CLINT.

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