Skip to Content
0
Former Member
Sep 26, 2013 at 04:59 AM

Data Xtraction Query

27 Views

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