Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Infocube/query: more than a record by item

Hi everybody,

Please review this issue and kindly suggest a solution. I have an InfoCube feeded by 3 DSOs, here I go with the structures:

Zo01

ZDOCNR (Key)

ZPOSNR (Key)

ZDOCTP (Key)

ZREQNR

ZPOSRQ

ZIND

ZKYF01

ZKYF02

Zo02

ZDOCNR

ZPOSNR

ZREQNR (Key)

ZPOSRQ (Key)

ZKYF03

ZKYF04

Zo03

ZDOCNR (Key)

ZPOSNR (Key)

ZREQNR

ZPOSRQ

ZKYF01

ZKYF02

(Key) are the keys for each one of the DSOs, as you can see, each one of them has different key combinations. Now, my InfoCube let's supose has this structure:

Zic01

ZDOCNR

ZPOSNR

ZDOCTP

ZREQNR

ZPOSRQ

ZIND

ZKYF01

ZKYF02

ZKYF03

ZKYF04

We want to generate a report over this InfoCube having the info which comes from the 3 mentioned before DSOs but when reporting more than a record appears for each item. Let's supose this sample:

Zo01

ZDOCNR ZPOSNR ZDOCTP ZREQNR ZPOSRQ ZIND ZKYF01 ZKYF02

0001 1 X 1 1 LIB 123 456

Zo02

ZDOCNR ZPOSNR ZREQNR ZPOSRQ ZKYF03 ZKYF04

0001 1 1 1 789 012

Zo03

ZDOCNR ZPOSNR ZREQNR ZPOSRQ ZKYF01 ZKYF02

-no data-

the results in the InfoCube and therefore in the query is as follows:

Zic01

ZDOCNR ZPOSNR ZDOCTP ZREQNR ZPOSRQ ZIND ZKYF01 ZKYF02 ZKYF03 ZKYF04

0001 1 X 1 1 LIB 123 456

0001 1 1 1 780 012

I would like you to suggest how can I design the model so I can get these results (in the InfoCube and therefore at the report output):

ZDOCNR ZPOSNR ZDOCTP ZREQNR ZPOSRQ ZIND ZKYF01 ZKYF02 ZKYF03 ZKYF04

0001 1 X 1 1 LIB 123 456 780 012

Thanks a lot in advance. With best regards,

Bernardo

Former Member
Former Member replied

Bernardo,

Not sure how far down the line you are in your design, but, if it is flexible you should still be able to populate a single DSO if you have the DOC no and Line NO as keys from all 3 sources. Assuming you get this information from all three sources.

You could create the new DSO with just DOC no and Line No as the key and have all other fields (from all 3 DSOs) as data fields.

Create a transformations from each source into the DSO and set the fields not supplied by the source to no update. The DSO will do the work for you to consolidate into a single record.

Regards,

Sanjiv

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question