Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Skip routine in transformation

Hello,

I do have a problem with a transformation from different relations and one source field to different target fields.

In the target is only one key. The problem is that I only want to change the relevant fields in the target dataset when I get deltas and don't want to write initials.

Relations (Source)

RELNr.-BP1


BP2-----Rel.Type

1--


4711---8000----partner

2--


4711---8500----mother

3--


4711---9000----father

4--


4711---9500----brother

The relations should lead to the following record

BP Table (Target)

BP1----mother-fatherbrother---partner

4711---8500


9000-9500--


8000

If I test the relationtype per routine and write BP2 to the relevant field the other target fields are written with the value initial. The last record of the datasource wins.

BP--


motherfather---brother partner

4711--


X
X

9500
---X---

I could handle the problem with an end routine when i use a full DTP. Unfortuanaly I need to load only deltas. How can I skip a routine (not a record) in a transformation to not change the target field?

The result should work like this:

Delta

1--


4711---9999-----partner

actual

BP-----mother-father-brother-partner

4711---9500-9000-9500---8000

result

4711---8500-9000-9500---9999

thanks for your help

best regards

Martin

Former Member
Former Member replied

Hi Martin,

what you want to achieve can only be implemented in the extractor already. For each record you get (initial or delta load) you need to add the relations as well.

regards

Siggi

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question