MPOS
Maintenance item
MPOS is an SAP database table in S/4HANA. Maintenance item. It contains 82 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_MaintenanceItemBasic | view | from | EXTENSION | Extension View of Maintenance Item |
| I_MaintenanceItemBasic | view | from | BASIC | Basic view for MaintenanceItem |
Fields (82)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | wapos | WAPOS | MaintItem | |||
| warpl | WARPL | MaintenancePlan | ||||
| wstra | STRAT | Strategy | ||||
| wppos | WPPOS | Item number | ||||
| pstxt | POSTXT | MaintItem text | ||||
| equnr | EQUNR | Equipment | ||||
| obknr | OBJKNR | Object list | ||||
| erknz | ERKNZ | CreatnIndic. | ||||
| aeknz | AEKNZ | ChngeIndic. | ||||
| ernam | ERNAM | Created By | ||||
| ersdt | EDATUM | Created on | ||||
| aedat | AEDAT | Changed On | ||||
| aenam | AENAM | Changed By | ||||
| plnty | PLNTY | Task List Type | ||||
| plnnr | PLNNR | Group | ||||
| plnal | PLNAL | Group Counter | ||||
| status | MPSTAT | Status | ||||
| ltknz | MPLTX | L-Text Indicat. | ||||
| wpgrp | INGRP | Planner Group | ||||
| objty | CR_OBJTY | Object Type | ||||
| gewrk | LGWID | Work Center | ||||
| iwerk | IWERK | Planning Plant | ||||
| langu | MPLANGU | Language | ||||
| iloan | ILOAN | Loc/AccAssmt | ||||
| iloai | ILOAI | ILOA individ. | ||||
| laufn | LAUFN | Last order | ||||
| bautl | BAUTL | Assembly | ||||
| anlzu | ANLZU | SystemCondition | ||||
| auart | AUFART | Order Type | ||||
| inact | INACT | Inactive | ||||
| ilart | ILA | MaintActivType | ||||
| gsber | GSBER | Business Area | ||||
| objnr | J_OBJNR | Object number | ||||
| ind_abrvo | IND_ABRVO | SettlmntRule | ||||
| pspel | PS_PSP_PNR | WBS Element | ||||
| std_netz | PLNNR | Group | ||||
| std_avo | PLNKN | Node | ||||
| kdauf | VBELN_VA | Sales Document | ||||
| kdpos | POSNR_VA | Item | ||||
| mityp | MITYP | MaintItCat | ||||
| bstnr | BSTNR | Purchase order | ||||
| bstpo | BSTPO | Item | ||||
| packno | PACKNO | Package number | ||||
| netpr | NETPR | Net Price | ||||
| waers | WAERS | Currency | ||||
| sakto | KSTAR | Cost Element | ||||
| aufnr | ILOM_ORDST | SettlementOrder | ||||
| apfkt | APFKT | Task list factor | ||||
| scrrenty | SCREENTY | Type | ||||
| serialnr | GERNR | Serial Number | ||||
| sermat | MATNR | Material | ||||
| deviceid | DEVICEID | Device Data | ||||
| qmnum | QMNUM | Notification | ||||
| qmart | QMART | Notifictn Type | ||||
| lblni | LBLNI | Entry Sheet | ||||
| task_determine | TASK_DETERMINE | Task determtn. | ||||
| priok | PRIOK | Priority | ||||
| qmkat | QMKAT | Catalog Type | ||||
| qmgrp | QMGRP | Code Group | ||||
| dummy_mpos_incl_eew_ps | CFD_DUMMY | Dummy | ||||
| qmcod | QMCOD | Coding | ||||
| phynr | QPHYSPRNR | Sample | ||||
| art | QPART | Inspection Type | ||||
| prueflos | QPLOS | Inspection Lot | ||||
| tstmp_bw | TSTMP_BW_EXT | Time (GMT) | ||||
| no_aufrelkz | NO_AUFRELKZ | Do Not Release | ||||
| maintcmplnccalculationmethod | EAM_MAINTCMPLNCCALCMETHOD | Cmplnc_Calc_Method | ||||
| maintcmplncstrtdteoffsetindays | EAM_OFF_STADT | Offset Start | ||||
| maintcmplncenddateoffsetindays | EAM_OFF_ENDDT | Offset End Date | ||||
| service_document_type | CRMT_PROCESS_TYPE | Transaction Type | ||||
| service_contract | CRMT_OBJECT_ID_DB | Transaction ID | ||||
| service_contract_item | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| service_template | CRMT_OBJECT_ID_DB | Transaction ID | ||||
| service_priority | CRMT_PRIORITY | Priority | ||||
| product | PRODUCTNUMBER | Product | ||||
| desnum | /CUM/DESNUM | CU Design No. | ||||
| cycleseqind | CYCLESETSEQ | Cycle Set Seq. | ||||
| adpsp | ADDCOMPARE_CORE | Ref. Element PM/PS | ||||
| ind_mpos_api | IND_MPOS_API | MItem by API | ||||
| rbnr | RBNR | Catalog Profile | ||||
| rbnri | EAM_RBNRI_MITEM | Profile Origin |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Maintenance item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPOS (
MANDT, -- Client [MANDT]
WAPOS, -- MaintItem [WAPOS]
WARPL, -- MaintenancePlan [WARPL]
WSTRA, -- Strategy [STRAT]
WPPOS, -- Item number [WPPOS]
PSTXT, -- MaintItem text [POSTXT]
EQUNR, -- Equipment [EQUNR]
OBKNR, -- Object list [OBJKNR]
ERKNZ, -- CreatnIndic. [ERKNZ]
AEKNZ, -- ChngeIndic. [AEKNZ]
ERNAM, -- Created By [ERNAM]
ERSDT, -- Created on [EDATUM]
AEDAT, -- Changed On [AEDAT]
AENAM, -- Changed By [AENAM]
PLNTY, -- Task List Type [PLNTY]
PLNNR, -- Group [PLNNR]
PLNAL, -- Group Counter [PLNAL]
STATUS, -- Status [MPSTAT]
LTKNZ, -- L-Text Indicat. [MPLTX]
WPGRP, -- Planner Group [INGRP]
OBJTY, -- Object Type [CR_OBJTY]
GEWRK, -- Work Center [LGWID]
IWERK, -- Planning Plant [IWERK]
LANGU, -- Language [MPLANGU]
ILOAN, -- Loc/AccAssmt [ILOAN]
ILOAI, -- ILOA individ. [ILOAI]
LAUFN, -- Last order [LAUFN]
BAUTL, -- Assembly [BAUTL]
ANLZU, -- SystemCondition [ANLZU]
AUART, -- Order Type [AUFART]
INACT, -- Inactive [INACT]
ILART, -- MaintActivType [ILA]
GSBER, -- Business Area [GSBER]
OBJNR, -- Object number [J_OBJNR]
IND_ABRVO, -- SettlmntRule [IND_ABRVO]
PSPEL, -- WBS Element [PS_PSP_PNR]
STD_NETZ, -- Group [PLNNR]
STD_AVO, -- Node [PLNKN]
KDAUF, -- Sales Document [VBELN_VA]
KDPOS, -- Item [POSNR_VA]
MITYP, -- MaintItCat [MITYP]
BSTNR, -- Purchase order [BSTNR]
BSTPO, -- Item [BSTPO]
PACKNO, -- Package number [PACKNO]
NETPR, -- Net Price [NETPR]
WAERS, -- Currency [WAERS]
SAKTO, -- Cost Element [KSTAR]
AUFNR, -- SettlementOrder [ILOM_ORDST]
APFKT, -- Task list factor [APFKT]
SCRRENTY, -- Type [SCREENTY]
SERIALNR, -- Serial Number [GERNR]
SERMAT, -- Material [MATNR]
DEVICEID, -- Device Data [DEVICEID]
QMNUM, -- Notification [QMNUM]
QMART, -- Notifictn Type [QMART]
LBLNI, -- Entry Sheet [LBLNI]
TASK_DETERMINE, -- Task determtn. [TASK_DETERMINE]
PRIOK, -- Priority [PRIOK]
QMKAT, -- Catalog Type [QMKAT]
QMGRP, -- Code Group [QMGRP]
DUMMY_MPOS_INCL_EEW_PS, -- Dummy [CFD_DUMMY]
QMCOD, -- Coding [QMCOD]
PHYNR, -- Sample [QPHYSPRNR]
ART, -- Inspection Type [QPART]
PRUEFLOS, -- Inspection Lot [QPLOS]
TSTMP_BW, -- Time (GMT) [TSTMP_BW_EXT]
NO_AUFRELKZ, -- Do Not Release [NO_AUFRELKZ]
MAINTCMPLNCCALCULATIONMETHOD, -- Cmplnc_Calc_Method [EAM_MAINTCMPLNCCALCMETHOD]
MAINTCMPLNCSTRTDTEOFFSETINDAYS, -- Offset Start [EAM_OFF_STADT]
MAINTCMPLNCENDDATEOFFSETINDAYS, -- Offset End Date [EAM_OFF_ENDDT]
SERVICE_DOCUMENT_TYPE, -- Transaction Type [CRMT_PROCESS_TYPE]
SERVICE_CONTRACT, -- Transaction ID [CRMT_OBJECT_ID_DB]
SERVICE_CONTRACT_ITEM, -- Item Number in Doc. [CRMS4_NUMBER_INT]
SERVICE_TEMPLATE, -- Transaction ID [CRMT_OBJECT_ID_DB]
SERVICE_PRIORITY, -- Priority [CRMT_PRIORITY]
PRODUCT, -- Product [PRODUCTNUMBER]
DESNUM, -- CU Design No. [/CUM/DESNUM]
CYCLESEQIND, -- Cycle Set Seq. [CYCLESETSEQ]
ADPSP, -- Ref. Element PM/PS [ADDCOMPARE_CORE]
IND_MPOS_API, -- MItem by API [IND_MPOS_API]
RBNR, -- Catalog Profile [RBNR]
RBNRI, -- Profile Origin [EAM_RBNRI_MITEM]
PRIMARY KEY (MANDT, WAPOS)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA