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

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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Clinical System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0N2OZ911IS-H*MED: Surgery TimesClinical System
SQL:  selectupdate insert create

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

SELECT MANDT, EINRI, ANKERLEIST, ZEITP, DATUM_E, DATUM_A, ABRUF, D_ABRUF, EINSCHL, BEGANVORB, D_BEGANVOR, BEGANPRAES, D_BEGANPRA, BEGEINL, D_BEGEINL, INTUB, D_INTUB, BEGNARK, D_BEGNARK, ENDEINL, D_ENDEINL, SAALEINTR, D_SAALEINT, BEGOPVORB, D_BEGOPVOR, EINTROP, D_EINTROP, ENDOPVORB, D_ENDOPVOR, OPBEREIT, D_OPBEREIT, SCHNITT, D_SCHNITT, NAHT, D_NAHT, BEGAUSL, D_BEGAUSL, EXTUB, D_EXTUB, ENDNARK, D_ENDNARK, ENDAUSL, D_ENDAUSL, BEGOPNACHB, D_BEGOPNAC, ENDOPNACHB, D_ENDOPNAC, BEGANNACHB, D_BEGANNAC, ENDANNACHB, D_ENDANNAC, OPMASSENDE, SAALAUSTR, D_SAALAUST, ENDANPRAES, D_ENDANPRA, EINTRAWR, D_EINTRAWR, AUSTRAWR, D_AUSTRAWR, AUSSCHL, XZ001, XZ002, XZ003, XZ004, XZ005, XZ006, XZ007, XZ008, XZ009, XZ010, ERUSR, ERDAT, UPUSR, UPDAT, LOUSR, LODAT, OPDAUER, ANDAUER, ANPRAESENZ, EINLDAUER, ANVORB, OPVORB, OPBEREITD, AUSLDAUER, ANNACHB, OPNACHB, AWR, TAGESW, CDOKFREIG, OPFREIGABE FROM N2OZ
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2EINRIInstitutionnvarchar40CHAR(N' ')NoTN01EINRI Allow NULL? 
3ANKERLEISTIS-H: Service Sequence Numbernvarchar100CHAR(N' ')NoLNRLS Allow NULL? 
4ZEITPIdent. of Documentation Elementnvarchar100CHAR(N' ')No*N2_DEID Allow NULL? 
5DATUM_EPass-In to OR Datenvarchar80DATS(N'00000000')YesN2_DATUM_E Allow NULL? 
6DATUM_APass-Out from OR Datenvarchar80DATS(N'00000000')YesN2_DATUM_A Allow NULL? 
7ABRUFCall Timenvarchar60TIMS(N'000000')YesN2_ABRUF Allow NULL? 
8D_ABRUFApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
9EINSCHLInward Transfernvarchar60TIMS(N'000000')YesN2_EINSCHL Allow NULL? 
10BEGANVORBStart of Anesthetist Preparationnvarchar60TIMS(N'000000')YesN2_BANVORB Allow NULL? 
11D_BEGANVORApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
12BEGANPRAESStart of Anesthetist Presencenvarchar60TIMS(N'000000')YesN2_BANP Allow NULL? 
13D_BEGANPRAApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
14BEGEINLStart Inductionnvarchar60TIMS(N'000000')YesN2_BEINL Allow NULL? 
15D_BEGEINLApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
16INTUBIntubationnvarchar60TIMS(N'000000')YesN2_INTUB Allow NULL? 
17D_INTUBApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
18BEGNARKStart Narcosisnvarchar60TIMS(N'000000')YesN2_BNARK Allow NULL? 
19D_BEGNARKApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
20ENDEINLSurgery Releasenvarchar60TIMS(N'000000')YesN2_EEINL Allow NULL? 
21D_ENDEINLApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
22SAALEINTRArrival in Operating Roomnvarchar60TIMS(N'000000')YesN2_SAALE Allow NULL? 
23D_SAALEINTApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
24BEGOPVORBStart of Surgery Preparationnvarchar60TIMS(N'000000')YesN2_BOPV Allow NULL? 
25D_BEGOPVORApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
26EINTROPArrival of Surgeonnvarchar60TIMS(N'000000')YesN2_EOP Allow NULL? 
27D_EINTROPApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
28ENDOPVORBEnd of Surgery Preppingnvarchar60TIMS(N'000000')YesN2_EOPV Allow NULL? 
29D_ENDOPVORApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
30OPBEREITPatient Prepped for Surgerynvarchar60TIMS(N'000000')YesN2_OPBER Allow NULL? 
31D_OPBEREITApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
32SCHNITTIncisionnvarchar60TIMS(N'000000')YesN2_SCHNITT Allow NULL? 
33D_SCHNITTApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
34NAHTSuturenvarchar60TIMS(N'000000')YesN2_NAHT Allow NULL? 
35D_NAHTApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
36BEGAUSLStart Reversalnvarchar60TIMS(N'000000')YesN2_BAUSL Allow NULL? 
37D_BEGAUSLApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
38EXTUBExtubationnvarchar60TIMS(N'000000')YesN2_EXTUB Allow NULL? 
39D_EXTUBApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
40ENDNARKEnd of Narcosisnvarchar60TIMS(N'000000')YesN2_ENARK Allow NULL? 
41D_ENDNARKApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
42ENDAUSLEnd of Reversalnvarchar60TIMS(N'000000')YesN2_EAUSL Allow NULL? 
43D_ENDAUSLApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
44BEGOPNACHBStart of Surgery Clean-Upnvarchar60TIMS(N'000000')YesN2_BOPN Allow NULL? 
45D_BEGOPNACApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
46ENDOPNACHBEnd of Surgery Cleanupnvarchar60TIMS(N'000000')YesN2_EOPN Allow NULL? 
47D_ENDOPNACApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
48BEGANNACHBStart Anesthesia Clean-Upnvarchar60TIMS(N'000000')YesN2_BANN Allow NULL? 
49D_BEGANNACApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
50ENDANNACHBEnd of Anesthesia Cleanupnvarchar60TIMS(N'000000')YesN2_EANN Allow NULL? 
51D_ENDANNACApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
52OPMASSENDEEnd of Surgical Proceduresnvarchar60TIMS(N'000000')YesN2_OPMAEND Allow NULL? 
53SAALAUSTROperating Room Exitnvarchar60TIMS(N'000000')YesN2_SAALA Allow NULL? 
54D_SAALAUSTApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
55ENDANPRAESEnd of Anesthetist Presencenvarchar60TIMS(N'000000')YesN2_EANP Allow NULL? 
56D_ENDANPRAApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
57EINTRAWREnter Recovery Roomnvarchar60TIMS(N'000000')YesN2_EAWR Allow NULL? 
58D_EINTRAWRApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
59AUSTRAWRExit Recovery Roomnvarchar60TIMS(N'000000')YesN2_AAWR Allow NULL? 
60D_AUSTRAWRApplication Storage Datenvarchar80DATS(N'00000000')YesN2_DATE Allow NULL? 
61AUSSCHLTransfer Outnvarchar60TIMS(N'000000')YesN2_AUSSCHL Allow NULL? 
62XZ001OR Documentation: Surgery Timenvarchar60TIMS(N'000000')YesN2_ZEITPKT Allow NULL? 
63XZ002OR Documentation: Surgery Timenvarchar60TIMS(N'000000')YesN2_ZEITPKT Allow NULL? 
64XZ003OR Documentation: Surgery Timenvarchar60TIMS(N'000000')YesN2_ZEITPKT Allow NULL? 
65XZ004OR Documentation: Surgery Timenvarchar60TIMS(N'000000')YesN2_ZEITPKT Allow NULL? 
66XZ005OR Documentation: Surgery Timenvarchar60TIMS(N'000000')YesN2_ZEITPKT Allow NULL? 
67XZ006OR Documentation: Surgery Timenvarchar60TIMS(N'000000')YesN2_ZEITPKT Allow NULL? 
68XZ007OR Documentation: Surgery Timenvarchar60TIMS(N'000000')YesN2_ZEITPKT Allow NULL? 
69XZ008OR Documentation: Surgery Timenvarchar60TIMS(N'000000')YesN2_ZEITPKT Allow NULL? 
70XZ009OR Documentation: Surgery Timenvarchar60TIMS(N'000000')YesN2_ZEITPKT Allow NULL? 
71XZ010OR Documentation: Surgery Timenvarchar60TIMS(N'000000')YesN2_ZEITPKT Allow NULL? 
72ERUSRIS-H: Name of Employee who Created Recordnvarchar120CHAR(N' ')YesRI_ERNAM Allow NULL? 
73ERDATIS-H: Date when Record Creatednvarchar80DATS(N'00000000')YesRI_ERDAT Allow NULL? 
74UPUSRIS-H: Name of Person who Last Changed Datanvarchar120CHAR(N' ')YesRI_UPNAM Allow NULL? 
75UPDATIS-H: Date of Last Changenvarchar80DATS(N'00000000')YesRI_UPDAT Allow NULL? 
76LOUSRUser Who Deleted Recordnvarchar120CHAR(N' ')YesRI_LOUSR Allow NULL? 
77LODATDate of Deletionnvarchar80DATS(N'00000000')YesRI_LODAT Allow NULL? 
78OPDAUERSurgery Durationnvarchar40NUMC(N'0000')YesN2_OPDAUER Allow NULL? 
79ANDAUERAnesthesia Lengthnvarchar40NUMC(N'0000')YesN2_ANDAUER Allow NULL? 
80ANPRAESENZAnesthetist Presentnvarchar40NUMC(N'0000')YesN2_ANPRAES Allow NULL? 
81EINLDAUERDuration of Inductionnvarchar40NUMC(N'0000')YesN2_EINLDAU Allow NULL? 
82ANVORBAnesthesia Preparationnvarchar40NUMC(N'0000')YesN2_ANVORB Allow NULL? 
83OPVORBSurg. Preparationnvarchar40NUMC(N'0000')YesN2_OPVORB Allow NULL? 
84OPBEREITDDuration until Prepped for Surgerynvarchar40NUMC(N'0000')YesN2_OPBEREI Allow NULL? 
85AUSLDAUERDuration of Anesthetic Reversalnvarchar40NUMC(N'0000')YesN2_AUSLDAU Allow NULL? 
86ANNACHBAnesthesia: Clean-upnvarchar40NUMC(N'0000')YesN2_ANNACHB Allow NULL? 
87OPNACHBSurgery Cleanupnvarchar40NUMC(N'0000')YesN2_OPNACB Allow NULL? 
88AWRRecovery Room Length of Staynvarchar40NUMC(N'0000')YesN2_AWR Allow NULL? 
89TAGESWDaily Changeoverchar10CHAR(N' ')YesN2_TAGESW Allow NULL? 
90CDOKFREIGReserve field XFELDchar10CHAR(N' ')YesN2_XFELD Allow NULL? 
91OPFREIGABEReserve field XFELDchar10CHAR(N' ')YesN2_XFELD Allow NULL? 
NamePrimaryUniqueTypeColumns
N2OZ~0YesYesCLUSTEREDANKERLEIST, EINRI, MANDT