Data Xtraction Query

[Former Member]

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	10.1.2012	S	400016	6000
11000001	RE	40	10.1.2012	S	401199	700
11000001	RE	50	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

[suma_mani · Accepted solution]

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