Validity dates in TCode ME11

[Former Member]

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.

[Former Member]

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.

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.

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.

[Former Member]

HI

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