Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Inbound interface

Former Member
0 Kudos
148

I have a text file. I need to extract the contents from the file and based on the action code make changes to the sales order.

The following is the structure of the file . How do I upload the data, extract and assign the fields and make changes to the sales order (delivery block)

DATA: BEGIN OF credit_detail,

formattype(2) TYPE c,

groupclientnumber(4) TYPE n,

clientnumber(4) TYPE n,

juliandate(3) TYPE c,

hrextraction(2) TYPE c,

recordtype(2) TYPE c,

citcustnum(7) TYPE n,

clientcustnum(15) TYPE c,

custnum(30) TYPE c,

clientordernum(22) TYPE c,

citrefnum(10) TYPE c,

orderamt(8) TYPE n,

appamt(8) TYPE n,

actioncode(2) TYPE c,

reasoncode1(2) TYPE c,

reasoncode2(2) TYPE c,

reasoncode3(2) TYPE c,

reasoncode4(2) TYPE c,

reasoncode5(2) TYPE c,

orderdate(6) TYPE c,

startshipdate(6) TYPE c,

endshipdate(6) TYPE c,

terms(3) TYPE n,

lineamt(9) TYPE n,

linetype TYPE n,

appnum(3) TYPE n,

futureuse(62) TYPE c,

END OF credit_detail.

DATA: BEGIN OF credit_total,

formattype(2) TYPE c,

groupclientnumber(4) TYPE n,

clientnumber(4) TYPE n,

juliandate(3) TYPE c,

hrextraction(2) TYPE c,

recordtype(2) TYPE n,

filler(7) TYPE n,

recordcnt(5) TYPE n,

totalamt(9) TYPE n,

futureuse(187) TYPE c,

END OF credit_total.

1 ACCEPTED SOLUTION

ferry_lianto
Active Contributor
0 Kudos
97

Hi,

You can use OPEN DATASET statement (file is stored in application server) or FM GUI_UPLOAD (file is stored in PC) to read the file and store the information data into an internal table(s).

Next step is to process the data in internal table(s) and prepare the input parameters for calling BAPI BAPI_SALESDOCUMENT_CHANGE to update sales order's delivery block.

The ORDER_HEADER_IN and ORDER_HEADER_INX parameters have the field for delivery block.

In the ORDER_HEADER_INX has the field UPDATEFLAG as 'U' for updating the sales order.

Hope this will help and give an idea.

Regards,

Ferry Lianto

3 REPLIES 3

Former Member
0 Kudos
97

data : it_creditdetail like table of credit_detaol,

it_credittotal like table of credit_total.

data :v_filename type string.

v_filename = 'C:\TEST.txt'. (ur file name.)

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = V_FILENAME

HAS_FIELD_SEPARATOR = '#'

tables

data_tab = IT_creditdetail.

Now all the details will be available in the internal table similarly do it for total table & write ur logic.

Former Member
0 Kudos
97

hi

There are different methods avaiable.

1) DIRECT INPUT

using a progrom to upload data. standard programs available for different transactions.

2) RECORDING (BATCH INPUT)

You will record your sequence of screen through recording and then use this recording to upload data using batch input sessions.

Transaction : SM35.

3) CALL Transaction.

you will the data into BDCDATA table and then call the corresponding transaction.

check this link for details.

http://www.sapbrain.com/TUTORIALS/TECHNICAL/BDC_tutorial.html

or

<b>If you want to upload the data to an internal table then you can use the FM 'GUI_UPLOAD'</b>

once u get the data in internal table u can assign the fields and make changes.

regards

ravish

<b>plz reward if helpful</b>

ferry_lianto
Active Contributor
0 Kudos
98

Hi,

You can use OPEN DATASET statement (file is stored in application server) or FM GUI_UPLOAD (file is stored in PC) to read the file and store the information data into an internal table(s).

Next step is to process the data in internal table(s) and prepare the input parameters for calling BAPI BAPI_SALESDOCUMENT_CHANGE to update sales order's delivery block.

The ORDER_HEADER_IN and ORDER_HEADER_INX parameters have the field for delivery block.

In the ORDER_HEADER_INX has the field UPDATEFLAG as 'U' for updating the sales order.

Hope this will help and give an idea.

Regards,

Ferry Lianto