cancel
Showing results for 
Search instead for 
Did you mean: 

Report-Total Discount of total product for perticular time

Former Member
0 Kudos

Hi Experts.,

my client gave a requirement ,he wants a report on Total Discount of total product sold by giving item and material group. The report is unavailable in Stanadard hence have to develop.

i need some help in creating this Report,

With the development of this screen, user can view Total Discount given on total product sold.

The report should display the Item, Material group and Date

Selection fields

1-Material - FACOM-MATNR

2- material group VBRP-MATKL

3- Item- VBRP-POSNR

4-document date-- From VBRK-FKDAT , To FACOM-FKDAT_BIS

Discount from total sales will be taken from total bill amount for the perticular period

The question is which field and table i will fetch for TOTAL DISCOUNT ,from the total sales for perticular period.

please suggest me ASAP

i am waiting for the response

Thanks,

Accepted Solutions (1)

Accepted Solutions (1)

former_member209761
Active Contributor
0 Kudos

Dear Devbubble,

Assuming the discount amout is based on a condition type (which you see in the billing document)

following is the logic for developing your report.

Selection : VBRP-MATNR

OR

VBRP-MATKL

Output logic

Select VBRP-VBELN and Put in VBRK-VBELN and fetch VBRK-KNUMV

Put VBRK-KNUMV in KONV-KNUMV with KSCHL=your discount condition type.

KONV-KBETR will give the DISCOUNT VALUE

This will be the output of your report.

With the help of ABAPer you can set the SUMMATION option in the report.

Thanks & Regards,

Hegal K Charles

Former Member
0 Kudos

thanks Charles

as i told earlier i have to create total discount from total sales done (ex-for a month)

for that i need to develop it wid the help of abaper.

so v/la/ v/ld is not going to give me the results.

can you please elaborate from whr i will fetch total discount from total sales for particular month..

need to make an fs..

thanks again Charles

eduardo_hinojosa
Active Contributor
0 Kudos

Hi

V/LD gives you a report about the values of conditions that you mantain usually with tcodes VK11/12.

Hegal is right. In database this data is stored as he tells you. In VBAK you have a field, KNUMV. After in table KONV, for field KNUMV you have all data related with conditions. Check it with tcodes SE16/SE16N.

If the requirement is permanent for a long time, you can think in do with a SIS (sales information system), populating this values in a KZWI+ filed (see SAP Note 1022966 - FAQ for the 'Subto' column (KZWIW) in the pricing procedure for further information).

Other possibility is enhance tcode VA05 with new fields (see SAP Note 350068 - Additionl fields in VA05:Customer material number as example). Here you also need an ABAPer, and be careful with performance.

Of course, you could think in COPA and/or BI, but it would be so expensive.

If it's the usual ad-hoc requirement by sales dept. I think that the better option perhaps is an ABAP report.

I hope this helps you

Regards

Eduardo

former_member209761
Active Contributor
0 Kudos

Dear Devbubble,

As explained,

Selection : VBRP-MATNR (take se11 of VBRP and input any material code)

OR

VBRP-MATKL (take se11 of VBRP and input any material group)

Output logic

Select VBRP-VBELN (You will get a list of billing documents with the material/material group) and Put those billing documents in VBRK-VBELN {YOU CAN GIVE THE DATE RANGE IN VBRK-FKDAT} and fetch VBRK-KNUMV (Number of the document condition)

Put VBRK-KNUMV 9Number of the document condition) in KONV-KNUMV with KSCHL=your discount condition type (Eg: ZDIS).

the value in KONV-KBETR will give the DISCOUNT VALUE

This will be the output of your report.

With the help of ABAPer you can set the SUMMATION option in the report {select KONV-KBETR in the table and SHIFT+F8}.

Just try in the above logic yourself to get a better understanding.

This is the FS for your requirement.

Thanks & Regards,

Hegal K Charles

Edited by: Hegal . K . Charles on Jul 6, 2011 2:27 PM

Former Member
0 Kudos

Hi Eduardo

Thanks for reply,

can u please tell me Other possibility enhance tcode VA05 with new fields.

what fields i can enhance. and how the system will calculate the discount? from total sales.( considering all discount as same )

please send the procedure if u have

thanks

-jay

eduardo_hinojosa
Active Contributor
0 Kudos

Hi

I suggest to do with an ABAPer. It's been a long time since the last time that I did it. This is an idea, thinking in performance.

1. Add a zz-field (ZZDICOUNT for instance) in table VBAP with an append. See Note 155012 - Further subtotal fields in pricing to do it if you don't want to use a field between KZWI1-6. Use the field ZZWI7 for instance.

2. According to note 350068, do the steps that it suggests using field ZZWI7 instead KDMAT, ie, in step 4 you must do in include V05TZZMO. I think that perhaps you would add KNUMV (as ZZKNUMV) to orders before modification (be careful with performance)



***INCLUDE V05TZZMO .
* This form is called in the include LV05TFMO.
FORM MOVE_USERFIELDS USING ZP.
  CASE ZP.
    WHEN 'VBAK'.
*     header
*     MOVE LVBAK-XXXXX TO LVBMTV-ZZXXXXX.
      MOVE lvbak-knumv TO lvbmtv-zzknumv.
    WHEN 'VBAP'.
*     item
     MOVE LVBAP-ZZWI7 TO LVBMTV-ZZWI7.
*    for older documents (check it with your ABAPer, don't copy it and run in production without checking)
     IF lvbap-zzwi7 IS INITIAL.         "see if it's possible to check by date too
        SELECT SINGLE kbetr INTO zzwi7 FROM konv
           WHERE knumv = lvbmtv-zzkumv            "check that it's populated
           AND     kposn  = lvbmtv-posnr
           AND      ...........          "decide the type of select (GROUP BY, 
                                           "INTO TABLE, ie: with an internal table
     ENDIF.
     
    WHEN 'VBEP'.
*     schedule line
*     MOVE LVBEP-XXXXX TO LVBMTV-ZZXXXXX.


  ENDCASE.

ENDFORM.

Remember that you must register the object in SSCR.

3. Remember that it will work from this moment. Before this date with this coding doesn't work because the coding to catch data from KONV I'm not sure that it will work. So, perhaps the ABAP report will be the better solution.

Moreover, take your time, look for help from an ABAPer if you don't know enough ABAP and of coure, check it and check it newly.

I hope this helps you

Regards

Eduardo

Edited by: E_Hinojosa on Jul 6, 2011 1:36 PM

Answers (3)

Answers (3)

Former Member
0 Kudos

still unsolved

Former Member
0 Kudos

1- created the condition table in v/03

2)- while doing v/la and giving required fields.

it ask condition record to maintain.. after maintaining condition record. i am just getting the value of condition record...in v/la

how will i find the total discount..from the total sales made by the company....

please guide me ASAP

Thanks

Jay

prasanna_kumar4
Active Contributor
0 Kudos

Hi,

Go to T-Code V/LD and Select relevant the Pricing report and execute .

Regards,

Prasanna

Former Member
0 Kudos

i have gone to V/LD.

i am not getting the total discount..for a particular period for last month..

am just getting the condition record amount which i maintained .

please tell me asap...

prasanna_kumar4
Active Contributor
0 Kudos

Hi,

As per my knowledge through V/LD you will get the all the condition records which you maintained in the condition record

if you want to know total discount for sold material or whatever it may be you better to develop one report with the help of ABAP

if i wrong please correct me

Regards,

Prasanna

Former Member
0 Kudos

Dear Prasanna

the result of V/LA V/LB and V/LD shows only condition records which we have already maintained...

its only for condition records ...

not for creating pricing report and execute pricing report ..

for creating reports like this needs abapers help.

anyways thanks for your response

Former Member
0 Kudos

Hi,

Try to Create report with V/LA , V/LB , V/LC And execute by V/LD

Or extract data from table VBRK and VBRP

kapil

Former Member
0 Kudos

hi kapil

Thanks for your reply,i tried the way you told me...

while creating pricing report,

i gave-name of the list/title then

-selected -Material

-gave key combination -445 material

-continue to list structure ,i gave material and condition type in header and validity period is already in item level display mode.

then gave a tick in display validity period.

While saving it ERROR is Poping up.

Invalid call sequence for interfaces when recording changes-- Message no. TK425

i have never created report with V/LA , V/LB , V/LC

so please guide me ..if i am wrong.

thanks , waiting for your reply

-jay

prasanna_kumar4
Active Contributor
0 Kudos

Hi,

Try to do configuration like following steps

1. Create a condition table based on your requirement like as you mentioned Material , material group , Item and please check whether it is there in Standard SAP or Not if it is not there try to create a condition table

2. Go to T-Code V/LA and do the proper configuration in that we have to select under the "Field selection " based on your requirement

3. After selecting the Click on" AND" button , we will get another screen , in that you have to select your condition table and maintained proper settings

4. Go to T-Code V/LD , select the relevant pricing report and click on Execute and type the data then you will get the report what your clients wants

I think it will help to you

please try to check if i am wrong please correct me

Regards,

Prasanna

Former Member
0 Kudos

thanks prasanna,

it was helpful

prasanna_kumar4
Active Contributor
0 Kudos

Hi

Please close the Thread

Regards,

Prasanna

PhaniKalvagunta
Contributor
0 Kudos

Have you checked the pricing report in V/LD

Phani Prasad