Bank Statement 逻辑/流程/理解

流程/事务码： 

1. FF_5 Upload bank Statement/ APP: Manage incoming payment files

2. FEBAN reprocess bank statement /APP: Reprocess bank statement items

File Specifications: 选择要启用的bank statement format and File location

Algorithms: 重要 - 决定了自动上传过程是否auto clear open item.

FEBAN

Reprocess bank statement items

1. external transaction:PMNTICDTATXN link to posting rule ZE02(mapping 关系在OT83定义）

2. Postings

在define posting rules会定义具体的posting和clear的规则

常见的有：bank in /bank out/ bank charge/cashpool 等transaction。

3. Posting and clear rule example

以ZE04举例：

Posting area 1 过账： 在bank statement上传的过程中，基本不会出现问题。

40: Bank out    50： Main bank

Posting area 2过账：

50 bank out, this transaction remains open in the case that it cannot find the mapped transactions.

Manual Process: 选择对应的account type： customer/vendor/GL 输入客商号，找到open item

‘Two clearing account remain open after reprocessing' is the stanard system behavior. Assignment的逻辑：Short Key(FEBCL-KUKEY)+Memo Record No(FEBCL-ESNUM)

程序：RFEBKA00

程序：RFEBKA96,用于删除已经上传的银行对账单

底表： FEBCL - 可以看到SAP解析出来的用于match的数据

FEBEP:银行对账单item的数据

Reprocess bank statement 外币业务处理的逻辑：

1. AP entry transaction currency 为TWD, 本位币为SGD，for example:

Dr: Loan account 240000000 TWD

Cr:  Bank clearing account 240000000 TWD

2. Bank statement upload,实际汇款是通过SGD汇款

Dr: Bank clearing account 10512483 SGD

Cr: Main bank account      -10512483 SGD

3. Reprocess bank statement,实际在choose open item,会根据bank statement date的系统汇率换算，导致银行实际出钱和open item之间存在差异。

Bank statement No. 每一张银行对账单都有一个bank statement No.该字段由银行端提供。银行账号+statement来判断银行对账单是否重复，如果系统发现重复，则不会上传该份file

SAP Link： loading... | SAP Help Portal