FI Localization for Slovenia
S AP R / 3 R e l e a s e 6 . 0 Version: October 2014
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 1 / 175
Copyright © Copyright 2002 SAP AG. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Microsoft®, WINDOWS®, NT®, EXCEL®, Word®, PowerPoint® and SQL Server® are registered trademarks of Microsoft Corporation. IBM®, DB2®, OS/2®, DB2/6000®, Parallel Sysplex®, MVS/ESA®, RS/6000®, AIX®, S/390®, AS/400®, OS/390®, and OS/400® are registered trademarks of IBM Corporation. ORACLE® is a registered trademark of ORACLE Corporation. INFORMIX®-OnLine for SAP and Informix ® Dynamic Server ware Incorporated.
TM
are registered trademarks of Informix Soft-
UNIX®, X/Open®, OSF/1®, and Motif® are registered trademarks of the Open Group. HTML, DHTML, XML, XHTML are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology. JAVA® is a registered trademark of Sun Microsystems, Inc. JAVASCRIPT® is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape. SAP, SAP Logo, R/2, RIVA, R/3, ABAP, SAP ArchiveLink, SAP Business Workflow, WebFlow, SAP EarlyWatch, BAPI, SAPPHIRE, Management Cockpit, mySAP.com Logo and mySAP.com are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other products mentioned are trademarks or registered trademarks of their respective companies.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 2 / 175
Icons Icon
Meaning Caution Example Note Recommendation Syntax Tip
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 3 / 175
TABLE OF CONTENTS
1.
INSTALLATION................................................................................................................................... 9 1.1
2.
CUSTOMIZING INSTALLATION - BCSETS ................................................................................................ 9
GENERAL SETTINGS FOR SLOVENIA ......................................................................................... 11 2.1 COUNTRY SETTINGS ........................................................................................................................... 11 2.2 COMPANY CODE SETTINGS ................................................................................................................. 12 2.2.1 Edit Company Code Data......................................................................................................... 12 2.2.2 Enter Global Parameters.......................................................................................................... 12 2.3 CALENDAR SETTINGS ......................................................................................................................... 13 2.4 VENDOR/CUSTOMER MASTER DATA .................................................................................................... 15
3.
TAX ON SALES AND PURCHASES (DAVEK NA DODANO VREDNOST).................................. 16 3.1 IMG SETTINGS INCLUDED IN SI LOCALIZATION ................................................................................... 16 3.1.1 Calculation Procedure ............................................................................................................. 16 3.1.2 Assign Country to Calculation Procedure ................................................................................. 18 3.1.3 Define Tax codes for Sales and Purchases ................................................................................ 18 3.1.4 Group Tax Base Balances ........................................................................................................ 27 3.1.5 Group Tax Balances................................................................................................................. 28 3.1.6 IMG settings for transaction OBCG, OBCH and rules for DMEE outpuf files ........................... 29 3.1.7 Validations and Substitutions ................................................................................................... 37 3.1.7.1 Validations – customizing and program changes ..................................................................... 37 3.1.7.1.1 Validations SIVFIH and SIVVDC .......................................................................................... 37 3.1.7.1.2 Validation SIKIDNO (Validation of payment refer.->KIDNO) .............................................. 48 3.1.7.2 Substitutions – customizing and program changes ................................................................. 49
3.2 IMG SETTINGS TO BE DONE BY COMPANY ........................................................................................... 55 3.2.1 Company code settings ............................................................................................................. 55 3.2.2 Assign Company Code to Document Date for Tax Determination.............................................. 56 3.2.3 Define Tax Accounts ................................................................................................................ 56 3.2.4 Assign Tax Codes for Non-Taxable Transactions ...................................................................... 56 3.2.5 Down Payment Received .......................................................................................................... 57 3.2.6 Define Tax on Sales/Purchases Groups .................................................................................... 57 3.2.7 Assign Company Codes to Tax on Sales/Purchases Groups....................................................... 58 3.2.8 Define Accounts for Automatic Tax Payable Transfer Posting ................................................... 58 3.2.9 Plants Abroad .......................................................................................................................... 59 3.3 VENDOR/CUSTOMER MASTER DATA .................................................................................................... 59 3.4 POSTING VAT RELEVANT DOCUMENTS ............................................................................................... 60 3.4.1 Open/close tax period............................................................................................................... 60 3.4.2 Down payments........................................................................................................................ 60 3.4.3 Acquisition Tax Accruals on the 15.-th in the month.................................................................. 62 3.4.4 Posting EUL documents ........................................................................................................... 62 3.4.5 Reverse charge postings ........................................................................................................... 62 3.4.6 Posting document of Triangular deal ........................................................................................ 63 3.5 VAT INFORMATION SYSTEM ............................................................................................................... 65 3.5.1 Tax Reports.............................................................................................................................. 65 3.5.2 DDV-O form ............................................................................................................................ 81 3.5.3 GL line item export .................................................................................................................. 84 3.5.4 EC Sales list............................................................................................................................. 88 3.5.5 SI Cash Sales Report / Invoices paid by cash ...........................................................................100 3.5.5.1 Table /CCEE/SIFI_CACC, transaction /CCEE/SIFI_CS_ACC_AS: Account assignment to payment type.........................................................................................................................................100 3.5.5.2 Table /CCEE/SIFI_CDTYP, transaction /CCEE/SIFI_CS_DT_AS: Document type assignment 101 3.5.5.3 Table /CCEE/SIFI_CMWS, transaction /CCEE/SIFI_CS_TC_AS: Assign Tax Code to Tax Rate 101 3.5.5.4 Program /CCEE/SIFI_CASH_SALES_REPORT, transaction /CCEE/SIFI_CS_REP ......101 SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 4 / 175
3.5.6 4.
Info about VAT and VAT base amount on issued invoice in case of Slovenian reverse charge ...103
EXTENDED WITHHOLDING TAX (DAV NI ODTEGLJAJ) ......................................................104 4.1 IMG SETTINGS INCLUDED IN SI LOCALIZATION ..................................................................................104 4.1.1 Define reason for exemption:...................................................................................................104 4.1.2 Define recipient types ..............................................................................................................105 4.1.3 Define income types ................................................................................................................105 4.1.4 Define withholding tax type for payment posting ......................................................................107 4.1.5 Define withholding tax codes...................................................................................................108 4.1.6 Generic Withholding Tax Reporting ........................................................................................110 4.2 IMG SETTINGS TO BE DONE BY COMPANY ..........................................................................................111 4.2.1 Assign withholding tax type to company codes .........................................................................111 4.2.2 Activate extended withholding tax in your company code .........................................................111 4.2.3 Define G/L accounts for posting ..............................................................................................111 4.2.4 Define Servant code of Tax authorities ....................................................................................112 4.3 VENDOR MASTER DATA .....................................................................................................................112 4.4 DOCUMENT ENTRY............................................................................................................................114 4.5 CLEARING WITH EXTENDED WITHHOLDING TAX .................................................................................114 4.5.1 Manual posting with clearing ..................................................................................................114 4.5.2 Automatic Clearing (Payment Program)..................................................................................114 4.6 AN EXAMPLES OF EXTENDED WITHHOLDING TAX DOCUMENTS ...........................................................115 4.6.1 Received invoice from a vendor who is liable to withholding tax. The invoice is not relevant for withholding tax calculation. ..................................................................................................................115 4.6.2 Received invoice from a vendor who is liable to withholding tax. The invoice include relevant and non-relevant withholding tax calculation line items. ..............................................................................116 4.7 REPORT ODO-1 (SAP NOTE 828692 AND 954443) .............................................................................118
5.
OUTGOING PAYMENTS .................................................................................................................120 5.1 IMG SETTINGS INCLUDED IN SI LOCALIZATION ..................................................................................120 5.1.1 Instruction keys (SAP Note 1002497).......................................................................................120 5.1.2 Create Payment Medium Formats ...........................................................................................122 5.1.3 Adjust Payment Medium Format .............................................................................................124 5.1.4 Set Up Payment Methods per Country for Payment Transactions .............................................124 5.1.5 Validation of Accounting Documents .......................................................................................126 5.2 IMG SETTINGS TO BE DONE BY COMPANY ..........................................................................................127 5.2.1 Set Up All Company Codes for Payment Transactions .............................................................127 5.2.2 Set Up Paying Company Codes for Payment Transactions .......................................................128 5.2.3 Set Up Payment Methods per Company Code for Payment Transactions ..................................128 5.2.4 Set Up Bank Determination for Payment Transactions.............................................................129 5.2.5 Define House Banks ................................................................................................................129 5.2.6 Create/Assign Selection Variants.............................................................................................129 5.3 MASTER RECORDS DATA ...................................................................................................................130 5.3.1 Bank master records ...............................................................................................................130 5.3.2 Vendor master records ............................................................................................................130 5.3.3 Edit bank chains for creditors/debitors ....................................................................................131 5.4 DOCUMENT ENTRY............................................................................................................................132 5.5 PAYMENT MEDIUM ............................................................................................................................134 5.5.1 Payment Medium ....................................................................................................................134
6.
BANK STATEMENTS .......................................................................................................................137 6.1 IMG SETTINGS TO BE DONE BY COMPANY ..........................................................................................137 6.1.1 Define House Banks ................................................................................................................137 6.1.2 Make Global Settings for Electronic Bank Statement ...............................................................137 6.2 POSTING BANK STATEMENT ..............................................................................................................139
7.
OBLIGATORY MANYSIDED RECONCILIATION .......................................................................142 7.1
REPORTING OF FINANCIAL LIABILITIES TO THE RECONCILIATION SYSTEM EPOBOTI (SAP NOTE 1576656)142
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 5 / 175
7.2 8.
IMPORT RESULT OF OBLIGATORY MANYSIDED RECONCILIATION IN SAP (SAP NOTE 1592271) ............146
BANK OF SLOVENIA REPORTING ...............................................................................................149 8.1 SKV FORM – REPORT OF SHORT -TERM NON-RESIDENT OPERATING RECEIVABLES AND LIABILITIES (SKV OBRAZEC) ..................................................................................................................................................149 8.1.1 IMG settings to be checked by company...................................................................................149 8.1.2 SKV form ................................................................................................................................150 8.2 SFR FORM – REPORT OF FINANCIAL ACCOUNT STATISTICS .................................................................152 8.2.1 Table /CCEE/SIFIPODAT2 .....................................................................................................152 8.2.2 Table /CCEE/SIFISTATE2 ......................................................................................................155 8.2.3 Program /CCEE/SIFI_SFR .....................................................................................................156 8.3 BST REPORT - REPORT ON SERVICE EXCHANGE, PARTS OF GOODS EXCHANGE, AND CURRENT CAPITAL TRANSFERS WITH NON-RESIDENTS (SAP NOTE 1063103) .............................................................................159 8.3.1 Central bank indicator and Supplying country defined on BST report relevant documents .......159 8.3.2 Table /CCEE/SIFI_BST_T.......................................................................................................160 8.3.3 Table /CCEE/SIFI_BST_R ......................................................................................................161 8.3.4 Program /CCEE/SIFI_BST......................................................................................................161
9.
FINANCIAL STATEMENTS ............................................................................................................166 9.1 9.2 9.3 9.4 9.5
10.
FINANCIAL STATEMENT VERSIONS ....................................................................................................166 BALANCE SHEET AND PROFIT & LOSS STATEMENT REPORTS ..............................................................167 EXECUTION OF THE REPORT ...............................................................................................................168 CASH FLOW REPORT (INDIRECT METHOD) ..........................................................................................170 EXECUTION OF THE REPORT ...............................................................................................................173
EDOCUMENT FRAMEWORK ........................................................................................................175
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 6 / 175
Introduction Slovenian legislation and business practice has several differences to European standards. In order to cover these special requirements SAP has developed a localization package to cover these special demands. Slovene Localization in SAP® R/3 Release 6.0 complements R/3 with functions that meet the Slovenia specific statutory requirements and common business practices in Slovenia. The localization facilitates handling of tax throughout all processes in your supply chain management. The localization package consists of several programs, special reports and a precustomizing for country specific settings. This document describes the delivered country-specific customizing and R/3 add-on developments for Slovenia. All the developments are stored in namespace /CCEE/, which is reserved for the Central European add-on development. The Slovenian Localization menu you can call with the transaction /N/CCEE/SICV. It includes all tables and programs relevant for key users.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 7 / 175
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 8 / 175
1.
Installation
The Functional part contains one Add-On and additional Support Package with further developments and changes.
Software component Release SAP CORE CEE 110_600 C-CEE SAP CORE CEE 110_602 SAP CORE CEE 110_603 SAP CORE CEE 110_604 SAP CORE CEE 110_700
Workbench objects are delivered as Add-On which should be installed in the same way as Support Packages with the SAP Add-On installation tool (SAINT). Transfer the Add-On form the CD into the EPS/in directory of your SAP transport directory Define a Support Package queue: Import the Support Package queue Check the log files Confirm the Support Package queue. Detailed instructions are described in the note 97621. Additional Support Packages for C-CEE can be downloaded from http://service.sap.com/SWDC and should be installed like all other SP from SAP (transaction SPAM). For information about current SPs and a new planned delivery please see SAP Notes 574323, 1250189, 1250254 and 1293059. Additional information about the functions included and installation procedures can be found in SAP Notes: 574323 Add-on Support Packages for add-on SAP CORE CEE, 520991 Release strategy for the SAP CORE CEE add-on, 425098 Enhancements for R/3 4.6C installation, Slovenia.
1.1
Customizing installation - BCsets
In the Add-On delivery also part of Customizing is included (TAX codes and Payment engine – DMEE). All settings are delivered as BCsets, which can be installed with transaction SCPR20. More information in SAP Note: 851155 Delivery of TAX codes and DMEE setting inside add-on, 874760 Validations/substitutions for Slovenia, 978478 Delivery of Slovenian financial statements, 1171870 C-CEE Add-on Delivered Customizing BC Sets Validity, 1225512 BC Set /CCEE/SIFI_TAXES update, 1244168 Delivery of Slovenian CoA and data related to CC SI01, 1710397 Slovenia - Sample Customizing for Asset Management. BC sets available: /CCEE/SIFI_CUST - Slovenian FI customizing, /CCEE/SIFI_DMEE - Slovenian payment medium formats, SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 9 / 175
/CCEE/SIFI_STATEMENTS – Slovenian FI statements – client specific, /CCEE/SIFI_TAXES - Slovenian Taxes, /CCEE/SIFI_ACCOUNTS - Slovenien Chart of Accounts CASI, Company SI01 settings (The /CCEE/SIFI_ACCOUNTS BC Set will NOT be shipped by C-CEE SAP Core Add-on, this is only attached with the mentioned note), /CCEE/SIFI_AA_CUST Sample Customizing for Asset Management. Installing settings delivered with BCsets can overwrite your exciting customizing. You can install them on your system just in case you use the same TAX codes and DMEE settings as described / delivered within Slovenian Localization. If this is not the case, you can install delivered customizing in a separate / test client and use them as a template! BC sets generally can be version dependent (structure of customizing table, structure of customizing activity, ..). The dependency is specified in the BC sets attributes (validity). Most of our BC sets is version independent.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 10 / 175
2. 2.1
General settings for Slovenia Country settings
Transaction OY01:
Transaction OY17:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 11 / 175
2.2
Company code settings
2.2.1
Edit Company Code Data
IMG Enterprise Structure Definition Financial Accounting change company code Edit Company Code Data
2.2.2
Enter Global Parameters
IMG Financial Accounting Financial Accounting Global Settings Enter Global Parameters (Transaction OBY6) SAP d.o.o.
Define, copy, delete,
Phone: +386 (1) 5881 255
Company Code
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 12 / 175
Negative postings should be allowed. For Tax reporting activate Tax Rep. Date Active that new field Tax Reporting Date will appear at entering FI document (for details see SAP Note 1264280 and other SAP Notes).
Transaction OBA7: Negative postings should be allowed for all relevant type of documents.
2.3
Calendar settings
Here is described the way of customizing Slovenian-specific calendar in customer systems. Use transaction SCAL for maintenance of public holidays. Define the following public holidays:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 13 / 175
Example of IMG settings for Boži Create holiday Boži , input bold items. Transaction SCAL: Change public holiday: fix dates *************************************************** Day 25 Month 12 Sort criterion Religion Holiday class Public holidays shrt Holidays long text
SI ? (fill if you wish) 1 Boži Boži
***************************************************
Example of IMG settings for Holiday calendar Create a holiday calendar for Slovenia, input bold items. SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 14 / 175
Transaction SCAL: *************************************************** Change public holiday calendar: Details Calendar ID
SI
Valid Fr.year To year
2001 2020
Holiday
Koledar praznikov za Slovenijo
Valid from Valid to
*************************************************** and assign Slovenian public holidays into your calendar using the button “Assign publ. holiday” on this subscreen..
Example of IMG settings for Factory calendar Create a factory calendar for your company using holiday calendar for Slovenia. Input bold items. Transaction SCAL: *************************************************** Change factory calendar: Details Factory cal.ID
SI Tovarniški koledar za Slovenijo
Valid Fr.year To year
2001 2020
Holiday cal. ID SI Koledar praznikov za Slovenijo Workdays: click Monday to Friday on.
2.4
Vendor/customer master data
VAT Identification number is entered into the field VAT reg. no. (LFA1-STCEG/KNA1-STCEG). Tax number can be entered into the filed Tax number 1 (LFA1-STCD1/KNA1-STCD1) and ID number from business register (Mati na številka podjetja) can be entered into the field Tax number 2 (LFA1-STCD2/KNA1STCD2). In case of using e-invoice solution for Slovenia Tax Number 4 is relevant as well and there should be provided 5 digit Budget user number.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 15 / 175
3.
Tax on Sales and Purchases (Davek na dodano vrednost)
The main condition for the correct preparation of the tax reports is the correct posting procedure with the relevant tax dates and tax codes. Based on the tax legislation the entry rules differ based on the number of tax relevant dates. In order to write the instructions more clearly we divide between: PROCEDURE 1 – Document date is relevant for Tax calculation. PROCEDURE 2 - VAT date is relevant for Tax calculation. PROCEDURE 1 – THE ENTRY RULES Posting of the incoming invoice o Document Date (BKPF-BLDAT) = VAT relevant date (e.g. Date of Invoice Receipt) o Posting Date (BKPF-BUDAT) = Balance Sheet Relevant Date o Document Header Text (BKPF-BKTXT) = Document date (e.g. Invoice Issue Date) Posting of the outgoing invoice o Document Date (BKPF-BLDAT) = VAT relevant date (e.g. Goods Issue Date or Date of Service being provided) o Posting Date (BKPF-BUDAT) = Balance Sheet Relevant Date o Document Header Text (BKPF-BKTXT) = N/A PROCEDURE 2 – THE ENTRY RULES Posting of the incoming invoice o Document Date (BKPF-BLDAT) = Document date (e.g. Invoice Issue Date) o Posting Date (BKPF-BUDAT) = Balance Sheet Relevant Date o Tax Report. Date (BKPF-VATDATE) = VAT relevant date (e.g. Date of Invoice Receipt) Posting of the outgoing invoice o Document Date (BKPF-BLDAT) = Document date (e.g. Invoice Issue Date) o Posting Date (BKPF-BUDAT) = Balance Sheet Relevant Date o Tax Report. Date (BKPF-VATDATE) = VAT relevant date (e.g. Goods Issue Date or Date of Service being provided) SAP recommendation is to use PROCEDURE 2 with VAT Date. For details about solution with VAT due date see SAP Note 1264280 and other SAP Notes.
3.1
IMG settings included in SI localization
3.1.1
Calculation Procedure
Tax Calculation Procedure for Slovenia is TAXSI. SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 16 / 175
IMG Financial Accounting Sales/Purchases Basic Settings
Financial Accounting Global Settings Check Calculation Procedure
Tax on
Variant 1
or Variant 2
More info about TAXSI Calculation Procedure and appropriate variant see in NOTE 939278. Tax codes in Slovenian template are defined according to Variant 1. In case of using Variant 2 please define Tax codes accordingly. There is also available Calculation procedure TAXSI1 in case of Budgetary consumers (Public sector):
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 17 / 175
More info about TAXSI1 Calculation Procedure and appropriate settings please find in SAP Note 1519575.
3.1.2
Assign Country to Calculation Procedure
IMG Financial Accounting Sales/Purchases Basic Settings
3.1.3
Financial Accounting Global Settings Assign Country to Calculation Procedure
Tax on
Define Tax codes for Sales and Purchases
Indicators can be divided into four basic types: 1. Indicators for output tax (i.e. commitment for tax payment), Type A (Tax code properties, field T007A-MWART) using account key MWS. Account assignment depending on indicator. 2. Indicators for input tax (i.e. receivables for input tax) Type V, using account key VST. Account assignment depending on indicator. 3. Indicator for non-deductible input tax, type V, account key NVV. Account assignment must be set even if this indicator has no tax posting because of procedure functionality. 4. Indictors for output/output acquisition tax (i.e. commitment and receivables for tax payment/commitment), Type V, using account key ESA/ESE. Account assignment depending on indicator.
IMG Financial Accounting Sales/Purchases Calculation FTXP)
Financial Accounting Global Settings Tax on Define Tax Codes for Sales and Purchases (Transaction
SAP d.o.o.
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 18 / 175
Phone: +386 (1) 5881 255
Transaction FTXP
Tax code Description
Tax type
EU Check code AccKy
A0 A5 A6 A7 B1 B2 B3 B4 B5 B6 B7 B8 B9 BA C0 C1 C2 C3
A A A A A A A A A A A A A A A A A A
X X X X X X X X X X X X X X X X X X
A A A
X X X
A A A A
X X X X
C4 C5 C6 C7 C8 C9 CA
0% output tax without deductions 0% output tax - export/EUL 0% exempt output tax 0% output tax untaxable tran.with deductions 8,5% domestic ouptut tax - taxable persons 20% domestic output tax - taxable persons 8,5% domestic ouptut tax - final consumers 20% domestic ouptut tax - final consumers 20% output tax self-assessment from import 9,5% domestic ouptut tax - taxable persons 22% domestic output tax - taxable persons 9,5% domestic ouptut tax - final consumers 22% domestic ouptut tax - final consumers 22% output tax self-assessment from import 0% exempt output tax for Triangular deals in EU 0% exempt output tax for goods in EU,reported in RP-O 0% exempt output tax for other goods in EU 0% exempt output tax EU-article 20. 0% exempt output tax for services in EU, VAT calculated in other EU country 8,5% output tax- not liable for tax 20% output tax- not liable for tax 0% exempt output tax for service and goods in SI-reverse charge by customer (art. 76a) 0% exempt output tax import 3rd/export EU 9,5% output tax- not liable for tax 22% output tax- not liable for tax
SAP d.o.o.
Phone: +386 (1) 5881 255
Tax percent. rate
MWS MWS MWS MWS MWS MWS MWS MWS MWS MWS MWS MWS MWS MWS MWS MWS MWS MWS
0 0 0 0 8,5 20 8,5 20 20 9,5 22 9,5 22 22 0 0 0 0
4
MWS MWS MWS
0 8,5 20
3 6
MWS MWS MWS MWS
0 0 9,5 22
1 1
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 19 / 175
F1 F1 F2 F2 F3 F3 F3 F4 F4 F4 F5 F5 F6 F6 J1 J2 J3 J4 O6 O7 P1 P1 P2 P2 P3 P3 P4 P4 P5 P5 P6 P6 P7 P7 P8 P8 PA PA PB PB PC PC PD PD PE PE PF
8,5% input tax - foreigners w/o hq in SLO
V
X
9
20% input tax - foreigners w/o hq in SLO
V
X
9
9,5% input tax - foreigners w/o hq in SLO-1% non-deductible
V
X
9
22% input tax - foreigners w/o hq in SLO-1% non-deductible
V
X
9
9,5% input tax - foreigners w/o hq in SLO
V
X
9
22% input tax - foreigners w/o hq in SLO
V
X
9
A
X
MWS
8,5
A
X
MWS
20
A
X
MWS
9,5
A V V V
X X X X
20% input tax, not deductible
V
X
8,5% input tax, not deductible - assets
V
X
20% input tax, not deductible - assets
V
X
8,5% input tax, not deductible - IMPORT
V
X
20% input tax, not deductible - IMPORT
V
X
8,5% input tax, not deductible-assets downpayment
V
X
20% input tax, not deductible-assets downpayment
V
X
9,5% input tax, not deductible
V
X
22% input tax, not deductible
V
X
9,5% input tax, not deductible - assets
V
X
22% input tax, not deductible - assets
V
X
9,5% input tax, not deductible - IMPORT
V
X
22% input tax, not deductible - IMPORT
V
X
MWS VST VST VST NVV VST NVV VST NVV VST NVV VST NVV VST NVV VST NAV VST NAV VST NVV VST NVV VST NVV VST NVV VST NVV VST
22 0 0 0 8,5 0 20 0 8,5 0 20 0 8,5 0 20 0 8,5 0 20 0 9,5 0 22 0 9,5 0 22 0 9,5 0
8,5% domestic output tax - internal settlement 15.article) 20% domestic output tax - internal settlement 15.article) 9,5% domestic output tax - internal settlement 15.article) 22% domestic output tax - internal settlement 15.article) 0% tax - exempt input tax for real estate 0 % tax - exempt input tax for other assets 8,5% input tax, not deductible
SAP d.o.o.
Phone: +386 (1) 5881 255
ESA ESE ESA ESE NVV ESA ESE NVV ESA ESE ESA ESE ESA ESE
8,508,5 20,0020 0,095 9,509,405 0,22 22,021,78 9,509,5 22,0022
(7.,8.and (7.,8.and (7.,8.and (7.,8.and
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 20 / 175
PF PG PG PH PH PN PO PP PP S1 S2 S3 S4 S5 S6 S7 SA SB SC SD SE T0 T0 T1 T1 T2 T2 T3 T3 T4 T4 T5 T5 R0 R0 R1 R1 R2 R2 R3 R3 R4 R4 R5 R5 RA RA RB
9,5% input tax, not deductible-assets downpayment
V
X
22% input tax, not deductible-assets downpayment
V
X
8% flat rate compensation 8% flat rate compensation - settlement 8% flat rate compensation, non - deductible
V V V
X X X
8,5% domestic input tax for assets 20% domestic input tax for assets 20% domestic input tax for real estate 8,5% input tax - import with EUL for assets 20% input tax - import with EUL for assets 9,5% inp.tax-corr.inp.VAT at sales assets-70.art.ZDDV-1 22% inp.tax-corr.inp.VAT at sales assets-70.art.ZDDV-1 9,5% domestic input tax for assets 22% domestic input tax for assets 22% domestic input tax for real estate 9,5% input tax - import with EUL for assets 22% input tax - import with EUL for assets 20% input/output tax-purchased services from EU
V V V V V V V V V V V V V V V V V V V V V V
X X X X X X X X X X X X X X X X X X X X X X
V V V V V V V V V V V V
X X X X X X X X X X X X
9
V V V V V
X X X X X
9
8,5% input/output tax-purchased services from EU 20% input/output tax-purchased services from EU/real estate 8,5% input/output tax-purchased services from EU/real estate 20% input/output tax-purchased services from EU/fixed assets 8,5% input/output tax-purchased services from EU/fixed assets 22% input/output tax-purchased services from EU 9,5% input/output tax-purchased services from EU 22% input/output tax-purchased services from EU/real estate 9,5% input/output tax-purchased services from EU/real estate 22% input/output tax-purchased services from EU/fixed assets 9,5% input/output tax-purchased services from EU/fixed assets 20% input tax-purchased services from EU 8,5% input tax-purchased services from EU
SAP d.o.o.
Phone: +386 (1) 5881 255
9 9 9 9 9
9 9 9 9 9
9 9
NVV VST NAV VST NAV VST NAV VST NVV VST VST VST VST VST VST VST VST VST VST VST VST ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE
22 0 9,5 0 22 8 8 0 8 8,5 20 20 8,5 20 2 2 9,5 22 22 9,5 22 2020 8,508,5 2020 8,508,5 2020
ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE
8,508,5 2222 9,509,5 2222 9,509,5 2222
ESA ESE ESA ESE ESA
9,509,5 2020 8,50-
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 21 / 175
RB RC RC RD RD RE RE RF RF RG RG RH RH RI RI RJ RJ RK RK RQ RQ RL RL RM RM RN RN RO RO RP RP RR RR RS RS RT RT RU RU RV RV RW RW RZ RZ T6 T6 T7
20% input tax-purchased services from EU/real estate 8,5% input tax-purchased services from EU/real estate 20% input tax-purchased services from EU/fixed assets 8,5% input tax-purchased services from EU/fixed assets 22% input tax-purchased services from EU 9,5% input tax-purchased services from EU 22% input tax-purchased services from EU/real estate 9,5% input tax-purchased services from EU/real estate 22% input tax-purchased services from EU/fixed assets 9,5% input tax-purchased services from EU/fixed assets 20% output tax-purchased services from EU 8,5% output tax-purchased services from EU 20% output tax-purchased services from EU/real estate 8,5% output tax-purchased services from EU/real estate 20% output tax-purchased services from EU/fixed assets 8,5% output tax-purchased services from EU/fixed assets 22% output tax-purchased services from EU 9,5% output tax-purchased services from EU 22% output tax-purchased services from EU/real estate 9,5% output tax-purchased services from EU/real estate 22% output tax-purchased services from EU/fixed assets 9,5% output tax-purchased services from EU/fixed assets 20% input/output tax-purchased services/goods in SI-reverse charge (76a art.) 8,5% input/output tax-purchased services/goods in SI-reverse charge (76a art.)
SAP d.o.o.
Phone: +386 (1) 5881 255
V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V
X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
V V
X X
V
X
ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE
8,5 2020 8,508,5 2020 8,508,5 2222 9,509,5 2222 9,509,5 2222 9,509,5 2020 8,508,5 2020 8,508,5 2020 8,508,5 2222 9,509,5 2222 9,509,5 2222 9,509,5
9
ESA ESE
20,0020
9
ESA
8,50-
9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 22 / 175
T7 T8 T8 T9 T9 TA TA TB TB TC TC TD TD TE TE TF TF TG TG TH TH TI TI TJ TJ TK TK TQ TQ U0 U0 UN UN US US U1 U1 U2 U2 U3 U4
ESE
8,5
9
ESA ESE
20,0020
X X
9
ESA ESE
8,508,5
V V
X X
9
ESA ESE
20,0020
V V
X X
9
ESA ESE
8,508,5
V V
X X
9
ESA ESE
20,0020
V V
X X
9
ESA ESE
8,508,5
V V
X X
9
ESA ESE
22,0022
V V
X X
9
ESA ESE
9,509,5
V V
X X
9
ESA ESE
22,0022
V V
X X
9
ESA ESE
9,509,5
V V
X X
9
ESA ESE
22,0022
V V
X X
9
ESA ESE
9,509,5
V V
X X
9
ESA ESE
22,0022
X X X
9
20% input tax, non-deductible - goods acquisitions EU
V V V
8,5% input tax, non-deductible - goods acquisitions EU
V
X
9
20%input tax,non-deductible-services EU
V
X
9
8,5% input tax - goods acquisitions within EU
V
X
9
20%input tax - goods acquisitions within EU
V
X
9
0% input tax - third party acquisitions within EU 0% input tax - tax exempt goods acquisitions within EU
V V
X X
ESA ESE NVV ESA NVV ESA NVV ESA ESA ESE ESA ESE VST VST
9,509,5 20 20,008,5 8,5020 20,008,508,5 20,0020 0 0
20% input/output tax-purchased services/goods in SI/real estate-reverse charge (76a art.) 8,5% input/output tax-purchased services/goods in SI/real estate-reverse charge (76a art.) 20% input/output tax-purchased services/goods in SI/fixed assets-reverse charge (76a art.) 8,5% input/output tax-purchased services/goods in SI/fixed assets-reverse charge (76a art.) 20% input/output tax-downpaym./purchased services/goods in SI-reverse charge (76a art.) 8,5% input/output tax-downpaym./purchased services/goods in SI-reverse charge (76a art.) 22% input/output tax-purchased services/goods in SI-reverse charge (76a art.) 9,5% input/output tax-purchased services/goods in SI-reverse charge (76a art.) 22% input/output tax-purchased services/goods in SI/real estate-reverse charge (76a art.) 9,5% input/output tax-purchased services/goods in SI/real estate-reverse charge (76a art.) 22% input/output tax-purchased services/goods in SI/fixed assets-reverse charge (76a art.) 9,5% input/output tax-purchased services/goods in SI/fixed assets-reverse charge (76a art.) 22% input/output tax-downpaym./purchased services/goods in SI-reverse charge (76a art.) 9,5% input/output tax-downpaym./purchased services/goods in SI-reverse charge (76a art.)
SAP d.o.o.
Phone: +386 (1) 5881 255
V
X
V V
X X
V V
9
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 23 / 175
U5 U5 U6 U6 U7 U7 U8 U8 U9 U9 UA UA UB UB UC UC UD UD UE UE UX UX UY UY UZ UZ UQ UQ UW UW E0 E0 EN EN ES ES E1 E1 E2 E2 E3 E3 E4 E4 E5 E5 E6 E6 E7 E7
8,5% EU input tax - fixed assets
V
X
9
20% EU input tax - fixed assets
V
X
9
8,5% tax calculation -15.-th of the month
V
X
9
20% tax calculation - 15.-th of the month
V
X
9
20% input tax - services EU
V
X
9
20% output tax - goods acquisition within EU
V
X
9
8,5% output tax - goods acquisition within EU
V
X
20% output tax - services EU
V
X
9
20% output tax - fixed assets acquisition within EU
V
X
9
8,5% output tax - fixed assets acquisition within EU
V
X
9
20% input tax - goods acquisitions within EU
V
X
9
8,5% input tax - goods acquisitions within EU
V
X
9
20% input tax - services EU
V
X
9
20% input tax - fixed assets acquisitions within EU
V
X
9
8,5% input tax - fixed assets acquisitions within EU
V
X
9
22% input tax, non-deductible - goods acquisitions EU
V
X
9
9,5% input tax, non-deductible - goods acquisitions EU
V
X
9
22%input tax,non-deductible-services EU
V
X
9
9,5% input tax - goods acquisitions within EU
V
X
9
22%input tax - goods acquisitions within EU
V
X
9
9,5% EU input tax - fixed assets
V
X
9
22% EU input tax - fixed assets
V
X
9
9,5% tax calculation -15.-th of the month
V
X
9
22% tax calculation - 15.-th of the month
V
X
9
22% input tax - services EU
V
X
9
SAP d.o.o.
Phone: +386 (1) 5881 255
ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE NVV ESA NVV ESA NVV ESA ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE
8,508,5 20,0020 8,58,5 2020 20,0020 20,0020 8,508,5 20,0020 20,0020 8,508,5 20,0020 8,508,5 20,0020 20,0020 8,508,5 22 22,009,5 9,5022 22,009,509,5 22,0022 9,509,5 22,0022 9,59,5 22,0022 22,0022
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 24 / 175
EA EA EB EB EC EC ED ED EE EE EX EX EY EY EZ EZ EQ EQ EW EW V0 V5 V6 XA XV Z1 Z2 Z3 Z4 Z5 Z6 ZN ZA ZB ZC ZD ZE ZF ZG Q1 Q1 Q1 Q2 Q2 Q2 Q5 Q5 Q5
22% output tax - goods acquisition within EU
V
X
9,5% output tax - goods acquisition within EU
V
X
22% output tax - services EU
V
X
9
22% output tax - fixed assets acquisition within EU
V
X
9
9,5% output tax - fixed assets acquisition within EU
V
X
9
22% input tax - goods acquisitions within EU
V
X
9
9,5% input tax - goods acquisitions within EU
V
X
9
22% input tax - services EU
V
X
9
22% input tax - fixed assets acquisitions within EU
V
X
9
9,5% input tax - fixed assets acquisitions within EU
V
X
9
0 % tax exempt input tax 0% import tax Import for export No tax procedure No tax procedure 8,5% domestic input tax 20% domestic input tax 8,5% input tax - import with EUL 20% input tax - import with EUL 8,5% input tax - fixed assets downpayments 20% input tax - fixed assets downpayments 20% input tax - real estate downpayments 9,5% domestic input tax 22% domestic input tax 9,5% input tax - import with EUL 22% input tax - import with EUL 9,5% input tax - fixed assets downpayments 22% input tax - fixed assets downpayments 22% input tax - real estate downpayments 9,5% input tax - goods acquisitions within EU - 1% nondeductible
V V V A V V V V V V V V V V V V V V V
X X X X X X X X X X X X X X X X X X X
V
X
22% input tax-goods acquisitions within EU-1% nondeductible
V
9,5% EU input tax-fixed assets -1% non-deductible
V
SAP d.o.o.
Phone: +386 (1) 5881 255
9
ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE VST VST VST MWS VST VST VST VST VST VST VST VST VST VST VST VST VST VST VST
22,0022 9,509,5 22,0022 22,0022 9,509,5 22,0022 9,509,5 22,0022 22,0022 9,509,5 0 0 0 0 0 8,5 20 8,5 20 8,5 20 20 9,5 22 9,5 22 9,5 22 22
9
NVV ESA ESE
0,095 9,509,405
X
9
X
9
NVV ESA ESE NVV ESA ESE
0,22 22,0021,78 0,095 9,509,405
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 25 / 175
Q6 Q6 Q6 Q7 Q7 Q8 Q8 Q9 Q9 Q9 QA QA QA QB QB QB QC QC QC QD QD QD QE QE QE QF QF QF QG QG QG QH QH QH QI QI QI QJ QJ QJ QK QK QK
22% EU input tax - fixed assets - 1% non-deductible
V
X
9,5% tax calculation - 15.-th of the month - 1% non-deductible
A
22% tax calculation -15.-th of the month - 1% non-deductible
X
NVV ESA ESE MWS
0,22 22,0021,78 9,405
A
X
MWS
21,78
22% input tax - services EU - 1% non-deductible
V
X
9
NVV ESA ESE
0,22 22,0021,78
22% input/output tax-purchased services from EU - 1% nondeductible
V
X
9
NVV ESA ESE
0,22 22,0021,78
9,5% input/output tax-purchased services from EU - 1% nondeductible
V
X
9
NVV ESA ESE
0,095 9,509,405
22% input/output tax-purchased services from EU/real estate 1% non-deductible
V
X
9
NVV ESA ESE
0,22 22,0021,78
9,5% input/output tax-purchased services from EU/real estate - 1% non-deductible
V
X
9
NVV ESA ESE
0,095 9,509,405
22% input/output tax-purchased services from EU/fixed assets - 1% non-deductible
V
X
9
NVV ESA ESE
0,22 2221,78
9,5% input/output tax-purchased services from EU/fixed assets - 1% non-deductible
V
X
9
NVV ESA ESE
0,095 9,509,405
22% input/output tax-purchased services/goods in SI-reverse charge (76a art.) - 1% non-deductible
V
X
9
NVV ESA ESE
0,22 22,0021,78
9,5% input/output tax-purchased services/goods in SI-reverse charge (76a art.) - 1% non-deductible
V
X
9
NVV ESA ESE
0,095 9,509,405
22% input/output tax-purchased services/goods in SI/real estate-reverse charge (76a art.) - 1% non-deductible
V
X
9
NVV ESA ESE
0,22 22,0021,78
9,5% input/output tax-purchased services/goods in SI/real estate-reverse charge (76a art.) - 1% non-deductible
V
X
9
NVV ESA ESE
0,095 9,509,405
22% input/output tax-purchased services/goods in SI/fixed assets-reverse charge (76a art.) - 1% non-deductible
V
X
9
NVV ESA ESE
0,22 22,0021,78
SAP d.o.o.
Phone: +386 (1) 5881 255
9
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 26 / 175
QL QL QL QM QM QM QN QN QN YN YN Y1 Y1 Y2 Y2 Y3 Y3 Y4 Y4 Y6 Y6 Y7 Y7 Y8 Y8 Y9 Y9 YA YA
9,5% input/output tax-purchased services/goods in SI/fixed assets-reverse charge (76a art.) - 1% non-deductible
V
X
9
NVV ESA ESE
0,095 9,509,405
22% input/output tax-downpaym./purchased services/goods in SI-reverse charge (76a art.) - 1% non-deductible
V
X
9
NAV ESA ESE
0,22 22,0021,78
9,5% input/output tax-downpaym./purchased services/goods in SI-reverse charge (76a art.) - 1% non-deductible
V
X
9
8% flat rate compensation - 1% non-deductible
V
X
9,5% domestic input tax - 1% non-deductible
V
X
22% domestic input tax - 1% non-deductible
V
X
9,5% domestic input tax for assets - 1% non-deductible
V
X
22% domestic input tax for assets - 1% non-deductible
V
X
22% domestic input tax for real estate - 1% non-deductible
V
X
NAV ESA ESE VST NVV VST NVV VST NVV VST NVV VST NVV VST NVV
9,405 9,509,405 7,92 0,08 9,405 0,095 21,78 0,22 9,405 0,095 21,78 0,22 21,78 0,27
9,5% input tax - fixed assets downpayments - 1% nondeductible
V
X
VST NAV
9,405 0,095
22% input tax - fixed assets downpayments - 1% nondeductible
V
X
VST NAV
21,78 0,22
22% input tax - real estate downpayments - 1% nondeductible
V
X
VST NAV
21,78 0,22
9,5% input tax - import with EUL for assets - 1% nondeductible
V
X
VST NVV
9,405 0,095
V
X
V
X
V
X
A A
X X
VST NVV VST NVV VST NVV MWS NAV
21,78 0,22 9,405 0,095 21,78 0,22 6,5 6,5
22% input tax - import with EUL for assets - 1% nonYB deductible YB YC 9,5% input tax - import with EUL - 1% non - deductible YC YD 22% input tax - import with EUL - 1% non - deductible YD 1A* 6,5% tax on financial services - settlement 1B* 6,5% tax on financial services - settlement * Tax on financial services – for more details check SAP Note 1822420.
1A
To create tax codes for Down payments with non-deductible input tax see SAP Notes 29216 and 939278. Tax codes U7 and U8 for posting VAT on the 15.th in the month are created based on Instructions in SAP Note 789859 Acquisition Tax Accruals.
3.1.4 SAP d.o.o.
Group Tax Base Balances Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 27 / 175
In this activity, you group the combinations of taxes on sales/purchases codes for filling out the DDV-O form.
IMG Financial Accounting General Ledger Accounting Business Transactions Closing Reporting Sales/Purchases Tax Returns Group Tax Base Balances (Transaction OBCG)
3.1.5
Group Tax Balances
In this activity, you group the combinations of taxes on sales/purchases codes for filling out the DDV-O form.
IMG Financial Accounting General Ledger Accounting Business Transactions Closing Reporting Sales/Purchases Tax Returns Group Tax Balances (Transaction OBCH)
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 28 / 175
3.1.6
IMG settings for transaction OBCG, OBCH and rules for DMEE outpuf files
Transaction FTXP Tax code
AccKy
A0 A5 A6 A7 B1 B2 B3 B4 B5 B5
MWS MWS MWS MWS MWS MWS MWS MWS MWS
0 0 0 0 8,5 20 8,5 20 20
B6 B7 B8 B9 BA BA C0 C1 C2 C3 C4
MWS MWS MWS MWS MWS
9,5 22 9,5 22 22
C5 C6 C7 C8 SAP d.o.o.
MWS MWS MWS MWS MWS MWS MWS MWS MWS
Tax % rate
OBCG
OBCH
DMEE at RFUMSV00
Tx.bs
Gp no
column in new DMEE
0 0 0 0 0 8,5 20 0 0
Phone: +386 (1) 5881 255
15 11 11 11 11 11 11
22 21 22 21 26
31 11 11 11 11
22 21 22 21 26
31 12 12 14 13 12 11 11 11a (81) 12
22 21
Obracunani DDV.9 Obracunani DDV.7 Obracunani DDV.7 Obracunani DDV.23 Obracunani DDV.7, 15 Obracunani DDV.7, 14 Obracunani DDV.7, 15 Obracunani DDV.7, 14 Obra unani DDV.22 Odbitek DDV.8 Obracunani DDV.7, 15 Obracunani DDV.7, 14 Obracunani DDV.7, 15 Obracunani DDV.7, 14 Obra unani DDV.22 Odbitek DDV.8 Obracunani DDV.11 Obracunani DDV.10 Obracunani DDV.13 Obracunani DDV.12 Obracunani DDV.10 Obracunani DDV.7, 15 Obracunani DDV.7, 14 Obra unani DDV.8 Obracunani DDV.10
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 29 / 175
C9 CA F1 F1 F2 F2 F3 F3 F3 F4 F4 F4 F5 F5 F6 F6 J1 J2 J3 J4 O6 O7 P1 P1 P2 P2 P3 P3 P4 P4 P5 P5 P6 P6 P7 P7 P8 P8 PA PA PB PB PC PC PD PD PE PE PF PF SAP d.o.o.
MWS MWS ESA ESE ESA ESE NVV ESA ESE NVV ESA ESE ESA ESE ESA ESE MWS MWS MWS MWS VST VST VST NVV VST NVV VST NVV VST NVV VST NVV VST NVV VST NAV VST NAV VST NVV VST NVV VST NVV VST NVV VST NVV VST NVV
9,5 22 8,508,5 20,0020 0,09 8,508,42 0,2 20,019,8 9,509,5 22,0022 8,5 20 9,5 22 0 0 0 8,5 0 20 0 8,5 0 20 0 8,5 0 20 0 8,5 0 20 0 9,5 0 22 0 9,5 0 22 0 9,5 0 22
Phone: +386 (1) 5881 255
11 11 31 31 31 31 31 31 31 31 11 11 11 11 33, 34 33, 35 31
22 21 25a (85) 42 25 41
Obracunani DDV.7, 15 Obracunani DDV.7, 14 Obracunani DDV.21 Odbitek DDV.8, 19 Obracunani DDV.20 Odbitek DDV.8, 18
25 42
Obracunani DDV.21 Odbitek DDV.8, 17, 19
25 41 25a (85) 42 25 41 22 21 22 21
Obracunani DDV.20 Odbitek DDV.8, 17, 18 Obracunani DDV.21 Odbitek DDV.8, 19 Obracunani DDV.20 Odbitek DDV.8, 18 Obracunani DDV.7, 15 Obracunani DDV.7, 14 Obracunani DDV.7, 15 Obracunani DDV.7, 14 Odbitek DDV.14, 15 Odbitek DDV.14, 16 Odbitek DDV.8, 17
31
Odbitek DDV.8, 17
31, 35
Odbitek DDV.8, 13, 17
31, 35
Odbitek DDV.8, 13, 17
31
Odbitek DDV.8, 17
31
Odbitek DDV.8, 17
31, 35
Odbitek DDV.8, 13, 17
31, 35
Odbitek DDV.8, 13, 17
31
Odbitek DDV.8, 17
31
Odbitek DDV.8, 17
31, 35
Odbitek DDV.8, 13, 17
31, 35
Odbitek DDV.8, 13, 17
31
Odbitek DDV.8, 17
31
Odbitek DDV.8, 17 Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 30 / 175
PG PG PH PH PN PO PP PP S1 S2 S3 S4 S5 S6 S7 SA SB SC SD SE T0 T0 T1 T1 T2 T2 T3 T3 T4 T4 T5 T5 R0 R0 R1 R1 R2 R2 R3 R3 R4 R4 R5 R5 RA RA RB RB RC RC SAP d.o.o.
VST NAV VST NAV VST NAV VST NVV VST VST VST VST VST VST VST VST VST VST VST VST ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE
0 9,5 0 22 8 8 0 8 8,5 20 20 8,5 20 2 2 9,5 22 22 9,5 22 2020 8,508,5 2020 8,508,5 2020 8,508,5 2222 9,509,5 2222 9,509,5 2222 9,509,5 2020 8,508,5 2020
Phone: +386 (1) 5881 255
31, 35
Odbitek DDV.8, 13, 17
31, 35
Odbitek DDV.8, 13, 17
31
43
31
Odbitek DDV.8, 20 Odbitek DDV.8, 17
31, 35 31, 35 31, 34 31, 35 31, 35
31, 35 31, 35 31, 34 31, 35 31, 35 32a (92) 32a (92) 32a (92), 34 32a (92), 34 32a (92), 35 32a (92), 35 32a (92) 32a (92) 32a (92), 34 32a (92), 34 32a (92), 35 32a (92), 35
42 41 41 42 41 42 41 42 41 41 42 41 23a (83) 41 24a (84) 42 23a (83) 41 24a (84) 42 23a (83) 41 24a (84) 42 23a (83) 41 24a (84) 42 23a (83) 41 24a (84) 42 23a (83) 41 24a (84) 42
Odbitek DDV.8, 13, 19 Odbitek DDV.8, 13, 18 Odbitek DDV.8, 12, 18 Odbitek DDV.8, 13, 19 Odbitek DDV.8, 13, 18 Odbitek.19 Odbitek.18 Odbitek DDV.8, 13, 19 Odbitek DDV.8, 13, 18 Odbitek DDV.8, 12, 18 Odbitek DDV.8, 13, 19 Odbitek DDV.8, 13, 18 Obra unani DDV.17 Odbitek.11, 18 Obra unani DDV.19 Odbitek.11, 19 Obra unani DDV.17 Odbitek.11, 12, 18 Obra unani DDV.19 Odbitek.11, 12, 19 Obra unani DDV.17 Odbitek.11, 13, 18 Obra unani DDV.19 Odbitek.11, 13, 19 Obra unani DDV.17 Odbitek.11, 18 Obra unani DDV.19 Odbitek.11, 19 Obra unani DDV.17 Odbitek.11, 12, 18 Obra unani DDV.19 Odbitek.11, 12, 19 Obra unani DDV.17 Odbitek.11, 13, 18 Obra unani DDV.19 Odbitek.11, 13, 19
41
Odbitek.18
42
Odbitek.19
41
Odbitek.18
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 31 / 175
RD RD RE RE RF RF RG RG RH RH RI RI RJ RJ RK RK RQ RQ RL RL RM RM RN RN RO RO RP RP RR RR RS RS RT RT RU RU RV RV RW RW RZ RZ T6 T6 T7 T7 T8 T8 T9 T9 SAP d.o.o.
ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE
8,508,5 2020 8,508,5 2222 9,509,5 2222 9,509,5 2222 9,509,5 2020 8,508,5 2020 8,508,5 2020 8,508,5 2222 9,509,5 2222 9,509,5 2222 9,509,5 20,0020 8,508,5 20,0020 8,508,5
Phone: +386 (1) 5881 255
42
Odbitek.19
41
Odbitek.18
42
Odbitek.19
41
Odbitek.18
42
Odbitek.19
41
Odbitek.18
42
Odbitek.19
41
Odbitek.18
42 23a (83)
Odbitek.19 Obra unani DDV.17 Odbitek.11 Obra unani DDV.19 Odbitek.11 Obra unani DDV.17 Odbitek.11, 12 Obra unani DDV.19 Odbitek.11, 12 Obra unani DDV.17 Odbitek.11, 13 Obra unani DDV.19 Odbitek.11, 13 Obra unani DDV.17 Odbitek.11 Obra unani DDV.19 Odbitek.11 Obra unani DDV.17 Odbitek.11, 12 Obra unani DDV.19 Odbitek.11, 12 Obra unani DDV.17 Odbitek.11, 13 Obra unani DDV.19 Odbitek.11, 13 Obra unani DDV.20 Odbitek.9, 18 Obra unani DDV.21 Odbitek.9, 19 Obra unani DDV.20 Odbitek.9, 12, 18 Obra unani DDV.21 Odbitek.9, 12, 19
32a (92) 24a (84) 32a (92) 23a (83) 32a (92), 34 24a (84) 32a (92), 34 23a (83) 32a (92), 35 24a (84) 32a (92), 35 23a (83) 32a (92) 24a (84) 32a (92) 23a (83) 32a (92), 34 24a (84) 32a (92), 34 23a (83) 32a (92), 35 24a (84) 32a (92), 35 31a (91) 31a (91) 31a (91), 34 31a (91), 34
25 41 25a (85) 42 25 41 25a (85) 42
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 32 / 175
TA TA TB TB TC TC TD TD TE TE TF TF TG TG TH TH TI TI TJ TJ TK TK TQ TQ U0 U0 UN UN US US U1 U1 U2 U2 U3 U4 U5 U5 U6 U6 U7 U7 U8 U8 U9 U9 UA UA UB UB SAP d.o.o.
ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE NVV ESA NVV ESA NVV ESA ESA ESE ESA ESE VST VST ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE
20,0020 8,508,5 20,0020 8,508,5 22,0022 9,509,5 22,0022 9,509,5 22,0022 9,509,5 22,0022 9,509,5 20 20,008,5 8,5020 20,008,508,5 20,0020 0 0 8,508,5 20,0020 8,58,5 2020 20,0020 20,0020 8,508,5
Phone: +386 (1) 5881 255
31a (91), 35 31a (91), 35 31a (91) 31a (91) 31a (91) 31a (91) 31a (91), 34 31a (91), 34 31a (91), 35 31a (91), 35 31a (91) 31a (91) 32
25 41 25a (85) 42 25 41 25a (85) 42 25 41 25a (85) 42 25 41 25a (85) 42 25 41 25a (85) 42 25 41 25a (85) 42 23
32 24 31 25 24 42 23 41
32 32 33 33 32, 35 32, 35
24 42 23 41 24
32 23 32 31
25 41 23
32 24 32
Obra unani DDV.20 Odbitek.9, 13, 18 Obra unani DDV.21 Odbitek.9, 13, 19 Obra unani DDV.20 Odbitek.9, 18 Obra unani DDV.21 Odbitek.9, 19 Obra unani DDV.20 Odbitek.9, 18 Obra unani DDV.21 Odbitek.9, 19 Obra unani DDV.20 Odbitek.9, 12, 18 Obra unani DDV.21 Odbitek.9, 12, 19 Obra unani DDV.20 Odbitek.9, 13, 18 Obra unani DDV.21 Odbitek.9, 13, 19 Obra unani DDV.20 Odbitek.9, 18 Obra unani DDV.21 Odbitek.9, 19 Odbitek DDV.10, 17 Obracunani DDV.16 Odbitek DDV.10, 17 Obracunani DDV.18 Odbitek DDV.8, 17 Obracunani DDV.20 Obracunani DDV.18 Odbitek DDV.10, 19 Obracunani DDV.16 Odbitek DDV.10, 18 Odbitek DDV.14 Odbitek DDV.14 Obracunani DDV.18 Odbitek DDV.10, 13, 19 Obracunani DDV.16 Odbitek DDV.10, 13, 18 Obracunani DDV.18 Odbitek DDV.10 Obracunani DDV.16 Odbitek DDV.10 Obracunani DDV.20 Odbitek DDV.8, 18 Obracunani DDV.16 Odbitek DDV.10 Obracunani DDV.18 Odbitek DDV.10
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 33 / 175
UC UC UD UD UE UE UX UX UY UY UZ UZ UQ UQ UW UW E0 E0 EN EN ES ES E1 E1 E2 E2 E3 E3 E4 E4 E5 E5 E6 E6 E7 E7 EA EA EB EB EC EC ED ED EE EE EX EX EY EY SAP d.o.o.
ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE NVV ESA NVV ESA NVV ESA ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE ESA ESE
20,0020 20,0020 8,508,5 20,0020 8,508,5 20,0020 20,0020 8,508,5 22 22,009,5 9,5022 22,009,509,5 22,0022 9,509,5 22,0022 9,59,5 2222 22,0022 22,0022 9,509,5 22,0022 22,0022 9,509,5 22,0022 9,509,5
Phone: +386 (1) 5881 255
25 31 23 32, 35 24 32, 35 41
Odbitek DDV.18
42
Odbitek DDV. 19
41
Odbitek DDV.18
41
Odbitek DDV.18
42
Odbitek DDV. 19 Odbitek DDV.10, 17 Obracunani DDV.16 Odbitek DDV.10, 17 Obracunani DDV.18 Odbitek DDV.8, 17 Obracunani DDV.20 Obracunani DDV.18 Odbitek DDV.10, 19 Obracunani DDV.16 Odbitek DDV.10, 18 Obracunani DDV.18 Odbitek DDV.10, 13, 19 Obracunani DDV.16 Odbitek DDV.10, 13, 18 Obracunani DDV.18 Odbitek DDV.10 Obracunani DDV.16 Odbitek DDV.10 Obracunani DDV.20 Odbitek DDV.8, 18 Obracunani DDV.16 Odbitek DDV.10 Obracunani DDV.18 Odbitek DDV.10 Obracunani DDV.20 Odbitek DDV.8 Obracunani DDV.16 Odbitek DDV.10, 13 Obracunani DDV.18 Odbitek DDV.10, 13
32 23 32 24 31
32 32 32, 35 32, 35
25 24 42 23 41 24 42 23 41 24
32 23 32 25 41 23
31
Obracunani DDV.20 Odbitek DDV.8 Obracunani DDV.16 Odbitek DDV.10, 13 Obracunani DDV.18 Odbitek DDV.10, 13
32 24 32 25 31 23 32, 35 24 32, 35 41
Odbitek DDV.18
42
Odbitek DDV. 19
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 34 / 175
EZ EZ EQ EQ EW EW V0 V5 V6 XA XV Z1 Z2 Z3 Z4 Z5 Z6 ZN ZA ZB ZC ZD ZE ZF ZG Q1 Q1 Q1 Q2 Q2 Q2 Q5 Q5 Q5 Q6 Q6 Q6 Q7 Q7 Q8 Q8 Q9 Q9 Q9 QA QA QA QB QB QB SAP d.o.o.
ESA ESE ESA ESE ESA ESE VST VST VST MWS VST VST VST VST VST VST VST VST VST VST VST VST VST VST VST NVV ESA ESE NVV ESA ESE NVV ESA ESE NVV ESA ESE MWS
22,0022 22,0022 9,509,5 0 0 0 0 0 8,5 20 8,5 20 8,5 20 20 9,5 22 9,5 22 9,5 22 22 0,095 5,509,405 0,22 22,0021,78 0,095 9,509,405 0,22 22,0021,78 9,405
MWS
21,78
NVV ESA ESE NVV ESA ESE NVV ESA ESE
0,22 22,0021,78 0,22 22,0021,78 0,095 9,509,405
Phone: +386 (1) 5881 255
41
Odbitek DDV.18
41
Odbitek DDV.18
42
Odbitek DDV. 19 Odbitek DDV.14 Odbitek DDV.14 Odbitek DDV.14
42 41 42 41 42 41 41 42 41 42 41 42 41 41
Odbitek Odbitek Odbitek Odbitek Odbitek Odbitek Odbitek Odbitek Odbitek Odbitek Odbitek Odbitek Odbitek Odbitek
24 42
Obracunani DDV.18 Odbitek DDV.10, 17, 19
23 41
Obracunani DDV.16 Odbitek DDV.10, 17, 18
24 42
Obracunani DDV.18 Odbitek DDV.10, 13, 17, 19
23 41 24
Obracunani DDV.16 Odbitek DDV.10, 13, 17, 18 Obracunani DDV.18 Odbitek DDV.10 Obracunani DDV.16 Odbitek DDV.10
33 33 33
31 31 31 31 31, 35 31, 35 31, 34 31 31 31 31 31, 35 31, 35 31, 34 32 32 32 32 32, 35 32, 35 32, 35 32, 35
23
DDV.8, DDV.8, DDV.8, DDV.8, DDV.8, DDV.8, DDV.8, DDV.8, DDV.8, DDV.8, DDV.8, DDV.8, DDV.8, DDV.8,
19 18 19 18 13, 19 13, 18 12, 18 19 18 19 18 13, 19 13, 18 12, 18
31 31 32a (92) 32a (92) 32a (92) 32a (92)
25 41
Obracunani DDV.20 Odbitek DDV.8, 17, 18
23a (83) 41
Obra unani DDV.17 Odbitek.11, 17, 18
24a (84) 42
Obra unani DDV.19 Odbitek.11, 17, 19
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 35 / 175
QC QC QC QD QD QD QE QE QE QF QF QF QG QG QG QH QH QH QI QI QI QJ QJ QJ QK QK QK QL QL QL QM QM QM QN QN QN YN YN Y1 Y1 Y2 Y2 Y3 Y3 Y4 Y4 Y6 Y6 Y7 Y7 SAP d.o.o.
NVV ESA ESE NVV ESA ESE NVV ESA ESE NVV ESA ESE NVV ESA ESE NVV ESA ESE NVV ESA ESE NVV ESA ESE NVV ESA ESE NVV ESA ESE NAV ESA ESE NAV ESA ESE VST NVV VST NVV VST NVV VST NVV VST NVV VST NVV VST NAV
0,22 22,0021,78 0,095 9,509,405 0,22 2221,78 0,095 9,509,405 0,22 22,0021,78 0,095 9,509,405 0,22 22,0021,78 0,095 9,509,405 0,22 22,0021,78 0,095 9,509,405 0,22 22,0021,78 9,405 9,509,405 7,92 0,08 9,405 0,095 21,78 0,22 9,405 0,095 21,78 0,22 21,78 0,22 9,405 0,095
Phone: +386 (1) 5881 255
32a (92), 34 23a (83) 41
Obra unani DDV.17 Odbitek.11, 12, 17, 18
24a (84) 42
Obra unani DDV.19 Odbitek.11, 12, 17, 19
23a (83) 41
Obra unani DDV.17 Odbitek.11, 13, 17, 18
24a (84) 42
Obra unani DDV.19 Odbitek.11, 13, 17, 19
25 41
Obra unani DDV.20 Odbitek.9, 17, 18
25a (85) 42
Obra unani DDV.21 Odbitek.9, 17, 19
25 41
Obra unani DDV.20 Odbitek.9, 12, 17, 18
25a (85) 42
Obra unani DDV.21 Odbitek.9, 12, 17, 19
25 41
Obra unani DDV.20 Odbitek.9, 13, 17, 18
31a (91), 35
25a (85) 42
Obra unani DDV.21 Odbitek.9, 13, 17, 19
31a (91)
25 41
Obra unani DDV.20 Odbitek.9, 17, 18
25a (85) 42 43
Obra unani DDV.21 Odbitek.9, 17, 19 Odbitek DDV.8, 17, 20
42
Odbitek DDV.8, 17, 19
41
Odbitek DDV.8, 17, 18
42
Odbitek DDV.8, 13, 17, 19
41
Odbitek DDV.8, 13, 17, 18
41
Odbitek DDV.8, 12, 17, 18
42
Odbitek DDV.8, 13, 17, 19
32a (92), 34 32a (92), 34 32a (92), 34 32a (92), 35 32a (92), 35
32a (92), 35 31a (91) 31a (91) 31a (91) 31a (91) 31a (91), 34 31a (91), 34 31a (91), 34 31a (91), 34 31a (91), 35 31a (91), 35 31a (91), 35
31a (91) 31 31 31 31 31 31 31, 35 31, 35 31, 35 31, 35 31, 34 31, 34 31, 35 31, 35
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 36 / 175
Y8 Y8 Y9 Y9 YA YA YB YB YC YC YD YD
VST NAV VST NAV VST NVV VST NVV VST NVV VST NVV
3.1.7
21,78 0,22 21,78 0,22 9,405 0,095 21,78 0,22 9,405 0,095 21,78 0,22
31, 35 31, 35 31, 34 31, 34 31, 35 31, 35 31, 35 31, 35 31 31 31 31
41
Odbitek DDV.8, 13, 17, 18
41
Odbitek DDV.8, 12, 17, 18
42
Odbitek DDV.8, 13, 17, 19
41
Odbitek DDV.8, 13, 17, 18
42
Odbitek DDV.8, 17, 19
41
Odbitek DDV.8, 17, 18
Validations and Substitutions
3.1.7.1 Validations – customizing and program changes For Slovenia 3 validations have been developed: - SIVFIH (Valid. of date in header text) - SIVVDC (Valid. of VAT date -> Document date or VATDATE) and - SIKIDNO (Validation of payment refer. -> KIDNO).
3.1.7.1.1
Validations SIVFIH and SIVVDC
These validations check: a) content of the field BKPF-VATDATE (in case that the field T001-XVATDATE is active - see Company code -> Global parameters in the FI part of IMG) or content of the field BKPF-BLDAT (in case that the field T001-XVATDATE is not active) against open VAT periods. b) Document date entered in the document header text (in the field BKPF-BKTXT) in the form „ddmmyy“ or „dd.mm.yyyy“ (in the case that the field T001-XVATDATE is not active (see Company code -> Global parameters in the FI part of IMG), Open periods are defined in the table /CCEE/FISI_DDVN, which can be maintained by the help of the transaction SM30:
These validations also check, that posted document which VAT date is in the closed period, can’t be reversed by the transaction FB08. Implementation process description: 1. Transaction GCX2 – check the program used for the validation (for Appl.area = GBLR):
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 37 / 175
In our example it is the program /CCEE/SIFI_RGGBR000. Program /CCEE/SIFI_RGGBR000 – perform following changes: In the part „FORM get_exit_titles TABLES etab.“ add new exits: exits-name = 'U101'. exits-param = c_exit_param_none. "Complete data used in exit. exits-title = text-101. "Validation of date format in header APPEND exits. exits-name = 'U102'. exits-param = c_exit_param_none. "Complete data used in exit. exits-title = text-102. "Validation of tax date APPEND exits. Below, in the form definition add new forms U101 and U102: *----------------------------------------------------------------------* * FORM U101 * *----------------------------------------------------------------------* * Check date in bktxt for Slovenien * *----------------------------------------------------------------------* * csls040518 - field BKPF-BKTXT in format DDMMYY*Custom proc./DDMMYY *********************************************************************** FORM u101 USING b_result. SELECT SINGLE * FROM t001 WHERE bukrs = bkpf-bukrs. "n1264280 IF t001-xvatdate IS INITIAL. IMPORT b_result FROM MEMORY ID 'J6S'. IF b_result NE b_false. * repeat the validation text. date for parked doc. DATA: pstr(10). DATA: pbktxt LIKE bkpf-bktxt. DATA pdat LIKE sy-datum. * DATA: lv_tail(10) TYPE c. "csls040518 "n1264280 *CSPS040526ins: IF bkpf-bktxt(1) EQ '/'. "format for 'D*' doc. type SHIFT bkpf-bktxt. ENDIF. *CSPS040526ins: SPLIT bkpf-bktxt AT '*' INTO pstr pbktxt. IF pbktxt IS INITIAL. SPLIT bkpf-bktxt AT ' ' INTO pstr pbktxt. ENDIF. SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 38 / 175
IF pstr CN './-+0123456789 ' OR pstr EQ space. b_result = b_false. ELSE. CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL' EXPORTING date_external = pstr EXCEPTIONS date_external_is_invalid = 1. IF sy-subrc 0. MESSAGE ID sy-msgid TYPE 'I' NUMBER sy-msgno WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4. b_result = b_false. ** Begin of change csls040518 * ELSE. "n1264280 * SPLIT pbktxt AT '/' INTO pbktxt lv_tail. "n1264280 * "n1264280 * IF NOT lv_tail IS INITIAL. "n1264280 * IF lv_tail CN './-+0123456789 '. "n1264280 * b_result = b_false. "n1264280 * ELSE. "n1264280 * CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL' "n1264280 * EXPORTING "n1264280 * date_external = lv_tail "n1264280 * IMPORTING "n1264280 * date_internal = pdat "n1264280 * EXCEPTIONS "n1264280 * date_external_is_invalid = 1 "n1264280 * OTHERS = 2. "n1264280 * IF sy-subrc NE 0. "n1264280 * b_result = b_false. "n1264280 * ELSE. "n1264280 * EXPORT b_true TO MEMORY ID 'J6S'. "n1264280 * ENDIF. "n1264280 * ENDIF. "n1264280 * ELSE. "n1264280 * EXPORT b_true TO MEMORY ID 'J6S'. "n1264280 * ENDIF. "n1264280 ** End of change csls040518 ENDIF. ENDIF. ELSE. * reset ABAP memory EXPORT b_true TO MEMORY ID 'J6S'. ENDIF. ELSE. "n1264280 * reset ABAP memory "n1264280 EXPORT b_true TO MEMORY ID 'J6S'. "n1264280 ENDIF. ENDFORM. *----------------------------------------------------------------------* * FORM U102 * *----------------------------------------------------------------------* * Check bldat for close period *----------------------------------------------------------------------* FORM u102 USING b_result. DATA: begda LIKE /ccee/fisi_ddvn-bldat, SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 39 / 175
endda LIKE /ccee/fisi_ddvn-bdatu. *CSPS040611ins: DATA: taxdt TYPE sy-datum. " tax date SELECT SINGLE * FROM t001 WHERE bukrs = bkpf-bukrs.
"n1264280
IMPORT b_result taxdt FROM MEMORY ID 'J6S'. IF t001-xvatdate IS INITIAL. "n1264280 IF taxdt IS INITIAL. IF bkpf-bktxt CS '/'. "mb050425 "n1264280 "need only date after / :-) "n1264280 SPLIT bkpf-bktxt AT '/' INTO bkpf-bktxt bkpf-bktxt. "n1264280 taxdt(4) = bkpf-bktxt+6(4). "n1264280 taxdt+4(2) = bkpf-bktxt+3(2). "n1264280 taxdt+6(2) = bkpf-bktxt(2). "n1264280 ELSE. "n1264280 * taxdt = bkpf-bldat. "n1264280 ENDIF. "n1264280 ENDIF. "mb050425 ELSE. "n1264280 IF taxdt IS INITIAL. "n1264280 taxdt = bkpf-vatdate. "n1264280 ENDIF. "n1264280 IF taxdt IS INITIAL. "n1264280 taxdt = bkpf-bldat. "n1264280 ENDIF. "n1264280 ENDIF. "n1264280 *CSPS040611ins. b_result = b_false. SELECT SINGLE bldat bdatu INTO (begda, endda) FROM /ccee/fisi_ddvn WHERE bukrs = bkpf-bukrs. IF sy-subrc IS INITIAL AND *CSPS040611 ( bkpf-bldat BETWEEN begda AND endda ). ( taxdt BETWEEN begda AND endda ). "CSPS040611 b_result = b_true. ENDIF. ENDFORM. *----------------------------------------------------------------------* 2. Transaction SE91: create 3 new messages in the message class /CCEE/FISI_MC1 e.g. messages 005, 009 and 010:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 40 / 175
3. Transaction OB28: create for your company code 2 new validations SIVFIH (for CallPnt = 1) and SIVVDC (for CallPnt = 3). Remark: company code SI01 serves here as an example ...
Content of individual validations: 3.1 Validation SIVFIH: 1. Step 1:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 41 / 175
2. Step 2:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 42 / 175
3. Used rules SIRFIH, SIRFIHD and SIRFIHA:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 43 / 175
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 44 / 175
Remark: the validation SIVFIH uses the user-exit U101 and Error messages 005 and 010 (from the message class = /CCEE/FISI_MC1). Rules described above serve as an example and can / must be changed on the project level ... 3.2 Validation SIVVDC: 4. Step 1:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 45 / 175
5. Step 2:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 46 / 175
6. Used rules SIRVVDCB and SIRVVDCA:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 47 / 175
Remark: the validation SIVVDC uses the user-exit U102 and Error messages 009 and 010 (from the message class = /CCEE/FISI_MC1). Rule described above serves as an example and can / must be changed on the project level ...
3.1.7.1.2
Validation SIKIDNO (Validation of payment refer.->KIDNO)
This validation checks that the field BSEG-KIDNO isn’t empty. Implementation process description: 1. Transaction SE91: create 1 new message in the message class /CCEE/FISI_MC1 e.g. messages 007:
2. Transaction OB28: create for your company code 1 new validation SIKIDNO (for CallPnt = 2). Remark: company code SI01 serves here as an example ...
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 48 / 175
Content of the validation:
3.1.7.2 Substitutions – customizing and program changes For Slovenia 2 substitutions have been developed: - SISFIH2 and SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 49 / 175
-
SISFIC.
This substitution supply: a) formatting of date in header text (substitution SISFIH2) b) BKTXT date format, tax date change (substitution SISFIC) Implementation process description: 1. Transaction GCX2 – check the program used for the substitution (for Appl.area = GBLS):
In our example it is the program /CCEE/SIFI_RGGBS000. Program /CCEE/SIFI_RGGBS000 – perform following changes: In the part „FORM get_exit_titles TABLES etab.“ add new exits: exits-name = 'U101'. exits-param = c_exit_param_none. exits-title = text-100. " Tax append exits.
date
into
BKTXT
(verify
and
format)
exits-name = 'U103'. exits-param = c_exit_param_none. exits-title = text-103. "Tax date into BKTXT (verify and format), "field BKPF-BKTXT in format /DDMMYY append exits. Below, in the form definition add new forms U101, U103: *---------------------------------------------------------------------* * FORM U101 * *---------------------------------------------------------------------* form u101. data: b_result. data: pstr(10). data: pbktxt like bkpf-bktxt. data pdat like sy-datum. select single * from t001 where bukrs = bkpf-bukrs. "n1264280 if t001-xvatdate is initial. "n1264280 search bkpf-bktxt for '/'. if sy-subrc = 0. search bkpf-bktxt for '**'. if sy-subrc ne 0. replace '/' with '*/' into bkpf-bktxt. endif. endif. split bkpf-bktxt at '*' into pstr pbktxt. if pbktxt is initial. SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 50 / 175
split bkpf-bktxt at ' ' into pstr pbktxt. endif. if pstr cn './-+0123456789 ' or pstr eq space. b_result = b_false. else. call function 'CONVERT_DATE_TO_INTERNAL' exporting date_external = pstr importing date_internal = pdat exceptions date_external_is_invalid = 1 others = 2. if sy-subrc 0. if sy-subrc = 1. message id sy-msgid type 'I' number sy-msgno with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4. endif. else. write pdat to pstr. clear pdat. concatenate pstr pbktxt into bkpf-bktxt separated by '*'. b_result = b_true. endif. endif. else. "n1264280 b_result = b_true. endif. "n1264280 export b_result taxdt from pdat to memory id 'J6S'. endform.
"n1264280
*---------------------------------------------------------------------* * FORM U103 * *---------------------------------------------------------------------* form u103. data: b_result. data: pstr(10). data: pstr11(11). data: pbktxt like bkpf-bktxt. data pdat like sy-datum. select single * from t001 where bukrs = bkpf-bukrs. "n1264280 if t001-xvatdate is initial. "n1264280 if bkpf-bktxt(1) eq '/'. "format for 'D*' doc. type shift bkpf-bktxt. endif. split bkpf-bktxt at '*' into pstr pbktxt. if pbktxt is initial. split bkpf-bktxt at ' ' into pstr pbktxt. endif. if pstr cn './-+0123456789 ' or pstr eq space. b_result = b_false. else. call function 'CONVERT_DATE_TO_INTERNAL' SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 51 / 175
exporting date_external = pstr importing date_internal = pdat exceptions date_external_is_invalid = 1 others = 2. if sy-subrc 0. if sy-subrc = 1. message id sy-msgid type 'I' number sy-msgno with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4. endif. else. write pdat to pstr. concatenate '/' pstr into pstr11. concatenate pstr11 pbktxt into bkpf-bktxt separated by '*'. b_result = b_true. endif. endif. else. "n1264280 b_result = b_true. "n1264280 endif. "n1264280 export b_result to memory id 'J6S'. export b_result taxdt from pdat to memory id 'J6S'. endform. 2. Transaction OBBH: create for your company code 2 new substitutions SISFIH2 (for CallPnt = 1) and SISFIC (for CallPnt = 3). Remark: company code SI01 serves here as an example ...
Content of individual substitutions: 2.1 Substitution SISFIH2: 7. Step 1:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 52 / 175
8. Step 2:
9. Used rules SIRFIHD:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 53 / 175
Remark: The substitution SISFIH2 uses the user-exits U101 and U103. Rules described above serve as an example and can / must be changed on the project level ... 2.2 Substitution SISFIC: 10. Step 1:
11. Rule SISFIC:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 54 / 175
Remark: The substitution SISFIC uses the user-exit U101. Rule described above serves as an example and can / must be changed on the project level ...
3.2
IMG settings to be done by company
3.2.1
Company code settings
Transaction OBY6: - field VAT registration no. and Address is used for reporting to the tax authorities, - field Telephone is displayed in the EC Sales List.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 55 / 175
3.2.2
Assign Company Code to Document Date for Tax Determination
IMG Financial Accounting Financial Accounting Global Settings Tax on Sales/Purchases Calculation Assign Company Code to Document Date for Tax Determination
3.2.3
Define Tax Accounts
Define Tax Accounts for Transactions: ESA, ESE, MWS and VST.
IMG Financial Accounting Financial Accounting Global Settings Sales/Purchases Posting Define Tax Accounts
3.2.4
Assign Tax Codes for Non-Taxable Transactions
IMG Financial Accounting Global Settings Tax on Sales/Purchases Tax Codes for Non-Taxable Transactions (Transaction OBCL)
SAP d.o.o.
Tax on
Phone: +386 (1) 5881 255
Posting
Assign
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 56 / 175
3.2.5
Down Payment Received
For every special G/L indicator, which is relevant for VAT, define Output tax clearing and Tax Account.
IMG Financial Accounting Accounts Receivable and Accounts Payable Business Transactions Down Payment Received Define Reconciliation Accounts for Customer Down Payments (Transaction OBXR)
IMG Financial Accounting Accounts Receivable and Accounts Payable Business Transactions Down Payment Received Define Tax Accounts for Tax Clearing (Transaction OBXB)
3.2.6
Define Tax on Sales/Purchases Groups
IMG Financial Accounting General Ledger Accounting Business Transactions Closing Reporting Sales/Purchases Tax Returns Define Tax on Sales/Purchases Groups (Transaction OBCF) SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 57 / 175
Field Form (T007F-FORMU) should be maintained with the form /CCEE/SIFI_DDV13S. Field Adv. Ret. Tax. No. T007F-UMSNR should be maintained with the company ID VAT.
3.2.7
Assign Company Codes to Tax on Sales/Purchases Groups
IMG Financial Accounting General Ledger Accounting Business Transactions Closing Reporting Sales/Purchases Tax Returns Assign Company Codes to Tax on Sales/Purchases Groups (Transaction OBC6)
3.2.8
Define Accounts for Automatic Tax Payable Transfer Posting
IMG Financial Accounting General Ledger Accounting Business Transactions Closing Reporting Sales/Purchases Tax Returns Define Accounts for Automatic Tax Payable Transfer Posting s (Transaction OB89)
-
If you want to post Tax payable posting direct on Vendor instead of on G/L account you should: define posting keys 21 (Debit) and 31 (Credit) for the transaction key 'UMS' (instead of 40 and 50) in transaction OB89
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 58 / 175
-
define Vendor in Tax report program parameters (program RFUMSV00)
3.2.9
Plants Abroad
Use SAP standard solution (SAP Note 63103, ...)
3.3
Vendor/customer master data
VAT Identification number is entered into the field VAT reg. no. (LFA1-STCEG/KNA1-STCEG).
In case the vendor/customer has identified himself with more VAT reg. no. in different EU member countries, these is entered into the table, which is shown after clicking on the button More.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 59 / 175
3.4
Posting VAT relevant documents
3.4.1
Open/close tax period
For opening and closing tax period can be used the table /CCEE/FISI_DDVN.
Control on the opening Tax period and Tax date check in header text is supported by substitutions (GGB1) and validations (GGB0).
3.4.2
Down payments
Customer down payments (received) Down payment is paid by customer based on proforma and posted on the proper customer reconciliation G/L account with Special G/L indicator. VAT is calculated and posted immediately when the down payment is received with the relevant tax code. Vendor down payments (given) Down payment is paid to vendor based on proforma and post on the proper vendor reconciliation G/L account with Special G/L indicator. VAT can be calculated and posted immediately when the down payment is given or when “down payment confirmation/avansni ra un” is received by vendor (domestic). Here are described three possible procedures of posting vendor down payments in accordance with Slovenian Tax legislation. A. Procedure of processing Down payment to vendor (domestic), when invoice is not received before VAT period is closed and vendor issue down payment confirmation: 1. Create Request for Down payment (Transaction F-47) and post on technical G/L account (e.g. 1309*) with special G/L indicator, define Tax code XV and activate Calculate tax.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 60 / 175
Special G/L indicator has to be created without Input tax clearing definition and the Special G/L account is the same as Reconciliation acct. in Transaction OBYR (e.g. Special G/L account and Reconciliation acct. is 220*). 2. Posting Down payment on Special G/L acct. (e.g. 130*) with Special G/L indicator and bank G/L acct. (e.g. 110*) in transaction F110 or F-48. 3. Posting Down payment confirmation with transaction F-51 (Transfer posting with clearing) till the end of the VAT period with Special G/L indicator, Posting Key 29 on vendor Special G/L acct. (e.g. 130*), define relevant Tax code, activate Calculate tax and close the Down payment (from point 2; e.g. 220*). Special G/L indicator has to be created with Input tax clearing definition and the Special G/L account is G/L account for Sending Down payments in Transaction OBYR (e.g. Special G/L account is 130* and Reconciliation acct. is 220*). In the transaction OBXB you also should define G/L account for procedure VVA (e.g. G/L acct. 295*). 4. Further posting is done in the same way as the regular down payment: Normal posting of the invoice. Closing of the down payment and invoice with transaction F-44 (e.g. vendor open line item on Reconciliation acct. 220* and 130*). B. Procedure of processing Down payment to vendor (domestic), when invoice is received before VAT period is closed: 1. Create Request for Down payment (Transaction F-47) and post on technical G/L account (e.g. 1309*) with special G/L indicator, define Tax code XV and activate Calculate tax. Special G/L indicator has to be created without Input tax clearing definition and the Special G/L account is the same as Reconciliation acct. in Transaction OBYR (e.g. Special G/L account and Reconciliation acct. is 220*). 2. Posting Down payment on Special G/L acct. (e.g. 220*) with Special G/L indicator and bank G/L acct. (e.g. 110*) in transaction F110 or F-48. 3. Further posting is done in the same way as the regular down payment: Normal posting of the invoice. Closing of the down payment and invoice with transaction F-44 (e.g. vendor open line items on Reconciliation acct. 220*). C. Procedure of processing Down payment to vendor (foreign): 1. Create Request for Down payment (Transaction F-47) and post on technical G/L account (e.g. 1309*) with special G/L indicator, without Tax code and Calculate tax. Special G/L indicator has to be created without Input tax clearing definition. Special G/L account is the G/L account for Sending Down payments in Transaction OBYR (e.g. Special G/L account is 1301* and Reconciliation acct. is 221*). 2. Posting Down payment on Special G/L acct. (e.g. 1301*) with Special G/L indicator and bank G/L acct. (e.g. 110*) in transaction F110 or F-48. 3. Further posting is done in the same way as the regular down payment: Normal posting of the invoice. Closing of the down payment and invoice.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 61 / 175
3.4.3
Acquisition Tax Accruals on the 15.-th in the month
Solution is described in SAP Note 789853 Acquisition Tax Accruals.
3.4.4
Posting EUL documents
EUL (Enotna upravna listina; import and export declaration) documents should be processed differently because the tax processing should be based on dates from EUL documents and not invoices. For this purpose should be defined Reconciliation G/L account for vendor (for separate posting VAT) and General G/L account. Special G/L indicator for Vendor reconciliation G/L account should be also defined. -
Procedure for posting import EUL: o Opening of the dummy vendor (e.g. Customs office) with the out of balance reconciliation account; o Opening of two additional document types for EUL and reverse posting of EUL; o The posting procedure is as follows: - posting of ECL with dummy vendor and out of balance offsetting accounts - with relevant tax code (transaction FB60), - posting of the customs invoice (real vendor) with XV tax code and real account (transaction FB60), - posting of credit memo with reference to EUL (reverse posting) - with tax code XV - automatic clearing (transaction F.13).
-
Procedure for posting export EUL: o Opening of the dummy customer for export (e.g. Customs office) with the out of balance reconciliation account; o Opening of two additional document types for EUL and reverse posting of EUL; o The posting procedure is as follows: - posting of export invoice without tax code (standard procedure), - posting of EUL with dummy customer with reference to the export invoice and out of balance offsetting accounts - with relevant tax code;(transaction FB70), - posting of credit memo with reference to EUL (reverse posting)- with tax code XV (transaction FB75), - automatic clearing (transaction F.13).
3.4.5
Reverse charge postings
In case that date of Goods Receipt and Invoice Issue is in the same tax period but the date of Invoice Receipt is in the next tax period Reverse charge postings according to Slovenian tax legislation should be done in the following way: The output part of the input tax should be calculated on the Invoice Issue date, where on the other hand, the input part of input tax on the incoming invoice (from EU) should be calculated on the Invoice Receipt date. Due to the fact, that the tax report and the general ledger have to be in balance, the above mentioned posting procedure means posting in two different posting periods – two different postings per one incoming invoice. For separate posting of liabilities and debt from input tax where, special tax codes (e.g. UA, UB, ...) should be defined using Transaction key ESA and ESE or ESE, ESE and NAV for posting non-deductible VAT on interim GL account (in that case you avoid problem to clear Interim GL acct. When create Batch input session in RFUMSV00). Here are described possible procedures for separate posting of liabilities and debt from input tax in accordance with Slovenian Tax legislation: 1. Posting the output part of the input tax in the first tax period as special tax relevant document (2 possibilities): a) Using technical GL acct. SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 62 / 175
In this case you need to fill BSEG-LIFNR into this GL acct. Using Substitutions (if not then data about vendor won’t be available in Tax books).
or b) Using Vendor and Technical GL acct. In this case you need to define: - Reconciliation G/L account for vendor and General G/L account, - Special G/L indicator for Vendor reconciliation G/L account.
2. In the second period: a) Invoice is posted with the regular tax codes (input and output tax is posted). Special tax relevant document posted in the first tax period has to be reversed (do not reverse doc. with tran. FB08 because on the reverse doc. Tax reporting date has to be changed with the tax relevant date from Invoice – you can use Post with reference and then select Generate reverse posting) or b) Invoice is posted with the special tax codes UX, UY, UZ, UQ and UW that only input tax is posted.
3.4.6
Posting document of Triangular deal
When you enter a document, there are three fields that are significant for Triangular deal: Reporting Country for Delivery of Goods within the EU; it means Country in which the customer acquired a VAT registration number (VAT reg.no.). Every VAT reg.no. of the business partner must be stored under the corresponding reporting country in the master record, VAT reg. number and Indicator: Triangular deal within the EU; If you select the Indicator: Triangular deal within the EU, the system includes this transaction in the EC sales list under the triangular deal section.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 63 / 175
After the country has been entered, VAT reg. number of the selected is automatically shown. It is important that under this country in business master data VAT reg. number exists, otherwise the system issues an error. In the tax report the VAT reg. number from the document is displayed in case it differs from the one from the home country, otherwise the VAT reg. number of the home country is taken from the master data. In it obligatory to report on the business transactions, where the vendor identifies himself with a different VAT ID number (not the one from his home country). With the new member states, on the vendor side a SAP Note 729863 for FI and 730751 for MM have to be implemented, which support the above mentioned functionality. The same functionality on the customer side is part of standard SAP and no additional notes need to be imported.
IMG Financial Accounting Financial Accounting Global settings Document Change Rules, Line Item
Document
Line Item
Here you make the settings for EU Tax data on reconciliation account for vendors as optional entries in order to get a display of relevant fields on posting transactions.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 64 / 175
IMG Financial Accounting Accounts Receivable and Accounts Payable Business Transactions Incoming Invoices/Credit memos Carry Out and Check Document Settings Maintain Field Status Variants Here you should define that the fields BSEG-XEGDR and RF05L-EGMLD can be changing during posting.
3.5
VAT information system
3.5.1
Tax Reports
To prepare Tax reports use SAP standard program RFUMSV00 (tran. S_ALR_87012357 Advance Return for Tax on Sales/Purchases). This program creates the advance return for tax on sales/purchases, and, if required, also creates a batch input session for automatic transfer posting of tax payable. The program can also fill out the tax return if required. You can display the return at line item level for each tax type (output and input tax). Note howSAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 65 / 175
ever, that even when you suppress the line item information, the data is still taken from the individual documents. With this program is also covered local requirement by Tax authority to create file structured by Tax Authority with Input/Output VAT data. For creating file structured by Tax Authority see also SAP Note 1110117, 1128932 and 1418291. Based on the selected PROCEDURE 1 or 2 it is necessary to define relevant parameters during execution the Tax report: - PROCEDURE 1 – Document date is VAT relevant date: On the selection screen you should define Document date; this is the tax period for tax calculation. - PROCEDURE 2 – Tax Reporting Date: On the selection screen you should define Tax Reporting Date; this is the tax period for tax calculation. You can also define parameters for: Tax form DDV-O preparation:
The form DDV-O will be prepared just in case that the tax period is define from the first to the last day in the month. creating files with Input/Output VAT data, structured by Tax Authority: o Create DME file: activate, o Format tree: select SI_TB-INC for Input VAT data between 1.1.2008 and 31.12.2009 or SI_TB-INC10 for Input VAT from 1.1.2010 onwards or SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 66 / 175
o
SI_TB-INC111 for Input VAT from 1.1.2010 onwards, SI_TB-OUT for Output VAT data between 1.1.2008 and 31.12.2009 or SI_TB-OUT10 for Output VAT data from 1.1.2010 onwards or SI_TB-OUT112 for Output VAT data from 1.1.2010 onwards. File name: define file name. .
Tax report includes two different type of files, but you can create only ONE at the same time. Because of this reason only ONE "Output list" can be checked in connection with Format tree and that file will be made. It is strongly recommended that you: - activate only check box Select input tax when you execute SI_TB-INC or SI_TB-INC10 or SI_TBINC11 (Tax Book for Incoming Invoices) and Select output tax when you execute SI_TB-OUT or SI_TB-OUT10 or SI_TB-OUT11 (Tax Book for Outgoing Invoices). DO NOT TICK OFF BOTH CHECK BOXES! - define only all relevant tax codes for VAT reporting (otherwise line items without amounts will be included in txt files) - some tax codes are defined with MWS but they have to be reported (also) in Tax Book for incoming Invoices (e.g. B5, Q7, Q8; at some suctomers also U7 and U8). In such cases you should execute the report separately with DMEE definition for Incoming invoices and “Only output tax”. The created DMEE file will be written to the file system. You can use program RFASLDPC to download the created files onto a disk or the hard drive of your PC:
1 2
For details see SAP Note 1568006 For details see SAP Note 1568006
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 67 / 175
By tax authority is also required file with whole GL data in predefined format. This part is covered by program Export GL line items /CCEE/SIFI_EXPORT_GL_LINE. 12. Relevant for DME Format trees SI_TB-INC, SI_TB-INC10, SI_TB-OUT and SI_TB-OUT10: Mapping rules in table /CCEE/FISITAX must be done for creating files with Input/Output VAT data, structured by Tax Authority: - If customer’s tax codes are different from codes from SI FI localization template, mapping must be done - For Tax codes valid from 01.07.2013 (VAT rate 22% and 9,5%) The table includes the following fields: - Company code (BUKRS) - Transaction key (KTOSL), transaction key, which is used at customer (destination tran. key) - Tax code (MWSKZFR); tax code, which is used at customer (destination tax code) - Tax code (MWSKZTO); tax code, which is default and must be converted to the customer’s tax code (source tax code) - Transaction key (KTOSLTO); transaction key, which is default and must be converted to the customer’s tran. key (source tran. key) Transaction SM30 -> Table /CCEE/FISITAX:
Content of table with mapping rules for Tax codes valid from 01.07.2013 (VAT rate 22% and 9,5%): KTOSL
MWSKZFR
MWSKZTO
KTOSLTO
ESA
E0
U0
ESA
ESA
E1
U1
ESA
ESA
E2
U2
ESA
ESA
E3
U5
ESA
ESA
E4
U6
ESA
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 68 / 175
ESA
E5
U7
ESA
ESA
E6
U8
ESA
ESA
E7
U9
ESA
ESA
EA
UA
ESA
ESA
EB
UB
ESA
ESA
EC
UC
ESA
ESA
ED
UD
ESA
ESA
EE
UE
ESA
ESA
EN
UN
ESA
ESA
EQ
UQ
ESA
ESA
ES
US
ESA
ESA
EW
UW
ESA
ESA
EX
UX
ESA
ESA
EY
UY
ESA
ESA
EZ
UZ
ESA
ESA
F5
F1
ESA
ESA
F6
F2
ESA
ESA
R0
T0
ESA
ESA
R1
T1
ESA
ESA
R2
T2
ESA
ESA
R3
T3
ESA
ESA
R4
T4
ESA
ESA
R5
T5
ESA
ESA
RG
RA
ESA
ESA
RH
RB
ESA
ESA
RI
RC
ESA
ESA
RJ
RD
ESA
ESA
RK
RE
ESA
ESA
RQ
RF
ESA
ESA
RS
RL
ESA
ESA
RT
RM
ESA
ESA
RU
RN
ESA
ESA
RV
RO
ESA
ESA
RW
RP
ESA
ESA
RZ
RR
ESA
ESA
TE
T6
ESA
ESA
TF
T7
ESA
ESA
TG
T8
ESA
ESA
TH
T9
ESA
ESA
TI
TA
ESA
ESA
TJ
TB
ESA
ESA
TK
TC
ESA
ESA
TQ
TD
ESA
ESE
E1
U1
ESE
ESE
E2
U2
ESE
ESE
E3
U5
ESE
ESE
E4
U6
ESE
ESE
E5
U7
ESE
ESE
E6
U8
ESE
ESE
E7
U9
ESE
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 69 / 175
ESE
EA
UA
ESE
ESE
EB
UB
ESE
ESE
EC
UC
ESE
ESE
ED
UD
ESE
ESE
EE
UE
ESE
ESE
EQ
UQ
ESE
ESE
EW
UW
ESE
ESE
EX
UX
ESE
ESE
EY
UY
ESE
ESE
EZ
UZ
ESE
ESE
F5
F1
ESE
ESE
F6
F2
ESE
ESE
R0
T0
ESE
ESE
R1
T1
ESE
ESE
R2
T2
ESE
ESE
R3
T3
ESE
ESE
R4
T4
ESE
ESE
R5
T5
ESE
ESE
RG
RA
ESE
ESE
RH
RB
ESE
ESE
RI
RC
ESE
ESE
RJ
RD
ESE
ESE
RK
RE
ESE
ESE
RQ
RF
ESE
ESE
RS
RL
ESE
ESE
RT
RM
ESE
ESE
RU
RN
ESE
ESE
RV
RO
ESE
ESE
RW
RP
ESE
ESE
RZ
RR
ESE
ESE
TE
T6
ESE
ESE
TF
T7
ESE
ESE
TG
T8
ESE
ESE
TH
T9
ESE
ESE
TI
TA
ESE
ESE
TJ
TB
ESE
ESE
TK
TC
ESE
ESE
TQ
TD
ESE
MWS
B6
B1
MWS
MWS
B7
B2
MWS
MWS
B3
MWS
MWS
B8 B9
B4
MWS
MWS
BA
B5
MWS
MWS
C9
C5
MWS
MWS
CA
C6
MWS
MWS
J3
J1
MWS
MWS
J4
J2
MWS
NAV
PG
P7
NAV
NAV
PH
P8
NAV
NVV
E0
U0
NVV
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 70 / 175
NVV
EN
UN
NVV
NVV
ES
US
NVV
NVV
PA
P1
NVV
NVV
PB
P2
NVV
NVV
PC
P3
NVV
NVV
PD
P4
NVV
NVV
PE
P5
NVV
NVV
PF
P6
NVV
VST
PA
P1
VST
VST
PB
P2
VST
VST
PC
P3
VST
VST
PD
P4
VST
VST
PE
P5
VST
VST
PF
P6
VST
VST
PG
P7
VST
VST
PH
P8
VST
VST
SA
S1
VST
VST
SB
S2
VST
VST
SC
S3
VST
VST
SD
S4
VST
VST
SE
S5
VST
VST
ZA
Z1
VST
VST
ZB
Z2
VST
VST
ZC
Z3
VST
VST
ZD
Z4
VST
VST
ZE
Z5
VST
VST
ZF
Z6
VST
VST
ZG
ZN
VST
13. Relevant for DME Format trees SI_TB-INC11 and SI_TB-OUT11: In the table /CCEE/FISITCA you determine the positions of tax amounts in the tax book for incoming or outgoing invoices files. You assign each tax code to a character position set. A character position set corresponds to the character positions in the resulting tax book file, which are stipulated by the tax authority. The table includes the following fields: - Company code (BUKRS) - Payment Type – Input or Output (PAYTYPE) - Node/Position Number (NODE) - Tax Code (MWSKZ) - Transaction Key (KTOSL) - Type of Amount (GETAMOUNT) to be used – e.g. Tax Base Amount, Tax Amount, etc. - Percentage Coefficient (KOEF) to be multiplied by – requested amount is multiplied by this value. If it’s not filled in, amount is not changed. Examples: -100,000 means, amount is multiplied by -1 8,500 means, amount is multiplied by 0,0085 - 8,5 % The character position sets for tax book file are different depending on whether incoming or outgoing invoice data is used:
Tax Book for Incoming Invoices: SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 71 / 175
Character Position Set
From Position
To Position
8
136
151
Use
9
153
168
Tax base amount (Amount without tax) Tax base amount from goods and services in Slovenia (reverse charge)
10
170
185
Tax base amount for inbound deliveries for goods
11
187
202
Tax base amount for received services
12
204
219
Tax base amount for real estate
13
221
236
Tax base amount for assets
14
238
253
Exempt input tax
15
255
270
Exempt input tax on real estate
16
272
287
Exempt input tax on assets
17
289
304
Non-deductible tax
18
306
321
Input tax, 20% rate
19
323
338
Input tax, 8,5% rate
20
340
355
Flat rate compensation
Tax Book for Outgoing Invoices Character Position Set
From Position
To Position
7
127
142
Amount of deliveries and services
8
144
159
Amount of deliveries and sevices in SIovenia
Use
9
161
176
Amount of output tax without deduction
10
178
193
Amount of exempt output tax EU
11
195
210
Triangular deliveries in EU
12
212
227
Amount of exempt output tax for other goods in EU
13
229
244
Sales goods including assembling
14
246
261
Output tax, 20% rate
15
263
278
Output tax, 8,5% rate
16
280
295
Amount of output tax 20% for goods received from EU
17
297
312
Amount of output tax 20% for services received from EU
18
314
329
Amount of output tax 8,5% for goods received from EU
19
331
346
Amount of output tax 8,5% for services received from EU
20
348
363
Amount of acquisition output tax 20% (ESA)
21
365
380
Amount of acquisition output tax 8,5% (ESA)
22
382
397
Output tax from import (reverse charge)
23
399
414
Deductible tax for deliveries outside Slovenia
An example of entries in the table for Slovenian Tax code template: BUKRS SI01 SI01 SI01 SI01 SI01 SI01 SI01
PAYTYPE O O O O O O O
SAP d.o.o.
NODE 09 07 07 23 07 15 07
MWSKZ A0 A5 A6 A7 B1 B1 B2
KTOSL
MWS
Phone: +386 (1) 5881 255
GETAMOUNT HWBAS HWBAS HWBAS HWBAS HWBAS HWSTE HWBAS
KOEF 0,000 0,000 0,000 0,000 0,000 0,000 0,000
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 72 / 175
SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01
O O O O O I O O O O O O O O I O O O O O O O O O O O O I I O I I O I I O I I I O I I I O I I O O I I O O I I O I O I O I O I I O I I O I
SAP d.o.o.
14 07 15 07 14 08 22 15 07 14 07 15 07 14 08 22 11 10 13 12 10 07 15 07 14 08 10 10 17 16 10 19 18 10 18 16 10 13 19 18 10 13 18 16 10 10 18 18 10 10 16 16 08 18 20 10 16 10 18 08 20 10 13 16 10 13 18 10
B2 B3 B3 B4 B4 B5 B5 B6 B7 B7 B8 B8 B9 B9 BA BA C0 C1 C2 C3 C4 C5 C5 C6 C6 C7 C8 E0 E0 E0 E1 E1 E1 E2 E2 E2 E3 E3 E3 E3 E4 E4 E4 E4 E5 E5 E5 E5 E6 E6 E6 E6 E7 E7 E7 EA EA EB EB EC EC ED ED ED EE EE EE EN
MWS MWS MWS MWS MWS MWS MWS MWS MWS
MWS MWS
ESA ESE
ESA
ESE
ESA MWS ESA MWS MWS ESA MWS
ESA
ESA
Phone: +386 (1) 5881 255
HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS HWBAS HWBAS HWBAS HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS HWBAS HWSTE HWSTE HWBAS HWSTE HWSTE HWBAS HWSTE HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWSTE HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS
0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 -100,000 0,000 0,000 0,000 -100,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 73 / 175
SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01
I O I I I O I I I I I I O I I O I I I O I I I O I I O I I O O O O O O O O O I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I
SAP d.o.o.
17 18 18 08 17 20 19 18 19 18 08 19 21 08 18 20 08 17 19 21 08 17 18 20 08 19 21 08 18 20 07 15 07 14 07 15 07 14 14 15 14 16 08 17 08 17 08 13 17 08 13 17 08 17 08 17 08 13 17 08 13 17 08 17 08 17 08 13
EN EN EQ ES ES ES EW EX EY EZ F1 F1 F1 F2 F2 F2 F3 F3 F3 F3 F4 F4 F4 F4 F5 F5 F5 F6 F6 F6 J1 J1 J2 J2 J3 J3 J4 J4 O6 O6 O7 O7 P1 P1 P2 P2 P3 P3 P3 P4 P4 P4 P5 P5 P6 P6 P7 P7 P7 P8 P8 P8 PA PA PB PB PC PC
ESE ESE
ESE
ESE
MWS MWS MWS MWS
Phone: +386 (1) 5881 255
HWSTE HWSTE HWSTE HWBAS HWSTE HWSTE HWSTE HWSTE HWSTE HWSTE HWBAS HWSTE HWSTE HWBAS HWSTE HWSTE HWBAS HWNAF HWSTEAA HWSTE HWBAS HWNAF HWSTEAA HWSTE HWBAS HWSTE HWSTE HWBAS HWSTE HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS HWBAS HWBAS HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS
0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 74 / 175
SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01
I I I I I I I I I I I I I I I I I I I I I O I I I O I I I I O I I I I O I O I O I I I O I I I O I I I O I I I I O I I I I O I I I I O I
SAP d.o.o.
17 08 13 17 08 17 08 17 08 13 17 08 13 17 08 20 08 17 10 17 19 18 10 17 18 16 10 13 17 19 18 10 13 17 18 16 10 18 10 16 08 17 18 20 11 17 18 17 11 17 19 19 11 12 17 18 17 11 12 17 19 19 11 13 17 18 17 11
PC PD PD PD PE PE PF PF PG PG PG PH PH PH PN PN PP PP Q1 Q1 Q1 Q1 Q2 Q2 Q2 Q2 Q5 Q5 Q5 Q5 Q5 Q6 Q6 Q6 Q6 Q6 Q7 Q7 Q8 Q8 Q9 Q9 Q9 Q9 QA QA QA QA QB QB QB QB QC QC QC QC QC QD QD QD QD QD QE QE QE QE QE QF
ESE ESA
ESE ESA MWS MWS
ESE
ESA
ESE
ESA
ESE
Phone: +386 (1) 5881 255
HWSTE HWBAS HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS HWBAS HWNAF HWSTEAA HWSTE HWBAS HWNAF HWSTEAA HWSTE HWBAS HWBAS HWNAF HWSTEAA HWSTE HWBAS HWBAS HWNAF HWSTEAA HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWNAF HWSTEAA HWSTE HWBAS HWNAF HWSTEAA HWSTE HWBAS HWNAF HWSTEAA HWSTE HWBAS HWBAS HWNAF HWSTEAA HWSTE HWBAS HWBAS HWNAF HWSTEAA HWSTE HWBAS HWBAS HWNAF HWSTEAA HWSTE HWBAS
0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 8,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 75 / 175
SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01
I I I O I I I O I I I O I I I I O I I I I O I I I I O I I I I O I I I O I I I O I I O I I O I I I O I I I O I I I O I I I O I I I I I I
SAP d.o.o.
13 17 19 19 09 17 18 20 09 17 19 21 09 12 17 18 20 09 12 17 19 21 09 13 17 18 20 09 13 17 19 21 09 17 18 20 09 17 19 21 11 18 17 11 19 19 11 12 18 17 11 12 19 19 11 13 18 17 11 13 19 19 18 19 18 19 18 19
QF QF QF QF QG QG QG QG QH QH QH QH QI QI QI QI QI QJ QJ QJ QJ QJ QK QK QK QK QK QL QL QL QL QL QM QM QM QM QN QN QN QN R0 R0 R0 R1 R1 R1 R2 R2 R2 R2 R3 R3 R3 R3 R4 R4 R4 R4 R5 R5 R5 R5 RA RB RC RD RE RF
ESA ESE ESE ESE
ESE
ESE ESE
ESE
ESE ESE
ESE ESE ESE
ESE
ESE ESA
ESE
ESE ESA
ESE
ESE ESA ESE ESE ESE ESE ESE ESE
Phone: +386 (1) 5881 255
HWBAS HWNAF HWSTEAA HWSTE HWBAS HWNAF HWSTEAA HWSTE HWBAS HWNAF HWSTEAA HWSTE HWBAS HWBAS HWNAF HWSTEAA HWSTE HWBAS HWBAS HWNAF HWSTEAA HWSTE HWBAS HWBAS HWNAF HWSTEAA HWSTE HWBAS HWBAS HWNAF HWSTEAA HWSTE HWBAS HWNAF HWSTEAA HWSTE HWBAS HWNAF HWSTEAA HWSTE HWBAS HWSTEAA HWSTE HWBAS HWSTE HWSTE HWBAS HWBAS HWSTEAA HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWBAS HWSTEAA HWSTE HWBAS HWBAS HWSTE HWSTE HWSTEAA HWSTE HWSTEAA HWSTE HWSTEAA HWSTE
0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 76 / 175
SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01
I I I I I I O I O I I O I I O I I O I I I O I O I O I I O I I O I I O I I O I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I
SAP d.o.o.
18 19 18 19 18 11 17 11 19 11 12 17 11 12 19 11 13 17 19 11 13 19 11 17 11 19 11 12 17 11 12 19 11 13 17 11 13 19 08 13 19 08 13 18 08 12 18 08 13 19 08 13 18 19 18 08 13 19 08 13 18 08 12 18 08 13 19 08
RG RH RI RJ RK RL RL RM RM RN RN RN RO RO RO RP RP RP RQ RR RR RR RS RS RT RT RU RU RU RV RV RV RW RW RW RZ RZ RZ S1 S1 S1 S2 S2 S2 S3 S3 S3 S4 S4 S4 S5 S5 S5 S6 S7 SA SA SA SB SB SB SC SC SC SD SD SD SE
ESE ESE ESE ESE ESE ESA ESA
ESA
ESA
ESA ESE
ESA ESA ESA
ESA
ESA
ESA
ESA
Phone: +386 (1) 5881 255
HWSTEAA HWSTE HWSTEAA HWSTE HWSTEAA HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWSTE HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS
0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 77 / 175
SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01
I I I I O I I O I I I O I I I O I I I O I I I O I I O I I O I I I O I I I O I I I O I I I O I I O I I O I I O I I O I I I O I I I O I I
SAP d.o.o.
13 18 11 18 17 11 19 19 11 12 18 17 11 12 19 19 11 13 18 17 11 13 19 19 09 18 20 09 19 21 09 12 18 20 09 12 19 21 09 13 18 20 09 13 19 21 09 18 20 09 19 21 09 18 20 09 19 21 09 12 18 20 09 12 19 21 09 13
SE SE T0 T0 T0 T1 T1 T1 T2 T2 T2 T2 T3 T3 T3 T3 T4 T4 T4 T4 T5 T5 T5 T5 T6 T6 T6 T7 T7 T7 T8 T8 T8 T8 T9 T9 T9 T9 TA TA TA TA TB TB TB TB TC TC TC TD TD TD TE TE TE TF TF TF TG TG TG TG TH TH TH TH TI TI
ESE
ESE ESA
ESE
ESE ESA
ESE
ESE ESA ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE ESE
Phone: +386 (1) 5881 255
HWBAS HWSTE HWBAS HWSTEAA HWSTE HWBAS HWSTE HWSTE HWBAS HWBAS HWSTEAA HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWBAS HWSTEAA HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWSTEAA HWSTE HWBAS HWSTE HWSTE HWBAS HWBAS HWSTEAA HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWBAS HWSTEAA HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWSTEAA HWSTE HWBAS HWSTE HWSTE HWBAS HWSTEAA HWSTE HWBAS HWSTE HWSTE HWBAS HWBAS HWSTEAA HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWBAS
0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 78 / 175
SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01
I O I I I O I I O I I O I I O I I O I I O I I I I I O I I I O I I O O I I O O I I O I O I O I O I I O I I O I I O I I I O I I I I I I I
SAP d.o.o.
18 20 09 13 19 21 09 18 20 09 19 21 10 17 16 10 19 18 10 18 16 14 14 10 13 19 18 10 13 18 16 10 10 18 18 10 10 16 16 08 18 20 10 16 10 18 08 20 10 13 16 10 13 18 10 17 18 18 08 17 20 19 18 19 18 14 14 14
TI TI TJ TJ TJ TJ TK TK TK TL TL TL U0 U0 U0 U1 U1 U1 U2 U2 U2 U3 U4 U5 U5 U5 U5 U6 U6 U6 U6 U7 U7 U7 U7 U8 U8 U8 U8 U9 U9 U9 UA UA UB UB UC UC UD UD UD UE UE UE UN UN UN UQ US US US UW UX UY UZ V0 V5 V6
ESE ESE ESE ESE ESE ESE ESE
ESA ESE
ESA
ESE
ESA MWS ESA MWS MWS ESA MWS
ESA
ESA
ESE ESE
Phone: +386 (1) 5881 255
HWSTEAA HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWSTEAA HWSTE HWBAS HWSTE HWSTE HWBAS HWSTE HWSTE HWBAS HWSTE HWSTE HWBAS HWSTE HWSTE HWBAS HWBAS HWBAS HWBAS HWSTE HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWBAS HWSTE HWSTE HWBAS HWSTE HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWSTE HWSTE HWSTE HWBAS HWSTE HWSTE HWSTE HWSTE HWSTE HWSTE HWBAS HWBAS HWBAS
0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 -100,000 0,000 0,000 0,000 -100,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 79 / 175
SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01
I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I
SAP d.o.o.
08 17 19 08 17 18 08 13 17 19 08 13 17 18 08 12 17 18 08 13 17 19 08 13 17 18 08 12 17 18 08 13 17 19 08 13 17 18 08 17 19 08 17 18 08 17 20 08 19 08 18 08 19 08 18 08 13 19 08 13 18 08 19 08 18 08 19 08
Y1 Y1 Y1 Y2 Y2 Y2 Y3 Y3 Y3 Y3 Y4 Y4 Y4 Y4 Y6 Y6 Y6 Y6 Y7 Y7 Y7 Y7 Y8 Y8 Y8 Y8 Y9 Y9 Y9 Y9 YA YA YA YA YB YB YB YB YC YC YC YD YD YD YN YN YN Z1 Z1 Z2 Z2 Z3 Z3 Z4 Z4 Z5 Z5 Z5 Z6 Z6 Z6 ZA ZA ZB ZB ZC ZC ZD
Phone: +386 (1) 5881 255
HWBAS HWNAF HWSTEAA HWBAS HWNAF HWSTEAA HWBAS HWBAS HWNAF HWSTEAA HWBAS HWBAS HWNAF HWSTEAA HWBAS HWBAS HWNAF HWSTEAA HWBAS HWBAS HWNAF HWSTEAA HWBAS HWBAS HWNAF HWSTEAA HWBAS HWBAS HWNAF HWSTEAA HWBAS HWBAS HWNAF HWSTEAA HWBAS HWBAS HWNAF HWSTEAA HWBAS HWNAF HWSTEAA HWBAS HWNAF HWSTEAA HWBAS HWNAF HWSTEAA HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS HWSTE HWBAS
0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 80 / 175
SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01 SI01
I I I I I I I I I I I I I
3.5.2
18 08 13 19 08 13 18 08 12 18 08 12 18
ZD ZE ZE ZE ZF ZF ZF ZG ZG ZG ZN ZN ZN
HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE HWBAS HWBAS HWSTE
0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000 0,000
DDV-O form
The pogram /CCEE/SIFIDDV1 and form /CCEE/SIFIDDV13S enable you to prepare form DDV-O for Tax authorities. Transaction SA38 -> Program /CCEE/SIFIDDV1
On the selection screen you define: - Run date (defined during execution VAT report), SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 81 / 175
-
Additional run ID (defined during execution VAT report), Company code, Return required, Calculate deductible amount and XML output to file.
An example of DDV-0 form print out -> Transaction SP01
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 82 / 175
… and XML file:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 83 / 175
3.5.3
GL line item export
Program for GL line item export enables you to prepare whole General Ledger in a predefined Electronic format by Official Journal of Republic of Slovenia no. 59 in 126 (SAP Note 1128932). Tran. SA38 -> Program /CCEE/SIFI_EXPORT_GL_LINE or tran. /CCEE/SIFI_EXPORT_GL When you execute the program you have to define the following parameters: Company code, Fiscal year, Ledger (leading, non-leading), Posting date (always enter interval from the first to the last day in the month e.g. from 1.1.2009 to 30.6.2009 otherwise beginning and closing balance won’t be correct) GL accounts from - to, - Local Chart of Accounts; if you select this option alternative GL accounts from Local CoA will be displayed in the file (otherwise GL accounts from operational CoA) and in case that GL account doesn't have assigned Alternative GL acct. (in SKB1-ALTKT) program takes GL from operational CoA and in log you can see datailed info about this GL acct. As in some cases the filed BSEGLOKKT could be different from the SKB1-ALTKT, info from BSEG-LOKKT is added to the last column in the file “Local GL acct. (from BSEG-LOKKT)” Sort output file; There are two possibilities to run the export: SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 84 / 175
a) checked button Sort – the program creates one output file with line items and opening and closing balances sorted by GL account and Posting date. In that case the program needs more time and memory. If the program falls to dump (lack of memory) you can devide your accounts into several account ranges in the input screen. Then the program executes range by range and need of memory is not so big. The more ranges you specify the less memory it will need (but it will be slower, because must go through table BSEG so many times how many account ranges are specified). b) unchecked button Sort - program creates two output files. One with line items and one with opening and closing balances. The program doesn‘t need a lot of memory and line items are not sorting – therefore it is faster. If you don’t specify GL account range the program will be faster because it will go only once through table BSEG (and will export everything). Path to save file/ Path to save file (OTV, ZAK); Program create file or two files depends on Sort output file. File is always saved on your appserver. To the PATH, you must enter path on your appserver. When the file(s) is/are created, you can send it to your local machine for example with program RFASLDPC or transaction CG3Y. Delimiter Data sources: there you can define data source (Use database or Use archives)
When you execute the program, a file(s) is/are created and information is displayed:
and
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 85 / 175
or in case of Background execution:
... and for GL accounts without Alternative GL acct. assigned log is prepared:
Then use program RFASLDPC or transaction CG3Y to save file(s) from appserver to your local machine:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 86 / 175
And now the file you can simply open and read it. The structure of the prepared file is: - GL Acct. number - GL Acct. long text - Posting date - Document date - Document no. - Sign (OTV/ZAK) - Business transaction description - Amount in debet - Amount in credit - Company code - Document type - Reference - Header text SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 87 / 175
-
Posting period/year Tax period VAT Date Tax code Cost center Customer/Vendor Offsett. Account Local GL acct. (from BSEG-LOKKT) Ledger
3.5.4
EC Sales list
The pogram /CCEE/SIFI_RFASLM00_SI and forms enable you to prepare Recapitulative statement – form RP-O (SAP form /CCEE/SIFIFASL12) and Report on the supplies (article 76.a) – form PD-O (SAP form /CCEE/SIFIDELIV3) for Tax authority. Transaction SA38 -> Program /CCEE/SIFI_RFASLM00_SI Recapitulative statement: It works depends upon the settings of the tax codes (output tax and EU code = 1, 4 or 6) and definition of the Third Party Sales on the outgoing invoice (which is defined by the field INVFO-XEGDR). Under selection paramaters it is important that you define: - Reporting period and year (otherwise it is empty in a form and XML file) - Choose appropriate Posting or Tax Reporting Date Selection - Output tax codes (otherwise also transactions relevant for Report on the supplies (article 76.a) will be displayed) - Select goods delivery and Select services to display relevant transactions for goods and services deliveries - Generate B segment; corrective documents are displayed in segment B (see also Additional info below) - A seg only, w/o corrections; form and XML file are generated only for segment A without correction documents - A seg. Only, corrections included; form and XML file are generated only for segment A including correction documents - SegB decision algorithm: o Only negative amount are cumulated into segB o Positive and negative amounts are cumulated into segB and documents are cumulated into segB according connection to original document: if original document is found and period of original document is different than current => segB if original document is found and period of original document is the same than current => segA if original document isn't found => segA - Official run (save data). If you select that checkbox data provided in XML file will be saved into history table /CCEE/SIFI_RFASL as well. You can check or maintain saved data via maintenance view /CCEE/SIFI_RFA_V. The report saves exactly the same data into this table that are reported in XML file, but SAP is not responsible for content of this table. - Analyze run. If you select that option program will go throught documents and find all “problematic” documents. With “problematic” documents we understand (1) all corrective documents for which it is not possible to find original document or (2) if data for previous period to which correction belongs to according to original document are not availalble in history table. Info about that is saved in columns Error description and Error type on ALV display. With error type W are marked documents without reference to original documents and with E documents for which data for preSAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 88 / 175
-
vious period in history table according original document were not found. Wigh choosing that selection it is not possible to generate XML file or form. SAPscript Form Output; Form name /CCEE/SIFIFASL12 XML output to file is vatreport.xml (it is important that you define this name as the approporiate format of XML file is defined behind of that name).
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 89 / 175
Explanation of some msg.s that can be generated: If data has already been saved for reported period, the report will show error message “Declaration already exists. Please maintain and run again. Official run data !!!NOT!!! saved.” You should maintain history table manually (delete already generated data). If some correction documents are linked to original reporting period before year 2010 and there is no data avaialable in table /CCEE/SIFI_RFASL, msg. “Documents before 2010 were skipped.” is generated. If correction documents are linked to original reporting period from year 2010 onwards and data is not available in the table, error msg. “Required data for previous period wasn’t find. Most probably because is missing in history table declaration for YYYY/MM” is generated. Additional info: The prerequisite for successful working of the program is that data is available in the table from year 2010 onwards (you can fill it in the way that you execute the program for each period from 2010 with active parameter Official run. If needed manually update it afterthat, that data are allinged with reported to Tax authority). For each correction document program try to find appropriate original document. Information about that is saved in columns: Corr. Doc. amount, Corr. Doc. no., Corr. Period, Corr. Year in Correction. Data for Segment B are calculated for reporting period in the way that program checks reporting history in table /CCEE/SIFI_RFASL for that correction (amount that was reported under regular reporting period and all corrections reported afterthat until now). SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 90 / 175
If correction document is found in current reported period but the program is not able to find reference data/document from previous period, the report will by default take and report such correction document in current reporting period. Therefore you must take responsibility and manually update such corrections and report it in the appropriate period (via maintenance view /CCEE/SIFI_RFA_V). Information of original document is saved in different ways in correction document at customers. As in the program it was not possible to cover all different approaches, in SAP Note 1750374 is given proposal that customer can implement his own approach. History table, view /CCEE/SIFI_RFA_V - description of columns: CoCd - company code VAT Registration No. - Vat number - XML - edp:vatNumber Year - reporting year - XML - H1_Year Period - reporting period - XML - H1_Month row index - key identification for each reported block Segment - typ of segment A or B declaration column - A1_C or B0_Y declaration column - A2_N or B0_M declaration column - A3_T or B1_C declaration column - A4_C4263 or B2_N declaration column - A5_T3 or B3_T declaration column - A6_S or B4_C4263 declaration column - B5_T3 declaration column - B6_S
An example of display for Analyze run:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 91 / 175
An example of regular run display:
An example of EC sales list print out -> Transaction SP01
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 92 / 175
and an example of EC sales list XML file:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 93 / 175
Report on the supplies (article 76.a) It works depends upon the settings of the tax code (EU code = 3). Under selection paramaters it is important that you define: - Reporting period and year (otherwise it is empty in a form and XML file) - Choose appropriate Posting or Tax Reporting Date Selection - Output tax codes (otherwise also transactions relevant for Recapitulative statement will be displayed) - Select goods delivery and Select services to display relevant transactions for goods and services deliveries - Generate B segment; corrective documents are displayed in segment B (see also Additional info below) - A seg only, w/o corrections; form and XML file are generated only for segment A without correction documents - A seg. Only, corrections included; form and XML file are generated only for segment A including correction documents SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 94 / 175
-
-
-
-
SegB decision algorithm: o Only negative amount are cumulated into segB o Positive and negative amounts are cumulated into segB and documents are cumulated into segB according connection to original document: if original document is found and period of original document is different than current => segB if original document is found and period of original document is same than current => segA if original document isn't found => segA Official run (save data). If you select that checkbox data provided in XML file will be saved into history table /CCEE/SIFI_RFASD as well. You can check or maintain saved data via maintenance view /CCEE/SIFI_RFD_V. The report saves exactly the same data into this table that are reported in XML file, but SAP is not responsible for content of this table. Analyze run. If you select that option program will go throught documents and find all “problematic” documents. With “problematic” documents we understand (1) all corrective documents for which it is not possible to find original document or (2) if data for previous period to which correction belongs to according to original document are not availalble in history table. Info about that is saved in columns Error description and Error type on ALV display. With error type W are marked documents without reference to original documents and with E documents for which data for previous period in history table according original document were not found. Wigh choosing that selection it is not possible to generate XML file or form. Form name is /CCEE/SIFIDELIV3 XML output to file is xml_deliv.xml (it is important that you define this name as the approporiate format of XML file is defined behind of that name).
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 95 / 175
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 96 / 175
Explanation of some msg.s that can be generated: If data has already been saved for reported period, the report will show error message “Declaration already exists. Please maintain and run again. Official run data !!!NOT!!! saved.” You should maintain history table manually (delete already generated data). If some correction documents are linked to original reporting period before year 2010 and there is no data available in table /CCEE/SIFI_RFASD, msg. “Documents before 2010 were skipped.” is generated. If correction documents are linked to original reporting period from year 2010 onwards and data is not available in the table, error msg. “Required data for previous period wasn’t find. Most probably because is missing in history table declaration for YYYY/MM” is generated. Additional info: The prerequisite for successful working of the program is that data is available in the table from year 2010 onwards (you can fill it in the way that you execute the program for each period from 2010 with active parameter Official run. If needed manually update it afterthat, that data are allinged with reported to Tax authority). For each correction document program try to find appropriate original document. Information about that is saved in columns: Corr. Doc. amount, Corr. Doc. no., Corr. Period, Corr. Year in Correction. Data for Segment B are calculated for reporting period in the way that program checks reporting history in table /CCEE/SIFI_RFASD for that correction (amount that was reported under regular reporting period and all corrections reported afterthat until now). SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 97 / 175
If correction document is found in current reported period but the program is not able to find reference data/document from previous period, the report will by default take and report such correction document in current reporting period. Therefore you must take responsibility and manually update such corrections and report it in the appropriate period (via maintenance view /CCEE/SIFI_RFD_V). Information of original document is saved in different ways in correction document at customers. As in the program it was not possible to cover all different approaches, in SAP Note 1750374 is given proposal that customer can implement his own approach. History table, view /CCEE/SIFI_RFD_V - description of columns: CoCd - company code VAT Registration No. - Vat number - XML - edp:vatNumber Year - reporting year - XML - PeriodYear Period - reporting period - XML - PeriodMonth row index - key identification for each reported block Segment - typ of segment A or B declaration column – A2 or B1_Year declaration column – A3 or B1_Month declaration column – B2 declaration column – B3
An example of display:
An example of regular run display:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 98 / 175
An example of Report on the supplies (article 76.a) -> Transaction SP01
and an example of Report on the supplies (article 76.a) in XML file:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 99 / 175
3.5.5
SI Cash Sales Report / Invoices paid by cash
Solution for SI Cash Sales Report includes: - table /CCEE/SIFI_CACC, transaction /CCEE/SIFI_CS_ACC_AS, - table /CCEE/SIFI_CDTYP, transaction /CCEE/SIFI_CS_DT_AS, - table /CCEE/SIFI_CMWS, transaction /CCEE/SIFI_CS_TC_AS, - program /CCEE/SIFI_CASH_SALES_REPORT, transaction /CCEE/SIFI_CS_REP. For more info see SAP Note 1927941.
3.5.5.1 Table /CCEE/SIFI_CACC, transaction /CCEE/SIFI_CS_ACC_AS: Account assignment to payment type Assign G/L account to payment type – Cash/Credit Card. This account will be checked on payment document to determine type of payment:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 100 / 175
3.5.5.2 Table /CCEE/SIFI_CDTYP, transaction /CCEE/SIFI_CS_DT_AS: Document type assignment Assign company code and document type which you want to report. For document types, which you are using for credit memos, please add posting key used for this credit memos (default could be 11):
3.5.5.3 Table /CCEE/SIFI_CMWS, transaction /CCEE/SIFI_CS_TC_AS: Assign Tax Code to Tax Rate Assign tax code to tax rates, this report recognizes 3 types: normal, reduced and zero:
3.5.5.4 Program /CCEE/SIFI_CASH_SALES_REPORT, transaction /CCEE/SIFI_CS_REP Program /CCEE/SIFI_CASH_SALES_REPORT enables you to report invoices paid by cash or credit card. Transaction SA38 -> Program /CCEE/SIFI_BST On the selection screen you can define: SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 101 / 175
Company code, Fiscal year, Posting date in the Document/Invoice (from – to), Invoices select options: you can select All invoices or Invoices issued only to Taxable person (ID VAT in KNA1-STCEG is provided) Data source: that is relevant for data displayed in file with line items. If you select FI (header + items) data (material number, quantity, values) are taken from FI tables, if you select FI (header) FI+SD (items) data are taken from FI and SD tables. Output specification: o Output to ALV table o Output file name; define application server during background processing. Execute the program. Program you can execute in: foreground (ALV is dispplayed on the screen, file is stored according path from selection screen field), background (ALV is printed into spool, file name according selection screen is stored on application server, in the job log you can find additional messages).
If you execute the program in background, use program RFASLDPC or transaction CG3Y to save file(s) from appserver to your local machine. SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 102 / 175
3.5.6
Info about VAT and VAT base amount on issued invoice in case of Slovenian reverse charge
Solution to display info about VAT and VAT base amount on issued invoices to customers with Slovenian ID VAT for some deliveries of goods and services according to article 76a in Tax law valid from 1.1.2010 is available in SAP Note 1431552. The statistical tax condition can be printed if the print indicator (T683S-DRUKZ) in the SD pricing procedure is set to ‘S’ (sum) or ‘X’ (item). So, if you know the needed tax rate, then this statistical condition could be printed on the invoice.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 103 / 175
4.
Extended Withholding tax (Dav ni odtegljaj)
Solution for “Dav ni odtegljaj” was prepared as standard SAP solution for Extended Withholding tax. Solution supports withholding tax on the customer and vendor side. When a customer that is authorized to deduct withholding tax pays invoices from a vendor subject to withholding tax, the customer reduces the payment amount by the withholding tax proportion. The customer then pays the tax withheld directly to the appropriate tax authorities. Only the output list ODO-1 is created according to the Slovenia country-specific requirements. NOTE: Due to the validity periods that you have to define, the withholding tax master data is timedependent. This means that the withholding tax information saved in an open item may be different to the current relevant withholding tax types. In the document display, the system displays appropriate warnings about the validity of the withholding tax information in the withholding tax dialog box. If, between the time a document is entered and the time it is cleared, you have changed the list of relevant withholding tax types, the system will not clear the document. The following situations can occur: - A withholding tax type is no longer relevant This is the case where the company code is no longer authorized to deduct tax for a withholding tax type, although it was authorized to do so at the time the document was entered. The item in question is displayed in the withholding tax dialog box with all the withholding tax data stored in the database. The s ystem displays a message telling you that this withholding tax type is no longer relevant. - A withholding tax type is new This is the case if you have entered a new withholding tax type for a company code since the time of document entry. The system displays the withholding tax data not yet saved to the database in the dialog box with a message that the withholding tax type is new. You have the following options for clearing documents despite these warnings: - Change the posting date for clearing, so that the relevant withholding tax types are the same on the posting date and on document entry. · Change individual documents using the document change function: To do this, you delete the withholding tax code in withholding tax types that are no longer relevant, and then save new withholding tax types. - Start report RFWT0010. Once you have changed the relevant withholding tax types, this report adjusts the open items to take account of the current relevant withholding tax types. It either creates new withholding tax information, or changes existing information.
4.1
IMG settings included in SI localization
4.1.1
Define reason for exemption:
IMG Financial Accounting Financial Accounting Global Settings Withholding Tax Extended Withholding Tax Basic Settings Define Reasons for Exemption
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 104 / 175
4.1.2
Define recipient types
IMG Financial Accounting Financial Accounting Global Settings Extended Withholding Tax Basic Settings Check Recipient Types
Withholding Tax
Recipent types are defined in combination with withholding tax type. For withholding tax type 01 (25% tax - form ODO-1) are defined following recipient types: 1 – tuja pravna oseba ali družba oz. združenje oseb, vklju no z družbo civilnega prava, po tujem pravu iz države, s katero ima Republika Slovenija sklenjeno mednarodno pogodbo o izogibanju dvojnega obdav evanja, ki obvezuje Republiko Slovenijo; 2 – tuja pravna oseba ali družba oziroma združenje oseb, vklju no z družbo civilnega prava, po tujem pravu iz države, s katero ima Republika Slovenija sklenjeno drugo mednarodno pogodbo, ki obvezuje Republiko Slovenijo; 3 – tuja pravna oseba ali družba oz. združenje oseb, vklju no z družbo civilnega prava, po tujem pravu iz države, s katero ni mednarodne pogodbe o izogibanju dvojnega obdav evanja; 4 – prejemnik rezident, ki ne sporo i dav ne številke.
4.1.3
Define income types
IMG Financial Accounting Financial Accounting Global Settings Extended Withholding Tax Basic Settings Check Income Types
SAP d.o.o.
Phone: +386 (1) 5881 255
Withholding Tax
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 105 / 175
Defined incomes types are: 01 - Dividenda, ki je dobi ek ali presežek prihodkov nad odhodki, ki se izpla a družbenikom ali lanom, v zvezi z udeležbo v dobi ku izpla evalca; 02 - Dobi ek, ki se izpla a v zvezi z vrednostnimi papirji in krediti, ki zagotavljajo udeležbo v dobi ku izpla evalca; 03 - Dobi ek, rezerve iz dobi ka in osnovni kapital v delu, ki se je oblikoval iz predhodnega pove anja osnovnega kapitala iz dobi ka ali rezerv iz dobi ka, ob prenehanju izpla evalca; 04 - Skrite rezerve ob prenehanju izpla evalca, ki se izra unajo kot razlika med pošteno vrednostjo in dav no vrednostjo sredstev in obveznosti po stanju na dan pred vpisom zaklju ka likvidacije v sodni register; 05 - Izpla ana vrednost delnic ali poslovnih deležev, zmanjšana za njihovo emisijsko vrednost in za sorazmerni del kapitalskih rezerv, ob izklju itvi ali izstopu delni arja, družbenika ali lana iz izpla evalca; 06 - Izpla ilo na podlagi rednega zmanjšanja osnovnega kapitala izpla evalca v delu, ki se je oblikoval iz predhodnega pove anja osnovnega kapitala iz dobi ka ali rezerv iz dobi ka; 07 - Izpla ana vrednost pridobljenih lastnih delnic ali lastnih poslovnih in drugih lastnih deležev, zmanjšana za njihovo emisijsko vrednost in za sorazmerni del kapitalskih rezerv; 08 - Dobi ek, prenesen na podlagi podjetniške pogodbe v skladu z zakonom, ki ureja gospodarske družbe; 09 - Prikrito izpla ilo dobi ka, kot je dolo eno v 7. to ki 74. lena ZDDPO-2 in se nanaša na zagotovitev vseh oblik sredstev in opravljanje storitev, vklju no z odpustom dolga, brez pla ila ali po ceni, ki je nižja od primerljive tržne cene iz 16. in 17. lena tega zakona, ali pla ila za nakup vseh oblik sredstev in storitev po ceni, ki je višja od primerljive tržne cene iz 16. in 17. lena tega zakona, ali pla ila za sredstva in storitve, e sredstva niso bila prevzeta ali storitve niso bile opravljene, ki se opravi osebi, ki ima neposredno ali posredno v lasti najmanj 25 % vrednosti ali števila delnic ali deležev v kapitalu, upravljanju ali nadzoru izpla evalca ali obvladuje izpla evalca na podlagi pogodbe ali na na in, ki se razlikuje od razmerij med nepovezanimi osebami; 10 - Prikrito izpla ilo dobi ka, kot je dolo eno v 7. to ki 74. lena ZDDPO-2 in se nanaša na obresti na posojila, dana po nižji ali prejeta po višji obrestni meri, kot znaša priznana obrestna mera iz 19. lena tega zakona, ki se opravi osebi, ki ima neposredno ali posredno v lasti najmanj 25 % vrednosti ali števila delnic ali deležev v kapitalu, upravljanju ali nadzoru izpla evalca ali obvladuje izpla evalca na podlagi pogodbe ali na na in, ki se razlikuje od razmerij med nepovezanimi osebami; SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 106 / 175
11 - Prikrito izpla ilo dobi ka, kot je dolo eno v 7. to ki 74. lena ZDDPO-2 in se nanaša na obresti od presežka posojil iz 32. lena tega zakona, ki se opravi osebi, ki ima neposredno ali posredno v lasti najmanj 25 % vrednosti ali števila delnic ali deležev v kapitalu, upravljanju ali nadzoru izpla evalca ali obvladuje izpla evalca na podlagi pogodbe ali na na in, ki se razlikuje od razmerij med nepovezanimi osebami; 12 - Obresti kot dohodek iz vseh vrst terjatev ne glede na to, ali so zavarovane s hipoteko, ter obresti od vseh dolžniških vrednostnih papirjev in drugih dolžniških finan nih instrumentov, vklju no s premijami in nagradami, ki pripadajo takim vrednostnim papirjem in finan nim instrumentom, razen: a. obresti od kreditov, ki jih najema, in vrednostnih papirjev, ki jih izdaja Republika Slovenija; b. obresti iz najetih kreditov in izdanih dolžniških vrednostnih papirjev s strani pooblaš ene institucije v skladu z zakonom, ki ureja zavarovanje in financiranje mednarodnih gospodarskih poslov, za katere po navedenem zakonu daje poroštvo Republika Slovenija; c. obresti, ki jih banke pla ujejo drugim bankam in finan nim institucijam, in d. zamudnih obresti. 13 - Pla ila za uporabo ali pravica do uporabe avtorskih pravic, patentov, zaš itnih znakov in drugih premoženjskih pravic in drugih podobnih dohodkov, kot so dolo ena v 3.to ki prvega odstavka 70. lena ZDDPO-2; 14 - Pla ila za zakup nepremi nin, ki se nahajajo v Sloveniji; 15 - Pla ila za storitve nastopajo ih izvajalcev ali športnikov, e ta pla ila pripadajo drugi osebi; 16 - Pla ila za storitve, e so pla ila opravljena osebam, ki imajo sedež ali kraj dejanskega delovanja poslovodstva v državah, razen držav lanic EU, v katerih je splošna oziroma povpre na nominalna stopnja obdav itve dobi ka nižja od 12,5 % in je država objavljena na seznamu v skladu z 8. lenom ZDDPO-2; 17 - Dividende in dohodki, podobni dividendam, ki se štejejo za prikrito izpla ilo dobi ka, ki se v skladu z drugim odstavkom 71. lena ZDDPO-2 ne kvalificirajo pod ugodnosti iz prvega odstavka 71. lena ZDDPO-2, e znesek pla il ni skladen s 16. lenom ZDDPO-2; 18 - Obresti nad zneskom obresti po drugem odstavku 19. lena ZDDPO-2, ki se v skladu z drugim odstavkom 72. lena ZDDPO-2 ne kvalificirajo pod ugodnosti iz prvega odstavka 72. lena ZDDPO-2 (izpolnjuje se v primeru dovoljenja, izdanega na podlagi 377. lena ZDavP-2); 19 - Pla ila za uporabo premoženjskih pravic nad zneskom po etrtem odstavku 16. lena ZDDPO-2, ki se v skladu z drugim odstavkom 72. lena ZDDPO-2 ne kvalificirajo pod ugodnosti iz prvega odstavka 72. lena ZDDPO-2 (izpolnjuje se v primeru dovoljenja, izdanega na podlagi 377. lena ZDavP-2); 20 - Pla ila, ki imajo naravo delitve dobi ka ali vra ila kapitala, ki se v skladu s 73. lenom ZDDPO-2 ne kvalificirajo pod ugodnosti iz 72. lena ZDDPO-2; 21 - Obresti iz kreditov, ki vsebujejo pravico udeležbe na dolžnikovem dobi ku, ki se v skladu s 73. lenom ZDDPO-2 ne kvalificirajo pod ugodnosti iz 72. lena ZDDPO-2; 22 - Obresti iz kreditov, ki kreditodajalcu dajejo pravico zamenjave njegove pravice do obresti v pravico do udeležbe v dobi ku, ki se v skladu s 73. lenom ZDDPO-2 ne kvalificirajo pod ugodnosti iz 72. lena ZDDPO-2; 23 - Pla ila iz kreditov, ki ne vsebujejo dolo b za vra ilo glavnice ali vra ilo glavnice zapade po 50 letih po nastanku, ki se v skladu s 73. lenom ZDDPO-2 ne kvalificirajo pod ugodnosti iz 72. lena ZDDPO-2; 24 - Pla ila po 2. do 5. to ki prvega odstavka 68. lena Zakona o davku od dohodkov pravnih oseb (Uradni list RS, št. 33/06 – uradno pre iš eno besedilo), obra unana za obdobja pred 1.1.2007 in izpla ana po 1.1.2007.
4.1.4
Define withholding tax type for payment posting
The withholding tax type governs the way in which extended withholding tax is calculated and is defined at country level. Several withholding tax types can be defined in the system; one or more can be assigned in the vendor master record.
IMG Financial Accounting Financial Accounting Global Settings Withholding Tax Extended Withholding Tax Calculation Withholding Tax Type Define Withholding Tax Type for Payment Posting
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 107 / 175
There is created one withholding tax type for payment posting: 01 - 25% tax - form ODO-1. Tax type for payment posting 01 is defined as presented:
to enable you to enter withholding tax base and tax amount during the posting
4.1.5
SAP d.o.o.
Define withholding tax codes
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 108 / 175
Withholding tax code to enable the system to calculate the tax amount. You define the tax base and rate in the withholding tax code. You make the settings for each country and withholding tax type. You can therefore define as many withholding tax codes as required for each withholding tax type.
IMG Financial Accounting Financial Accounting Global Settings Withholding Tax Extended Withholding Tax Calculation Withholding Tax Codes Define Withholding Tax Codes
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 109 / 175
The definitions for the codes for withholding tax must not be changed or deleted while there are still outstanding items in the s ystem posted under the code in question. If you do not observe this rule, you may find errors occur when carrying out payment transactions.
4.1.6
Generic Withholding Tax Reporting
Generic Withholding Tax Reporting for Slovenia based on definition of output group which is connected with form ODO-1.
IMG Financial Accounting Financial Accounting Global Settings Withholding Tax Extended Withholding Tax Generic Withholding Tax Reporting Define Output Groups The relevant form for Withholding tax in Slovenia is /CCEE/SIFI_ODO1_07 (form ODO-1).
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 110 / 175
4.2
IMG settings to be done by company
4.2.1
Assign withholding tax type to company codes
IMG Financial Accounting Financial Accounting Global Settings Withholding Tax Extended Withholding Tax Company code Assign Withholding Tax Types to Company Codes
4.2.2
Activate extended withholding tax in your company code
IMG Financial Accounting Financial Accounting Global Settings Withholding Tax Extended Withholding Tax Company code Activate Extended Withholding Tax
4.2.3
Define G/L accounts for posting
IMG Financial Accounting Financial Accounting Global Settings Extended Withholding Tax Postings Accounts for Withholding Tax Define Accounts for Withholding Tax to be Paid Over
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 111 / 175
If withholding tax is to be paid/reported, you must create an account to which it can be posted. The posting is made to this account automatically. You can post the tax to different accounts according to the withholding tax code. There are three fields in account master records that are important for withholding tax specifications: - tax category; as the withholding tax account is not tax-relevant, you cannot make an entry in this field. - post automatically only; this field determines how the account is posted to; either automatically only or both automatically and manually. - determination that open items are managed for this account.
4.2.4
Define Servant code of Tax authorities
IMG Financial Accounting Financial Accounting Global Settings Enter Global Parameters (Additional details)
Company code
The Servant code of Tax authorities will be displayed in form ODO-1.
4.3
Vendor master data
Withholding tax is only posted for a withholding tax type if the vendor is defined as subject to tax for this withholding tax type. In order to be able to post withholding tax in vendor business transactions, for each withholding tax type, the company code must be authorized to deduct withholding tax and the vendor must be subject to withholding tax. SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 112 / 175
Define the following in the vendor master record: - make an entry for each withholding tax type, - define the vendor as subject to withholding tax, - if necessary, also define the withholding tax code, type of recipient, withholding tax ID and details of any withholding tax exemption.
obligatory if withholding tax can be calculated
compulsory to enter on vendor master data
The wth tax base amount is 100. The wth tax rate is 25% meaning that the wth tax amount is 25. Given an exemption rate of 80%, the wth tax amount is reduced to 5.
obligatory in case of exemption
Withholding tax code is defaulted from the vendor master record when you enter a line item if the vendor is subject to withholding tax. If a vendor is exempt from withholding tax, you must specify this in the master record. The basis of the withholding tax exemption is an exemption certificate, possibly temporary. In the master record of the vendor, you enter the number of this certificate and the date up to which the exemption is valid. If an exemption exists, the system either posts no withholding tax or the reduced tax rate. SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 113 / 175
4.4
Document entry
When you enter a document, there are three fields that are significant for withholding tax: - withholding tax code, - withholding tax base amount and - amount exempt from withholding tax. You use the system settings to determine whether these fields appear when you enter business transactions. You specify this information at three separate levels: - for every business transaction on vendor accounts, you specify whether it is subject to withholding tax or not. You use the field status definition for the posting key and for the reconciliation account to do this, by suppressing the fields for withholding tax or defining them as optional fields. - for company codes that have business with vendors liable to withholding tax, you choose a special screen variants. - for every vendor liable to withholding tax, you enter a withholding tax code in the master record. The system defaults this indicator when you enter a document for this account.
4.5
Clearing with Extended withholding tax
For withholding tax types with posting at time of payment, the withholding tax is calculated and posted when open items are paid. When you clear open items without a payment (transfer posting), no withholding tax is posted.
4.5.1
Manual posting with clearing
For postings with clearing, the system calculates and, if necessary, posts the withholding tax for the withholding tax types with posting at time of payment. Any withholding tax amounts you may have entered manually override those calculated by the system. An open item can only be activated if, at the time it is cleared, the withholding tax information it contains is still relevant. This will depend on the date the document was entered and the posting date of the payment. If an open item is not active, all withholding tax amounts are zero. The system recalculates all withholding tax amounts for all open items if you: - (de)activate one or more open items, - change the cash discount for one or more open items, - change the partial payment amount for one or more open items. If you recalculate the withholding tax amounts for an active open item, these amounts can change due to the Customizing settings for withholding tax types. This may be the case, for example, if you have defined withholding tax after cash discount for this withholding tax type. The total of withholding tax amounts for all open items is displayed in the appropriate field in the lower half of the withholding tax screen. The system takes this figure into account when determining the total amount to be cleared. When you post or simulate the payment document, the total withholding tax amounts are subtracted from the payment amount. The withholding tax amounts are posted to the G/L accounts specified in the account determination in Customizing for the withholding tax types/codes. Those withholding tax amounts posted to G/L account.
4.5.2
Automatic Clearing (Payment Program)
The payment proposal includes information about potential inconsistencies in a business partner’s withholding tax status and in the open items. If the relevant withholding tax types for an open item are different to the relevant withholding tax types when the payment is posted, this is an inconsistency and the system adds these open items to the exception list. You have to change each document in the exception list individually. SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 114 / 175
As is the case for manual payment transactions, the payment program also supports payment of withholding tax calculated for more than one document. In this case, the withholding tax amount is not calculated on a single line item but on all the selected line items linked by the invoice reference. When you call up the payment proposal, you can have the system recalculate the withholding tax at any time. When you save the proposal, the system always recalculates the withholding tax. When you call up the proposal, you can display the withholding tax data for every individual document.
4.6
An examples of Extended withholding tax documents
4.6.1
Received invoice from a vendor who is liable to withholding tax. The invoice is not relevant for withholding tax calculation.
Vendor master data:
Document entry: You should not enter withholding tax code.
Clearing document (payment):
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 115 / 175
4.6.2
Received invoice from a vendor who is liable to withholding tax. The invoice include relevant and non-relevant withholding tax calculation line items.
Document entry: Enjoy transactions give you an opportunity in the easiest way to enter this kind of documents. On Amount split screen you should separate amount and for each line define proper withholding tax code select button Detail WT.
Document display: Vendor line items are divided by different withholding tax codes.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 116 / 175
Non-relevant withholding tax vendor line item
Relevant withholding tax vendor line item
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 117 / 175
Clearing document (payment):
4.7
Report ODO-1 (SAP note 828692 and 954443)
You can create tax form ODO-1 for tax authorities with using standard SAP report RFIDYYWT which you can find under:
SAP menu Accounting Financial Accounting Accounts Payable Withholding tax General Generic Withholding Tax Reporting (tran. S_P00_07000134). During preparation the form ODO-1 (/CCEE/SIFI_ODO1_07) you should define following important parameters: Process type: STD Output group: SI Country key: SI Reporting period: you should enter payment date (not as interval from – to). Extended WT type: 01 Print form 1 should be activated. SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 118 / 175
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 119 / 175
5.
Outgoing payments
DMEE format SIFI-SEPA_40 (ISO SEPA XML RB 4.03) is provided for SEPA and VP70 (foreign) outgoing payments.
5.1
IMG settings included in SI localization
5.1.1
Instruction keys (SAP Note 1002497)
The instruction keys are used for information about payment costs and Business statistical codes. A. Information about cost payee Information concerning the Bank expenses is mandatory data. It is predefined by Instruction key 1 with the following values: IK1 Description 01 Charges payable by payee BEN 02 Charges payable by payer OUR 03 Charges of payer's bank payable by payee, other SHA In DMEE SIFI-SEPA_40 default value is set in the field to SHAR (IK1 = 03). If defult value is not appropriate you can define/change it in FI document. B. Purpose code of payment Information concerning purpose code is required. It is predefined by Instructions defined under field 3 and 4 and Instruction keys from DA – HU. In DMEE SIFI-SEPA_40 default value is set in the field under to GDSV. If defult value is not appropriate you can define/change it in FI document.
SAP menu Accounting Financial Accounting Accounts Receivable and Accounting Payable Business Transactions Outgoing Payments Automatic Outgoing Payments Payment Media Data Medium Exchange Define Instructions for Payment Transactions
3
Depends on parameter “SEPA payment (X=true, space=false) under Format parameters defined in tran. FBPM DMEE SIFISEPA_40 covers SEPA (within SEPA area) and VP70 (out of SEPA area) payments.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 120 / 175
Based on that in addition in the IMG under Financial Accounting Accounts Receivable and Accounting Payable Business Transactions Outgoing Payments Automatic Outgoing Payments Payment Media Data Medium Exchange Define Instruction keys
The instruction key should be maintained in the customer/vendor master record or in the system configuration for data medium exchange data for the house bank. This is very important for paying documents which are created in Logistics because there you can not fill Instruction keys during posting a document. The instruction keys can be entering and changing in FI documents and during payment run preparation.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 121 / 175
5.1.2
Create Payment Medium Formats
Transaction FBPM: You may enter the following settings on this screen: Structure of format parameters – contains items, which are fields of initial screen for medium creation program SAPFPAYM. By pressing button “Default values” you may assign format-specific initial values in the initial screen of the program for payment medium creation (SAPFPAYM). Structure of payment medium according to the level of detail. By selecting fields you determine which change of attributes will cause creation of a new file during the start of the payment medium creation program (SAPFPAYM). Selected attributes are predefined as standard.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 122 / 175
IMG Financial Accounting Accounts Receivable and Accounts Payable Business Transactions Outgoing Payments Automatic Outgoing Payments Payment Media Make Settings for Payment Medium Formats from Payment Medium Workbench Create Payment Medium Formats (Transaction OBPM1)
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 123 / 175
5.1.3
Adjust Payment Medium Format
IMG Financial Accounting Accounts Receivable and Accounts Payable Business Transactions Outgoing Payments Automatic Outgoing Payments Payment Media Make Settings for Payment Medium Formats from Payment Medium Workbench Adjust Payment Medium Format (Transaction OBPM3)
5.1.4
Set Up Payment Methods per Country for Payment Transactions
To set the payment method for country is necessary not only for the run of payment program but also because it contains entries substantial for the creation of payment medium. It is the item „Format“ which specifies uniquely assignment of the format of payment medium to payment method. The payment method is unique identifier specifying whether the format is inland or foreign. Only by foreign payment method is allowed the bank to be abroad. Proposed payment methods are: C: SEPA payments SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 124 / 175
D: VP70 payments
IMG Financial Accounting Accounts Receivable and Accounts Payable Business Transactions Outgoing Payments Automatic Outgoing Payments Payment Method/Bank Selection for Payment Program Set Up Payment Methods per Country for Payment Transactions
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 125 / 175
5.1.5
SAP d.o.o.
Validation of Accounting Documents
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 126 / 175
For checking entry in filed Payment reference you can activate Validation rule SIKIDNO on Line item level.
IMG Financial Accounting Financial Accounting Global Settings Document ment Header Validation in Accounting Document (Transaction GGB0 and OB28)
Docu-
Transaction GGB0 Change Validation: You may modify the setup of the validations for call point Line item. Prerequisite: direct specification of prerequisite, by whose compliance the appropriate validation step will be processed (e.g. posting key, Special G/L indicator, G/L reconcile acct. and doc. type).
Transaction OB28 Change view "Validation in Accounting Documents” Setup Activation level for Validation callup point (1 = active).
It should be done for all relevant company codes!
5.2
IMG settings to be done by company
5.2.1
SAP d.o.o.
Set Up All Company Codes for Payment Transactions
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 127 / 175
IMG Financial Accounting Accounts Receivable and Accounts Payable Business Transactions Outgoing Payments Automatic Outgoing Payments Payment Method/Bank Selection for Payment Program Set Up All Company Codes for Payment Transactions
5.2.2
Set Up Paying Company Codes for Payment Transactions
IMG Financial Accounting Accounts Receivable and Accounts Payable Business Transactions Outgoing Payments Automatic Outgoing Payments Payment Method/Bank Selection for Payment Program Set Up Paying Company Codes for Payment Transactions 5.2.3
Set Up Payment Methods per Company Code for Payment Transactions
IMG Financial Accounting Accounts Receivable and Accounts Payable Business Transactions Outgoing Payments Automatic Outgoing Payments Payment Method/Bank Selection for Payment Program Set Up Payment Methods per Company Code for Payment Transactions
Payer data should be maintained in 1st, 3rd and 4th line as displayed: SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 128 / 175
5.2.4
Set Up Bank Determination for Payment Transactions
IMG Financial Accounting Accounts Receivable and Accounts Payable Business Transactions Outgoing Payments Automatic Outgoing Payments Payment Method/Bank Selection for Payment Program Set Up Bank Determination for Payment Transactions
5.2.5
Define House Banks
IMG Financial Accounting (Transaction FI12)
Bank Accounting
Bank Accounts
Define House Banks
Bank Account Number should be provided in IBAN. Instruction key: can be defined as defaulted value (for additional explanation see SAP Note 1002497).
5.2.6
Create/Assign Selection Variants
IMG Financial Accounting Accounts Receivable and Accounts Payable Business Transactions Outgoing Payments Automatic Outgoing Payments Payment Media Make Settings for Payment Medium Formats from Payment Medium Workbench Create/Assign Selection Variants (Transaction OBPM4)
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 129 / 175
5.3
Master records data
5.3.1
Accounting FI02)
Bank master records
Financial Accounting
Banks
Master Data
Bank Master records (tran.
The bank leading number has to be filled in the Bank Number (BNKA-BNKLZ) field. The Bank Key (BNKABANKL) is freely definable, but for easier recognition it is recommended also to use the bank leading number as bank key.
Bank name, Street, City, SWIFT code and Bank number are mandatory fields in SIFI-SEPA_40.
5.3.2
Vendor master records
SAP menu Accounting Financial Accounting Accounts Payable ords Create/Change/Display (Transaction FK01/FK02/FK03).
Master rec-
Bank account is mandatory data for payment execution:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 130 / 175
If bank account is opened at National bank of Slovenia and starting with SI5601000000, in payment order SWIFT code must be provided from commercial bank, which is provided in IBAN from position 13 to 17 (e.g. SI5601000000XXXXX28). That means that in Bank master data (tran. FI01/FI02) Bank key XXXXX must exist.
5.3.3
Edit bank chains for creditors/debitors
SAP menu Accounting Chains Business Partners
Financial Accounting Edit (Transaction FIBPU)
Banks
Master data
Bank
SAP standard functionality of Bank chains can be used in case of using correspondence banks on vendors.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 131 / 175
5.4
Document entry
Payment reference provided in domestic payment order is common practice in the country. In SAP that info is entered in the field Payment reference (BSEG-KIDNO) during posting of FI document in one of the following format: - enter model and payment reference with space in between of (e.g. 00 12345) - enter payment reference starting with SI or RF (e.g. SI121234567890123 or RF45SBO2010). if payment reference is not provided, constant SI99 is filled under “RemittanceInformation” in XML file.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 132 / 175
Functions FI_PAYREF_CHECK and FI_PAYREF_CREATE can be modified for correct entering a payment reference into the payment reference field (KIDNO) (NOTE 350449). According to SAP Note 1557907 you can set Validation of RF Creditor reference at point of creating, parking or changing FI document. The second exception at Document entry is regarding Slovenian legislation about “Washing money and finance terorist's activities” (ZPPDFT- Zakon o prepre evanju pranja denarja in financiranja terorizma). The requirement is that in some cases it is not enough to provide Payment description in the way that Payment description is filled with text “Pla ilo ra una” or “Payment of invoice” and a content of filed Reference (BKPF-XBLNR). For such cases an exeption is implemented that Payment description is taken from vendor or customer line item text (BSEG-SGTXT) if entered text starting with *#.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 133 / 175
5.5
Payment medium
5.5.1
Payment Medium
Creation of payment medium is supported by DMEE technique (Data Medium Exchange Engine). It is a tool converting data from payment order generated by payment program into the format of corresponding bank. Payment medium will be created using standard program SAPFPAYM (Transaction FBPM). It is recommended to start this program twice: proposal mode and productive mode. General procedure is as follows: 1. Generate payment proposal (transaction F110). 2. Start program SAPFPAYM – in proposal mode. When the checks are switched on (event described in chapter 3.1.2.), the list of correct and incorrect items will be displayed. 3. If incorrect items are identified, then please correct corresponding documents and try point 2 again. 4. Generate payment order (transaction F110). 5. Start program SAPFPAYM in productive mode. 6. Select function „Download“ for generated medium – saves payment medium into an external file. Parameters for initial screen of program SAPFPAYM (Transaction FBPM) Specify payment run (date of execution, identification) and format name in the selection screen and press Enter:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 134 / 175
A new button „Format parameters“ appears in the screen. By using this button will be displayed a window with some parameters:
General parameters: Namespace: urn:iso:std:iso:20022:tech:xsd:pain.001.001.03 Namespace of Shema: http://www.w3.org/2001/XMLSchema-instance Location of Schema: urn:iso:std:iso:20022:tech:xsd:pain.001.001.03 ./pain.001.001.03.xsd Type of method (to fill Payer payment reference): 1 - Method nalog (if you use Payment order functionality), 2 - Method referenz, 3 – For payments from Payroll. Grouping payments: X = true, space = false, SEPA payment: X = SEPA payments within SEPA area), - = VP70 payments out of SEPA area. The second possibility (instead of step 1 to 6) is that in transaction F110 go to Environment -> Payment medium -> DME Administration:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 135 / 175
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 136 / 175
6.
Bank statements
In Slovenia bank statements are provided in format CAMT.053 with some specifics that are described in SAP Note 1740454.
6.1
IMG settings to be done by company
6.1.1
Define House Banks
IMG Financial Accounting (Transaction FI12)
6.1.2
Bank Accounting
Bank Accounts
Define House Banks
Make Global Settings for Electronic Bank Statement
IMG Financial Accounting Bank Accounting Business Transactions Payment Transactions Electronic Bank Statement Make Global Settings for Electronic Bank Statement Create Account Symbols
Assign Accounts to Account Symbol
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 137 / 175
Create Keys for Posting Rules
Define Posting Rules
Create Transaction Type
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 138 / 175
External transaction codes for importing Bank statement in CAMT.053: - NOTPROVIDED (-) Outgoing payments, - NOTPROVIDED (+) Incoming payments.
Assign Bank Accounts to Transaction Types
6.2
Posting Bank statement
SAP menu statement
SAP d.o.o.
Accounting Financial Accounting Banks Import (Transaction FF_5 or program RFEBKA00).
Phone: +386 (1) 5881 255
Incomings
Bank
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 139 / 175
Selection screen field descriptions: Import data; if this field is checked, data are loaded and processed, Electronic account statement format: XML or Bank-Specific Format Statements file: path and name of the file containing the bank statement, Line item file: empty Workstation upload: if this field is entered, the input file is loaded from a local PC otherwise from the application server, Post immediately/Generate batch input/Do not post: see the selection screen documentation, Only bank postings: select this field if you want to create postings only for the G/L bank accounts, Session names: select a rule to create the map name, Cash management payment advises: see the selection screen documentation, Summarization: check if the bank statement items are to be summed by the FX date and stored in the map - see the selection screen documentation, Planning type: see the selection screen documentation, Account Balance: see the selection screen documentation,
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 140 / 175
BELNR number interval: when searching for an open items using BELNR and number 1 interpretation algorithm, the BELNR number range applied to the SAP accounting document number is used to restrict the item selection in SAP R/3 against the bank statement items, XBLNR number interval: when searching for an open items using criteria other than BELNR and number 1 interpretation algorithm, the XBLNR number range applied to the SAP document reference number is used to restrict the item selection in SAP R/3 against the bank statement items, Bundling and Items Per Bundeling: determine the linking type and number of linking items - see the selection screen documentation, Execute as baskground job: the bank statement will be batch-processed, Print bank statement: check if account statement is to be printed out, Print posting log: check if bank statement items posting log is to be printed out, Print statistics: check if the bank statement processing statistics is to be printed out, Separate list: check if the accounting log and the statistics are to be separated. The local PC (presentation server) level data file loading and converted data storing is limited by the data file sizes (files of up to 85 kB have safely been processed when testing a bank statement). To process large files the pre-processed application server files have to be loaded. The PC-Upload field should not be marked. If program RFEBKA00 is used in batch processing - the bank statement files have to be downloaded from the application server.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 141 / 175
7. 7.1
Obligatory manysided reconciliation Reporting of financial liabilities to the reconciliation system ePoboti (SAP Note 1576656)
According to law “ZPreZP - Law on Avoidance of Delays in Payments” the debtor has obligation of the reporting of financial liabilities to the reconciliation system ePobot. The law defines the obligatory manysided reconciliation of mutual liabilities. The debtor is liable immediately after the delay in payment has occurred to report his liability in electronic way into the first lap of the obligatory manysided reconciliation at the administrator – currently Agency of the Republic of Slovenia for public-legal evidences and services (AJPES). The process of the reporting of the reconciliation occurs via e-application »ePobot« on the internet sites of AJPES. With the program /CCEE/SIFI_POBOTI1 you can select open vendor items according to different selection criteria. A selection can be manually deselected. A selection using “New run” can be refined repeatedly until you say to »store new reconciliation run” into database. Reconciliation run is identified by: - Company code - Year - Number of the round Same open items are now blocked from multiple selection in another reconciliation run. The “Reconciliation run” can be subsequently accessed by Display function. In both functions you are allowed to store xml file on PC. Before start working report needs to fill some control tables: Days for Reconciliation table – table /CCEE/SIFIPOBKRO You need to enter Days for Reconciliation (published by goverment notice). Click on the button „Reconciliation Days” on selection screen. This table type is of “Application table” so order to be allowed for maintenance in productive system. The content is not transferred from customizing system.
Reference field and Blocking Reason – table /CCEE/SIFIPOBXRF This customizing table tells what reference field in the table BSEG will be used by report to store information (Day when the item was sent to reconciliation system). This can be XREF1, XREF2, XREF3. Furthermore you set Blocking reason that will be used to block document item from SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 142 / 175
payment program. You can not maintain this in productive system, but only in customizing/development system and transport it to productive. Transaction SA38 -> Program /CCEE/SIFI_POBOTI1 or Transaction /CCEE/SIFI_POBOTI To execute the program you have to define at least the following selection parameters/Dynamic selection: - Vendor; Basic selection for vendors - Company code; in case of creating run with more than one company code you must explicitly list all relevant Company codes e.g. SI01, SI02, SI03 and don't define interval from SI01 – SI03. The prerequisite is also that all this Company codes have the same ID VAT. - Open items at Key date - Baseline payment date - Net due date - Special G/L transactions; Noted and parked items are not however included - Company code; in case of creating run with more than one company code you must define one of them defined under Vendor selection - Year and Number of the round - ALV Layout; layout, that is initially used to display line items in Create new mode - Create new run or Display old run or Delete old run; select appropriate option, if you select Display old run or Delete old run Type of open item selection is frozen, do not delete already created production run that is sent to ePoboti - Type of open item; Filters output according classification 1 mandatory4 overdue - (overdue5, not sent to ePobot) 2 voluntary not overdue 3 voluntary overdue (overdue, already sent to ePobot) - Display; display file to be import to ePoboti - Download to PC; path and name of file
4
mandatory items are treated all overdue open line items vithout value in XREFx field in time of reconciliation run execution. XREFx field is populated with “Date of reconciliation” from the table “Days for reconciliation table”. 5 overdue with regard to selection parameter “Open items at Key date”
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 143 / 175
Create new reconciliation Generates a list of open vendor items using above selection criteria and the result displays in ALV viewer.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 144 / 175
A user performs check of the selection. Doubleclick on line item drills into accounting document. User is allowed to deselect items by unticking the checkbox in the first column. After leaving ALV, user is enquired if Reconciliation run shall be stored in the database.
If not, you can repeat selection again. If you answer yes, items belonging to the selection are stored in the database . (item data are stored in the table /CCEE/SIFIPOBOTI. Simultaneously, blocking from paying is set (see customizing for “Ref.field and Block.reason”) and field XREF1(2,3) is updated with “Date of reconciliation” (format DD.MM.YYYY) from the table “Days for reconciliation table” for relevant accounting document/open line item. Display old run Reads data about previously created Reconciliation Run (defined by Year / Nr. of round in selection parameters from database (item data are stored in the table /CCEE/SIFIPOBOTI). The purpose is to reshow items in ALV or/and repeatedly save XML file. Delete old run Removes data about Reconciliation Run (defined by Year / Nr. of round in selection parameter from database (item data are stored in the table /CCEE/SIFIPOBOTI). Simultaneously it removes blocking from paying and initiates field XREF1 (2, 3). For this function, a user has to have authorization for object /CCEE/EPOB, Activity 06 (delete). Use this function only in emergency situations or during testing. XML output Display and download the file to your local drive with appropriate file name.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 145 / 175
7.2
Import result of Obligatory manysided reconciliation in SAP (SAP Note 1592271)
When obligatory manysided reconciliation is done, file with reconciled line items is provided in ePoboti. Customer has to do the following steps in business process: -
Download file with results of ePoboti to local drive Import this file to SAP and clear reconciled open line items on vendor (in debit) and customer (credit) side. Reconciled open line items in ePoboti are provided in the predefined structure.
Program /CCEE/SIFI_POBOTI3 enables to post all reconciled line items from file. Transaction SA38 -> Program /CCEE/SIFI_POBOTI3 or Transaction /CCEE/SIFI_POBOTI3 To execute the program you must define the following selection parameters/Dynamic selection: - Company code - Year and Number of the round - ePoboti file; path and name of file - Document type for Vendor's documents - Document type for Customer's documents - Reconcililation GL acct. - Display posted documents; on the selection screen only Company Code, Year, Number of the round remains active. - Post customer items - Test run-does not post - Processing Mode - We use Business Area in FB05 SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 146 / 175
-
ALV Layout; layout, that is initially used to display line items Print Form and Name of the form
Execute the program and program will display line items for posting/clearing:
For start posting documents press button
.
If you activate Print form information for your vendor is prepared in Output controller (SP01):
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 147 / 175
Remark: All line items that were sent to ePoboti are blocked until file from ePoboti is received and imported to the system. Afterthat these line items are cleared or only unblocked and ready to be paid with any other payment method.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 148 / 175
8.
Bank of Slovenia reporting
8.1
SKV Form – Report of short-term non-resident operating receivables and liabilities (SKV obrazec)
Program /CCEE/SIFI_SKV enables you to prepare SKV report. It reports the states and changes of shortterm non-resident receivables and liabilities (up to one year yield without the effect of payment due on date). Prerequisite for reporting: installation of program BSLO on local computer (program is available on Bank of Slovenia homepage http://www.bsi.si/html/porocanje_banki/index.html).
8.1.1
IMG settings to be checked by company
For accuracy of the report currency and country numbers have to be maintained.
IMG General Settings Set countries Define countries in R/3 systems (Transaction OY01) or Define Countries in mySAP.com Systems (CRM, EBP, APO, BW, SEM, …)
If you are on version 4.70 or higher you can use country codes from the field T005-INTCN3 instead from the field T005-LANDA. In that case you should activate check box “Country (new)” during execution the program.
IMG
General Settings
SAP d.o.o.
Currencies
Phone: +386 (1) 5881 255
Check currency codes
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 149 / 175
8.1.2
SKV form
Transaction SA38 -> Program /CCEE/SIFI_SKV To execute the program you have to define fields: Company code, Record type; Demand of Bank of Slovenia is to display report separately for short-term operating receivables and liabilities for non-resident customers and vendor with reporting company code capital connection. In case of company code capital connections you have to produce separate reports in SAP and export them to BSLO. For that purpose indicators 1.1., 1.2., 2.1., 2.2. and 3 are used, they reflect the differentiation rule of Bank of Slovenia reporting demand. Indicator 1.1. – used for short-term receivables and liabilities for direct investors (customers and vendors which are owning reporting company code in the share 10% or more). Indicator 1.2. – used for short-term receivables and liabilities for companies which belong to direct investors, Indicator 2.1. – used for short-term receivables and liabilities for direct investment receivers (nonresident customers and vendors which are owned by reporting company code in share 10% or more). Indicator 2.2. – used for short-term receivables and liabilities for companies in group of direct investment receivers, Indicator 3. – used for short-term receivables and liabilities for other non-resident customers and vendors. Vendor Account; enter G/L account number for foreign vendors, Customer Down Payment; enter G/L account number for customers down payments, Vendor; enter Vendor number - empty field means that all vendors are taken into the account, Customer Account; enter G/L account number for foreign customers, Vendor Down Payment; enter G/L account number for vendors down payments, Customer; enter Customer number - empty field means that all customers are taken into the account, Currency; empty field means that all currencies are taken into the account, Country; empty field means that all countries are taken into the account, Other Customer Document; field is used for the customer document exceptions reported under column Spremembe-Ostalo, if there are none enter non-existing number, ex. 9999999999, Other Customer Account; field is used for the customer account exceptions reported under column Spremembe-Ostalo,, if there are none enter non-existing number, ex. 9999999999, Other Vendor Document; field is used for the vendor document exceptions reported under column Spremembe-Ostalo, if there are none enter non-existing number, ex. 9999999999, Other Vendor Account; field is used for the customer account exceptions reported under column Spremembe-Ostalo, if there are none enter non-existing number, ex. 9999999999, Period for which we want to execute the report, Path where we want to save report on the local computer, folder and file name in txt format have to be defined, example c:\bs\skv.txt, Conversion in EUR; expired currencies (DEM, ITL etc.) will be converted in EUR, Country (new); country codes will be used from the field T005-INTCN3 instead from the field T005-LANDA, Transfer negative balances; program transfer negative balances on the right side in case of any incorrectness – this amounts are marked in red (i.e. amount of receivable is negative and if you activate transfer negative balances this amount will be transferred on the payable side as positive amount during preparation file to Bank of Slovenia). When making report types you specify individual vendors and customers which are ownership connected to reporting company code and their accounts, in other fields enter value 9999999999. SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 150 / 175
Example when only non-resident customer is owning reporting company code in the share 10% or more.
Execute the report. It is recommended to save report as a variant (for all record types) and only to change date on further monthly reporting process.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 151 / 175
Export to the predefined local file is made with the click on the icon “Import table for Bank Slovenia”. Saved txt file can be checked with click on icon “Date survey on the disc”.
8.2
SFR Form – Report of financial account statistics
Solution for SFR Form includes: table /CCEE/SIFIPODAT2, table /CCEE/SIFISTATE2 and program /CCEE/SIFI_SFR.
8.2.1
Table /CCEE/SIFIPODAT2
Prerequisite for preparing SFR report is that for each relevant G/L account, vendor and customer you define proper rules about financial instrument, sector, etc. in table /CCEE/SIFIPODAT2. Transaction SM30 -> Table /CCEE/SIFIPODAT2 Table includes the following fields: company code (BUKRS),
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 152 / 175
from – to account no. (SAKNR_LOW, SAKN_HIGH); you can enter G/L account, vendor or customer no., type of account (KOART); define what type of account is it (S - G/L acct., D -customer, K- vendor), financial instrument (FIN_INSTR); define no. of financial instrument without F., enter just numeric value, type of account (PAS_AKT); important for relevant form from 1 – 4. If account has assigned A (active) it means that it is relevant for Form 1 and 3 and amounts are calculated debet – credit. If account has assigned P (passive) it means that it is relevant for Form 2 and 4 and amounts are calculated credit – debet. sector (SECTOR); define relevant sector without S., enter just numeric value. In case that G/L acct. is defined as reconciliation G/L account for vendor/customer you do not enter sector, because sector is defined on vendor/customer line item in the table, Items are not valuated (FROM_DMBTR; if you activate it the amounts in foreign currency won’t be valuated on the report date in forms 1 and 2 (but read from field DMBTR). Table settings for regular G/L accounts With general G/L accounts are meant all G/L accounts which are not defined as reconciliation G/L accounts. For each G/L account or interval from – to you should define: type of account (KOART): S, financial instrument (FIN_INSTR): define no. of financial instrument without F., enter just numeric value, type of account (PAS_AKT): A (active) or P (passive), sector (SECTOR): define relevant sector without S., enter just numeric value.
In some cases the defined sector on G/L account segment in the table is not relevant for all line items in reporting period so you can define sector on document line item. Sector you can enter at the end of filed text in line item segment (BSEG-SGTXT) with prefix SFRS. (e.g. xxxxxxxxx SFRS.1311). The entered sector on document line item has priority before defined in the table.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 153 / 175
Table settings for Vendors/Customers For each business partner should be defined relevant data: type of account (KOART): D (customer) or K (vendor), financial instrument (FIN_INSTR): no entry because it will be taken from a G/L reconciliation account, type of account (PAS_AKT): A (active) or P (passive), sector (SECTOR): define relevant sector without S., enter just numeric value.
During the preparation SFR report sector will be taken from business partner (the first line in the table) and financial instrument from G/L reconciliation account (the second and third line in the table) in the table. In case that G/L reconciliation account is not defined in the table (missing), documents for this G/L account won’t be included in the SFR report. Table settings for reconciliation G/L accounts For each reconciliation G/L account should be defined relevant data in the table: type of account (KOART): S, financial instrument (FIN_INSTR): define no. of financial instrument without F., enter just numeric value, type of account (PAS_AKT): A (active) or P (passive), sector (SECTOR): no entry because it will be taken from a Vendor/Customer.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 154 / 175
During the preparation SFR report sector will be taken from business partner and financial instrument from G/L reconciliation account in the table. In case that business partner is not defined in the table (missing), documents for this business partner won’t be included in the SFR report.
8.2.2
Table /CCEE/SIFISTATE2
Transaction SM30 -> Table /CCEE/SIFISTATE2
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 155 / 175
The table /CCEE/SIFISTATE2 will be updated in case that you activate check box Update table with balances. The table include balances for each reporting period. You can fill it with amounts from previous reporting periods (e.g. 2014) – in that case you should import amounts from Form 1 and 2, because during the execution the program reads amounts at the beginning of the period/at the end of the previous reporting period and add amounts of transactions in the reporting period. The other way is that you run the program for previous reporting periods and activate Update table with balances (you should run program from the production start of FI module). First you have to update table for all periods in the past (check Form 3, 4 and Update …). Until then are values for Forms 1,2 meaningless. When amounts of the period are in the table you can run all forms as they want and no update check is needed to be selected (only when another period ends). In case that you do nothing concerning entries from previous reporting periods in that table, amounts in Form 1, 2 will be the same as in Form 3,4.
8.2.3
Program /CCEE/SIFI_SFR
Program /CCEE/SIFI_SFR enables you to prepare SFR report. SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 156 / 175
Transaction SA38 -> Program /CCEE/SIFI_SFR On the selection screen you can define: Company code, Fiscal year for reporting period, Posting date; For preparation Form 3, 4 you should define reporting period in the fields Posting date From – To. For preparation Form 1, 2 you should enter the key date of reporting in field Posting date From. Forms 1, 2; If you activate check box Forms 1, 2 program prepare Form 1 (Obrazec 1): Data about states of financial means on day (Podatki o stanjih finan nih sredstev na dan) and Form 2 (Obrazec 2): Data about states of obligation on day (Podatki o stanjih obveznosti na dan). Forms 3, 4; If you activate check box Forms 3, 4 program prepare Form 3 (Obrazec 3): Data about transactions of financial means in period (Podatki o transakcijah finan nih sredstev v obdobju) and Form 4 (Obrazec 4): Data about transactions of obligation in period (Podatki o transakcijah obveznosti v obdobju). Update table with balances; If you activate check box Update table with balances, the balances for the reporting period will be saved in the table /CCEE/SIFISTATES. It can be activate just in connection with Forms 3 and 4. NOTE: If the amounts exist in the table /CCEE/SIFISTATES for reported period and Check box Update table with balances is activated you get message: “All items in the year * will be deleted!”. Thousand separator; If you activate check box Thousand separator the amounts will be displayed with dots, commas and signs, Currency, currency translation key date and exchange rate type: By request Bank of Slovenia all values in report are presented in local currency EUR. That means that all values in foreign currency have to be converted into EUR at the reporting date (at the last day of the reported period, e.g. 31.12.2013). There you can define proper records.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 157 / 175
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 158 / 175
When you are updating the table of transactions /CCEE/SIFISTATE2 for counting states (Table 3&4), no output on the screen except 'Table updated' will appear. You can not prepare together Forms 1, 2 (transactions) and Forms 3, 4 (states).
8.3
BST Report - Report on service exchange, parts of goods exchange, and current capital transfers with non-residents (SAP Note 1063103)
Solution for BST Report includes: - table /CCEE/SIFI_BST_T, - table /CCEE/SIFI_BST_R, - program /CCEE/SIFI_BST and - form /CCEE/SIFI_BST.
8.3.1
Central bank indicator and Supplying country defined on BST report relevant documents
BST report basis on "Central bank indicator" (BSEG-LZBKZ) and "Supplying country" (BSEG-LANDL) which have to be defined in each BST relevant document/line item during the posting. Therefore in the corresponding field selection string for the posting key and G/L accounts and/or reconciliation accounts, the field SCB and Supplying country must be active.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 159 / 175
Slovenian SCB indicators template has been defined based on the statistical codes defined by Bank of Slovenia. Each SCB indicator can be assigned just one Reporting code. If one Statistical code is relevant for more than one BST reporting code, it is necessary to define the new one. SCB indicators can be maintained under IMG menu: SAP menu
Accounting Financial Accounting Accounts Receivable and Accounts Payable Business Transactions Incoming Invoices/Credit Memos Define SCB Indicators for Foreign Trade Regulations For Slovenian SCB indicators template check SAP Note 979869 State central bank indicator for Slovenia. For entering the Central bank indicator and Delivering country: - in SD please see the SAP Notes 27067, 301077 and 784491, - in Travel expenses (TRM) please see the SAP Note 1144364.
8.3.2
Table /CCEE/SIFI_BST_T
In the table /CCEE/SIFI_BST_T are defined Reporting codes, Description of each Reporting code and Seq. numbers. Transaction SM30 -> Table /CCEE/SIFI_BST_T
Table includes the following fields: SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 160 / 175
- Reporting code from the BST report (SIFRA), - Language Key (SPRSL), - Description of Reporting codes from the BST report (OPIS) - Sequential no. from the BST report (ZAP_ST).
8.3.3
Table /CCEE/SIFI_BST_R
Table /CCEE/SIFI_BST_R includes rules for preparing BST report. In the table SCB indicator has to be assigned to reported BST Reporting code for Incomings and Outgoings. Transaction SM30 -> Table /CCEE/SIFI_BST_R
Table includes the following fields: - SCB indicator for Incomings column in the BST report (PREJEMKI), - SCB indicator for Outgoings column in the BST report (IZDATKI), - Reporting code from the BST report (SIFRA). Template of the content of tables /CCEE/SIFI_BST_T and /CCEE/SIFI_BST_R is stored in the attachment of SAP note1063103.
8.3.4
Program /CCEE/SIFI_BST
Program /CCEE/SIFI_BST enable you to prepare BST report. Transaction SA38 -> Program /CCEE/SIFI_BST On the selection screen you can define: Company code, Fiscal year and period for reporting period, Document no., Document type, Supplying country, Posting date or Document date; define the date based on which data will be selected for reporting period, Entry date; Accounting document entry date, Posting key (Vendor); vendor posting keys for Outgoing side in the report; Vendor reconciliation acct.; reconciliation GL acc. for Outgoing side in the report, Offsetting account; offsetting account for Outgoing side in the report, Posting key (Customer); customer posting keys for Incoming side in the report, Customer reconciliation acct.; reconciliation GL acc. for Incoming side in the report, Offsetting account; offsetting account for Incoming side in the report, Posting key (GL); GL posting keys for Outgoing side in the report, you have to define PK 40 and 50 in connection with GL accounts for Outgoings; if you don't want to use this part of functionality in the report then define posting key 99, SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 161 / 175
GL Accounts; GL acct. relevant for Outgoing side in the report, Posting key (GL); GL posting keys for Incoming side in the report, you have to define PK 40 and 50 in connection with GL accounts for Incomings; if you don't want to use this part of functionality in the report then define posting key 99, GL Accounts; GL acct. relevant for Incoming side in the report, Relevant line items; if this check box is active the program includes in the first level of report all line items where SCB indicator and Supplying county are defined on the document line items and in the second level of report are included just line items with SCB indicators assigned to Reporting code in table /CCEE/SIFI_BST_R; if this check box is not active the program includes in the report all line items based on selection screen definition independent of SCB indicator and Supplying county definition on the document line items. In that case if you want to add this line items into the report you have to define SCB indicator and Supplying county in the document line items (otherwise they will be eliminated from the second level of report). Include block 1. Goods; tick off the block for which you want to prepare report, Include block 2. Services, tick off the block for which you want to prepare report, Include block 3. transfers, tick off the block for which you want to prepare report, ID no. of business partner (Mati na št.), Person responsible, Reporter, File name. Execute the program.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 162 / 175
Below is an example of BST First level report in case that check box for Relevant line items is not active. As we can see at the beginning there are some line items defined without SCB indicator and Supplying country.
If you want to report this line items in the BST report (second level) you should double click on the document no. and define SCB indicator and Supplying country for each relevant line item (Supp. Country is defaulted from vendor/customer master data during posting and has to be entered manually on GL acct.).
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 163 / 175
BST second level report you will get if you press on button for Sum of Incomings and Outgoings by Countries
.
Report can be exported into the file with press on button the predefined BST form is not supported for release 4.6C).
SAP d.o.o.
Phone: +386 (1) 5881 255
or printed with press on button
(print in
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 164 / 175
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 165 / 175
9. 9.1
Financial Statements Financial Statement Versions
Financial statement versions are versions of structured and grouped accounts into balance sheet and profit and loss statement and are base for various financial reports.
IMG Financial Accounting Closing Documenting
General Ledger Accounting Business Transactions Define Financial statement Versions
The financial statement versions that are part of the SI FI localization package are: BSI1 – Balance Sheet and Profit & Loss Statement (variant .), BSI2 – Balance Sheet and Profit & Loss Statement (variant .), BSI3 – Balance Sheet and Profit & Loss Statement (AJPES), BSI4 – Cash flow (base for report) Two of the above mentioned Financial Statement Versions (BSI1, BSI2) are structured according to Slovenian Accounting Standards and one (BSI3) is structured according to Republic of Slovenia’s agency AJPES. BSI4 is technical structure needed for execution of Cash Flow report. All of the versions are based on CASI chart of the accounts. In case that other chart of accounts is in use it is necessary to attach the used chart of the accounts to financial statement version and to define individual or interval of accounts for the statement item.
Accounts or accounts intervals are defined under “Financial statement items”. For each item an account or range of accounts are assigned.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 166 / 175
9.2
Balance Sheet and Profit & Loss Statement Reports
Based on Financial Statement Versions (BSI1, BSI2, BSI3), which are base for various financial reports (transaction F.01, F.08, program RFBILA00, etc.), special balance sheet and profit and loss reports are created. All reports are based on the reports form, which has to be defined prior to defining the report. Form can be created, changed or displayed with Transactions FSI4, FSI5 and FSI5:
IMG Financial Accounting General Ledger Accounting Drilldown Reports (G/L Accounts) Form Define Form
Information System
For the case of balance sheet and profit and loss reports two types of form and report have been created, these are “Financial Statement Analysis” and “Financial Statement key Figures”. “Financial Statement Analysis” reports are only tools for presenting the data from financial statement version on various ways. Only data and structure of financial statement version can be presented. On the other hand “Financial Statement Key Figures” reports enable us to use formulas for calculation partial sums or other relevant data which can’t be extracted directly from the accounts. Localization forms which are base for the reports are: SL-BSI Balance Sheet – SI, SL-BSI Balance sheet SRS SI, SL-BSI3 Balance sheet AJPES, SL-IPI-AJPES P+L Statement AJPES, SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 167 / 175
SL-IPI-VAR1 P+L Statement SRS I., SL-IPI-VAR1 P+L Statement SRS II. Example of the form:
Based on the forms, localization contained 8 different reports. The same create, change and display logic applies here with Transaction FSI1, FSI2 and FSI3.
IMG Financial Accounting General Ledger Accounting Drilldown Reports (G/L Accounts) Report Define Report
Information System
Balance Sheet Analysis Reports based directly on Financial Statement Versions: SL-BSI1 BS & P+L SRS var. I., SL-BSI2 BS & P+L SRS var. II., SL-BSI3 BS & P+L AJPES. Financial Statement Key Figures Reports: SL BS AJPES Balance sheet AJPES, SL BS SRS Balance sheet SRS, SL-IPI-AJPES P+L Statement AJPES, SL-IPI-VAR 1 P+L Statement SRS var. I., SL-IPI-VAR 2 P+L Statement SRS var. II. Beside Financial Statement Versions items reports contain items with partial sums, and are presented in the exact same structure as defined by Slovenian Accounting Standards and AJPES Agency.
9.3
Execution of the report
IMG Financial Accounting General Ledger Accounting Information System Drilldown Reports (G/L Accounts) Report Define Report (Transaction FSI3) Selection of the report:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 168 / 175
Click on the Execute icon and define Company Code, Fiscal Year and Output Type.
Example of Graphical Report Output: SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 169 / 175
Due to data extraction directly from the accounts reports are containing values with wrong prefixes (negative values in the fields extracted from the Liabilities part of Balance Sheet), on fields which are based on formulas such as subtotals prefixes are correct.
9.4
Cash Flow Report (indirect method)
Based on Financial Statement Version BSI4 cash flow report was created. Report is based on the reports form, which has to be defined prior to defining the report. Form can be created, changed or displayed with transactions FSI4 and FSI5:
IMG Financial Accounting General Ledger Accounting Drilldown Reports (G/L Accounts) Form Define Form
SAP d.o.o.
Phone: +386 (1) 5881 255
Information System
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 170 / 175
Based on the forms, localization contains report SL DEN TOK. The same create, change and display logic applies here with transactions FSI1, FSI2 and FSI3.
IMG Financial Accounting General Ledger Accounting Drilldown Reports (G/L Accounts) Report Define Report
Information System
Prerequisite for correct working of the report is correct assignment of the GL accounts to the Financial Statement Version BSI4.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 171 / 175
Financial statement version BSI4 is slightly changed Financial Statement Version BSI1. For balance sheet part structure was not changed, unlike the changed structure for P/L statement, where only cash flow relevant structures are kept. Company must assign cash flow relevant GL accounts to predefined structure according to following guideline, where position in structure of BSI4 Financial Statement Version is mapped with position of cash flow report defined according to Slovenian Accounting Standards.
3110000 3150000 3170000 1240000, 1150000 1300000 1160000 1210000 1220000 2320000, 2430000 2200000 2330000
3190000 1110000 1120000 1130000 1140000 1230000 1110000 1120000 1130000 1140000 1230000
A.Denarni tokovi pri poslovanju a)Postavke izkaza poslovnega izida Poslovni prihodki in finan ni prihodki iz poslovnih terjatev Poslovni odhodki brez amortizacije Davli iz dobi ka in drugi davki, ki niso zajeti v poslovnih odhodkih b)Spremembe istih obratnih sredstev Za etne manj kon ne poslovne terjatve Za etne manj kon ne A R Za etne manj kon ne odložene terjatve za davek Za etna manj kon na sredstva za prodajo Za etne manj kon ne zaloge Kon ni manj za etni poslovni dolgovi Kon ne manj za etne P R in rezervacije Kon ne manj za etne odložene obveznosti za davek c)Prebitek prejemkov pri poslovanju ali prebitek izdatkov B.Denarni tokovi pri naložbenju a)Prejemki pri naložbenju Prejemki od dobljenih obresti in deležev v dobi ku drugih, ki se nanašajo na ložbenje Prejemki od odtujitve neopredmetenih sredstev Prejemki od odtujitve opredmetenih osnovnih sredstev Prejemki od odtujitve naložbenih nepremi nin Prejemki od odtujitve dolgoro nih finan nih naložb Prejemki od odtujitve kratkoro nih finan nih naložb b)Izdatki pri naložbenju Izdatki za pridobitev neopredmetenih sredstev Izdatki za pridobitev opredmetenih osnovnih sredstev Izdatki za pridobitev naložbenih nepremi nin Izdatki za pridobitev dolgoro nih finan nih naložb Izdatki za pridobitev kratkoro nih finan nih naložb c)Prebitek prejemkov pri naložbenju ali prebitek izdatkov
2100000 2310000 2420000
C.Denarni tokovi pri financiranju a)Prejemki pri financiranju Prejemki od vpla anega kapitala Prejemki od pove anja dolgoro nih finan nih obveznosti Prejemki od pove anja kratkoro nih finan nih obveznosti
3230000 2100000 2310000
b)Izdatki pri financiranju Izdatki za dane obresti, ki se nanašajo na financiranje Izdatki za vra ila kapitala Izdatki za odpla ila dolgoro nih finan nih obveznosti
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 172 / 175
2420000 2440000
9.5
Izdatki za odpla ila kratkoro nih finan nih obveznosti Izdatki za pla ilo dividend in drugih deležev v dobi ku
Execution of the report
IMG Financial Accounting General Ledger Accounting Information System Drilldown Reports (G/L Accounts) Report Define Report (Transaction FSI3) Selection of the report:
Click on the Execute icon and define Company Code and Fiscal Year.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 173 / 175
Example of Report:
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 174 / 175
10. eDocument Framework All budget users must receive invoices solely in predefined electronic form (eInvoice). Basic solution for handling eInvoices, a so-called cockpit for management and sending of the relevant eDocuments to customers is part of SAP standard solution. For more info check SAP Notes: - 2061633 - eDocument Slovenia - Electronic Invoicing II - 2069613 - eDocument Slovenia - Customizing and Configuration Basic - 2069615 - eDocument Slovenia - Additional Information to the Basic Solution (custom implementation) Basic solution does not provide XML document preparation; however, local add-on has been developed for SAP ERP part (for invoices, issued from SD and FI modules) and enable to prepare XML document according to eSlog specification. Local add-on has been developed as “one-time” solution in a form of a consulting note and is not included in regular distribution of C-CEE Support Packages. It has been developed in “Z” namespace. Support is provided as a consulting service. Local “add-on” solution is available in SAP Note 2072049. For consulting services contact SAP Slovenia.
SAP d.o.o.
Phone: +386 (1) 5881 255
Fax: +386 (1) 5881 385 Dunajska cesta 156, 1000 Ljubljana, Slovenia www.sa p. si Page 175 / 175