topic Re: database table for RV13A-DATBI in Application Development and Automation Discussions

database table for RV13A-DATBI

Former Member — Wed, 21 Mar 2007 02:30:34 GMT

Hi all,

I need to get the valid end date for a condition item inside a contract (VA43).

But I can only found a structure RV13A-DATBI, how to find the exact table holding it ? (I've looked into the where-used list for DATBI, but seems have no idea)

Thanks.

Re: database table for RV13A-DATBI

Former Member — Wed, 21 Mar 2007 03:07:59 GMT

When in doubt, you can try using ST05 to enable your trace before you retrieve/update data, then disable, and analyze the SQL trace.

Not sure which valid end date you mean, but if it is at the header level check sales doc. header table (VBAK). Sales document pricing conditions are in table KONV. You can use the value of the document condition KNUMV from the sales order header table VBAK as the key to search KONV.

Hope the info is of help.

Re: database table for RV13A-DATBI

Former Member — Wed, 21 Mar 2007 03:13:08 GMT

Hi Macy,

Try A019.

Regards

Gareth

Re: database table for RV13A-DATBI

Former Member — Wed, 21 Mar 2007 03:18:12 GMT

Try the table T685 the field DATVO gives the following information:

Valid till 31.12.9999

Valid till Today's date

Valid till End of the current month

Valid till End of the current year

Valid till No proposal

Valid till According to calendar

Naveen.

Re: database table for RV13A-DATBI

Former Member — Wed, 21 Mar 2007 03:32:35 GMT

Hi,

You can find condition records from the table KONV.

For that first get the data from table VBAK with VBELN = contract number. The VBAK-KNUMV field is the condition record number.

Take this condition record number and look at table KONV with KNUMV = condition record number ( VBAK-KNUMV).

So, if you write the code it will look like this.

*----------------------------------------------------------------------*
PARAMETERS: p_vbeln LIKE vbak-vbeln.   "Contract number

DATA: l_knumv LIKE vbak-knumv.
DATA: lit_konv LIKE STANDARD TABLE OF konv WITH HEADER LINE.

*get condition record number
SELECT SINGLE
             knumv FROM vbak
                   INTO l_knumv
                   WHERE vbeln = p_vbeln.
IF sy-subrc = 0.
* get condition records
  SELECT
        * FROM konv
          INTO TABLE lit_konv
          WHERE knumv = l_knumv.
ENDIF.
*----------------------------------------------------------------------*

I hope this will solve your problem.

Let me know if you have any question.

Regards,

Re: database table for RV13A-DATBI

Former Member — Wed, 21 Mar 2007 03:53:55 GMT

Thanks all for your answers.

But the problem is not solved yet.

I am locating the valid end date of an contract item's condition...so it should be in item level....

Re: database table for RV13A-DATBI

Former Member — Wed, 21 Mar 2007 05:08:23 GMT

Hi,

Where do you see this field on VA43. I run the where-used list on the field RV13A-DATBI for screens and the list does not show transaction VA43. All the transactions are related to maintaining the condition ( master data ) and NONE of them are related to document condition records ( transaction data ).

Mention your issue clearly.

Regards,

Re: database table for RV13A-DATBI

Former Member — Wed, 21 Mar 2007 07:06:18 GMT

In VA43, when you select an item and click the button marked "Pricing agrt", it goes to the screen showing different condition rates for that item...

I now found that the DB table KONH contains the valid to date (DATBI) that I am looking for.

But the question is how do I know the condition record # for this contract item?

Re: database table for RV13A-DATBI

Former Member — Wed, 21 Mar 2007 07:13:01 GMT

DATBI is just for validate the Condition Record , so when u are trying to pick condition value at the same time u have to check validity of that record.

DATBI -Validity end date of the condition record

DATAB-Validity start date of the condition record

based on the system date u have to put a logic by using there 2 dates.

Regards

Prabhu

Re: database table for RV13A-DATBI

Former Member — Wed, 21 Mar 2007 09:17:34 GMT

I found that Table KONH is used.

Thanks