cancel
Showing results for 
Search instead for 
Did you mean: 

FMS Query

former_member275826
Participant
0 Kudos

Dear all,

I have created foll query:

SELECT T0.CARDNAME [CUSTOMER NAME],T0.DOCNUM [INVOICE NO],T0.DOCDATE [INVOICE DATE],

T0.DOCTOTAL [INVOICE AMT],T6.DocDate  [INCOMING PAYMENT DATE],

T4.DEPOSDATE [DEPOSIT DATE],

DATEDIFF(DD,T0.DOCDATE,T6.DOCDATE) [REALIZATION DAYS TO WITHOUT PDC],

DATEDIFF(DD,T6.DOCDATE,T4.DEPOSDATE) [REALIZATION DAYS TO WITH PDC],

DATEDIFF(DD,T0.DOCDATE,T4.DEPOSDATE) [TURNAROUND DAYS]

FROM OINV T0

LEFT JOIN RCT2 T5 ON T0.DocEntry = T5.DocEntry

LEFT JOIN ORCT T6 ON T6.DocEntry=T5.DocNum

left JOIN RCT1 T2 ON T2.DOCNUM=T6.DOCNUM

left JOIN OCHH T3 ON T3.Checknum=T2.checknum AND T3.CARDCODE=T0.CARDCODE left JOIN ODPS T4 ON T3.DpstAbs=T4.DeposId

WHERE T0.CARDCODE =[%1] and T0.DOCDATE between  [%2] and [%3]

At Parameter screen it will show Cardcode ,From Date and to Date.

When we click on CFL of Cardcode it just showing me cardcode & count. but can we show corresponding Cardname of cardcode.

So user can search Cardname wise.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Pravin......

Its not possible to show both at a time in Query Generator.

You may either run the CFL by Code or Name.

But it is possible in Crystal Report when you run it through SAP....

Regards,

Rahul

former_member275826
Participant
0 Kudos

Thanx Rahul for ur reply.

You told that:

But it is possible in Crystal Report when you run it through SAP....

How to use crystal report in sap query generator?

Answers (1)

Answers (1)

former_member204969
Active Contributor
0 Kudos

You can use

WHERE T0.CARDNAME =[%1]

intead of

WHERE T0.CARDCODE =[%1]

former_member275826
Participant
0 Kudos

Thanx István Korös for ur reply,

My concern is i howto show both Cardname & cardcod in query generator CFL.

Is it possible?

former_member204969
Active Contributor
0 Kudos

There is a half-solution:

WHERE (T0.CARDCODE =[%1] or T0.CARDNAME =[%0])

        and T0.DOCDATE between  [%2] and [%3]

(The list of existing values windows can show only one system field.)