update VBKD table using open sql

Former Member — Thu, 29 Nov 2007 06:55:14 GMT

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.

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!

Re: update VBKD table using open sql

former_member386202 — Thu, 29 Nov 2007 06:57:42 GMT

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

topic update VBKD table using open sql in Application Development and Automation Discussions

update VBKD table using open sql

Re: update VBKD table using open sql