update VBKD table using open sql

[Former Member]

HI

when i use BAPI_SALESORDER_CREATEFROMDAT2 to create SO!

but some field i can't fill in BAPI_SALESORDER_CREATEFROMDAT2 of parameter. so i want update it using open SQL.

so i want to use BAPI_SALESORDER_CREATEFROMDAT2 first. and next using

open sql to update VBKD of field! VBKD-TRATY(Means-of-Transport Type)

abap code:

CALL FUNCTION 'BAPI_SALESORDER_CREATEFROMDAT2'

EXPORTING

• SALESDOCUMENTIN =

ORDER_HEADER_IN = header

ORDER_HEADER_INX = headerx

• SENDER =

• BINARY_RELATIONSHIPTYPE =

• INT_NUMBER_ASSIGNMENT =

• BEHAVE_WHEN_ERROR =

• LOGIC_SWITCH =

• TESTRUN =

• CONVERT = ' '

IMPORTING

SALESDOCUMENT = saledocument

TABLES

RETURN = return

ORDER_ITEMS_IN = item

ORDER_ITEMS_INX = itemx

ORDER_PARTNERS = partner

• ORDER_SCHEDULES_IN =

• ORDER_SCHEDULES_INX =

ORDER_CONDITIONS_IN = condition

ORDER_CONDITIONS_INX = conditionx

• ORDER_CFGS_REF =

• ORDER_CFGS_INST =

• ORDER_CFGS_PART_OF =

• ORDER_CFGS_VALUE =

• ORDER_CFGS_BLOB =

• ORDER_CFGS_VK =

• ORDER_CFGS_REFINST =

• ORDER_CCARD =

• ORDER_TEXT =

• ORDER_KEYS =

• EXTENSIONIN =

• PARTNERADDRESSES =

.

if sy-subrc = 0.

update vbkd

set TRATY = in_data-TRATY

where vbeln = saledocument.

if sy-subrc = 0.

commit work.

endif.

endif.

but i don't what affect if i use open sql to update sap VBKD table.

who can help me to explain it!

thank you!

[former_member386202]

Hi,

Try like thais

&----

---

*& Form SUB_READ_UPDATE_BSEG

&----

---

• text

----

---

FORM sub_read_update_bseg.

IF NOT it_final[] IS INITIAL.

LOOP AT it_final INTO wa_final.

UPDATE bseg SET zuonr = wa_final-ccnum

WHERE bukrs EQ wa_final-bukrs

AND belnr EQ wa_final-vbeln

AND rfzei EQ wa_final-rfzei

AND saknr NE ' '.

ENDLOOP.

*--Message data updated successfully

MESSAGE i888 WITH text-002.

LEAVE LIST-PROCESSING.

ELSE.

*--Message No data found

MESSAGE i888 WITH text-003.

LEAVE LIST-PROCESSING.

ENDIF.

ENDFORM. " SUB_READ_UPDATE_BSEG

Regards,

Prashant