-
Give transaction SHDB, press new recording,name,transaction
-
-
Press Starting Recording
-
-
Input and save
-
-
BACK
-
-
SAVE
-
-
Choose the recording and Program
-
-
Fill the program's name and choose transferfrom recording
-
-
Source code
-
-
Using SE11 get the Length of the fields. It must be supplied in MS-Excel
-
-
Define internal table in the report.
-
-
Call function upload after start-of-selection
-
Call function 'UPLOAD'
-
EXPORTING
-
FILENAME = 'C:/'
-
FILETYPE = 'ASC'
-
TABLES
-
DATA_TAB = ITAB.
-
-
Put loop after perform open group
-
loop at itab.
-
-
Close loop using Endloop before perform close_group
-
-
Replace the constains in perform statement within loop by internal name wirh field name
-
-
Save and Activate
-
-
Data in EXCEL, the order must be in the internal table.
-
-
Choose all fields, right click, choose FORMAL CELLs,choose txt
-
-
Set the weight of every datas.
-
-
Save as Formatted text
-
-
Choose ok, yes, then close excel by giving no
-
-
Run the program
-
-
Choose Call transaction,F8
-
-
Choose the *.prn field
-
-
Transfer
BDC的导入数据库表步骤:
最新推荐文章于 2024-09-11 23:43:48 发布
本文档详细介绍了如何使用 SAP 系统创建交易记录、定义内部表、上传 Excel 数据到 SAP 的过程。从启动录制、输入保存交易记录,到通过 SE11 获取字段长度,并在报告中定义内部表,最后调用上传功能将 Excel 数据导入 SAP。
28

被折叠的 条评论
为什么被折叠?



