cancel
Showing results for 
Search instead for 
Did you mean: 

0mat_sales datasource enhancment problem

Former Member
0 Kudos

<b>Datasource:</b> 0MAT_SALES_ATTR

<b>Goal:</b> I am trying to enhance the datasource with the following fields: (restricted by the condition type and getting only the current valid rate.)

From table ZA004: (an extract of the pool table A004)

KSCHL, KNUMH, DATBI, DATAB

From KONP:

KBETR, KONWA

The ABAP piece isn't a problem (keys, join and selection works), and I have created the append structure, ZABIW_MVKE_S, which activates fine, like this:

ZZKBETR - KBETR Ref: TCURC - WAERS

ZZKSCHL - KSCHL

ZZKNUMH - KNUMH

ZZDATBI - DATBI

ZZDATAB - DATAB

This checks and activates OK, along w/ my ABAP code. However, in RSA6, when I go in and edit 0MAT_SALES_ATTR and try to unhide the KBETR field, it gives me the error:

<i>The OLTP source still has errors

Message no. R8 417</i>

The only note I find on this is 202162 - R8003: IO of type KYF requires unit field.

However, I can't figure out what I am doing wrong. Can anyone suggest what I am missing or doing incorrectly ???

Thanks,

Stephen

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Stephen,

Have you added TCURC - WAERS to your datasource,regenerated it,and tried again ?

Tony

Former Member
0 Kudos

Yep, no luck.

I have done other modifications to other datasources b4 and not had this problem. I am sure its something simple I am missing, but I can't see it.

- Stephen

Former Member
0 Kudos

Stepehen,

Whenever you are appending the structure and if the structure has quantity/amount fields, you have to include the unit and currency keys. If you already tried the WAERS, try MSEHI from T006 table. This is the unit of measurement/unit key. This should work.

Abdul

Former Member
0 Kudos

Nope, it really doesn't like that. Checking the structure after adding that as the reference errors with the message its the incorrect type.

In looking a <b>KONP</b>, <b>KBETR</b> has a reference of <b>RV13A-KONWA</b>, but that doesn't work either. I have tried a number of variations - in all cases it activates OK, I just can't un-hide KBETR!

If I try and leave the reference blank for KBETR, it automatically fills in <b>TCURS - WAERS</b>.

Is there any place/anywhere I can look which may provide more information or detail on why the "OLTP <i>still has errors</i>"???

- Stephen

- Stephen

Former Member
0 Kudos

This problem has been fixed. I don't know what the issue was in using any of the the reference tables, but I was able to get the following to work:

ZZKBETR - KBETR Ref: ZABIW_MVKE_S - <b>ZZKONWA</b>

ZZKONWA - KONWA

Prior in doing the self-referencing, I had reference KONWA and not ZZKONWA. I still don't understand why references to the RV13A and TCURC tables did not work.

I got this solution in another forum.