DIQMEL SAP (PM Notification) Structure details
Description: PM Notification
Structure field list including key, data, relationships and ABAP select examples
DIQMEL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "PM Notification" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_DIQMEL TYPE DIQMEL.
The DIQMEL table consists of various fields, each holding specific information or linking keys about PM Notification data available in SAP. These include MANDT (Client), QMNUM (Notification No), QMART (Notification Type), QMTXT (Short Text).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DIQMEL structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
QMNUM | Notification No | QMNUM | CHAR | 12 | Assigned to domain | ALPHA | QMNUM | IQM | |
QMART | Notification Type | QMART | CHAR | 2 | TQ80 | QMART | QMR | ||
QMTXT | Short Text | QMTXT | CHAR | 40 | TEXT40 | ||||
ARTPR | Priority Type | ARTPR | CHAR | 2 | T356A | ARTPR | |||
PRIOK | Priority | PRIOK | CHAR | 1 | T356 | PRIOK | PRIOK | ||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
MZEIT | Time of Notification | MZEIT | TIMS | 6 | UHRZT | ||||
QMDAT | Date of Notification | QMDAT | DATS | 8 | DATUM | ||||
QMNAM | Name of Person Reporting Notification | QMNAM | CHAR | 12 | USNAM | ||||
STRMN | Required start date | STRMN | DATS | 8 | DATUM | ||||
STRUR | Required Start Time | STRUR | TIMS | 6 | UZEIT | ||||
LTRMN | Required End Date | LTRMN | DATS | 8 | DATUM | ||||
LTRUR | Requested End Time | LTRUR | TIMS | 6 | UZEIT | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
VERID | Production Version | VERID | CHAR | 4 | MKAL | VERID | VER | ||
RM_MATNR | Material number of the production version | RM_MATNR | CHAR | 18 | MKAL | MATN1 | MATNR | MAT | MAT1 |
RM_WERKS | Plant of production version | RM_WERKS | CHAR | 4 | MKAL | WERKS | WRK | H_T001W | |
SA_AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | SAFK | ALPHA | SA_AUFNR | ||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
PRDHA | Product hierarchy | PRODH_D | CHAR | 18 | T179 | PRODH | VPR | ||
KZKRI | Indicator: Critical part | KZKRI | CHAR | 1 | XFELD | ||||
KZDKZ | Documentation required indicator | KZDKZ | CHAR | 1 | XFELD | ||||
KUNUM | Account Number of Customer | QKUNUM | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
FEKNZ | Error Records Exist | FEKNZ | CHAR | 1 | CHAR1 | ||||
MAKNZ | Task Records Exist | MAKNZ | CHAR | 1 | CHAR1 | ||||
OBJNR | Object Number for Status Management | QMOBJNR | CHAR | 22 | ONR00 | J_OBJNR | |||
QMDAB | Date for Notification Completion | QMDAB | DATS | 8 | DATUM | ||||
QMZAB | Completion Time of Notification | QMZAB | TIMS | 6 | UZEIT | ||||
RBNR | Catalog Profile | RBNR | CHAR | 9 | T352B | RBNR | |||
RBNRI | Origin of Notifications Catalog Profile | RBNRI | CHAR | 1 | RBNRI | ||||
INDTX | Object Long Text Available | INDLTX | CHAR | 1 | CHAR1 | ||||
KZMLA | Primary language indicator for text segment | KZMLA | CHAR | 1 | CHAR1 | ||||
HERKZ | Origin of Notification | HERKZ | CHAR | 2 | HERKZ | ||||
BEZDT | Notification Reference Date | BEZDT | DATS | 8 | DATUM | ||||
BEZUR | Notification Reference Time | BEZUR_D | TIMS | 6 | UZEIT | ||||
LIFNUM | Vendor Account Number | LIFNUM | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
BUNAME | Author of a Q/PM Notification | BUNAME | CHAR | 12 | Assigned to domain | XUBNAME | XUS | ||
VBELN | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
BSTNK | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
ADRNR | Addresses: Address Number | CADNR | CHAR | 10 | Assigned to domain | ALPHA | CADRNR | ||
AEZEIT | Time of Change | AEZEIT | TIMS | 6 | UHRZT | ||||
ERZEIT | Time, at Which Record Was Added | ERZEIT | TIMS | 6 | UHRZT | ||||
MAWERK | Plant for Material | QMAWERKS | CHAR | 4 | T001W | WERKS | WRK | ||
QMKAT | Catalog Type - Coding | QMKAT | CHAR | 1 | TQ15 | QKATART | |||
QMGRP | Code Group - Coding | QMGRP | CHAR | 8 | QPGR | QCODEGRP | |||
QMCOD | Coding | QMCOD | CHAR | 4 | Assigned to domain | QCODE | |||
AUSWIRK | Key for a Scenario | QSCENARIO | CHAR | 4 | TQ81 | QSCENARIO | |||
TEILEV | Usage of Parts | QTEILEV | CHAR | 4 | TQ81V | QTEILEV | |||
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | QALS | QPLOS | QLS | QALS | |
CHARG | Batch Number | CHARG_D | CHAR | 10 | MCH1 | CHARG | CHA | ||
LGORTCHARG | Storage Location of Batch | QLGORTCHAR | CHAR | 4 | T001L | LGORT | LAG | ||
LICHN | Vendor Batch Number | LICHN | CHAR | 15 | LICHN | ||||
HERSTELLER | Number of Manufacturer | QLIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
EMATNR | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | MARA | MATN1 | MATNR | HTN | |
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
BKGRP | Purchasing Group | BKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
LGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | CHAR | 4 | T001L | LGORT | |||
FERTAUFNR | Order Number (Production Order) | FERTAUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
FERTAUFPL | Plan Number for Operations in Order (Production Order) | FERTAUFPL | NUMC | 10 | AUFPL | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | QEBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MBLPO | Item in Material Document | QMBLPO | NUMC | 4 | MBLPO | POS | |||
LS_KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
LS_KDPOS | Item number of the SD document | POSNR | NUMC | 6 | VBUP | POSNR | |||
LS_VBELN | Delivery | VBELN_VL | CHAR | 10 | VBUK | ALPHA | VBELN | VL | |
LS_POSNR | Delivery Item | QPOSNR_VL | NUMC | 6 | VBUP | POSNR | |||
CROBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
ARBPL | Object ID of the Work Center | LGWID | NUMC | 8 | CRID | CR_OBJID | |||
ARBPLWERK | Plant for Work Center | QARBPWERKS | CHAR | 4 | T001W | WERKS | WRK | ||
FEART | Report Type for Defects Recording | QFEART | CHAR | 8 | TQ86 | QFEART | QFE | ||
PNLKN | Current Node Number from Order Counter APLZL | QLFNKN | NUMC | 8 | KNTNR | ||||
MGEIG | Defective Quantity (Internal) | MGEIG | QUAN | 13(3) | MENGE | ||||
MGFRD | Defective Quantity (External) | MGFRD | QUAN | 13(3) | MENGE | ||||
MGEIN | Unit of Measure | MGEIN | UNIT | 3 | T006 | CUNIT | MEINS | ||
BZMNG | General Reference Quantity | QBZMNG | QUAN | 13(3) | MENGE | ||||
RKMNG | Complaint Quantity | RKMNG | QUAN | 13(3) | MENGE | ||||
RGMNG | Return Delivery Quantity | RGMNG | QUAN | 13(3) | MENGE | ||||
RKDAT | Date of Return Delivery | RKDAT | DATS | 8 | DATUM | ||||
COAUFNR | Order Number (QM Order) | COAUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
QWRNUM | Reference Notification Number | QWRNUM | CHAR | 12 | QMEL | ALPHA | QMNUM | IQM | |
REFNUM | External Reference Number | QMEXTNR | CHAR | 20 | CHAR020 | ||||
KDMAT | Material Number Used by Customer | MATNR_KU | CHAR | 35 | IDNEX | ||||
IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | IDNEX | ||||
SERIALNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
KZLOESCH | Delete Data Record | KZLOESCH | CHAR | 1 | CHAR1 | ||||
PRODDAT | Production Date | QPRODDAT | DATS | 8 | DATUM | ||||
DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | DEVICEID | ||||
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG | ||
AUTKZ | Data Record Created with Function 'Create with Copy Model' | QAUTKZ | CHAR | 1 | QKZ | ||||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | Assigned to domain | BEDID | |||
BEDZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
PROFIL_TYP | Object Type | OTYPE | CHAR | 2 | Assigned to domain | OTYPE | POT | ||
PROFIL_ID | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
HANDLE | Globally unique identifier (linked to time segment, etc) | TSEGGUID | CHAR | 22 | SYSUUID_22 | ||||
TSEGFL | Time segment exists | TSEGEXISTS | CHAR | 1 | FLAG | ||||
TSEGTP | Template | TSEGTEMPLA | CHAR | 10 | TTSEGTPLH | TMPLA | TSEGTEMPLA | ||
TZONSO | Time Zone for Notification | TZONSO | CHAR | 6 | TTZZ | TZNZONE | |||
TZONID | Origin of Time Zone in Notification | TZONSMID | CHAR | 1 | TZONSMID | ||||
FUNKTION | Keys for Function in Action Box | QNFUNKTION | CHAR | 4 | CHAR4 | ||||
/SAPSMOSS/INSTN | Installation number | /SAPSMOSS/R3INSTN | CHAR | 10 | /SAPSMOSS/INSTN | /SAPSMOSS/R3INSTN | |||
/SAPSMOSS/MNUMM | SAPNet notification number | /SAPSMOSS/MNUMM | NUMC | 24 | /SAPSMOSS/MNUMM | ||||
/SAPSMOSS/OSSYS | Operating system and version | /SAPSMOSS/OSSYS | CHAR | 10 | /SAPSMOSS/OSYS | /SAPSMOSS/OSSYS | |||
/SAPSMOSS/DBSYS | Database system | /SAPSMOSS/DBSYS | CHAR | 10 | /SAPSMOSS/DBSY | /SAPSMOSS/DBSYS | |||
/SAPSMOSS/REL | R/3 Release | /SAPSMOSS/R3REL | CHAR | 10 | /SAPSMOSS/REL | /SAPSMOSS/R3REL | |||
/SAPSMOSS/COMP | Area | /SAPSMOSS/R3COMP | CHAR | 20 | /SAPSMOSS/R3COMP | ||||
/SAPSMOSS/FRONT | Frontend | /SAPSMOSS/FRONTEND | CHAR | 10 | /SAPSMOSS/FRNT | /SAPSMOSS/FRONTEND | |||
/SAPSMOSS/SYSTYP | R/3 System type | /SAPSMOSS/R3SYSTYPE | CHAR | 1 | /SAPSMOSS/SYST | /SAPSMOSS/R3SYSTYPE | |||
/SAPSMOSS/ADDID | Add-on ID | /SAPSMOSS/R3ADDID | CHAR | 10 | /SAPSMOSS/ADDID | /SAPSMOSS/R3ADDID | |||
/SAPSMOSS/ADDREL | Add-On Release | /SAPSMOSS/R3ADDREL | CHAR | 10 | /SAPSMOSS/ADDRL | /SAPSMOSS/R3ADDREL | |||
/SAPSMOSS/TSTMP | SAPNet time stamp | /SAPSMOSS/NSTSTMP | NUMC | 14 | TZNTIMESTP | ||||
/SAPSMOSS/STATUS | Status of R/3 notification in SAPNet | /SAPSMOSS/STATUS | CHAR | 1 | /SAPSMOSS/STAT | /SAPSMOSS/STATUS | |||
/SAPSMOSS/ERDAT | Date on which notification was completed at SAP | /SAPSMOSS/ERDAT | DATS | 8 | DATUM | ||||
/SAPSMOSS/ERZEIT | Time when notification was completed at SAP | /SAPSMOSS/ERZEIT | TIMS | 6 | UHRZT | ||||
/SAPSMOSS/SYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
/SAPSMOSS/MANDT | Client ID | SYMANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PSP_NR | WBS Element | PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
ESTIMATED_COSTS | Estimated Costs for a Claim | PS_COSTS | CURR | 13(2) | WERTV7 | ||||
CLAIMED_COSTS | Costs Claimed | COSTS_CLAIM | CURR | 13(2) | WERTV7 | ||||
RESULT_COSTS | Costs Accepted | COSTS_RESULT | CURR | 13(2) | WERTV7 | ||||
CHANCE | Chance of Completing a Claim | PS_CHANCE | NUMC | 2 | PS_CHANCE | ||||
OPPONENT | Partner Type | PS_OPPONENT | CHAR | 2 | OPPONENT | ||||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
KALVAR | Costing Variant for Postprocessing with Unit Costing | CK_KALVAR | CHAR | 4 | Assigned to domain | KLVAR | |||
OBJNR_REAL | Object number of real CO account assignment | J_OBJNR_REAL | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
OBJNR_STAT | Auxiliary account assignment 1 | OBJNR_N1 | CHAR | 22 | ONR00 | J_OBJNR | |||
PHASE | Notification Processing Phase | QM_PHASE | CHAR | 1 | QM_PHASE | ||||
.INCLU--AP | 0 | ||||||||
/ISDFPS/OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
/ISDFPS/MEQUI | Master Equipment | /ISDFPS/MEQUI | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | ||
.INCLU--AP | 0 | ||||||||
SHN_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
SHN_OBJID | Object ID of the resource | CR_OBJID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
SHN_FUNCT_LOC | Functional Location | TPLNR | CHAR | 30 | Assigned to domain | TPLNR | TPLNR | IFL | IFLM |
SHN_EQUIPMENT | Equipment Number | EQUNR | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | EQN | EQUI |
SHN_ORIGIN | Origin or Use of Shift Note or Report | COCF_SRN_ORIGIN | NUMC | 2 | COCF_SRN_ORIGIN | ||||
.INCLU--AP | 0 | ||||||||
UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | UII_CHAR72 | UII | H_UII | ||
IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | T399I | WERKS | IWK | ||
ILOAN | Location and account assignment for technical object | ILOAN | CHAR | 12 | ILOA | ILOAN | |||
ILOAI | ILOA Individual | ILOAI | CHAR | 1 | X | ||||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
BAUTL | Assembly | BAUTL | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
EBORT | Installation Point for Subitem | EBORT | CHAR | 20 | TEXT20 | ||||
MSAUS | Breakdown Indicator | MSAUS | CHAR | 1 | XFELD | ||||
AUSVN | Start of Malfunction (Date) | AUSVN | DATS | 8 | DATUM | ||||
AUSBS | End of Malfunction (Date) | AUSBS | DATS | 8 | DATUM | ||||
AUZTV | Start of Malfunction (Time) | AUZTV | TIMS | 6 | UHRZT | ||||
AUZTB | End of Malfunction (Time) | AUZTB | TIMS | 6 | UHRZT | ||||
AUSZT | Breakdown Duration | AUSZT | FLTP | 16(16) | FLTP | ||||
MAUEH | Unit for Breakdown Duration | MAUEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BTPLN | Functional Location Affected | BTPLN | CHAR | 30 | IFLOT | TPLNR | TPLNR | IFL | IFLM |
BEQUI | Equipment Affected | BEQUI | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | |
AUSWK | Effect on Operation | AUSWK | CHAR | 1 | T357A | AUSWK | |||
VERFV | Availability Before Malfunction | VERFV | NUMC | 3 | NUM3 | ||||
VERFN | Availability After Malfunction | VERFN | NUMC | 3 | NUM3 | ||||
VERFM | Availability After Completion of Task | VERFM | NUMC | 3 | NUM3 | ||||
ANLZV | System Condition Before Malfunction | ANLZV | CHAR | 1 | T357Z | ANLAZ | |||
ANLZN | System Condition After Malfunction | ANLZN | CHAR | 1 | T357Z | ANLAZ | |||
ANLZE | System Condition After Completion of Task | ANLZE | CHAR | 1 | T357Z | ANLAZ | |||
INSPK | Name of Person Responsible for Technical Inspection | INSPK | CHAR | 12 | USNAM | ||||
DATAN | Date of Technical Inspection | DATAN | DATS | 8 | DATUM | ||||
INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | CHAR | 3 | T024I | INGRP | IHG | ||
ABNUM | Maintenance Plan Call Number | ABNUM | INT4 | 10 | ABNUM | ||||
TPLNR | Functional Location | TPLNR | CHAR | 30 | IFLOT | TPLNR | TPLNR | IFL | IFLM |
ABCKZ | ABC indicator for technical object | ABCKZ | CHAR | 1 | T370C | ABCKZ | |||
ABCKZI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
EQFNR | Sort field | EQFNR | CHAR | 30 | CHAR30 | ||||
EQFNRI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
SWERK | Maintenance plant | SWERK | CHAR | 4 | T001W | WERKS | SWK | ||
SWERKI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
STORT | Location of maintenance object | PMLOC | CHAR | 10 | T499S | AP_STAND | |||
STORTI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
MSGRP | Room | RAUMNR | CHAR | 8 | CHAR8 | ||||
MSGRPI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
BEBER | Plant section | BEBER | CHAR | 3 | T357 | BEBER | BBE | ||
BEBERI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
CR_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
PPSID | Object ID of PP work center | PPSID | NUMC | 8 | CRID | CR_OBJID | |||
PPSIDI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
GSBERI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
KOKRSI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
KOSTLI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
PROID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
PROIDI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BUKRSI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
ANLNR | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLNRI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
ANLUN | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
ANLUNI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
DAUFN | Standing order number | DAUFN | CHAR | 12 | AUFK | ALPHA | AUFNR | ORDP | |
DAUFNI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
KAUFN | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
STTXT | System Status for Notification | QMSTTXT | CHAR | 40 | TEXT40 | ||||
USTXT | User Status Line | J_ATEXT | CHAR | 40 | TEXT40 | ||||
KDAUF | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
KDPOS | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
ARBPLE | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
ADRNR_ILOA | Addresses: Address Number | CADNR | CHAR | 10 | Assigned to domain | ALPHA | CADRNR | ||
STRNO | Functional Location Label | ILOM_STRNO | CHAR | 40 | ILOM_STRNO | ||||
WARPL | Maintenance Plan | WARPL | CHAR | 12 | MPLA | ALPHA | WARPL | MPL | MPLAL |
WAPOS | Maintenance item | WAPOS | CHAR | 16 | ALPHA | POSNU | MPS | MPOSL | |
NAME_LIST | Name for list displays | I_NAME_LST | CHAR | 35 | NAME | ||||
TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | CHAR30 | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
.INCLU--AP | 0 | ||||||||
REVNR | Revision for Plant Maintenance and Customer Service | REVNI | CHAR | 8 | Assigned to domain | REVNI |
Key field | Non-key field |
How do I retrieve data from SAP structure DIQMEL using ABAP code?
As DIQMEL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DIQMEL as there is no data to select.How to access SAP table DIQMEL
Within an ECC or HANA version of SAP you can also view further information about DIQMEL and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects