TU - GT - BP 02.11 Manage GL Master Data V2.4

Thai Union Group
Business Blueprint
02.11 Manage GL Master Data
Table of Contents
1 Document History................................................................................................................................4
1.1 Change History.............................................................................................................................4
1.2 Approval Detail............................................................................................................................4
1.3 Other Related Documents...........................................................................................................4
2 Business Process Overview..................................................................................................................5
2.1 High level requirements...............................................................................................................5
3 Business Sub-Process Description........................................................................................................6
3.1 Maintain Account Master............................................................................................................6
Use.......................................................................................................................................................6
Integration.........................................................................................................................................13
Process/Sub process Variation..........................................................................................................13
Process/Sub Process diagram............................................................................................................13
Activity List........................................................................................................................................13
RICEFW..............................................................................................................................................14
Role Summary....................................................................................................................................14
3.2 Maintain Bank Master...............................................................................................................15
Use.....................................................................................................................................................15
Integration.........................................................................................................................................15
Activity List........................................................................................................................................15
RICEFW..............................................................................................................................................15
Role Summary....................................................................................................................................16
3.3 Maintain Exchange Rate............................................................................................................17
Use.....................................................................................................................................................17
Integration.........................................................................................................................................19
Activity List........................................................................................................................................19
RICEFW..............................................................................................................................................20
Last modified: 8/3/2024 9:56 PM Page 2 of 25

File Name: 778087406.docx4
Copyright © 2017 Accenture All rights reserved.778087406.docx
Role Summary....................................................................................................................................20
1 Document History
1.1 Change History

Ver. Date Summary of Changes Author Reviewer
V0.1 31-Oct-2016 Draft Natkamol J.
V1.0 13-Feb-2016 Updated with new Global COA Natkamol J.
V1.1 08-May-2017 Description adjustment Pathom T.
 Account currency
 Sort Key 001
 Post automatically only
V1.2 10-May-2017 Updated from new Chart of Account Natkamol J.
Added new process maintain
exchange rate
V1.3 11-May-2017 Updated purchasing account Battaglia F.
implementation
V1.4 07-Jun-2017 Posting without tax allowed is Pathom T.
recommended to unmark for P&L.
V2.0 12-June-2017 Convert to V2.0 after Governance KY Ng Thamrongwarasart,
review on TUE R1 updates Pakin (Tdai) and KY
Ng
V2.1 29-June-2017 Updated bank master maintenance Tittaya B. KY Ng
roles and responsibilities
V2.2 17-Aug-2017 Updated account group KY Ng
V2.3 30-Jan-2017 Updated Bank key master Tittaya B. KY Ng
maintenance and NBP interface
exchange rate.
V2.4 27-June-2018 Updated post TUE R1 UAT: KY Ng
1) Global CoA maintainence
2)[1)] Alternative CoA
3)[2)] PT Purchasing Account
4)[3)] House bank, bank key and
account ID key data structure
(KDS)
5)[4)] Display exchange rate T-code
EWCT

1.2 Approval Detail
Review # Date Name & Position of Approver Signature
1.3 Other Related Documents

Please insert links/References to related Documents (issues, data entities, etc.).
Related Document Comment

2 Business Process Overview
This scenario defines General Ledger (G/L) master data maintenance for all companies.
2.1 High level requirements
 Define global common chart of accounts is a prerequisite for bringing standardization across all
businesses of the company.
 Country specific chart of account can be created per legal requirement only

3 Business Sub-Process Description
The SAP GL Master Data compose of
3.1 Maintain Account Master
3.2 Maintain Bank Master
3.3 Maintain Exchange Rate
3.1 Maintain Account Master

Use
Global Chart of Account:
All Thai Union company codes will share a common global Chart of Accounts (TUG0) in the new SAP
environment. If a specific company code has a need for a new g/l account, the account must first
exist and/or be added at the chart of accounts level, and then extended to the respective company
code(s).
For control and data integrity purposes, TU G/L account maintenance will be centralized and
designated approvers for account changes will need to be identified within the Gglobal C chart of
Aaccount Tteam eam under (Group Accounting and Controlling (GAC). Local entity will need to first
check whether existing chart of account exist and suitable to be extended to their local company
code. If no suitable G/L account, they can then send e-mail request to GAC providing background
and reasons for the new request.
After approval, the G/L account will be maintained in the SAP system by the centralized Global MDC
team via the Winshuttle application. Local entity SAP Users will only have Display GL account
access.
G/L account registered in Global Operational Chart of Account will consist of eight digits number with
numbering convention as following:
Account Code Structure

Overview of Account Category and Sub Category
For more details on the Global CoA, refer to this share point link which provide the excel design file
as well as the ppt deck describing the key design areas.
Cost Elements:
Cost elements are part of the chart of accounts from CO module view. They are maintained in GL
account master data. There is no separate cost element master data maintenance in SAP S4 HANA.
Maintenance access to G/L account master records will be restricted to avoid unauthorized changes.
The creation of G/L account master records involves two ‘layers’, chart of accounts data and
company specific data
Alternative Chart of Account:

Besides the Global CoA, local entity can also have alternative chart of account which will be mapped
with accounts in the global chart of accounts to represent financial statement in SAP as report for
their local legal requirements. Example below is for ESIP (co. code PT01) local chart of account
which is defined to meet the Portuguese SNC and taxonomy reporting requirements.
Global CoA: TUG0 Alternative CoA: PT01

GL Account Description GL Account Description
11041010 Trade Account Receivable-Third Party 21110010 Clientes - Clientes gerais
Trade Account Receivable-Related Clientes - outras partes
11041020 21160010
Party relacionadas
21039010 GR/IR-Goods and Services 22500020 Fornecedores - Faturas
21039020 GR/IR-In-bound Transportation em receção e conferência
21039030 GR/IR-Adjustment
21039040 GR/IR-Consignment
TUE R1 (Portugal) Specific: The Portuguese chart of Accounts is named SNC. It was defined in
2009 and implemented in 2010. SNC is based in the International Accounting Standard used by the
European Union. Besides providing the financial statement in the SNC format required, the local CoA
for Portugal is also mapped to the legal taxonomy codes in SAP which are required in order to
produce the SAFT audit file (monthly and yearly) in SAP. Note: The SAFT file is mandatory in Portugal since
2008. It is an audit file that needs to follow the standard structure defined by local law. This file should be delivered to the tax
authorities by request or when delivering the information for the ‘Dossier Fiscal’
Purchasing Account:
Req ID 02.11.010-03: for Portugal (country of release 1) classified under balance sheet, France and
Italy (countries of release 2) purchasing account classified under P&L(P&L) need to be added for
statutory reporting. The following is an example of vendor invoice posting as per IFRS and
Portuguese/French/Italian Local GAAP requirements:

TUE R1 (Portugal) Specific: There are 3 main purchase GL accounts to be defined for ESIP (co.
code PT01) and the balances for the GL accounts must be ZERO at month end:
i. Purchase + Purchase Offset  this is configured in standard SAP automatic Purchasing
Account and Offset determination (T-code OBYC)

Dr/Cr SAP GL Account Amount SNC Taxonomy
At Goods Received
Dr. 11081xxx Raw material 100 331* 171
Cr. 21039010 GR/IR clearing -100 225* 47
Dr. 79100010 Purchase account 100 312* 157
Cr. 79100020 Purchase account -100 312* 99 157
offset
At Invoice Receipt
Dr. 21039010 GR/IR clearing 100 225* 47
Dr. 11591010 Deductible VAT 23 2432* 74
Cr. 21021xxx Supplier -123 2211* 37
ii. Purchase Return + Purchase Return Offset  this is handled via FI substitution User Exit
(RICEFW: FI-28) since standard SAP cannot determine different GL accounts in case of
purchase return from MM side.
At Goods Return
Dr. 2103901 GR/IR clearing 100 225* 47

0
Cr. 11081xxx Raw material -100 331* 171
Dr. 7910004 Purchase return 100 317* 99 160

0 offset
Cr. 7910003 Purchase return -100 317* 160

0
At Invoice Receipt for CN
Dr. 21021xxx Supplier 123 2211* 37
Cr. 2103901 GR/IR clearing -100 225* 47

0
Cr. 2199105 Adjustment VAT -23 2434* 76

0

iii. Purchase Discount & Rebate + Purchase Discount & Rebate Offset  This is handled
via manual posting in AP and GL.
At Manual AP Invoice Posting
Dr. 21021xxx Supplier 123 2211* 37
Cr. 79100050 Purchase Rebate -100 318* 163
Cr. 11591010 Deductible VAT -23 2432* 74
Adjust Purchase Rebate to P&L for Cost of Manufacturing - Post to individual RM/PM/ING
material
Dr. 79100060 Purchase Rebate 100 318* 99 163

offset
Cr 51080040 Stock Diff (Material -60 731 519

Price Change)
Cr 51080040 Stock Diff (Material -40 731 519

Price Change)
Revalue inventory which will post the contra to Stock Diff (Material Price Change) - Post to
individual RM/PM/ING material
Dr 51080040 Stock Diff (Material 60 731 519

Price Change)
Dr 51080040 Stock Diff (Material 40 731 519

Price Change)
Cr 11081030 Packing Material 100 333 173
The followings are the important fields for account control at the chart of account area:
 Account group – to control which fields to appear in the G/L master data - company code
specific maintenance screen. TU global chart of account TUG0 will have account groups
below:
Account Description From To Account Group

Group
Fixed assets Fixed assets
AS 12000000 12999999
accounts accounts
General General
BS Balance Sheet 10000000 39999999 Balance Sheet
accounts accounts
Cash and Bank Cash and Bank
CASH 11000000 11999999
accounts accounts
P&L Statement P&L Statement
PL 40000000 69999999
accounts accounts
Recon. Recon.
RECN 11040000 21029999
Accounts Accounts
Secondary Secondary
SECC 80000000 89999999
Costs Costs
Technical/Zero Technical/Zero
TECH 70000000 79999999
Balance Balance
Conversion Conversion
CONV 90000000 99999999
accounts accounts
 Balance sheet or P/L account indicator

 Short text (20 characters) & Long text (50 characters)
o Account Description must be maintained in English Language,
 Account Type – to control nature of account and document creation in system
Account Type Description Usage

X Balance Sheet  Account that is posted from business
Account transactions.
 The balance of a balance sheet account is
carried forward at fiscal year-end.
P Primary cost or  Income statement account that functions as
revenue a cost element for primary costs or revenue.
 Primary costs reflect operating expenses
such as payroll, selling expenses, or
administration costs.
S Secondary Costs  Income statement account that functions as
a cost element for secondary costs.
 Secondary costs result from value flows
within the organization, such as internal
activity cost allocations, overhead
allocations, and settlement transactions.
N Non-operating  Income statement account that records
expense or expenses or gains from activities that are not
income part of the main purpose of the company.
 Special setting for COGS account / WIP
contra account to avoid double booking in
CO-PA (technical setting).
The followings are the important fields at the company code specific area:
 Account control
o Account currency – for foreign currency assets/liabilities, e.g. USD bank account,
enter the respective foreign currency. Other accounts enter the company
currency (e.g. THB). For example, company code TH01, all the GL account
currency will be set the same as company currency (THB) including GL account
for bank accounts that pay cross currency (e.g. bank THB can pay invoice in
USD, EUR, etc.).
o Only balances in local currency – balances are updated only in local currency
when users post items to this account. This field only can be tick if G/L Account is
not reconciliation Account
o Note: As per standard SAP recommendation Tthis indicator must be ticked for
GR/IR and Consignment (MM) accounts.
G/L Account Description

2103901021035030 GR/IR-Goods and Services
21039020 GR/IR-In-bound Transportation
21039030 GR/IR-Adjustment
21039040 GR/IR-Consignment
o Tax category – to determine whether a tax code is required later when entering a
line item for this account.
o For Thai Union Group, the following Tax Category will choose for some group
G/L Account:
Tax Category Description GL Account Grouping

- Only input tax allowed Cost Account
+ Only output tax allowed Revenue
* All tax types allowed AP/ AR GL Account
o Posting without tax allowed – allowing taxable and non-taxable postings to be

entered to an account at the same time. TU GT design to untick this field for most
P&L GL accounts (e.g. revenue and SG&A GL account) to avoid missing tax
code input during transaction posting. In case there are non-VAT-relevant
transactions for these GL accounts, there will be dummy tax codes which User
can use to input, instead of leaving a blank value for the tax code field.
o Reconciliation account – an account that links sub-ledger to the general ledger.
Recon Account Type Description

A Asset Account
D Customer Account
K Vendor Account
o Alternative account no – the local GL account number to be mapped (e.g. for

PT01 SNC local CoA)
 Account management
o Line item display – to display line item detail in the account after posting. All G/L
Account master data should tick this field.
o Sort key – to determine how line items are automatically sorted when user
displays the line items in this account.
Sort Key Description GL Account Grouping

001 Posting Date All Accounts
002 Document Number Bank Account
014 Purchase Order Number Cost account, GR/IR
 Control of document creation

o Field status group – to control which fields are required, optional or suppressed
when user enters a line item of a document in this account.
o Post automatically only – for certain GL account posting in SAP, the system
automatically determines the GL account line items. For example, COGS,
GOGM, material consumption related are all posted automatically by the system
based on automatic GL account determination setting in MM and SD. These GL
accounts need to be set as “Post automatically only” to prevent any manual
postings.
o Note: Example control: Inventory balance accounts must have this indicator
ticked to prevent manual posting to this G/L Account so that G/L balance in
Finance and total inventory amounts in Logistic will always be reconciled.
G/L Account Description

11081010 Raw Material
11081020 Ingredient
11081030 Packing Material
11083020 Semi-Finished Good
11083030 FG-Manufacture Goods
11083040 Trading Goods
 Bank/financial details
o Planning level – used to control display in Cash Management. TU GT only uses
this for information purpose. Example below:
 Main Bank GL Accounts = F0 (Posting to bank account)
 Incoming Bank GL Accounts = Z3 (Incoming checks) - for all types of
incoming posting (cheque, bank transfer, direct debit)
 Outgoing Bank GL Accounts = Z1 (Outgoing checks) - for all types of
outgoing posting (cheque, bank transfer, etc)
 Other Bank GL Accounts = Z4 (Other interim postings)
o House bank – enter the house bank code for banks related account
o Account ID – enter bank account ID for bank related account
The followings are the important fields at the Controlling-area-specific area:
 Account setting in controlling area

o Cost Element Category – The cost element category determines which cost
elements can be used for which business transactions
CE Cat. Description
01 Primary costs/cost-reducing This category of cost element can
revenues be debited with all primary postings,

CE Cat. Description
for example, in Financial
Accounting (FI) or Materials
Management (MM).
11 Revenues The cost element category is used
to post revenues.
12 Sales Deduction Cost elements of this category are
used to post sales deductions.
Sales deductions (reductions,

adjustments, corrections) are
adjustment or deduction postings of
revenues, such as discounts and
rebates.
Certain revenues, such as freight

charged separately in the invoice,
surcharges for small quantities or
special orders, are not classified as
sales deductions.
22 External Settlement Cost elements of this category are
used to settle order, project, or cost
object costs to objects outside of
Controlling.
CO external objects can be, for

example, assets (AM), materials
(MM) or G/L accounts (FI).
CE Cat. Description
21 Internal settlements This cost element category is used
to settle (further allocate) order or
project costs to Controlling (CO)
internal objects.
CO-internal objects are, for

example, orders, profitability
segments, cost centers and
projects.
31 Order/project results This cost element category is used
analysis to save the order/project results
analysis (WIP) data on the relevant
order/project.
42 Assessment This cost element category is used
to allocate costs using the
assessment method.
43 Internal activity allocation This cost element category is used
during internal activity allocation.
(Template Allocation)
o Account assignment objects will be assigned (statistical): This checkbox

indicator is the same setting at cost element category 90, to control the costs of
an order or project budget during the acquisition of fixed assets that can be
directly capitalized. This indicator can be set on reconciliation accounts for fixed
asset or material only
In certain countries, there may be a need to maintain a statutory (or country) chart of accounts. This
has been expressed as a requirement for Thai Union entities in France. Alternate (Country) Chart of
Accounts will be created for each of these countries, and the specific company codes will then be
linked to their respective alternate chart of accounts.
Integration
<None>
Process/Sub process Variation

<None>
Process/Sub Process diagram

Refer to MDC
Activity List
Activity definition document if applicable for the project & also has references in the process/sub
process diagram
Step Activity Description Transaction Code, Roles involved Regulatory

if relevant /Other
Controls
010 Maintain GL Account FS00 GL account master

maintenance assigned to
MDC
020 Maintain Cost Element FS00 GL account master

maintenance assigned to
MDC
030 Display G/L Account FS00 GL accountant (display

only)

RICEFW
R-Report; I-Interface; C-Conversion; E-Enhancement; F-Form; W-Workflow
RICEFW Standard/ Transaction

No. Report Description Type Customize Code, if Comments
d relevant
For ESIP (PT01) to

FI Substitution Exit for substitute the
1 PT Purchasing Return E C N/A purchasing return GL
GL account during goods
return posting from MM
Role Summary
The content in this section will serve as input for the authorization and training.
Role SAP Transaction Description
GL account master maintenance FS00 GL account maintenance

(centrally)
GL display FS00 GL account maintenance
(centrally) – Display only

3.2 Maintain Bank Master
Use
Bank master includes bank address data and control data such as the SWIFT code (Society for
Worldwide Interbank Financial Telecommunication) and the bank group. In SAP, bank masters also
includesinclude house banks and the banks of all business partners (customer and vendor).
Below are the bank masters in SAP:
1) House Bank: represents the bank account of TU companies. The setup of house bank is a
prerequisite to be able to run the payment program in AP (note: additional configurations are
required to setup the house bank to be used in the AP automatic payment program). House Bank
is defined by company code and further represented by different bank accounts called account ID
(e.g. savings, current, etc.). A G/L account i.e. bank account is assigned to the account ID in the
house bank.
TU Global Template key data structure for house bank:
 House bank represent bank and bank branch that company open account with, using 5
digits by bank short name and bank branch short name define internally by Bank
Master Maintenance Person.
TU Global Template key data structure for account ID:
 Coding by bank branch short name, then account type (current, saving, fixed deposit and
foreign currency deposit), and then running number
2) Bank Key: represents the unique identification of the bank. It usually stands for the bank branch
(of each bank). Bank key will be used for the creation of House Bank and account ID and also
use for other purpose in banking such as payment transaction, bank transfer correspondence,
etc. The bank key covers both TU banks and TU business partner (customer and vendor) banks.
TU Global Template key data structure for bank key:

• Adopt SWIFT code as bank key. Exceptional:
• Thailand use bank coding from Bank of Thailand (National System)
• For UK and IE, adopt 6 digits SORT CODE of the United Kingdom as bank key.
• In case that it is local bank which no SWIFT code, Bank Master Maintenance Person will
define coding for each bank
• Coding Structure is separated in 2 groups
Example bank list:
Compan House Account GL

Bank Key Bank Account Number Curr. Account ID Description
y Code Bank ID Account
Societe Generale/London
GB01 236391 SOG01 CUR01 19003606 GBP 11600010
19003606 (GBP)
Societe Generale/London
GB01 236391 SOG01 CUR02 19003800 EUR 11900010
19003800 (EUR)

ALLIED IRISH BANKS/IFSC
IE01 933384 AIB01 CUR01 19726023 EUR 11600030
19726023 (EUR)
Societe Generale Amsterdam
NL01 SOGENL2A SOG01 CUR01 NL84SOGE0270204962 EUR 11600020
NL84SOGE0270204962(EUR)
Societe Generale Amsterdam
NL01 SOGENL2A SOG01 CUR02 NL70SOGE0270205020 USD 11900050
NL70SOGE0270205020(USD)
BNP Paribas
PT01 BNPAPTPL01 BNP01 CUR01 0010901373000182 EUR 11600040
0010901373000182 (EUR)
BPI Bank 33647274000001
PT01 BBPIPTPL BPI01 CUR01 33647274000001 EUR 11600050
(EUR)
Societe Generale
3000304250000204239468
PT01 SOGEFRPP SOG01 CUR01 EUR 30003042500002042394680 11600060
0
(EUR)
TU House bank and TU bank key will be maintained by either one of these Users, depending on the
entity roles & organization setup:
 Central Treasury User e.g. France, Bangkok
 Treasury User in each entity e.g. JW UK, JW IE, ESIP)
 AP Accountant, GL Accounting Manager)
For business partner (customer/vendor) bank keys, MDC team will maintain it in the business partner
master data under payment transaction tab using Winshuttle application.
Integration
<None>

<None>

<None>
Activity List
process diagram
Step Activity Description Transaction Code, if relevant Roles Regulatory

involved /Other
Controls

010 Maintain house bank, bank Fiori Apps: Manage Bank Bank Master
account ID and bank key Accounts – to maintain house Maintenance
bank and bank accounts (account (Treasury
ID) within house bank. User)
For TU bank key, User can submit
request via Winshuttle application
(which triggers workflow approval)
to maintain TU bank key in SAP
system.
020 Maintain House Bank FI12_HBANK Bank Master
(alternative T-code) Maintenance
(Treasury
User)
RICEFW

d relevant
Role Summary
Bank Master Maintenance Fiori apps – Manage Banks and Maintain Banks and Bank
Manage Bank Accounts Accounts
Bank Master Maintenance Winshuttle – Bank Key Master Maintain Bank Key Master
Bank Master Maintenance FI03 Display Bank Key
Bank Master Maintenance FI12_HBANK Maintain House Bank

3.3 Maintain Exchange Rate
Use
Exchange rates are used to translate an amount into another currency. Exchange rates are defined at
client level and therefore apply for all company codes. Exchange rates are defined in the system for
the following purposes:
 Posting and Clearing: To translate foreign currency amounts when posting or clearing or to
check an exchange rate entered manually.
 Exchange Rate Differences: To determine gains or losses from exchange rate differences.
 Foreign Currency Valuation: To valuate open items in foreign currency and foreign currency
balance sheet accounts as part of the closing operations.
Different exchange rates can be maintained and are distinguished by an exchange rate type. These
different exchange rates can be used for various purposes such as valuation, translation, conversion,
planning, etc.
The following exchange rate types be maintained in the system:
Exchange Description Usage Maintenance

Rate Type Interval
M Standard translation at At daily; Any foreign currency invoice Daily
bank average rate posting or clearing (realized exchange
rate difference)
G Standard translation at At daily; Thailand requirement: Any Daily
bank buying rate foreign currency invoice posting or
clearing of Purchase Process
B Standard translation at At daily; Thailand requirement: Any Daily
bank selling rate foreign currency invoice posting or
clearing of Sales Process
ZMX End of Month Exchange At month end; FX revaluation of the open Monthly
Rate at average rate items in foreign currency and post
unrealized exchange rate difference.
ZGX End of Month Exchange At month end; FX revaluation of the open Monthly
Rate at buying rate items in foreign currency and post
ZBX End of Month Exchange At month end; FX revaluation of the open Monthly
Rate at selling rate items in foreign currency and post
P Standard translation for Annual rate for planning/budgeting Yearly
Planning Rate
As Thai Union Thailand operates under Thailand’s tax regulation, and company must follow tax
requirement from Thailand Revenue Department for tax transactions (Output Tax / Input Tax) as
describes below
 When company send a foreign customer invoice, an invoice denominated not in baht.
Thailand Revenue Department requires company to translate the foreign currency amounts
using the buying rate (exchange rate = G) that the Bank of Thailand published.

 When company receive a foreign vendor invoice, an invoice denominated not in baht.
Thailand Revenue Department requires company to translate the foreign currency amounts
using the selling rate (exchange rate = B) that the Bank of Thailand published.
SAP transactions are tied to exchange rate type M. Therefore, all the foreign currency translation for
the transactional entry will be calculated based on the exchange rate type M. However, if the user
wants to enter a different exchange rate than the system-calculated value, then the system-calculated
value can be overwritten at the transactional level.
SAP Global Template was designed to support all country specific requirements of currency
translation. To minimize process of user to manual entering exchange rate when posting, the default
exchange rate type for specific SAP accounting “Document Type” has been set in the system as
below. (refer to process variation section for more detail.)
The following SAP “document type” with specific exchange rate type in the system:
Document Description Exchange Rate

Type Type
Dx Manual FI-AR Invoice G
Dx Manual FI-AR Debit Note G
Dx Manual FI-AR Credit Note G
…
Kx Manual FI-AP Invoice B
Kx Manual FI-AP Invoice B
… Manual FI-AP Invoice B
RE Logistic Invoice Verification B
WE Goods Receipt B
Exchange rates are maintained with the validity date to specify the date from which the exchange rate
should apply. The system then refers to either the posting date or the translation date and uses the
current exchange rate from the system. Exchange rates can be maintained in either direct or indirect
quotation to specify exchange rates.
Exchange rate will be updated by global team with reference to exchange rate source from Bank of
Thailand (BOT). In case of any pair currencies not available from BOT, Thai Union will refer to
Reuters. The exchange rate upload program will update the exchange rate for exchange rate type M,
B, G and ZBX, ZMX, ZGX (M/B/G will be uploaded daily where as ZMX/ZBX/ZGX will be uploaded
monthly).
Example exchange rate maintenance in SAP
Rate Valid Date From Rate To Rate Source

Type (In direct) (Direct)
M 01.10.2016 USD 1 THB 34.6843 Bank of Thailand
M 01.10.2016 EUR 1 THB 41.3530 Bank of Thailand
B 01.10.2016 USD 1 THB 34.8528 Bank of Thailand
B 01.10.2016 EUR 1 THB 38.2422 Bank of Thailand
G 01.10.2016 USD 1 THB 34.5158 Bank of Thailand
G 01.10.2016 EUR 1 THB 44.4639 Bank of Thailand
M 01.10.2016 USD 1.1922 EUR 1 Bank of Thailand
M 01.10.2016 THB 41.3530 EUR 1 Bank of Thailand
B 01.10.2016 USD 1.1922 EUR 1 Bank of Thailand
B 01.10.2016 THB 41.3530 EUR 1 Bank of Thailand
G 01.10.2016 USD 1.1922 EUR 1 Bank of Thailand
G 01.10.2016 THB 41.3530 EUR 1 Bank of Thailand
Remarks: Exchange rate type B and G must be maintained in the system for all “To Currency”, even
though some currency e.g. EUR does not require to use buying/selling rate then enter the same rate
as average rate.
Integration
<None>

 Thailand Localization Requirement
a. For SD Billing, exchange rate type G (Standard Translation for buying rate) will be maintained
with the exchange rate provided by the Bank of Thailand. Follow SAP localization solution for
Thailand with SD implementation for “Maintain the copying control for creating billing documents”
a. Copying Requirements: 364
b. Data VBRK/VBRP: 360
c. Pricing Exchange Rate Type: C (Exchange Rate Determination according to Billing
Date)
When system post billing to accounting document, then a tax invoice from the billing document,
the tax invoice displays the baht prices correctly
b. For all transactions, other than SD Billing, exchange rate type M will be used. Except transactions
posting with specific document types which require to use buying/selling exchange rate instead of
average rate (exchange rate type M).
c. For Poland Localization Requirement, exchange rate has to be maintained based on NBP rate.

Refer to MDC
Activity List
process diagram
Step Activity Description Transaction Code, Roles Regulatory

if relevant involved /Other
Controls
1 Interface from BOT and NBP to maintain Custom Interface N/A. Auto
currency exchange rate via interface
2 Maintain currency exchange rate OB08 N/A. Auto
via interface
3 Display currency exchange rate OB08 / Accounting
S_BCE_68000174 / Manager
EWCT

RICEFW

d relevant
1 Interface to maintain Interface Customize ZTHFIGL004 - Interface program to
currency exchange rate d Convert XML to update exchange rate
text file based on BOT rate
exchange rate
from BOT
ZTHFIGL005 -
Update
Exchange rate
(BOT)
Role Summary
Accounting Manager OB08 / S_BCE_68000174 / Display Currency Exchange

EWCT Rate


TU - GT - BP 02.11 Manage GL Master Data V2.4

Uploaded by

Copyright:

Available Formats

TU - GT - BP 02.11 Manage GL Master Data V2.4

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

TU - GT - BP 02.11 Manage GL Master Data V2.4

Uploaded by

Copyright:

Available Formats

Thai Union Group

Last modified: 8/3/2024 9:56 PM Page 2 of 25

1.1 Change History

Last modified: 8/3/2024 9:56 PM Page 3 of 25

1.3 Other Related Documents

Related Document Comment

Last modified: 8/3/2024 9:56 PM Page 4 of 25

2.1 High level requirements

Last modified: 8/3/2024 9:56 PM Page 5 of 25

The SAP GL Master Data compose of

3.1 Maintain Account Master

3.2 Maintain Bank Master

3.3 Maintain Exchange Rate

3.1 Maintain Account Master

Global Chart of Account:

Account Code Structure

Last modified: 8/3/2024 9:56 PM Page 6 of 25

Alternative Chart of Account:

Last modified: 8/3/2024 9:56 PM Page 7 of 25

Global CoA: TUG0 Alternative CoA: PT01

Last modified: 8/3/2024 9:56 PM Page 8 of 25

Last modified: 8/3/2024 9:56 PM Page 9 of 25

Dr/Cr SAP GL Account Amount SNC Taxonomy

Dr. 2103901 GR/IR clearing 100 225* 47

Cr. 11081xxx Raw material -100 331* 171

Dr. 7910004 Purchase return 100 317* 99 160

Cr. 7910003 Purchase return -100 317* 160

At Invoice Receipt for CN

Dr. 21021xxx Supplier 123 2211* 37

Cr. 2103901 GR/IR clearing -100 225* 47

Cr. 2199105 Adjustment VAT -23 2434* 76

Last modified: 8/3/2024 9:56 PM Page 10 of 25

Dr/Cr SAP GL Account Amount SNC Taxonomy

At Manual AP Invoice Posting

Dr. 21021xxx Supplier 123 2211* 37

Cr. 79100050 Purchase Rebate -100 318* 163

Cr. 11591010 Deductible VAT -23 2432* 74

Dr. 79100060 Purchase Rebate 100 318* 99 163

Cr 51080040 Stock Diff (Material -60 731 519

Cr 51080040 Stock Diff (Material -40 731 519

Dr 51080040 Stock Diff (Material 60 731 519

Dr 51080040 Stock Diff (Material 40 731 519

Cr 11081030 Packing Material 100 333 173

Account Description From To Account Group

 Balance sheet or P/L account indicator

Account Type Description Usage

G/L Account Description

Tax Category Description GL Account Grouping

o Posting without tax allowed – allowing taxable and non-taxable postings to be

o Reconciliation account – an account that links sub-ledger to the general ledger.

Recon Account Type Description

o Alternative account no – the local GL account number to be mapped (e.g. for

Sort Key Description GL Account Grouping

 Control of document creation

G/L Account Description

The followings are the important fields at the Controlling-area-specific area:

 Account setting in controlling area

Last modified: 8/3/2024 9:56 PM Page 14 of 25

Sales deductions (reductions,