0MAT_VEND Statistics Vendor

[Former Member]

Hi,

I am new to BI (using 7.0) and when running an info package for data source 2LIS_11_V_ITM it extracts all my data, but doesn't activate (or turn green), and displays many errors stating "No statistics vendor could be found for article..."

Diagnosis "The master data table for 0MAT_VEND does not contain any suitable entries for article..."

I can not find any information on this error, and wondered if anybody else has this problem...?

Thanks for your time,

Alice

[Former Member · Accepted solution]

Hi,

check in your start routine, there should be a form gathering the statistics vendor from the master data of 0MAT_VEND.

Of course you'll have to 0MAT_VEND and activate this master data before loading your V_ITM transactional data...

hope this helps....

Olivier.

[Former Member · Accepted solution]

Hi,

Thanks for replying. I have activated the master data already. But could you elaborate on your first point?

Alice

[Former Member · Accepted solution]

Hi,

in the start routine (either during TRules or URules) you have a form executed. This form is populating an internal table based on information from 0MAT_VEND

0RT_STVEND (if I remeber correctly) should have a transfer/update routine looking up to this internal table with the value of the material in the transactional record. If a "statistical vendor" is found then fine. If not you'll get these messages...

hope this helps...

Olivier.

[Former Member]

Hi,

Your reply has helped me narrow down the problem. It is actually causing an error because 0PLANT has a blank line in it. I've looked at the other info objects with master data, and discovered they all do.

What is the reason for this and how do I get around it?

Thanks

[Former Member]

Hi,

I don't get your input of 0PLANT being blank...

In the start routine there is a LOOP AT DATA_PACKAGE and for each record the system will

- perform determine_conf_material using DATA_PACKAGE-material changing confmat.

- if confmat is initial.

PERFORM determine_statvendor USING DATA_PACKAGE-material CHANGING l_rc.

else.

PERFORM determine_statvendor_conf_mat USING DATA_PACKAGE-material confmat CHANGING l_rc.

endif.

During this process please note that 0PLANT is never used...

Also be aware that these "retail content" routines are very bad tuned... but that's another story...

let us know your investigations....

Olivier.

[Former Member]

Hi,

The blank line in 0PLANT appears to be in all BI Content master data info objects. When you run "display data" there is a line, where all the key figures are "0", and there is no data in the characteristics. This isn't a line from the source system, and when a colleague has looked into it, appears to be the reason why I'm getting my error.

What you stated is in the Start Routine for the Update Rule, but I am unsure how this is helping my issue.

Any more information you have would be very useful.

Thanks

Alice.

[Former Member]

Hi Alice,

sorry, I still don't get it....

what do you mean by

"The blank line in 0PLANT appears to be in all BI Content master data info objects. When you run "display data" there is a line, where all the key figures are "0", and there is no data in the characteristics"

Do you mean that 0PLANT is never filled? where? as attribute of anoter characteristic?

Which data do you display "when you run display data"? Master data from an IObj? Transactional data from a cube? PSA?

Do you mean that an empty record has been posted in your cube?

-

---

The error message you are describing in your first post is definitvely because you don't have entries in your 0MAT_VEND corresponding to the material (or its configurable material, the "generic" of a "variant") coming in your 2LIS_11_V_ITM record....

hope this helps...

Olivier.

Edited by: Olivier Cora on Jan 17, 2008 3:39 PM

[Former Member]

Hi,

Sorry. I'll try and make myself more clear.

When looking through the list of master data Info objects in RSA1, through the Info Provider screen, you can right click on the master data IO and choose "display data". When i do this on any of them, there is one line already in them (that I have not placed there).

When I transfer my data into it (i.e. with 0PLANT), my data is displayed, but also is this one line.

We found the error in the include RS_BCT_RETAIL_STATVENDOR

in the sub routine get_statvendor

READ TABLE l_tab_plant

WITH TABLE KEY plant = l_tab_matvend-vendor.

IF sy-subrc <> 0.

• the found vendor is not a plant (internal vendor), ok and exit

l_vendor = l_tab_matvend-vendor.

l_rc = 0.

ENDIF.

The read should fail if the vendor field is initial but because of the blank line, it doesn't.