topic Re: Table update does not work + AUFK in Application Development and Automation Discussions

Table update does not work + AUFK

ramiwal_dsilva — Thu, 30 Jul 2015 09:40:15 GMT

Hi,

I am trying to update the AUFK table for a service order that just got created in the previous statement. But the Modify nor update statement does not work.

I have a custom field in the AUFK table that I am trying to update (AUFK-ZFIELD)

Step 1:

CALL FUNCTION 'BAPI_ALM_ORDER_MAINTAIN' " This creates a new service order (IW31) and generates an order number aufk-1234.

Step2:

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'.

Step 3

UPDATE aufk

SET ZZ_FIELD = XXXX

WHERE aufnr = aufk-1234.

The above statement returns sy-subrc eq 4

I do not want to use the extension BAPI for this custom field update.

Can someone tell me why this doesn't work? I tried using the modify statement likewise with no effect.

Re: Table update does not work + AUFK

ArcherZhang — Thu, 30 Jul 2015 09:44:07 GMT

Hi Ramiwal,

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT' exporting WAIT = 'X'.

regards,

Archer

Re: Table update does not work + AUFK

dibyajeeban_jena — Thu, 30 Jul 2015 13:07:42 GMT

Hi Ramiwal,

Agree with Archer .

Reason why 'UPDATE' is not working is, in database the order number(aufnr = aufk-1234) is not yet created in AUFK table . When you are trying to update a field of a record which does not exists in database, its showing sy-subrc = 4 .

Use this CALL FUNCTION 'BAPI_TRANSACTION_COMMIT' exporting WAIT = 'X' for synchronous updating .

Regards

Re: Table update does not work + AUFK

ramiwal_dsilva — Thu, 30 Jul 2015 15:48:25 GMT

Hi Archer, Jena,

Thank you for the response, but i believe i solved the issue.

It is because the data element referring to aufk-1234 had a conversion exit , and hence

was required to be converted before passing it to the Update statement.

Issue resolved

Re: Table update does not work + AUFK

suresh_kutam — Fri, 31 Jul 2015 11:49:23 GMT

Hello Ramiwal,

I suggest you do not modify or update AUFK /any SAP standard tables .

During the BAPI process , look for a exit or Enhancement technique to pass the value of your custom field and let BAPI save the data on it own.

Ground rule is we should not write Modify/update on SAP standard tables.

Let me know if you need any further details.

Thanks,

Suresh Kutam