create Contract Reports from Quick Viewer(SQVI)

[Former Member]

Dear All,

there are Hundreds of Contracts, we handling and OTC cycle are fully Referenced.

And I want to make a report in Quick Viewer like this

Selection Screen- Enter Contract Number then Execute

It Shows All Line Items, Their quantities, Net Price and Net Value + All Ordered Quantities, value + All Del Qty, Value + All Invoiced Quantities, value + All reverse Qty, Value + Remaining Qty, value etc

Selection Screen

Contract number- 9999999999

Item	Description	Qty.	Net Price	Net value	Ordered Qty	Ord Value	Del Qty	Del Value	Invoiced Qty	Invoiced Value	Invoice Reverse Qty	Invoice Reversed Value	Final Qty	Final Value
0010	test	100	50	5000	70	3500	50	2500	40	2000	10	500	30	1500
0010	test	100	50	5000	70	3500	50	2500	40	2000	10	500	30	1500

Pl tell me that how can we achieve this by Quick viewer.

Thanks

Govind

[phanikumar_v3]

Have you tried with standard methods?? Hope SDV1/2/3 may satisfy your requirement partially.(Returned qty with value may be a issue here)

Go to Tcode SAP1>>SD>>Sales>>Contracts...

Hope it will helps you..

Phanikumar

[Lakshmipathi]

First you have to put some efforts to find out which are the tables the data you want are being stored.  Next in SQVI, instead of Table Join, try with Logical Data Base. 

G. Lakshmipathi

[Former Member]

Hi Govind,

SQVI will not fulfill your all requirements as report shared by you. Better you go with a custom report with the help of an ABAPer.

Please let me know if any clarification required.

Regards

Abhishek