Interest Expense Different Cost Center

[former_member200703]

Hi Experts

I am facing an issue while posting the loan interest , the TBB1 is giving as error that the GL related to bank loan interest has to be assigned to cot object..

i am aware of the error message as its familiar in FI, but here the issue that different loans used in different projects .. every project assigned to different cost centers ,

How can i assign every loan to specific cost center  that its interest use this cost center while posting?

Regards

Mahmoud  El Nady

[grigoriy_babitskiy · Accepted solution]

Hello Mahmoud,

• Simple dependency:

IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Allocate Additional Account Assignments to Account Assignment References (tr. SM30 -> TRACV_ADDACCDATA)

Cost center depends on

• Company code
• Account Assignment Reference
  

• Advance dependency: Derivation.

IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Additional Account Assignments -> Define Derivation of Additional Account Assignments (tr. TPM_DERIVE_ACCNT)

This is the list of parameters from which Cost Center may depend on:

AA_REF	Account Assignment Reference of Position Management
ACCOUNTING_CODE	Accounting Code
ACCOUNT_GROUP	Securities Account Group
ACC_SYMBOL	Account Symbol for Account Assignment Reference
BP_RLTYP	BP Role
BUSTRANSCAT	Business Transaction Category
BUSTRANSID	Identifier of the Distributor Business Transaction
CHART_OF_ACCOUNTS	Chart of Accounts
COMPANY_CODE	Company Code
CURRENCY_CAT	Currency Category
DEAL_NUMBER	Financial Transaction
DIS_FLOWTYPE	Update Type
DOCUMENT_DATE	Document Date in Document
DOCUMENT_TYPE	Document Type
FLOW_NUMBER	Number of a Distributor Flow
FUND	Fund
GL_ACCOUNT	General Ledger Account
GRANT_NBR	Grant
IGT_STATUS	IGT: Status of an Intragroup transaction
ISSUER	Issuer Identity Key
KONTRAHENT	Business Partner Number
LOANS_CONTRACT	Contract Number
PORTFOLIO	Portfolio
POSITION_ACCOUNT	Futures Account for Listed Options and Futures
POSTING_CAT	Posting Category
POSTING_DATE	Posting Date in the Document
POSTING_KEY	Posting Key
POSTING_PERIOD	Fiscal Period
POSTING_YEAR	Fiscal Year
PRODUCT_GROUP	Product Group
PRODUCT_TYPE	Product Type
RFHAZU	Transaction activity
SECURITY_ACCOUNT	Securities Account
SECURITY_ID	Security ID Number
TRANSACTION_TYPE	Financial Transaction Type
VALUATION_AREA	Valuation Area
VALUATION_CLASS	Valuation Class
VBUND	Company ID of Trading Partner

How to set up derivation - articles.

• More advance dependency (ABAP)
  • IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Enhancements in the Posting Interface (tr. SE18 -> TPM_ACCIF_TRAC, method ACCIT_KOSTL_EXIT)

List of fields from which cost center may depend on you can find in tr. SE11 -> TRACS_EXIT_FLOW

• IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Additional Account Assignments -> Business Add-Ins (BAdIs) -> Derivation of Additional Account Assignments -> BAdI: Derivation of Additional Account Assignments (tr. SE18 -> BADI_TPM_ENHANCE_ACCFIG_TRAC, method DERIVE_ACC_KEYFIG)

[Former Member · Accepted solution]

Hello Grigoriy,

you write that the cost center can be derived in transaction TPM_DERIVE_ACCNT.

How can you achieve this? The cost center is not offered as target field.

Regards,

Stefan

[former_member198450]

Hi,

Please check the assignment in below customization path.

Financial Supply Chain Management--Treasury and Risk Management--Transaction Manager--General Settings---Accounting---Link to Other Accounting Components---Allocate Additional Account Assignments to Account Assignment References

Here, Allocate Additional Account Assignments to Account Assignment References please check the assingment.

Regards,

Jain

[former_member200703]

Hi

Is there other way to assign cost center per loan agreement? i mean that i may post many short term loans that has same account assignment reference "in order to determine the right GL used" but each one may use for different reason?

Thanks in Advance

Regards

Mahmoud El nady

[former_member198450]

Hi,

If you go to T.code TPM32, You will find derivation rule. Now in your case, each loan might be created as a single product type which is assigned to Account assignment reference in TPM32 based on this setting with account determination system determine the GL.

So, You shall assign each Product type to Single account assignment reference.

I hope this clarify you concern.

Regards,

Jain

[grigoriy_babitskiy]

Is "loan agreement" field a Z field? or standard?

If Z:

IMG -> Financial Supply Chain Management -> Treasury and Risk Management ->Transaction Manager -> General Settings -> Accounting -> Link to Other Accounting Components -> Additional Account Assignments -> Define Derivation of Additional Account Assignments (tr. TPM_DERIVE_ACCNT) - Derivaiton type: Enchancement

If Standard:

the same but other Derivation types and list of fields from this answer