Different COGS between PGI FI Posting and Billing COPA Posting

[Former Member]

Dear Experts,

I have an issue regarding different COGS between PGI FI Posting and Billing COPA Posting, here are my condition :

1. MTO Scenario with valuated stock and sales order is not a cost object

2. Sales Order costing is done when sales order created (VA01) and automatically marked (Costing ID B) in the requirement class.

3. EK01 is passed to the sales order item condition, along with other standard condition like VPRS and PR00.

4. Material cost estimate is configured in order to get breakdown of COGS while transfering COGS to COPA, the costing key is configured to take sales order cost estimate (Y02).

5. Since we also have a MTS Scenario, i also configured material cost estimate another costing key to get current standard cost estimate (Y01).

6. Both costing key is assigned to material type, and i already did simulation in billing transfer analysis for MTO the system took Y02, while MTS scenario the system took Y01.

and my problem are :

1. When i did the PGI for MTO sales order valuated stock, the system post an accounting document for COGS and took value from EK01 condition type (which is this correct).

2. When i did the billing to the customer, the system post an accounting document (for reveneue recognition) and also COPA document (for COGS), but when i checked to COPA Document created the system took value from VPRS condition type which is not correct because there is different value between VPRS and EK01.

Question :

1. Is this standard behavior ? because i think there will be difference between COPA and FI for COGS.

2. Is there any configuration that i miss? since i am new in CO module.

Pls share your experience regarding this issue..

Regards,

Aldrich

[Former Member · Accepted solution]

Hi,

I guess in KE4I SD condition VPRS is mapped to a CO-PA value field but EK01 is not. So the CO-PA doc. contains the VPRS value but not the EK01 information. From my point of view there are 2 ways to fix this:

1: Map EK01 to a CO-PA value field (maybe the same as VPRS) and ensure 100% that MTO billing docs contain only EK01 condition but not VPRS, whereas MTS billing docs contain VPRS as before but no EK01.

2: If you can't ensure this at the source (billing doc), map EK01 and VPRS to different value fields thus you will have 2 values in MTO case (the EK01 value and the VPRS value), only VPRS in MTS case. Use COPA0005 enhancement (include ZXKKEU08) to clear VPRS value in case EK01 is not empty.

At the end, the MTO COGS are shown in the value field where EK01 is mapped, MTS COGS in the value field where VPRS is mapped.

In COPA0005 you can also bring both the values to one value field which might be easier when creating CO-PA form based reports.

BR Christian

[Former Member · Accepted solution]

Hi Christian,

thanks for the respond, actually i already maintained both VPRS and EK01 to same value field but i still don't understand why SAP take VPRS instead of EK01 for COPA document. for your solution :

1. this is mean that i should consult to SD Consultant, since this modification should be done in pricing procedure. am i right?

2. your explanation for implementing enhancement on COPA0005 is very logical, but i will take a look into it once there is no other way to solve this problem except implementing the enhancement.

note :

something strange came when COPA did valuation using material cost estimate when COPA document is created, where the itemization of COGS is reflecting from EK01. so in short if i sum the itemization of COGS the total is not the same as COGS value field since COGS value field is populated from VPRS (but equal to COGS in EK01).

Regards,

Aldrich

[ajaycwa1981 · Accepted solution]

Hi

You should not have mapped both to same value field.. You are fortunate that EK01 is not working now.. Else, it would have been EK01+VPRS value in your COPA Val Field

Map both of them to separate val fields... and use COPA enhancement as suggested by Christian

br, Ajay M

[Former Member · Accepted solution]

Hi ajay,

sorry for the late reply, just had a busy weekend

i got your point, but beside of COPA enhancement as suggested by christian i have plan to ask SD consultant to write the code on their pricing routine so VPRS will copy EK01 value if condition EK01 exist in pricing procedure. it mean the mapping from EK01 to COPA value field is no longer necessary right?

thanks

Aldrich