cancel
Showing results for 
Search instead for 
Did you mean: 

Missing field in ODS object

Former Member
0 Kudos
115

Hello all,

I´m using standard ODS object to load marketting attributes from CRM to BW (ODS object: 0ATR_DS01). In this ODS there is a field called 0MKTATFOR, that informs about data type (char, dec, numc ...). The issue is that this field exists in PSA but when I finish data upload to 0ATR_DS01 I go to manage to see information in ODS object and this field doesn´t exist.

I simulated the update and I writed breakpoints in transfer and update rules, and everything is correct (this field contains values); in the PSA this field contains values, but in ODS object this field is missing.

Could please please anybody help me?

Thank you so much.

Carmen

Accepted Solutions (0)

Answers (9)

Answers (9)

Former Member
0 Kudos

Hi Carmen,

Did you solve this issue. We are facing excatly the same error with a different ODS and we haven't been able to find the solution.

Regards,

Raimundo Alvarez

Former Member
0 Kudos

Hello:

ODS object --> Right mouse click --> manage --> see content

Carmen

Former Member
0 Kudos

Hello Roberto

if can see my data in New Table (and at the end of debugging); the update mode is overwrite.

I can see the empty ID (ID request) when I go to see data in ODS (not in New data table)

I´m working with BW 7;

Regards,

Carmen

Former Member
0 Kudos

"when I go to see data in ODS "

Where exactly ?

In the active data there is no ID reference and in new table you need it as key field...

Former Member
0 Kudos

Hello Roberto,

I tried to load this data without a subsequent activation process; I checked my field in New Data table, and contains values.

Answering the second point: I don't have any code in my update rule, it's just a simple mapping with (the right) object coming from communication structure/transfer rules.

I checked in debug mode what's the output at the end of update rules processing, and the field contains values.

But I realized something curious; ID request in empty when you see data in ODS. Could have this something to do with te problem?

Could be a basis problem?

Regards,

Carmen

Former Member
0 Kudos

Carmen,

if you see your data in New Table (and at the end of debugging), this means that we have some problem on activation process: which is the update mode? Overwrite one?

Where are you seeing this emty ID ? In New Data table

Former Member
0 Kudos

Hello;

I have this infoObject in the ODS, mapped in update rules and in transfer rules.

I execute a data load. I have a look at PSA and this infoObject is filled. I activate the request, and when I go to manage ODS to see data, this field doesn´t appear at all; (although I included this field in ODS).

I tried to change layout but this field doesn´t appear in the list (and I promise you I included this field when I defined ODS object)

I hope this helps you to understand better the problem

Thank you so much.

Carmen

Former Member
0 Kudos

Ok Carmen.

Now let's try to load this data without a subsequent activation process, then check your field in New Data table.

Just to be sure: you don't have any code in your update rule, it's just a simple mapping with (the right) object coming from communication structure/transfer rules.

Did you check in debug mode what's the output at the end of update rules processing ? We have to understand in which step we are missing the value.

Bye,

Roberto

Former Member
0 Kudos

Hi,

Use the Listcube transaction.

1: TCODE : LISTCUBE -> 0ATR_DS01

2: execute

3: settings->layout->change

change the layout after displaying the content and select the field you want to see.

Happy Tony

Former Member
0 Kudos

Hi Carmen,

just to better understand...

do you have the infoobject in your ODS, but it's not filled or do you have missed the object in ODS?

Former Member
0 Kudos

Hi

Go to the contents from ODS manage and click Fld Selection for Output, look for the infoobject and check it and exicute to see the data in the ODS.

Hope it helps

Chris

Former Member
0 Kudos

Check the assignment of this field in transfer and update rules; you have checked that the fild is populated in trnasfer and comunication structure, but is it assigned to the infoobject?

Hope it helps.

Regards