cancel
Showing results for 
Search instead for 
Did you mean: 

What is the best way to track a characteristic from R3 to a BEx report?

Former Member
0 Kudos

Hi,

What is the most convinient way to track these 2 characteristics in my enivornment:

Data flows from R3 to InfoSource1, InfoSource2, InfoSource3 and InfoSource4.

InfoSource1 and InfoSource2.flows to ODS1

and

InfoSource3 and InfoSource4. flows to ODS2

then ODS1 and ODS1 flows to Cube1 which then goes ro MultiProvider1

"Created On" characteristics came in from InfoSource1

and

"Change On" characteristics came in from InfoSource2

Now when you go into BEx, these two are not shown in the dimension nor the report structure, but there are other Time characteristics such as Calendar Day, Calendar Month, Calendar Week.

What are the definitive steps can I take to track down the "Change on" anbd "Created on" down to my report in BEx?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

hi Amanda,

try to check the transfer rules and update rules,

use the technical name, if they are fields from r/3 extract structure,

check whether they are assigned to infoobject and which infoobject,

then check how these infoobjects mapped to bw transfer structure,

check communication structure, update rules etc

hope this helps.

Former Member
0 Kudos

Ok, in the transfer rule in one case I see them mapped to some Infoobjects, but when they get to the Communication structure, they are not mapped.

In another case I do see the mapping then also in the comm. structure.

Can you tell me with the scenario above how it is typically mapped?

Also, when I see in he transfer rule that there is a mapping e.g.

InfoObject1 maps to a field XXXX, how do I track down to a document to see what is actually being entered in the Sales Order document on R3.?

Is it possible that “Change on" and "Created on" were mapped onto Calendar Day? … It is a weird question but in the query the only available Time characteristics Calendar Day, Calendar Month, Calendar Week.

Thanks

0 Kudos

hi Amanda,

..how do I track down to a document to see what is actually being entered in the Sales Order document on R3.?

- normally for this, we need to understand the definition of that field sales order document in r/3, if the description just the same as in sales order screen (VA03),

to verify the field we can press F1 on that field, and 'technical information', check 'Field Name'.

we can only mapped one field to one infoobject, you can create another date characteristic or use business content delivered,

if you are using business content e.g sales and install everything from business content, the mapping should be taken care by system.

hope this helps.

Answers (1)

Answers (1)

Former Member
0 Kudos

If you dont see "created on" and "changed on" in Bex, then the initial possibilities are:

1.Check the update rules in the ODS and the cube.

2. Check the definition of the multi provider; you may not have these two objects in the multi cube or not identified in the identified tab in multi cube definition cube.

Ravi Thothadri