SAP-tabelreferentie

QMEL

Quality Notification

Bekijk een andere tabel

Vul een tabelcode of zoekwoord in om verder te zoeken.

Bekijk de structuur, velden en relaties van SAP-tabel QMEL.

SAP-tabel QMEL heeft 2 primaire sleutelvelden: MANDT,QMNUM.

Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.

/ Velden

QMEL velden.

155 velden
VeldOmschrijvingDatatypeLengteDecimalenChecktabelData-element
Sleutel MANDT ClientCLNT30 T000 MANDT
Sleutel QMNUM Notification NumberCHAR120 QMNUM
QMART Notification TypeCHAR20 TQ80 QMART
QMTXT Short TextCHAR400 QMTXT
ARTPR Priority TypeCHAR20 T356A ARTPR
PRIOK PriorityCHAR10 T356 PRIOK
ERNAM Name of Person Responsible for Creating the ObjectCHAR120 ERNAM
ERDAT Date on which the record was createdDATS80 ERDAT
AENAM Name of Person Who Changed ObjectCHAR120 AENAM
AEDAT Last Changed OnDATS80 AEDAT
MZEIT Time of NotificationTIMS60 MZEIT
QMDAT Date of NotificationDATS80 QMDAT
QMNAM Name of Person Reporting NotificationCHAR120 QMNAM
STRMN Required start dateDATS80 STRMN
STRUR Required Start TimeTIMS60 STRUR
LTRMN Required End DateDATS80 LTRMN
LTRUR Required End TimeTIMS60 LTRUR
WAERS Currency KeyCUKY50 TCURC WAERS
AUFNR Order NumberCHAR120 AUFK AUFNR
VERID Production VersionCHAR40 MKAL QM_VERID
RM_MATNR Material Number of Production VersionCHAR400 MKAL RM_MATNR
RM_WERKS Plant of Production VersionCHAR40 MKAL RM_WERKS
SA_AUFNR Run schedule header numberCHAR120 SAFK SA_AUFNR
MATNR Material NumberCHAR400 MARA MATNR
REVLV Revision LevelCHAR20 REVLV
MATKL Material GroupCHAR90 T023 MATKL
PRDHA Product hierarchyCHAR180 T179 PRODH_D
KZKRI Indicator: Critical partCHAR10 KZKRI
KZDKZ Documentation required indicatorCHAR10 KZDKZ
KUNUM Account Number of CustomerCHAR100 KNA1 QKUNUM
FEKNZ Defect Records ExistCHAR10 FEKNZ
MAKNZ Task Records ExistCHAR10 MAKNZ
OBJNR Object Number for Status ManagementCHAR220 ONR00 QMOBJNR
QMDAB Date for Notification CompletionDATS80 QMDAB
QMZAB Completion Time of NotificationTIMS60 QMZAB
RBNR Catalog ProfileCHAR90 T352B RBNR
RBNRI Origin of Notifications Catalog ProfileCHAR10 RBNRI
INDTX Object Long Text AvailableCHAR10 INDLTX
KZMLA Primary language indicator for text segmentCHAR10 KZMLA
HERKZ Origin of NotificationCHAR20 HERKZ
BEZDT Notification Reference DateDATS80 BEZDT
BEZUR Notification Reference TimeTIMS60 BEZUR_D
LIFNUM Supplier Account NumberCHAR100 LFA1 LIFNUM
BUNAME Author of a QM/PM NotificationCHAR120 BUNAME
VBELN Sales Order NumberCHAR100 VBAK QM_KDAUF
BSTNK Customer ReferenceCHAR350 BSTKD
BSTDK Customer Reference DateDATS80 BSTDK
SPART DivisionCHAR20 TSPA SPART
VKORG Sales OrganizationCHAR40 TVKO VKORG
VTWEG Distribution ChannelCHAR20 TVTW VTWEG
ADRNR Addresses: Address NumberCHAR100 CADNR
AEZEIT Time of ChangeTIMS60 AEZEIT
ERZEIT Time at Which Record Was AddedTIMS60 ERZEIT
MAWERK Plant for MaterialCHAR40 T001W QMAWERKS
QMKAT Catalog Type - CodingCHAR10 TQ15 QMKAT
QMGRP Code Group - CodingCHAR80 QPGR QMGRP
QMCOD CodingCHAR40 QMCOD
AUSWIRK Key for a ScenarioCHAR40 TQ81 QSCENARIO
TEILEV Usage of PartsCHAR40 TQ81V QTEILEV
PRUEFLOS Inspection Lot NumberNUMC120 QALS QPLOS
CHARG Batch NumberCHAR100 MCH1 CHARG_D
LGORTCHARG Storage Location of BatchCHAR40 T001L QLGORTCHAR
LICHN Supplier Batch NumberCHAR150 LICHN
HERSTELLER Number of ManufacturerCHAR100 LFA1 QLIFNR
EMATNR Material number corresponding to manufacturer part numberCHAR400 MARA EMATN
EKORG Purchasing organizationCHAR40 T024E EKORG
BKGRP Purchasing GroupCHAR30 T024 BKGRP
LGORTVORG Storage Location for Inspection Lot StockCHAR40 T001L QLGORTVORG
FERTAUFNR Order Number (Production Order)CHAR120 AUFK FERTAUFNR
FERTAUFPL Plan Number for Operations in Order (Production Order)NUMC100 FERTAUFPL
EBELN Purchasing Document NumberCHAR100 EKKO QM_EBELN
EBELP Item Number of Purchasing DocumentNUMC50 EKPO QEBELP
MJAHR Material Document YearNUMC40 QM_MJAHR
MBLNR Number of Material DocumentCHAR100 QM_MBLNR
MBLPO Item in Material DocumentNUMC40 QMBLPO
LS_KDAUF Sales Order NumberCHAR100 VBAK QM_KDAUF
LS_KDPOS Item number of the SD documentNUMC60 VBAP QM_POSNR
LS_VBELN DeliveryCHAR100 LIKP VBELN_VL
LS_POSNR Delivery ItemNUMC60 LIPS QPOSNR_VL
CROBJTY Object types of the CIM resourceCHAR20 CR_OBJTY
ARBPL Object ID of the Work CenterNUMC80 CRID LGWID
ARBPLWERK Plant for Work CenterCHAR40 T001W QARBPWERKS
FEART Report Type for Defects RecordingCHAR80 TQ86 QFEART
PNLKN Current Node Number from Order CounterNUMC80 QLFNKN
MGEIG Defective Quantity (Internal)QUAN133 MGEIG
MGFRD Defective Quantity (External)QUAN133 MGFRD
MGEIN Unit of MeasureUNIT30 T006 MGEIN
BZMNG General Reference QuantityQUAN133 QBZMNG
RKMNG Complaint QuantityQUAN133 RKMNG
RGMNG Return Delivery QuantityQUAN133 RGMNG
RKDAT Date of Return DeliveryDATS80 RKDAT
COAUFNR Order Number (QM Order)CHAR120 AUFK COAUFNR
QWRNUM Reference Notification NumberCHAR120 QMEL QWRNUM
REFNUM External Reference NumberCHAR200 QMEXTNR
KDMAT Material Number Used by CustomerCHAR350 MATNR_KU
IDNLF Material Number Used by SupplierCHAR350 IDNLF
SERIALNR Serial NumberCHAR180 GERNR
KZLOESCH Delete Data RecordCHAR10 KZLOESCH
CVP_XBLCK Business Purpose Completed FlagCHAR10 CVP_XBLCK
PRODDAT Production DateDATS80 QM_QPRODDAT
DEVICEID Additional Device DataCHAR400 DEVICEID
VKBUR Sales officeCHAR40 TVKBZ VKBUR
VKGRP Sales groupCHAR30 TVBVK VKGRP
AUTKZ Data Record Created with Function 'Create with Copy Model'CHAR10 QAUTKZ
BEDID ID of the Capacity Requirements RecordNUMC120 BEDID
BEDZL Internal counterNUMC80 CIM_COUNT
PROFIL_TYP Object TypeCHAR20 OTYPE
PROFIL_ID Object IDNUMC80 OBJEKTID
HANDLE Globally unique identifier (linked to time segment, etc)CHAR220 TSEGGUID
TSEGFL Time segment existsCHAR10 TSEGEXISTS
TSEGTP TemplateCHAR100 TTSEGTPLH TSEGTEMPLA
TZONSO Time Zone for NotificationCHAR60 TTZZ TZONSO
TZONID Origin of Time Zone in NotificationCHAR10 TZONSMID
FUNKTION Keys for Function in Action BoxCHAR40 QNFUNKTION
/SAPSMOSS/INSTN Installation numberCHAR100 /SAPSMOSS/INSTN /SAPSMOSS/R3INSTN
/SAPSMOSS/MNUMM SAPNet notification numberNUMC240 /SAPSMOSS/MNUMM
/SAPSMOSS/OSSYS Operating system and versionCHAR100 /SAPSMOSS/OSYS /SAPSMOSS/OSSYS
/SAPSMOSS/DBSYS Database systemCHAR100 /SAPSMOSS/DBSY /SAPSMOSS/DBSYS
/SAPSMOSS/REL R/3 ReleaseCHAR100 /SAPSMOSS/REL /SAPSMOSS/R3REL
/SAPSMOSS/COMP AreaCHAR200 /SAPSMOSS/R3COMP
/SAPSMOSS/FRONT FrontendCHAR100 /SAPSMOSS/FRNT /SAPSMOSS/FRONTEND
/SAPSMOSS/SYSTYP R/3 System typeCHAR10 /SAPSMOSS/SYST /SAPSMOSS/R3SYSTYPE
/SAPSMOSS/ADDID Add-on IDCHAR100 /SAPSMOSS/ADDID /SAPSMOSS/R3ADDID
/SAPSMOSS/ADDREL Add-On ReleaseCHAR100 /SAPSMOSS/ADDRL /SAPSMOSS/R3ADDREL
/SAPSMOSS/TSTMP SAPNet time stampNUMC140 /SAPSMOSS/NSTSTMP
/SAPSMOSS/STATUS Status of R/3 notification in SAPNetCHAR10 /SAPSMOSS/STAT /SAPSMOSS/STATUS
/SAPSMOSS/ERDAT Date on which notification was completed at SAPDATS80 /SAPSMOSS/ERDAT
/SAPSMOSS/ERZEIT Time when notification was completed at SAPTIMS60 /SAPSMOSS/ERZEIT
/SAPSMOSS/SYSID Name of SAP SystemCHAR80 SYSYSID
/SAPSMOSS/MANDT Client IDCLNT30 * SYMANDT
PSP_NR WBS ElementNUMC80 * QM_PS_POSNR
ESTIMATED_COSTS Estimated Costs for a ClaimCURR132 PS_COSTS
CLAIMED_COSTS Costs ClaimedCURR132 COSTS_CLAIM
RESULT_COSTS Costs AcceptedCURR132 COSTS_RESULT
CHANCE Chance of Completing a ClaimNUMC20 PS_CHANCE
OPPONENT Partner TypeCHAR20 PS_OPPONENT
KALNR Cost Estimate Number for Cost Est. w/o Qty StructureNUMC120 CK_KALNR
KALVAR Costing Variant for Postprocessing with Unit CostingCHAR40 CK_KALVAR
OBJNR_REAL Object Number of Real CO Account AssignmentCHAR220 ONR00 J_OBJNR_REAL
OBJNR_STAT Auxiliary account assignment 1CHAR220 ONR00 OBJNR_N1
DUMMY_QMEL_INCL_EEW_PS Dummy function in length 1CHAR10 DUMMY
PHASE Notification Processing PhaseCHAR10 QM_PHASE
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss)DEC150 TZNTSTMPS
/ISDFPS/MHIO_ADDATE Completion Date for Call ObjectDATS80 MHIO_ADDAT
/ISDFPS/MHIO_ADTIME Completion Time for Call ObjectTIMS60 MHIO_ADUHR
/ISDFPS/USERMODE Scheduling determined by userCHAR10 USERMOD
/ISDFPS/OBJNR Object numberCHAR220 * J_OBJNR
LOGSYSTEM Logical SystemCHAR100 * LOGSYSTEM
/ISDFPS/MEQUI Master EquipmentCHAR180 * /ISDFPS/MEQUI
SHN_OBJTY Object types of the CIM resourceCHAR20 CR_OBJTY
SHN_OBJID Object ID of the resourceNUMC80 * CR_OBJID
SHN_FUNCT_LOC Functional LocationCHAR300 TPLNR
SHN_EQUIPMENT Equipment NumberCHAR180 EQUNR
SHN_ORIGIN Origin or Use of Shift Note or ReportNUMC20 COCF_SRN_ORIGIN
UII Unique Item IdentifierCHAR720 UII_CHAR72
/ Relaties

QMEL relaties.

90 relaties
TabelVeldChecktabelOmschrijvingCheckveld
QMELARBPLCRIDCIM Resource - EntitiesMANDT
QMELARBPLCRIDCIM Resource - EntitiesOBJID
QMELARBPLWERKT001WPlants/BranchesMANDT
QMELARBPLWERKT001WPlants/BranchesWERKS
QMELARTPRT356APriority type tableMANDT
QMELARTPRT356APriority type tableARTPR
QMELAUFNRAUFKOrder master dataAUFNR
QMELAUSWIRKTQ81Notification ScenarioMANDT
QMELAUSWIRKTQ81Notification ScenarioAUSWIRK
QMELBKGRPT024Purchasing GroupsEKGRP
QMELCHARGMCH1Batches (if Batch Management Cross-Plant)MANDT
QMELCOAUFNRAUFKOrder master dataAUFNR
QMELEBELNEKKOPurchasing Document HeaderEBELN
QMELEBELPEKPOPurchasing Document ItemMANDT
QMELEBELPEKPOPurchasing Document ItemEBELN
QMELEKORGT024EPurchasing OrganizationsEKORG
QMELEMATNRMARAGeneral Material DataMANDT
QMELEMATNRMARAGeneral Material DataMATNR
QMELFEARTTQ86Report category for defects recordingMANDT
QMELFERTAUFNRAUFKOrder master dataAUFNR
QMELHERSTELLERLFA1Supplier Master (General Section)MANDT
QMELHERSTELLERLFA1Supplier Master (General Section)LIFNR
QMELKUNUMKNA1General Data in Customer MasterMANDT
QMELKUNUMKNA1General Data in Customer MasterKUNNR
QMELLGORTCHARGT001LStorage LocationsMANDT
QMELLGORTCHARGT001LStorage LocationsWERKS
QMELLGORTVORGT001LStorage LocationsMANDT
QMELLGORTVORGT001LStorage LocationsWERKS
QMELLIFNUMLFA1Supplier Master (General Section)MANDT
QMELLIFNUMLFA1Supplier Master (General Section)LIFNR
QMELLS_KDAUFVBAKSales Document: Header DataMANDT
QMELLS_KDAUFVBAKSales Document: Header DataVBELN
QMELLS_KDPOSVBAPSales Document: Item DataVBELN
QMELLS_KDPOSVBAPSales Document: Item DataPOSNR
QMELLS_POSNRLIPSSD document: Delivery: Item dataMANDT
QMELLS_POSNRLIPSSD document: Delivery: Item dataVBELN
QMELLS_POSNRLIPSSD document: Delivery: Item dataPOSNR
QMELLS_VBELNLIKPSD Document: Delivery Header DataMANDT
QMELLS_VBELNLIKPSD Document: Delivery Header DataVBELN
QMELMATKLT023Material GroupsMATKL
QMELMATNRMARAGeneral Material DataMANDT
QMELMATNRMARAGeneral Material DataMATNR
QMELMAWERKT001WPlants/BranchesMANDT
QMELMAWERKT001WPlants/BranchesWERKS
QMELMGEINT006Units of MeasurementMANDT
QMELMGEINT006Units of MeasurementMSEHI
QMELOBJNRONR00General Object NumberMANDT
QMELOBJNR_REALONR00General Object NumberMANDT
QMELOBJNR_REALONR00General Object NumberOBJNR
QMELOBJNR_STATONR00General Object NumberMANDT
QMELOBJNR_STATONR00General Object NumberOBJNR
QMELPRDHAT179Materials: Product HierarchiesPRODH
QMELPRIOKT356PrioritiesMANDT
QMELPRIOKT356PrioritiesARTPR
QMELPRUEFLOSQALSInspection lot recordMANDANT
QMELQMARTTQ80Notification TypesMANDT
QMELQMARTTQ80Notification TypesQMART
QMELQMGRPQPGRInspection catalog code groupsMANDT
QMELQMGRPQPGRInspection catalog code groupsKATALOGART
QMELQMKATTQ15Inspection catalog type indexKATALOGART
QMELQWRNUMQMELQuality NotificationMANDT
QMELQWRNUMQMELQuality NotificationQMNUM
QMELRBNRT352BTechnical reportMANDT
QMELRM_MATNRMKALProduction Versions of MaterialWERKS
QMELRM_MATNRMKALProduction Versions of MaterialVERID
QMELRM_WERKSMKALProduction Versions of MaterialWERKS
QMELRM_WERKSMKALProduction Versions of MaterialVERID
QMELSA_AUFNRSAFKRun Schedule Master DataMANDT
QMELSA_AUFNRSAFKRun Schedule Master DataAUFNR
QMELSPARTTSPAOrganizational Unit: Sales DivisionsMANDT
QMELSPARTTSPAOrganizational Unit: Sales DivisionsSPART
QMELTEILEVTQ81VUsage of partsMANDT
QMELTEILEVTQ81VUsage of partsTEILEV
QMELTSEGTPTTSEGTPLHTime Segment Template HeaderTEPL
QMELTZONSOTTZZTime zonesTZONE
QMELVBELNVBAKSales Document: Header DataMANDT
QMELVBELNVBAKSales Document: Header DataVBELN
QMELVERIDMKALProduction Versions of MaterialWERKS
QMELVERIDMKALProduction Versions of MaterialVERID
QMELVKBURTVKBZOrg.Unit: Sales Office: Assignment to Organizational UnitMANDT
QMELVKBURTVKBZOrg.Unit: Sales Office: Assignment to Organizational UnitVKORG
QMELVKBURTVKBZOrg.Unit: Sales Office: Assignment to Organizational UnitVTWEG
QMELVKBURTVKBZOrg.Unit: Sales Office: Assignment to Organizational UnitSPART
QMELVKGRPTVBVKOrganizational Unit: Sales Groups per Sales OfficeMANDT
QMELVKORGTVKOOrganizational Unit: Sales OrganizationsMANDT
QMELVKORGTVKOOrganizational Unit: Sales OrganizationsVKORG
QMELVTWEGTVTWOrganizational Unit: Distribution ChannelsMANDT
QMELVTWEGTVTWOrganizational Unit: Distribution ChannelsVTWEG
QMELWAERSTCURCCurrency CodesMANDT
QMELWAERSTCURCCurrency CodesWAERS