Skip to Content
0
Former Member
Feb 17, 2011 at 08:23 AM

regarding qals and qamr table

488 Views

hai

i created one report using QALS,QAMR and QAMV tables.

i took PRUEFLOS as the key feild to connect the table .

now my problem is in QALS for each PRUEFLOS there are multiple enteries in QAMR and QAMV tables.

so the first entry is displaying correctly but the remaing entries are not displaying.

SELECT PRUEFLOS WERK ART OBJNR OBTYP STAFO PLNTY PLNNR AUFPL LIFNR MATNR CHARG EBELN

EBELP MBLNR BUDAT KTEXTMAT FROM QALS INTO CORRESPONDING FIELDS OF TABLE IT_QALS

WHERE MATNR IN S_MATNR AND LIFNR IN S_LIFNR AND WERK IN S_WERKS.

IF IT_QALS IS NOT INITIAL.

SELECT PRUEFLOS VORGLFNR MERKNR ORIGINAL_INPUT FROM QAMR INTO CORRESPONDING FIELDS OF TABLE

IT_QAMR FOR ALL ENTRIES IN IT_QALS WHERE PRUEFLOS = IT_QALS-PRUEFLOS.

SELECT PRUEFLOS VORGLFNR MERKNR KURZTEXT FROM QAMV INTO CORRESPONDING FIELDS OF TABLE IT_QAMV

FOR ALL ENTRIES IN IT_QALS WHERE PRUEFLOS = IT_QALS-PRUEFLOS.

ENDIF.

i used this format. can anyone suggest the needful

Moderator Message: Basic Question. Please take an ABAP course and learn the basics of ABAP programming.

Edited by: kishan P on Feb 17, 2011 3:18 PM