EXCISE Charges in COPA Report

[former_member191564]

Dear experts

                  Our client want to EXCISE duty in my COPA report . But excise duty is an Balance sheet item i cannot maintain this g/l account as Cost element .if i not maintain as cost element it wont come to my copa report .so please tell me an alternative way to solve this issue

Regards

  Ajeesh.s

[ajaycwa1981 · Accepted solution]

Hi

I was unable to log in to SCN since 3 days, so could not reply you

What you need to do is add one more cond type in your SD pricing procedure...

This will be statistical and will have condition record 100% based on Excise duty cond type

Map this Stat Cond type to your COPA in KE4I

This is a tried and tested approach

br, Ajay M

[former_member191564 · Accepted solution]

Dear expert

[Former Member · Accepted solution]

Pls check whether excise condition type are statistical in pricing procedure.

[former_member191564 · Accepted solution]

Dear Expert

My Pricing Procedure

[Former Member · Accepted solution]

Wht it is % in pricing procedure. Why not amount.

Populate amount in Excise condition instead of %

[former_member191564 · Accepted solution]

Dear Expert

            Can you tell me where we need to maintain 100% .As per our requirement we are calculating 5.1 % of cost is our excise duty.ZEXD  Excise Duty

Regards

   Ajeesh.s

[former_member191564 · Accepted solution]

Dear All

         I have solved the issue by changing ,condition category,Calculation type:,Condition class:,

Scale basis in ZEX1 Condition type

Regards

  Ajeesh.s

[Former Member · Accepted solution]

HI Ajeesh,

Don't you think, Even ajay and Myself has shared the idea and steps involved as well.

or you only solved and assign point to yourself.

regards

RK

[former_member191564 · Accepted solution]

Dear Expert

               Don't mind  .Have you Mentioned anything in your posting about changing ,condition category,Calculation type:,Condition class:,Scale basis ?My Error is belongs to Calculation type

Regards

   Ajeesh,s

[former_member217328]

Hi Ajeesh

There is no standard way to capture the balance sheet account values to COPA as they do not have cost elements.

We acheived this by using the stastistical conditions and copied them to the value feilds in COPA using the user exit COPA005.

This will work 100%.

Thanks

Mahesh

[Former Member]

Hi,

Pls check billing document in VF02 for zex1 condition value in line item.

if it is appearing then it must flow to COPA.

Check copa document for excise value field VV011.

regards

RK

[former_member191564]

Dear Experts

Regards

  Ajeesh.s

[Former Member]

Hi,

You can get all pricing condition type details including excise from below sap table

KONH Conditions header

KONP Conditions items

regards

RK

[former_member191564]

Dear Expert

           how can i show this value to ke30 report

Regards

  Ajeesh

[Former Member]

Hi Ajeesh,

As you said in your post as well.

Balance sheet account cannot be transfered to COPA value field.

Either you will create query or ABAP report based on below table

KONH Conditions header

KONP Conditions items

Or Create seperate statistical condition type and seperate value field in COPA and Link this excise statistical condition type to COPA

And also tell your SD people he/she will transfer excise condition type actual cost from real condition type to statistical condition type in pricing procedure.

regards

RK

[former_member191564]

Dear expert

              As per above discussion we have configured separate statistical condition type and separate value field in COPA and Link this excise statistical condition type to COPA. but still Excise duty is not picking please check the below  screen shots