topic Re: Update - Problem for Purchasing Doc item in Application Development and Automation Discussions

Update - Problem for Purchasing Doc item

Former Member — Thu, 07 Jun 2012 09:45:02 GMT

Hi all,

I Have a problem for Update syntax.

please see code below:

            UPDATE ekpo
             SET:   oic_oland1   = wa_xekpo-oic_oland1   "Country
                    oic_oregio   = wa_xekpo-oic_oregio   "Region
                    umren        = wa_xekpo-umren.       "QTY conversion

Using this the table for EKPO should be updated but it did not..
did i miss something here.. for me to update directly on EKPO..

Thanks in advance..

Well appreciated your response..

Re: Update - Problem for Purchasing Doc item

Former Member — Thu, 07 Jun 2012 09:49:10 GMT

u should mention the purchase order to be updated.Pls search in SCN before u post

Re: Update - Problem for Purchasing Doc item

Former Member — Thu, 07 Jun 2012 09:58:12 GMT

Hello Karthik

I already did that specifying the Purchase order item.

But it same it did not update the EKPO..

actually the code i paste is it takes time to update the EKPO...

Re: Update - Problem for Purchasing Doc item

Former Member — Thu, 07 Jun 2012 10:08:50 GMT

Hi,

Try this,

CALL FUNCTION 'ENQUEUE_E_TABLE'
   EXPORTING
     MODE_RSTABLE   = 'E'
     TABNAME        = 'EKPO'
   EXCEPTIONS
     FOREIGN_LOCK   = 1
     SYSTEM_FAILURE = 2
     OTHERS         = 3.
 
 UPDATE EKPO SET BUKRS = '1000'
                               LOEKZ = 'X'
                               STATU = 'F'
           WHERE EBELN EQ '45000001'
           AND   EBELP EQ '0010'.
 
 CALL FUNCTION 'DEQUEUE_E_TABLE'
   EXPORTING
     MODE_RSTABLE = 'E'
     TABNAME      = 'EKPO'.

Regards,

Danish

Re: Update - Problem for Purchasing Doc item

Clemenss — Thu, 07 Jun 2012 12:44:25 GMT

Hi beginners,

NEVER ( means N E V E R) update a SAP standard table other than using Functions module, BAPIs, BaDi, Transaction provided by SAP.

Or ask the business revision department first 🙂

Regards

Clemens

Re: Update - Problem for Purchasing Doc item

Former Member — Thu, 07 Jun 2012 14:14:07 GMT

ABAPER SAP wrote:
actually the code i paste is it takes time to update the EKPO...

Probably because the code you have posted will try to update every record in EKPO. But when it dumped, fortunately it rolled back your attempt to change it.

Clemens Li was right - don't do this.

Rob

Re: Update - Problem for Purchasing Doc item

RaymondGiuseppi — Thu, 07 Jun 2012 14:20:17 GMT

Never

- use UPDATE SET without WHERE clause

- update a standard table with open sql (or use an update task FM)

I don't have access to an IS-OIL system, but you should look for BAPI* structures using the data element of the fields you want to update, and then look for BAPI using those structures. If not found look, via transaction BAPI, for a generic BAPI on purchase orders with an EXTENSIONIN parameter.

Regards,

Raymond

Re: Update - Problem for Purchasing Doc item

Former Member — Fri, 08 Jun 2012 02:01:54 GMT

Hello ALL,

Thanks for all the response..

I already configure the logic.. and not it is working..

Question answered..
I need to use update syntax.. cause the FM did not automatic update my Purc. Doc item..
to update direct the table automativ upon execution.. i also use WAIT syntax.