Delivered Format Trees

Use

SAP delivers a number of predefined format trees that can be used by applications listed below, for the specified formats. The format trees for outgoing files can be used to generate DME files without any further configuration in DMEE. In addition, you can use the format trees as templates to create new trees to cover any regional or bank-specific formats not supported by SAP.

Two sample formats are available that highlight the features you can use when you create a format tree. They are both called SAP_EXAMPLE, and are delivered for tree types PAYM and MCSH.

Integration

Outgoing DME files

The following applications in Financial Accounting (FI) use the format trees to generate a DME file to be sent , for instance, to your bank.

Payment Program (Tree Type PAYM) The following PAYM format trees (used in conjunction with the Payment Medium Workbench format) cover most of the standard formats previously supported by SAP as individual file generation programs, listed below as the corresponding classical payment medium program:

Country	Format Tree	Description	Corresponding Classical Payment Medium Program
Australia	AU_BECS	Domestic bank transfers/debit memos	RFFOAU_T
Australia	AU_BECS_B	Domestic bank transfers/debit memos with balancing record	RFFOAU_T
Austria	V3	Domestic bank transfers	RFFOAT_P
Belgium	BE_BEPDTA	Foreign bank transfers	RFFOBE_E
	BE_DOM80	Debit memos	RFFOBE_D
	BE_PIBDTA	Domestic payments	RFFOBE_I
Brazil	FEBRABAN_P	Domestic bank transfers	RFFOBR_U
Canada	005	Human Resources and payments to/from customers/vendors	New format
CzechRepublic	CZ_GEMINI	Domestic bank transfers	RFFOCZ_U
CzechRepublic	CZ_GEMINI_F	Foreign bank transfers	RFFOCZ_U
Denmark	DK_PAYMUL_DOMESTIC	Domestic payments (EDIFACT format)	New format
Finland	LM03	Domestic payments	New format (replaces format LM02, program RFFOFI_L)
	FI_LUM2	Foreign payments	RFFOFI_U
	TS	Human Resources	New format
	FI_A_AUTOGIRO	Direct debits/debit memos	RFFOFI_A
France	FR_ETEBAC_VRT-ETR	Foreign bank transfers	RFFOF__T
France	FR_ETEBAC_VRT-DOM	Domestic bank transfers	RFFOF__V
Hong Kong	AUTOPLAN1	Domestic bank transfers/debit memos	RFFOHK_A
Hungary	HU_GIRO	Domestic bank transfers	New format
Ireland	IE_AIB	Domestic payments (Allied Irish Banks)	RFFOGB_T
Ireland	IE_BOI	Domestic payments (Bank ofIreland)	RFFOGB_T
Luxembourg	LUX_VIR2000	Domestic and foreign payments	RFFOLU_V
Netherlands	BTL91	Foreign bank transfers	RFFONL_A
Netherlands	CLIEOP03	Domestic bank transfers/debit memos	RFFONL_I
New Zealand	MTS	Domestic bank transfers/debit memos	RFFONZ_T
Norway	NO_PAYMUL	Outgoing domestic payments and foreign payment orders	New format
Portugal	PS2	Bank transfers	RFFOM100
Slovakia	CZ_GEMINI	Domestic bank transfers	RFFOCZ_U
Slovakia	CZ_GEMINI_F	Foreign bank transfers	RFFOCZ_U
South Africa	ACB_ZA	Domestic bank transfers	RFFOZA_A
Sweden	SE_A_AUTOGIRO	Direct debits/debit memos	RFFOSE_A
	SE_BANKGIROT	Domestic payments	RFFOSE_B
	SE_POSTGIROT	Domestic payments with Postgirot Bank	RFFOSE_P
	SE_UTLI_SISU	UTLI/SISU via BGC/foreign bank transfers	RFFOSE_H
Switzerland	CH_DD	Direct debits/debit memos (Postfinance)	New format
	CH_DTA	POR: domestic/foreign payments (bank)	RFFOCH_U
	CH_EZAG	POR Domestic/foreign/ payments (Postfinance)	New format
	CH_LSV	Direct debits/debit memos (bank)	RFFOCH_U
United Kingdom	GB_BACS	Domestic payments	RFFOGB_T

Advance Return for Tax on Sales/Purchases (Tree Type UMS1)

Country	Format Tree	Description
Taiwan	TW_GUI_403	Government Unified Invoice (GUI) 401/403
Taiwan	TW_GUI_DETAIL	GUI detail list and summary form

Advance Return for Tax on Sales/Purchases (Tree Type UMS3)

Country	Format Tree	Description
Austria	AUSTRIA_U30_XML	XML Tax Report forAustria

Withholding Tax Reporting (Tree Type WTRE)

Country	Format Tree	Description
France	IDWTFILE_FR_DAS2	Withholding tax Déclaration honoraires
South Korea	KR_BUSINESSINCOME	Withholding tax on business income
United Kingdom	IDWTFILE_UK_CIS23E	CIS23E: Construction Gross Payment Voucher
	IDWTFILE_UK_CIS25E	CIS25E: Tax Payment Voucher
	IDWTFILE_UK_CIS36E	CIS36E: End of Year Return
	IDWTFILE_UK_S16TMA	List of external service providers that you have paid over GBP 1,000 to over the course of the fiscal year
United States	IDWTFILE_US_1042	1042S reporting
	IDWTFILE_US_1099	1099 reporting
	IDWTFILE_US_1099G	1099-G reporting
	IDWTFILE_US_1099INT	1099-INT reporting

EC Sales List (Tree Type ASLD)

Country	Format Tree	Description
Austria	AUSTRIA_ZM_XML	EC Sales List forAustria
Finland	ASLD_FI	EC Sales List forFinland

1099-C Cancellation of Debt (Tree Type DEBT)

Country	Format Tree	Description
United States	IDUS99C_1099C	1099-C reporting

Incoming DME Files

The DMEE also supports the conversion of incoming DME files (in external, country-specific formats) to a standard format that the system can process. Currently, only conversion to MultiCash is supported, and no format trees are delivered.