Skip to Content
author's profile photo Former Member
Former Member

Table for maintenance plan and maintenance cycle and Unit

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

8 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2011 at 03:49 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2011 at 03:36 PM

    Guys/Gals,

    Please help...

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 07, 2011 at 04:10 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2011 at 08:40 AM

    Hi Friends,

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

    Regards,

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 08, 2011 at 03:14 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2012 at 05:11 PM

    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??

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2012 at 07:18 PM

    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!

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2014 at 02:43 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.