Community
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

REPORT

Go to solution
Former Member

‎2007 Apr 10 11:38 AM

0 Likes
370

hello all,

can someone tell me in which table i can get the following fields that are to be used in a REPORT.

Input: Purchase Order / Work Order Number

Output: Status of PO

Item number

Status of Work Order

WBS Element / Cost Center

Work Order / PO Created by (user id)

User e-mail ID

thanks in advance,

seenu

Message was edited by:

Seenu SAP

1 ACCEPTED SOLUTION
Read only

Go to solution
former_member404244
Active Contributor

‎2007 Apr 10 11:43 AM

0 Likes
342

Hi,

chek the tables--EKKO,EKPO,EKBE...,ADRC, ADR6

Regards,

Nagaraj

2 REPLIES 2
Read only

Go to solution
former_member404244
Active Contributor

‎2007 Apr 10 11:43 AM

0 Likes
343

Hi,

chek the tables--EKKO,EKPO,EKBE...,ADRC, ADR6

Regards,

Nagaraj

Read only

Go to solution
Former Member

‎2007 Apr 10 11:44 AM

0 Likes
342

Hi,

PO number(EBELN) , Item Number (POSNR)and created by(ERNAM) in EKKO/ EKPO tables

Cost center (KOSTL) and Work Order (AUFNR) and WBS element (PS_PSP_PNR) etc in EKKN table

Work order status in in TJ02/Tj02T Table

User email Id will be in ADR6 table , but we have to get the ADDRESSNUMBER field and to pass .

reward points if useful

regards,

ANJI