SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | QMFE
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Plant Maintenance :: Maintenance Processing :: Maintenance Notifications
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0QMFE573Quality notification - itemsMaintenance Notifications
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, QMNUM, FENUM, ERNAM, ERDAT, AENAM, AEDAT, FETXT, FEKAT, FEGRP, FECOD, FEVER, OTKAT, OTGRP, OTEIL, OTVER, BAUTL, EBORT, INDTX, KZMLA, ERZEIT, AEZEIT, KZORG, WDFEH, FEQKLAS, FCOAUFNR, FMGFRD, FMGEIG, FMGEIN, ANZFEHLER, FEHLBEW, UNITFLBEW, FEART, PNLKN, MERKNR, PROBENR, PHYNR, PRUEFLINR, CROBJTY, ARBPL, ARBPLWERK, FENUMORG, KZSYSFE, KZLOESCH, POSNR, HERPOS, AUTKZ, MATNR, WERKS, EKORG, INFNR, KOSTL, LSTAR, PRZNR, MENGE, EQUNR, TPLNR FROM QMFE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2QMNUMNotification Nonvarchar120CHAR(N' ')NoQMELQMNUM Allow NULL? 
3FENUMItem Number in Item Recordnvarchar40NUMC(N'0000')NoFELFD Allow NULL? 
4ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
5ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
6AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
7AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
8FETXTNotification Item Short Textnvarchar400CHAR(N' ')YesFETXT Allow NULL? 
9FEKATCatalog Type - Problems/Defectschar10CHAR(N' ')YesTQ15FEKAT Allow NULL? 
10FEGRPCode Group - Problemnvarchar80CHAR(N' ')YesQPGRFEGRP Allow NULL? 
11FECODProblem or Damage Codenvarchar40CHAR(N' ')Yes*FECOD Allow NULL? 
12FEVERVersion Numbernvarchar60CHAR(N' ')YesQVERSNR Allow NULL? 
13OTKATCatalog Type - Object Partschar10CHAR(N' ')YesTQ15OTKAT Allow NULL? 
14OTGRPCode Group - Object Partsnvarchar80CHAR(N' ')YesQPGROTGRP Allow NULL? 
15OTEILPart of Objectnvarchar40CHAR(N' ')Yes*OTEIL Allow NULL? 
16OTVERVersion Numbernvarchar60CHAR(N' ')YesQVERSNR Allow NULL? 
17BAUTLAssemblynvarchar180CHAR(N' ')YesMARABAUTL Allow NULL? 
18EBORTInstallation Point for Subitemnvarchar200CHAR(N' ')YesEBORT Allow NULL? 
19INDTXObject Long Text Availablechar10CHAR(N' ')YesINDLTX Allow NULL? 
20KZMLAPrimary language indicator for text segmentchar10CHAR(N' ')YesKZMLA Allow NULL? 
21ERZEITTime, at Which Record Was Addednvarchar60TIMS(N'000000')YesERZEIT Allow NULL? 
22AEZEITTime of Changenvarchar60TIMS(N'000000')YesAEZEIT Allow NULL? 
23KZORGOriginating Defectchar10CHAR(N' ')YesKZORG Allow NULL? 
24WDFEHRepetitive Defectchar10CHAR(N' ')YesWDFEH Allow NULL? 
25FEQKLASDefect Classnvarchar20CHAR(N' ')YesTQ17QFEHLKLAS Allow NULL? 
26FCOAUFNROrder Number (CO Order) for Itemnvarchar120CHAR(N' ')YesAUFKQCOAUFNR Allow NULL? 
27FMGFRDDefective Quantity for Item (External)decimal133QUAN((0))YesQMGFRD
28FMGEIGDefective Quantity for Item (Internal)decimal133QUAN((0))YesQMGEIG
29FMGEINUnit of Measure for Itemnvarchar30UNIT(N' ')YesT006QMGEIN Allow NULL? 
30ANZFEHLERNumber of Defects Foundint100INT4((0))YesQANZFEHL4 Allow NULL? 
31FEHLBEWDefect Valuationfloat1516FLTP((0))YesQFEHLBEW
32UNITFLBEWUnit for Defect Valuationnvarchar30UNIT(N' ')YesT006QUNITFLBEW Allow NULL? 
33FEARTReport Type for Defects Recordingnvarchar80CHAR(N' ')YesTQ86QFEART Allow NULL? 
34PNLKNCurrent Node Number from Order Counter APLZLnvarchar80NUMC(N'00000000')YesQLFNKN Allow NULL? 
35MERKNRInspection Characteristic Numbernvarchar40NUMC(N'0000')YesQMERKNRP Allow NULL? 
36PROBENRSample Numbernvarchar60NUMC(N'000000')YesQASVQPROBENR Allow NULL? 
37PHYNRPhysical Sample Numbernvarchar120CHAR(N' ')YesQPRSQPHYSPRNR Allow NULL? 
38PRUEFLINRSingle-Unit Number for the Unit to Be Inspectednvarchar180CHAR(N' ')YesQPRUEFLINR Allow NULL? 
39CROBJTYObject types of the CIM resourcenvarchar20CHAR(N' ')YesCR_OBJTY Allow NULL? 
40ARBPLObject ID of the Work Centernvarchar80NUMC(N'00000000')YesCRIDLGWID Allow NULL? 
41ARBPLWERKPlant for Work Centernvarchar40CHAR(N' ')YesT001WQARBPWERKS Allow NULL? 
42FENUMORGNumber of Original Item to Which Reference Is Madenvarchar40NUMC(N'0000')YesQFENUMORG Allow NULL? 
43KZSYSFESystematic Defectchar10CHAR(N' ')YesQKZSYSFE Allow NULL? 
44KZLOESCHDelete Data Recordchar10CHAR(N' ')YesKZLOESCH Allow NULL? 
45POSNRSort Number for Itemnvarchar40NUMC(N'0000')YesQLFDPOS Allow NULL? 
46HERPOSOrigin of Item Recordchar10CHAR(N' ')YesQMFEHERK Allow NULL? 
47AUTKZData Record Created with Function 'Create with Copy Model'char10CHAR(N' ')YesQAUTKZ Allow NULL? 
48MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
49WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
50EKORGPurchasing Organizationnvarchar40CHAR(N' ')YesT024EEKORG Allow NULL? 
51INFNRNumber of Purchasing Info Recordnvarchar100CHAR(N' ')YesEINAINFNR Allow NULL? 
52KOSTLCost Centernvarchar100CHAR(N' ')YesCSKSKOSTL Allow NULL? 
53LSTARActivity Typenvarchar60CHAR(N' ')YesCSLALSTAR Allow NULL? 
54PRZNRBusiness Processnvarchar120CHAR(N' ')YesCBPRCO_PRZNR Allow NULL? 
55MENGEDefective Quantity for Item (Internal)decimal133QUAN((0))YesQMGPOS
56EQUNREquipment Numbernvarchar180CHAR(N' ')Yes*EQUNR Allow NULL? 
57TPLNRFunctional Locationnvarchar300CHAR(N' ')Yes*TPLNR Allow NULL? 
NamePrimaryUniqueTypeColumns
QMFE~0YesYesCLUSTEREDFENUM, QMNUM, MANDT
QMFE~1NoNoNONCLUSTEREDFEKAT, FECOD, FEGRP, MANDT
QMFE~2NoNoNONCLUSTEREDOTEIL, OTGRP, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy