topic BAPI_SALESDOCU_CREATEFROMDATA, create credit memo request in Application Development and Automation Discussions

BAPI_SALESDOCU_CREATEFROMDATA, create credit memo request

Former Member — Mon, 09 Jul 2007 04:00:13 GMT

hi all,

in which field of BAPI_SALESDOCU_CREATEFROMDATA needs to fill in, i need to create SO Credit memo request (CR doc type ) with reference to billing no , which field shall i put the billing no ?

Re: BAPI_SALESDOCU_CREATEFROMDATA, create credit memo request

Former Member — Mon, 09 Jul 2007 04:06:33 GMT

Hello Ester,

BAPI_SALESDOCU_CREATEFROMDATA will not work for credit memo ,

so use FM SD_DOCUMENT_CREATE ,it will create Credit memo.

Thanks

Seshu

Re: BAPI_SALESDOCU_CREATEFROMDATA, create credit memo request

Former Member — Mon, 09 Jul 2007 04:09:11 GMT

HI Seshu,

I can create the SO., i just need to put the reference billing no

Re: BAPI_SALESDOCU_CREATEFROMDATA, create credit memo request

Former Member — Mon, 09 Jul 2007 04:22:38 GMT

Hello Ester,

I tried to create sales order with order type CR using BAPI FM ,i got so many errors,then i changed FM SD_DOCUMENT_CREATE and it works great.

Right now i am not system to tell about reference billing no.

Thanks

Seshu

Re: BAPI_SALESDOCU_CREATEFROMDATA, create credit memo request

Former Member — Mon, 09 Jul 2007 07:03:15 GMT

Hi Seshu,

I am trying to use the Fm as you mentioned, here is the coding

tables: vbak, vbap, vbrk, vbrp, likp, lips, vbpa.

DATA: v_vbeln LIKE vbak-vbeln.

DATA: header LIKE BAPISDHD1.

DATA: headerx LIKE BAPISDHD1X.

DATA: item LIKE BAPISDITM OCCURS 0 WITH HEADER LINE.

DATA: itemx LIKE BAPISDITMx OCCURS 0 WITH HEADER LINE.

DATA: partner LIKE BAPIPARNR OCCURS 0 WITH HEADER LINE.

DATA: return LIKE BAPIRET2 OCCURS 0 WITH HEADER LINE.

data: ivbrp like vbrp occurs 0 with header line.

DATA: lt_schedules_inx TYPE STANDARD TABLE OF bapischdlx

WITH HEADER LINE.

DATA: lt_schedules_in TYPE STANDARD TABLE OF bapischdl

WITH HEADER LINE.

data: wvbeln_in like BAPIVBELN-VBELN.

data: wauart like vbak-auart value 'G2'.

Header data

clear: vbrk, vbpa.

refresh: ivbrp.

select single * from vbrk

where vbeln = '0090009938'.

select single * from vbpa

where vbeln = '0090009938'

and parvw = 'WE'.

select * from vbrp

into table ivbrp

where vbeln = '0090009938'.

wvbeln_in = vbrk-vbeln.

Sales document type

header-doc_type = wauart.

headerx-doc_type = 'X'.

Sales organization

header-sales_org = vbrk-vkorg.

headerx-sales_org = 'X'.

Distribution channel

header-distr_chan = vbrk-vtweg.

headerx-distr_chan = 'X'.

Division

header-division = vbrk-spart.

headerx-division = 'X'.

headerx-updateflag = 'I'.

append header. append headerx.

Partner data
Sold to

partner-partn_role = 'AG'.

partner-partn_numb = vbpa-kunnr.

APPEND partner.

loop at ivbrp.

clear: item, itemx.

ITEM DATA

itemx-updateflag = 'I'.

Line item number.

item-itm_number = ivbrp-posnr.

itemx-itm_number = 'X'.

Material

item-material = ivbrp-matnr.

itemx-material = 'X'.

Plant

item-plant = ivbrp-werks.

itemx-plant = 'X'.

Quantity

item-target_qty = ivbrp-fkimg.

itemx-target_qty = 'X'.

APPEND item.

APPEND itemx.

endloop.

CALL FUNCTION 'SD_SALESDOCUMENT_CREATE'

EXPORTING

SALESDOCUMENT = wvbeln_in

sales_header_in = header

SALES_HEADER_INX = headerx

SENDER =
BINARY_RELATIONSHIPTYPE = ' '
INT_NUMBER_ASSIGNMENT = ' '
BEHAVE_WHEN_ERROR = ' '
LOGIC_SWITCH = ' '

BUSINESS_OBJECT = 'BUS2094'

TESTRUN =
CONVERT_PARVW_AUART = ' '
STATUS_BUFFER_REFRESH = 'X'
IMPORTING
SALESDOCUMENT_EX =
SALES_HEADER_OUT =
SALES_HEADER_STATUS =

TABLES

RETURN = return

SALES_ITEMS_IN = item

SALES_ITEMS_INX = itemx

SALES_PARTNERS = partner

SALES_SCHEDULES_IN =
SALES_SCHEDULES_INX =
SALES_CONDITIONS_IN =
SALES_CONDITIONS_INX =
SALES_CFGS_REF =
SALES_CFGS_INST =
SALES_CFGS_PART_OF =
SALES_CFGS_VALUE =
SALES_CFGS_BLOB =
SALES_CFGS_VK =
SALES_CFGS_REFINST =
SALES_CCARD =
SALES_TEXT =
SALES_KEYS =
SALES_CONTRACT_IN =
SALES_CONTRACT_INX =
EXTENSIONIN =
PARTNERADDRESSES =
SALES_SCHED_CONF_IN =
ITEMS_EX =
SCHEDULE_EX =
BUSINESS_EX =
INCOMPLETE_LOG =
EXTENSIONEX =
CONDITIONS_EX =
PARTNERS_EX =
TEXTHEADERS_EX =
TEXTLINES_EX =
BATCH_CHARC =

but i got error:

Enter a document number between 0065000000 and 0069999999

my requirement is to create Credit Memo request with reference to billing no

where shall i put the document no?

Re: BAPI_SALESDOCU_CREATEFROMDATA, create credit memo request

Former Member — Mon, 09 Jul 2007 07:58:50 GMT

REPORT ZTEST_SO_CREATE .

Order Header

DATA: HEADER LIKE BAPISDHD1.

Internal Item Number Assignment

DATA: L_INA LIKE BAPIFLAG-BAPIFLAG.

Item Data

DATA: IT_ITEM LIKE BAPISDITM OCCURS 0 WITH HEADER LINE.

Document Partner

DATA: IT_PARTN LIKE BAPIPARNR OCCURS 0 WITH HEADER LINE.

Schedule Line Data

DATA: IT_SIN LIKE BAPISCHDL OCCURS 0 WITH HEADER LINE.

Conditions

DATA: IT_COND LIKE BAPICOND OCCURS 0 WITH HEADER LINE.

Configuration: Reference Data

DATA: IT_CUCFG LIKE BAPICUCFG OCCURS 0 WITH HEADER LINE.

Configuration: Instances

DATA: IT_CUINS LIKE BAPICUINS OCCURS 0 WITH HEADER LINE.

Part_of Entries of Several Configurations

DATA: IT_CUPRT LIKE BAPICUPRT OCCURS 0 WITH HEADER LINE.

CU: Reference Order Item / Instance in Configuration

DATA: IT_CUREF LIKE BAPICUREF OCCURS 0 WITH HEADER LINE.

Characteristic values of several configurations

DATA: IT_CUVAL LIKE BAPICUVAL OCCURS 0 WITH HEADER LINE.

*Number of Generated Document

DATA: L_SO LIKE BAPIVBELN-VBELN.

DATA: RETURN LIKE BAPIRET2 OCCURS 0 WITH HEADER LINE.

START-OF-SELECTION.

-----------------------------------------
Header data

PERFORM SUB_HEADER.

Internal Item Number Assignment

L_INA = 'X'.

-----------------------------------------
Item Data

PERFORM SUB_ITEM.

Document Partner

PERFORM SUB_PARTN.

Schedule Line Data

PERFORM SUB_SIN.

Conditions

PERFORM SUB_COND.

Configuration: Reference Data

PERFORM SUB_CUCFG.

Configuration: Instances

PERFORM SUB_CUINS.

Part_of Entries of Several Configurations

PERFORM SUB_CUPRT.

CU: Reference Order Item / Instance in Configuration

PERFORM SUB_CUREF.

Characteristic values of several configurations

PERFORM SUB_CUVAL.

Call the BAPI to create the sales order.

CALL FUNCTION 'BAPI_SALESORDER_CREATEFROMDAT2'

EXPORTING

ORDER_HEADER_IN = HEADER

INT_NUMBER_ASSIGNMENT = L_INA

IMPORTING

SALESDOCUMENT = L_SO

TABLES

RETURN = RETURN

ORDER_ITEMS_IN = IT_ITEM

ORDER_PARTNERS = IT_PARTN

ORDER_SCHEDULES_IN = IT_SIN

ORDER_CONDITIONS_IN = IT_COND

ORDER_CFGS_REF = IT_CUCFG

ORDER_CFGS_INST = IT_CUINS

ORDER_CFGS_PART_OF = IT_CUPRT

ORDER_CFGS_VALUE = IT_CUVAL

ORDER_CFGS_REFINST = IT_CUREF.

Check the
RETURN TABLE.
LOOP AT
RETURN WHERE TYPE = 'E' OR TYPE = 'A'.
EXIT.
ENDLOOP.

LOOP AT RETURN.

WRITE 😕

RETURN-TYPE,

RETURN-ID,

RETURN-NUMBER,

RETURN-MESSAGE,

RETURN-LOG_NO,

RETURN-LOG_MSG_NO,

RETURN-MESSAGE_V1,

RETURN-MESSAGE_V2,

RETURN-MESSAGE_V3,

RETURN-MESSAGE_V4,

RETURN-PARAMETER,

RETURN-ROW,

RETURN-FIELD,

RETURN-SYSTEM.

ENDLOOP.

IF SY-SUBRC = 0.

Commit the work.

COMMIT WORK AND WAIT.

WRITE: / 'Document ', L_SO, ' created'.

ENDIF.

&----

*& Form SUB_HEADER

&----

text

----

--> p1 text
<-- p2 text

----

FORM SUB_HEADER.

Sales document type

HEADER-DOC_TYPE = 'ZOEM'.

Sales organization

HEADER-SALES_ORG = '1000'.

Distribution channel

HEADER-DISTR_CHAN = '12'.

Division

HEADER-DIVISION = '03'.

Sales group

HEADER-SALES_GRP = '001'.

Sales office

HEADER-SALES_OFF = '1000'.

Requested delivery date

HEADER-REQ_DATE_H = '20070701'.

HEADER-REQ_DATE_H = SY-DATUM.
Proposed date type

HEADER-DATE_TYPE = '1'.

Customer purchase order date

HEADER-PURCH_DATE = '20070701'.

HEADER-PURCH_DATE = SY-DATUM.
Sales district

HEADER-SALES_DIST = 'CC'.

Incoterms (part 1)

HEADER-INCOTERMS1 = 'EXW'.

Incoterms (part 2)

HEADER-INCOTERMS2 = 'XIAMEN'.

Terms of payment key

HEADER-PMNTTRMS = '1000'.

Date for pricing and exchange rate

HEADER-PRICE_DATE = '20070701'.

HEADER-PRICE_DATE = SY-DATUM.
Customer purchase order number

HEADER-PURCH_NO_C = 'atest'.

SD document category

HEADER-SD_DOC_CAT = 'C'.

Shipping conditions

HEADER-SHIP_COND = '02'.

Shipping type

HEADER-SHIP_TYPE = '07'.

HEADER-PURCH_NO_S = '1100511'.

ENDFORM. " SUB_HEADER

&----

*& Form SUB_ITEM

&----

text

----

--> p1 text
<-- p2 text

----

FORM SUB_ITEM.

Sales document item

IT_ITEM-ITM_NUMBER = '001000'.

Higher-level item in bill of material structures

IT_ITEM-HG_LV_ITEM ='000000'.

Item Number of the Underlying Purchase Order

IT_ITEM-PO_ITM_NO = '1000'.

Material number

IT_ITEM-MATERIAL = 'VD4'.

APPEND IT_ITEM.

IT_ITEM-ITM_NUMBER = '001001'.

IT_ITEM-HG_LV_ITEM ='001000'.

IT_ITEM-PO_ITM_NO = '1001'.

IT_ITEM-MATERIAL = 'CDX8004317R3J'.

IT_ITEM-CONFIG_ID = '000001'.
IT_ITEM-INST_ID = '00000001'.

APPEND IT_ITEM.

ENDFORM. " SUB_ITEM

&----

*& Form SUB_PARTN

&----

text

----

--> p1 text
<-- p2 text

----

FORM SUB_PARTN.

Partner function

IT_PARTN-PARTN_ROLE = 'AP'.

Customer number

IT_PARTN-PARTN_NUMB = '0000000090'.

Item number of the SD document

IT_PARTN-ITM_NUMBER = '000000'.

APPEND IT_PARTN.

IT_PARTN-PARTN_ROLE = 'VE'.

IT_PARTN-PARTN_NUMB = '0000000107'.

IT_PARTN-ITM_NUMBER = '000000'.

APPEND IT_PARTN.

IT_PARTN-PARTN_ROLE = 'SB'.

IT_PARTN-PARTN_NUMB = 'OEM'.

IT_PARTN-ITM_NUMBER = '000000'.

APPEND IT_PARTN.

IT_PARTN-PARTN_ROLE = 'AG'.

IT_PARTN-PARTN_NUMB = '0001100511'.

IT_PARTN-ITM_NUMBER = '000000'.

APPEND IT_PARTN.

ENDFORM. " SUB_PARTN

&----

*& Form SUB_SIN

&----

text

----

--> p1 text
<-- p2 text

----

FORM SUB_SIN.

Sales document item

IT_SIN-ITM_NUMBER = '001000'.

Schedule line

IT_SIN-SCHED_LINE = '0000'.

Schedule line date

IT_SIN-REQ_DATE = '07-01-2007'.

Date type (day, week, month, interval)

IT_SIN-DATE_TYPE = '1'.

Order quantity in sales units

IT_SIN-REQ_QTY = 5.

APPEND IT_SIN.

IT_SIN-ITM_NUMBER = '001001'.

IT_SIN-SCHED_LINE = '0000'.

IT_SIN-REQ_DATE = '07-01-2007'.

IT_SIN-DATE_TYPE = '1'.

IT_SIN-REQ_QTY = 5.

APPEND IT_SIN.

ENDFORM. " SUB_SIN

&----

*& Form SUB_COND

&----

text

----

--> p1 text
<-- p2 text

----

FORM SUB_COND.

Condition item number

IT_COND-ITM_NUMBER = '001000'.

Step number

IT_COND-COND_ST_NO = '000'.

Condition counter

IT_COND-COND_COUNT = '00'.

Condition type

IT_COND-COND_TYPE = 'VA00'.

Condition rate

IT_COND-COND_VALUE = 1.

Currency Key

IT_COND-CURRENCY = 'RMB'.

APPEND IT_COND.

IT_COND-ITM_NUMBER = '001000'.

IT_COND-COND_ST_NO = '000'.

IT_COND-COND_COUNT = '00'.

IT_COND-COND_TYPE = 'PR01'.

IT_COND-COND_VALUE = 1.

IT_COND-CURRENCY = 'RMB'.

APPEND IT_COND.

IT_COND-ITM_NUMBER = '001001'.

IT_COND-COND_ST_NO = '000'.

IT_COND-COND_COUNT = '00'.

IT_COND-COND_TYPE = 'VA00'.

IT_COND-COND_VALUE = 1.

IT_COND-CURRENCY = 'RMB'.

APPEND IT_COND.

IT_COND-ITM_NUMBER = '001001'.

IT_COND-COND_ST_NO = '000'.

IT_COND-COND_COUNT = '00'.

IT_COND-COND_TYPE = 'PR01'.

IT_COND-COND_VALUE = 1.

IT_COND-CURRENCY = 'RMB'.

APPEND IT_COND.

ENDFORM. " SUB_COND

&----

*& Form SUB_CUCFG

&----

text

----

--> p1 text
<-- p2 text

----

FORM SUB_CUCFG.

External item number

IT_CUCFG-POSEX = '001001'.

External Configuration ID (Temporary)

IT_CUCFG-CONFIG_ID = '000001'.

Instance Number in Configuration

IT_CUCFG-ROOT_ID = '00000001'.

APPEND IT_CUCFG.

ENDFORM. " SUB_CUCFG

&----

*& Form SUB_CUINS

&----

text

----

--> p1 text
<-- p2 text

----

FORM SUB_CUINS.

External Configuration ID (Temporary)

IT_CUINS-CONFIG_ID = '000001'.

Instance Number in Configuration

IT_CUINS-INST_ID = '00000001'.

Object type

IT_CUINS-OBJ_TYPE = 'MARA'.

Object key

IT_CUINS-OBJ_KEY = 'D'.

APPEND IT_CUINS.

IT_CUINS-CONFIG_ID = '000001'.

IT_CUINS-INST_ID = '00000002'.

IT_CUINS-OBJ_TYPE = 'MARA'.

IT_CUINS-OBJ_KEY = 'D2'.

APPEND IT_CUINS.

ENDFORM. " SUB_CUINS

&----

*& Form SUB_CUPRT

&----

text

----

--> p1 text
<-- p2 text

----

FORM SUB_CUPRT.

External Configuration ID (Temporary)

IT_CUPRT-CONFIG_ID = '000001'.

Instance Number in Configuration

IT_CUPRT-PARENT_ID = '00000001'.

Instance Number in Configuration

IT_CUPRT-INST_ID = '00000002'.

Part_of item number

IT_CUPRT-PART_OF_NO = '0280'.

Object type

IT_CUPRT-OBJ_TYPE = 'MARA'.

Object key

IT_CUPRT-OBJ_KEY = 'D2'.

APPEND IT_CUPRT.

ENDFORM. " SUB_CUPRT

&----

*& Form SUB_CUREF

&----

text

----

--> p1 text
<-- p2 text

----

FORM SUB_CUREF.

External item number

IT_CUREF-POSEX = '001001'.

External Configuration ID (Temporary)

IT_CUREF-CONFIG_ID = '000001'.

Instance Number in Configuration

IT_CUREF-INST_ID = '00000001'.

APPEND IT_CUREF.

ENDFORM. " SUB_CUREF

&----

*& Form SUB_CUVAL

&----

text

----

--> p1 text
<-- p2 text

----

FORM SUB_CUVAL.

External Configuration ID (Temporary)

IT_CUVAL-CONFIG_ID = '000001'.

Instance Number in Configuration

IT_CUVAL-INST_ID = '00000001'.

Characteristic name

IT_CUVAL-CHARC = 'ZS1_LV_HEIGHT'.

Characteristic Value

IT_CUVAL-VALUE = '02'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_TOP'.

IT_CUVAL-VALUE = '04'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_LV_BOTTOM'.

IT_CUVAL-VALUE = '01'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_BOTTOM'.

IT_CUVAL-VALUE = '01'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_CB_DOOR'.

IT_CUVAL-VALUE = '01'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_FIXED_PT'.

IT_CUVAL-VALUE = '01'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_EK6'.

IT_CUVAL-VALUE = '01'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_EK6_VENDER'.

IT_CUVAL-VALUE = '01'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_AUX'.

IT_CUVAL-VALUE = '02'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_INTERL'.

IT_CUVAL-VALUE = '01'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_CA'.

IT_CUVAL-VALUE = '01'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_DXN_Q'.

IT_CUVAL-VALUE = '02'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_CAP_DIV'.

IT_CUVAL-VALUE = '02'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_PACK'.

IT_CUVAL-VALUE = '02'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_PAINT'.

IT_CUVAL-VALUE = '02'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_AUX'.

IT_CUVAL-VALUE = '02'.

APPEND IT_CUVAL.

IT_CUVAL-CONFIG_ID = '000001'.

IT_CUVAL-INST_ID = '00000001'.

IT_CUVAL-CHARC = 'ZS1_RECTIFIER'.

IT_CUVAL-VALUE = '01'.

APPEND IT_CUVAL.

ENDFORM. " SUB_CUVAL

Re: BAPI_SALESDOCU_CREATEFROMDATA, create credit memo request

Former Member — Mon, 09 Jul 2007 10:37:28 GMT

Look at FM - BAPI_SALESORDER_CREATEFROMDAT2 -this fm use SD_SALESDOCUMENT_CREATE FM...

Ref doc : BAPISDHD1-REF_DOC

try to create manually first and see the results then use Program to create .

Thanks

Seshu