How to check the records posted in LBWQ

[Loed]

Hi guys,

Just wanted to ask if there is a way for me check the transactions posted in LBWQ?

I need to know the transactions posted in LBWQ last October 8 because I need to delete them so our DELTA extraction will resume. There was an upgrade last October 8 in ECC side but BW team was not informed so DELTA QUEUE still has data during the upgrade. Then error below appeared when extracting data after the upgrade.'

"MESSAGE_TYPE_X"

"SAPLMCEX" bzw. LMCEXU03

"MCEX_UPDATE_02"

I saw this note to solve the error encountered when running the V3 job.

https://launchpad.support.sap.com/#/notes/2387875

The solution I wanted to implement is the FULL load extraction in RED BOX so I wanted to know the list of transactions in LBWQ for October 8.

Any idea how to do this?

Thank you.

Loed

[bhavinvyas]

Hi Loed,

let's try if this works,

Take no. of records in the outbound queue entries for 02 application of 8th Oct. from TRFCQOUT table.

Additionally,filter entries in CDHDR table for 8th OBJECTCLAS=EINKBELEG. We will get order details from here and compare record count from both the tables.

Thanks,

Bhavin

[Loed]

Hi Bhavin,

I filtered QRFCDATUM = October 8 and QRFCFNAM = MCEX_UPDATE_02_QRFC in table TRFCQOUT. I got 226 entries.

While for table CDHDR with filter for OBJECTCLAS = EINKBELEG and UDATE = October 8, I got 190 entries.

What does it mean?

Thanks.

Loed

[bhavinvyas]

I mean we can get the list of orders from CDHDR for repair full. Additionally we can check EKKO and EKPO and get the order details based on changed on and created on on 08th. Once we have that combined list of order, we can do repair full.

Check if any of this orders are there in infocube, if yes we can selectively delete and then perfrom repair full.

Thanks,

Bhavin

[Loed]

Hi Bhavin,

My I know what is the purpose of EINKBELEG in OBJECTCLAS of CDHDR? Is it the value for 2lis_02? So we have other values ofr let's say 2lis_03, 2lis_13, etc?

Thanks.

Loed

[bhavinvyas]

Yes object class EINKBELEG is related to po documents.