cancel
Showing results for 
Search instead for 
Did you mean: 

Delta for 2LIS_02_ITM with appended Z fields

Former Member
0 Kudos

Hello experts,

I have a problem with the delta. I use the standard extractor 2LIS_02_ITM (order positions) with the update mode "Direct Delta" and apanded Z-fields. These Z-Fields are in the database table EKPO. The fields are filled with an Z-transaction directly in the database. Now my problem is, when these Z-fields get filled, I get no delta from the standard extractor.

How we can change the Z-transaction so that the extractor provides a delta data set when the Z-Fields are filled? I didn't found anything how the extractor notices, that the order has been changed...

Plz help me!

Ralf

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Nothing to modify in Z_transaction....you have to midfy the CMOD code which you are using right now to populate these Z fields in the extractor.

As you have mentioned that these Z fileds are already part of extractor...just make sure that you have code written in CMOD to populate it clearly from EKPO table

Thanks

Ajeet

Former Member
0 Kudos

Hi Ajeet,

we don't use code in CMOD now for this but the fiedls will be extracted nevertheless.

Could you give me an example of code for this or any link where I can read how to do it? And when we have the code, the extractor really will give me a delta when I fill the Z-fields?

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi all,

I have a Z field in the extractor 2LIS_02_ITM. Normally this field is changed via ME22N.

My problem is that this field is not delta relevant. Which means that a change to this field will not put the PO item in the 2LIS_02_ITM queue of RSA7.

This way the BI value of this field is not updated.

I've implemented EXIT_SAPLEINS_001, but i'm not understanding how to make the PO to go into the queue.

Can you please help me?

Regards

Former Member
0 Kudos

Hi,

almost 4 years later, I have exactly the same issue. the Z fields that I added in EKPO and in my datasource 2LIS_02_ITM are not triggering a delta update to BW.

Did you found any solution that you could share?

Regards,

Frederic.

Former Member
0 Kudos

argh, my fault, 2lis.. so no changepointer/ALE-Delta... sorry! My hint is only relevant for this kind of delta method.

Are these fields not maintained with a standard transaction?

best,

Sascha

Former Member
0 Kudos

No problem. No the fields are filled with an custom Z transaction...

Former Member
0 Kudos

imho, this z-transaction should use a standard document posting function module, I think then, you would get your delta. At the moment, you are only changing the table item. The delta machanism doesn´t notice this. So, add a step to your abap, posting the existing document, to get a before and a after image.

best,

Sascha

Former Member
0 Kudos

Yes we thought about this as well. Maybe we can simulate a "saving" of the order. But I think there is another way so that the extractor notices the change of the field. I read something about the user-exit LEINS001 in another [thread|;. When we write code in the exit LEINS001 for 2LIS_02_ITM, then even the enhanced fields are delta enabled. But I don't know the code...

Former Member
0 Kudos

yes, but this exits are only used when posting a purchasing document... The relevant ABAP for your coding then is the ZXM06U16.

So, I think, it`ll be the best way to "pseudo-post" your changed document.

Former Member
0 Kudos

Hi Ralf,

you should search this forum for "BD52" and "ROOSGEN" - then you`ll get the information needed.

in keywords: you have to add the needed fields to your relevant message type in transaction BD52, the relevant message type for 2lis_02_itm, you`ll find in table roosgen.

best,

Sascha

Edited by: SB on Sep 18, 2008 1:11 PM

Former Member
0 Kudos

Hi Sascha,

thanks for the answer, but the field "message type" in table ROOSGEN for 2LIS_02_ITM is empty...

Former Member
0 Kudos

I have not clearly got ur querry

but what i feel is that u have modified the standrd data source with some z-fields and now want these z-fields to extract from EKPO table

If that is so u will have to write a user exit using CMOD

Enhancement assignment - RSAP0001

Component EXIT_SAPLRSAP_001

Former Member
0 Kudos

Hi,

thanks for youre answer. My problem is, when I fill the Z-fields in the EKPO I want to have a delta data set in my deltaqueue. But I don't get it.

When I open the order with transaction ME22 change anything and then save it, I will get a delta. But the Z-fields are not filled with this transaction. We use an own Z-transaction for this.

Hope you understand me better now?