Displaying Commodity Codes and Import Code

Use

This function displays descriptions of commodity codes and import code numbers that meet

criteria you define.

Prerequisites

The codes must be loaded into the system before you can search them. For more on loading

codes, see Loading of Commodity Codes and Import Code Numbers

The resulting list of codes is grouped by chapter and section. To display the chapter and section

titles in the list, maintain the following tables in Customizing for Sales and Distribution Foreign

Trade:

Basic Data for Foreign Trade Sections with regard to customs law

Basic Data for Foreign Trade Assign chapters to a section

You can compare commodity codes and import code numbers from the Foreign

Trade Data Service Area. See Foreign Trade Data Service Cockpit

Comparison of Commodity Code Numbers

Use

This function allows you to maintain the lists of commodity codes (for example, US Schedule B

codes) and import code numbers (for example, Harmonized Tariff Schedule codes) in the

system.

Periodically, some codes become obsolete with the customs authorities. This function identifies

obsolete codes by comparing codes currently in the system with the set of codes designated by a

keyword you enter. (See the graphic below.) This designated set of codes could be, for example,

the most recent set of commodity codes you received from the customs authorities and loaded

into R/3. From the comparison, the system creates a list of the codes that are not in the

designated set. You then have the option of deleting the listed codes.

Commodity codes Commodity codes Commodity codes

Currently listed in the selected for

in the system most recent set deletion

100

101

102

103

104

100

101

103

102

104

Prerequisites

To use this function, you must know the keyword assigned to the set of codes on which you want

to base the comparison. (When you load a set of commodity codes or import code numbers, you

can print the key you assigned to the set and keep it on file.) The system uses that keyword to

retrieve the set of codes from its database.

Loading Commodity Codes and Import Code Numbers

Use

This procedure describes how to load an external file containing commodity codes or import code

numbers for use in your system.

Prerequisites

The external file must be in ASCII format

You need to know the structure of the file – which columns (positions) the codes, the text

descriptions and the units of measure occupy.

Procedure

1. You access this function from the Foreign Trade Data Service Cockpit.

2. Choose the appropriate tab – European Union, Japan or Other – in the Load/Compare

section of the Data Service Cockpit. Choose the Load commodity code button next to the

Commodity code field to display the selection criteria screen.

3. Enter the selection criteria and the file specifications.

Entries in the following fields are mandatory:

– Country key

– File name

– Drive

– Subdirectory

– Initial position goods number

– Final position goods number

– Initial position goods text

– Final position goods text

See the field help (F1) for detailed information about each of the fields in this procedure.

You can determine the actual positions of the columns for the data record structure

entries by opening the ASCII file and counting the spaces used for the digits and the

text characters. For this you need to identify the beginning and end positions of the

codes, their texts and units of measure (when applicable) and enter them in the

corresponding fields.

For example, for a commodity code file with the contents "12345678 Sample text"

(with no unit of measure), you should make the following entries in the data record

structure section:

Data Record Structure

Field

Entry

Initial pos. goods no.

1

Final pos. goods no.

8

Initial pos. goods text

10

Final pos. goods text

21

If there is no unit of measure (optional entry), the last position for the goods text can be a

number that is much greater than the actual final position for the goods text (for example,

200).

4. If you want to use this set of codes as the basis for maintaining the codes in the system,

select Carry out preparations and enter an identification code in the Key for upload field. You

will need this key to access this set of codes during maintenance.

5. If you are installing codes from floppy disks or several files

– For the first disk or file, select First data carrier

For additional disks or files, select Further data carriers

6. Execute the function.

Results

The system uploads the file contents to the SAP System.

Potential Errors

When you execute this report, the system issues an error message if

The values for the beginning and end positions overlap

You enter an incorrect length for a commodity code or import code

number

The length for the codes has not been maintained for the country you

enter on the selection screen.

You assign commodity code and import code lengths for each country in

Table T609S in Customizing (see Sales Foreign Trade/Customs

Basic Data for Foreign Trade Length of commodity Codes/Import

Code Numbers).

Loading of Commodity Codes and Import Code

Numbers

Use

This function copies commodity codes [Ext.] into the SAP System from external files available

from the customs authorities. It saves you the time required to manually enter these codes in the

system.

Integration

Once they have been loaded into the SAP System, the codes and their descriptions can be used

throughout the system. For example, you can match them with materials in material master

records and print them in foreign trade documents.

The system stores goods numbers and their descriptions in tables T604 and T604T (Foreign

Trade: Commodity Code / Import Code Numbers).

Prerequisites

Before the function can transfer the codes into R/3, you need to:

Make sure that the file containing the codes and their descriptions is in ASCII format

Know the structure of the file from which the system will copy the codes – which columns

the codes, the text descriptions and the units of measure (if available) occupy.

Features

You do not have to load all codes into your system. If you want, you can load only the chapters

relevant to your business.

You can overwrite all of the system’s existing codes or add only the new codes.

For example, suppose the system contains the codes 100 and 101 and the set of

codes you want to load contains codes 100, 101, and 102. You can do one of the

following:

Load only the new code, 102, and ignore codes 100 and 101

Load the new code and overwrite the existing information for codes 100 and

101

You can load commodity codes and import code numbers from the Foreign Trade

Data Service Cockpit.

Enjoy SAP - Foreign Trade Data Service

New Interface

From this view, you can perform all important tasks relevant to Data Service from a single

screen. For this purpose, this screen is divided into five sections [Ext.].

Additional Functions

Finding Relevant Data Quickly and Easily [Ext.]

Additional Information [Ext.]

Price Determination

Before you carry out the import simulation in the next section, you need to maintain the

corresponding condition records for Foreign Trade. The tasks in this section provides you with all

the necessary condition types for pricing.

Here you can maintain pricing conditions to include

Gross price

Surcharges and discounts

Shipment costs

Insurance costs

You can also maintain the following condition types for customs duties:

Customs quotas

Pharmaceutical products

Customs exemptions

Preferential duty rates

Third country duty rates

Anti-dumping information

Simulation

In this section, you can simulate the import of a product. The system determines the incurred

customs duties, papers and preference situation. Here, the system calculates the duty and lists

the documentation you need to import a material.

See also:

Import Simulation [Ext.

Foreign Trade Data Service Cockpit

Use

This group of functions installs and maintains data pertaining to commodity codes, import code

numbers, duties and required customs papers in the Foreign Trade component. Using these

functions is optional.

To go to the Foreign Trade Data Service Cockpit from the main SAP menu, choose Logistics

Sales and distribution (or Materials management) Foreign Trade / Customs Data service

Cockpit - Data Service.

Features

There are four sections on the initial screen for Foreign Trade Data Service:

Functions on the Initial Screen

Section

Function

Load / Compare

Loading and comparison of commodity codes and import code numbers

with existing codes in the system

Information

Search and display of existing codes in the system

Price determination

Maintenance of pricing conditions

Import Simulation

Determination of duties and documentation for imports

On the initial screen, there is an additional area that you can fill with a picture or text. You can

include the standard picture or a text in this screen by choosing Environment Maintain user

data from the initial screen. The standard picture is SD_FT_SRV_START. You can create a

standard text for display in this section using transaction SO10.

Load / Compare

In the first section, you can load commodity codes and import code numbers from external files

available from the customs authorities (or other data providers) into your system. As codes

become obsolete, this function allows you to maintain codes in the system by comparing existing

codes with updated code numbers before saving the new data in the foreign trade tables.

See also:

Loading of Commodity Codes and Import Code Numbers

Comparison of Commodity Code Numbers

Information

This section provides you with easy-to-use search functions to display existing commodity codes

and import code numbers already in the system when assessing tariffs. You can use selection

criteria, such as chapter numbers, special measures, text and so on, to search for these codes.

See also:

Displaying Commodity Codes and Import Code Numbers

Enjoy SAP - Foreign Trade Processing

New Interface

The Foreign Trade Cockpit enables you to perform all tasks in Foreign Trade processing from the

initial screen. For this purpose, this screen is divided into five sections [Ext.].

Incomplete Foreign Trade Data

From the Operative Cockpit, you can maintain and monitor foreign trade data.

Data Maintenance / Data Selection

To ensure efficient processing of foreign trade data, you can save transactions that are repeated

frequently as variants (see Data Maintenance/Selection [Ext.]).

Additional Functions

Finding Relevant Data Quickly and Easily [Ext.]

Additional Information [Ext.]

Strategic Cockpit

The Strategic Cockpit provides Journal tasks that you can use to list activities that have already

taken place, for example, on a weekly, monthly, quarterly or annual basis. It provides access to

import and export data to create periodic activity statements.

An important feature of the Strategic Cockpit is the effective use of the general list viewer. With

the general list viewer, you can display and sort foreign trade activities, for example, according

to

Vendors

Customs procedures (for example, inward or outward processing)

Value of imports or exports

Bonded warehouses

Monitoring (of master data)

With the Monitoring tasks, you can check whether foreign trade data is complete in master

records and generate a list of records with missing data. See Foreign Trade Data Check in

Master Records.

You can also maintain foreign trade data in these records using the normal system menus. See

Foreign Trade Data in Master Records.

Master data (maintenance)

You can use tasks in the Master data section as a link to check or modify a single master record,

for example, to see whether the foreign trade data has been maintained for a particular material.

Environment (IMG links)

Tasks in the Environment section are linked to the Implementation Guide (IMG). They allow you

to make direct changes in the corresponding IMG tables.

The tables in this section do not include all the tables you need to set up the system

for using Foreign Trade but rather includes tables that need to be modified on a

relatively frequent basis.

Integration

This function is integrated with SD and MM for the maintenance of import and export documents.

Prerequisites

Before this function can display the incompletion lists properly, you need to set up the

corresponding tables in Customizing.

To define the incompletion procedures that you want to use at the header or item level, choose

Sales and Distribution Foreign Trade/Customs Control Foreign Trade Data in MM and SD

Documents Incompleteness Schemas for Foreign Trade Data.

To assign the relevant incompletion procedure to the import and export country, choose Sales

and Distribution Foreign Trade/Customs Control Foreign Trade Data in MM and SD

Documents Foreign Trade Data in MM and SD Documents. This is also the table where you

set the flag "Save Incompletion Log".

Important: You need to set the flag "Save Incompletion Log" in Table V_T609S

(Foreign Trade Data: Control System Response). This is the function that analyzes

the completeness of entries in table EIUV. When you set this flag, the system

records the incomplete documents in table EIUV based on the fields selected in the

incompletion procedure.

If you select documents that were created before activating the incompletion task or

if you have changed the incompletion configuration for foreign trade data in the

customizing tables, it is possible that documents that are “complete” are indicated as

“incomplete” in the incompletion worklist. In this case, you need to run the

reorganization tasks by using the transaction codes created for this purpose.

Afterwards, the entries in the lists and in the documents will be identical

Foreign Trade Cockpit


Use

The Foreign Trade Cockpit has several functions that enable you to monitor and update foreign

trade data in export and import documents, system master records and settings in the

Implementation Guide.

To go to the Foreign Trade Cockpit from the SAP main menu, choose Logistics Sales and

distribution (or Materials management) Foreign Trade/Customs Cockpit Cockpit -

General Foreign Trade processing.

Completion Checks – The Basis of the FT Cockpit

For most activities in the Foreign Trade Cockpit, the system can generate incompletion worklists

that display the status of each document or record individually using a green, yellow or red traffic

signal. The incompletion worklists display all documents or records responding to the selection

criteria and indicate whether foreign trade data is complete (green signal) in the selected

documents.

From these worklists, you can directly access documents that need to be changed and enter the

necessary data. You can also activate incompletion worklists to display only records that need to

be processed.

Features

The Initial Screen – General Foreign Trade Processing

There are five sections on the initial screen of the Foreign Trade Cockpit:

Section

Function

Operative Cockpit

Daily worklist for FT data in documents

Strategic Cockpit

Journal and Evaluations

Monitoring

Master record display and maintenance

Master data

Maintenance links

Environment

Important IMG links

On the initial screen, there is an additional area that you can fill with a picture or text. You can

include the standard picture or a text in this screen by choosing Environment Maintain user

data from the initial screen. The standard picture is SD_FT_PRO_START. You can create a

standard text for display in this section using transaction SO10.

Operative Cockpit

You use the Operative Cockpit to view and update documents on a regular basis. For example,

you use it to perform tasks that are included in your daily workload.

With this task, you can select import documents (purchase orders and goods receipts) and export

documents (deliveries and invoices). You use variants to limit the documents selected.

Since the Operative Cockpit is intended for use as a "working tool”, you should

generally design variants to select documents for a short time period only.

For example, using the Operative Cockpit, you can display and modify the actual

export or import documents that have entered the system today.

You can also use the Operative Cockpit to display your workload by generating a list

of documents for exports that are planned during the upcoming week. You can then

make any necessary changes to complete the foreign trade information in the

documents associated with those exports in advance.

Maintenance of FT Data in Purchasing Documents

Use

This function allows you to maintain foreign trade import data in purchase orders and shipping

notifications.

To maintain data in

Menu path

The purchase order header

In the purchase order, choose Header Foreign

Trade / Customs

A purchase order item

In the purchase order, select the item and choose

Item More functions Foreign Trade / Customs

The shipping notification header

In the shipping notification, choose Header Foreign

Trade / Customs

A shipping notification item

In the shipping notification, select an item and choose

Item Foreign Trade / Customs

Foreign Trade Data in Purchase Order and Advance Shipping Notification

Data

Description

Comments

Material data

Material

The material key for the item

Description

A description of the item

Commodity code

The system copies this data

from the material master record.

Origin

The goods’ country of origin

The good’s country and region of

destination

The system copies the country

of origin from the purchasing

info record as a default value.

It copies the country and region

of destination from the ordering

plant.

Transaction

Import procedure

The procedure by which the

goods being imported are

declared to customs

Transaction type

The classification of the type of

transaction contract

With the appropriate settings in

Customizing, the system

determines the transaction type

automatically based on criteria

like the importing country or the

item category. The system then

copies the data to purchase

orders and advanced shipping

notifications.

Value

Statistical value

The untaxed value of the goods,

including transportation and

insurance costs that arise in the

importer’s country

The system calculates the

statistical values in pricing in the

purchase orders.

Foreign Trade Data in Purchasing Documents

Definition

Data that describes the import or arrival characteristics of a purchasing transaction.

Structure

Foreign trade data appears at the header and item levels in purchase orders and shipping

notifications. The vendor and material master records and purchasing info records propose this

data.

Foreign Trade Data in Purchase Order and Advance Shipping Notification

Headers

Data

Description

Comments

Partner data

Vendor

The vendor key

Delivery vendor

Country key

The vendor country key

The system copies this data

from the purchase order to

the shipping notification.

Customs data

Mode of transport

The technical customs term

describing the type of

transport (for example, see or

air transport) used to take the

goods across a national

border

Office of entry

The key for the border

customs office where the

goods are unloaded from the

mode of transport used for

crossing the border

The system determines this

data from the vendor master

and uses it as a default

value in the purchase order

and shipping notification.

Mode of transport

data

The inland mode of transport

(the mode of transport from

the border to the plant)

The identifier for the means of

transport with which the goods

leave the vendor location

The country of the means of

transport by which the goods

leave the vendor location

The mode of transport by

which the goods cross the

border

The identifier for the means of

transport by which the goods

cross the border

The country of the means of

transport by which the goods

cross the border