Skip to Content
author's profile photo Former Member
Former Member

condition type

Hi,

I need to create an ALV report.The spec is as follows.

A report is needed for CVS credits. They are requesting certain fields to be included in the report. The Customer Relations analyst is having to report on this manually with selection and deselection fields from VA05.

To make this report more globally usable, the column YYLP Unit price should be taken as the Gross Value (subtotal 1 KOMP-KZWI1) amount /quantity, and the net price (YYP1) to use the net price for item

(KOMP-NETPR). The partial quantity discount will need to be read as condition type YYP1 in the procedure, or alternatively, calculated based on total discount subtotal line 5 (KOMP-KZWI5), and expressed as a

percentage.

Recommend a custom ABAP report be developed here rather than BW, due to the logic and specific layout needed. Selection options for the report: Sales org (VBAK-VKORG), created on date (VBAK-ERDAT), distrib. channel (VBAK-VTWEG), sold-to customer (VBAK-KUNNR), sales doc type (VBAK-AUART). Output should be using ABAP List Viewer, to provide user with ability to sort and subtotal.

This is the sample output of how the report shud look like :

Item|Material | Desrcptn| Batch| <b>Confirmqty</b>| <b>PartialQty</b>| <b>Unit</b> <b>Price</b>|<b>NetPr</b>| <b>Rej.reson</b>

10 | 2105d3 | xyzz | 10 | 1 | -75% | 273.93 | 68.48 | no lot nr.

Can anyone plz help me on how to retrieve the fieldsConfirm qty,partial qty,unit price,netpr and rej reason??

Thanks in advance.

Regards

SWARNA

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 12, 2007 at 08:37 AM

    Hi!

    You might find the relevant data in the following tables:

    - VBEP - order scheduling. The open quantity has to computed like this: you have to sum the quantity from the given order item line , and you have to sum the corresponding delivery item line. The difference between them is what you need. Deliveries are stored in table LIKP, LIPS.

    - KONH, KONP - conditions-prices, KNUMH field is the key (from VBAK, VBAP)

    - VBAP-ABGRU - reason for rejection

    Regards

    Tamá

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.