Skip to Content
0
Jun 03, 2020 at 10:17 AM

External Bank Reconciliation Joins with Payment windows in SAP B1

756 Views Last edit Jun 03, 2020 at 08:07 PM 4 rev

Hello World!!

I have a client requirement of creating a report in SAP B1 9.3 for HANA in which customer wants to see the Incoming/Outgoing payment document number and linked 'End Date' of External Bank Reconciliation window.

Can anybody please explain how can we create joins between External Recon and Incoming/Outgoing Payment window for this particular report? The data for External Bank Reconciliation window is stored in the table OBNK.


I tried using data from following tables (Not sure whether its correct) -

SELECT * FROM ITR1

SELECT * FROM BNK2

SELECT * FROM OMTH;

SELECT * FROM OBNK;

SELECT * FROM ITR1

SELECT * FROM OITR WHERE ReconType=24 ORDER BY ReconDate

Any suggestion will be very helpful.