[Edward T]

Hi,

SAP EAM (Enterprise Asset Management) is evolve from SAP PM (Plant Maintenance). SAP PM was introduce started within SAP R/2, R/3. Later in 2005 with the first ERP release into the market PM term has been replaced with EAM.
The SAP PM module is a subset of SAP EAM. SAP PM contains the key Maintenance Planning and Scheduling functionalities to support successful asset or equipment maintenance. And you will find new process within EAM.

Regards,
Edward

[Edward T]

Hi,
Since you need all the details data from your IDoc, and IDoc data segment table is a cluster table, I don’t think you will be able to access it directly via SQL Server query.
The best thing to do is to create an interface using RFC Function that will provide you all the data you need before you access it from non-SAP apps.
You can get all the data required from following tables:

EDIDC – control record
EDIDS – has status and message record
EDID4 – data segment record

You can filter by IDOC Message type and segment name and get only IDoc with status 51.
Hope its help,

Regards,
Edward

[Edward T]

Hi Arthur,

You can create a query or simple report program for this purpose. The tables you will need are :
PR data can get from EBAN
PO data can get from EKKO + EKPO
GR data can get from MKPF + MSEG
IR data can get from RBKP + RSEG
And PO history from EKBE

The logic should follow this:

1. SELECT BANFN, BNFPO, LFDAT, FRGDT, EBELN, EBELP, …
FROM EBAN

2. SELECT EBELN, EBELP, AEDAT, …
FROM EKKO INNER JOIN EKPO
WHERE EKKO~EBELN = EBAN~EBELN
AND EKPO~EBELP = EBAN~EBELP

3. SELECT EBELN, EBELP, VGABE, BELNR, BUZEI, BUDAT,…
FROM EKBE
WHERE EBELN = EKKO~EBELN
AND EBELP = EKPO~EBELP

4. If you need details for GR then
get from MKPF + MSEG
Where MKPF~MBLNR = EKBE~BELNR
and MKPF~MJAHR = EKBE~GJAHR
and MSEG~ZEILE = EKBE~BUZEI
(for EKBE~VGABE = ‘1’)

5. If you need details for Inv Receipt then
get from RBKP + RSEG
Where RBKP~BELNR = EKBE~BELNR
and RBKP~GJAHR = EKBE~GJAHR
and RSEG~BUZEI = EKBE~BUZEI
(for EKBE~VGABE = ‘2’)

Thanks,
Edward

• This reply was modified 4 years, 8 months ago by Edward T.

[Author]

Posts