Accounts Payable Check Register

[Former Member]

Hello,

Does anyone have any advice they can share with regard to creating an InfoProvider that would contain check register information for Accounts Payable? I have looked through Business Content for Financials but have not been able to find anything even close to this type of design. Our Financial functional analysts cannot believe that a check register InfoProvider is not included as part of BC.

Thanks in advance,

Sonya

[Former Member]

As an accountant for 35 years, I could not believe that there is no check register in SAP.  The document journal report hardly suffices.  The company I am with now did create a query that is below.  See how this works for you.

SELECT T0.CreateDate AS 'Creation Date', T0.CheckNum AS 'Check No.', T0.VendorCode AS 'Vendor Code', T0.VendorName AS 'Vendor Name', T0.CheckSum AS 'Check Amount', T1.JrnlMemo AS 'Journal Remarks', T1.TransId AS 'Transaction Number', T0.Canceled AS 'Cancelled' FROM  [dbo].[OVPM] T1 INNER JOIN [dbo].[OCHO] T0 ON T1.DocEntry = T0.PmntNum INNER JOIN [dbo].[VPM1] T2 ON T2.DocNum = T1.DocNum WHERE T1.DocDate >= CONVERT(DATETIME, '[%0]', 112)  AND  T1.DocDate <= CONVERT(DATETIME, '[%1]', 112)

[Former Member]

Hi Sonya,

Go through this link.

http://help.sap.com/saphelp_nw04/helpdata/en/ee/cd143c5db89b00e10000000a114084/frameset.htm

u can expand infocube or characteristics and keyfigures.

Assign some points if it helps.

Regards,

Ravi