Skip to Content
avatar image
Former Member

Need Report

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jul 28, 2011 at 01:58 AM

    Hi,

    Try to extract data from table KONP

    Kapil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 28, 2011 at 04:27 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 28, 2011 at 04:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 06, 2011 at 10:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded