Importing a File: Transformation of a Record (SAP Library - Executive Information System and Business Planning)

Importing a File: Transformation of a Record

The records in the file have the following structure:

Field	Description
YEARB	Fiscal year
COCDE	Company code
PLANT	Plant
CSTCT	Cost center
VLA01	Value A Period 1
VLA02	Value A Period 2
.
.
.
VLA12	Value A Period 12
VLB01	Value B Period 1
VLB02	Value B Period 2
. . .
VLB12	Value B Period 12

This record must be transformed into 12 records (Repetition factor 12; Start value 1; Increment 1) with the following structure:

Field	Description
YEARB	Fiscal year
PERDE	Period
COCDE	Company code
PLANT	Plant
CSTCT	Cost center
VLA	Value A
VLB	Value B

The second record differs from the first in two ways:

It contains the field PERDE. This field should be entered under the parameter Index field on the selection screen.
Instead of the 24 fields VLA01,...., VLA12, VLB01,...., VLB12, it contains the two fields VLA and VLB.

The sender structure of the second record must be described for the data transfer. Make the following entries on the selection screen to transform the first record into 12 records of the record of the second structure.

Field	Entries
Index field	PERDE
Repeat factor	12
Start value of the index field	1
Increment of the index	1
Repeat fields	VLA
	VLB

After the transformation 12 records exist, each with the additional field PERDE. Instead of the 24 fields VLAO1....VLA12, VLB01.....VLB12, each record contains the two fields VLA and VLB. In the first record, the field VLA is filled with the value VLA01, and VLB is filled with the value VLB01. In the second record the field VLA is filled with the value VLA02, and field VLB is filled with VLB02 etc.