cancel
Showing results for 
Search instead for 
Did you mean: 

SAP PM - Field Mapping with ref to name and table

Former Member
0 Kudos

Dear PM gurus,

I have a requirement to show the fields in SAP PM for BW.

Attached are the 3 images for which I need your help to show where these fields are located and in which tcode.

FieldTableTable/ Structure
STRNoDIAUFKStructure
equnrDIAUFKStructure
ABCKZVIAUFKSTTable
EBELNMEPO1211Structure

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Sir,

Pls help how can i get the table data linked from a WO for the fields (refer attachment)

peter_atkin
Active Contributor
0 Kudos

Have a look in view table VIAUFKS which has most of the order related data

EQKTX is in table EQKT

PLTXT is in table IFLOTX

EBELN is in table EKKO or EKPO

PeteA

Former Member
0 Kudos

Maria / Prashant / Rao,

Please help in which table can i find the below fields

1. STTXT             - System Status in WO

2. IKOSTENKGR - Actual costs in WO

3. PKOSTENKGR - Plan costs in WO

4. Notification long text (circled in red)

5. Entered By (identifies individual)

In IW33, go to Extras, Document for Order and then select Action Log.

Within the Action Log, we require the username of the person who created the document (earliest date)

Former Member
0 Kudos

Hi Mudassar

1. STTXT      

  • JEST - Pass Order Object Number.
  • TJ02T - for status text.

2. IKOSTENKGR

  • COEP & COBK table - Pass document numbers for confirmations ( AFRU) & Material movements ( MSEG)
  • PMCO table

3. PKOSTENKGR


Table PMCO


4. Notification long text (circled in red)


Hope this helps.


Regards,

Amol






Former Member
0 Kudos

How about

5. Entered By (identifies individual)

In IW33, go to Extras, Document for Order and then select Action Log.

Within the Action Log, we require the username of the person who created the document (earliest date)

Former Member
0 Kudos

Hi Muddasar,

For status changes ( created, released etc.) oriented action logs, JCDS table can be referred by passing order object number.

Regards,

Amol

jogeswararao_kavala
Active Contributor
0 Kudos

mudassar

  • For this specific query on Action log you need tables CDHDR and CDPOS . These are Change Documents Header and Change Documents Items tables.

         OR

  • You can use function module BUS_TABLE_CHANGEDOCUMENTS_READ
jogeswararao_kavala
Active Contributor
0 Kudos

mudassar,

  • First you need to understand the architecture of SAP. What the earlier posts told you are the answers, which will not be understood easily unless you know the concepts of fields, tables and structures.
  • In other-words it is a basic pre-requisite to ask queries like this and also essential for you to work on BW reports.
  • After you attain that knowledge, your query will become more meaningful like: "Which are the tables those host fields STRNO, EQUNR, ABCKZ, EBELN. "
  • Then replies like one from Prashant would attract the 'Correct answer' marking.
  • To add to Prashant's reply: EBELN comes from table EKKO.
  • These  F1 help pictures do not help.
prashant_pandey2
Employee
Employee
0 Kudos

Hello,

Question is not clear. But If I understand correctly, you are looking for tables where you can find these fields:

STRNO: Table IFLOS

EQUNR: Table EQUI

ABCKZ: Table ILOA

Let me know if you need further details.

Thanks,

Prashant

Former Member
0 Kudos

No Prashanth,

Im looking for these fields in the SAP Screen like below :

Ex :

I want to see the fields for the below Table relationships in SAP screen

STRNoDIAUFK
equnrDIAUFK
ABCKZVIAUFKST
MTerence
Active Contributor
0 Kudos

Hi Mudassar,

These are structure, data will not be stored in these places.

You need to check these fields in corresponding tables mentioned by prashanth.

Regards

Terence

Former Member
0 Kudos

Sir,

Please see the below images - I need to locate the fields which may be either from WO header or Iw38 or anything else which corresponds to the F1 data shown below

MTerence
Active Contributor
0 Kudos

Hi Mudassar,

Refer below doc, check whether you are able to find out the table by your own way

Regards

Terence