1. Objective and Scope

1.1. Objective of this Operation

To be able to fill a Survey called “SPE - Inquérito aos Serviços Prestados às  Empresas” for a public entity of statistics (INE). 

• The purpose of the Business Services Survey (SPE) is to harmonize the sectoral statistics on services in 8 specific areas of activity:
   - Architecture, engineering and related techniques;
   - Accounting, auditing and consulting;
   - Technical tests and analysis;
   - Market research and opinion polling;
   - Informatics and related activities;
   - Legal activities;
   - Publicity;
   - Employment activities;
  

1.2. Scope

This procedure applies to the following Portuguese company:

• 6424: SYENSQO PORTUGAL - UNIPESSOAL LDA (PF2)SLSLV SPECIALTIES PORTUGAL, UNIPESSOAL, LDAV SPECIALTIES PORTUGAL, UNIPESSOAL, LDAECIALTIES PORTUGAL, UNIPESSOAL, LDA

2. Definitions

Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary 

See Finance Glossary:

• CAM – Company Accounting Manager
• PF2 – Syensqo Legacy's SAP system
• ACP SL - Accounting Platform Service Line
• IS - Information Services.

3. Concepts

1. What is a COPE?

COPE are external transactions conducted by the entity itself. Transactions intermediated by the resident banking system, transactions directly with non-resident entities through external accounts or clearing accounts, and transactions in current accounts should be communicated. Within the scope of such reporting, end-of-period positions on loans, trade credits or external deposits/deposits abroad are also considered.

2. What is a COL?
COL are transactions communicated by the resident banking system on behalf of customers. External settlements on behalf of resident customers and transactions on behalf of non-resident customers should be communicated. This information should be communicated on an individual transaction basis, not specifying any statistical classification.

COL are made available to enterprises for consultation or use to create COPE, through the Collection Application on the Corporate Area.

4. Tasks description

This procedure consists in 2 parts:

• The first one is to verify and correct the data in SAP before extracting the XML file.
• The second part is to submit the information to Banco de Portugal.  

4.1. Responsibilities

• CAM – To correct information, Check it and submit the report.
• IS – To edit tables if needed.

4.2. Periodicity

This report must be delivered every month until 15º useful day /M+1.

The COL it's available in " Aplicação de Recolha" on the 8º useful day. 

5. I check and correct data in SAP

5.1. I analyze the Output Types - P (payments) & O (open Items) 

5.1.1. I analyze the output type - P (Payments)

To analyze the rows that are Payments in Output Type:

1. Check if the Vendor/Customer is from Syensqo;
   
   
2. Go to the Vendor or Customer line items (FBL1N for Vendors and FBL5N for Customers) and check the invoice for the amount that we are analyzing. In the invoice, we need to certify if it is a Service or a Stock movement.

5.1.2. I analyze the output type - O (Open Items)

To analyze the rows that are Open Items in Output Type:

1. Check if it is a Vendor or a Customer and if it is a Group or External company (Check on Trading Partner and Description of the Customer/Vendor);
   
   
2. For Open Items there is no need to check the line items. We just need to know if it is a customer or a vendor and if it is Group or External Company.

5.2. I edit the table Z1F_CBR_ENTITIES

To check for new vendors, go to S_ALR_87012086 using variant “SCO VENDORS BP”:

To check for new customers, go to S_ALR_87012179 using variant “SCO CUSTO BP”:

In both variants, in the dynamic selection, update the period range for the year you are reporting. 

To correct the missing SCB Codes, go to transaction SM30 and in field Table/View fill with:

Z1F_CBR_ENTITIES ( in PF2) 

ZFI_CBR_ENTITIES ( in WP2)

Then, select Maintain and you will have the following table:

To add the new customer/vendor to correct the missing SCB, click on “New entries”

With your analysis, you are able to fill the table:

We need to fill the following fields: 

• CoCd: 6414 / 6424
• AccTy: Vendor / Customer
• OutType: Open Items / Payments
• Partner: Vendor number / Customer number
• SCB Code: Check table with the codes on 3.3.1.
• SCB Cod Cr: Check table with the codes on 3.3.1. (same code as field SCB Code)
• Acc. Type: If OutType is Open Items, select "Sem movimentação" & if OutType is Payments, select "Outra Conta Externa"

Depending on the Country, Value Type, Account Type and Output type, the movements can assume the following codes:

Now, save and the missing SCB Codes will be corrected.

Run in PF2 transaction Z1F_BANK_PT and in WP2 transaction ZFI_BANK_PT again, add all columns to layout, do a subtotal by SCB Code, collapse and check if there are any missing SCB Codes left.
It must be like in the following example:

5.3. I run in PF2 the SAP transaction Z1F_BANK_PT and in WP2 the SAP transaction ZFI_BANK_PT

5.3.1. I run in PF2 the SAP transaction Z1F_BANK_PT 

Go to transaction Z1F_BANK_PT to retrieve the report with clients and vendors movements in CICC account.

Inside the transaction, go to variants and you will find variants for PT companies.

Run the transaction with CCCC ALV variant.

Add all possible columns to the layout:

After Run select layout COPE

Do a Subtotal by SCB Code, collapse and expand only the row with missing SCB Code:

Save the information in excel file with name ALV CCCC. This information will be necessary to fill excel PT SCO CCCC Banco de Portugal MM.YYYY, in sheet "SAP CCCC". 

5.3.2. I run in WP2 the SAP transaction ZFI_BANK_PT

Go to transaction ZFI_BANK_PT to retrieve the report with clients and vendors movements in CICC account.

Inside the transaction, go to variants and you will find variants for PT companies.

Run the transaction with CCCC ALV variant.

Add all possible columns to the layout:

Do a Subtotal by SCB Code, collapse and expand only the row with missing SCB Code:

Save the information in excel file with name ALV CCCC. This information will be necessary to fill excel PT SCO Banco de Portugal MM.YYYY, in sheet "SAP CCCC".

In 10. Appendix  it is explained the description for each column.

We must analyze each item that does not have a SCB Code.

5.4. I Request IS to update Other Tables

If for some reason it is necessary to modify the other tables, please request IS :

for PF2 Z1F_CBR_SCB or Z1F_CBR_BANKS

for WP2 ZFI_CBR_SCB or ZFI_CBR_BANKS

In Service One choose

Example:

6. I extract SAP information

Go to Transaction Z1F_BANK_PT in PF2 and ZFI_BANK_PT in WP2. 

Choose Variant CCCC XML , being CCCC the company code.

Choose where you want to save the XML in "Directory Path".

This variant will create a XML document like  and will be saved in "Directory Path" chosen (in this example in Downloads).

This is the document that will be submitted in the Banco de Portugal Website.

7. I fill the excel file "PT SCO CCCC Banco de Portugal_MM.YYYY"

Fill the excel file from previous month as template saved in Google Drive. Please follow paths below: 

6414 - COPE

6424 - COPE

The files have each other 5 sheets and the following topics will explain how to fill them.

7.1. I fill the sheet "SAP CCCC"

Fill this sheet with information from file ALV CCCC that you extract in step 5.1.: 

7.2 I fill the sheet "XML CCCC"

To fill this sheet we need to extract the information from the XML file created in step 6.

Open a new excel document and open the file XML as a XML Table:

It will open a table and you will have to copy that information to the XML CCCC sheet:

After having copied all the information, you must refresh the pivot table on the right side to update it with the new information.

7.3 I fill the sheet "BP Resumo CCCC"

7.3.1. I fill the period of report

Update the date that you are reporting in cell B1.

7.3.2. I update the pivot table

We must refresh the pivot tables with name "ALV" and "XML":

7.3.3. I check some items

Now we need to check:

1) SCB Code L0224

Go to transaction FS10N and check if accounts, in PF2 7510030000 & 6500030000, in WP2 98532100 and 98531100, have any amount. There will be a row with code L0224.

2) SCB Code L1131-P / L2131-P

Go to transaction FS10N and insert in account, in PF2 591EUR2232 and in WP2 58EUR500. Check if the amount on Cum. balance of the current month matches the amount in row L2131.

The control in cell E90 must be zero. If you have a difference, it can be from accounts in PF2 2200250000 or 2300250000, and WP2 41100900 or 40100900.

If you need to perform any correction, please add the new information in "Acertos":

Note: It can happen that we need to perform one correction in code Z1020 OS. If indeed we need to make this correction, the report in Banco de Portugal site also needs to be manually corrected.

8. I submit in Banco de Portugal website

8.1. I entry in Banco de Portugal website

Go to Banco de Portugal Website → Aplicação de recolha → Empresas

                                                     ↓

Select "Utilizar dados do Portal das Finanças" and then insert the the same access credentials from "Portal das Finanças":

8.2 I submit information in Banco de Portugal website

Import the XML file that you extracted from SAP to Banco de Portugal Website.

Select "Importar Ficheiro"/ "Choose file":

And select the file  that you extracted form SAP in step 6.

8.2.1. I perform the corrections if needed

In this case there was no need to perform any correction. However, if it was needed, I would have to look for the Code that needed correction, selectand make the necessary changes.

P.s. Be aware that you can have more than one page.

8.2.2. I perform the validation

In Banco de Portugal Website, copy all the information in table "Comunicação de operações e posições com o exterior - COPE":

And paste the information in excel file PT - Banco de Portugal yyyy-mm, in sheet BP CCCC:

8.3. I submit

Click in "Submeter"

And it will appear the following message:

Add the print in sheet "Print CCCC".

9. I save all information in Drive

Save all information in drive:

For 6414:

6414 - COPE

For 6424:

6424 - COPE

10. Appendix

10.1. Table Z1F_BANK_PT

10.2. Table ZFI_BANK_PT

11. Legislation

INSTRUÇÃO N.º 27/2012 - (BO N.º 9, 17.09.2012) - Estatísticas de Operações e Posições com o Exterior

Instrução (Histórico) n.º 56/2012 - Estatísticas de Operações e Posições com o Exterior

MANUAL DE PROCEDIMENTOS

End of document.