Skip to Content
avatar image
Former Member

create Contract Reports from Quick Viewer(SQVI)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 23, 2015 at 12:30 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 23, 2015 at 01:11 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2015 at 05:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded