Skip to Content
avatar image
Former Member

AP and AR Cube Table in R/3

Experts,

This is kind of a mix of FI and BW - I can see 3 different cubes in our BW system - one for GL, 1 for AP and 1 for AR - But what are the tables from which it gets this info :

I am under the impression that it is BSEG for GL, but then BSEG contains all the info including AR and AP - so can i say GL cube will have all of the info where AP will be just BSIK and AR BSID.

All answers would be duly rewarded with points.

Thanks,

Nandita

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 20, 2007 at 08:58 PM

    Yes you are right, Bseg is basically your gl table it also contains AP and AR data including the clear items. BSIK and BSID include th AP and AR and has only open items.

    Assign points if helpful

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 20, 2007 at 09:16 PM

    BSEG is made up of BSIS and BSAS for Finance.

    BSIK & BSAK for AP

    BSID & BSAD for AP

    Dont forget BKPF as well for Document header info.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      No I am afraid you are wrong.

      BSIS will hold only the GL postings, and BSIK & BSID will hold the recon details.

      Best to check the account type in BSEG or try t code FB09 to view GL data for a single a/c document.