Master Data Texts

[Former Member]

I'm have great confusion trying to figure this out; Some vendor names are not pulling into my queries;

FACTS

1) When looking at our 0Vendor Master Data InfoObject I can see a list of all the vendor numbers as well as the corresponding name of the particular vendor (I assumed the name is what is considered the 'TEXTS')

2) When I run a report from our AP ODS that contains 0Creditor it references 0VENDOR to pull in the corresponding name of the vendor. This works in most cases however some vendor names are not appearing. For example vendor 12345 is showing no corresonding vendor name.

3) If I go into 0Vendor info object again I can indeed see vendor 12345 and corresponding NAME.

4) If I then go into the 0Creditor InfoOjbect, click the master data texts table TVENDOR I can see all the texts for 0Vendor however, sure enough vendor 12345 is missing!

5) I looked for an infopackage the updates VENDOR TEXTS but there is nothing!

MY QUESTIONS

- How can the VENDOR NAME exist when looking at the 0VENDOR InfoObject yet not exist in the TVENDOR texts table??

- Why would some vendor names exist in the TVENDOR text table but not all of them?

Our BW was implemented by a consultant a year ago and I'm wondering if somehow he initially loaded the texts and then somehow it has not been updated ever since. Mostly I'm baffled as to why the 0VENDOR info object would not contain the same info as the TVENDOR text table.

[Ashwin · Accepted solution]

Hi!

your assumption might be right like someone might have loaded the texts some time back.

have you tried activating Master Data by selecting "Activate master data" in context menu of the vendor.

with regards

ashwin

[Former Member · Accepted solution]

Ok I just tried this and received the message 'the master data for characteristic 0vendor is already active'.

It's puzzling to me if the consultant did once update the texts then what happened to the old info package because nothing exists.

It is also puzzling that the texts would not show up in the text table yet the name clearly is visibly loaded when looking at the 0vendor infoobject.

[former_member188975 · Accepted solution]

Hi Patrick,

For texts data it is not necessary to activate the master data to make the text available. It is possible that the InfoPackage was deleted and hence you cannot see it now.

[Ashwin · Accepted solution]

Hi!

i dont see any reason why it is not visible in a reference charecter... it might be that in 0vender infoobject you are just seeing to attribute name instead of text and the name is visible..can it be the case?

i too think infopackage was just deleted.

with regards

ashwin

[former_member184494 · Accepted solution]

Patrick ,

is 0vendor part of the ODS or is it referenced as a navigational attribute ?

I think 0vendor must be compounded with 0creditor ?

then check the reporting settings for the characteristic - long texts / short etc , maybe something amiss there...

Arun

[Former Member · Accepted solution]

Patrick,

I believe 0VENDOR is also an InfoProvider, so maybe you wanna have a look at update rules that connect the 0VENDOR_TEXT InfoSource with the 0VENDOR__T InfoProvider.

Maybe that assignment was established before, and now it is not, so that's why you see different texts (one for the InfoProvider and the other for the InfoObject).

Hope it helps,

David.

[Former Member · Accepted solution]

Hmm... David, I guess I'm confused because the infoProvider and th infoObject appear to be showing me the same data. I can clearly see the missing TEXT by looking at the contents of the infoprovider or the infoobject. However, when running queries it seems to be matching up to a totally different table called TVENDOR which does not contain the text. I'm struggling to understand the relationship between the TVENDOR table and the infoprovider/infoobject contents.

[Former Member · Accepted solution]

Thanks for your help folks! I setup an infopackage for the texts (I first had to do a bunch of transports) and when I ran the update it seemed to fix the problem! I don't know what happened to the original infopackage but as long as it works now I am happy!

Thanks for all your help.

-Patrick