topic Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived in Application Development and Automation Discussions

BAPI_PO_CREATE1 Error: SD document not in database or has been archived

Former Member — Wed, 16 May 2012 03:12:49 GMT

Hi experts,

I am trying to create purchase orders using BAPI_PO_CREATE1. I have passed all required fields in the header, item, schedule line and account assignment tables in the BAPI.

I am passing the account assignment as Q. The BAPI gives me the error "SD document not in database or has been archived". I have not passed any refrenece SD document. I am also able to create PO via ME21N with the exact same data.

Our SAP version is ECC 6.0, so the OSS note 910636 is not relevant.

Any inputs on how to solve this issue is highly appreciated.

Thanks,

Saritha.

Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived

Former Member — Wed, 16 May 2012 03:30:15 GMT

Maybe the material you are using is referring to a Contract

Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived

ShyamPindiproli — Wed, 16 May 2012 03:41:56 GMT

Hello Saritha,

Refer sample code using BAPI_PO_CREATE1 --> here ...

For all the input data to the BAPI, ensure that the data format is correct (especially Leading Zeroes) or make use of conversion exits wherever necesary.

If this doesn't resolve the issue, then upload the snippet which has the input parameters for the BAPI.

Regards,

Shyam

Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived

Former Member — Wed, 16 May 2012 03:48:47 GMT

No its not a contract material.

In fact we are not passing a material number as we are creating this PO for requesting a service from a vendor and this case we pass a short text into the item table (field SHORT_TEXT in parameter POITEM) and also specify the account assignment category(field ACCTASSCAT in POITEM) as Q.

Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived

madhu_vadlamani — Wed, 16 May 2012 03:58:11 GMT

Hi Mohan,

Please paste your code.

Regards,

Madhu.

Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived

Former Member — Wed, 16 May 2012 04:11:19 GMT

LOOP AT it_header INTO st_header.

st_poheader-po_number = st_header-ponumber.

st_poheader-comp_code = p_ccode.

st_poheader-doc_type = st_header-potype.

st_poheader-creat_date = sy-datum.

st_poheader-item_intvl = st_output-itemintvl.

st_poheader-vendor = st_header-vendor.

st_poheader-langu = 'E'.

st_poheader-purch_org = p_ekorg.

st_poheader-pur_group = st_header-purchgrp.

CLEAR g_date.

CONCATENATE g_date st_header-docdate+6(4)

st_header-docdate+3(2) st_header-docdate+0(2)

INTO g_date.

st_poheader-doc_date = g_date.

st_poheader-currency = st_header-currency.

st_poheader-ref_1 = st_header-refname1.

st_poheader-our_ref = st_header-refname2.

st_poheader-pmnttrms = st_header-zterm.

st_poheaderx-po_number = 'X'.

st_poheaderx-comp_code = 'X'.

st_poheaderx-doc_type = 'X'.

st_poheaderx-creat_date = 'X'.

st_poheaderx-item_intvl = 'X'.

st_poheaderx-vendor = 'X'.

st_poheaderx-langu = 'X'.

st_poheaderx-pmnttrms = 'X'.

st_poheaderx-purch_org = 'X'.

st_poheaderx-pur_group = 'X'.

st_poheaderx-currency = 'X'.

st_poheaderx-doc_date = 'X'.

st_poheaderx-ref_1 = 'X'.

st_poheaderx-our_ref = 'X'.

st_poheaderx-pmnttrms = 'X'.

LOOP AT it_output INTO st_output

WHERE ponumber = st_header-ponumber.

st_poitem-po_item = st_output-itemno.

st_poitem-short_text = st_output-shrtxt.

IF NOT st_output-matnr IS INITIAL.

st_poitem-material = st_output-matnr.

ENDIF.

st_poitem-plant = p_plant.

IF NOT st_output-lgort IS INITIAL.

st_poitem-stge_loc = st_output-lgort.

ENDIF.

st_poitem-matl_group = st_output-matkl.

st_poitem-quantity = st_output-menge.

st_poitem-po_unit = st_output-uom.

st_poitem-orderpr_un = st_output-uom.

st_poitem-net_price = st_output-netprice.

st_poitem-tax_code = st_output-taxcode.

st_poitem-item_cat = st_output-item_cat.

IF NOT st_output-knttp IS INITIAL.

st_poitem-acctasscat = st_output-knttp.

ENDIF.

IF st_output-netprice = '0.00'.

st_poitem-free_item = 'X'.

ENDIF.

IF NOT st_output-confcntrl IS INITIAL.

st_poitem-conf_ctrl = st_output-confcntrl.

ENDIF.

APPEND st_poitem TO it_poitem.

st_poitemx-po_item = st_output-itemno.

st_poitemx-po_itemx = 'X'.

st_poitemx-short_text = 'X'.

IF NOT st_output-matnr IS INITIAL.

st_poitemx-material = 'X'.

ENDIF.

st_poitemx-plant = 'X'.

IF NOT st_output-lgort IS INITIAL.

st_poitemx-stge_loc = 'X'.

ENDIF.

st_poitemx-matl_group = 'X'.

st_poitemx-quantity = 'X'.

st_poitemx-po_unit = 'X'.

st_poitemx-orderpr_un = 'X'.

st_poitemx-net_price = 'X'.

st_poitemx-tax_code = 'X'.

st_poitemx-item_cat = 'X'.

IF NOT st_output-knttp IS INITIAL.

st_poitemx-acctasscat = 'X'.

ENDIF.

IF st_output-netprice = '0.00'.

st_poitemx-free_item = 'X'.

ENDIF.

IF NOT st_output-confcntrl IS INITIAL.

st_poitemx-conf_ctrl = 'X'.

ENDIF.

APPEND st_poitemx TO it_poitemx.

st_schedule-po_item = st_output-itemno.

st_schedule-sched_line = st_output-etenr.

CLEAR g_date.

CONCATENATE g_date st_output-eindt+6(4)

st_output-eindt+3(2) st_output-eindt+0(2)

INTO g_date.

st_schedule-delivery_date = g_date.

st_schedule-quantity = st_output-menge.

APPEND st_schedule TO it_schedule.

st_schedulex-po_item = st_output-itemno.

st_schedulex-sched_line = st_output-etenr.

st_schedulex-po_itemx = 'X'.

st_schedulex-sched_linex = 'X'.

st_schedulex-delivery_date = 'X'.

st_schedulex-quantity = 'X'.

APPEND st_schedulex TO it_schedulex.

IF NOT st_output-knttp IS INITIAL.

st_poaccnt-po_item = st_output-itemno.

st_poaccnt-serial_no = st_output-zekkn.

st_poaccnt-quantity = st_output-menge.

IF NOT st_output-glaccnt IS INITIAL.

st_poaccnt-gl_account = st_output-glaccnt.

ENDIF.

st_poaccnt-sched_line = st_output-etenr.

IF NOT st_output-kokrs IS INITIAL.

st_poaccnt-co_area = st_output-kokrs.

ENDIF.

IF NOT st_output-prctr IS INITIAL.

st_poaccnt-profit_ctr = st_output-prctr.

ENDIF.

IF NOT st_output-costctr IS INITIAL.

st_poaccnt-costcenter = st_output-costctr.

ENDIF.

IF NOT st_output-wbselmnt IS INITIAL.

st_poaccnt-wbs_element = st_output-wbselmnt.

ENDIF.

APPEND st_poaccnt TO it_poaccnt.

st_poaccntx-po_item = st_output-itemno.

st_poaccntx-serial_no = st_output-zekkn.

st_poaccntx-po_itemx = 'X'.

st_poaccntx-serial_nox = 'X'.

st_poaccntx-quantity = 'X'.

IF NOT st_output-glaccnt IS INITIAL.

st_poaccntx-gl_account = 'X'.

ENDIF.

st_poaccntx-sched_line = 'X'.

IF NOT st_output-kokrs IS INITIAL.

st_poaccntx-co_area = 'X'.

ENDIF.

IF NOT st_output-prctr IS INITIAL.

st_poaccntx-profit_ctr = 'X'.

ENDIF.

IF NOT st_output-costctr IS INITIAL.

st_poaccntx-costcenter = 'X'.

ENDIF.

IF NOT st_output-wbselmnt IS INITIAL.

st_poaccntx-wbs_element = 'X'.

ENDIF.

APPEND st_poaccntx TO it_poaccntx.

ENDIF.

ENDLOOP.

LOOP AT it_texts INTO st_texts

WHERE ponumber = st_header-ponumber.

IF st_texts-objectid = c_ekko.

st_potxthdr-po_number = st_texts-ponumber.

st_potxthdr-po_item = st_texts-poitem.

st_potxthdr-text_id = st_texts-textid.

st_potxthdr-text_form = st_texts-txtformat.

st_potxthdr-text_line = st_texts-textline.

APPEND st_potxthdr TO it_potxthdr.

ELSE.

st_potxtitm-po_number = st_texts-ponumber.

st_potxtitm-po_item = st_texts-poitem.

st_potxtitm-text_id = st_texts-textid.

st_potxtitm-text_form = st_texts-txtformat.

st_potxtitm-text_line = st_texts-textline.

APPEND st_potxtitm TO it_potxtitm.

ENDIF.

ENDLOOP.

CALL FUNCTION 'BAPI_PO_CREATE1'

EXPORTING

poheader = st_poheader

poheaderx = st_poheaderx

IMPORTING

exppurchaseorder = g_ponumber

TABLES

return = it_return

poitem = it_poitem

poitemx = it_poitemx

poschedule = it_schedule

poschedulex = it_schedulex

poaccount = it_poaccnt

poaccountx = it_poaccntx

potextheader = it_potxthdr

potextitem = it_potxtitm.

IF sy-subrc EQ 0.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

EXPORTING

wait = 'X'

* IMPORTING

* RETURN =

ENDIF.

ENDLOOP.

Also here is my upload file

potype

ponumber

pocat

itemno

purchgrp

itemintvl

zterm

currency

vendor

docdate

refname1

refname2

matnr

shrtxt

lgort

matkl

menge

uom

netprice

taxcode

confcntrl

itm catgry

knttp

etenr

eindt

zekkn

glaccnt

kokrs

prctr

costctr

wbselmnt

error

messg

1234567890

00001

123

00001

zzzz

USD

123456

16.05.2012

test

testy thing

test

1.000

100.00

0001

22.05.2012

123456

1234

Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived

Former Member — Wed, 16 May 2012 04:17:31 GMT

I also tried changing the account assignment category from Q to K and the error still exists.

given below is the return table from BAPI

TYPE	ID	NUMBER	MESSAGE
E	MEPO	46	Purchase order item 00001 still contains faulty account assignments
E	BAPI	1	No instance of object type PurchaseOrder has been created. External reference:
W	ME	40	Can delivery date be met?
E	V1	302	SD document is not in the database or has been archived

Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived

madhu_vadlamani — Wed, 16 May 2012 04:21:31 GMT

Hi Mohan,

In which field you are passing the so?

Can you pass minimum data and see.

Regards,

Madhu.

Message was edited by: Madhu Vadlamani

Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived

Former Member — Wed, 16 May 2012 04:24:57 GMT

I am not passing sales document number as we do not want create this PO with any reference SD document.

Thanks,
Saritha.

Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived

Former Member — Wed, 16 May 2012 04:33:36 GMT

Hi Shyam,

In what scenarios would you populate the services data. and in case of services data how do would u specify the account assignment category?

Thanks,

Saritha.

Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived

naresh_bammidi — Wed, 16 May 2012 04:42:56 GMT

Hi,

After passing header and item data into the BAPI,Try calling BAPI_TRANSACTION_COMMIT.I guess ,this is the reason for the error "Document is not in the database or has been archived".

Thanks

Naresh

Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived

Former Member — Wed, 16 May 2012 05:03:36 GMT

Hi Naresh,

I am already calling BAPI_TRANSACTION_COMMIT. Since the BAPI_PO_CREATE1 already gives me errors in the return table, there is no point in doing COMMIT.

Thanks,
Saritha.

Re: BAPI_PO_CREATE1 Error: SD document not in database or has been archived

Former Member — Thu, 17 May 2012 01:27:24 GMT

This issue was solved by passing tax code in POACCNT table. I also deleted the code which was passing the schedule line number to POACCNT table.

Thanks,

Saritha.