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_TM_STEP461pathways Step of Patient PathwayClinical System
SQL:  selectupdate insert create

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

SELECT MANDT, SCHEDULE_ID, STEP_ID, EINRI, FALNR, GROUP_ID, GROUP_NAME, SEQUENCE_NUMBER, ITEM_ID, STEP_STATE, STEP_NOTE_ID, ANSWER_TEXT, DURATION, ROLE_ID, ROLE_TXT, REASON_ID, ITEMTYPE, TM_NAME, PATH_RELEVANT, ACTION_TYPE, BASE_ITEM_ID, ACTION_EXECUTED, HAS_CORRESP_STEP, HAS_DEPEND_STEP, PLAN_DATE, PLAN_TIME, NEW_PLAN_DATE, NEW_PLAN_TIME, DONE_PLAN_DATE, DONE_PLAN_TIME, DONE_DATE, DONE_TIME, DONE_STATE, EMR, UNPLANNED_STEP, URL_ID, INSDATE, INSUSER, UPDDATE, UPDUSER, DELDATE, DELUSER, DELFLAG, LAST_CHANGE, ACTION_BEHAVIOR, DIFF_PLAN_DONE FROM N2GL_TM_STEP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2SCHEDULE_IDPatient Pathway Keynvarchar320CHAR(N' ')NoN2GL_TM_ID Allow NULL? 
3STEP_IDStep Keynvarchar320CHAR(N' ')NoN2GL_STEP_ID Allow NULL? 
4EINRIInstitutionnvarchar40CHAR(N' ')Yes*EINRI Allow NULL? 
5FALNRIS-H: Case Numbernvarchar100CHAR(N' ')Yes*FALNR Allow NULL? 
6GROUP_IDGroup IDnvarchar320CHAR(N' ')YesN2GL_GROUP_ID Allow NULL? 
7GROUP_NAMEName of Groupnvarchar800CHAR(N' ')YesN2GL_TITLE_GROUP Allow NULL? 
8SEQUENCE_NUMBERSequence Numberint100INT4((0))YesN2GL_SEQUENCE_NUMBER Allow NULL? 
9ITEM_IDItem IDnvarchar320CHAR(N' ')YesN2GL_ITEM_ID Allow NULL? 
10STEP_STATEStatus of Stepnvarchar20CHAR(N' ')YesN2GL_STEP_STATE Allow NULL? 
11STEP_NOTE_IDPD: PD Keynvarchar200CHAR(N' ')YesN2VDNOTEN2VD_KEY Allow NULL? 
12ANSWER_TEXTResponse Textnvarchar2000CHAR(N' ')YesN2GL_ANSWER_TEXT Allow NULL? 
13DURATIONDurationint100INT4((0))YesN2GL_DURATION Allow NULL? 
14ROLE_IDpathways Responsibility IDnvarchar40CHAR(N' ')Yes*N2GL_ROLE_ID Allow NULL? 
15ROLE_TXTResponsibilitynvarchar300CHAR(N' ')YesN2GL_ROLE_TXT Allow NULL? 
16REASON_IDReason for Rescheduling ID (Obsolete)nvarchar30CHAR(N' ')YesN2GL_NEWPLAN_REASON Allow NULL? 
17ITEMTYPEItem Typenvarchar20CHAR(N' ')YesN2GL_ITEMTYPE Allow NULL? 
18TM_NAMEName of a Step in Patient Pathwaynvarchar800CHAR(N' ')YesN2GL_STEP_NAME Allow NULL? 
19PATH_RELEVANTPathway Relevancechar10CHAR(N' ')YesN2GL_PATHRELEVANT Allow NULL? 
20ACTION_TYPEAction Typenvarchar100CHAR(N' ')YesN2GL_ACTION_TYPE Allow NULL? 
21BASE_ITEM_IDBase Items: Base Item Internal Keynvarchar320CHAR(N' ')YesN2GL_BASEITEM_ID Allow NULL? 
22ACTION_EXECUTEDAction Was Executedchar10CHAR(N' ')YesN2GL_ACTION_EXECUTED Allow NULL? 
23HAS_CORRESP_STEPStep Has Connected Stepchar10CHAR(N' ')YesN2GL_HAS_CORRESP Allow NULL? 
24HAS_DEPEND_STEPStep Is Dependent on Stepchar10CHAR(N' ')YesN2GL_HAS_DEPENDENT Allow NULL? 
25PLAN_DATEStep Planned Date (Original Planning)nvarchar80DATS(N'00000000')YesN2GL_PLAN_DATE Allow NULL? 
26PLAN_TIMEStep Planned Time (Original Planning)nvarchar60TIMS(N'000000')YesN2GL_PLAN_TIME Allow NULL? 
27NEW_PLAN_DATEStep Planned Date: Current Calculationnvarchar80DATS(N'00000000')YesN2GL_NEW_PLAN_DATE Allow NULL? 
28NEW_PLAN_TIMEStep Planned Time: Current Calculationnvarchar60TIMS(N'000000')YesN2GL_NEW_PLAN_TIME Allow NULL? 
29DONE_PLAN_DATEPlanned Step Date on Processingnvarchar80DATS(N'00000000')YesN2GL_DONE_PLAN_DATE Allow NULL? 
30DONE_PLAN_TIMEPlanned Step Time on Processingnvarchar60TIMS(N'000000')YesN2GL_DONE_PLAN_TIME Allow NULL? 
31DONE_DATEStep Processing Datenvarchar80DATS(N'00000000')YesN2GL_DONE_DATE Allow NULL? 
32DONE_TIMEStep Processing Timenvarchar60TIMS(N'000000')YesN2GL_DONE_TIME Allow NULL? 
33DONE_STATECompletion Status of Stepnvarchar20CHAR(N' ')YesN2GL_DONE_STATE Allow NULL? 
34EMREmployee Responsiblenvarchar100CHAR(N' ')Yes*N2GL_VMA Allow NULL? 
35UNPLANNED_STEPPlan Time of Step not yet Determinedchar10CHAR(N' ')YesN2GL_STEP_UNPLANNED Allow NULL? 
36URL_IDID of URLnvarchar320CHAR(N' ')YesN2GL_URL_ID 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? 
44LAST_CHANGETime Stamp of Last Changedecimal217DEC((0))YesN2GL_LAST_CHANGE
45ACTION_BEHAVIORAction Behavior When Confirming a Stepnvarchar20CHAR(N' ')NoN2GL_ACTION_BEHAVIOR Allow NULL? 
46DIFF_PLAN_DONEpathways Difference Completion Date/Original Date Plannedint100INT4((0))NoN2GL_DIFFERENCE_PLAN_DONE Allow NULL? 
NamePrimaryUniqueTypeColumns
N2GL_TM_STEP~0YesYesCLUSTEREDSTEP_ID, SCHEDULE_ID, MANDT