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.0N2GL_GUIDELINE462pathways Treatment PathwayClinical System
SQL:  selectupdate insert create

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

SELECT MANDT, GL_VERSION_ID, EINRI, GL_ID, SHORT_CODE, VERSION, TITLE_CLIN, TITLE_PAT, SHORT_DES, STATE, DES_ID_CLIN, DES_ID_PAT, DES_ID_TECH, DES_ID_SVG, URL_ID, STATE_MED_USE, VALID_FROM, VALID_TO, CHECK_DATE, CHECK_OVERDUE, TIMEUNIT, IS_MODULE, IS_PATHWAY, MODEL_TOOL_USED, MODEL_TOOL_VERS, IS_H_RELEASE, IS_H_LEVEL, USER_FIELD, DES_ID_AUTH, RESPONS_PERSON, CONTACT_PERSON, CONTACT_PHONE, CONTACT_EMAIL, KEYWORD_A, KEYWORD_B, GRAPH_CHECKED, INSDATE, INSUSER, UPDDATE, UPDUSER, DELDATE, DELUSER, DELFLAG, PAT_UNIQUE, CATSET_ID, ACTIVE_CHANGED FROM N2GL_GUIDELINE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2GL_VERSION_IDTreatment Pathway IDnvarchar320CHAR(N' ')NoN2GL_GL_ID Allow NULL? 
3EINRIInstitutionnvarchar40CHAR(N' ')YesTN01EINRI Allow NULL? 
4GL_IDTreatment Pathway IDnvarchar320CHAR(N' ')YesN2GL_GL_ID Allow NULL? 
5SHORT_CODEAbbreviation of Treatment Pathwaynvarchar200CHAR(N' ')YesN2GL_SHORT_CODE Allow NULL? 
6VERSIONVersion of Treatment Pathwaynvarchar30NUMC(N'000')YesN2GL_VERSION Allow NULL? 
7TITLE_CLINTitle of Treatment Pathwaynvarchar400CHAR(N' ')YesN2GL_TITLE Allow NULL? 
8TITLE_PATTitle of Pathway in Patient Informationnvarchar400CHAR(N' ')YesN2GL_TITLE_PAT Allow NULL? 
9SHORT_DESDescriptionnvarchar2550CHAR(N' ')YesN2GL_DESCR Allow NULL? 
10STATETechnical Status of Treatment Pathwaynvarchar20CHAR(N' ')YesN2GL_STATE Allow NULL? 
11DES_ID_CLINUUID in character formnvarchar320CHAR(N' ')YesSYSUUID_C Allow NULL? 
12DES_ID_PATUUID in character formnvarchar320CHAR(N' ')YesSYSUUID_C Allow NULL? 
13DES_ID_TECHUUID in character formnvarchar320CHAR(N' ')YesSYSUUID_C Allow NULL? 
14DES_ID_SVGUUID in character formnvarchar320CHAR(N' ')YesSYSUUID_C Allow NULL? 
15URL_IDUUID in character formnvarchar320CHAR(N' ')YesSYSUUID_C Allow NULL? 
16STATE_MED_USEMedical Status of Treatment Pathwaynvarchar20CHAR(N' ')YesN2GL_MED_STATE Allow NULL? 
17VALID_FROMStart of Validity of Treatment Pathwaynvarchar80DATS(N'00000000')YesN2GL_VALID_FROM Allow NULL? 
18VALID_TOEnd of Validity of Treatment Pathwaynvarchar80DATS(N'00000000')YesN2GL_VALID_TO Allow NULL? 
19CHECK_DATECheck Date of Treatment Pathwaynvarchar80DATS(N'00000000')YesN2GL_CHECK_DATE Allow NULL? 
20CHECK_OVERDUEAvailability After Check Datenvarchar40CHAR(N' ')YesN2GL_OVERDUE Allow NULL? 
21TIMEUNITTime Unitnvarchar20CHAR(N' ')YesN2GL_TIMEUNIT Allow NULL? 
22IS_MODULEUse as Modulechar10CHAR(N' ')YesN2GL_MODULE Allow NULL? 
23IS_PATHWAYUse as Treatment Pathwaychar10CHAR(N' ')YesN2GL_GL_USABLE Allow NULL? 
24MODEL_TOOL_USEDEditor for Creating Treatment Pathwaynvarchar40CHAR(N' ')YesN2GL_MODELTOOL Allow NULL? 
25MODEL_TOOL_VERSVersion of Graphical Editornvarchar120CHAR(N' ')YesN2GL_MODELTOOLV Allow NULL? 
26IS_H_RELEASESAP Releasenvarchar100CHAR(N' ')YesSAPRELEASE Allow NULL? 
27IS_H_LEVELSupport Package Level of a Software Componentnvarchar100CHAR(N' ')YesSAPPATCHLV Allow NULL? 
28USER_FIELDCustomer Parameter (Free Usage by Customer)nvarchar320CHAR(N' ')YesN2GL_USER_FIELD Allow NULL? 
29DES_ID_AUTHUUID in character formnvarchar320CHAR(N' ')YesSYSUUID_C Allow NULL? 
30RESPONS_PERSONPerson Responsible for Contentnvarchar400CHAR(N' ')YesN2GL_REPONS_PERSON Allow NULL? 
31CONTACT_PERSONContact Personnvarchar400CHAR(N' ')YesN2GL_CONTACT_PERSON Allow NULL? 
32CONTACT_PHONETelephone Number of Contact Personnvarchar300CHAR(N' ')YesN2GL_CONTACT_PHONE Allow NULL? 
33CONTACT_EMAILE-Mail Address of Contact Partnernvarchar2550CHAR(N' ')YesN2GL_CONTACT_EMAIL Allow NULL? 
34KEYWORD_AKeywordnvarchar400CHAR(N' ')YesTN2GL_KEYWORDN2GL_KEYWORD Allow NULL? 
35KEYWORD_BKeywordnvarchar400CHAR(N' ')YesTN2GL_KEYWORDN2GL_KEYWORD Allow NULL? 
36GRAPH_CHECKEDValidity of Clinical Algorithmchar10CHAR(N' ')YesN2GL_VALID_GRAPH Allow NULL? 
37INSDATECreated Onnvarchar80DATS(N'00000000')YesN2GL_INSDATE Allow NULL? 
38INSUSERUser who Created Data Recordnvarchar120CHAR(N' ')YesN2GL_INSUSER Allow NULL? 
39UPDDATEDate on Which Record Was Last Changednvarchar80DATS(N'00000000')YesN2GL_UPDDATE Allow NULL? 
40UPDUSERUser who Last Changed Recordnvarchar120CHAR(N' ')YesN2GL_UPDUSER Allow NULL? 
41DELDATEDate, on Which Deletion Indicator Was Setnvarchar80DATS(N'00000000')YesN2GL_DELDATE Allow NULL? 
42DELUSERUser Who Set Deletion Indicatornvarchar120CHAR(N' ')YesN2GL_DELUSER Allow NULL? 
43DELFLAGDeletion Indicatorchar10CHAR(N' ')YesN2GL_DELFLAG Allow NULL? 
44PAT_UNIQUEPathways: Unique Indicator for Patientchar10CHAR(N' ')NoN2GL_PATIENT_UNIQUE Allow NULL? 
45CATSET_IDCategories: Category Set Keynvarchar60CHAR(N' ')NoTN2CATSETN2CAT_SET Allow NULL? 
46ACTIVE_CHANGEDTreatment Pathway Was Changed After Activationchar10CHAR(N' ')NoN2GL_ACTIVE_CHANGED Allow NULL? 
NamePrimaryUniqueTypeColumns
N2GL_GUIDELINE~0YesYesCLUSTEREDGL_VERSION_ID, MANDT
N2GL_GUIDELINE~1NoNoNONCLUSTEREDVERSION, SHORT_CODE, MANDT