Sites: Exporting and Importing Site Master Data
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.
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).
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