Entering content frame

Procedure documentationUpdating Master Data from a Flat File Locate the document in its SAP Library structure

Procedure

  1. Defining the source system from which you want to load data

    2. Choose Source System Tree ® Root (source system) ® Context menu (right mouse button) ® Create.

    For a flat file, choose: File System, Manual Metadata; Data via File Interface.

  2. Defining the InfoSource for which you want to load data

    3. Optional: Choose InfoSource Tree ®Root (InfoSources) ® Context Menu (right mouse button) ® Create Application Component.

    Choose InfoSource Tree ® Your Application Component ® Context Menu (right mouse button) ® Create InfoSource ® Direct Master Data Update

    Choose an InfoObject from the proposal list, and specify a name and a description.

  3. Assigning the source system to the InfoSource

Choose InfoSource tree ® Your application component ® One of your InfoSources ® Context menu (right mouse button) ® Assign source system.

You are taken automatically to the transfer structure maintenance.

The system generates automatically, DataSources for the three different data types to which you can load data.
  1. Attributes
  2. Texts
  3. Hierarchies (if the InfoObject has access to hierarchies)

The system automatically generates the transfer structure, the transfer rules, and the communication structure (for attributes and texts).
  1. Maintaining the transfer structure / transfer rules

Choose either the DataSource to load attributes or the DataSource to load texts.

The system automatically generates a proposal for the data source, transfer structure, transfer rules and communication structure for you.

Attributes

The proposal for uploading attributes displays which structure your flat file must have for uploading attributes, and contains at least the characteristic and the attributes assigned to it. Make sure that the sequence of the objects in the transfer structure corresponds to the sequence of the fields in the flat file.

The following fields can be required in a flat file for attributes:

/BIC/<ZYYYYY>

  

Key for the compounded characteristic (if the characteristic exists)

/BIC/<ZXXXXX>

  

Characteristic key

DATETO*

CHAR 8

valid to – date (only for time-dependent master data)

DATEFROM*

CHAR 8

valid from – date (only for time-dependent master data)

 

Texts

The proposal for uploading texts displays which structure your flat file must have for uploading texts for this characteristic. Ensure that the structure of your flat file corresponds to the proposed structure.

The following fields can be required in a flat file for texts:

LANGU

CHAR 1

Language key (F for French, E for English)

/BIC/<ZYYYYY>

  

Key for the compounded characteristic (if the characteristic exists)

/BIC/<ZXXXXX>

  

Characteristic key

DATETO*

CHAR 8

valid to – date (only for time-dependent master data)

DATEFROM*

CHAR 8

valid from – date (only for time-dependent master data)

TXTSH

CHAR 20

Short text

TXTMD

CHAR 40

Medium-length text

TXTLG

CHAR 60

Long text

 

Note 

The sequence of columns in the transfer structure must correspond to the sequence of columns in your flat file. If you do not use the same sequence, the corresponding transfer structure is not filled correctly.

Activate the transfer structure/transfer rules and the communication structure.

Further Steps:

Maintaining InfoPackages

Result

You have uploaded the master data for the corresponding characteristic. You can check the uploaded data using the master data maintenance.

 Leaving content frame