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  | DNOD_NOTIF_S
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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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
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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Cross-Application Components :: Messages
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DNOD_NOTIF_S503Notification: SAP Support DataMessages
SQL:  selectupdate insert create

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

SELECT CLIENT, GUIDS, GUIDH, DELETED, INSTN, MNUMM, MSTAT, COMP, OSSYS, DBSYS, FRONT, SWCOMP, SWREL, SWPTCH, ADD_SWCOMP, SYSTYPE, SYSID, MANDT, SAP_TSTMP, S2SAP_TSTMP, REL_SAP_TSTMP, SOLNUMB, BUSPROCOBJ1, BUSPROCOBJ2, BUSPROCOBJ3, BUSPROCOBJ4, BUSPROCOBJ5, SWCOMPONENT1, SWCOMPONENT2, SWCOMPONENT3, SWCOMPONENT4, SWCOMPONENT5, PROJECTNUMB, ROLLOUTPHASE, SESSINO_SRC, SESSITYPE_SRC, SESSINO_TRG, SESSITYPE_TRG, S2SAP_FIRST, S2SAP_LAST, SFRSAP_FIRST, SFRSAP_LAST, TIME_AT_SDESK, TIME_AT_SAP, STEP1, STEP2, STEP3, STEP4, STEP5, SYSNO FROM DNOD_NOTIF_S
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2GUIDSGUID SAP Supportvarbinary160RAWNoDNOT_GUIDS
3GUIDHGUID Notificationvarbinary160RAWYesDNOT_GUIDH
4DELETEDDeletion Indicator Support (Assignment)char10CHAR(N' ')YesDNOT_DELE_S Allow NULL? 
5INSTNSAP Installation Numbernvarchar100CHAR(N' ')YesDNOT_INSTN Allow NULL? 
6MNUMMNotification Number SAPnvarchar240NUMC(N'000000000000000000000000')YesDNOT_MNUMM Allow NULL? 
7MSTATNotification Status at SAPchar10CHAR(N' ')YesDNOT_MSTAT Allow NULL? 
8COMPSAP componentnvarchar200CHAR(N' ')YesDNOT_COMP Allow NULL? 
9OSSYSOperating system and versionnvarchar300CHAR(N' ')YesDNOT_OSSYS Allow NULL? 
10DBSYSDatabase System with Versionnvarchar300CHAR(N' ')YesDNOT_DBSYS Allow NULL? 
11FRONTFrontend System and Versionnvarchar300CHAR(N' ')YesDNOT_FRONT Allow NULL? 
12SWCOMPSoftware componentnvarchar300CHAR(N' ')Yes*DNOT_SWCOMP Allow NULL? 
13SWRELReleasenvarchar100CHAR(N' ')YesDNOT_SWREL Allow NULL? 
14SWPTCHSupport Package Level of Software Componentnvarchar100CHAR(N' ')YesDNOT_SWPTCH Allow NULL? 
15ADD_SWCOMPIndicator for Other Software Componentschar10CHAR(N' ')YesDNOT_ADD_SWCOMP Allow NULL? 
16SYSTYPESAP System Typechar10CHAR(N' ')YesDNOT_SYSTYPE Allow NULL? 
17SYSIDSAP System, Name of SAP Systemnvarchar80CHAR(N' ')YesDNOT_SYSID Allow NULL? 
18MANDTSAP Clientnvarchar30CLNT(N'000')Yes*DNOT_MANDT Allow NULL? 
19SAP_TSTMPSAP Time of Change Stampdecimal150DEC((0))YesDNOT_SAP_TSTMP
20S2SAP_TSTMPSend to SAP: Time Stampdecimal150DEC((0))YesDNOT_S2SAP_TSTMP
21REL_SAP_TSTMPSAP Completion Time Stampdecimal150DEC((0))YesDNOT_REL_SAP_TSTMP
22SOLNUMBSolution Numbernvarchar150NUMC(N'000000000000000')YesDNOT_SOLNUMB Allow NULL? 
23BUSPROCOBJ1Business Process Object 1nvarchar100NUMC(N'0000000000')YesDNOT_BUSPROCOBJ1 Allow NULL? 
24BUSPROCOBJ2Business Process Object 2nvarchar100NUMC(N'0000000000')YesDNOT_BUSPROCOBJ2 Allow NULL? 
25BUSPROCOBJ3Business Process Object 3nvarchar100NUMC(N'0000000000')YesDNOT_BUSPROCOBJ3 Allow NULL? 
26BUSPROCOBJ4Business Process Object 4nvarchar100NUMC(N'0000000000')YesDNOT_BUSPROCOBJ4 Allow NULL? 
27BUSPROCOBJ5Business Process Object 5nvarchar100NUMC(N'0000000000')YesDNOT_BUSPROCOBJ5 Allow NULL? 
28SWCOMPONENT1Software Component 1nvarchar100NUMC(N'0000000000')YesDNOT_SWCOMPONENT1 Allow NULL? 
29SWCOMPONENT2Software Component 2nvarchar100NUMC(N'0000000000')YesDNOT_SWCOMPONENT2 Allow NULL? 
30SWCOMPONENT3Software Component 3nvarchar100NUMC(N'0000000000')YesDNOT_SWCOMPONENT3 Allow NULL? 
31SWCOMPONENT4Software Component 4nvarchar100NUMC(N'0000000000')YesDNOT_SWCOMPONENT4 Allow NULL? 
32SWCOMPONENT5Software Component 5nvarchar100NUMC(N'0000000000')YesDNOT_SWCOMPONENT5 Allow NULL? 
33PROJECTNUMBProject Numbernvarchar100CHAR(N' ')YesDNOT_PROJECTNO Allow NULL? 
34ROLLOUTPHASERollout Phasenvarchar100NUMC(N'0000000000')YesDNOT_ROLLOUTPH Allow NULL? 
35SESSINO_SRCService Session Source (Session Number)nvarchar130CHAR(N' ')YesDNOT_SESSINO_SRC Allow NULL? 
36SESSITYPE_SRCService Session Type Sourcenvarchar20CHAR(N' ')YesDNOT_SESSITYPE_SRC Allow NULL? 
37SESSINO_TRGService session Target (Session Number)nvarchar130CHAR(N' ')YesDNOT_SESSINO_TRG Allow NULL? 
38SESSITYPE_TRGService Session Type Targetnvarchar20CHAR(N' ')YesDNOT_SESSITYPE_TRG Allow NULL? 
39S2SAP_FIRSTFirst Send to SAP: Time Stampdecimal150DEC((0))YesDNOT_S2SAP_FIRST
40S2SAP_LASTLast Send to SAP: Time Stampdecimal150DEC((0))YesDNOT_S2SAP_LAST
41SFRSAP_FIRSTFirst Reply from SAP: Time Stampdecimal150DEC((0))YesDNOT_SFRSAP_FIRST
42SFRSAP_LASTLast Send to SAP: Time Stampdecimal150DEC((0))YesDNOT_SFRSAP_LAST
43TIME_AT_SDESKDuration of Processing by Support Deskint100INT4((0))YesDNOT_TIME_AT_SDESK Allow NULL? 
44TIME_AT_SAPDuration of Processing at SAPint100INT4((0))YesDNOT_TIME_AT_SAP Allow NULL? 
45STEP1Business Process Step 1nvarchar100NUMC(N'0000000000')YesDNOT_STEP1 Allow NULL? 
46STEP2Business Process Step 2nvarchar100NUMC(N'0000000000')YesDNOT_STEP2 Allow NULL? 
47STEP3Business Process Step 3nvarchar100NUMC(N'0000000000')YesDNOT_STEP3 Allow NULL? 
48STEP4Business Process Step 4nvarchar100NUMC(N'0000000000')YesDNOT_STEP4 Allow NULL? 
49STEP5Business Process Step 5nvarchar100NUMC(N'0000000000')YesDNOT_STEP5 Allow NULL? 
50SYSNOSystem Numbernvarchar180CHAR(N' ')YesDNOT_SYSNO Allow NULL? 
NamePrimaryUniqueTypeColumns
DNOD_NOTIF_S~0YesYesCLUSTEREDGUIDS, CLIENT
DNOD_NOTIF_S~HNoNoNONCLUSTEREDGUIDH, CLIENT
DNOD_NOTIF_S~MNoNoNONCLUSTEREDMNUMM

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