Instead of using batch input, you can transfer internal orders automatically from external systems to the ERP system. The system transfers data from the external files into the data fields of the new ERP internal orders. The easier way of transferring external data from master data is to use a BAPI. For more information on external data transfer of master data for internal orders using a BAPI, see Information Sheet: Transferring Master Data for Internal Orders . Legacy data and external data is normally transferred to the SAP system as part of the implementation project in the IT department.
To transfer actual data from internal orders, use the following transactions:
KAFD, which transfers costs on orders/projects and networks
KAFL, which deletes transferred costs on orders/projects and networks
You are in transaction
KO09
Sender Structure Maintenance for Orders: Master Data
.
The system transfers the data from the external files to the data fields of the internal orders that you want to create. The procedure for is the same as for creating orders from the application. To transfer data, you can use the receiver structure OREXT (external order) in the SAP system. This receiver structure (for transferring data from the external system) consists of the fields in the order master data, and up to three distribution rules. A corresponding sender structure must exist in the external system. All orders you want to create in the SAP system must exist in an external file with the same format as the sender structure. The external file must contain exactly one complete sender structure for each order (including up to three distribution rules).
See also:
Example of a Completed Sender Structure
The field
KONTY_n
determines the settlement receiver (n = 1, 2, or 3). You can settle to the following receivers if you fill
KONTY_n
as follows:
Receiver |
KONTY_n |
Conversion Exit |
---|---|---|
Asset |
AN |
ALPHA |
Cost center |
KS |
|
Cost object |
HP |
ALPHA |
Network |
NP |
ALPHA |
Order |
OR |
ALPHA |
Sales order |
VB |
ALPHA |
Project/WBS element |
PR |
KONPR |
G/L account |
SK |
ALPHA |
If you want to use fewer than three distribution rules, leave the
KONTY_n
fields blank that you do not need.
The (BUKRS) field in the distribution rule is needed for future releases, and is currently not included. Therefore you need to leave it blank.
The
SCOPE
field (object class) is two characters long in the
OREXT. Entries there are not language dependent (for example, OC for overhead costs). For the purposes of the screen display, the system determines the language-dependent field content from the domain table for the
SCOPE
data element. The content is displayed with five characters (such as
GKOST
for overhead costs).
For order types whose old order status management is active, you can use the
ASTNR
field to set the initial status. Otherwise, the system uses the default status.
The same consistency checks are made for the automatic creation of internal orders as those made when you create or maintain internal orders in the transactions. This means you must fill the same fields. The field names in the sender structure must be the same as the screen field names.
Name on the screen: |
|
Screen field name: |
|
Field name in sender structure: |
|
You can display used field names on a screen by positioning the cursor on that field, then choosing F1 and
Technical information
. In the data element field, you can see the technical name of the corresponding field.
Many of the attributes of the order to be created are derived from the order type (for example, whether revenue postings are allowed or not). You need to specify the order type in the appropriate field in the sender structure. The data you transfer using the sender structure must fit the definitions of the corresponding order type in the system.
If you require a settlement rule, you need to enter a settlement profile in the order type. If you want to transfer a source assignment, you must maintain the source structure.
The SAP system must be able to recognize all the organizational units, settlement receivers, and so on. To settle one of the orders you want to create to a different order, you cannot create this in the same run as the order you want to settle, as it must already exist in the system.
In contrast to the creation of orders in the application, you cannot use reference orders or model orders in the process of transferring old, or external data from external systems.
If the sender and receiver structures are the same, proceed as follows:
Choose
New Entries.
Enter the sender structure name (such as ORSEND) and an explanatory short text.
Enter a
1 under
Item
.
Enter
OREXT as a
DDIC structure.
Save the sender structure.
Choose
Environment
Transfer Rules.
The sender structure that you just generated is already defaulted.
To edit the transfer rules, choose
Maintain.
Choose
Create Default Rule.
The system inserts the field names of the sender structure into the sender fields.
Save the default rule.
If the sender and receiver structures are
not the same, see the implementation guide (IMG) for information on settings that you can make, under
Enterprise Controlling
→
Executive Information System and Business Planning
→
Data Transfer.
The report RKOFILET is available as an example of data transfer from an external system. You can use this report to create sender records on the hard drive of your presentation server for testing purposes.
Proceed as follows:
Generate the sender structure ORSEND as described above.
Start the report RKOFILET and make entries in some of the fields provided. The data is not checked, as this is a test.
Start the transfer of legacy data.
Set the following indicators for the test:
File system:
Presentation server
File type:
CSV format
Number format:
Decimal point
For an overview of the written sender records, and the messages for each record, choose
Logs.
To be able to see this overview later on, start the report RKCDLMON.
Transferring Legacy Data and External Data
You can also:
See files using the transaction KO08.
For more information on data transfer, see the SAP
Library
, under
Financials
→
Enterprise Controlling
→
Executive Information System and Business Planning
→
Data Collection
→
Data Transfer Methods
.