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...