Block types for Looping in Transaction

Previous  Top  Next

Below is the sample excel data of a multi-line header detail transaction.

transaction---loopingb1

Fig. 1

Basically there are 3 types of Block Types for Header-Detail items in a loop.

a. "Start Value" = Header line value

b. "Loop Value" = Line item value

c.  "Start+Loop value" = Header + Line item value

 

hmtoggle_plus1a. Start Value

In some rare case you have a field inside the loop that should always take value from header row. In that

case, you would map "Start Value" for this field inside the loop.

For example, in the above data file (Fig. 1), if we do not want to write “V0” in every detail item.

We can write it only once as shown in Fig. 2 & map it as Start Loop (Fig. 3).

It will consider “V0” as the block type for all subsequent detail items. (Fig. 4).

transaction---loopingb2

Fig. 2

transaction---loopingb3

Fig. 3

transaction---loopingb4

Fig. 4

 

hmtoggle_plus1b. Loop Value

In some cases, you can have Header is on row 2 and all the line items will be from row 3 as shown in Fig.  In that case, you would map only "Loop value" for the fields inside the loop.

So if we assign loop value (Fig. 6) for the detail items, Process Runner will pickup the detail items from the second row below the header item.

transaction---loopingb5

Fig. 5

transaction---loopingb6

Fig. 6

 

hmtoggle_plus1c. Start + Loop Value

In some cases, you can have Header is on row 2 and all the line items will be from row 3 as shown in Fig.  In that case, you would map only "Loop value" for the fields inside the loop.

So if we assign loop value (Fig. 6) for the detail items, Process Runner will pickup the detail items from the second row below the header item.

transaction---loopingb5

Fig. 5

transaction---loopingb6

Fig. 6

In some cases, you can have Header is on row 2 and also line starts from row 2. In that case, you would

map "Start+Loop value" for the fields inside the loop.

transaction---loopingb7

Fig. 7

transaction---loopingb8

Fig. 8

 

 

See more mapping types:

 

Transaction - Basic | Transaction - Header Detail

BAPI/RFM - Basic | BAPI/RFM - Header Detail

GUI Script - Basic | GUI Script - Header Detail

Data Extractor - Basic