11-04-2015 10:35 AM
Hi ,
When i run T.Code : ME23N i am getting the following error message
Error analysis
The following syntax error was found in the program SAPLV61A :
"Type "J_1AR_BUTYPE" is unknown"
" "
" "
" "
What happened?
Error in the ABAP Application Program
The current ABAP program "SAPLMEPO" had to be terminated because it has
come across a statement that unfortunately cannot be executed.
The following syntax error occurred in program "SAPLV61A " in include "FV64A334
" in
line 12:
"Type "J_1AR_BUTYPE" is unknown"
" "
" "
" "
The include has been created and last changed by:
Created by: "SAP "
Last changed by: "SAP "
Error in the ABAP Application Program
The current ABAP program "SAPLMEPO" had to be terminated because it has
come across a statement that unfortunately cannot be executed.
Source Code is :
1 | *---------------------------------------------------------------------* |
2 | * FORM KONDITIONEN_LESEN * |
3 | *---------------------------------------------------------------------* |
4 | * ........ * |
5 | *---------------------------------------------------------------------* |
6 | FORM konditionen_lesen. |
7
8 | IF ekko-knumv NE space AND t160-vorga NE vorga-anha. |
9 | komk-knumv = ekko-knumv. |
10 | komk-kappl = 'M'. "776070 |
11 | REFRESH tkomv. |
12 | ENHANCEMENT-SECTION KONDITIONEN_LESEN_02 SPOTS ES_MM06EFKO_KONDITIONEN_LESEN INCLUDE BOUND. |
13 | CALL FUNCTION 'RV_KONV_SELECT' " (This line is throwing Exeception) |
14 | EXPORTING |
15 | comm_head_i = komk |
16 | general_read = 'X' |
17 | TABLES |
18 | tkomv = tkomv. |
19 | END-ENHANCEMENT-SECTION. |
20
21 | ENHANCEMENT-POINT konditionen_lesen_01 SPOTS es_mm06efko_konditionen_lesen INCLUDE BOUND. |
22
23 | * den alten Stand für den Konditionsindex merken |
24 | otkomv[] = tkomv[]. |
25 | ENDIF. |
26
27 | ENDFORM. "KONDITIONEN_LESEN |
Please help me to solve this issue
Thanks & Regards,
Saad Mehmood
11-04-2015 11:51 AM
Hi SM,
According to error message it is clear that the object 'J_1AR_BUTYPE' is missing in your system.
From the description, i understand that the object is related to Argentina.
So you have to create this as per SAP instructions, I found SAP not: 1346188 which will create required object in your system. Check related notes if possible for complete solution.
Regards,
Surendra Gupta.
11-04-2015 11:06 AM
Hello Saad,
Please refer below Snote and let me know
1914860 - ME22N/ME23N : SYNTAX_ERROR
1911449 - ME21N : SYNTAX_ERROR
Regards
Eknath
11-04-2015 11:40 AM
Hello Eknath,
I have read both Sap Note.
1914860 - ME22N/ME23N : SYNTAX_ERROR (Both Table have same fields)
1911449 - ME21N : SYNTAX_ERROR (Error is not occured in ME21N its working fine)
The problem is when i investigate this problem in more detail i found out that
Include FV64A334
*&---------------------------------------------------------------------*
*& Form FRM_KONDI_WERT_334
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
FORM FRM_KONDI_WERT_334.
DATA : lt_komp TYPE komp OCCURS 0 WITH HEADER LINE,
wa_komp LIKE komp,
lt_knbw TYPE knbw OCCURS 0 WITH HEADER LINE,
wa_t059z LIKE t059z,
lt_butype TYPE j_1ar_butype OCCURS 0 WITH HEADER LINE, " does not recognizing this Type j_1ar_butype.
lt_wtad TYPE wtad OCCURS 0 WITH HEADER LINE,
lt_bseg TYPE bseg OCCURS 0 WITH HEADER LINE,
lt_bkpf TYPE bkpf OCCURS 0 WITH HEADER LINE,
lt_bsid TYPE bsid OCCURS 0 WITH HEADER LINE,
lt_komv TYPE komv_index OCCURS 0 WITH HEADER LINE,
lt_dtype TYPE j_1ar_dtype OCCURS 0 WITH HEADER LINE,
lt_gridt TYPE j_1ar_gridt OCCURS 0 WITH HEADER LINE,
it_komv TYPE komv OCCURS 0 WITH HEADER LINE,
wa_komv LIKE komv_index,
wa_dtype LIKE j_1ar_dtype,
wa_knb1 LIKE knb1,
l_tbl_upt TYPE C,
l_liable TYPE C,
l_xkwert TYPE konv-kwert,
l_netwr TYPE komp-netwr,
wa_t001 LIKE t001,
wa_tplist LIKE j_1ar_tplist,
wa_kna1 LIKE kna1.
DATA : l_unit_sum TYPE komp-netpr,
fromdate TYPE SY-DATUM,
curyear TYPE SY-DATUM,
lastyear TYPE SY-DATUM,
startyear TYPE SY-DATUM,
startmonth TYPE SY-DATUM,
enddate TYPE SY-DATUM,
curmonth TYPE SY-DATUM,
month(2) TYPE n,
num(2) TYPE n,
num1(2) TYPE n,
l_sum TYPE komp-netwr,
l_komv(10) TYPE C.
* Checking for the Header level pricing execution
IF PREISFINDUNGSART_KOPF IS INITIAL.
CALL FUNCTION 'J_1A_GET_GLOBAL_VAR'
IMPORTING
KWERT = l_xkwert
LIABLE = l_liable
TBL_UPDATE = l_tbl_upt
TABLES
DTYPE = lt_dtype.
IF l_liable IS NOT INITIAL.
l_liable = ''.
l_xkwert = ''.
l_tbl_upt = ''.
CLEAR lt_dtype.
REFRESH lt_dtype.
CALL FUNCTION 'J_1A_SET_GLOBAL_VAR'
EXPORTING
KWERT = l_xkwert
LIABLE = l_liable
TBL_UPDATE = l_tbl_upt
TABLES
DTYPE = lt_dtype.
ENDIF.
EXIT.
ENDIF.
IF komk-aland = 'AR'.
CALL FUNCTION 'J_1A_GET_GLOBAL_VAR'
IMPORTING
KWERT = l_xkwert
LIABLE = l_liable
TBL_UPDATE = l_tbl_upt
TABLES
DTYPE = lt_dtype.
************************************************************************************************
* Already executed for first item
* then no need to execute for the next items.
IF l_liable = 'X'.
IF l_xkwert = 0.
xkwert = 0.
ENDIF.
* komk-fkart is filled only in Billing not in Sales Order
IF ( SY-UCOMM = 'YES' OR SY-UCOMM = 'SICH' ) AND komk-fkart IS NOT INITIAL.
IF lt_dtype[] IS NOT INITIAL.
SORT lt_dtype by bukrs accno.
DELETE ADJACENT DUPLICATES FROM lt_dtype COMPARING bukrs accno.
IF l_tbl_upt IS INITIAL.
CALL FUNCTION 'J_1A_UPDATE_DTYPE' IN UPDATE TASK
TABLES
LT_DTYPE = lt_dtype.
l_tbl_upt = 'X'.
ENDIF.
ENDIF.
ENDIF.
ELSE.
************************************************************************************************
* Check whether the Customer is there in the tax payer list
* SELECT SINGLE * FROM j_1ar_tplist
* INTO wa_tplist
* WHERE koart = 'D'
* AND accno = komk-kunnr
* AND date_start >= komk-fkdat
* AND to_end <= komk-fkdat.
* IF SY-SUBRC <> 0.
SELECT SINGLE * FROM KNA1
INTO wa_kna1
WHERE kunnr = komk-kunnr.
IF SY-SUBRC = 0.
* Check whether the Customer/Vendor with same CUIT number is there in the tax payer list
SELECT SINGLE * FROM j_1ar_tplist "#EC *
INTO wa_tplist
WHERE cuit = wa_kna1-stcd1
AND date_start <= komk-fkdat
AND to_end >= komk-fkdat.
IF SY-SUBRC = 0.
wa_tplist-accno = komk-kunnr.
ENDIF.
ENDIF.
* ENDIF.
IF wa_tplist-accno IS INITIAL. " Customer is not there in tax payer list
* Check whether the Customer is liable for tax.
SELECT SINGLE * FROM j_1ar_dtype "#EC *
INTO wa_dtype
WHERE bukrs = komk-bukrs
AND cuit = wa_kna1-stcd1
AND v_taxable = 'X'.
IF SY-SUBRC <> 0.
* Fetch the threshold limit
SELECT SINGLE * FROM t001
INTO wa_t001
WHERE bukrs = komk-bukrs
AND land1 = 'AR'.
SELECT * FROM j_1ar_butype
INTO TABLE lt_butype
WHERE LAND1 = 'AR'.
*AND WITHCD2 = 'SALES'.
* Fetch the Witholding tax master data
SELECT SINGLE * FROM t059z
INTO wa_t059z
WHERE qscod = '692'.
* Fetch all the Distribution types
SELECT * FROM j_1ar_gridt
INTO TABLE lt_gridt
WHERE bukrs = komk-bukrs.
* Checking if the Customer belongs to a
* specific Region liable for Gross Income Pr
IF lt_gridt[] IS INITIAL.
xkwert = 0.
l_xkwert = 0.
l_liable = 'X'.
ELSE.
SELECT SINGLE * FROM knb1
INTO wa_knb1
WHERE kunnr = komk-kunnr
AND bukrs = komk-bukrs.
READ TABLE lt_gridt WITH KEY gridt = wa_knb1-gridt.
IF SY-SUBRC <> 0.
xkwert = 0.
l_xkwert = 0.
l_liable = 'X'.
ELSE.
* Fetch the Witholding tax details of the Customers
SELECT * FROM knbw INTO TABLE lt_knbw
WHERE kunnr = wa_knb1-kunnr
AND bukrs = komk-bukrs
AND wt_agent = 'X'.
IF NOT lt_knbw[] IS INITIAL.
READ TABLE lt_knbw WITH KEY WITHT = wa_t059z-witht WT_WITHCD = wa_t059z-wt_withcd.
IF SY-SUBRC = 0.
READ TABLE lt_butype WITH KEY land1 = wa_t059z-land1 withcd2 = wa_t059z-withcd2.
IF SY-SUBRC = 0.
* lt_komp[] = tkomp[].
it_komv[] = tkomv[].
LOOP AT it_komv WHERE koaid = 'B' AND kntyp = 'H'.
IF I_CURRENCY_NEW_RATE IS NOT INITIAL.
komk-kurrf = I_CURRENCY_NEW_RATE.
ELSEIF I_CURRENCY_OLD_RATE IS NOT INITIAL.
komk-kurrf = I_CURRENCY_OLD_RATE.
ENDIF.
IF it_komv-waers <> wa_t001-waers.
CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'
EXPORTING
date = komk-fkdat
foreign_amount = it_komv-kbetr
foreign_currency = it_komv-waers
local_currency = t001-waers
rate = komk-kurrf
IMPORTING
local_amount = it_komv-kbetr
EXCEPTIONS
no_rate_found = 1
overflow = 2
no_factors_found = 3
no_spread_found = 4
OTHERS = 5.
IF sy-subrc <> 0.
MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.
CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'
EXPORTING
date = komk-fkdat
foreign_amount = it_komv-kwert
foreign_currency = it_komv-waers
local_currency = t001-waers
rate = komk-kurrf
IMPORTING
local_amount = it_komv-kwert
EXCEPTIONS
no_rate_found = 1
overflow = 2
no_factors_found = 3
no_spread_found = 4
OTHERS = 5.
IF sy-subrc <> 0.
MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.
ENDIF.
l_unit_sum = l_unit_sum + it_komv-kbetr.
ENDLOOP.
* Checking for the Unit Price
IF l_unit_sum < lt_butype-unit_price.
fromdate = komk-fkdat.
enddate = komk-fkdat.
fromdate+6(2) = 01.
enddate+6(2) = 01.
fromdate+0(4) = fromdate+0(4) - 1.
IF fromdate+4(2) > 2.
fromdate+4(2) = fromdate+4(2) - 1.
enddate+4(2) = enddate+4(2) - 2.
ELSEIF fromdate+4(2) = 2.
fromdate+4(2) = 01.
enddate+4(2) = 12.
enddate+0(4) = enddate+0(4) - 1.
ELSEIF fromdate+4(2) = 1.
fromdate+4(2) = 12.
enddate+4(2) = 11.
fromdate+0(4) = fromdate+0(4) - 1.
enddate+0(4) = enddate+0(4) - 1.
ENDIF.
CALL FUNCTION 'RP_LAST_DAY_OF_MONTHS'
EXPORTING
DAY_IN = enddate
IMPORTING
LAST_DAY_OF_MONTH = enddate
EXCEPTIONS
DAY_IN_NO_DATE = 1
OTHERS = 2.
IF SY-SUBRC <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
curyear = enddate+0(4).
lastyear = fromdate+0(4).
startyear = fromdate+0(4).
startmonth = fromdate+4(2).
curmonth = enddate+4(2).
* Fetch the last 11 months balances including the current month
* Witholding Customer table
SELECT * FROM wtad
INTO TABLE lt_wtad
WHERE bukrs = komk-bukrs
AND kunnr = komk-kunnr
AND wt_caly BETWEEN lastyear AND curyear
AND witht = wa_t059z-witht
AND wt_withcd = wa_t059z-wt_withcd.
LOOP AT lt_wtad.
IF lt_wtad-wt_caly = startyear.
month = startmonth.
num = 13 - month.
DO num TIMES.
CASE month.
WHEN '01'.
l_sum = l_sum + lt_wtad-wt_bs01.
WHEN '02'.
l_sum = l_sum + lt_wtad-wt_bs02.
WHEN '03'.
l_sum = l_sum + lt_wtad-wt_bs03.
WHEN '04'.
l_sum = l_sum + lt_wtad-wt_bs04.
WHEN '05'.
l_sum = l_sum + lt_wtad-wt_bs05.
WHEN '06'.
l_sum = l_sum + lt_wtad-wt_bs06.
WHEN '07'.
l_sum = l_sum + lt_wtad-wt_bs07.
WHEN '08'.
l_sum = l_sum + lt_wtad-wt_bs08.
WHEN '09'.
l_sum = l_sum + lt_wtad-wt_bs09.
WHEN '10'.
l_sum = l_sum + lt_wtad-wt_bs10.
WHEN '11'.
l_sum = l_sum + lt_wtad-wt_bs11.
WHEN '12'.
l_sum = l_sum + lt_wtad-wt_bs12.
ENDCASE.
month = month + 01.
ENDDO.
ELSE.
month = curmonth.
num1 = curmonth.
DO num1 TIMES.
CASE month.
WHEN '01'.
l_sum = l_sum + lt_wtad-wt_bs01.
WHEN '02'.
l_sum = l_sum + lt_wtad-wt_bs02.
WHEN '03'.
l_sum = l_sum + lt_wtad-wt_bs03.
WHEN '04'.
l_sum = l_sum + lt_wtad-wt_bs04.
WHEN '05'.
l_sum = l_sum + lt_wtad-wt_bs05.
WHEN '06'.
l_sum = l_sum + lt_wtad-wt_bs06.
WHEN '07'.
l_sum = l_sum + lt_wtad-wt_bs07.
WHEN '08'.
l_sum = l_sum + lt_wtad-wt_bs08.
WHEN '09'.
l_sum = l_sum + lt_wtad-wt_bs09.
WHEN '10'.
l_sum = l_sum + lt_wtad-wt_bs10.
WHEN '11'.
l_sum = l_sum + lt_wtad-wt_bs11.
WHEN '12'.
l_sum = l_sum + lt_wtad-wt_bs12.
ENDCASE.
month = month - 01.
ENDDO.
ENDIF.
ENDLOOP.
* Checking for the Threshold Amount
IF l_sum > lt_butype-threshold.
l_xkwert = xkomv-kwert.
l_liable = 'X'.
lt_dtype-mandt = sy-mandt.
lt_dtype-koart = 'D'.
lt_dtype-accno = komk-kunnr.
lt_dtype-v_taxable = 'X'.
lt_dtype-cuit = wa_kna1-stcd1.
lt_dtype-bukrs = komk-bukrs.
APPEND lt_dtype.
ELSE.
xkwert = 0.
l_xkwert = 0.
l_liable = 'X'.
ENDIF.
ELSE.
l_xkwert = xkomv-kwert.
l_liable = 'X'.
lt_dtype-mandt = sy-mandt.
lt_dtype-koart = 'D'.
lt_dtype-accno = komk-kunnr.
lt_dtype-v_taxable = 'X'.
lt_dtype-cuit = wa_kna1-stcd1.
lt_dtype-bukrs = komk-bukrs.
APPEND lt_dtype.
ENDIF.
ELSE.
xkwert = 0.
l_xkwert = 0.
l_liable = 'X'.
ENDIF.
ELSE.
xkwert = 0.
l_xkwert = 0.
l_liable = 'X'.
ENDIF.
ELSE.
xkwert = 0.
l_xkwert = 0.
l_liable = 'X'.
ENDIF.
ENDIF.
ENDIF.
ELSE.
l_xkwert = xkomv-kwert.
l_liable = 'X'.
ENDIF.
ELSE.
l_xkwert = xkomv-kwert.
l_liable = 'X'.
ENDIF.
ENDIF.
ENDIF.
CALL FUNCTION 'J_1A_SET_GLOBAL_VAR'
EXPORTING
KWERT = l_xkwert
LIABLE = l_liable
TBL_UPDATE = l_tbl_upt
TABLES
DTYPE = lt_dtype.
ENDFORM. "FRM_KONDI_WERT_334
I really appreciate you replied.
Kind Regards
Saad Mehmood
11-04-2015 11:51 AM
Hi SM,
According to error message it is clear that the object 'J_1AR_BUTYPE' is missing in your system.
From the description, i understand that the object is related to Argentina.
So you have to create this as per SAP instructions, I found SAP not: 1346188 which will create required object in your system. Check related notes if possible for complete solution.
Regards,
Surendra Gupta.
11-05-2015 6:23 AM
Hi Surendra,
I was upgrading sap from 4.7 to ecc 6.0
I got an error which i recognized in SPAU with red light button, I resolve that by resting it.
Since that this issue is occurring in ME23n TCODE.
After i deeply investigated this problem i observe that
J1AF Package didnt contain Database Table Named
J_1AR_BUTYPE | Maintain Business Types for Monotributo vendors | TRANSP | C |
J_1AR_DTYPE | ARG - Gross Income Perception Customer Data | TRANSP | A |
Kind Regards
Saad Mehmood
11-05-2015 9:34 AM
11-05-2015 9:39 AM
hi Raymond,
Yes I did but there is nothing in SPDD
But there are some values in SPAU
Kind Regards
Saad Mehmood
11-05-2015 9:54 AM
11-05-2015 10:06 AM
hi Surrender,
I wish that could happen but issue is not resolved yet both SPAU and SPDD showing these screen.
However when I see J1AF package in SE80 J_1AR_BUTYPE database table is missing
Kind Regards
Saad Mehmood
11-05-2015 12:41 PM
Hi SM,
Have you gone through the note mentioned by me earlier i.e., 1346188 - Argentina Legal change - 2009( Monotributo Vendors ), this note contains the object you are looking.
I am pasting the content of the note for your ref.
For each release from 4.6C to 604, kindly apply the attached SAR files present in the ZIP file RG2549_LC_SARfiles.zip
.SAR file details
Release .SAR attachment present in this note
46C RG2549_LC_46C
470 RG2549_LC_470
500 RG2549_LC_500
600 RG2549_LC_600
602 RG2549_LC_602
603 RG2549_LC_603
604 RG2549_LC_604
SAP notes 480180 and 13719 to get more information on downloading the attachments from the note.
SAR files contains the following objects
Data Elements:
ACCPERIOD
ACCTYPE
THR_AMOUNT
THR_WAERS
U_WAERS
U_WRBTR
WT_MTYPE
Tables:
J_1AR_BUTYPE
J_1AR_MTYPE
Function Group
FI_AR
Views:
V_T059Z_AR
V_WTAX_KEY_AR
After implementing the SAR file, please make sure that all the above mentioned objects are available in your system and is Active.
So my advice is to have look into this note and take necessary actions.
Regards,
Surendra Gupta.
11-25-2015 7:57 AM
Hi SM,
Hope your issue is resolved, if yes please close the thread with comments.
11-26-2015 5:06 AM
Hello Surendra,
I have overcome this problem by Upgrading BASIS Service Pack after that.
There are some index missing in these Tables I have added that from SE11, It start working.
Kind Regards
Saad Mehmood