topic Validity dates in TCode ME11 in Application Development and Automation Discussions

Validity dates in TCode ME11

Former Member — Wed, 10 May 2006 23:05:45 GMT

Hi all,

I did a BDC for ME11 Info records transaction. In the "Conditions" tab, i entered validity dates for each record. The validity end date shows up in EINE table. I guess both the start and end dates are stored in table A017 in fields DATAB and DATBI. When I check the table contents, there are no records in it. I guess it is a pool table. Is there any other table where the condition records are stored and how do we read them?

Thanks in advance.

Re: Validity dates in TCode ME11

Former Member — Thu, 11 May 2006 06:48:44 GMT

Hi,

THis is the logic inside the transaction which decides which conditon table to be used.

IF I_KOMG-MATNR NE SPACE OR IA_FLAG NE SPACE.

IF I_KOMG-EKORG NE SPACE.

IF I_KOMG-WERKS NE SPACE.

*- Key: Lifnr, Matnr, Ekorg, Werk, Esokz

IF I_VARIANTEN IS INITIAL.

E_KOTABNR = '017'.

IF I_KOMG-BSTME NE SPACE. E_KOTABNR = '067'.

ENDIF.

ELSE.

E_KOTABNR = '160'.

ENDIF.

ELSE.

*- Key: Lifnr, Matnr, Ekorg, Esokz

IF I_VARIANTEN IS INITIAL.

E_KOTABNR = '018'.

IF I_KOMG-BSTME NE SPACE. "Kondition pro Bestellmengeneinheit

E_KOTABNR = '066'.

ENDIF.

ELSE.

E_KOTABNR = '161'.

ENDIF.

ELSE.

*- ohne Ekorg läuft nichts

EXIT.

*- Key: Lifnr, Matnr

E_KOTABNR = '001'.

ENDIF.

ELSE.

IF I_KOMG-EKORG NE SPACE.

IF I_KOMG-WERKS NE SPACE.

*- Key: Lifnr, Matkl, Infnr, Ekorg, Werk, Esokz

E_KOTABNR = '025'.

ELSE.

*- Key: Lifnr, Matkl, Infnr, Ekorg, Esokz

E_KOTABNR = '028'.

ENDIF.

ELSE.

*- ohne Ekorg läuft nichts

EXIT.

*- Key: Lifnr, Matkl

E_KOTABNR = '015'.

ENDIF.

*----

The value of E_KOTABNR is concatenetaed with A to get the condition table name like A wit 015 to get A015.

You can decide to query the table by fallowing the same logic as above.

Re: Validity dates in TCode ME11

Former Member — Thu, 11 May 2006 07:09:52 GMT

GOOD

YES A017 IS A POOLED TABLE,AND DATAB AND DATBI BELONGS TO VALID TO AND VALID ON FIELDS.THESE TWO FIELDS CAN CONTAIN DATA,I HOPE THERE MUST BE SOME MISTAKE IN YOUR QUERY OR THERE MUST BE SOME MISTAKE WITH YOUR RECORDING PROCESS.

CHECK BOTH OF THINGS AND TRY AGAIN.

THANKS

MRUTYUN