Automation of ACCT Type property in GL account dimension.

[former_member1147219]

Hi Gurus, We have a requirement of loading GL Account Acct Type automatically. We are using BPC 7.5 version and loaded GL

IDs and Hierarchy by using new process chain.We used trasformation and Conversion files for loading ID to GL dimensions.We have a requirement of automation of Acct Type based on the GL Ids( For Eg: GL=10*,Act type=EXP).We have Acct Type as Property in the C_ACCT dimension.

I request you to suggest options to make the Acct Type as automatic.

Thanks

Mahesh

[Former Member]

Hi,

You can try using end routine. You need to use BADI for this. Please check the below link from help.sap:

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/28/b66863b41f47589b9943f80b63def6/content.htm

Hope this helps.

[Former Member]

Hi Mahesh,

An easier option is to map the property to the Account and use a conversion file which mapping between acctype and account for example 10 -> exptype .

Hope this helps.

Regards,

Sachin

[former_member1147219]

Hi Nilanjan,

Thanks for your reply. There is any other methods available to address the requirement apart from BADI.

Can we do by using Conversion file?

There is no source field when loading data from BI Infoobject but need to update a data in the target column of BPC dimension.

Thanks

Mahesh

[Former Member]

Hi Mahesh,

Your source field will be the account .The target will be fetched based on the conversion file.

Regards,

Sachin

[Former Member]

Hi Mahesh,

As Sachin has indicated, you can use conversion file for ACCTYPE property. Depending the account ID, you can mention the ACCTYPE.

Hope this helps.

[former_member1147219]

Hi Gurus,

Thanks for your reply. I configured the Conversion file for automation of ACCTTYPE for GL account.

I have a requirement like 1* series GL = EXP account type. So i configures in the conversion as below

External=1* and Internal =EXP. Now 1* series are populating with EXP account correctly and for other series account it is posting some values.

H0w to make the other series account as BLANK.

And also i need a Guidence for populating ACCTTYPE for GL Nodes also.

Logic for GL Nodes to populate Acct type is immediate Dependencey ACCTTYPE of the node.

Eg:Node=Z0011

GL Account under the Node=100000( Has Acct Type as EXP)

In this above case we need to populate EXP as ACCTTYPE for Node Z0011.

Please help me in configuring the Above scenario.

Thanks in Advance

[Former Member]

Hi Mahesh,

Just try if having another conversion row

EXT INT

• *SKIP

works.

Otherwise you need to mention different account patterns and use *SKIP.

Hope this helps.

Regards,

Sachin