topic Re: Search for returned materials in Application Development and Automation Discussions

Search for returned materials

Former Member — Tue, 17 Jul 2007 10:38:17 GMT

Hi. I have such problem.

In first step I want to give some period of time in which some product were ordered. Then I’d like to find out which of them were moved to warehouse 5 (for example in some other period of time) . Could You tell me which tables I can use? In company there are warehouses signed 1, 2 and 5. 5 keeps damaged and returned things.

I know that info about ordered materials are in EKPO. There’s an EBELN number. Maybe I can use that field EKPO-EBELN to search for returned materials. But I don’t know which table to use. I’d be greatful for suggestions. Greetings. P.

Re: Search for returned materials

Former Member — Tue, 17 Jul 2007 12:06:22 GMT

check the following tables

EKPO,EKKO gives the Ordered Materials

MSEG and MKPF gives the received Materials into Stock

LTAP,LTAK - Warehouse materials (moved with transfer order)

<b>Reward points for useful Answers</b>

Regards

Anji

Re: Search for returned materials

Former Member — Tue, 17 Jul 2007 13:02:26 GMT

Hi,

EKKO Purchase document

EKPO Purchase document (item level)

EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item

EKET Delivery schedule

VETVG Delivery Due Index for Stock Transfer

EKES Order Acceptance/Fulfillment Confirmations

EKKN Account assignment in purchasing

EKAN Vendor address purchasing

EKPA Partner functions

EIPO Item export / import data

EINA Purchase info record (main data)

EINE Purchase info record (organisational data)

EORD Source list

EBAN Purchase requisition

EBKN Purchase Requisition Account Assignment

Pls reward points.

Regards,

Ameet