Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Query Report for Account balance in Business partner Master Data

Hi Experts,

One of my client requirement is one query report for account balance of business partner master data . Where I need that query to design a crystal report.

I need your help for the below query , where I need some fields that is BP CODE , BP NAME, BP ADDRESS (block, city, country, mobile no, zip code , landline number) , SERIES POSTING DATE, ORIGIN , ORIGIN NO, DETAILS, DEBIT,CREDIT,CUMULATIVE BALANCE, FROM DATE AND TO DATE.

Actually I am unable to find the field names for ORIGIN, CUMULATIVE BALANCE, FROM DATE AND TO DATE.

Kindly help me for write the query for account balance.


SELECT T0.[CardName], T0.[CardType], T1.[Address], T1.[Street], T1.[CardCode], T1.[Block], T1.[ZipCode], T1.[City], T1.[County], T2.[RefDate], T3.[Debit], T3.[Credit], T3.[LineMemo] FROM OCRD T0  INNER JOIN CRD1 T1 ON T0.[CardCode] = T1.[CardCode], OJDT T2 INNER JOIN JDT1 T3 ON T2.[TransId] = T3.[TransId] WHERE T0.[CardCode] ='c20000'

Thanks and Regards,

Nagendra Prasad.

Former Member
Not what you were looking for? View more on this topic or Ask a question