Skip to Content
0
Oct 25, 2007 at 03:28 AM

Incorrect data copied thru LDS

35 Views

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