2006 Nov 13 6:13 PM
Hi All,
how can we modify and insert dynamically the Records into DDIC Table using
WHERE Conditions?
Thanks for your Replies.
Best Regards
Beserithan Malabakan
2006 Nov 13 11:38 PM
Hi,
Here is sample program from SAP documentation which uses dynamic WHERE clause within a SELECT statement.
DATA: COND(72) TYPE C,
ITAB LIKE TABLE OF COND.
PARAMETERS: CITY1(10) TYPE C, CITY2(10) TYPE C.
DATA WA TYPE SPFLI-CITYFROM.
CONCATENATE 'CITYFROM = ''' CITY1 '''' INTO COND.
APPEND COND TO ITAB.
CONCATENATE 'OR CITYFROM = ''' CITY2 '''' INTO COND.
APPEND COND TO ITAB.
CONCATENATE 'OR CITYFROM = ''' 'BERLIN' '''' INTO COND.
APPEND COND TO ITAB.
LOOP AT ITAB INTO COND.
WRITE COND.
ENDLOOP.
SKIP.
SELECT CITYFROM
INTO WA
FROM SPFLI
WHERE (ITAB).
WRITE / WA.
ENDSELECT.
You can also refer to this link for more details:
<a href="http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3a1f358411d1829f0000e829fbfe/frameset.htm">http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3a1f358411d1829f0000e829fbfe/frameset.htm</a>
Regards,
Sumant.
2006 Nov 13 8:39 PM
what do you mean by dynamically? can you please elaborate your requirement?
2006 Nov 14 8:22 AM
I mean like this;
modify (ZTABLE) from wa where (lt_where_conditions).
But it doesnt work in this Form. The Same ought to be for Insert Command
Beserithan
2006 Nov 13 11:38 PM
Hi,
Here is sample program from SAP documentation which uses dynamic WHERE clause within a SELECT statement.
DATA: COND(72) TYPE C,
ITAB LIKE TABLE OF COND.
PARAMETERS: CITY1(10) TYPE C, CITY2(10) TYPE C.
DATA WA TYPE SPFLI-CITYFROM.
CONCATENATE 'CITYFROM = ''' CITY1 '''' INTO COND.
APPEND COND TO ITAB.
CONCATENATE 'OR CITYFROM = ''' CITY2 '''' INTO COND.
APPEND COND TO ITAB.
CONCATENATE 'OR CITYFROM = ''' 'BERLIN' '''' INTO COND.
APPEND COND TO ITAB.
LOOP AT ITAB INTO COND.
WRITE COND.
ENDLOOP.
SKIP.
SELECT CITYFROM
INTO WA
FROM SPFLI
WHERE (ITAB).
WRITE / WA.
ENDSELECT.
You can also refer to this link for more details:
<a href="http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3a1f358411d1829f0000e829fbfe/frameset.htm">http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3a1f358411d1829f0000e829fbfe/frameset.htm</a>
Regards,
Sumant.
2006 Nov 14 4:18 PM