09.06.02.04. Manage Centralized Outgoing Payments on Behalf of Subsidiaries

09.06.02.05. Manage Centralized Incoming Payments on Behalf of Subsidiaries

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. 

The Output of the report should be  ALV features to add / remove fields , sort , sum/semisum, sort, filter,  …

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). 

BUKRS 

KUNNR

LIFNR

GJAHR 

 Invoice document number

The Output of the report should be able to share the following information: 

Finance Information ( original invoice and header one ) 

• Document Number (BELNR): Unique identifier for the accounting document . This field should be possible to navigate to display the FI invoice.  It can be use the same logic as FAGLL03 report 
• Company Code (BUKRS): Company code where the document was posted
• Fiscal Year (GJAHR): Fiscal year of the document posting
• Document Date (BLDAT): Date on the document
• Posting Date (BUDAT): Date when the document was posted to SAP 
• Document Type (BLART): Type of accounting document (invoice, payment, etc.)
• Reference Document (XBLNR): External reference number . This field should be possible to navigate to display the FI invoice.  It can be use the same logic as FAGLL03 report 
• Customer ( KUNNR )  /  Vendor (LIFNR )  : Customer / Vendor account number.
• Header Text (BKTXT): Descriptive text for the document header . This will include the invoice reference number of the subsidiary . So it  should be use to retrieve the information of the invoice of the subsidiary. 
• Currency (WAERS): Document currency
• Entry Date (CPUDT): Date when document was entered into system
• Entered By (USNAM): User who created the document 
• Amount (WRBTR): Amount in document currency
• Cash Discount Amount ( WSKTO ) : Cash discount amount in document currency
• Cash discount percentage rate ( SKTOF) : Cash Discount Percentage 
• Assignment (ZUONR): Assignment field for additional reference
• Text: Line item text description
• Cost Center (KOSTL): Cost center assignment 
• Business Area (GSBER): Business area assignment 
• Profit Center: Profit center assignment 
• Trading Partner (VBUND): Trading partner information
• Sales Order (KDAUF): Sales order reference 
• Sales Order Item (KDPOS): Sales order line item reference
• SD Billing ( AWEKEY ): SD Billing Document
• Payment Ref ( KIDNO ) : Payment Reference
• Reference Key (XREF1 ) : Relevance information in text field
• Reference Key (XREF2 ) : Relevance information in text field
• Reference Key (XREF3 ) : Relevance information in text field
• House Bank (HBKID): Bank identification key for house bank master data
• Account ID (HKTID): Account identifier within the house bank
• Payment Block Key (ZLSPR): Field for selected invoices for factoring

IHB Contract ( /PF1/DB_ORDER ) 

• Clearing Area ( CLEARING_AREA): Clearing area identifier for payment processing
• Factoring Contract Number (PI_NO) : Unique payment item number
• Payment Item Date ( PI_DATE) : Date of the payment item
• Technical Status ( TECH_STAT ) : Technical processing status of payment item
• Transaction Type (TRANS_TYPE ) : Type of payment transaction
• Transaction Amount ( TR_AMOUNT) : Payment transaction amount
• Transaction Currency ( TR_CURR ) : Currency code for transaction amount

Payment information:

From the header document in case of payable:

• Batch : Unique identifier linking to BNK_BATCH_HEADER  from BNK_BATCH_ITEM (  IDBATCH_ID )
• Item Number : ( ITEM_NO -BNK_BATCH_ITEM ) Sequential number identifying individual items within batch
• Document reference: REFERENCE_DOCBELNR -  BNK_BATCH_ITEM
• Vendor/Customer ( PARTNER- BNK_BATCH_ITEM ) Business partner number (vendor or customer)
• Item Status ( STATUS - BNK_BATCH_ITEM )  Current processing status of the payment item
• Payment Method ( PAYMENT_METHOD - BNK_BATCH_ITEM )  Method used for payment execution

In case of receivable from the bank reconciliation:

• Reconciled Item :  FEBEP- VB2OK = 'X' its reconciled . VB2OK = ' ' means unreconciled.  when its reconciled the report should say ACCEPTED if not pending .

Finance information  link to IHB Contract

The header information will be stored in Reference field . This is the Payment reference text ( CHAR35 ) 

Finance information link to Payment information: 

From the header invoice you can find the subsidiary invoice in the  BKTXT . This field is stored in the BSEG table.  

• Finance:
  • PAYR: Contains payment medium file numbers and payment document references for tracking payment batches ( Invoice documents BELNR)
  • REGUT: Stores detailed invoice information selected during payment run processing.  ( Payment Run LAUFI  )

Primary Linking Fields from PAYR and REGUT  are   : LAUFI Payment Run , LAUFD Payment Run , BUKR Company & LIFNR Vendor Number

• BCM: 
  • BNK_BATCH_HEADER: Batches created from collector processing  
  • BNK_BATCH_ITEM  Individual payment items within batches that include the payment status ( STATUS ) 

 Primary Linking Field is  batch_id  

Payment Run ID (LAUFI): Links F110 payment runs to  BCM thru BNK_BATCH_HEADER  , with BCM-eligible runs starting with ":"  

 Finance information link to Reconciliation: 

 From the invoice ( BESEG , BKPF ,ACDOCA ) &  Reconciliation (  FEBEP, FEBKO ) it will  use the company code ( BUKRS , accounting document number ( BELNR )  , Fiscal Year GJAHR and line item number ( BUZEI) 

It should be available ALV features to add / remove fields , sort , sum/semisum, sort, filter,  …

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. 

Run the Fiori application

Selection Screen should be displayed

Execute the Report layout 

Report information is shown