on 07-04-2011 7:46 AM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
still unsolved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Have you checked the pricing report in V/LD
Phani Prasad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.