This content has been marked as final. Show 3 replies
i'm trying to add a where clause into sap extraction but it is not working.
[AKTNR_TVK] as [AKTNR_TVK.Номер акции (YMMDD)],
[AUFNR_TVP] as [AUFNR_TVP.Ссылочный номер заказа],
[BISMT_TVP] as [BISMT_TVP.Номер материала внешнего магазина],
(... other fields)
SQL EXTRACTOR ZBI_NEW_ZTPRC_VP
TFRMETHOD T // tRFC transfer method
UPDMODE F // full extractor
//UPDMODE C // initial extraction, to be followed by delta extractions
//UPDMODE D // delta extraction
//INITRNR <NR> // Resend extraction
//IDOC <NR> // Resend single IDoc
AUFNR_TVP I EQ 098341769064
Please take into account additional comments:
1) I tried it with and without single quotes, any variants doesn't work either.
2) The field AUFNR_TVP in SAP extractor is marked for selection.
3) When I try to test extractor in SAP ERP using RSA3 and with applying filter by field AUFNR_TVP - it works.
4) The SAP extractor is based on view.
Please let me know if you have any solution regarding this problem.