on 07-27-2011 8:02 PM
Hello All,
Good Day.
Past 1 Year i am trying to Extract Item Level Condition Percentage for ZM30 & ZM31.
But I am not able to Extract.
Experts Please help how to extract the Zm30 & ZM31 Percentage.
Se16 or SA38 OR ?
In SA38 "ZPRICECOND" i get the value of ZM30 Price. but i need Percentage of ZM30.
Hai Vinu,
If you want he condition record values respective to the dates.
Create a Pricing report in SPRO
and create a new report for the condition type and input the key combination and decide which one has to come in header and item and now
T CODE: V/ld you can get all the condition record Value or percentages maintained.
Regards,
Mani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Vinubuzz,
You can either create a query using tables VBRK - KONV
In the VBRK , you can make the DATE as selection ( and input the date range at the query execution phase)
Map VBRK-KNUMV with KONV-KNUMV and filter with KSCHL=ZM30, ZM31
Alternatively , if this is a one time activity, you can get the detail table wise
use se11 / se16n
Input VBRK and give the selection date FKDAT
Remove the maximum no of hits.
You will get a list , extract the same to an excel sheet and copy the value in KNUMV.
Input this KNUMV in konv with kschl=zm30 and zm31.
This will give you the list of KONV.
KBETR / 10 will give the percentage of ZM30 and ZM31.
Please check and revert back.
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.
IF YOU DONT HAVE THE CONDITION RECORD NUMBER ENTER THE CONDITION TYPE FIELD SELECT CONDTION TYPE FIELD "KSCHL" AND ENTER YOUR CONDITION TYPE AND GO FOR GENERATE YOU WILL GET CONDITION RECORD NUMBER.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try to extract data from table KONP
Kapil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Vinubizz,
Then please use se16 and do as follows.
Input VBRK and give the selection date in FKDAT
Remove the maximum no of hits.
Execute.
You will get a list , extract the same to an excel sheet and copy the value in KNUMV.
Input this KNUMV in konv with kschl=zm30 and zm31.
Execute
This will give you the list of KONV.
KBETR / 10 will give the percentage of ZM30 and ZM31.
Please check and revert back.
Thanks & Regards,
Hegal K Charles
User | Count |
---|---|
85 | |
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.