Entering content frameFunction documentation Sites: Exporting and Importing Site Master Data Locate the document in its SAP Library structure

Use

Use, for example, to copy site master data from R/3 Release 4.6C and later releases to releases prior to R/3 Release 4.6C. You export site master data from the source system and import it to the target system.

Integration

The site master consists of the following data:

You can import Customizing tables and settings by transporting the IMG or copying the client.

Features

Exporting Site Master Data

When you export site master data, the system reads all site master data (Customizing tables and settings, and application data) that can be maintained on-line via the site master data maintenance screens.

The individual table entries are written line by line to an ASCII file in the following format:

<table name><data record>

More than one site master record can be written to an export file.

Importing Site Master Data

The import program of the site master can only process ASCII files generated by the export program of the site master. The import program adds the application data (customer or vendor master data, retail-specific data) to the Customizing tables and settings that are in the target system following IMG transport or client copy.

The data records are read in full and written to an internal structure corresponding to the table name. Data records with unknown table names are not processed and are listed in an error log.

The system compares the imported data records to the data records that already exist in the target system. If differences exist, the existing data records are overwritten by the imported data records.

The system checks the data records for check table entries only. Check table entries include organizational units such as the company code. This data must exist in the target system, for example, as the result of a client copy.

The site import program does not check that:

Activities

If you have already completed the site master data by importing it to the target system, you can repeat the exporting and importing of site master data as often as required.

Note

Following a client copy, you have IMG entries for sites and valuation areas that:

If the target system contains IMG entries for sites and valuation areas that have no application data, do one of the following:

Use the site master maintenance transactions, and not the IMG, to change site master data (for example organizational assignments, addresses, customer and vendor assignments).

Example

Following a client copy, an IMG entry refers to a customer master record that does not exist in the target system. You create the site master data and corresponding customer master data in the target system.

The system takes the following tables into account during exporting/importing:

Site Customizing Tables

Table

Content

T001W

Sites/branches

T001K

Valuation area

T001L

Storage location

TWLOF

Storage location determination

T436A

Scheduling horizons

T161W

Order types for stock transfers

T024D

Stock planners

T024W

Allowed purchasing organizations for the site

T064S

Stock levels for inventory sampling

T130W

Site parameters for master data maintenance

T134G

Organizational area: business area determination

T134M

Quantity/value update control

T148W

Site parameters for special stock maintenance

T159C

Value table for count cycles if cycle counting is active

T159L

Default values for inventory management and physical inventory

T159R

MB document re-organization - document runtimes

T159X

Inventory management: XAB number range determination

T161I

Release strategy determination

T161V

Shipping-related data for stock transfers for purchasing document types

T16FW

Function assignments for release codes

T320

Assignment of IM storage locations to WM warehouse numbers

T399D

Control parameters for requirements planning

T438M

Control parameters for requirements planning (article level)

T438R

Range of coverage profile

T438S

Texts for range of coverage profile

T438X

Text for requirements planning group

T439G

WBS planning periods: header table

T439H

WBS planning periods: long texts

T439I

WBS planning periods: schedule lines (periods)

T439J

WBS planning periods: calculation rules

T439L

Storage costs for requirements-planning lot sizes

T439P

Allocation for forecast requirements

T440L

Forecast correction factors

T460T

Special procurement key

T0460T

Texts for special procurement keys

TMKSU

Purchasing calculation schema for stock transfers

TMVFU

Availability check: scope (default values)

TMW00

Requirements planning default values for each article type

TNAD7

Message control: printer for each storage location

TNAD9

Message determination: printer for each storage location and user group

TVKOL

Picking: storage location determination in deliveries

TVKWZ

Organizational unit: allowed sites for each sales organization

TVSTZ

Organizational unit: shipping points for each site

TVSWZ

Shipping points for each site

TWICSCMF

SAP Retail Store: assignment of Customizing schemas to sites

 

Central Address Tables

Table

Content

ADRC

Addresses (central address management)

ADR2

Telephone numbers (central address management)

ADR3

Fax numbers (central address management)

ADR4

Teletext numbers (central address management)

ADR5

Telex numbers (central address management)

ADR6

SMTP numbers (central address management)

ADR7

R/mail numbers (central address management)

ADR8

X.400 numbers (central address management)

ADR9

RFC destinations (central address management)

ADRT

Texts for communication data (central address management)

ADRCT

Texts for addresses (central address management)

 

Retail-Specific Application Data

Table

Content

WRF1

General site data

WRF3

Supplying site, time-dependent

WRF4

Sites/departments

WRF5

Site/merchant ID of credit card company

WRF6

Site/merchandise category

T023W

Control table for value-only article determination

T023X

Exception table for value-only article determination

WRF12

Site/receiving points

 

Customer Master Application Data

Table

Content

KNA1

Customer master (general part)

KNB1

Customer master (company code)

KNVK

Customer master contact persons

KNEX

Customer master: legal control: sanctioned party list

KNVA

Customer master unloading points

KNVI

Customer master tax codes

KNB5

Customer master (dunning data)

KNBK

Customer master (bank details)

KNVV

Customer master (sales data)

KNVP

Customer master (partner functions)

 

Vendor Master Application Data

Table

Content

LFA1

Vendor master (general part)

WYT1

Vendor sub-range

WYT1T

Vendor sub-range description

LFB1

Vendor master (company code)

LFBK

Vendor master (bank details)

LFM1

Vendor master (purchasing organization data)

LFM2

Vendor master: purchasing data

WYT3

Partner functions

Additional Information

Sites: Transfer and Distribution of Master Data

Sites: Distribution Between Different Releases

Leaving content frame