alongside SAP on the sub-menu on the left. Additional options will be displayed.This report extracts the financial transactions to be uploaded into SAP Financials.
Also refer to
Client Specific
Barclays Africa
SAP Financial Extract Translation Values
From the General menu, click alongside SAP on the sub-menu on the left. Additional options will be displayed.
To create a new report, select New from the sub-menu on the left. The SAP Report screen will be displayed.
To generate a report, capture details as follows:
|
Administrator |
Select an Administrator from the drop-down list.
Mandatory |
|
Administrator Branch |
Select an Administrator Branch from the drop-down list.
When the Administrator Branch drop down is selected and an Administrator has been selected, the system will provide a list of only the Administrator Branches linked to the Administrator selected.
Mandatory |
|
From Date |
The date from which financial transactions must be displayed. The From Date must be the first day of the month.
If no date is captured, the system will default the From Date to the first day of the month prior to the current date and enable a date to be captured.
The completion of this field is mandatory. |
|
To Date |
The date to which financial transactions must be displayed. The To Date must be the last day of the month.
If no date is captured, the system will default the To Date to the last day of the month prior to the current date and enable a date to be captured.
The completion of this field is mandatory. |
|
|
Capture the email address to which the report must be sent.
The completion of this field is mandatory. |
Click GENERATE.
The following screen confirms that the Report has been submitted.
When GENERATE REPORT is selected, the system will extract all of the Business Transaction for the Schemes linked to the Administrator Branch selected with a Transaction Date greater than or equal to the report From Date and less than or equal to the report To Date and for which the Stakeholder is FUND and the Purpose Class is OPERATIONAL.
For each Business Transaction included in the extract file, the Link Date will be updated with the run date.
The system will sum the BT’s for which the Scheme Code, Account Code, Qualifier (Income Type or Expense Type), Due Date and Accounting Activity are the same.
The system will read the Pooling Status for the Scheme selected and if it is MAIN UMBRELLA, will extract the BT’s for each of the SUB UMBRELLA Schemes linked to the Scheme. The system will sum the BT’s per SUB UMBRELLA Scheme, Account Code, Qualifier, Due Date and Accounting Activity.
If no Translation Value is found for the combination of Account Code and Account Qualifier on the BT on the Translation record for which the Source System Attribute is ACC/QUAL and the Target System Attribute is ACCOUNT, the file will not be created and an error message will be written to the error log.
Note:
This is done to avoid the risk of extracting only one side of a transaction.
The information will be extracted as per the tables below:
Heading
FCP_BULKJO
Header
|
Field Name |
Details |
|
Co. Code |
Read translation value for the Translation Value record for which the Purpose is INP TO SAP AFS and the Source System ID is IN.PENSIONS, the Source System Attribute is COUNTRY the Target System ID is SAP AFS and the Target System Attribute is COMPANY CODE. Find the Translation value for the value for Country for the Scheme |
|
Doc. Date |
Report To Date in the format ccyymmdd |
|
Pst. Date |
Report To Date in the format ccyymmdd |
|
Doc. Type |
Default to SA |
|
Reference |
Leave blank |
|
Currency |
Currency for the Scheme |
|
Header Text |
Read translation value for the Translation Value record for which the Purpose is INP TO SAP AFS and the Source System ID is IN.PENSIONS, the Source System Attribute is COUNTRY the Target System ID is SAP AFS and the Target System Attribute is JOURNAL ID. Find the Translation value for the value for Country for the Scheme. Set this value to the Translation Value followed a space and then the Month and Year of the report To Date in the format MM/CCYY |
|
Bal. Acct |
Default to 199930 |
|
Bal. Profit |
Default to 99913 |
|
Bal. Text |
Default to BALANCING LINE |
|
Post Method |
Default to C |
Transaction Section
|
Field Name |
Details |
|
Co. Code |
Leave blank |
|
Post. Key |
If the value for the DB CR Ind field on the Business Transaction is D set this to 40. If it C set this to 50. |
|
Account |
Read the translation value for the combination of Account Code and Account Qualifier on the BT on the Translation record for which the Purpose is INP TO SAP AFS and the Source System ID is IN.PENSIONS, the Source System Attribute is AAC/QUAL, the Target System ID is SAP AFS and the Target System Attribute is ACCOUNT. Find the Translation value for the combination of Account Code and Account Qualifier. If there is no value for Qualifier in the Source System Translation value e.g. the value is BANK and not BANK/12345678 find the Translation value for just the Account. |
|
Amount |
Sum of the Amounts for the BT’s per Scheme Code, Account, Qualifier and Accounting Activity |
|
Cost Center |
If the Account Type Code for the Account is INCOME or EXPENSE read the translation value for the Translation Value record for which the Purpose is INP TO SAP AFS and the Source System ID is IN.PENSIONS, the Source System Attribute is SCHEME the Target System ID is SAP AFS and the Target System Attribute is COST CENTRE. Find the Translation value for the value for the Scheme Code. If the Account Type Code is not INCOME or EXPENSE leave blank. |
|
Prof. Ctr |
If the Account Type Code for the Account is ASSET or LIABILITY read the translation value for the Translation Value record for which the Purpose is INP TO SAP AFS and the Source System ID is IN.PENSIONS, the Source System Attribute is SCHEME the Target System ID is SAP AFS and the Target System Attribute is COST CENTRE. Find the Translation value for the value for the Scheme Code. If the Account Type Code is not ASSET or LIABILITY leave blank. |
|
Item Text |
Scheme Name |
|
Calc. Tax |
Leave blank |
|
Tax Code |
Leave blank |
|
Segment |
Read the translation value for the Translation Value record for which the Purpose is INP TO SAP AFS and the Source System ID is IN.PENSIONS, the Source System Attribute is SCHEME the Target System ID is SAP AFS and the Target System Attribute is SEGMENT. Find the Translation value for the value for the Scheme Code. |
|
Assignment |
Leave blank |
Click View below SAP. The Report Selection screen will be displayed.
This screen displays a list of the extracts created.
The following columns are displayed:
- Product
- Timestamp
- Date Captured
- Report Type
- Sequence Number
- Action
To sort the reports in ascending or descending order, select either the Asc or Desc radio buttons.
Click SEARCH.
The data on the Report Selection screen will be sorted into the required order.
To display a report, click on the hyperlinked display in the Action column.
The Report Selection screen will be displayed.
The Report displays the Heading value at the top of the report and the Header column headings and header data followed by the Transaction Section column headings and then the Transaction Section details as per the tables under Processing above.
The data will be displayed in the columns as per the table below:
|
Heading |
Header |
Transaction Section |
|
|
Column Heading |
Column Heading |
|
FCP_BULKJO |
Co. Code |
Co. Code |
|
|
Doc. Date |
Post. Key |
|
|
Pst. Date |
Account |
|
|
Doc. Type |
Amount |
|
|
Reference |
Cost Center |
|
|
Currency |
Prof. Ctr |
|
|
Header Text |
Item Text |
|
|
Bal. Acct |
Calc. Tax |
|
|
Bal. Profit |
Tax Code |
|
|
Bal. Text |
Segment |
|
|
Post Method |
Assignment |