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

Data Xtraction Query

Hello Experts,

To tell you about the project, I have to extract all FI data from SAP the client doesn't want to continue with SAP, they will be using another ERP. Now, they want all the data (open & cleared) month wise.

  • If client asks for Open items & cleared items separately than how can we do that, for an example if they say that give us the data for cleared items like this:-

doc no.

Doc Type

posting key

posting date

a/c key

G/L account

Amount

11000001

RE

40

  1. 10.1.2012

S

400016

6000

11000001

RE

40

  1. 10.1.2012

S

401199

700

11000001

RE

50

  1. 10.1.2012

K

1001

6700

Is it possible? Because…

  • What I am getting confused in is that all these tables are interrelated and if a vendor line item is been cleared than the table which stores the value is BSAK, simultaneously table BSAS is also getting affected & so as BSIS (BSEG too) therefore i am not able to decide how to start the work because if I am taking the value from BSAK, BSAS & BSIS the data is getting duplicated, For an example when a vendor invoice is been cleared it will be moved from BSIK table to BSAK & BSAS, so BSAK table showing 2 line items for the same document and the GL account for both the line items is the vendor recon account. Same thing is there in BSAS, this too is showing 2 line items under one document and the GL account for both the line items is the vendor recon account. So in this case what line item to be pulled from which table?

Please help.

Thanks & regards,

Pallavi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 27, 2013 at 06:39 PM

    Hi Pallavi,

    Just look BSEG and FAGLFLEXA table where you can get all data ( GL account wise ,Vendor wise ,customer wise). At the day end ,your recon account balance must be tally with sub ledger.

    Regards

    Mani Kumar


    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.