Find a delivery number in SAP CRM

[manikandan_rajasekaran2]

Hi Experts,

We are developing a report based on CRM Orders to ECC FI documents. We have CRM Return order, Delivery, Delivery ASN, Material Document, Accounting Document and other corresponding fields etc.

The flow goes like BKPF->BSEG->MSEG->MKPF->LIPS->LIKP

With the help of Delivery number, we can determine the CRM Return order number.

The problem we have here is, some of the RO's delivery were archived (due to business setup) and due to that the other corresponding selection data are failed and missed to complete the output.

I.e. the deliveries are archived in LIKP and LIPS tables which leads to failed in determining the CRM Return order.

The deliveries are exists in Material document table (MSEG) but failed to get the corresponding Return order due to the relevant delivery data archived in LIKP/LIPS.

I want your help, is there anyway to determine the delivery number in CRM or in ECC?

We can abe to see the delivery number in CRMD_ORDER->document flow and would like to know where these get stored (though when I click, it says document cannot be displayed as it has been archived) .

Thanks.

[FredericGirod]

When you archiv a document you could populate table (info structure) check trans SARI SARJ