topic Re: Can i able to update Material Document After post. in Application Development and Automation Discussions

Can i able to update Material Document After post.

former_member196331 — Mon, 30 Nov 2015 10:24:07 GMT

HI,

I have one question.

I am posting Material document with movement type 201 . using Mb1a against to cost center.

In migo i have two custom fields, Now i would like to update that fields.

Can i able to update using any bapi or Function module Can any body faced this type of problem.

I have one doubt. After post the material document, there is no possibility to Open the same document and do the changes.

So, that's why i am thinking , If it possible please Update me.

Re: Can i able to update Material Document After post.

Former Member — Mon, 30 Nov 2015 10:37:42 GMT

Not all data of material document can be updated.

If its a field that can be changed via MB02, then you can try the FM MB_CHANGE_DOCUMENT.

Re: Can i able to update Material Document After post.

michael_kozlowski — Mon, 30 Nov 2015 10:39:04 GMT

Check BAdI 'MB_MIGO_BADI' for this usecase.

Re: Can i able to update Material Document After post.

former_member196331 — Mon, 30 Nov 2015 10:40:45 GMT

Dear Michael Kozlowski

How badi useful to me i am not able to understood.

I dont want to implement new screen. already we did.

But my task is now, I need to update two custom fields in material Document.

Re: Can i able to update Material Document After post.

former_member196331 — Mon, 30 Nov 2015 10:42:07 GMT

HI, thanks for your reply. In Mb02 , No custom fields are appearing.

Re: Can i able to update Material Document After post.

michael_kozlowski — Mon, 30 Nov 2015 11:15:18 GMT

Sorry - misunderstanding from my side.

I think there are two options:

1) reverse and re-post documents (the recommended approach)

2) direct update of customer fields with a small program (if you be able to keep document relations consistent)

Re: Can i able to update Material Document After post.

former_member196331 — Mon, 30 Nov 2015 11:18:47 GMT

hi,

Through the program means.Are u saying bapi.

Re: Can i able to update Material Document After post.

karthikeyan_p3 — Mon, 30 Nov 2015 11:18:54 GMT

Hi,

If your custom field is available either in MKPF or MSEG, you could use the Function Module MB_CHANGE_DOCUMENT. This FM is a update function Module, so validate your data before calling this FM.

Thanks,

Karthikeyan

Re: Can i able to update Material Document After post.

former_member196331 — Mon, 30 Nov 2015 11:24:02 GMT

Ok, Thanks for your reply. I will check it.

Re: Can i able to update Material Document After post.

former_member196331 — Mon, 30 Nov 2015 12:41:03 GMT

I Hope this is too risky, I need to pass all the fields to mkpf and mseg, If i miss any fields that fields are not updating previous values.

Re: Can i able to update Material Document After post.

RaymondGiuseppi — Mon, 30 Nov 2015 12:45:17 GMT

As a rule, I won't suggest any update task function, as not only you have to code the full logic of SAP standard tools : checks but also update of other data (from logistics statistics to some sum tables)

Regards,

Raymond

Re: Can i able to update Material Document After post.

former_member196331 — Mon, 30 Nov 2015 12:48:29 GMT

Only custom fields i need to update , i will not touch any things.

Any other options.

Re: Can i able to update Material Document After post.

RaymondGiuseppi — Mon, 30 Nov 2015 12:57:50 GMT

If you developped fields on MIGO, why do you use MB1A, as the available BAdI (MB_DOCUMENT_BADI, MB_CHANGE_DOCUMENT and similar ones) provided much less options than for MIGO (e.g. MB_MIGO_BADI which allows change of data before posting) so you may be required to use some wild tools/tricks?

Regards,

Raymond

Re: Can i able to update Material Document After post.

former_member196331 — Mon, 30 Nov 2015 13:03:06 GMT

First i would like to tell u What is in my system. May be my explanation is wrong.

We have screen exit at Mb1a with movement type 201 .At the time of posting Mb1a wtih movement type 201 . Then it will ask two fields names these values are coming from ztable.

this was created exactly 01.05.2015 on words. this is mandatory. so, after 01.05.2015 all the documents with 201 mvmt type is having the custom fields but 01.04.2015 to 01.05.2015 the document does not have the custom fields so, there is no data.

We develop a reports based on custom fields . As per my company higher people desire.

Now i need to update that fields then only i can see the reports.

Now tell me how could i update that documents.

Re: Can i able to update Material Document After post.

RaymondGiuseppi — Mon, 30 Nov 2015 13:09:51 GMT

Did you try to identify any implicit available enhancement to update (perform a where-used search on FM MB_POST_DOCUMENT)

Regards,

Raymond

Re: Can i able to update Material Document After post.

former_member196331 — Mon, 30 Nov 2015 13:12:16 GMT

MB_post documnet means it will post the document.

Re: Can i able to update Material Document After post.

michael_kozlowski — Mon, 30 Nov 2015 13:32:23 GMT

If you need to update custom fields in historical data only once you can do this with an UPDATE Statement for involved table in a loop like this:

SELECT SINGLE FOR UPDATE * FROM mkpf

WHERE mblnr EQ '4711'

AND mjahr EQ '2015'.

IF sy-subrc EQ 0.

mkpf-zzfield1 = 'XYZ'.

mkpf-zzfield2 = '123'.

UPDATE mkpf.

ENDIF.

Re: Can i able to update Material Document After post.

former_member196331 — Mon, 30 Nov 2015 13:34:54 GMT

Ok..

Above method or directly se16n GD-EDIT and GD-SAPEDIT .

Re: Can i able to update Material Document After post.

michael_kozlowski — Mon, 30 Nov 2015 13:41:01 GMT

If not too many entries SE16N will work as well. Good luck!

Re: Can i able to update Material Document After post.

RaymondGiuseppi — Mon, 30 Nov 2015 13:57:14 GMT

Ok you aren't "posting Material document with movement type 201" but have already "posted Material document with movement type 201", right ? remember that the basic rule for material movement is:


 The Document Concept, you can no longer change a document once it has been posted. If you made a typing error when entering a goods movement (for example, when you entered the quantity), you must reverse the movement with a so-called reversal document (see section  Cancelling a Material Document).  


Why Change a Material Document?
  
Although you cannot change a posted document, you can use the function "Change Material Document" to


enter additional information for the document.

But SAP only provided MB02, and AFAIK there is no extension there. If your fields are (SAP point of view) only external ZZ_information, you could use MB_CHANGE_DOCUMENT or even Open SQL statement in this case (look at source of MB_CHANGE_DOCUMENT...) But if you are using some tools as logistic statistics you should also consider calling MCB_STATISTICS_LIS or even trigger MB_DOCUMENT_BADI_SAP / MB_DOCUMENT_BADI too if your fields have any impact there. Try to execute MB02 to change some value executing an Abap trace (SAT/SE30) and analyze list of called FM.

Regards,

Raymond