High- Level Specification
| Parameter | Value |
|---|---|
| Application System | S/4Hana ROW, S/4Hana CUI |
| Business Process Reference | 09.06.02.04. Manage Centralized Outgoing Payments on Behalf of Subsidiaries 09.06.02.05. Manage Centralized Incoming Payments on Behalf of Subsidiaries |
Functional Overview
Its needed to enable a monitor that is able so display the invoices selected in the IHB and the ones that not in case its needed to take action.
This will require a FIORI app to access by business.
Scope and Objectives
The project involves the implementation of a factoring solution within In-House Bank (IHB) using the S/4 Hana FI/IHB module. This system is designed to handle transfer of AP/AR items that are relevant for factoring, to the IHB center for further collection/payable management.
This enhancement covers the monitor to review the integrated items and bring the capacity to integrate new ones.
Process Flow Diagram
09.06.02.04. Manage Centralized Outgoing Payments on Behalf of Subsidiaries
09.06.02.05. Manage Centralized Incoming Payments on Behalf of Subsidiaries
Step | Description | Comment |
|---|---|---|
| 1 | Open the Fiori application to access the report | |
| 2 | Select the parameters from the selection screen | The report should have a selection screen with the following fields .All fields they need to be able to select single value, a range of information or multiple values. |
| 3 | Display the output of the report | The Output of the report should be ALV features to add / remove fields , sort , sum/semisum, sort, filter, … |
| 4 | Select / Deselect invoices for Factoring | When I display the information, I should be able to select and deselect the relevant invoices for Factoring (selection flag with multiple selection or all should be available and a button to execute the action).
|
Assumptions
All BPs extended to the companies in countries specified in Z table would be relevant for factoring except the ones which are specifically excluded based on the Checks specified
Dependencies
Finance Invoice settings
APM / In House Bank Settings
Enhancements relating to performing factoring of the open invoices (AP/AR) from affiliate to IHB from 953 to 959 and 963
Security, Integrity and Controls
Follow program authorization checks
Configuration Requirements
Finance Invoice settings
APM / In House Bank Settings
Language Requirements
No specific language requirement
Special Requirements
NA
Design Rationale
Functional Requirements
Z table or Filter table (STVARV) entry must be created for storing countries. These countries represent countries of the company code that are relevant for factoring. Only exception to the above is the IHB entity itself.
Z program must check all BPs extended to the entities belonging to these countries except BPs extended to IHB itself, and populate the house bank field IHB1. This modification to the BP must not trigger any release workflow.
Proposed Technology to Use
Custom program
Data Source Considerations
| Table | Field Name | Comments/Calculation/Field Manipulation |
|---|---|---|
| KNB1 | HBKID | This field must be filled by the program |
| LFB1 | HBKID | This field must be filled by the program |
Data Validation Considerations
NA
| Table | Field Name | Comments/Calculation/Field Manipulation |
|---|---|---|
Custom Tables
N/A.
Master Data
NA
| Field | Description | Data Type/Length | Validation rule/ Value Help |
|---|---|---|---|
Configuration Table
NA
| Field | Description | Data Type/Length | Validation rule/ Value Help |
|---|---|---|---|
Selection Screen Enhancement
The report should have a selection screen with the following fields :
| Field Name | Description | Select: | Data Type/Length | Default Value/ Validation rule/ Value Help | Selection Logic |
|---|---|---|---|---|---|
BUKRS | Company code | Radio Button | CHAR(4) | Mandatory Field | |
KUNNR | Customer Number : Customer account number for receivables postings | Radio Button | CHAR(10) | ||
LIFNR | Vendor Number: Account number of vendor or creditor | Radio Button | CHAR(10) | ||
| BUDAT | Posting Date: Date when the document was posted to SAP. | Radio Button | DATS (8) | Mandatory Field | |
GJAHR | Fiscal year | Radio Button | NUMC(4) | Mandatory Field | |
| Document Type (BLART) | Type of accounting document (invoice, payment, etc.) | Radio Button | |||
| BELNR for FI, billing document number for SD | Invoice document number |
Processing Logic
The main tables to retrieve the information are:
- Finance information : ACDOCA (or BSEG, BKPF, FAGLFLEXA,FAGLFLEXT… )
- IHB Contract : /PF1/DB_ORDER ( from Clearing area onwards from the previous list )
- Payment Information : BNK_BATCH_ITEM / BNK_BATCH_HEADER / REGUHM/REGUT / FEBEP
Its expected to use API to retrieve the information if possible:
- Display Document (for FI accounting documents) : API_JOURNALENTRYITEMBASIC_SRV ( BAPI_ACC_DOCUMENT_FIND / BAPI_ACC_DOCUMENT_READ ) / FB03
- Display Billing Document (for SD invoices) : API_SUPPLIERINVOICE_PROCESS_SRV ( BAPI_INCOMINGINVOICE_GETDETAIL ) / VF03
- Display Invoice Document (for MM vendor invoices) : API_SUPPLIERINVOICE_PROCESS_SRV ( BAPI_INCOMINGINVOICE_GETDETAIL ) / MIR4
- ...
| Display the output of the report : | The Output of the report should be able to share the following information: Finance Information
IHB Contract
Payment information
It should be available ALV features to add / remove fields , sort , sum/semisum, sort, filter, … |
| Select / Deselect invoices for Factoring | When I display the information, I should be able to select and deselect the relevant invoices for Factoring (selection flag with multiple selection or all should be available and a button to execute the action). This should happen to be updating the invoice Payment Block Key ( ZLSPR ) and House Bank and Account ID if required). In case of deselect it should be verified that the Factoring contract is created, in case it is Reversal program should be called as well to reverse the factoring contract.
|
Volumetrics
This volume is estimated to be approx: 10000
Performance Considerations
In case of performance issues due to large number of information to be processed it should be raised the message to restrict the selection parameters and stop the execution.
Error Handling
Error Code | Description | Type Of Error | Resolution |
Testing
How to Test
Test Conditions and Expected Results
| ID | Condition | Expected Result |
|---|---|---|
| 1 | Run the Fiori application | Selection Screen should be displayed |
| 2 | Execute the Report layout | Report information is shown |
| 3 | Select invoice for factor | Invoice integrated in the IHB |
| 4 | Deselect invoice for factoring | Invoice reversed from the IHB |
Test Considerations/Dependencies
Data set should be created for multiple scenarios:
AP:
- Invoice factored and paid
- Invoice factored but not paid
- Invoice non factored
AR
- Invoice factored and paid
- Invoice factored but not paid
- Invoice non factored
Other Information
Development Details
Package
| Package Name | Parent Package |
|---|---|
Enhancement Implementation
| Enhancement Type | Standard Definition Name | Custom Implementation Name | Design Rationale Reference |
|---|---|---|---|
Other Development Objects
| Object Type | Object Name | Purpose/High Level Logic | Design Rationale Reference |
|---|---|---|---|
Appendix
Custom Authorization Group Naming Convention
This table is based on the Syensqo development standards document. It provides the naming conventions for authorization groups to associated with custom reports and tables to comply with security requirements.
ABAP | ZFI | ZMM | ZPS | ZCO | ZSD | ZBC | ZFI | ZCA |
|---|---|---|---|---|---|---|---|---|
| TABLES | ZFIT | ZMMT | ZPST | ZCOT | ZSDT | ZBCT | ZFIT | ZCAT |