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  | TQ80
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Plant Maintenance :: Maintenance Processing :: Maintenance Notifications
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TQ80821Notification TypesMaintenance Notifications
SQL:  selectupdate insert create

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

SELECT MANDT, QMART, QMTYP, RBNR, HERKZ, BEZZT, QMNUK, AUART, HSCRTP, OSCRTP, PSCRTP, PARGR, STSMA, SMSTSMA, ARTPR, SDAUART, COAUART, PARVW_KUND, PARVW_AP, PARVW_INT, PARVW_LIEF, PARVW_HER, PARVW_VERA, PARVW_AUTO, PARVW_QMSM, KLAKT, INFO_WIND, SERWI, ESCAL, FEKAT, URKAT, MAKAT, MFKAT, OTKAT, SAKAT, STAFO, QMWAERS, QMWERT, FBS_CREATE, FBS_DYNNR, TDFORMAT, KZEILE, USERSCR1, USERSCR2, USERSCR3, USERSCR4, USERSCR5, QMLTXT01, QMLTXT02, AUART2, EARLY_NUM, AUTOM_CONT, MATKZ, KUKZ, MATKUKZ, LIKZ, MATLIKZ, MATCHKZ, MATCHKUKZ, MATCHLIKZ, FEGRPKZ, FECODKZ, FOGRPKZ, FOCODKZ, MOD, ICON1, ICON2, VERS, ZEITRAUM, TDOBJECT, TDNAME, TDID, CMCHECK_SM, CMGRA, PARVW_PAGE, CUA_FBS, ROLE_VERA, PERMIT, PARVW_GEH, ROLE_GEH, ROLE_QMSM, PROCESS FROM TQ80
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2QMARTNotification Typenvarchar20CHAR(N' ')NoQMART Allow NULL? 
3QMTYPNotification Categorynvarchar20CHAR(N' ')NoTQ8TQMTYP Allow NULL? 
4RBNRCatalog Profilenvarchar90CHAR(N' ')NoT352BRBNR Allow NULL? 
5HERKZOrigin of Notificationnvarchar20CHAR(N' ')NoHERKZ Allow NULL? 
6BEZZTPM Notification Reference Date/Timechar10CHAR(N' ')NoBEZZT Allow NULL? 
7QMNUKNumber Range for Notificationsnvarchar20CHAR(N' ')NoQMNUK Allow NULL? 
8AUARTOrder Typenvarchar40CHAR(N' ')NoT003OAUFART Allow NULL? 
9HSCRTPSubscreen Type - Headernvarchar40CHAR(N' ')NoTQBTHSCRTP Allow NULL? 
10OSCRTPSubscreen Type - Objectnvarchar40CHAR(N' ')NoTQBTOSCRTP Allow NULL? 
11PSCRTPSubscreen Type - Partnernvarchar40CHAR(N' ')NoTQBTPSCRTP Allow NULL? 
12PARGRPartner Determination Procedurenvarchar40CHAR(N' ')NoTVPGPARGR Allow NULL? 
13STSMAStatus Profilenvarchar80CHAR(N' ')NoTJ20J_STSMA Allow NULL? 
14SMSTSMAStatus Profilenvarchar80CHAR(N' ')NoTJ20J_STSMA Allow NULL? 
15ARTPRPriority Typenvarchar20CHAR(N' ')NoT356AARTPR Allow NULL? 
16SDAUARTSales Document Typenvarchar40CHAR(N' ')NoTVAKAUART Allow NULL? 
17COAUARTOrder Typenvarchar40CHAR(N' ')NoT003OAUFART Allow NULL? 
18PARVW_KUNDPartner Function for Customernvarchar20CHAR(N' ')NoTPARPARVW_KUND Allow NULL? 
19PARVW_APPartner Function for Contact Personnvarchar20CHAR(N' ')NoTPARPARVW_AP Allow NULL? 
20PARVW_INTPartner Function for Implementation (Department)nvarchar20CHAR(N' ')NoTPARPARVW_INT Allow NULL? 
21PARVW_LIEFPartner Function for Vendornvarchar20CHAR(N' ')NoTPARPARVW_LIEF Allow NULL? 
22PARVW_HERPartner Function for Manufacturernvarchar20CHAR(N' ')NoTPARPARVW_HER Allow NULL? 
23PARVW_VERAPartner Function: Person/Department Responsiblenvarchar20CHAR(N' ')NoTPARPARVW_VERA Allow NULL? 
24PARVW_AUTOPartner Function for Author of Notificationnvarchar20CHAR(N' ')NoTPARPARVW_AUTO Allow NULL? 
25PARVW_QMSMFunction of Person Responsible for Tasknvarchar20CHAR(N' ')NoTPARQMSM_PARVW Allow NULL? 
26KLAKTIndicator Classification Activechar10CHAR(N' ')NoKLAKT Allow NULL? 
27INFO_WINDParameter ID Object Infonvarchar100CHAR(N' ')NoTQ80OI_INFOWIND Allow NULL? 
28SERWIService Profilenvarchar100CHAR(N' ')NoT355RI_SERWI Allow NULL? 
29ESCALResponse Profilenvarchar100CHAR(N' ')NoT355EI_ESCAL Allow NULL? 
30FEKATCatalog Type - Problems/Defectschar10CHAR(N' ')NoTQ15FEKAT Allow NULL? 
31URKATCatalog Type - Causeschar10CHAR(N' ')NoTQ15URKAT Allow NULL? 
32MAKATCatalog Type - Taskschar10CHAR(N' ')NoTQ15MAKAT Allow NULL? 
33MFKATCatalog Type - Activitieschar10CHAR(N' ')NoTQ15MFKAT Allow NULL? 
34OTKATCatalog Type - Object Partschar10CHAR(N' ')NoTQ15OTKAT Allow NULL? 
35SAKATCatalog Type - Codingchar10CHAR(N' ')NoTQ15SAKAT Allow NULL? 
36STAFOUpdate group for statistics updatenvarchar60CHAR(N' ')NoTMCBSTAFO Allow NULL? 
37QMWAERSUnit of Estimated Nonconformity Costsnvarchar50CUKY(N' ')NoTCURCQMWAERS Allow NULL? 
38QMWERTValuation of Average Noncomformity Costsdecimal112CURR((0))NoQMWERT
39FBS_CREATEFunction Module "Create Notification"nvarchar300CHAR(N' ')NoTFDIRQFBSQM01 Allow NULL? 
40FBS_DYNNRNumber of Initial Screennvarchar40CHAR(N' ')NoQFBSDYNNR Allow NULL? 
41TDFORMATFormat Column for Long Text Lines on Notification Screennvarchar20CHAR(N' ')NoQTDFORMAT Allow NULL? 
42KZEILEFormatting Applies to Each Single Long Text Linechar10CHAR(N' ')NoKZEILE Allow NULL? 
43USERSCR1Subscreen Number for Customer Screen Area "Notif. Header"nvarchar40CHAR(N' ')NoQMUSRSCR Allow NULL? 
44USERSCR2Subscreen Number for Customer Screen Area Notification Itemnvarchar40CHAR(N' ')NoQMUSRSCR1 Allow NULL? 
45USERSCR3Subscreen Number for Customer Screen Area 'Cause'nvarchar40CHAR(N' ')YesQMUSRSCR2 Allow NULL? 
46USERSCR4Screen Area Number for Customer Screen Area "Task"nvarchar40CHAR(N' ')YesQMUSRSCR3 Allow NULL? 
47USERSCR5Screen Area Number for Customer Screen Area "Activity"nvarchar40CHAR(N' ')YesQMUSRSCR4 Allow NULL? 
48QMLTXT01Log Line for Long Text Changechar10CHAR(N' ')NoQMLTXT01 Allow NULL? 
49QMLTXT02No Changes to Existing Long Textchar10CHAR(N' ')NoQMLTXT02 Allow NULL? 
50AUART2Order Typenvarchar40CHAR(N' ')YesT003OAUFART Allow NULL? 
51EARLY_NUMEarly Number Assignmentchar10CHAR(N' ')YesEARLY_NUM Allow NULL? 
52AUTOM_CONTAutomatic Contract Determinationchar10CHAR(N' ')YesAUTOM_CONT Allow NULL? 
53MATKZSearch for Notifications for Materialchar10CHAR(N' ')YesQNMATKZ Allow NULL? 
54KUKZSearch for Notifications for Customerchar10CHAR(N' ')YesQNKUKZ Allow NULL? 
55MATKUKZSearch for Notifications for Material/Customerchar10CHAR(N' ')YesQNMATKUKZ Allow NULL? 
56LIKZSearch for Vendor Notificationschar10CHAR(N' ')YesQNLIKZ Allow NULL? 
57MATLIKZSearch for Notifications for Material/Vendorchar10CHAR(N' ')YesQNMATLIKZ Allow NULL? 
58MATCHKZSearch for Notifications for Material and Batchchar10CHAR(N' ')YesQNMATCHKZ Allow NULL? 
59MATCHKUKZSearch for Notifications for Material/Batch and Customerchar10CHAR(N' ')YesQNMATCHKUKZ Allow NULL? 
60MATCHLIKZSearch for Notifications for Material/Batch and Vendorchar10CHAR(N' ')YesQNMATCHLIKZ Allow NULL? 
61FEGRPKZSearch for Notifications for "Defect Type" Code Groupchar10CHAR(N' ')YesQNFEGRPKZ Allow NULL? 
62FECODKZSearch for Notifications for "Defect Type" Codechar10CHAR(N' ')YesQNFECODKZ Allow NULL? 
63FOGRPKZSearch for Notifications for "Defect Location" Code Groupchar10CHAR(N' ')YesQNFOGRPKZ Allow NULL? 
64FOCODKZSearch for Notifications for "Defect Location" Codechar10CHAR(N' ')YesQNFOCODKZ Allow NULL? 
65MODDisplay Mode for Notificationschar10CHAR(N' ')YesQNMOD Allow NULL? 
66ICON1No Outstanding Notificationsnvarchar300CHAR(N' ')YesQNICON1 Allow NULL? 
67ICON2Outstanding Notificationsnvarchar300CHAR(N' ')YesQNICON2 Allow NULL? 
68VERSVariants for Determining Existence of Notificationschar10CHAR(N' ')YesQNVERS Allow NULL? 
69ZEITRAUMNumber of Daysnvarchar40NUMC(N'0000')YesQNZEIT Allow NULL? 
70TDOBJECTTexts: Application Objectnvarchar100CHAR(N' ')YesTTXOBTDOBJECT Allow NULL? 
71TDNAMENamenvarchar700CHAR(N' ')YesSTXHTDOBNAME Allow NULL? 
72TDIDText IDnvarchar40CHAR(N' ')YesTTXIDTDID Allow NULL? 
73CMCHECK_SMCredit Limit Check for CS Processingchar10CHAR(N' ')YesCMCHECK_SM Allow NULL? 
74CMGRACredit group sales ordernvarchar20CHAR(N' ')YesT691DCMGRA Allow NULL? 
75PARVW_PAGEPartner Function for Pagingnvarchar20CHAR(N' ')YesTPARPARVW_PAGE Allow NULL? 
76CUA_FBSFunction Module that Sets CUA Menunvarchar300CHAR(N' ')YesTFDIRQ_CUA_FBS Allow NULL? 
77ROLE_VERAStandard Role for Partner Determination: Notif. Processornvarchar120CHAR(N' ')YesQSTROLE Allow NULL? 
78PERMITNotification Type with Approval Procedurechar10CHAR(N' ')YesQPERMIT Allow NULL? 
79PARVW_GEHPartner Function for Approver (Person/Department)nvarchar20CHAR(N' ')YesTPARPARVW_GEH Allow NULL? 
80ROLE_GEHStandard Role for Partner Determination: Approvernvarchar120CHAR(N' ')YesQSTROLE2 Allow NULL? 
81ROLE_QMSMStandard Role for Partner Determination: Task Processornvarchar120CHAR(N' ')YesQSTROLE3 Allow NULL? 
82PROCESSQM Processnvarchar30NUMC(N'000')YesTQ80_PRQMPROCESS Allow NULL? 
NamePrimaryUniqueTypeColumns
TQ80~0YesYesCLUSTEREDMANDT, QMART

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