05-11-2006 12:05 AM
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.
05-11-2006 7:48 AM
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.
05-11-2006 8:09 AM
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