I am creating financial statement as per our requirement. Based on our report when I check Business Content I saw the data flow as per below link
In the above link I couldnt understand why they used both 0FIGL_D40 and 0FIAR_V40 to 0FIGL_M40. I am trying to understand why we are using two data targets ( DSO and Virtual Cube) are pulling data from one data source.
My question is either one of data target can use. And also I need is there any other data flow where I can use for Balance sheet ( Financial report).
Please some one assist me what is the use of two data targets.
Transformations for VirtualProviders, such as 0FIGL_V40, aren't done the same way as they are for traditional InfoCubes in BW. VirtualProviders, for off, are dynamically loaded at the time of query execution and can be based after one of the following:
1) A DTP and a DataSource with 3.x InfoSource. This is provided so that queries can directly accesstransaction data in another source SAP systems.
2) A BAPI. If the date is processed external to BW and read into BW, then a BAPI would be the interface.
3) A Function Module. The Function Module would act as the means for extracting the data from some respository and dynamically load to the VirtualProvider.
To determine which is being used, go into Display or Change mode on the VirtualProvider, expand the Settings and the Subtype identifies the way that the VirtualProvider gets it's data. In the case of 0FIGL_V40, it uses a DTP and DataSource with 3.x InfoSource.
Thanks for your help, I am confused with your statement about Virtual Provider. As for my knowledge is concern there is no DTP Transformation (Correct if I am wrong), UR, TR. I think Virtual provider does contains just source system connection.
Or else could you tell me can I use 0FIGL_O02 --> 0FIGL_C01. Is there any other data flow to useful for Financial Statement.
If you're only producing a Balance Sheet report, then the flow 0FI_GL_10 -> 0FIGL_O10 -> 0FIGL_C10 would be what you need, because typically Balance Sheet accounts (except for maybe inventory) are only updated/adjusted at the end of a Fiscal Period and Fiscal Year.
However, if you're producing an Income Statement report too, then the 0FI_GL_10 -> 0FIGL_O10 -> 0FIGL_C10 -> 0FIGL_V10 flow would be appropriate.
In answer to your concern about VirtualProviders...there can be DTPs for Virtual Providers but those DTPs are invoked by the execution of the query and not manually or via a Process Chain as is the case for regular old InfoCube loading.