topic Re: Dynamical Modify or Insert in Application Development and Automation Discussions

Dynamical Modify or Insert

Former Member — Mon, 13 Nov 2006 18:13:53 GMT

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

Re: Dynamical Modify or Insert

Former Member — Mon, 13 Nov 2006 20:39:11 GMT

what do you mean by dynamically? can you please elaborate your requirement?

Re: Dynamical Modify or Insert

Former Member — Mon, 13 Nov 2006 23:38:43 GMT

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.

Re: Dynamical Modify or Insert

Former Member — Tue, 14 Nov 2006 08:22:05 GMT

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

Re: Dynamical Modify or Insert

Former Member — Tue, 14 Nov 2006 16:18:51 GMT

Is there No Chance to this Topic?