SAP J_1I6_DETERMINE_EXCISE_RATE Function Module for Determine if material is excisable/nonexcisable and the rate









J_1I6_DETERMINE_EXCISE_RATE is a standard j 1i6 determine excise rate SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Determine if material is excisable/nonexcisable and the rate processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.


See here to view full function module documentation and code listing for j 1i6 determine excise rate FM, simply by entering the name J_1I6_DETERMINE_EXCISE_RATE into the relevant SAP transaction such as SE37 or SE38.

Function Group: J1I6
Program Name: SAPLJ1I6
Main Program: SAPLJ1I6
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:



Function J_1I6_DETERMINE_EXCISE_RATE pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.
CALL FUNCTION 'J_1I6_DETERMINE_EXCISE_RATE'"Determine if material is excisable/nonexcisable and the rate
  EXPORTING
   BUKRS =  "
   UNIT =  "
*  VBTYP = ' ' "
*  ORDER = '  ' "
*  DELIVERY = '  ' "
*  VKORG = ' ' "
*  VTWEG = ' ' "
*  FORMC1 = ' ' "Form Type
*  FORMC2 = '   ' "Form Type
   WERKS =  "
   MATNR =  "
   VENDOR =  "
*  KALSM = 'TAXINJ' "
   MWSKZ =  "
*  TAX_DATE = SY-DATUM "
   MENGE =  "
   KAWRT =  "

 IMPORTING
   EXC_AMOUNT =  "
   NCCD_PERC =  "NCCD Rate in %
   ECS_AMOUNT =  "Net Payment Amount
   ECS_PERC =  "ECS rate  in %
   EXADDTAX1_AMOUNT =  "Net Payment Amount
   EXADDTAX2_AMOUNT =  "Net Payment Amount
   EXADDTAX3_AMOUNT =  "Net Payment Amount
   EXADDTAX1_PERC =  "Additional Excise Duty %
   EXADDTAX2_PERC =  "Additional Excise Duty %
   EXADDTAX3_PERC =  "Additional Excise Duty %
   EXC_PERC =  "
   ADD_AMOUNT =  "
   ADD_PERC =  "
   SED_AMOUNT =  "
   SED_PERC =  "
   CESS_AMOUNT =  "
   CESS_PERC =  "
   NCCD_AMOUNT =  "Net Payment Amount

EXCEPTIONS
   CHAPTER_ID_MISSING = 1    COMPANY_DATA_NOT_SETUP = 2    TAX_PROC_INVALID = 3    EXCIND_MISSING = 4    VENDOR_MISSING = 5    TAXCODE_INVALID = 6    EXCISE_RATE_MISSING = 7
.



IMPORTING Parameters details for J_1I6_DETERMINE_EXCISE_RATE

BUKRS -

Data type: T001-BUKRS
Optional: No
Call by Reference: No ( called with pass by value option)

UNIT -

Data type: KOMP-MEINS
Optional: No
Call by Reference: No ( called with pass by value option)

VBTYP -

Data type: KOMK-VBTYP
Default: ' '
Optional: Yes
Call by Reference: No ( called with pass by value option)

ORDER -

Data type: VBAK-VBELN
Default: ' '
Optional: Yes
Call by Reference: No ( called with pass by value option)

DELIVERY -

Data type: LIKP-VBELN
Default: ' '
Optional: Yes
Call by Reference: No ( called with pass by value option)

VKORG -

Data type: KOMK-VKORG
Default: ' '
Optional: Yes
Call by Reference: No ( called with pass by value option)

VTWEG -

Data type: KOMK-VTWEG
Default: ' '
Optional: Yes
Call by Reference: No ( called with pass by value option)

FORMC1 - Form Type

Data type: J_1IFRMTYP-J_1IFRMTYP
Default: ' '
Optional: Yes
Call by Reference: No ( called with pass by value option)

FORMC2 - Form Type

Data type: J_1IFRMTYP-J_1IFRMTYP
Default: ' '
Optional: Yes
Call by Reference: No ( called with pass by value option)

WERKS -

Data type: VBAP-WERKS
Optional: No
Call by Reference: No ( called with pass by value option)

MATNR -

Data type: MARA-MATNR
Optional: No
Call by Reference: No ( called with pass by value option)

VENDOR -

Data type: LFA1-LIFNR
Optional: No
Call by Reference: No ( called with pass by value option)

KALSM -

Data type: T007A-KALSM
Default: 'TAXINJ'
Optional: Yes
Call by Reference: Yes

MWSKZ -

Data type: T007A-MWSKZ
Optional: No
Call by Reference: Yes

TAX_DATE -

Data type: KOMK-PRSDT
Default: SY-DATUM
Optional: Yes
Call by Reference: No ( called with pass by value option)

MENGE -

Data type: MSEG-MENGE
Optional: No
Call by Reference: No ( called with pass by value option)

KAWRT -

Data type: KOMV-KAWRT
Optional: No
Call by Reference: No ( called with pass by value option)

EXPORTING Parameters details for J_1I6_DETERMINE_EXCISE_RATE

EXC_AMOUNT -

Data type: TAXCOM-NEBTR
Optional: No
Call by Reference: No ( called with pass by value option)

NCCD_PERC - NCCD Rate in %

Data type: J_1IEXCTAX-J_1INCCDRAT
Optional: No
Call by Reference: No ( called with pass by value option)

ECS_AMOUNT - Net Payment Amount

Data type: TAXCOM-NEBTR
Optional: No
Call by Reference: No ( called with pass by value option)

ECS_PERC - ECS rate in %

Data type: J_1IEXCTAX-ECSRATE
Optional: No
Call by Reference: No ( called with pass by value option)

EXADDTAX1_AMOUNT - Net Payment Amount

Data type: TAXCOM-NEBTR
Optional: No
Call by Reference: No ( called with pass by value option)

EXADDTAX2_AMOUNT - Net Payment Amount

Data type: TAXCOM-NEBTR
Optional: No
Call by Reference: No ( called with pass by value option)

EXADDTAX3_AMOUNT - Net Payment Amount

Data type: TAXCOM-NEBTR
Optional: No
Call by Reference: No ( called with pass by value option)

EXADDTAX1_PERC - Additional Excise Duty %

Data type: J_1IEXCTAX-J_1IAEDRAT
Optional: No
Call by Reference: No ( called with pass by value option)

EXADDTAX2_PERC - Additional Excise Duty %

Data type: J_1IEXCTAX-J_1IAEDRAT
Optional: No
Call by Reference: No ( called with pass by value option)

EXADDTAX3_PERC - Additional Excise Duty %

Data type: J_1IEXCTAX-J_1IAEDRAT
Optional: No
Call by Reference: No ( called with pass by value option)

EXC_PERC -

Data type: J_1IEXCTAX-RATE
Optional: No
Call by Reference: No ( called with pass by value option)

ADD_AMOUNT -

Data type: TAXCOM-NEBTR
Optional: No
Call by Reference: No ( called with pass by value option)

ADD_PERC -

Data type: J_1IEXCTAX-J_1IAEDRAT
Optional: No
Call by Reference: No ( called with pass by value option)

SED_AMOUNT -

Data type: TAXCOM-NEBTR
Optional: No
Call by Reference: No ( called with pass by value option)

SED_PERC -

Data type: J_1IEXCTAX-J_1ISEDRAT
Optional: No
Call by Reference: No ( called with pass by value option)

CESS_AMOUNT -

Data type: TAXCOM-NEBTR
Optional: No
Call by Reference: No ( called with pass by value option)

CESS_PERC -

Data type: J_1IADDEXC-J_1ICESSPC
Optional: No
Call by Reference: No ( called with pass by value option)

NCCD_AMOUNT - Net Payment Amount

Data type: TAXCOM-NEBTR
Optional: No
Call by Reference: No ( called with pass by value option)

EXCEPTIONS details

CHAPTER_ID_MISSING -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

COMPANY_DATA_NOT_SETUP -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

TAX_PROC_INVALID -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

EXCIND_MISSING -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

VENDOR_MISSING -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

TAXCODE_INVALID -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

EXCISE_RATE_MISSING -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

Copy and paste ABAP code example for J_1I6_DETERMINE_EXCISE_RATE Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the newer method of declaring data variables on the fly. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8), which i why i have stuck to the origianl for this example.

DATA:
lv_bukrs  TYPE T001-BUKRS, "   
lv_exc_amount  TYPE TAXCOM-NEBTR, "   
lv_chapter_id_missing  TYPE TAXCOM, "   
lv_unit  TYPE KOMP-MEINS, "   
lv_nccd_perc  TYPE J_1IEXCTAX-J_1INCCDRAT, "   
lv_vbtyp  TYPE KOMK-VBTYP, "   ' '
lv_ecs_amount  TYPE TAXCOM-NEBTR, "   
lv_order  TYPE VBAK-VBELN, "   ' '
lv_ecs_perc  TYPE J_1IEXCTAX-ECSRATE, "   
lv_delivery  TYPE LIKP-VBELN, "   ' '
lv_exaddtax1_amount  TYPE TAXCOM-NEBTR, "   
lv_vkorg  TYPE KOMK-VKORG, "   ' '
lv_exaddtax2_amount  TYPE TAXCOM-NEBTR, "   
lv_vtweg  TYPE KOMK-VTWEG, "   ' '
lv_exaddtax3_amount  TYPE TAXCOM-NEBTR, "   
lv_formc1  TYPE J_1IFRMTYP-J_1IFRMTYP, "   ' '
lv_exaddtax1_perc  TYPE J_1IEXCTAX-J_1IAEDRAT, "   
lv_formc2  TYPE J_1IFRMTYP-J_1IFRMTYP, "   ' '
lv_exaddtax2_perc  TYPE J_1IEXCTAX-J_1IAEDRAT, "   
lv_exaddtax3_perc  TYPE J_1IEXCTAX-J_1IAEDRAT, "   
lv_werks  TYPE VBAP-WERKS, "   
lv_exc_perc  TYPE J_1IEXCTAX-RATE, "   
lv_company_data_not_setup  TYPE J_1IEXCTAX, "   
lv_matnr  TYPE MARA-MATNR, "   
lv_add_amount  TYPE TAXCOM-NEBTR, "   
lv_tax_proc_invalid  TYPE TAXCOM, "   
lv_vendor  TYPE LFA1-LIFNR, "   
lv_add_perc  TYPE J_1IEXCTAX-J_1IAEDRAT, "   
lv_excind_missing  TYPE J_1IEXCTAX, "   
lv_kalsm  TYPE T007A-KALSM, "   'TAXINJ'
lv_sed_amount  TYPE TAXCOM-NEBTR, "   
lv_vendor_missing  TYPE TAXCOM, "   
lv_mwskz  TYPE T007A-MWSKZ, "   
lv_sed_perc  TYPE J_1IEXCTAX-J_1ISEDRAT, "   
lv_taxcode_invalid  TYPE J_1IEXCTAX, "   
lv_tax_date  TYPE KOMK-PRSDT, "   SY-DATUM
lv_cess_amount  TYPE TAXCOM-NEBTR, "   
lv_excise_rate_missing  TYPE TAXCOM, "   
lv_menge  TYPE MSEG-MENGE, "   
lv_cess_perc  TYPE J_1IADDEXC-J_1ICESSPC, "   
lv_kawrt  TYPE KOMV-KAWRT, "   
lv_nccd_amount  TYPE TAXCOM-NEBTR. "   

  CALL FUNCTION 'J_1I6_DETERMINE_EXCISE_RATE'  "Determine if material is excisable/nonexcisable and the rate
    EXPORTING
         BUKRS = lv_bukrs
         UNIT = lv_unit
         VBTYP = lv_vbtyp
         ORDER = lv_order
         DELIVERY = lv_delivery
         VKORG = lv_vkorg
         VTWEG = lv_vtweg
         FORMC1 = lv_formc1
         FORMC2 = lv_formc2
         WERKS = lv_werks
         MATNR = lv_matnr
         VENDOR = lv_vendor
         KALSM = lv_kalsm
         MWSKZ = lv_mwskz
         TAX_DATE = lv_tax_date
         MENGE = lv_menge
         KAWRT = lv_kawrt
    IMPORTING
         EXC_AMOUNT = lv_exc_amount
         NCCD_PERC = lv_nccd_perc
         ECS_AMOUNT = lv_ecs_amount
         ECS_PERC = lv_ecs_perc
         EXADDTAX1_AMOUNT = lv_exaddtax1_amount
         EXADDTAX2_AMOUNT = lv_exaddtax2_amount
         EXADDTAX3_AMOUNT = lv_exaddtax3_amount
         EXADDTAX1_PERC = lv_exaddtax1_perc
         EXADDTAX2_PERC = lv_exaddtax2_perc
         EXADDTAX3_PERC = lv_exaddtax3_perc
         EXC_PERC = lv_exc_perc
         ADD_AMOUNT = lv_add_amount
         ADD_PERC = lv_add_perc
         SED_AMOUNT = lv_sed_amount
         SED_PERC = lv_sed_perc
         CESS_AMOUNT = lv_cess_amount
         CESS_PERC = lv_cess_perc
         NCCD_AMOUNT = lv_nccd_amount
    EXCEPTIONS
        CHAPTER_ID_MISSING = 1
        COMPANY_DATA_NOT_SETUP = 2
        TAX_PROC_INVALID = 3
        EXCIND_MISSING = 4
        VENDOR_MISSING = 5
        TAXCODE_INVALID = 6
        EXCISE_RATE_MISSING = 7
. " J_1I6_DETERMINE_EXCISE_RATE




ABAP code using 7.40 inline data declarations to call FM J_1I6_DETERMINE_EXCISE_RATE

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

"SELECT single BUKRS FROM T001 INTO @DATA(ld_bukrs).
 
"SELECT single NEBTR FROM TAXCOM INTO @DATA(ld_exc_amount).
 
 
"SELECT single MEINS FROM KOMP INTO @DATA(ld_unit).
 
"SELECT single J_1INCCDRAT FROM J_1IEXCTAX INTO @DATA(ld_nccd_perc).
 
"SELECT single VBTYP FROM KOMK INTO @DATA(ld_vbtyp).
DATA(ld_vbtyp) = ' '.
 
"SELECT single NEBTR FROM TAXCOM INTO @DATA(ld_ecs_amount).
 
"SELECT single VBELN FROM VBAK INTO @DATA(ld_order).
DATA(ld_order) = ' '.
 
"SELECT single ECSRATE FROM J_1IEXCTAX INTO @DATA(ld_ecs_perc).
 
"SELECT single VBELN FROM LIKP INTO @DATA(ld_delivery).
DATA(ld_delivery) = ' '.
 
"SELECT single NEBTR FROM TAXCOM INTO @DATA(ld_exaddtax1_amount).
 
"SELECT single VKORG FROM KOMK INTO @DATA(ld_vkorg).
DATA(ld_vkorg) = ' '.
 
"SELECT single NEBTR FROM TAXCOM INTO @DATA(ld_exaddtax2_amount).
 
"SELECT single VTWEG FROM KOMK INTO @DATA(ld_vtweg).
DATA(ld_vtweg) = ' '.
 
"SELECT single NEBTR FROM TAXCOM INTO @DATA(ld_exaddtax3_amount).
 
"SELECT single J_1IFRMTYP FROM J_1IFRMTYP INTO @DATA(ld_formc1).
DATA(ld_formc1) = ' '.
 
"SELECT single J_1IAEDRAT FROM J_1IEXCTAX INTO @DATA(ld_exaddtax1_perc).
 
"SELECT single J_1IFRMTYP FROM J_1IFRMTYP INTO @DATA(ld_formc2).
DATA(ld_formc2) = ' '.
 
"SELECT single J_1IAEDRAT FROM J_1IEXCTAX INTO @DATA(ld_exaddtax2_perc).
 
"SELECT single J_1IAEDRAT FROM J_1IEXCTAX INTO @DATA(ld_exaddtax3_perc).
 
"SELECT single WERKS FROM VBAP INTO @DATA(ld_werks).
 
"SELECT single RATE FROM J_1IEXCTAX INTO @DATA(ld_exc_perc).
 
 
"SELECT single MATNR FROM MARA INTO @DATA(ld_matnr).
 
"SELECT single NEBTR FROM TAXCOM INTO @DATA(ld_add_amount).
 
 
"SELECT single LIFNR FROM LFA1 INTO @DATA(ld_vendor).
 
"SELECT single J_1IAEDRAT FROM J_1IEXCTAX INTO @DATA(ld_add_perc).
 
 
"SELECT single KALSM FROM T007A INTO @DATA(ld_kalsm).
DATA(ld_kalsm) = 'TAXINJ'.
 
"SELECT single NEBTR FROM TAXCOM INTO @DATA(ld_sed_amount).
 
 
"SELECT single MWSKZ FROM T007A INTO @DATA(ld_mwskz).
 
"SELECT single J_1ISEDRAT FROM J_1IEXCTAX INTO @DATA(ld_sed_perc).
 
 
"SELECT single PRSDT FROM KOMK INTO @DATA(ld_tax_date).
DATA(ld_tax_date) = SY-DATUM.
 
"SELECT single NEBTR FROM TAXCOM INTO @DATA(ld_cess_amount).
 
 
"SELECT single MENGE FROM MSEG INTO @DATA(ld_menge).
 
"SELECT single J_1ICESSPC FROM J_1IADDEXC INTO @DATA(ld_cess_perc).
 
"SELECT single KAWRT FROM KOMV INTO @DATA(ld_kawrt).
 
"SELECT single NEBTR FROM TAXCOM INTO @DATA(ld_nccd_amount).
 


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!