Application Development 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: 

What are the field names for below mentioned

Former Member
0 Kudos

Hello Friends

What are the fields names for below tables

in EKKO

Purchase Document Date

Net Value of the purchase document.

In EKPO

Item Description

From which place We bought it. (It means in Sales Items there we can know from which plant we sold the goods, like in EKPO, there is any field like this)

Please let we are defining the report to find out the stock availability for perticular storage location using select Options plant, company code, material no.

How many tables involve her to build this report. and also field names, they come under which table.

Please send me this information ASAP. PLz Plz Plz..........

Regards

Praveen

2 REPLIES 2

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

You can check the fields of these tables via SE11

Purchase Document Date - EKKO-BEDAT

Item Description - EKPO-TXZ01

Net price per item - EKPO-NETPR.

Regards,

Rich Heilman

Former Member
0 Kudos

"from which place we bought it". This will be your vendor on EKKO-LIFNR. If it is a Stock Transport Order, then you have the sending plant and receiving plant. Look for fields WERKS on EKPO and RESWK on EKKO.

Srinivas