cancel
Showing results for 
Search instead for 
Did you mean: 

Can Any one Please give me template for OACT i.e for Chart of Account.

Former Member
0 Kudos

Dear Experts,

Can any one please give me DTW Template for Chart of account?

I am using SAP 8.81 PL 08.

Please make sure that All fields names in row1 and row2 should be the same.

Thank you,

Santosh

Accepted Solutions (0)

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please check with this folder for DTW template:

C:\Program Files (x86)\SAP\Data Transfer Workbench\Templates\Templates\Financials\Chart of Accounts

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Dear Sir,

Yes i took template from this path only.

But in this FatherAccountKey Column name is different in row1 and row2.

So while importing is this will give me error?

I have attached snap shot below please check it once.

Thank you,

Santosh

kothandaraman_nagarajan
Active Contributor
Former Member
0 Kudos

Dear sir,

Thanks for giving above link.

But i have saved my file as tab delimated and for  number appear as  E+14 i have change cell format to Numbers with no decimals.

Question,

1> If their is difference in template,in row1 and row2 will it give me error while importing data?

Thank you,

Santosh.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please post your template with values to check.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi Sir,

Thank you response,

I have copied my template here please check it once.

if you want any more information please let me know.

CodeNameCashAccountBudgetAccountActiveAccoutNOtFatherAccountKeyRateConversionTaxLiableAccountTaxExemptAccountAccountTypat_ExpensesLoadingTypeAcctCurrencyProtectedReconciledAccountLiableForAdvancesForeignNameRevaluationCoordinatedLockManualTransactionFormatCodeAllowChangeVatGroupCategoryTransactionCodeLoadingFactorCode5LoadingFactorCode2LoadingFactorCode3LoadingFactorCode4PlanningLevel
AcctCodeAcctNameFinanseBudgetPostableFatherNumRateTransTaxIncomeExmIncomeActTypat_ExpensesOverTypeActCurrProtectedRealAcctAdvanceFrgnNameRevalMatchLocManTranFormatCodeVatChangeCategoryTransCodeOverCode5OverCode2OverCode3OverCode4PlngLevel
100000Called Up Capital Not PaidtNOtNOtYES90004tYEStYEStNOat_OthertNOGBPtNOtNOtNO tNOtNO100000tYES
100001Not Called UptNOtNOtNO90002tYEStNOtNO tNO tNOtNOtNO tNOtNO100001tYES
100002Not Called UptNOtNOtNO100001tYEStNOtNO tNO tNOtNOtNO tNOtNO100002tYES
100010Uncalled Share CapitaltNOtNOtYES100002tYEStNOtNOat_OthertNO tNOtNOtNO tNOtNO100010tYES
100011Fixed AssetstNOtNOtNO100000000000000tYEStNOtNO tNO tNOtNOtNO tNOtNO100011tYES
100012Intangible AssetstNOtNOtNO100011tYEStNOtNO tNO tNOtNOtNO tNOtNO100012tYES
100013Formation ExpensestNOtNOtNO100012tYEStNOtNO tNO tNOtNOtNO tNOtNO100013tYES
101000Capitalised Formation ExpensestNOtNOtYES100013tYEStYEStNOat_OthertNOGBPtNOtNOtNO tNOtNO101000tYES
101010Capitalised Business Expansion CoststNOtNOtYES100013tYEStNOtNOat_OthertNO tNOtNOtNO tNOtNO101010tYES
101500Accumulated Deprec. - Capitalised Formation Exp.tNOtNOtYES100013tYEStNOtNOat_OthertNO tNOtNOtNO tNOtNO101500tYES

Santosh.Thank you,