Updating Master Data from a
Flat File
Procedure
...
1. Defining the source system from which you want to load data
In the source system tree choose File → Create.
2. Defining the InfoSource for which you want to load data
Optional: Choose InfoSource Tree → Root (InfoSources) → Create Application Components.
Choose InfoSource Tree → Your Application Component → Other Functions → Create InfoSource 3.x → Direct Update of Master Data.
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 → Your InfoSources → Assign Source System.
You are taken automatically to the transfer structure maintenance.
The system automatically generates 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).
4. 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 |
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: