Dan // Eugene // Sivakumar,
Your input is highly appreciated. Our scenario is as follows. Our R/3 system is 4.6C, we have Group COA and Group GL accounts in place in R/3. All the operational GL accounts are assigned to Group GL accounts. We have not activated GLT0 or GLT3 or GLFUNCT tables. I have extracted GL transaction data from BSEG and BKPF tables from R/3 to BI cube FIGL_C10. Since the BI cube FIGL_C10 does not have the char info-objects Group GL account and Group COA, I created custom Group GL account and Custom Group COA. The operational GL accounts data is available at 0GL_ACCOUNT and the aggregated data is available at custom Group GL account.
For Load Data Stream mapping purpose, I had followed the steps mentioned in the SAP help document and SEM 240 academy material. I had chosen the operator as reassignment and I had chosen Chart of Accounts. The 4-digit name of Group COA is also available in the drop down under COA, which I had chosen. Then I mapped each CS_Item with the GL account under that Chart Of Account. The mapping was successful.
I am able to execute LDS but it is not picking Group GL account data but picks data from 0GL_ACCOUNT. I do not find any option to map CS_Item with Group GL account in BCS. How can I map CS_Item with Group GL account in BCS?
Is my extraction from R/3 wrong? If I do not have customized info-objects for Group GL account and Group COA in the BI cube FLGL_C10, then where will I store those data?
All input// feedback are highly appreciated and welcome.
Thanks
Tim