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.