AP and AR Cube Table in R/3

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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.

[Former Member]

Mark,

Am i correct in saying this :

BSIS consists of BSIK and BSID and

BSAS consists of BSAK and BSAD.

Thanks,

Nandita

[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.