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:-
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?
Thanks & regards,