Skip to Content
1
Former Member
Dec 19, 2007 at 09:19 PM

How join ausp with mara

3758 Views

Hi expert,

I have a problem with the join between this two tables because not return nothing. Now the article have characteristic because en the transaction MM43 can be visualized. I want knwolegde if exit other object for the articles y how find. O if exist some function module and find el object that exist in the ausp table.

This is my code:

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.

DATA: P_MATNR LIKE AUSP-OBJEK.

PARAMETERS: S_MATNR LIKE MARA-MATNR.

START-OF-SELECTION.

SELECT SINGLE * FROM MARA WHERE MATNR = S_MATNR.

MOVE: MARA-MATNR TO P_MATNR.

SELECT AUSPOBJEK AUSPATINN AUSP~ATWRT INTO CORRESPONDING FIELDS OF TABLE T_CHAR

FROM MARA INNER JOIN AUSP ON AUSP~OBJEK = P_MATNR.

Thank...