TABC43
TABC43 Data Transfer ..................................0-1
Copyright......................................................0-2
Section Overview........................................0-4
Section: Data Transfer....................................................................1-1
Content: Data Transfer ........................................................................................................1-2
Overview of Data Transfer: Contents....................................................................................2-1
Course Overview Diagram .................................................................................................2-2
Overview of Data Transfer .................................................................................................2-3
Data Transfer into SAP System .........................................................................................2-4
Direct Data Transfer.............................................................................................................2-5
Data Transfer Using Interfaces ..........................................................................................2-6
Data Transfer Workbench...................................................................................................2-7
Overview of Data Transfer .................................................................................................2-8
Analyzing SAP Transactions..............................................................................................2-9
Assigning Data..........................................................................2-10
Formatting Data ........................................................................2-11
Concept Definition .............................................................................................................2-12
Data Transfer Using the DX-WB....................................................................................2-13
DX-WB: Transfer Procedure............................................................................................2-14
Data Transfer Using LSMW.............................................................................................2-15
LSMW Transfer Procedure...............................................................................................2-16
Data Transfer Overview: Unit Summary ........................................................................2-17
Overview of Data Transfer Exercises ..............................................................................2-18
Project Concept: Contents .......................................................................................................3-1
Course Overview Diagram .................................................................................................3-2
Data Transfer Project ...........................................................................................................3-3
Data Transfer in R/3.............................................................................................................3-4
Transfer Methods........................................................................3-5
Batch Input ..................................................................................3-6
Call Transaction..........................................................................3-7
Direct Input Technique..................................................................3-8
BAPIs ...........................................................................................3-9
Transaction Recorder...............................................................3-10
Project Concept.........................................................................3-11
Data Transfer Project ....................................................................3-12
Project Prerequisites.....................................................................3-13
Project Tasks .............................................................................3-14
Test Procedure...........................................................................3-15
Data Transfer Project .....................................................................3-16
Business Object Repository - BOR..................................................................................3-17
Project Concept.........................................................................3-19
DX-WB Functions....................................................................3-20
Mapping Project to the DX-WB......................................................................................3-21
Tasks and Programs ...........................................................................................................3-22
Programs and Task Types.................................................................................................3-23
Registration in the DX-WB..............................................................................................3-24
Organization of Data Transfer Projects ...........................................................................3-25
Creating Projects.......................................................................3-26
Creating Subproject............................................................................................................3-27
Create Run Definition........................................................................................................3-28
Create Task................................................................................3-29
Define Task Attributes.......................................................................................................3-30
Starting and Analyzing Run..............................................................................................3-31
Log ..............................................................................................3-32
Processing Run Problems ..................................................................................................3-33
Project Concept : Unit Summary .....................................................................................3-34
Project Concept Exercises.................................................................................................3-35
Project Concept Solutions.................................................................................................3-38
Principles of Standard Data Transfer.....................................................................................4-1
Course Overview Diagram .................................................................................................4-2
Standard Transfer Overview...............................................................................................4-3
Interfaces for Standard Data Transfer...............................................................................4-4
Tasks in Standard Transfer.................................................................................................4-5
Documentation from DX-WB............................................................................................4-6
Converting Data..........................................................................4-7
Formatting....................................................................................4-8
Mapping.......................................................................................4-9
General Record Layout Structure .....................................................................................4-10
Example of Record Layout Type 0 ..................................................................................4-11
General Record Layout Structure .....................................................................................4-12
Example: Record Layout Customer .................................................................................4-13
Supported Methods ............................................................................................................4-14
Principles of Standard Data Transfer: Unit Summary ..................................................4-15
DX-WB Tools: Contents..........................................................................................................5-1
Course Overview Diagram .................................................................................................5-2
DX-WB: Tools ............................................................................5-3
Function: Create File ............................................................................................................5-4
Function: Create File with Data .........................................................................................5-5
Function: Display/Change File ..........................................................................................5-6
Function: Copy File....................................................................5-7
Structure Operations ............................................................................................................5-8
Creating Test Data in DX-WB...........................................................................................5-9
Mapping Plan ............................................................................5-10
NODATA Indicator ...........................................................................................................5-11
Function: Check File ..........................................................................................................5-12
Record Layout - Displaying Structure (2)......................................................................5-13
Record Layout - Generating Structure (1).......................................................................5-14
Record Layout - Generating Structure (2).......................................................................5-15
DX-WB Tools: Unit Summary ........................................................................................5-16
DX-WB Tools Exercises...................................................................................................5-17
Sequential Files: Contents .......................................................................................................6-1
Course Overview Diagram .................................................................................................6-2
Overview of Content - Sequential Files.............................................................................6-3
File Transfer................................................................................6-4
The File Monitor (AL11) ....................................................................................................6-5
Directories in the File Monitor...........................................................................................6-6
Files in File Monitor (AL11) ..............................................................................................6-7
Overview of Content - Sequential Files (2) ......................................................................6-8
File Processing............................................................................6-9
Overview Diagram: Read File ..........................................................................................6-10
Overview Diagram: Write File .........................................................................................6-11
Open File ....................................................................................6-12
Open File: Additions..........................................................................................................6-13
Binary Mode and Text Mode ...........................................................................................6-14
Transfer Data Record .........................................................................................................6-15
Read Data Record .....................................................................6-16
Close / Delete File ....................................................................6-17
The NODATA Character..................................................................................................6-18
Initializing Record Layout Structures.............................................................................6-19
Initializing Help Structures...............................................................................................6-20
Example of Mapping Program........................................................................................6-21
Example of Formatting......................................................................................................6-22
Overview of Content - Sequential Files (3) ....................................................................6-23
Download and Upload.......................................................................................................6-24
DOWNLOAD Function Module .....................................................................................6-25
Example: DOWNLOAD..................................................................................................6-26
UPLOAD Function Module .............................................................................................6-27
Example: UPLOAD...........................................................................................................6-28
Overview of Content - Sequential Files (4) ....................................................................6-29
Customizing Logical File Name ......................................................................................6-30
Logical Path and Logical File ..........................................................................................6-31
Reserved Words........................................................................6-32
FILE_GET_NAME Function Module .............................................................................6-33
Sequential Files: Unit Summary ......................................................................................6-34
Sequential Files Exercises.................................................................................................6-35
Sequential Files Solutions.................................................................................................6-38
Batch Input Processing.............................................................................................................7-1
Course Overview Diagram .................................................................................................7-2
Batch Input Processing (1)..................................................................................................7-3
Overview: Batch Input Processing....................................................................................7-4
Batch Input Program............................................................................................................7-5
Format of Batch Input Session...........................................................................................7-6
Creating Batch Input Session.............................................................................................7-7
Structure of BDC Table ......................................................................................................7-8
Processing a Batch Input Session......................................................................................7-9
Batch Input Processing......................................................................................................7-10
The Batch Input Monitor...................................................................................................7-11
Functions of the Batch Input Monitor..............................................................................7-12
Initial Screen of Batch Input Monitor..............................................................................7-13
Processing Mode.......................................................................7-14
Menu Functions for Processing in Foreground..............................................................7-15
The Functions and OK codes ...........................................................................................7-16
Session Statuses ........................................................................7-17
Notes for Processing BI Sessions in Foreground...........................................................7-18
Session Statistics.......................................................................7-19
Session Log ...............................................................................7-20
Session Analysis .......................................................................7-21
Session Analysis .......................................................................7-22
Session Analysis - Screen Field List................................................................................7-23
Session Analysis - Screen Display ...................................................................................7-24
User Settings in BI Monitor..............................................................................................7-25
Exporting and Importing BI Sessions.............................................................................7-26
Import / Export Program Options....................................................................................7-27
Batch Input Processing: Unit Summary ..........................................................................7-28
Batch-Input Mappen Exercises ........................................................................................7-29
Batch- Input Monitor Solutions .......................................................................................7-30
Legacy System Migration Workbench (LSMW)..................................................................8-1
Course Overview Diagram .................................................................................................8-2
LSMW Basics .............................................................................8-3
LSMW: Characteristics .......................................................................................................8-4
LSMW as an Add-On..........................................................................................................8-5
LSMW: Core Functions......................................................................................................8-6
The LSMW Concept............................................................................................................8-7
LSMW Concept..........................................................................8-8
Generated Programs .............................................................................................................8-9
LSMW Transfer Procedure...............................................................................................8-10
Starting the LSMW ............................................................................................................8-11
Project Overview......................................................................8-12
The Main Steps.........................................................................8-13
Maintain Object Attributes ...............................................................................................8-14
Maintain Object Attributes - Standard.............................................................................8-15
Overview of Object Creation............................................................................................8-16
Conversion on Paper..........................................................................................................8-17
LSMW Structure Definitions ...........................................................................................8-18
Flat Source Structure..........................................................................................................8-19
Source Structures Containing Two Structures................................................................8-20
Source Structures With Header and Positions................................................................8-21
Maintain Source Structures...............................................................................................8-22
Maintain Source Fields......................................................................................................8-23
Field Types ................................................................................8-24
Maintain Structure Relations............................................................................................8-25
Hierarchical Display ..........................................................................................................8-26
LSMW Field Mapping and Rules .....................................................................................8-27
Maintain Field Mapping and Conversion Rules ............................................................8-28
Field Assignments....................................................................8-29
Reusability of Rules ...........................................................................................................8-30
Source Field Assignment ..................................................................................................8-31
Rule: Initial................................................................................8-32
Rule: Constants .........................................................................8-33
Rule: Transfer............................................................................8-34
Rule: Fixed Value.....................................................................8-35
Rule: Creating Translation................................................................................................8-36
Rule: Changing Translation..............................................................................................8-37
Translation Control Overview..........................................................................................8-38
1:1 Values of Conversion Key .........................................................................................8-39
Conversion Value Interval................................................................................................8-40
Rule: Prefix................................................................................8-41
Rule: Suffix ...............................................................................8-42
Rule: Concatenation...........................................................................................................8-43
Rule: Transfer Left-Justified ............................................................................................8-44
Rule: ABAP Code ....................................................................8-45
Rule: Own Routine.............................................................................................................8-46
Field Mapping and Conversion Rules..............................................................................8-47
LSMW Reading and Transferring Data to R/3...............................................................8-48
Specify Files ..............................................................................8-49
Source of the Legacy Data................................................................................................8-50
Read Data File ...........................................................................8-51
Converted Data File ...........................................................................................................8-52
Wildcards in File Names ...................................................................................................8-53
Assign Files ...............................................................................8-54
Read Data...................................................................................8-55
Display Read Data....................................................................8-56
Convert Data..............................................................................8-57
Display Converted Data ....................................................................................................8-58
Starting Transfer.......................................................................8-59
Starting Standard Transfer Program................................................................................8-60
Administrative Functions..................................................................................................8-61
Authorizations...........................................................................8-62
LSMW: Unit Summary .....................................................................................................8-63
LSMW Exercises......................................................................8-64
Direct Input ......................................................................................9-1
Course Overview Diagram .................................................................................................9-2
Direct Input Concept............................................................................................................9-3
Direct Input Monitor............................................................................................................9-4
Tasks in the Direct Input Monitor.....................................................................................9-5
Example: FI Documents......................................................................................................9-6
Job Analysis ................................................................................9-7
Error in FI Document...........................................................................................................9-8
Error in Material Master or Sales Document....................................................................9-9
Periodic Jobs .............................................................................9-10
Direct Input: Unit Summary .............................................................................................9-11
Direct-Input Exercises .......................................................................................................9-12
The Transaction Recorder: TA Recorder.............................................................................10-1
Course Overview Diagram ...............................................................................................10-2
The TA Recorder......................................................................10-3
Overview of Transaction Recorder ..................................................................................10-4
Uses of the TA Recorder...................................................................................................10-5
The Recording...........................................................................10-6
Changing Customer Data: Initial Screen.........................................................................10-7
Changing Customer Data: Address ..................................................................................10-8
Results of the Recording ...................................................................................................10-9
Special Recording Fields.................................................................................................10-10
Determining the Field Name ..........................................................................................10-11
Subscreens ...............................................................................10-12
Tabstrips...................................................................................10-13
Step Loops and Table Controls ......................................................................................10-14
Recording Guidelines ......................................................................................................10-15
Enjoy SAP Controls and Data Transfer.........................................................................10-16
The Transaction Recorder...............................................................................................10-17
Recording Using the LSMW ..........................................................................................10-18
Creating Recording ..........................................................................................................10-19
Changing Customer Data: Initial Screen.......................................................................10-20
Results ......................................................................................10-21
Assigning Field Names....................................................................................................10-22
Editing Recording.............................................................................................................10-23
Object Type and Import Method: Recording................................................................10-24
The Transaction Recorder...............................................................................................10-25
Transaction Recorder.......................................................................................................10-26
Changing Customer Data: Initial Screen.......................................................................10-27
Change Debitor: Payment Transactions (1) ..................................................................10-28
Changing Customer Data: Payment Transactions (2) .................................................10-29
Hierarchy Display of the Recording..............................................................................10-30
Recording Overview ........................................................................................................10-31
Recording Editor.....................................................................10-32
Recording Several Transaction Runs.............................................................................10-33
Editor: Importing and Exporting Recordings...............................................................10-34
Processing the Recording................................................................................................10-35
Processing Recording with CT 1 ...................................................................................10-36
Processing Recording with CT 2 ....................................................................................10-37
BI Mode ...................................................................................10-38
Creating a Session From the Recording ........................................................................10-39
Creating Test Data............................................................................................................10-40
Creating a Program...........................................................................................................10-41
Program Functions...........................................................................................................10-42
Generating Function Modules........................................................................................10-43
Function of Function Modules.......................................................................................10-44
Import Interface of Function Module.............................................................................10-45
The Transaction Recorder...............................................................................................10-46
Generated Program...........................................................................................................10-47
Structure of the Generated Program..............................................................................10-48
Structure of BDC Table ..................................................................................................10-49
Read Structure .........................................................................10-50
Opening and Closing the File .........................................................................................10-51
Function Modules for BI Progrmm ................................................................................10-52
Function Module BDC_OPEN_GROUP ......................................................................10-53
Subprogram OPEN_GROUP .........................................................................................10-54
Function Module BDC_INSERT ..................................................................................10-55
Subprogram BDC_TRANSACTION ............................................................................10-56
Function Module BDC_CLOSE_GROUP...................................................................10-57
Subprogram CLOSE_GROUP .......................................................................................10-58
Subprograms BDC_DYNPRO, BDC_FIELD..............................................................10-59
Filling the BDC Table .....................................................................................................10-60
Overview..................................................................................10-61
Call Transaction Program: Example ..............................................................................10-62
CALL TRANSACTION (1) ...........................................................................................10-63
CALL TRANSACTION (2) ...........................................................................................10-64
CALL TRANSACTION (3) ...........................................................................................10-65
CALL TRANSACTION (4) ...........................................................................................10-66
Structure CTU_PARAMS...............................................................................................10-67
Return Code and System Fields.....................................................................................10-68
Generated Program of the TA Recorder........................................................................10-69
The Transaction Recorder...............................................................................................10-70
Integrating into the DX-WB...........................................................................................10-71
DXWB Release 4.5..........................................................................................................10-72
Creating Program as DX Object .....................................................................................10-73
Advantages ..............................................................................10-74
The Transaction Recorder: Unit Summary ..................................................................10-75
Transaction Recorder Exercise 1 ....................................................................................10-76
Transaction Recorder Exercise 2 ....................................................................................10-78
Appendix: Include BDCRECX1....................................................................................10-80
Special Methods ............................................................................11-1
Course Overview Diagram ...............................................................................................11-2
Special Methods: Contents (1) .........................................................................................11-3
BI and Interactive Lists .....................................................................................................11-4
Transaction Recorder Results...........................................................................................11-5
Editing the Recording ........................................................................................................11-6
Special Methods: Contents (2) .........................................................................................11-7
External Data in Variable Data Format ...........................................................................11-8
Reading and Processing Variable Format .......................................................................11-9
Special Methods: Contents (3) .......................................................................................11-10
Synchronous Processing..................................................................................................11-11
Asynchronous Processing...............................................................................................11-12
Special Methods: Contents (4) .......................................................................................11-13
The New Selection Screen for ZRFBIDE00.................................................................11-14
Modifying ZRFBIDE00 for Call Transaction (CT).....................................................11-15
Special Methods: Contents (5) .......................................................................................11-16
SAP Notes on Data Transfer ..........................................................................................11-17
BI Utility Programs ..........................................................................................................11-18
BI Programming: Reduce Rollback Segment Load.....................................................11-19
Further Tips and Information .........................................................................................11-20
Special Methods: Unit Summary ....................................................................................11-21
Special Methods Exercises .............................................................................................11-22
Special techniques Solutions ..........................................................................................11-23
Background Processing..........................................................................................................12-1
Course Overview Diagram ...............................................................................................12-2
Background Processing - Contents (1) ............................................................................12-3
Concept of Background Processing................................................................................12-4
Background Processing Steps..........................................................................................12-5
Creating a Job (1) .....................................................................12-6
Creating a Job (2) .....................................................................12-7
Creating a Job (3) .....................................................................12-8
Creating a Job (4) .....................................................................12-9
Job Overview (1) ....................................................................12-10
Job Overview (2) ....................................................................12-11
Background Processing - Contents (2) ..........................................................................12-12
Parallel Processing with RSBDCSUB...........................................................................12-13
Batch Input Scheduling with RSBDCSUB...................................................................12-14
Jobs...........................................................................................12-15
RSBDCSUB Jobs.............................................................................................................12-16
Frontend Access in Background....................................................................................12-17
Background Processing: Unit Summary........................................................................12-18
Background Processing Exercises ..................................................................................12-19
Backg round Processing Solutions.................................................................................12-22
Download attached file: You must be Loged in to download file