topic Re: UPDATE NAST in Application Development and Automation Discussions

UPDATE NAST

Former Member — Mon, 04 Dec 2006 05:39:09 GMT

Hi all, i'm using this coding to update nast table for Purchase Order .This coding is not working.

please help me to solve this problem.

Your help is greatly appreciated.

tables nast.

nast-MANDT = sy-mandt.

nast-KAPPL = 'EF'.

nast-OBJKY = '4100000477'.

nast-KSCHL = 'NEU'.

nast-SPRAS = sy-langu.

nast-PARNR = '0000100165'.

nast-PARVW = 'LF'.

nast-ERDAT = sy-datum.

nast-ERUHR = sy-uzeit.

nast-NACHA = '1'.

nast-ANZAL = '0'.

nast-VSZTP = '1'.

nast-MANUE = 'X'.

nast-USNAM = sy-UNAME.

nast-VSTAT = '0'.

nast-LDEST = 'HOIT'.

nast-TDID = 'BEWG'.

nast-TDSPRAS = sy-langu.

nast-NAUTO = 'X'.

nast-TDRECEIVER = sy-UNAME.

nast-TDCOVTITLE = 'New Purchase Order Printout'.

CALL FUNCTION 'NAST_SAVE_OBJECT'

EXPORTING

pi_nast = nast

PI_LINK_OBJECT = 'X'

PI_PROCESSING = 'X'

EXCEPTIONS

NOT_SAVED = 1

OTHERS = 2

IF sy-subrc <> 0.

write: / 'NOT SAVED'.

ELSE.

write: / 'SAVED'.

ENDIF.

IF sy-subrc = 0.

COMMIT WORK.

write / 'TABLE "NAST" WAS UPDATED'.

else.

rollback work.

write / 'TABLE "NAST" WAS NOT UPDATED'.

endif.

Re: UPDATE NAST

jayanthi_jayaraman — Mon, 04 Dec 2006 05:43:55 GMT

Hi,

The following piece of coding should be changed as

IF sy-subrc <> 0.

write: / 'NOT SAVED'.

ELSE.

write: / 'SAVED'.

ENDIF.

IF sy-subrc = 0.

COMMIT WORK.

write / 'TABLE "NAST" WAS UPDATED'.

else.

rollback work.

write / 'TABLE "NAST" WAS NOT UPDATED'.

endif.

<u>Changed code:</u>

IF sy-subrc <> 0.

rollback work.

write / 'TABLE "NAST" WAS NOT UPDATED'.

ELSE.

COMMIT WORK.

write / 'TABLE "NAST" WAS UPDATED'.

ENDIF.

Re: UPDATE NAST

Former Member — Mon, 04 Dec 2006 06:33:24 GMT

still not working

Re: UPDATE NAST

Former Member — Mon, 04 Dec 2006 06:41:24 GMT

When you say 'not working', does it mean, it is giving error or it is not updating NAST table.

Re: UPDATE NAST

Former Member — Mon, 04 Dec 2006 06:45:38 GMT

message displayed:

TABLE "NAST" WAS UPDATED

but not updated in database

Re: UPDATE NAST

Former Member — Mon, 04 Dec 2006 06:48:33 GMT

I think you need to use NAST_MAIL_COMMIT which is used after this FM.

Re: UPDATE NAST

Former Member — Mon, 04 Dec 2006 06:54:33 GMT

can i use 'NAST_MAIL_COMMIT'

instead of 'NAST_SAVE_OBJECT' FM ?

Re: UPDATE NAST

Former Member — Wed, 06 Dec 2006 10:57:26 GMT

No, you need to use NAST_MAIL_COMMIT after using NAST_SAVE_OBJECT