Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results forĀ 
Search instead forĀ 
Did you mean:Ā 
Read only

Search for returned materials

Former Member
0 Likes
463

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
441

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

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.

2 REPLIES 2
Read only

Former Member
0 Likes
441

Hi

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

Read only

Former Member
0 Likes
442

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