condition record number

[siddivineshjogu5]

Hi All,

I know the conditin type , application Sequential number of the condition, by this I went for finding out condition records in KONP table , here I could find out multiple condition records.

How could I get exact one required.

Regards,

vinesh

[sachin_bhonsle · Accepted solution]

Hi Vinesh,

If I get your question right; you want to find out condition record from access tables, right?

Suppose you want to find out condition record for customer 4999, material P-109 for condition type K005, for which the access table is A005.

Then first go to table A005 using SE16, put following values as input:

KAPPL>> V

KSCHL>> K005

VKORG>>

VTWEG>>

KUNNR>> 4999

MATNR>> P-109

on F8 you will get a value for A005-KNUMH,

KAPPL KSCHL VKORG VTWEG KUNNR MATNR DATBI DATAB KNUMH

V K005 1000 10 0000004999 P-109 25.07.2000 20.11.1996 0000007229

note this value and feed it as input for table KONP again in SE16. You will get the value of condition record as KBETR (condition rate)

KNUMH KAPPL KSCHL KNUMT STFKZ KSTBW KONWS KBETR

0000007229 V K005 A 0,00 68,00-

So if you have to find value of condition records you have to use the access table Axxx in conjunction with KONP, with KNUMH as the connecting field.

If you are still getting multiple records, then please attach a screenshot, may be I can help.

Sachin

Edited by: Sachin Bhonsle on Mar 9, 2009 11:29 PM

Edited by: Sachin Bhonsle on Mar 9, 2009 11:32 PM

[Former Member]

Hi Vinesh,

For example i want to extract condition data for an invoice,then go to table VBRK(in SE16N) and enter the Bill no (VBRK-VBELN) and get Doc Condn no(VBRK-KNUMV) and pass this no in KONV-KNUMV and now you will be getting the required.

Regards,

Rangavittal

[Former Member]

Hi,

try with CTL+F(find)d

regards,

sk

[Former Member]

Hi vinesh,

Goto SE16 enter Table Name KONP, enter.,

key in the data like Application and Condition type execute(F8)

you will find list of Condition records maintained for a perticular Condition Type.

Thanks,

Swamy H P

[former_member217082]

Hi Vinesh

Check in KONV , KOMP info structures . Your required data can be extracted

Regards

Srinath