cancel
Showing results for 
Search instead for 
Did you mean: 

WRONG AMOUNT REFLECTED IN EXCISE BASE DUTY FIELD (EXBAS) IN TABLE J_1IEXCDTL:-

Former Member
0 Kudos

Dear Expert,

 

In billing document excise duty calculation correctly and
Excise invoice excise duty reflect correctly on the other hand excise base
amount wrongly reflected in J_1IEXCDTL. Please find screen shot for your
reference and PP configuration. As below billing document Basic excise duty (JEXP)
calculated form Total of captive con text line i.e. amount 2200 on the other
hand it is reflected in EXBAS field 20000. Please guide me as early as
possible.

Regards,

Manoranjan.

Accepted Solutions (1)

Accepted Solutions (1)

bsivasankarreddy_reddy
Active Contributor
0 Kudos

hi

in standerd behavior is

komv-kawrt = j_1iexcdtl-exbas

excitm-excbase = *konv-kwert

excitm-excbase =  j_1iexcdtl-exbas

so check the konv-kwert vaule ,

go to vbrk here check the document condition number(knumv)

next go to konv , enter the document condition number ( knumv), here then execute here check the field value kwert , same it will come at j_1iexcdtl level .

check this first

Former Member
0 Kudos

Hi Sivasankar,

Thanks in advance for your co-operation.

I have checked the field value KAWRT(Condition base value), its reflected corrrect amount i.e. 22,000 for Basic excise condition type(JEXP). Please find screen shot for your reference.

Please guide me as early as possible.

 

.

Regards,

Manoranjan.

bsivasankarreddy_reddy
Active Contributor
0 Kudos

hi

field is not KAWRT,  you find the values of KWERT , pl check this

Former Member
0 Kudos

Hi,

I have checked the condition value field(KWERT) correctly showing on the other hand my question is that how can i checked test line value i.e. (Total captive con. value) , form this line BED should be calculated. Please see my PP screen shot and guide me.

Regards,

Manoranjan.

bsivasankarreddy_reddy
Active Contributor
0 Kudos

hi

based on from and to number, when you give that number system will calculate the value ,

j_1iexcdtl - base value come form komv-kawrt  only,

User exit for calculating the base TAXINN

CALL FUNCTION 'J_1I7_USEREXIT_CALC_EXC_BASE'

  EXPORTING

   EXCITM_BASE       = excitm-excbase

           vbeln       = *vbrp-vbeln

           POSNR       = *vbrp-posnr

  IMPORTING

    EXCITM_BASE       = excitm-excbase

   TABLES

           konv        = *konv.

*User exit for calculating the base TAXINN

based on system will calculate , on you case system will pick the value

ZTOT condition value it come as excise base value , in you pricing procedure assign the  BAS TYPE routine as 902 for JEXP condition type , pl check the 902 routine logic


Former Member
0 Kudos
Hi,
Please find the logic as bleow for routine 902
FORM FRM_KOND_BASIS_902.
*{   INSERT         DEVK901532                                        1
if komp-kzwi2 ne 0 .
xkwert = komp-kzwi2.
endif .
*}   INSERT
ENDFORM.
Please guide me what can i do.
REgards
Manoranjan
Former Member
0 Kudos

Hi Sivasankar,

Please suggest me what can I do.

Regards,

Manoranjan

bsivasankarreddy_reddy
Active Contributor
0 Kudos

hi

based on this system will pick the value of kwert ,

so system will pick value  ,

you will try the same routine assign the calculation type routine remove the base type ,

then check

Former Member
0 Kudos

Hi,

Don't Mind, actually I am new in SAP.

  I have assigned subtotal(2 = KOMP-KZWI2) against test line item total captive con(step 193 ) in PP.

Please  suggest that remove the base type and assign the calculation type for which condition type i.e. for JEXP(Basic excise duty) or Total captive Con(Step 193).

Please guide me so that i can assign the same routine.

Regards,

Manoranjan

bsivasankarreddy_reddy
Active Contributor
0 Kudos

once thing you can do 

can do the deburge with help to ABAP consultant , then find which value and field it will pick , then you can decide ,

bsivasankarreddy_reddy
Active Contributor
0 Kudos

hi

finally one thing you will check

go to SE37 , give the functional module

J_1I7_USEREXIT_CALC_EXC_BASE

here check the source code and their any special logic you can assign

at source code tab level

Former Member
0 Kudos

Hi Sivasankar,

Thaks a lot, Probelm is sloved through Functional module J_1i7_USEREXIT_CALC_EXC_BASE

Regards,

Manoranjan.

Answers (0)