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

183 columns | Print definition?ERP 6.0  | LOUSR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TN1LSTi.s.h.med: Service Facility Categories9LOUSRUser Who Deleted Recordnvarchar120
2TN1MCI_COMPComponent Registration13LOUSRUser Who Deleted Recordnvarchar120
3TN1MCI_PROCCommunication Processes13LOUSRUser Who Deleted Recordnvarchar120
4TN1MCI_PROPProperties of a Processing Step14LOUSRUser Who Deleted Recordnvarchar120
5TN1MCI_STEPProcessing Steps of a Communication Process14LOUSRUser Who Deleted Recordnvarchar120
TOPBasic Data
6NABGIS-H: Employer (Business Partner)6LOUSRUser Who Deleted Recordnvarchar120
7NBAUIS-H: Building Units13LOUSRUser Who Deleted Recordnvarchar120
8NDEBIS-H: Business Partner/IS-H Customer Supplement8LOUSRUser Who Deleted Recordnvarchar120
9NGPAIS-H: Business Partners32LOUSRUser Who Deleted Recordnvarchar120
10NKRHIS-H: Hospitals (Business Partners)6LOUSRUser Who Deleted Recordnvarchar120
11NKTRIS-H: Business Partners/Insurance Providers39LOUSRUser Who Deleted Recordnvarchar120
12NORGIS-H: Organizational Units36LOUSRUser Who Deleted Recordnvarchar120
13NPERIS-H: Persons19LOUSRUser Who Deleted Recordnvarchar120
14NTPTIS-H: Service Catalog Item Description15LOUSRUser Who Deleted Recordnvarchar120
15NTPZIS-H: Service Catalog Line Items: Assignments/Groupings15LOUSRUser Who Deleted Recordnvarchar120
16NTSIIS-H: Service catalog column information14LOUSRUser Who Deleted Recordnvarchar120
17NTSPIS-H: Columns in Service Catalog11LOUSRUser Who Deleted Recordnvarchar120
TOPClinical System
18N1ANFTYPIS-H*MED: Request Type11LOUSRUser Who Deleted Recordnvarchar120
19N1APRIIS-H*MED: Request priorities10LOUSRUser Who Deleted Recordnvarchar120
20N1ASTIS-H*MED: Request status10LOUSRUser Who Deleted Recordnvarchar120
21N1AUFGAIS-H*MED: Task9LOUSRUser Who Deleted Recordnvarchar120
22N1BCEXPCFGBasis Cat.: Export Configuration16LOUSRUser Who Deleted Recordnvarchar120
23N1BCEXPCFGCPLBasis Cat.: Export Configuration Item Assignment9LOUSRUser Who Deleted Recordnvarchar120
24N1BCHBasic Cat.: Catalog Header17LOUSRUser Who Deleted Recordnvarchar120
25N1BCH2OUOBSOLETE15LOUSRUser Who Deleted Recordnvarchar120
26N1BCH2ROLEOBSOLETE14LOUSRUser Who Deleted Recordnvarchar120
27N1BCH2USEROBSOLETE14LOUSRUser Who Deleted Recordnvarchar120
28N1BCHLDBasic Cat.: Catalog Assignment Definition17LOUSRUser Who Deleted Recordnvarchar120
29N1BCIMPCFGBasic Cat.: Import Configuration23LOUSRUser Who Deleted Recordnvarchar120
30N1BCIMPCFGCPLBasic Cat.: Import Configuration Item Assignment11LOUSRUser Who Deleted Recordnvarchar120
31N1BCPBasic Cat.: Catalog Item22LOUSRUser Who Deleted Recordnvarchar120
32N1BCP2BCPBasic Cat.: Catalog Item to Catalog Item Assignment19LOUSRUser Who Deleted Recordnvarchar120
33N1BCP2DIAGBasic Cat.: Catalog Item to Diagnosis Assignment16LOUSRUser Who Deleted Recordnvarchar120
34N1BCP2HIERBasic Cat.: Catalog Item to Hierarchy Assignment16LOUSRUser Who Deleted Recordnvarchar120
35N1BCP2MATBasic Cat.: Catalog Item to Material Assignment16LOUSRUser Who Deleted Recordnvarchar120
36N1BCP2NTPKBasic Cat.: Catalog Item to Service Assignment18LOUSRUser Who Deleted Recordnvarchar120
37N1BCP2RCBasic Cat.: Item - Display Configuration Assignment17LOUSRUser Who Deleted Recordnvarchar120
38N1BCP2TASKBasic Cat.: Catalo Item to Task Assignment15LOUSRUser Who Deleted Recordnvarchar120
39N1BCP2URLBasic Cat.: Catalog Item to URL Assignment17LOUSRUser Who Deleted Recordnvarchar120
40N1BCPLDOBSOLETE17LOUSRUser Who Deleted Recordnvarchar120
41N1BCRCBasic Cat.: Display Configuration13LOUSRUser Who Deleted Recordnvarchar120
42N1BCRC2BCSMCBasic Cat.: Display Config. - Main Catalog Assignment18LOUSRUser Who Deleted Recordnvarchar120
43N1BCRGBasic Cat.: Display Group15LOUSRUser Who Deleted Recordnvarchar120
44N1BCSOBSOLETE: Basic Cat.: Basic Catalog Set18LOUSRUser Who Deleted Recordnvarchar120
45N1BCSEOBSOLETE: Basic Cat.: Basic Catalog Set Entry18LOUSRUser Who Deleted Recordnvarchar120
46N1BCSEPOBSOLETE: Basic Cat.: Basic Catalog Set Entry Property18LOUSRUser Who Deleted Recordnvarchar120
47N1BCSFBasic Catalog Set: Folder14LOUSRUser Who Deleted Recordnvarchar120
48N1BCSGOBSOLETE: Basic Cat.: Basic Catalog Set Group15LOUSRUser Who Deleted Recordnvarchar120
49N1BCSHBasic Catalog Set: Header Data19LOUSRUser Who Deleted Recordnvarchar120
50N1BCSMCBasic Catalog Set: Main Catalog19LOUSRUser Who Deleted Recordnvarchar120
51N1BCSPCBasic Catalog Set: Property Catalog18LOUSRUser Who Deleted Recordnvarchar120
52N1BCSPECBasic Cat.: Range13LOUSRUser Who Deleted Recordnvarchar120
53N1BCSPEC2BCPBasic Cat.: Range to Catalog Item Assignment16LOUSRUser Who Deleted Recordnvarchar120
54N1BCSPEC2EBCPBasic Cat.: Range to Excluded Catalog Item Assignment15LOUSRUser Who Deleted Recordnvarchar120
55N1BCSPEC2OUBasic Cat.: Range to OU Assignment16LOUSRUser Who Deleted Recordnvarchar120
56N1CORDUNITCORD: Units for Clinical Orders13LOUSRUser Who Deleted Recordnvarchar120
57N1CYGROUPi.s.h.med: Group Determination for Cycles10LOUSRUser Who Deleted Recordnvarchar120
58N1DCIS-H*MED: Table of Formularies15LOUSRUser Who Deleted Recordnvarchar120
59N1DFOIS-H*MED: Dispensing Form13LOUSRUser Who Deleted Recordnvarchar120
60N1ELEIISHMED: External service range14LOUSRUser Who Deleted Recordnvarchar120
61N1FOCATREFAi.s.h.med: Medication, ID References for External Catalogs16LOUSRUser Who Deleted Recordnvarchar120
62N1FOFILLSABi.s.h.med: Medication, Fill Source - Drug Assignment20LOUSRUser Who Deleted Recordnvarchar120
63N1FOFORMTYPEAi.s.h.med: Medication, Drug - Drug Type Assignment15LOUSRUser Who Deleted Recordnvarchar120
64N1FOFOTYPEAIS-H*MED: (O B S O L E T E) Usage Type - Drug Assignment14LOUSRUser Who Deleted Recordnvarchar120
65N1FOTHCLASSAIS-H*MED: Classification Code - Drug Assignment14LOUSRUser Who Deleted Recordnvarchar120
66N1FSOURCEIS-H*MED: Fill Source15LOUSRUser Who Deleted Recordnvarchar120
67N1FSOURCEOUAIS-H*MED: Fill Source for OUs Assignment14LOUSRUser Who Deleted Recordnvarchar120
68N1GPFOAIS-H*MED: Medication, Gener. Drug - Parameter Assignment15LOUSRUser Who Deleted Recordnvarchar120
69N1IFGIS-H*MED: Degrees of infection10LOUSRUser Who Deleted Recordnvarchar120
70N1KPLIS-H*MED: VBUND: Leistungsangebot Kommunikationspartner11LOUSRBenutzername Löschungnvarchar120
71N1LSSTAIS-H*MED: Service Status10LOUSRUser Who Deleted Recordnvarchar120
72N1MEDS_DS12Medication: Formulary Grouping Areas11LOUSRUser Who Deleted Recordnvarchar120
73N1MEDS_DS14Medication: Template Grouping Areas9LOUSRUser Who Deleted Recordnvarchar120
74N1MEKIS-H*MED: Master Data Medications - Catalogs13LOUSRUser Who Deleted Recordnvarchar120
75N1MEOPRIIS-H*MED: Medication - Order Priority12LOUSRUser Who Deleted Recordnvarchar120
76N1MEPOBSOLETE: Master Data Medication - Catalog Positions18LOUSRUser Who Deleted Recordnvarchar120
77N1MEPSTFZIS-H*MED: Medication - Substance Assignment16LOUSRUser Who Deleted Recordnvarchar120
78N1MESFOAi.s.h.med: Medication, Drug Messages21LOUSRUser Who Deleted Recordnvarchar120
79N1OUTIMESi.s.h.med: Standard Times for Organizational Units12LOUSRUser Who Deleted Recordnvarchar120
80N1PFABSGIS-H*MED: Table for Termination Reasons11LOUSRUser Who Deleted Recordnvarchar120
81N1PLBAIS-H*MED: Assignment basic hosp.cat.entry to hour.nurs.plans15LOUSRUser Who Deleted Recordnvarchar120
82N1PLSTISHMED: Position11LOUSRUser Who Deleted Recordnvarchar120
83N1POBKLIS-H*MED: Classification of planning objects8LOUSRUser Who Deleted Recordnvarchar120
84N1PRDOCIS-H*MED: PATREG: Dokumente32LOUSRKullanici adi - silmenvarchar120
85N1PRFOAi.s.h.med: Medication, Price - Drug Assignment20LOUSRUser Who Deleted Recordnvarchar120
86N1PRRSFIS-H*MED: PATREG: Risikofaktoren14LOUSRKullanici adi - silmenvarchar120
87N1QUALISHMED: Qualification8LOUSRUser Who Deleted Recordnvarchar120
88N1SPMLAYOUT_DISi.s.h.med: Table for Display Parameters26LOUSRUser Who Deleted Recordnvarchar120
89N1STFIS-H*MED: Master Data of Medication Substances15LOUSRUser Who Deleted Recordnvarchar120
90N1STFTYPIS-H*MED: Substance Types14LOUSRUser Who Deleted Recordnvarchar120
91N1STPLIS-H*MED Nursing: Nursing plan profiles8LOUSRUser Who Deleted Recordnvarchar120
92N1STPLZPSIS-H*MED Nursing: Asgmt of std.nrs.pln. to nrs.pln.profile12LOUSRUser Who Deleted Recordnvarchar120
93N1STPLZYIS-H*MED Nursing: Asgmt. of cycles to nursing plan profile10LOUSRUser Who Deleted Recordnvarchar120
94N1STZYOEIS-H*MED: Cycle Prioritization as a Function of the OU14LOUSRUser Who Deleted Recordnvarchar120
95N1TAIS-H*MED: Transport Types10LOUSRUser Who Deleted Recordnvarchar120
96N1THERSIS-H*MED: Therapeutic Scheme15LOUSRUser Who Deleted Recordnvarchar120
97N1TMSTPi.s.h.med: Table for Time Stamps15LOUSRUser Who Deleted Recordnvarchar120
98N1TMSTPDURDEFi.s.h.med: Duration Definition of Time Stamps21LOUSRUser Who Deleted Recordnvarchar120
99N1XLEIISHMED: Service Range15LOUSRUser Who Deleted Recordnvarchar120
100N1YLEIIS-H*MED: Requestable services11LOUSRUser Who Deleted Recordnvarchar120
101N1ZPIIS-H*MED: Time interpretation10LOUSRUser Who Deleted Recordnvarchar120
102N1ZYINFIS-H*MED: Cycle information25LOUSRUser Who Deleted Recordnvarchar120
103N2BKIS-H*MED: Basic Nursing Catalog13LOUSRUser Who Deleted Recordnvarchar120
104N2BKGZIS-H*MED: Nursing basic catalog - classif. areas assignment14LOUSRUser Who Deleted Recordnvarchar120
105N2DEIS-H*MED: Table of documentation elements41LOUSRUser Who Deleted Recordnvarchar120
106N2DZIS-H*MED: Diagnosis assignments (groups)15LOUSRUser Who Deleted Recordnvarchar120
107N2GTIS-H*MED: Classification areas catalog7LOUSRUser Who Deleted Recordnvarchar120
108N2GTZIS-H*MED: Classification areas asgmt13LOUSRUser Who Deleted Recordnvarchar120
109N2HLIS-H*MED: OU-related hit list for diagnoses12LOUSRUser Who Deleted Recordnvarchar120
110N2LKGZIS-H*MED: Service catalog - classif. area assignment14LOUSRUser Who Deleted Recordnvarchar120
111N2OKIS-H*MED: Surgery Complications (AVB)18LOUSRUser Who Deleted Recordnvarchar120
112N2OZIS-H*MED: Surgery Times76LOUSRUser Who Deleted Recordnvarchar120
113N2PSIS-H*MED: Nursing standard catalog8LOUSRUser Who Deleted Recordnvarchar120
114N2PSBZIS-H*MED: Nursing standard - basic catalog assignment15LOUSRUser Who Deleted Recordnvarchar120
115N2PSGZIS-H*MED: Nursing standard - classification areas asgmt14LOUSRUser Who Deleted Recordnvarchar120
116N2PSLZIS-H*MED: Nursing standard - service catalog assignment13LOUSRUser Who Deleted Recordnvarchar120
117N2SPGZIS-H*MED: Standard nursing plan - classif. areas asgmt14LOUSRUser Who Deleted Recordnvarchar120
118N2ZEITENIS-H*MED: Times for anchor service13LOUSRUser Who Deleted Recordnvarchar120
119NAGENTIS-H*MED: Agents of Drugs17LOUSRUser Who Deleted Recordnvarchar120
120NDOCAIS-H*MED: Document Management Data for Archived Documents40LOUSRUser Who Deleted Recordnvarchar120
121NDOCSTORNOIS-H*MED: Canceled Documents41LOUSRUser Who Deleted Recordnvarchar120
122TN1AGTYPEi.s.h.med: Medication, Agent Types of Drugs10LOUSRUser Who Deleted Recordnvarchar120
123TN1CCPROVi.s.h.med: Medication, External Provider Medication Checks13LOUSRUser Who Deleted Recordnvarchar120
124TN1DEVICEMedication: Administration Devices12LOUSRUser Who Deleted Recordnvarchar120
125TN1ESTATUSIS-H*MED: Status for Drug Event15LOUSRUser Who Deleted Recordnvarchar120
126TN1FORMLEVELi.s.h.med: Medication, Drug Levels20LOUSRUser Who Deleted Recordnvarchar120
127TN1FORMPi.s.h.med: Medication, Generic Drug Parameters10LOUSRUser Who Deleted Recordnvarchar120
128TN1FORMTYPEIS-H*MED: Drug Types12LOUSRUser Who Deleted Recordnvarchar120
129TN1INDEXALGi.s.h.med: Phonetic Algorithms8LOUSRUser Who Deleted Recordnvarchar120
130TN1LINTYPIS-H*MED: Line Type11LOUSRUser Who Deleted Recordnvarchar120
131TN1MEALHANDi.s.h.med: Medication - Alert Processing16LOUSRUser Who Deleted Recordnvarchar120
132TN1MECCGEPAi.s.h.med: Medication Transfer Parameters17LOUSRUser Who Deleted Recordnvarchar120
133TN1MECCTSi.s.h.med: Medication Time Spans17LOUSRUser Who Deleted Recordnvarchar120
134TN1MECHARTGRPMedication: Customizable Grouping Types12LOUSRUser Who Deleted Recordnvarchar120
135TN1MECHTYPEi.s.h.med: Medication Check Type24LOUSRUser Who Deleted Recordnvarchar120
136TN1MEDCLASSIS-H*MED: Medication Classes - OBSOLETE10LOUSRUser Who Deleted Recordnvarchar120
137TN1MEDGROUPIS-H*MED: Medication Groups12LOUSRUser Who Deleted Recordnvarchar120
138TN1MELOCIS-H*MED: Localization for Medication11LOUSRUser Who Deleted Recordnvarchar120
139TN1MESEVLEVi.s.h.med: Severity for Medication Alerts14LOUSRUser Who Deleted Recordnvarchar120
140TN1MEUNITIS-H*MED: Medication - Units for Orders23LOUSRUser Who Deleted Recordnvarchar120
141TN1MSGGROUPi.s.h.med: Medication, Groups of Drug Messages10LOUSRUser Who Deleted Recordnvarchar120
142TN1OSTATUSIS-H*MED: Status for Drug Order12LOUSRUser Who Deleted Recordnvarchar120
143TN1OTYPEIS-H*MED: Medication, Type of Order11LOUSRUser Who Deleted Recordnvarchar120
144TN1PHFORMMedication: Dosage Form13LOUSRUser Who Deleted Recordnvarchar120
145TN1PRICETYPi.s.h.med: Medication, Price Types for Drug10LOUSRUser Who Deleted Recordnvarchar120
146TN1RCINDMedication: Reason Code (Institution-Independent)11LOUSRUser Who Deleted Recordnvarchar120
147TN1RCODEIS-H*MED: Reason Code18LOUSRUser Who Deleted Recordnvarchar120
148TN1ROUTEMedication: Administration Routes12LOUSRUser Who Deleted Recordnvarchar120
149TN1SIGNSi.s.h.med: Patient Record, Indicators13LOUSRUser Who Deleted Recordnvarchar120
150TN2AD_AGRTObsolete Name of Allergen Group6LOUSRUser Who Deleted Recordnvarchar120
151TN2AD_CERTAllergy - Description of Allergic Certainty6LOUSRUser Who Deleted Recordnvarchar120
152TN2AD_REATAllergy - Description of Allergy Type6LOUSRUser Who Deleted Recordnvarchar120
153TN2AD_SOATDescription of Allergic Reaction Severity6LOUSRUser Who Deleted Recordnvarchar120
154TN2AD_TYPTAllergy - Description of Allergy Type6LOUSRUser Who Deleted Recordnvarchar120
155TNTHCLASSMedication: Classification Codes14LOUSRUser Who Deleted Recordnvarchar120
TOPDocuments
156N1IM_IMAGESingle Image Within Image Study23LOUSRUser Who Deleted Recordnvarchar120
157N1IM_STUDYMeta Data of Image Study25LOUSRUser Who Deleted Recordnvarchar120
TOPMedical Rounds
158TN1BALANCETYPEi.s.h.med: Fluid Balancing, Inflow/Outflow Types10LOUSRUser Who Deleted Recordnvarchar120
TOPNursing
159N1NRSPKMSNursing Plan: NCPS Classifications21LOUSRUser Who Deleted Recordnvarchar120
160N1SNPOBSOLETE - Std.Nurs.Plan: Std.Nurs.Plan Header Data20LOUSRUser Who Deleted Recordnvarchar120
161N1SNP2BCPOBS.: Std. Nrs.Plan: Std. Nrs. Plan to Basic Cat. Item Asgmt16LOUSRUser Who Deleted Recordnvarchar120
162N1SNP2SNPOBSOLETE: Std. Nrs. Plan: Std. Nrs. Plan to Std. Nrs. Plan16LOUSRUser Who Deleted Recordnvarchar120
163N1SNPEStandard Nursing Plan: Entry21LOUSRUser Who Deleted Recordnvarchar120
164N1SNPHStd.Nurs.Plan: Header Data21LOUSRUser Who Deleted Recordnvarchar120
165N1SNPH2BCPStnd Nrs. Plan: Stnd Nrs. Plan to Basic Calog Item Asgmt17LOUSRUser Who Deleted Recordnvarchar120
166N1SNPH2OUStnd Nrs. Plan: Standard Nursing Plan to OU Assignment16LOUSRUser Who Deleted Recordnvarchar120
167N1SNPH2SNPHStd.Nurs.Plan: Std.Nurs.Plan to Std.Nurs.Plan16LOUSRUser Who Deleted Recordnvarchar120
168N1SNPPOBSOLETE - Std. Nrs. Plan: Std. Nrs. Plan Item17LOUSRUser Who Deleted Recordnvarchar120
TOPPatient Accounting
169NTPKIS-H: Header Data of Service Item23LOUSRUser Who Deleted Recordnvarchar120
TOPPatient Management
170N1CORDTYPIS-H: Clinical Order Type17LOUSRUser Who Deleted Recordnvarchar120
171N1STGRIS-H: Cancellation Reasons9LOUSRUser Who Deleted Recordnvarchar120
172N2DTIS-H*MED: Table of Documentation Categories62LOUSRUser Who Deleted Recordnvarchar120
173NDOCIS-H: Assignment of IS-H Objects to Documents in DMS40LOUSRUser Who Deleted Recordnvarchar120
174NPRTIS-H: Preregistration Type28LOUSRUser Who Deleted Recordnvarchar120
175NRSFIS-H: Patient Risk Factors8LOUSRUser Who Deleted Recordnvarchar120
176NVVFIS-H: Case-Related Insurance Relationships13LOUSRUser Who Deleted Recordnvarchar120
TOPPatient Transport Service
177N1TRANSi.s.h.med: Transport Medium12LOUSRUser Who Deleted Recordnvarchar120
178N1TRANSTAi.s.h.med: Means of Transport - Transport Types Assignment6LOUSRUser Who Deleted Recordnvarchar120
TOPPlanning
179N1CSCHGIS-H*MED: Appointment Change Reason9LOUSRUser Who Deleted Recordnvarchar120
180N1RLSTi.s.h.med: Release Status9LOUSRUser Who Deleted Recordnvarchar120
TOPSAP Healthcare - Industry-Specific Components for Hospitals
181N2BASEITEMBase Items: Base Item20LOUSRUser Who Deleted Recordnvarchar120
182TNWCH94Fee Recipient Data15LOUSRUser Who Deleted Recordnvarchar120
TOPVital Signs
183N1VPSVital Signs Master Data29LOUSRUser Who Deleted Recordnvarchar120