topic Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2 in Application Development and Automation Discussions

Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Wed, 23 Nov 2011 09:39:54 GMT

Hello!

I am using BAPI_SALESORDER_CREATEFROMDAT2 for creating the Sales order. But I have a problem when Iu2019m trying to create configuration. I think that parameter order_items_in-material should be generated before calling BAPI described above. I try to use order_items_in-mat_entrd, but BAPI return error message id = V1, number = 320 (No item category available (Table T184 ZAPC TEXT )).

Help me please, How I can solve this problem?

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Wed, 23 Nov 2011 12:15:27 GMT

You can solve it by understanding the error message you mentioned.

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Wed, 23 Nov 2011 12:27:46 GMT

I checked this entry "ZAPC" in the table t184. This entry exists. Moreover, When I create sales order with the same parameters from VA01 this message didn't appear.

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Wed, 23 Nov 2011 12:34:04 GMT

Did you check the long text of said message?

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Wed, 23 Nov 2011 13:07:11 GMT

Yes, I checked long text. But when I'm trying to use the field order_items_in-material instead order_items_in-mat_entrd this message didn't display. But in this case, configuration is not created.

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Wed, 23 Nov 2011 13:42:43 GMT

So in fact you have a totally different problem? You're not able to asve the configuration? In that case check the documentation on the function. There is a areference to an OSS note.

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Thu, 24 Nov 2011 06:50:09 GMT

I read note 93091 but I didn't get any useful information. May be you know FM which gets the configuration on the entered criteria.

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

madhu_vadlamani — Thu, 24 Nov 2011 06:53:12 GMT

Hi Sergey,

Are you creating a sales order with configurable item.Give me more details in this.

Regards,

Madhu.

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Thu, 24 Nov 2011 07:00:10 GMT

I use the follow code:

Unformatted code removed.

Edited by: Rob Burbank on Nov 24, 2011 10:19 AM

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Thu, 24 Nov 2011 07:04:17 GMT


I read note 93091 but I didn't get any useful information. May be you know FM which gets the configuration on the entered criteria.

Ok.. are you creating the configuration or are you retrieving the configuration.

As for the note: it clearly describes (under section II) how to populate the internal tables to pass the configuration data. So.. unless you forgot your glasses when reading the note or were blinded by the sun reflection on your screen, i guess you didn't even read the note.

edit: i used that same note to find out how to pass the proper contents to the BAPI for the configuration.

Edited by: Maen Anachronos on Nov 24, 2011 8:05 AM

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

madhu_vadlamani — Thu, 24 Nov 2011 07:05:04 GMT

Hi Sergey,

Please paste your code in code format.If it is a configurable material where is the characteristics and its values .

wa_order_ref-posex = '000010'.

wa_order_ref-root_id = inst_id.

wa_order_ref-config_id = conf_id.

INSERT wa_order_ref INTO TABLE tab_order_ref

Regards,

Madhu.

Edited by: madhurao123 on Nov 24, 2011 12:37 PM

Edited by: madhurao123 on Nov 24, 2011 12:38 PM

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Thu, 24 Nov 2011 07:08:55 GMT

What is even worse: if you scroll down that OSS note, you'll see another OSS note with a fully written out example how to build your configuration tables.

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Thu, 24 Nov 2011 07:14:07 GMT

Unformatted code removed.

Edited by: Rob Burbank on Nov 24, 2011 10:19 AM

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Thu, 24 Nov 2011 07:22:16 GMT

FUNCTION Z_SD_GET_TEH_COST. "----

"  IMPORTING "     REFERENCE(IS_COST_ORDER) TYPE  ZWCLIF_COST_ORDER "  EXPORTING "     REFERENCE(EV_KBETR) TYPE  KBETR "----

DEFINE fill_prizn.     IF is_cost_order-&1 IS NOT INITIAL.       CLEAR: ls_cfgs_value-charc,              ls_cfgs_value-value.       ls_cfgs_value-charc = &2.       ls_cfgs_value-value = is_cost_order-&1. *      ls_cfgs_value-valcode = '1'.       APPEND ls_cfgs_value TO lt_cfgs_value.     ENDIF.   END-OF-DEFINITION.

DATA: ls_header_in TYPE bapisdhd1,       ls_header_inx TYPE bapisdhd1x,

lt_partners TYPE TABLE OF bapiparnr,       ls_partners TYPE bapiparnr,

lt_items_in TYPE TABLE OF bapisditm,       lt_items_inx TYPE TABLE OF bapisditmx,

ls_items_in TYPE bapisditm,       ls_items_inx TYPE bapisditmx,

ls_cfgs_ref TYPE bapicucfg,       lt_cfgs_ref TYPE TABLE OF bapicucfg,

lt_cfgs_value TYPE TABLE OF bapicuval,       ls_cfgs_value TYPE bapicuval,

lt_schedules_in TYPE TABLE OF bapischdl,       ls_schedules_in TYPE bapischdl,

lt_schedules_inx TYPE TABLE OF bapischdlx,       ls_schedules_inx TYPE bapischdlx,

lt_cfgs_inst TYPE TABLE OF bapicuins,       ls_cfgs_inst TYPE bapicuins,       lt_cfgs_partof TYPE TABLE OF bapicuprt,       ls_cfgs_partof TYPE bapicuprt,

lv_vbeln TYPE bapivbeln-vbeln,       lt_return TYPE TABLE OF bapiret2.

* fill header   ls_header_in-doc_type = 'ZAPC'.   ls_header_in-sales_org = is_cost_order-vkorg.   ls_header_in-distr_chan = is_cost_order-vtweg.   ls_header_in-division = '01'.   ls_header_in-sales_off = '1011'.

ls_header_inx-updateflag = 'I'.   ls_header_inx-doc_type = 'X'.   ls_header_inx-sales_org = 'X'.   ls_header_inx-distr_chan = 'X'.   ls_header_inx-division = 'X'.   ls_header_inx-sales_off = 'X'.

* fill partners   ls_partners-partn_role = 'AG'.   ls_partners-partn_numb = '1000000031'.   " фиктивный заказчик   APPEND ls_partners TO lt_partners.

*  ls_items_in-material = is_cost_order-matnr.   ls_items_in-mat_entrd = is_cost_order-matnr.   ls_items_in-target_qty = '1'.   ls_items_in-itm_number = '000001'.   ls_items_in-po_itm_no = '000001'.   ls_items_in-item_categ = 'ZCRM'.   SELECT SINGLE meins INTO ls_items_in-target_qu     FROM mara     WHERE matnr = is_cost_order-matnr.   APPEND ls_items_in TO lt_items_in.

ls_items_inx-itm_number = '000001'.   ls_items_inx-item_categ = 'X'.   ls_items_inx-po_itm_no = 'X'. *  ls_items_inx-material = 'X'.   ls_items_inx-mat_entrd = 'X'.   ls_items_inx-target_qty = 'X'.   ls_items_inx-target_qu = 'X'.   ls_items_inx-updateflag = 'I'.   APPEND ls_items_inx TO lt_items_inx.

* fill configuration   ls_cfgs_ref-posex = '000001'.   ls_cfgs_ref-config_id = '000001'.   ls_cfgs_ref-root_id = '00000001'.   APPEND ls_cfgs_ref TO lt_cfgs_ref.

ls_cfgs_value-config_id = '000001'.   ls_cfgs_value-inst_id = '00000001'.

fill_prizn kod_prod 'KOD_PROD'.   fill_prizn tlot_min 'TLOT_MIN'.   fill_prizn tlot_max 'TLOT_MAX'.   fill_prizn shot_min 'SHOT_MIN'.   fill_prizn shot_max 'SHOT_MAX'.   fill_prizn dlot_min 'DLOT_MIN'.   fill_prizn dlot_max 'DLOT_MAX'.   fill_prizn marka 'MARKA'.   fill_prizn stndrt_marka 'STNDRT_MARKA'.   fill_prizn stndrt_prod  'STNDRT_PROD'.   fill_prizn tprk 'TPRK'.   fill_prizn grot 'GROT'.   fill_prizn vityazhka 'VITYAZHKA'.   fill_prizn krom 'KROM'.   fill_prizn chisl_st_pokr 'CHISL_ST_POKR'.   fill_prizn kls_tol_pokr  'KLS_TOL_POKR'.   fill_prizn proch_izg_t_lic_max 'PROCH_IZG_T_LIC_MAX'.   fill_prizn priz_zasch_pov 'PRIZ_ZASCH_POV'.   fill_prizn vid_pokr  'VID_POKR'.   fill_prizn mark_pokr 'MARK_POKR'.   fill_prizn mat_pokr_lic 'MAT_POKR_LIC'.   fill_prizn plsk 'PLSK'.   fill_prizn vid_postavki 'VID_POSTAVKI'.   fill_prizn dressir 'DRESSIR'.   fill_prizn travl   'TRAVL'.   fill_prizn fsfr_min 'FSFR_MIN'.   fill_prizn fsfr_max 'FSFR_MAX'.   fill_prizn krmn_min 'KRMN_MIN'.   fill_prizn krmn_max 'KRMN_MAX'.   fill_prizn mrgn_min 'MRGN_MIN'.   fill_prizn mrgn_max 'MRGN_MAX'.   fill_prizn almn_min 'ALMN_MIN'.   fill_prizn almn_max 'ALMN_MAX'.   fill_prizn cugl_min 'CUGL_MIN'.   fill_prizn cugl_max 'CUGL_MAX'.

ls_schedules_in-itm_number = '000001'. *  ls_schedules_in-req_date = sy-datum.   ls_schedules_in-sched_line = '0001'.   ls_schedules_in-req_qty = '1'.   APPEND ls_schedules_in TO lt_schedules_in.

ls_schedules_inx-itm_number = '000001'.   ls_schedules_inx-sched_line = '0001'. *  ls_schedules_inx-req_date = 'X'.   ls_schedules_inx-req_qty = 'X'.   ls_schedules_inx-updateflag = 'I'.   APPEND ls_schedules_inx TO lt_schedules_inx.

ls_cfgs_partof-parent_id = '00000001'.   ls_cfgs_partof-inst_id = '00000001'.   ls_cfgs_partof-class_type = '300'.   ls_cfgs_partof-obj_type = 'MARA'.   ls_cfgs_partof-obj_key = is_cost_order-matnr.   APPEND ls_cfgs_partof TO lt_cfgs_partof.

ls_cfgs_inst-config_id = '000001'.   ls_cfgs_inst-inst_id = '00000001'.   ls_cfgs_inst-obj_type = 'MARA'.   ls_cfgs_inst-class_type = '300'.   ls_cfgs_inst-obj_key = is_cost_order-matnr.   APPEND ls_cfgs_inst TO lt_cfgs_inst.

CALL FUNCTION 'BAPI_SALESORDER_CREATEFROMDAT2'     EXPORTING       order_header_in               = ls_header_in       order_header_inx              = ls_header_inx *      testrun                       =     IMPORTING       salesdocument                 = lv_vbeln     TABLES       return                        = lt_return       order_items_in                = lt_items_in       order_items_inx               = lt_items_inx       order_partners                = lt_partners       order_schedules_in            = lt_schedules_in       order_schedules_inx           = lt_schedules_inx       order_cfgs_ref                = lt_cfgs_ref       order_cfgs_inst               = lt_cfgs_inst       order_cfgs_part_of            = lt_cfgs_partof       order_cfgs_value              = lt_cfgs_value             .

READ TABLE lt_return TRANSPORTING NO FIELDS WITH KEY type = 'E'.   IF sy-subrc = 0.     CALL FUNCTION 'BAPI_TRANSACTION_ROLLBACK'               .   ELSE.     CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'       EXPORTING         wait          = 'X'               .   ENDIF.

ENDFUNCTION.

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

madhu_vadlamani — Thu, 24 Nov 2011 07:23:09 GMT

Hi Sergey,

DATA: conf_id TYPE char6 VALUE '000010',   "changed
inst_id TYPE char8 VALUE '00000001',
configuration
wa_order_ref-posex = '000010'.
wa_order_ref-root_id = inst_id.
wa_order_ref-config_id = conf_id.
INSERT wa_order_ref INTO TABLE tab_order_ref.   "BAPICUCFG
*Refinst
wa_order_refinst-posex = '000010'.
wa_order_refinst-config_id = conf_id.
wa_order_refinst-inst_id = inst_id.
INSERT wa_order_refinst INTO TABLE tab_order_refinst.   "BAPICURE
*Attribute values
wa_order_value-config_id = conf_id.
wa_order_value-inst_id = inst_id.    "changed
wa_order_value-charc = 'COOLANT_CHIP_DX200'.         "cawn-atwrt
"wa_order_value-charc = '0000000004'.
wa_order_value-value = '2'.      "cawn-atinn
INSERT wa_order_value INTO TABLE tab_order_value.      "BAPICUVAL
CLEAR wa_order_value

Regards,

Madhu.

Edited by: madhurao123 on Nov 24, 2011 12:56 PM

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Thu, 24 Nov 2011 07:30:29 GMT

Hi, Madhu.

You wrote:

wa_order_ref-root_id = inst_id.

wa_order_ref-config_id = conf_id.

Say me please, how I get inst_id and conf_id?

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

madhu_vadlamani — Thu, 24 Nov 2011 07:34:04 GMT

Hi Sergey,

These values i hard coded and created sales order with the required variants and its characteristics and it is working.Can you explain how you are going to pass these characteristics.You take the bapi and create a sales order from se38 by using all the parameters.

Regards,

Madhu.

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Thu, 24 Nov 2011 09:28:39 GMT

Madhu,

I tried to do this way. This error was repeated.

No item category available (Table T184 ZAPC TEXT )

May be required to fill ls_items_inx-material instead ls_items_inx-mat_entrd? But I tried that too without result.

P.S. Did you see my code in code format?

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

Former Member — Thu, 24 Nov 2011 09:40:34 GMT

I take my function module Z_SD_GET_TEH_COST and create a sales order from se37 by using follow parameters

AUART= ZAPC

VKORG= 1010

VTWEG= 02

SPART= 01

VKBUR= 1011

KUNNR = 1000000031

MATNR= HR_0103100

KWMENG= 1

KOD_PROD= ВР_971

TLOT_MIN =5

TLOT_MAX

SHOT_MIN= 1500

SHOT_MAX

DLOT_MIN =6000

DLOT_MAX

MARKA =B

STNDRT_MARKA

STNDRT_PROD= ГОСТ Р 52927-2008

TPRK =Б

GROT

VITYAZHKA

KROM =О

CHISL_ST_POKR

KLS_TOL_POKR

PROCH_IZG_T_LIC_MAX

PRIZ_ZASCH_POV

VID_POKR

MARK_POKR

MAT_POKR_LIC

PLSK

VID_POSTAVKI

DRESSIR

TRAVL

FSFR_MIN

FSFR_MAX

KRMN_MIN

KRMN_MAX

MRGN_MIN

MRGN_MAX

ALMN_MIN

ALMN_MAX

CUGL_MIN

CUGL_MAX

Re: Error when creating sales order using BAPI_SALESORDER_CREATEFROMDAT2

madhu_vadlamani — Thu, 24 Nov 2011 09:49:41 GMT

Hi Sergey,

Keep your details here.I will send you the code to create sales order with this bapi.

Regards,

Madhu.