I tried ALV with two tables with following code.short dump error is coming,can anyone tell me why?I mean to say I want to display data from two tables pa0000 and pa0001 in one ALV grid.
REPORT ZGKMULALV1 .
type-pools:slis.
tables:pa0000,pa0001.
data:IT_FIELDCAT type slis_t_fieldcat_alv WITH HEADER LINE.
data:begin of itable occurs 0,
pernr like pa0000-pernr,
ename like pa0001-ename,
end of itable.
it_fieldcat-fieldname = 'PERNR'.
it_fieldcat-tabname = 'ITAB'.
it_fieldcat-outputlen = '10'.
append it_fieldcat.
it_fieldcat-fieldname = 'ENAME'.
it_fieldcat-tabname = 'ITAB'.
it_fieldcat-outputlen = '20'.
append it_fieldcat.
SELECT APERNR BENAME INTO TABLE ITABLE FROM PA0000 AS A INNER JOIN
PA0001 AS B ON APERNR = BPERNR.
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
I_INTERFACE_CHECK = ' '
I_BYPASSING_BUFFER = ' '
I_BUFFER_ACTIVE = ' '
I_CALLBACK_PROGRAM = ' '
I_CALLBACK_PF_STATUS_SET = ' '
I_CALLBACK_USER_COMMAND = ' '
I_CALLBACK_TOP_OF_PAGE = ' '
I_CALLBACK_HTML_TOP_OF_PAGE = ' '
I_CALLBACK_HTML_END_OF_LIST = ' '
I_STRUCTURE_NAME = ' '
I_BACKGROUND_ID = ' '
I_GRID_TITLE =
I_GRID_SETTINGS =
IS_LAYOUT =
IT_FIELDCAT = IT_FIELDCAT
IT_EXCLUDING =
IT_SPECIAL_GROUPS =
IT_SORT =
IT_FILTER =
IS_SEL_HIDE =
I_DEFAULT = 'X'
I_SAVE = ' '
IS_VARIANT =
IT_EVENTS =
IT_EVENT_EXIT =
IS_PRINT =
IS_REPREP_ID =
I_SCREEN_START_COLUMN = 0
I_SCREEN_START_LINE = 0
I_SCREEN_END_COLUMN = 0
I_SCREEN_END_LINE = 0
IT_ALV_GRAPHICS =
IT_HYPERLINK =
IT_ADD_FIELDCAT =
IT_EXCEPT_QINFO =
I_HTML_HEIGHT_TOP =
I_HTML_HEIGHT_END =
IMPORTING
E_EXIT_CAUSED_BY_CALLER =
ES_EXIT_CAUSED_BY_USER =
TABLES
T_OUTTAB = ITABLE
EXCEPTIONS
PROGRAM_ERROR = 1
OTHERS = 2
.
IF SY-SUBRC <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
As advised,I coded field catalogue manuall,so I thought reuse_alv_fieldcatalogue_merge not necessary.Is it correct?