04-18-2014 1:34 PM
04-18-2014 1:52 PM
04-18-2014 2:04 PM
04-19-2014 5:14 AM
i write like this:
IF NOT vbeln IS INITIAL.
APPEND 'a~vbeln = vbeln' TO l_where.
ENDIF.
IF NOT erdat IS INITIAL.
IF NOT l_where[] IS INITIAL.
APPEND ' AND ' TO l_where.
ENDIF.
APPEND 'a~erdat GE ERDAT' TO l_where.
ENDIF.
IF NOT auart IS INITIAL.
IF NOT l_where[] IS INITIAL.
APPEND ' AND ' TO l_where.
ENDIF.
APPEND 'a~AUART = AUART' TO l_where.
ENDIF.
IF NOT kunnr IS INITIAL.
IF NOT l_where[] IS INITIAL.
APPEND ' AND ' TO l_where.
ENDIF.
APPEND 'A~KUNNR = KUNNR' TO l_where.
ENDIF.
IF NOT werks IS INITIAL.
IF NOT l_where[] IS INITIAL.
APPEND ' AND ' TO l_where.
ENDIF.
APPEND 'B~WERKS = WERKS' TO l_where.
ENDIF.
IF NOT matnr IS INITIAL.
IF NOT l_where[] IS INITIAL.
APPEND ' AND ' TO l_where.
ENDIF.
APPEND 'B~MATNR = MATNR' TO l_where.
ENDIF.
IF NOT l_where[] IS INITIAL.
APPEND ' AND ' TO l_where.
ENDIF.
APPEND 'C~GBSTA NE ''C''' TO l_where.
* IF NOT werks IS INITIAL.
SELECT a~kunnr
a~audat
a~auart
b~vbeln
b~posnr
b~matnr
b~kwmeng
b~werks
c~gbsta
FROM vbak AS a INNER JOIN vbap AS b
ON a~vbeln = b~vbeln
INNER JOIN vbup AS c
ON b~vbeln = c~vbeln
AND b~posnr = c~posnr
INTO TABLE t_vbak1
WHERE (l_where).
but we are facing Performance issue.
please give explain detains to reduce performance.
thanks in advance .
04-19-2014 5:48 AM
04-19-2014 8:06 AM
some times VBELN is initial that time we are not getting any data
04-19-2014 10:12 AM
What exactly is your requirement sir? Just one sentence doesn't suffice to make people understand the requirement.
04-19-2014 1:00 PM