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
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
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
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 TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2QMARTNotification Typenvarchar20 Allow NULL? 
3QMTYPNotification Categorynvarchar20 Allow NULL? 
4RBNRCatalog Profilenvarchar90 Allow NULL? 
5HERKZOrigin of Notificationnvarchar20 Allow NULL? 
6BEZZTPM Notification Reference Date/Timechar10 Allow NULL? 
7QMNUKNumber Range for Notificationsnvarchar20 Allow NULL? 
8AUARTOrder Typenvarchar40 Allow NULL? 
9HSCRTPSubscreen Type - Headernvarchar40 Allow NULL? 
10OSCRTPSubscreen Type - Objectnvarchar40 Allow NULL? 
11PSCRTPSubscreen Type - Partnernvarchar40 Allow NULL? 
12PARGRPartner Determination Procedurenvarchar40 Allow NULL? 
13STSMAStatus Profilenvarchar80 Allow NULL? 
14SMSTSMAStatus Profilenvarchar80 Allow NULL? 
15ARTPRPriority Typenvarchar20 Allow NULL? 
16SDAUARTSales Document Typenvarchar40 Allow NULL? 
17COAUARTOrder Typenvarchar40 Allow NULL? 
18PARVW_KUNDPartner Function for Customernvarchar20 Allow NULL? 
19PARVW_APPartner Function for Contact Personnvarchar20 Allow NULL? 
20PARVW_INTPartner Function for Implementation (Department)nvarchar20 Allow NULL? 
21PARVW_LIEFPartner Function for Vendornvarchar20 Allow NULL? 
22PARVW_HERPartner Function for Manufacturernvarchar20 Allow NULL? 
23PARVW_VERAPartner Function: Person/Department Responsiblenvarchar20 Allow NULL? 
24PARVW_AUTOPartner Function for Author of Notificationnvarchar20 Allow NULL? 
25PARVW_QMSMFunction of Person Responsible for Tasknvarchar20 Allow NULL? 
26KLAKTIndicator Classification Activechar10 Allow NULL? 
27INFO_WINDParameter ID Object Infonvarchar100 Allow NULL? 
28SERWIService Profilenvarchar100 Allow NULL? 
29ESCALResponse Profilenvarchar100 Allow NULL? 
30FEKATCatalog Type - Problems/Defectschar10 Allow NULL? 
31URKATCatalog Type - Causeschar10 Allow NULL? 
32MAKATCatalog Type - Taskschar10 Allow NULL? 
33MFKATCatalog Type - Activitieschar10 Allow NULL? 
34OTKATCatalog Type - Object Partschar10 Allow NULL? 
35SAKATCatalog Type - Codingchar10 Allow NULL? 
36STAFOUpdate group for statistics updatenvarchar60 Allow NULL? 
37QMWAERSUnit of Estimated Nonconformity Costsnvarchar50 Allow NULL? 
38QMWERTValuation of Average Noncomformity Costsdecimal112
39FBS_CREATEFunction Module "Create Notification"nvarchar300 Allow NULL? 
40FBS_DYNNRNumber of Initial Screennvarchar40 Allow NULL? 
41TDFORMATFormat Column for Long Text Lines on Notification Screennvarchar20 Allow NULL? 
42KZEILEFormatting Applies to Each Single Long Text Linechar10 Allow NULL? 
43USERSCR1Subscreen Number for Customer Screen Area "Notif. Header"nvarchar40 Allow NULL? 
44USERSCR2Subscreen Number for Customer Screen Area Notification Itemnvarchar40 Allow NULL? 
45USERSCR3Subscreen Number for Customer Screen Area 'Cause'nvarchar40 Allow NULL? 
46USERSCR4Screen Area Number for Customer Screen Area "Task"nvarchar40 Allow NULL? 
47USERSCR5Screen Area Number for Customer Screen Area "Activity"nvarchar40 Allow NULL? 
48QMLTXT01Log Line for Long Text Changechar10 Allow NULL? 
49QMLTXT02No Changes to Existing Long Textchar10 Allow NULL? 
50AUART2Order Typenvarchar40 Allow NULL? 
51EARLY_NUMEarly Number Assignmentchar10 Allow NULL? 
52AUTOM_CONTAutomatic Contract Determinationchar10 Allow NULL? 
53MATKZSearch for Notifications for Materialchar10 Allow NULL? 
54KUKZSearch for Notifications for Customerchar10 Allow NULL? 
55MATKUKZSearch for Notifications for Material/Customerchar10 Allow NULL? 
56LIKZSearch for Vendor Notificationschar10 Allow NULL? 
57MATLIKZSearch for Notifications for Material/Vendorchar10 Allow NULL? 
58MATCHKZSearch for Notifications for Material and Batchchar10 Allow NULL? 
59MATCHKUKZSearch for Notifications for Material/Batch and Customerchar10 Allow NULL? 
60MATCHLIKZSearch for Notifications for Material/Batch and Vendorchar10 Allow NULL? 
61FEGRPKZSearch for Notifications for "Defect Type" Code Groupchar10 Allow NULL? 
62FECODKZSearch for Notifications for "Defect Type" Codechar10 Allow NULL? 
63FOGRPKZSearch for Notifications for "Defect Location" Code Groupchar10 Allow NULL? 
64FOCODKZSearch for Notifications for "Defect Location" Codechar10 Allow NULL? 
65MODDisplay Mode for Notificationschar10 Allow NULL? 
66ICON1No Outstanding Notificationsnvarchar300 Allow NULL? 
67ICON2Outstanding Notificationsnvarchar300 Allow NULL? 
68VERSVariants for Determining Existence of Notificationschar10 Allow NULL? 
69ZEITRAUMNumber of Daysnvarchar40 Allow NULL? 
70TDOBJECTTexts: Application Objectnvarchar100 Allow NULL? 
71TDNAMENamenvarchar700 Allow NULL? 
72TDIDText IDnvarchar40 Allow NULL? 
73CMCHECK_SMCredit Limit Check for CS Processingchar10 Allow NULL? 
74CMGRACredit group sales ordernvarchar20 Allow NULL? 
75PARVW_PAGEPartner Function for Pagingnvarchar20 Allow NULL? 
76CUA_FBSFunction Module that Sets CUA Menunvarchar300 Allow NULL? 
77ROLE_VERAStandard Role for Partner Determination: Notif. Processornvarchar120 Allow NULL? 
78PERMITNotification Type with Approval Procedurechar10 Allow NULL? 
79PARVW_GEHPartner Function for Approver (Person/Department)nvarchar20 Allow NULL? 
80ROLE_GEHStandard Role for Partner Determination: Approvernvarchar120 Allow NULL? 
81ROLE_QMSMStandard Role for Partner Determination: Task Processornvarchar120 Allow NULL? 
82PROCESSQM Processnvarchar30 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