cancel
Showing results for 
Search instead for 
Did you mean: 

Need Report

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (4)

Answers (4)

0 Kudos

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

former_member209761
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi,

Try to extract data from table KONP

Kapil

Former Member
0 Kudos

Hello Sir,

Thanks for your Reply.

For KONP I required Condition Record No.

Where Can i find the Condition Record No.... for the document ?

Former Member
0 Kudos

HI,

Go to SE16N give the table name VBRK get the data KNUMV,pass this KNUMV data into KONV table KNUMV field and execute,then you will get the condition record KNUMH pass this KNUMH into KONP table KNUMH field then you will get condition data.

Thanks

Vinayak.

jignesh_mehta3
Active Contributor
0 Kudos

To put it simply:

Document Condition can be found in VBRK - KNUMV (Doc. condition).

Pass this KNUMV value in KONV & you will see all the Conditions & Its value.

Hope this helps,

THanks,

Jignesh Mehta

Former Member
0 Kudos

Hello Experts.

I don't have access for "VBRK".

You are not authorized to display this table

Please help some other method.

former_member209761
Active Contributor
0 Kudos

Dear Vinubuzz,

If you have to get the values of condition type from billing , you will have to get access for SE11 or SE16N.

Contact your basis team for the same.

Else try using Query (sqvi) as mentioned.

Thanks & Regards,

Hegal K Charles

Edited by: Hegal . K . Charles on Jul 28, 2011 12:57 PM

Former Member
0 Kudos

Hello sir,

I Don't have acess for SE16N & SE11.

I have acess in se16

former_member209761
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hello Experts !

I have acees for se 16. but i don' have acess for table "VBRK ".

gomatheeswaran_palaniappa
Active Contributor
0 Kudos

Hi Vinu,

Try using SQVI and link the tables as per expert's advice before. I hope in SQVI, system might not check your access.

Regards,

P Gomatheeswaran

Former Member
0 Kudos

Hello all,

I don't Have acess for "SQVI "

Former Member
0 Kudos

hI

The last option is

Goto Your BASIS guys and explain all your authorisation problems.

regards