Tasks to be completed when documenting an operation (from creation to publication)

 1. Enter the Title of the operation / page

2. Add the following Labels : 

    • Scope of applicability: ww, country_accounting 

    • Country or group of countries (if applicable): belux, china, france, italy, lam, nam, uk_ie, bulgaria, dach, netherlands, iberia, poland, latvia, australia, india, japan, south_korea, thailand, singapore

    • Unit and Domain according to the List of labels to be used in the Finance Service Line space

      • E.g. 1: WW Operation in Financial Accounting under domain "Central Finance Processes & Compliance":
        • Labels to be used: ww, financial_accounting, central_fin_proc_compliance

      • E.g. 2: France Operation in Financial Accounting:
        • Labels to be used: country_accounting, france, financial_accounting
          (for country operations, the Domain is always country_accounting)


3. Fill in all fields as described above

 4. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow 


Domain: Country Accounting

Responsibility area: N/A

Table of contents 

By default the table of contents displays Heading 1 & Heading 2 (other levels can be added)


Scope

3. Remove the icon when not applicable


ERP

4. Remove the icon(s) when not applicable


Frequency

5. Remove the icon(s) when not applicable

 

 

References

6. Add the link to SAP transaction(s) (when it exists)

N/A


Forms

7. Insert the links accordingly and change the link text with the OP name

N/A


Attachments

Deutsche Bundesbank Website

SCo - ZA5 report to central banks

GAR library

Extracting from AODocs to a Spreadsheet - Instructions



Previous OP << >> Next OP



1. Objective and Scope

1.1. Objective of this Procedure

The purpose of this document is to explain how to prepare the variants used to extract a specific report to the central bank in Germany (Deutsche Bundesbank).

This report is called Annex Z 5a sheet 2 which refers to the assets and liabilities of the goods and services to foreign non-banks.  
The report must be submitted quarterly until the 20th, in the month before the quarter closing.

Accounting Platform is responsible to update the variants in transaction S_ALR_87010021. With these variants IS runs a program called “X_ZDF_020_M_ERP_RFAWVZ5A_LZB”. This can be checked in transaction SM37. Afterwards, CAM is responsible to extract the reports from transaction OADR with variant DE_RFAWVZ5A and send these reports to the Deutsche Bundesbank.

More background information can be found in the following link: Deutsche Bundesbank Website.

1.2. Scope

This procedure applies to German companies.


2. Definitions

See Finance Glossary:


3. Tasks description


In order to identify which customer and vendor numbers must be included or excluded from the variants there is a support google document which contains three tables, one for each category mentioned  (1, 2 and 3) (1):  ZA5 report to central banks.  

In this file, CAM's fills in the trading partner columns which can be found in the tabs identified by company code.

3.1. I identify the customer and vendor numbers related to “Unternehmen mit Beteiligung am Meldepflichtigen (Spalte 81-86)” and “Unternehmen mit Beteiligung des Meldepflichtigen (Spalte 87-92)”


With the information of trading partners provided by SBS SL Finance Front Office, Finance Operations within the Service Center can extract the customer and vendor number from transaction SQ00, query Z_RFAWVZ5A_PAR. This extraction must be done for each company.  If necessary, go to English version to extract data.


 Select   and the following screen is displayed:


In this screen please insert the trading partners provided by SBS SL Finance Front Office in field “Company ID of Trading Partner” and  The outcome appears with the following layout:


With this information the google document mentioned above can be completed with customers and vendors by company code:

 


The information shown in this table must be copied to tab , table .

 


The information shown in this table must be copied to tab , table

3.2. I Identify the customer and vendor numbers related to Verbunden über gemeinsame Beteiligten (Spalte 93-98)

In this section we must include all Group companies outside Germany not listed in category 1 and 2 (Unternehmen mit Beteiligung am Meldepflichtigen (Spalte 81-86) and Unternehmen mit Beteiligung des Meldepflichtigen (Spalte 87-92)).                     

In order to identify all customer and vendors which should be included in this category, please follow the steps here under:


1) Go to GAR List and extract all company codes EXCEPT German companies and external companies (such as sold companies).

Link to GAR list.

Don’t  change nothing, make sure that the   is selected.

Extract the data to excel:


Follow the instructions on how to extract: Extracting from AODocs to a Spreadsheet - Instructions.

This document will generate a file in your google drive. Download this file.

From this list, Filter by Active companies and exclude all German companies.

Inside of the file, paste this list of PRS companies into tab   in blues cells. 



2) Go to transaction SQ00, select query Z_RFAWVZ5A_PAR and .



Insert the company codes extracted from the GAR list (point 1) in field “Company ID of Trading Partner”:

Execute .

Extract the data as follows:

Go to  and select “local file”, “Spreadsheet”.

  

  


3) Copy the extracted data into tab .



4) Go to transaction SQ00, select query Z_RFAWVZ5A_PAR with Active companies and copy in green columns inside Sheet Active companies. 


3.3. I update the variants in transaction S_ALR_87010021

On a quarterly basis, ACP team needs to update the variants in transaction S_ALR_87010021 as detailed below.

In order to execute this procedure you need to log in SAP in DE language otherwise the texts of transaction S_ALR_87010021 will not be displayed.


CompanyVariant to update

5642

ZDF_5642


Make sure that the fields are filled:

  • Buchungskreis (company code)

Three folders must be updated for customers (Debitor) and vendors (Kreditor) (1) :

  1. Unternehmen mit Beteiligung am Meldepflichtigen (Spalte 81-86) = Receivables and liabilities arising from goods and services with associated foreign non-bank companies, which hold participations in the reporting party (columns 81-86)

  2. Unternehmen mit Beteiligung des Meldepflichtigen (Spalte 87-92) = Receivables and liabilities arising from goods and services with associated foreign non-bank companies, which are participated by the reporting party (columns 87-92)

  3. Verbunden über gemeinsame Beteiligten (Spalte 93-98) = all Group companies outside Germany not listed in category 1 + 2

Copy the data from file ZA5 report and update all variants inside tab " Verbundene Unternehmen"




End of document.