topic Re: REPORT in Application Development and Automation Discussions

REPORT

Former Member — Tue, 10 Apr 2007 10:38:42 GMT

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

former_member404244 — Tue, 10 Apr 2007 10:43:22 GMT

Hi,

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

Regards,

Nagaraj

Former Member — Tue, 10 Apr 2007 10:44:01 GMT

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