database table for RV13A-DATBI

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi Macy,

Try A019.

Regards

Gareth

[Former Member]

Try the table <b>T685</b> the field <b>DATVO</b> 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.

[Former Member]

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,

RS

[Former Member]

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....

[Former Member]

Hi,

Where do you see this field on <b>VA43</b>. 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,

RS

[Former Member]

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?

[Former Member]

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

[Former Member]

I found that Table KONH is used.

Thanks