Show TOC Entering content frame

Function documentation Delivered Format Trees Locate the document in its SAP Library structure

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

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

Czech Republic

CZ_GEMINI

Domestic bank transfers

RFFOCZ_U

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

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

IE_BOI

Domestic payments (Bank of Ireland)

RFFOGB_T

Luxembourg

LUX_VIR2000

Domestic and foreign payments

RFFOLU_V

Netherlands

BTL91

Foreign bank transfers

RFFONL_A 

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

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

TW_GUI_DETAIL

GUI detail list and summary form

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

Finland

ASLD_FI

EC Sales List for Finland

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 R/3 System can process. Currently, only conversion to MultiCash is supported, and no format trees are delivered.

Leaving content frame