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
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
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

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

39 columns | Print definition?ERP 6.0  | STOID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1N1SE_DOMAINISHMED: Table for Search Domain14STOIDReason for Canceling Medical Objectnvarchar30
2N1SE_INDEXISHMED: Table for Search Indexes21STOIDReason for Canceling Medical Objectnvarchar30
3N1SE_INDEX_ATTRISHMED: Search Index Attributes22STOIDReason for Canceling Medical Objectnvarchar30
TOPClinical System
4N1EDRUGIS-H*MED: Drug Event - Drug Assignment31STOIDReason for Canceling Medical Objectnvarchar30
5N1MEEVENTIS-H*MED: Medication, Medication Event43STOIDReason for Canceling Medical Objectnvarchar30
6N1MEOACTi.s.h.med: Medication, Order Activities11STOIDReason for Canceling Medical Objectnvarchar30
7N1MEORDERIS-H*MED: Medication, Medication Order78STOIDReason for Canceling Medical Objectnvarchar30
8N1MERGOBSOLETE: Medication Event23STOIDReason for Canceling Medical Objectnvarchar30
9N1MEVOOBSOLETE: Prescription of a Medication31STOIDReason for Canceling Medical Objectnvarchar30
10N1ODRUGIS-H*MED: Medication, Drugs of Order42STOIDReason for Canceling Medical Objectnvarchar30
11N1PRBEWIS-H*MED: PATREG: Bewegungen25STOIDIS-H: Islemin iptal nedeninvarchar30
12N1PRLEMIS-H*MED: PATREG: Leistungen34STOIDTibbi nesne iptal nedeninvarchar30
13N1SRVServices: Service Data37STOIDReason for Canceling Medical Objectnvarchar30
14N1SRVPROPNursing Services: Service Properties18STOIDReason for Canceling Medical Objectnvarchar30
15N1SRVTEAMServices: Employee for Service15STOIDReason for Canceling Medical Objectnvarchar30
16N1XSTGIS-H*MED: VBUND: Umsetzung von Stornogründen3STOIDStornogrund des medizinischen Objektsnvarchar30
17N2CLIM_OBSVSVital Signs: Examination30STOIDReason for Canceling Medical Objectnvarchar30
18N2CLIM_PLDVSVital Signs: Definite Planned Measurement (with Time)23STOIDReason for Canceling Medical Objectnvarchar30
19N2CLIM_SDLVSVital Signs: Measurement Plan for Patient (Cycles)23STOIDReason for Canceling Medical Objectnvarchar30
20N2CLIM_VALVSVital Signs: Measured Values36STOIDReason for Canceling Medical Objectnvarchar30
21NLEMIS-H*MED: Medical Service5STOIDReason for Canceling Medical Objectnvarchar30
TOPCommunication
22N1STGR_SE_MAPMap Cancellation Reasons3STOIDReason for Canceling Medical Objectnvarchar30
TOPNursing
23N1NRSPENursing Plan: Entry31STOIDReason for Canceling Medical Objectnvarchar30
24N1NRSPEENursing Plan: Entry Evaluation23STOIDReason for Canceling Medical Objectnvarchar30
25N1NRSPEPNursing Plan: Suspension of an Entry20STOIDReason for Canceling Medical Objectnvarchar30
26N1NRSPHPOBSOLETE15STOIDReason for Canceling Medical Objectnvarchar30
27N1NSRVTEAMOBSOLETE - Nursing Services: Employees for Service15STOIDReason for Canceling Medical Objectnvarchar30
TOPPatient Management
28N1CORDERIS-H: Clinical Order45STOIDIS-H: Reason for Cancellationnvarchar30
29N1STGRIS-H: Cancellation Reasons3STOIDReason for Canceling Medical Objectnvarchar30
30N1STGRTISHMED: Text for Cancellation Reason of Service4STOIDReason for Canceling Medical Objectnvarchar30
31N1VKGIS-H: Item of Clinical Order (Preregistration)41STOIDIS-H: Cancellation Reason for Preregistrationnvarchar30
32NAPPIS-H: Provisional Appointments for Visit Scheduling25STOIDIS-H: Reason for Canceling Movementnvarchar30
33NBEWIS-H: Movements for Case58STOIDIS-H: Reason for Canceling Movementnvarchar30
34NLOCIS-H: Time Slot Substitutions for Visit Scheduling12STOIDIS-H: Reason for Canceling Movementnvarchar30
35TNCASREVIS-H: Case Revision - Customizing Settings3STOIDReason for Canceling Medical Objectnvarchar30
TOPPatient Transport Service
36N1FATIS-H*MED: Transport Orders26STOIDCancellation Reason for Patient Transport Servicenvarchar30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
37NLVERKRechnungregister-kopf8STOIDStornoreden medisch objectnvarchar30
38TNLCINV02Sammelrechnung ruckgabe kodes10STOIDStornogrund des medizinischen Objektsnvarchar30
TOPVital Signs
39N1VPVital Sign Movement Data22STOIDVital Sign Cancellation Reasonnvarchar30