Tag Archives: tables

PM Linear Data – ECC Table + Links to Order and Functional Location

If you need to locate the table that contains the Lienar data for a Preventive Order => EAML_D_LFE_DATA-START_POINT and EAML_D_LFE_DATA-END_POINT

This info is extracted to BW via an exctractor 0PM_OM_OPA_1_EAML

 

You find the “linear data” record in the table EAML_D_LFE_DAT for a Functional Location by setting OBART=’IF’ and TABKEY = functional location (TPLNR)

You find the “linear data” record in the table EAML_D_LFE_DAT for a Maintenance Order by setting OBART=’OR’ and TABKEY = AUFNR

SAP PM Table Relations

PMTables
SAP PM Table relationships map in PDF format.
Produced by Camilo Veloso (camiloveloso@hotmail.com).

Download – [SAP-PM Tables.pdf] – 117.0 kB – 1,894   downloads

Erratas:

1) The link between AFVC/AFVV and AFPO/AFKO
See in the attachment and also following post http://scn.sap.com/thread/1435014

SAP_PM_Tables_Errata1

2) Add a link between MPOS and CRHD (main work centre of a Maintenance Item).
MPOS-GEWRK = CRHD-OBJID and CRHD-OBJTY = ‘A’

Get size of database table via ABAP

Check program Check program RSTABLESIZE
or following code.

Update for BW74: FM ‘EM_GET_NUMBER_OF_ENTRIES’ import parameter has changed. see new code below.

Code up to BW 73

REPORT ZTEST_ILESH.

TABLES : DD02L.

SELECT-OPTIONS : S_TABLES FOR DD02L-TABNAME.

DATA : GT_TABROWS LIKE STANDARD TABLE OF DDCDIM,
       WA_TABROWS LIKE DDCDIM.

SELECT TABNAME
  FROM DD02L
  INTO CORRESPONDING FIELDS OF TABLE GT_TABROWS
  WHERE TABNAME IN S_TABLES.

CALL FUNCTION 'EM_GET_NUMBER_OF_ENTRIES'
  TABLES
    IT_TABLES = GT_TABROWS.

LOOP AT GT_TABROWS INTO WA_TABROWS.
  WRITE : / WA_TABROWS-TABNAME , WA_TABROWS-TABROWS.
ENDLOOP.

Code from BW74

Download – PROG_ZBC_CHECK_SYSTEM_TABLES_74.slnk] – 1.3 kB – 273   downloads

REPORT  ZBC_CHECK_SYSTEM_TABLES.

TABLES : DD02L.

SELECT-OPTIONS : S_TABLES FOR DD02L-TABNAME.

DATA : GT_TABROWS LIKE STANDARD TABLE OF DDCDIM,
       WA_TABROWS LIKE DDCDIM.

SELECT TABNAME
  FROM DD02L
  INTO CORRESPONDING FIELDS OF TABLE GT_TABROWS
  WHERE TABNAME IN S_TABLES.

CALL FUNCTION 'EM_GET_NUMBER_OF_ENTRIES'
  TABLES
    IT_TABLES = GT_TABROWS.

LOOP AT GT_TABROWS INTO WA_TABROWS.
  WRITE : / WA_TABROWS-TABNAME , WA_TABROWS-TABROWS.
ENDLOOP.