List of delvieries created for the past three years

[Former Member]

Hi

I am BI consultant and i need to extract all delvieries created for the past three years into BI.

SAP Delviered Extractor doesnt provide the date field in the selection parameter for us to extract the records.

My Business has given the number ranges and when i check for the no of documents its 100 million records.of course they gave the entire number rangess used in the system.I.e i am getting all the deliveries in the system.i dont want all the deliveries .All i need is only deliveries for the past three years.

Regards

Vijay Thammineni

[Former Member · Accepted solution]

Hi,

Try t-codes --- VL06 , VL06F for getting the data...

Also, you can get the list via SE16 - LIKP table with your selection parameters...

Hrishi

[Former Member]

Hi there,

Use table SE16 LIKP-ERDAT. Give the upper & lower limits. Upper limit being current date & lower date being 3 yrs before current date.

You can also further filter using the sales org LIKP-VKORG, delivery type LIKP-LFART etc.

Regards,

Sivanand

[former_member217082]

Hi vijayabhaskar

Check the following t.codes

VL06 , VL06F , VL06N

Regards

Srinath

[Lakshmipathi]

Dear Vijay

Try with VL06 / MB51

thanks

G. Lakshmipathi