Company-code specific GL determination

[siowfong_chen]

Hi! I understand that the company code field is available in the table BBP_DET_ACCOUNT (Define G/L Account for Product Category and Account Assignment Category). However, we cannot use it in the sandard SRM environment. I did try to set the multicompany indicator in table BBPC_MARKETSET but this only allow me to create entry in the 'Define G/L Account for Product Category and Account Assignment Category' configuration. When I shop, the system still does not propose the right GL. Worst still, I encountered error 'Enter exactly one partner of type Sold-to Party.

Apart from using the BADI and building a custom table to maintain company code, product category and account assignment for the GL determination, does anyone know of any other options that are available 'functionally'?

Appreciate any comments on the above.

Thanks!

SF

[summer_wang1 · Accepted solution]

Hi ＳＦ

As per the standard design of GL account determination, the system will

first try to find the customing setting based on the category_guid,

category_id, acc_cat from the table bbp_det_account. If there is no

entry found, the system would then try to find the GL account based on

category_id and acc_cat alone

the only possible way to　do the GL account determination by using the BADI BBP_DTERMINE_ACCT.

Thanks and regards

Summer

[summer_wang1]

Please also use BBP_DOC_CHANGE_BADI , it works for other customer

Summer

[ravindra_mantri2]

Hi SF,

Users in the org structure of SRM are set-up based on company code (check Function tab in org structure).

So you can not set-up product categories account determination specific to company code since it will create confusion.

e.g. if Function tab in org structure has co.code A maintained and extended attributes have prod category assigned from other co code(which has G/L account mapping for co code B). In this case when user trying to create SC for prod. cat. system will get confused.

A straight forward solution for your requirement will be

1) Carry out prod. category -- G/L account -- account assigment category setting in normal way for all G/L a/cs from all company codes.

2) Now while setting extended attributes in org structure, only maintain co.code specific product categories. Or make sure that org unit has appropriate co.code maintained in the attributes so that G/l account exists.

3) This will allow to set-up co-code specific account determination for product categories.

Hope this meets your requirements.

-rgds,

Ravi

[siowfong_chen]

Hi Ravi,

Thanks for the explanation. I guess I was hoping that the system will take the company code assigned to the user and combine it with the product category to derive at the GL account.

Unfortunately we are using the same product category across different company code so cannot adopt your suggestion.In the past, we have built custom table to handle this but I was hoping that the functionality would be included in the new version.

Cheers!

SF