Entering content frameFunction documentation External Data Transfer Of Master Data For Internal Orders, With Transaction Locate the document in its SAP Library structure

Use

Instead of using batch input, you can transfer internal orders automatically from external systems to the SAP R/3 System. The system enters data from the external files into the data fields of the SAP-R/3 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.
Old and external data is normally transferred to the SAP R/3 system as part of the implementation project in the IT department.

Note

To transfer actual data from internal orders, use the following transactions:

Prerequisites

You are in the KO09 transaction: Sender structure maintenance for orders: Master data

Features

The system enters data from the external files into the data fields of the SAP-R/3 internal orders that you wish 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 R/3 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 the orders that you want to create in the SAP System must exist in an external file in the format of 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

Order Settlement

The KONTY_n field determines the settlement receiver (n=1,2,3). You can settle to the following receivers if you fill KONTY_n as follows:

Settlement Receivers

Receiver

KONTY_n

Conversion Exit

Asset

AN

ALPHA

Cost center

KS

  

Cost object

HP

ALPHA

Networks

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 contents from the domain table for the SCOPE data element. The system uses five-characters, for example, 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 when you create or maintain internal orders in SAP R/3 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.

Example

Name on the screen:

Plant

Screen field name:

WERKS

Field name in sender structure:

WERKS

 

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.

Maintaining Order Types and Dependent Objects

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 SAP R/3 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 R/3 System must be able to recognize all the organizational units, settlement receivers, and so on. If you want 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. It must already exist in the system.

Note

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.

 

Activities

If the sender and receiver structures are the same, proceed as follows:

Defining The Sender Structure

  1. Choose New entries.
  2. Enter the sender structure name (such as ORSEND) and an explanatory short text.
  3. Enter a 1 under Item.
  4. Enter OREXT as a DDIC structure.
  5. Save the sender structure.

Processing Transfer Rules

  1. Choose Environment ® Transfer rules.
    The sender structure that you just generated is already defaulted.
  2. To process the transfer rules, choose Maintain.
  3. Choose Create default rule.
    The system inserts the field names of the sender structure into the sender fields.
  4. 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.

Example For A Data Transfer

The RKOFILET report 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:

  1. As described above, generate the ORSEND sender structure.
  2. Start the RKOFILET report and make entries in some of the fields provided.
    The data is not checked, as this is a test.
  3. Start the old data transfer
  4. Set the following indicators for the test:
  1. For an overview of the written sender records, and the messages for each record, choose Logs.
  2. To be able to see this overview later on, start the RKCDLMON report.

Activities

Transferring Old and External Data

You can also:

For more information on data transfer, see the SAP Library, under Financials ® Enterprise Controlling ® Executive Information System and Business Planning ® Data Collection ® Structure link Data Transfer Methods.

 

 

Leaving content frame