BAPI_SALESDOCU_CREATEFROMDATA - Not Able to create SALES Document of CR and DR type

Help Activities
, ,
1

@ordo
@gabi_verzea ,
Hi Experts ,

I need your help in bapi-> BAPI_SALESDOCU_CREATEFROMDATA , I am using this BAPI to create SALES DOCUMENT of CREDIT(CR) and DEBIT( DR) type.

I am passing all the mandatory data into BAPI but not able to create SALES Document and getting “error :-> Sales document type CR is not defined”
However when same data i am passing in SAP GUI ( SE37) in same BAPI ,
i am able to create Sales document see below screenshot from SAP GUI

image
image1863×666 33.6 KB

Also screenshot of data set being passed
Order Header →
part 1 -

image
image687×705 10.9 KB

part 2 -

image
image1014×676 9.83 KB

part 3 -
image
image1039×716 11.4 KB

Order-ITEM Dataset screenshot
part 1 -

image
image982×699 12.4 KB

Part 2-

image
image944×723 10.6 KB

Part3 -
image
image948×708 10.4 KB

Order partners dataset screenshot -
Part 1-

image
image860×711 9.31 KB

Part 2 -

image
image915×706 9.48 KB

also please find below data set

header row → “{ , “CR”, , “279”, “02”, “99”, , , , , , , , , , , , , , , , , , , , , “BER”, , , , , , , , , , , , , , , , , , , , , , , “0.0000”, “00000”, , , , , , “0.0000”, “00000”, , , , , , “0.0000”, “00000”, , , , , , “0.0000”, “00000”, , , , , , , “N”, , , , , , }”

Order item → “[ITM_NUMBER,HG_LV_ITEM,PO_ITM_NO,MATERIAL,CUST_MAT,BATCH,DLV_GROUP,PART_DLV,REASON_REJ,BILL_BLOCK,BILL_DATE,PLANT,STORE_LOC,TARGET_QTY,TARGET_QU,REQ_QTY,SALES_UNIT,ITEM_CATEG,SHORT_TEXT,REQ_DATE,DATE_TYPE,REQ_TIME,COND_TYPE,COND_VALUE,COND_P_UNT,COND_D_UNT,PRC_GROUP1,PRC_GROUP2,PRC_GROUP3,PRC_GROUP4,PRC_GROUP5,PROD_HIERA,MATL_GROUP,PURCH_NO_C,PURCH_DATE,PO_METHOD,REF_1,PURCH_NO_S,PO_DAT_S,PO_METH_S,REF_1_S,PO_ITM_NO_S,COND_VAL1,CURRENCY,CURR_ISO,T_UNIT_ISO,S_UNIT_ISO,CD_UNT_ISO,CUST_MAT35,INCOTERMS1,INCOTERMS2,DLV_TIME,ASSORT_MOD,VAL_CONTR,VAL_CON_I,REF_DOC,REF_DOC_IT,REF_DOC_CA,CD_TYPE2,CD_VALUE2,CD_P_UNT2,CD_D_UNT2,CD_D_UISO2,CD_CURR2,CD_CU_ISO2,CD_TYPE3,CD_VALUE3,CD_P_UNT3,CD_D_UNT3,CD_D_UISO3,CD_CURR3,CD_CU_ISO3,CD_TYPE4,CD_VALUE4,CD_P_UNT4,CD_D_UNT4,CD_D_UISO4,CD_CURR4,CD_CU_ISO4,MAT_EXT,MAT_GUID,MAT_VERS,ALTERN_BOM,FKK_CONACCT,EAN_UPC,SHIP_POINT,PRODCAT,SGT_RCAT,INCOTERMSV,INCOTERMS2L,INCOTERMS3L,REF_DOC_CA_LONG,MATERIAL_LONG,REQ_SEG_LONG
10,EFR-DI-XHMC-SITE.,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,
]”

Order partners →

“[PARTN_ROLE,PARTN_NUMB,ITM_NUMBER,TITLE,NAME,NAME_2,NAME_3,NAME_4,STREET,COUNTRY,COUNTRY_ISO,POSTL_CODE,POBX_PCD,POBX_CTY,CITY,DISTRICT,REGION,PO_BOX,TELEPHONE,TELEPHONE2,TELEBOX,FAX_NUMBER,TELETEX_NO,TELEX_NO,LANGU,LANGU_ISO,UNLOAD_PT,TRANSPZONE,TAXJURCODE,ADDRESS,PRIV_ADDR,ADDR_TYPE,ADDR_ORIG,ADDR_LINK,VAT_REG_NO
SP,1000001105,0,
SH,1000001105,0,
]”

Appreciate your help
regards
Pratik Mehta

2

@pmexilinx

As per error the document type provided is wrong… please check if there are any extra spaces in the doc_type you provided and see if it is correctly getting passed

And may I know how are you passing the details

cheers

3

Hi Anil,

Thanks to reply , i have double checked on document Type CR and there is no extract space … and have printed the document type in log messages too see below.
message": “header row item 0 : Item 1->CR”

I am passing into SAP GUI BAPI from UiPath in form for DATA row

image
image1307×514 27.2 KB

4

Hi @StefanSchnell

Any ideas, what can be wrong here?

Thanks for your help and expertise
Best regards, Lev

1 Like
5

Hello @LevKushnir and @pmexilinx,
as far as I can tell, this is an input error. The BAPI is called and responds. The call contains a lot of data, it is very difficult to say exactly where the problem lies, based on the description here. Therefore I suggest to debug the call and see exactly where the difference is between the call in SE37 and the BAPI call via UiPath BAPI Activity. Based on the data, the causes can be many, as seen here in an example, where the UOM is the reason.
Best regards
Stefan