Skip to Content
author's profile photo Former Member
Former Member

Report looks like.

HI Gurus,

0FIGL_O02 : General Ledger: Line Items

0FIAP_O03 : FIAP: Line item

0FIGL_O02 having fields:-

Company code, fiscal year, Document No., Profit Centor

100, 05, 10001, un01

100, 05, 10002, un01

100, 05, 10006, un01

100, 05, 10007, un01

0FIAP_O03 having fields:-

Company code, fiscal year, Document No., Vendor

100, 05, 10001, A

100, 05, 10002, A

100, 05, 10003, A

100, 05, 10004, A

100, 05, 10006, B

100, 05, 10007, B

100, 05, 10008, B

100, 05, 10009, B

REPORT OUTPUT.

Vendor, Document No, Profit Centor

A, 10001, UN01

A, 10002, UN01

A, 10003,

A, 10004,

B, 10006, UN01

B, 10007, UN01

B, 10008,

B, 10009,

How to go for this report?

Looking for your input.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 09, 2007 at 08:29 AM

    Create an infoset on o03 and o02 with o03 as a left outerjoin on document number...

    Arun

    Assign points if useful

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Excerpts from a SAP help manual.

      InfoSets are the data sources of the InfoSet Query. They can be compared to an InfoCube to some extent. InfoSets are not containers of data, only references to the database tables or joins of tables. An InfoSet can also refer to a program that collects data.

      In BW, InfoSets can be built on master data (InfoObjects), ODS objects, or joins of these objects.

      How to create standard InfoSets for a certain ODS/InfoObject:

      · Click on the pushbutton Create standard InfoSets in the AWB toolbar.

      The system creates an InfoSet containing all the fields of the corresponding database tables of the ODS/InfoObject. With an ODS object, the system creates an InfoSet for the active records, and an InfoSet for the most recent records.

      You can modify these InfoSets according to your needs. Keep in mind, that only the generated version of an InfoSet can be used by the InfoSet Query.

      These standard InfoSets may be useful as a starting point. However, if you need more sophisticated contents (for example joined objects), you have to create your own InfoSet.

      How to create your own InfoSet:

      · Type in the technical name of the InfoSet on the AWB screen, and click the pushbutton Create new InfoSet.

      On the following screen, the system has already filled in the name of the corresponding database

      table.

      · By clicking the OK button, you get to the screen Join Definition. Define the join conditions.

      · On the main screen of the InfoSet maintenance you can:

      o Select all relevant attributes.

      o Group these attributes into field groups.

      o Define additional fields that may contain additional information, for example

      characteristics or key figures initially not contained in the ODS objects or in the

      InfoObjects.

      o Save your entries.

      Note: If an InfoSet is to be used for queries in a Web environment, the InfoSet must be assigned to an authorization group. To do this, go to InfoSet maintenance, click the pushbutton Change, and choose Global

      properties from the Goto Menu.

      Regards.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 08:55 AM

    Hi

    If it is cube create a multicube ,.. and if it is ODS create an Infoset and do bex reporting..

    You will get it.

    Regards,

    vishwa.

    Assign poits if useful

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.