Best way to update CO documents

[Former Member]

Hi friends ,

We have figured out few CO documents where we need to update material costs in Ke24 (txn) and in table Ce14000 in SAP. IS there any best approach to fix this data ? We have figured out few but would like to advice from experts.

Thanks in advance .

[ajaycwa1981 · Accepted solution]

Hi

KE21N is the best and only option in my opinion

1. Go to KE21N

2. Enter the period, record type (Usually F)

3. The next screen has 2 tabs - Chars and Val Fields

4. Figure out which posted docs has problems... . Post the new document populating the same chars as the posted document

5. Populate the Value fields relating to mat costs....

6. Save

7. Run KE24 and check

Regards

AJay M

[Former Member · Accepted solution]

Thanks so much Ajay ! We have lot of documents which needs to be corrected , can we create a LSMW or any other mass update process to apply this to all documents in one shot ?

And also so far I know that one of the tables storing this Co document # is CE * , and when I'm trying to pull these documents via SAP query the query never completes , So what is the other SAP table / Report that stores CO documents along with Direct Material Costs ?

Thanks for all your help,!

[ajaycwa1981 · Accepted solution]

Hi

Yes, you can create an LSMW or an upload mechanism using a BAPI

You can try to use KE24 to get those line items

Regards

Ajay M

[iklovski · Accepted solution]

Hi,

You can use BAPI_COPAACTUALS_POSTCOSTDATA BAPI method for this in LSMW.

Regards,

Eli

[Former Member · Accepted solution]

Thank you ! I know the purpose of LSMW but have not created one , and I'm not sure how to tie a BAPI to an LSMW , By any chnace is there any document which highlights this step ?

really appreciate all your inputs,

[ajaycwa1981 · Accepted solution]

Hi

Use BAPI_COPAACTUALS_POSTCOSTDATA BAPI .. You dont tie a BAPI to LSMW

BAPI is an upload program in itself... Your abaper needs to create an upload program using this BAPI.. he can assign a Z t code for the same

Regards

Ajay M

[Former Member · Accepted solution]

Thanks once again Ajay . Can I know more details on what this BAPI : BAPI_COPAACTUALS_POSTCOSTDATA does ?

And which one do you prefer out of these 2 opting , Uploading the data to Ke21 via LSMW or using this BAPI ?

Thank you,

[ajaycwa1981 · Accepted solution]

Hi

BAPI or LSMW serves the same purpose i.e. upload of data..

From a stability point of view, BAPI is more stable, but it needs to be handled by ABAPers only... whereas LSMW you are aware of and can be created by users as well

In BAPI, your ABAPer would write a code choosing all the chars and Value fields that you would like to upload values for and ultimately he will tell you a file fomat.... He can also create a Z T code for the same and the front screen will have option to specify the upload file path

You need to prepare file in that format and simply upload from the program

Regards

Ajay M

[Former Member · Accepted solution]

Thanks once again Ajay .

Couple of questions Ajay :

What Code does the abaper has to write again ? Since this BAPI is already existing what code he needs to wrtie and where ? Does he need to create a Copy of "Z" of this BAPI ? and Then attatch a Z tocde to this BAPI ?

What is this program to upload the file ? Are you reffering to the program which is tied to Z t-code ?

I'm trying to be very clear .

Appreciate all your help .

[ajaycwa1981 · Accepted solution]

Hi

BAPI is an upload tool just like LSMW... In LSMW you do a recording to map the fields...

Similarly, BAPI allows you to write a code to do mapping... You will have to tell your ABAPer all those chars and value fields which you would like to upload.. I would suggest map all the chars and value fields so that it would serve useful in future use also

Dont worry on the technical aspect of BAPI.. your abaper will be comfortable with it... Just post a manual document from KE21N infront of him and tell him this is what you expect from the upload program via BAPI

he will create this program using the BAPI and create a T code from SE93 assigning this program

Hope this helps

Regards

Ajay M

[Former Member · Accepted solution]

Thanks Ajay . I'll ask the technical person to do this and will come back to you .

Full points to you shortly and for all the detailed explaination .

[Former Member · Accepted solution]

Hello Ajay ,

Can you tell me what actions and precautions we need to take care on the GL side after updating the CO documents . Since each of these CO documents will have a GL entry also ( revenue or expense) how should we be taking of this scenario . Let me know if you want me to open a new thread

Thank you,

[ajaycwa1981 · Accepted solution]

Hi

When you update cost in COPA via KE21N, it wont trigger any FI GL entry....

This is a stand alone postng in COPA independant of any FI posting...

In future, ensure that COGS is updated promptly updated to COPA @ the time of billing and

ensure that any direct postings to COPA from FI happen @ the time of posting the FI document itself.. For this, your GL should be cost element and maintain the PA transfer str FI in KEI1..

Hope i have understood your question correctly and replied to the point

Regards

Ajay M