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

Business Content Cube Containing GL Data - Mainly from BSEG

I'm looking for a good business content GL cube which gets most of the data from BSEG. Any suggestions?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 08:23 PM

    We are on a 6.0 ERP system. All the documentation for the 0fi_gl_4 extract seem to be using DMSO fields whereas BSEG has DMB fields. Where does it get the DMB fields?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Use 0FI_GL_4 if you don;t have all the fields you want from BSEG - then use the CI_BSIS include attached to extraction structure (check OSS)

      In the CI_BSIS include you can add any field from BSEG as long as you give it it's proper field name

      This is the one of the only occasions you don't specify ZZ to begin your field names!

      THe way it works is that it extracts data from two views based on BKPF/BSEG and then BKPF/BSEG/BWFIAEDAT (which is a BW specific table implemented via a SAP standard BADI which tracks proper changes to BSEG records - the change date in BKPF can;t be trusted for this!)

      Then once this data has been extracted - the function module then loops aroudn the records of the extractor against BSEG doing a move-corresponding ..

      .. and thus automatically picking up your CI_BSIS include fields without you having to cmod the extractor

      You aslo have to use a ODS (change log DSO) before the cube to resolve duplicates (because you can change fi documents - ie text, due dates stuff like that)

      However be very careful about putting line item information into your cube if you huge volumes (think of the size of the SID table for accounting document number!!)

  • Posted on Jun 16, 2008 at 01:49 PM

    Hello,

    use 0FIGL_O02 ODS object (BSEG analog) as a base and make your own Z InfoCube according to your local requirements.

    Best Regards,

    Maciej

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 01:58 PM

    HI

    Reagarding GL everything will bring from BSEG using the 0FI_GL_4 data source.

    0FI_GL_4 is mapped to 0FIGL_O02.

    Regards,

    Chandra.

    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.