cancel
Showing results for 
Search instead for 
Did you mean: 

Table for maintenance plan and maintenance cycle and Unit

Former Member
0 Kudos
24,821

Hello,

I need to know the table where the values are stored for maintenance plan, maintenance cycle and Unit.

I know that we can get the maintenance cycle and unit from MMPT table.

Question 1

If the maintenance plan has only a single cycle then the data is stored in above table MMPT, but if a maintenance plan has mutiple cycles like 1 maintenance plan has maintenance cycle as 364 Days and 1092 days then the data is not stored in MMPt table.

Question 2

Requirement is I need to develop a report where in I need maintenance order, maintenance plan and the relevant maintenance cycle and unit. Supose an maintenance order is created for the above maintenance plan which has 2 maintenance cycle how can I identify for which maintenance cycle the order is created.

Regards,

Narendra

Accepted Solutions (0)

Answers (8)

Answers (8)

Former Member

Hi ,

Tables related to MP are :-

MHIO Call Object from Maintenance Order

MHIS Maintenance plan history

MMPT Cycle definitions and MeasPoints for MaintPlan

MMPX Maintenance cycle short texts

MPLA Maintenance plan

MPOS Maintenance item

T351 Maintenance strategy

T351P Maintenance packages

T351T Maintenance strategy texts

T351X Maintenance strategy package texts

T399G Maintenance Plan Sort Field

T399G_T Descriptions for Maintenance Plan Sort Fields

T399P Maintenance item category parameter

T399W Maintenance plan type parameter

T399W_T Maintenance plan category descriptions

VIMPOS Maintenance Item (view)

regards

pushpa

Former Member
0 Kudos

Hi. Prob a bit late now - but might help someone. The calculation looks to be divide the filed ZYKL1 (package cycle) by 86400 as the duration is stored in secs. (60 x 60 x 24 = 86400). This will convert the cycle to days which should be more meaningful.

Regards, D.

former_member330924
Discoverer

David,

It's never too late. Your note helped me today.

Best Regards,

Andy

Former Member
0 Kudos

One of our developers is going to do the conversions....however, if anyone ones to provide any better solutions to handle single cycle with no maintenance packages to log against, that would be great!

Former Member
0 Kudos

Hi Linda,

maintenance Plan and the Strategies are 2 completely diferent things.

you need to understand this that when you are calling the maintenance plan, the table MMPT is getting called but when you are talking about the maintenance package then the system first checks for the T351 and in turn goes to T351P, to fatch the packages.

Each Maintenance Plan can have multiple Packages from the same strategy.

I also checked the same long time back but couldnt find any standard solution.

Regards,

Yawar Khan

Former Member
0 Kudos

I am looking for same information to generate a PM compliance report from BW. So if I do a conversion using excel, for some numbers I have in table MMPT: 1.555200000000000E+07 and divide by 873600000000000000000 it actually comes out to 1.78021978021978E-14. My P/M is for 6 months. So then there has to be another conversion to get if from that number to 6 months. That is where I struggle...math not my strong suit...purely functional If anyone could help??

former_member661330
Contributor
0 Kudos

Hi,

You are using a strategy with two different cycles, correct? on these maintenance plans the cycle is coming from the task list and the strategy assigned to the task list.

You need to use the table MHIS field offset (OFFZE) this is the frequency per each operation, you will see a number like 3,1449600000000000E+07 you need to divide this number by 873600000000000000000 and you will have the frequency 360 days. When you have two packages 360 and 1092 then you will have two different calls on the table

Regards

Carlos

Former Member
0 Kudos

Hi Friends,

Could not findthe data in MMPT table for a plan having multiple cycles. Please help.

Regards,

Naren

Former Member
0 Kudos

Hi Friends,

Any help

Naren

former_member661330
Contributor
0 Kudos

Hi,

Please review PM tables

PM/SM/SD Tables

MPOS Maintenance Items

AFAB Network - Relationships

PLKO Task list

PLAS

AFFH Operations

PRT assignment data for the work order

AFFL Work order sequence

AFFT Order process instructions

AFFV Order process instruction values

AFFW Goods movements with errors from confirmations

AFIH Maintenance order header

AFKO Order header data PP orders

AFPO Order item

AFRC Table of planned changes to conf.: Automatic goods receipt

AFRD Default values for collective confirmation

AFRH Header information for confirmation pool

AFRU Order completion confirmations

AFRV Pool of confirmations

AFVC Operation within an order

AFVU DB structure of the user fields of the operation

AFVV DB structure of the quantities/dates/values in the operation

MPOS Maintenance ITEM

AFWI Subsequently posted goods movements for confirmations

AUFK Order master data

AUFM Goods movement for order

MPLA Maintenance Plans

BGMK Master warranty header

BGMP Master warranty item

BGMS Text item master warranty

BGMT Master warranty text

BGMZ Warranty counter information

CRHD Work Center Header

CRTX Text for the Work Center or Production Resource/Tool

EQKT Equipment short texts

EQST Equipment link to BOM

EQUI Equipment master data

EQUZ Equipment time segment

HIKO Order master data history

IFLO Functional Location (View)

IFLOT Functional location (TABLE)

IFLOTX Functional location: Short texts

IHGNS Plant maintenance permit segment

IHPA Plant Maintenance: Partners

IHSG Object-related permits in Plant Maintenance

ILOA PM object location and account assignment

IMPTT Measuring point (table)

IMRG Measurement document

KAKO Capacity Header Segment

KONP Conditions (Item)

KONV Conditions (Procedure Data)

OBJK Plant Maintenance Object List

QMEL Quality notification

QMFE Quality notification - items

QMIH Quality message - maintenance data excerpt

QMMA Quality notification - activities

QMSM Notification - Tasks

QMUR Quality notification - causes

STPOA Name is does not have an A at the end; BOM items

T001 Company Codes

T001L Storage Locations

T001W Plants

T077D Customer account groups

T003O Order Types

T352R Maintenance revisions

T353I_T Maintenance activity type description

T356 Priorities

T357G Permits

T357G_T Table 357G texts

T370A Activity category for PM lists

TINCT Customers: Incoterms: Texts

TVKO Organizational Unit: Sales Organizations

TVKOS Organizational Unit: Divisions per Sales Organization

TVKOV Org. Unit: Distribution Channels per Sales Organization

TVTA Organizational Unit: Sales Area(s)

VIAUFKST Order selection view

MMPT Cycle detail

Regards

Carlos

Former Member
0 Kudos

Guys/Gals,

Please help...

Naren