Skip to Content
0
Former Member
Nov 22, 2011 at 08:52 AM

Problem with query on Multiprovider

34 Views

HI Experts,

I have created a multiprovider with 1 info object and 2 cubes, they are

1.VROYACC - Royalty Accurals

2. VBILLDOC Billing Documents for Royalty

3. Z0SD_C03C - Sales/Billing Document Item

Relation of fields i have/need to link all the tree info providers are

I have :

Characteristics:

VROYACC----Material number, Condition Record Number

VBILDOC------Condition Record Number, Billing DocumentNumber , Document Condition

Z0SD_C03c---Material Number,Billing Document Number

Key Figure:

VROYACC---0Amount

VBILDOC---Number of documents per condition

Z0SD_C03c--Gross, Net, Discount royalty accured etc

I have mapped all the char/Key figure correctly to my knowledge, as when i take material i am able to see data from VROYACC and Z0SD_C03c in the result (not merged) but not VBILDOC, but if i take billing document number i am able to see the data of VBILDOC and Z0SD_C03c but not the VROYACC....

I need a report in a single line like

Customer Material Condition Number--Billing DocNUmber and relative key figures

Pl help me to get a clear direction on it.

Regards

Vinoth kumar S