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

193 columns | Print definition?ERP 6.0  | LODAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TN1LSTi.s.h.med: Service Facility Categories10LODATDate of Deletionnvarchar80
2TN1MCI_COMPComponent Registration11LODATDate of Deletionnvarchar80
3TN1MCI_PROCCommunication Processes11LODATDate of Deletionnvarchar80
4TN1MCI_PROPProperties of a Processing Step12LODATDate of Deletionnvarchar80
5TN1MCI_STEPProcessing Steps of a Communication Process12LODATDate of Deletionnvarchar80
TOPBasic Data
6NABGIS-H: Employer (Business Partner)7LODATDate of Deletionnvarchar80
7NBAUIS-H: Building Units14LODATDate of Deletionnvarchar80
8NDEBIS-H: Business Partner/IS-H Customer Supplement9LODATDate of Deletionnvarchar80
9NGPAIS-H: Business Partners33LODATDate of Deletionnvarchar80
10NKRHIS-H: Hospitals (Business Partners)7LODATDate of Deletionnvarchar80
11NKTRIS-H: Business Partners/Insurance Providers40LODATDate of Deletionnvarchar80
12NORGIS-H: Organizational Units37LODATDate of Deletionnvarchar80
13NPERIS-H: Persons20LODATDate of Deletionnvarchar80
14NTPTIS-H: Service Catalog Item Description16LODATDate of Deletionnvarchar80
15NTPZIS-H: Service Catalog Line Items: Assignments/Groupings16LODATDate of Deletionnvarchar80
16NTSIIS-H: Service catalog column information15LODATDate of Deletionnvarchar80
17NTSPIS-H: Columns in Service Catalog12LODATDate of Deletionnvarchar80
TOPBasic Functions
18FPLABilling Plan15LODATDates fromnvarchar80
19FPLAPOBilling Plan15LODATDates fromnvarchar80
20VFPLABilling Plan15LODATDates fromnvarchar80
TOPClinical System
21N1ANFTYPIS-H*MED: Request Type12LODATDate of Deletionnvarchar80
22N1APRIIS-H*MED: Request priorities11LODATDate of Deletionnvarchar80
23N1ASTIS-H*MED: Request status11LODATDate of Deletionnvarchar80
24N1AUFGAIS-H*MED: Task10LODATDate of Deletionnvarchar80
25N1BCEXPCFGBasis Cat.: Export Configuration14LODATDate of Deletionnvarchar80
26N1BCEXPCFGCPLBasis Cat.: Export Configuration Item Assignment7LODATDate of Deletionnvarchar80
27N1BCHBasic Cat.: Catalog Header15LODATDate of Deletionnvarchar80
28N1BCH2OUOBSOLETE13LODATDate of Deletionnvarchar80
29N1BCH2ROLEOBSOLETE12LODATDate of Deletionnvarchar80
30N1BCH2USEROBSOLETE12LODATDate of Deletionnvarchar80
31N1BCHLDBasic Cat.: Catalog Assignment Definition15LODATDate of Deletionnvarchar80
32N1BCIMPCFGBasic Cat.: Import Configuration21LODATDate of Deletionnvarchar80
33N1BCIMPCFGCPLBasic Cat.: Import Configuration Item Assignment9LODATDate of Deletionnvarchar80
34N1BCPBasic Cat.: Catalog Item20LODATDate of Deletionnvarchar80
35N1BCP2BCPBasic Cat.: Catalog Item to Catalog Item Assignment17LODATDate of Deletionnvarchar80
36N1BCP2DIAGBasic Cat.: Catalog Item to Diagnosis Assignment14LODATDate of Deletionnvarchar80
37N1BCP2HIERBasic Cat.: Catalog Item to Hierarchy Assignment14LODATDate of Deletionnvarchar80
38N1BCP2MATBasic Cat.: Catalog Item to Material Assignment14LODATDate of Deletionnvarchar80
39N1BCP2NTPKBasic Cat.: Catalog Item to Service Assignment16LODATDate of Deletionnvarchar80
40N1BCP2RCBasic Cat.: Item - Display Configuration Assignment15LODATDate of Deletionnvarchar80
41N1BCP2TASKBasic Cat.: Catalo Item to Task Assignment13LODATDate of Deletionnvarchar80
42N1BCP2URLBasic Cat.: Catalog Item to URL Assignment15LODATDate of Deletionnvarchar80
43N1BCPLDOBSOLETE15LODATDate of Deletionnvarchar80
44N1BCRCBasic Cat.: Display Configuration11LODATDate of Deletionnvarchar80
45N1BCRC2BCSMCBasic Cat.: Display Config. - Main Catalog Assignment16LODATDate of Deletionnvarchar80
46N1BCRGBasic Cat.: Display Group13LODATDate of Deletionnvarchar80
47N1BCSOBSOLETE: Basic Cat.: Basic Catalog Set16LODATDate of Deletionnvarchar80
48N1BCSEOBSOLETE: Basic Cat.: Basic Catalog Set Entry16LODATDate of Deletionnvarchar80
49N1BCSEPOBSOLETE: Basic Cat.: Basic Catalog Set Entry Property16LODATDate of Deletionnvarchar80
50N1BCSFBasic Catalog Set: Folder12LODATDate of Deletionnvarchar80
51N1BCSGOBSOLETE: Basic Cat.: Basic Catalog Set Group13LODATDate of Deletionnvarchar80
52N1BCSHBasic Catalog Set: Header Data17LODATDate of Deletionnvarchar80
53N1BCSMCBasic Catalog Set: Main Catalog17LODATDate of Deletionnvarchar80
54N1BCSPCBasic Catalog Set: Property Catalog16LODATDate of Deletionnvarchar80
55N1BCSPECBasic Cat.: Range11LODATDate of Deletionnvarchar80
56N1BCSPEC2BCPBasic Cat.: Range to Catalog Item Assignment14LODATDate of Deletionnvarchar80
57N1BCSPEC2EBCPBasic Cat.: Range to Excluded Catalog Item Assignment13LODATDate of Deletionnvarchar80
58N1BCSPEC2OUBasic Cat.: Range to OU Assignment14LODATDate of Deletionnvarchar80
59N1CORDUNITCORD: Units for Clinical Orders11LODATDate of Deletionnvarchar80
60N1CYGROUPi.s.h.med: Group Determination for Cycles9LODATDate of Deletionnvarchar80
61N1DCIS-H*MED: Table of Formularies16LODATDate of Deletionnvarchar80
62N1DFOIS-H*MED: Dispensing Form14LODATDate of Deletionnvarchar80
63N1ELEIISHMED: External service range15LODATDate of Deletionnvarchar80
64N1FOCATREFAi.s.h.med: Medication, ID References for External Catalogs14LODATDate of Deletionnvarchar80
65N1FOFILLSABi.s.h.med: Medication, Fill Source - Drug Assignment18LODATDate of Deletionnvarchar80
66N1FOFORMTYPEAi.s.h.med: Medication, Drug - Drug Type Assignment13LODATDate of Deletionnvarchar80
67N1FOFOTYPEAIS-H*MED: (O B S O L E T E) Usage Type - Drug Assignment12LODATDate of Deletionnvarchar80
68N1FOTHCLASSAIS-H*MED: Classification Code - Drug Assignment15LODATDate of Deletionnvarchar80
69N1FSOURCEIS-H*MED: Fill Source16LODATDate of Deletionnvarchar80
70N1FSOURCEOUAIS-H*MED: Fill Source for OUs Assignment15LODATDate of Deletionnvarchar80
71N1GPFOAIS-H*MED: Medication, Gener. Drug - Parameter Assignment16LODATDate of Deletionnvarchar80
72N1IFGIS-H*MED: Degrees of infection11LODATDate of Deletionnvarchar80
73N1KPLIS-H*MED: VBUND: Leistungsangebot Kommunikationspartner12LODATDatum Löschungnvarchar80
74N1LSSTAIS-H*MED: Service Status11LODATDate of Deletionnvarchar80
75N1MEDS_DS12Medication: Formulary Grouping Areas10LODATDate of Deletionnvarchar80
76N1MEDS_DS14Medication: Template Grouping Areas8LODATDate of Deletionnvarchar80
77N1MEKIS-H*MED: Master Data Medications - Catalogs14LODATDate of Deletionnvarchar80
78N1MEOPRIIS-H*MED: Medication - Order Priority13LODATDate of Deletionnvarchar80
79N1MEPOBSOLETE: Master Data Medication - Catalog Positions19LODATDate of Deletionnvarchar80
80N1MEPSTFZIS-H*MED: Medication - Substance Assignment17LODATDate of Deletionnvarchar80
81N1MESFOAi.s.h.med: Medication, Drug Messages19LODATDate of Deletionnvarchar80
82N1OUTIMESi.s.h.med: Standard Times for Organizational Units11LODATDate of Deletionnvarchar80
83N1PFABSGIS-H*MED: Table for Termination Reasons12LODATDate of Deletionnvarchar80
84N1PLBAIS-H*MED: Assignment basic hosp.cat.entry to hour.nurs.plans16LODATDate of Deletionnvarchar80
85N1PLSTISHMED: Position12LODATDate of Deletionnvarchar80
86N1POBKLIS-H*MED: Classification of planning objects7LODATDate of Deletionnvarchar80
87N1PRDOCIS-H*MED: PATREG: Dokumente33LODATSilme tarihinvarchar80
88N1PRFOAi.s.h.med: Medication, Price - Drug Assignment18LODATDate of Deletionnvarchar80
89N1PRRSFIS-H*MED: PATREG: Risikofaktoren13LODATSilme tarihinvarchar80
90N1QUALISHMED: Qualification9LODATDate of Deletionnvarchar80
91N1SPMLAYOUT_DISi.s.h.med: Table for Display Parameters25LODATDate of Deletionnvarchar80
92N1STFIS-H*MED: Master Data of Medication Substances16LODATDate of Deletionnvarchar80
93N1STFTYPIS-H*MED: Substance Types15LODATDate of Deletionnvarchar80
94N1STPLIS-H*MED Nursing: Nursing plan profiles9LODATDate of Deletionnvarchar80
95N1STPLZPSIS-H*MED Nursing: Asgmt of std.nrs.pln. to nrs.pln.profile13LODATDate of Deletionnvarchar80
96N1STPLZYIS-H*MED Nursing: Asgmt. of cycles to nursing plan profile11LODATDate of Deletionnvarchar80
97N1STZYOEIS-H*MED: Cycle Prioritization as a Function of the OU15LODATDate of Deletionnvarchar80
98N1TAIS-H*MED: Transport Types11LODATDate of Deletionnvarchar80
99N1THERSIS-H*MED: Therapeutic Scheme16LODATDate of Deletionnvarchar80
100N1TMSTPi.s.h.med: Table for Time Stamps14LODATDate of Deletionnvarchar80
101N1TMSTPDURDEFi.s.h.med: Duration Definition of Time Stamps20LODATDate of Deletionnvarchar80
102N1XLEIISHMED: Service Range16LODATDate of Deletionnvarchar80
103N1YLEIIS-H*MED: Requestable services12LODATDate of Deletionnvarchar80
104N1ZPIIS-H*MED: Time interpretation11LODATDate of Deletionnvarchar80
105N1ZYINFIS-H*MED: Cycle information26LODATDate of Deletionnvarchar80
106N2BKIS-H*MED: Basic Nursing Catalog14LODATDate of Deletionnvarchar80
107N2BKGZIS-H*MED: Nursing basic catalog - classif. areas assignment15LODATDate of Deletionnvarchar80
108N2DEIS-H*MED: Table of documentation elements42LODATDate of Deletionnvarchar80
109N2DZIS-H*MED: Diagnosis assignments (groups)16LODATDate of Deletionnvarchar80
110N2GTIS-H*MED: Classification areas catalog8LODATDate of Deletionnvarchar80
111N2GTZIS-H*MED: Classification areas asgmt14LODATDate of Deletionnvarchar80
112N2HLIS-H*MED: OU-related hit list for diagnoses13LODATDate of Deletionnvarchar80
113N2LKGZIS-H*MED: Service catalog - classif. area assignment15LODATDate of Deletionnvarchar80
114N2OKIS-H*MED: Surgery Complications (AVB)19LODATDate of Deletionnvarchar80
115N2OZIS-H*MED: Surgery Times77LODATDate of Deletionnvarchar80
116N2PSIS-H*MED: Nursing standard catalog9LODATDate of Deletionnvarchar80
117N2PSBZIS-H*MED: Nursing standard - basic catalog assignment16LODATDate of Deletionnvarchar80
118N2PSGZIS-H*MED: Nursing standard - classification areas asgmt15LODATDate of Deletionnvarchar80
119N2PSLZIS-H*MED: Nursing standard - service catalog assignment14LODATDate of Deletionnvarchar80
120N2SPGZIS-H*MED: Standard nursing plan - classif. areas asgmt15LODATDate of Deletionnvarchar80
121N2ZEITENIS-H*MED: Times for anchor service14LODATDate of Deletionnvarchar80
122NAGENTIS-H*MED: Agents of Drugs18LODATDate of Deletionnvarchar80
123NDOCAIS-H*MED: Document Management Data for Archived Documents41LODATDate of Deletionnvarchar80
124NDOCSTORNOIS-H*MED: Canceled Documents42LODATDate of Deletionnvarchar80
125TN1AGTYPEi.s.h.med: Medication, Agent Types of Drugs11LODATDate of Deletionnvarchar80
126TN1CCPROVi.s.h.med: Medication, External Provider Medication Checks14LODATDate of Deletionnvarchar80
127TN1DEVICEMedication: Administration Devices13LODATDate of Deletionnvarchar80
128TN1ESTATUSIS-H*MED: Status for Drug Event16LODATDate of Deletionnvarchar80
129TN1FORMLEVELi.s.h.med: Medication, Drug Levels21LODATDate of Deletionnvarchar80
130TN1FORMPi.s.h.med: Medication, Generic Drug Parameters11LODATDate of Deletionnvarchar80
131TN1FORMTYPEIS-H*MED: Drug Types13LODATDate of Deletionnvarchar80
132TN1INDEXALGi.s.h.med: Phonetic Algorithms9LODATDate of Deletionnvarchar80
133TN1LINTYPIS-H*MED: Line Type12LODATDate of Deletionnvarchar80
134TN1MEALHANDi.s.h.med: Medication - Alert Processing17LODATDate of Deletionnvarchar80
135TN1MECCGEPAi.s.h.med: Medication Transfer Parameters18LODATDate of Deletionnvarchar80
136TN1MECCTSi.s.h.med: Medication Time Spans18LODATDate of Deletionnvarchar80
137TN1MECHARTGRPMedication: Customizable Grouping Types13LODATDate of Deletionnvarchar80
138TN1MECHTYPEi.s.h.med: Medication Check Type25LODATDate of Deletionnvarchar80
139TN1MEDCLASSIS-H*MED: Medication Classes - OBSOLETE11LODATDate of Deletionnvarchar80
140TN1MEDGROUPIS-H*MED: Medication Groups13LODATDate of Deletionnvarchar80
141TN1MELOCIS-H*MED: Localization for Medication12LODATDate of Deletionnvarchar80
142TN1MESEVLEVi.s.h.med: Severity for Medication Alerts15LODATDate of Deletionnvarchar80
143TN1MEUNITIS-H*MED: Medication - Units for Orders24LODATDate of Deletionnvarchar80
144TN1MSGGROUPi.s.h.med: Medication, Groups of Drug Messages11LODATDate of Deletionnvarchar80
145TN1OSTATUSIS-H*MED: Status for Drug Order13LODATDate of Deletionnvarchar80
146TN1OTYPEIS-H*MED: Medication, Type of Order12LODATDate of Deletionnvarchar80
147TN1PHFORMMedication: Dosage Form14LODATDate of Deletionnvarchar80
148TN1PRICETYPi.s.h.med: Medication, Price Types for Drug11LODATDate of Deletionnvarchar80
149TN1RCINDMedication: Reason Code (Institution-Independent)12LODATDate of Deletionnvarchar80
150TN1RCODEIS-H*MED: Reason Code19LODATDate of Deletionnvarchar80
151TN1ROUTEMedication: Administration Routes13LODATDate of Deletionnvarchar80
152TN1SIGNSi.s.h.med: Patient Record, Indicators11LODATDate of Deletionnvarchar80
153TN2AD_AGRTObsolete Name of Allergen Group7LODATDate of Deletionnvarchar80
154TN2AD_CERTAllergy - Description of Allergic Certainty7LODATDate of Deletionnvarchar80
155TN2AD_REATAllergy - Description of Allergy Type7LODATDate of Deletionnvarchar80
156TN2AD_SOATDescription of Allergic Reaction Severity7LODATDate of Deletionnvarchar80
157TN2AD_TYPTAllergy - Description of Allergy Type7LODATDate of Deletionnvarchar80
158TNTHCLASSMedication: Classification Codes15LODATDate of Deletionnvarchar80
TOPContract Accounts Receivable and Payable
159DFKKCRDELCR: Deleted Payment Medium / Basic Data9LODATSystem Datenvarchar80
160DFKKCRDEL2PCR: Deleted Payment Medium / Payee Data10LODATSystem Datenvarchar80
161DFKKCRDELADDCR: Deleted Payment Medium / Additional Data9LODATSystem Datenvarchar80
162DFKKCRDELD2Check Register: Deleted Payment Media/Partial Encashments10LODATSystem Datenvarchar80
163DFKKCRDELESCHCheck Register: Escheatment Data9LODATSystem Datenvarchar80
164DFKKCRDELESCHACheck Register: Escheatment Data: Correspondence4LODATSystem Datenvarchar80
TOPDocuments
165N1IM_IMAGESingle Image Within Image Study21LODATDate of Deletionnvarchar80
166N1IM_STUDYMeta Data of Image Study23LODATDate of Deletionnvarchar80
TOPMedical Rounds
167TN1BALANCETYPEi.s.h.med: Fluid Balancing, Inflow/Outflow Types9LODATDate of Deletionnvarchar80
TOPNursing
168N1NRSPKMSNursing Plan: NCPS Classifications19LODATDate of Deletionnvarchar80
169N1SNPOBSOLETE - Std.Nurs.Plan: Std.Nurs.Plan Header Data18LODATDate of Deletionnvarchar80
170N1SNP2BCPOBS.: Std. Nrs.Plan: Std. Nrs. Plan to Basic Cat. Item Asgmt14LODATDate of Deletionnvarchar80
171N1SNP2SNPOBSOLETE: Std. Nrs. Plan: Std. Nrs. Plan to Std. Nrs. Plan14LODATDate of Deletionnvarchar80
172N1SNPEStandard Nursing Plan: Entry19LODATDate of Deletionnvarchar80
173N1SNPHStd.Nurs.Plan: Header Data19LODATDate of Deletionnvarchar80
174N1SNPH2BCPStnd Nrs. Plan: Stnd Nrs. Plan to Basic Calog Item Asgmt15LODATDate of Deletionnvarchar80
175N1SNPH2OUStnd Nrs. Plan: Standard Nursing Plan to OU Assignment14LODATDate of Deletionnvarchar80
176N1SNPH2SNPHStd.Nurs.Plan: Std.Nurs.Plan to Std.Nurs.Plan14LODATDate of Deletionnvarchar80
177N1SNPPOBSOLETE - Std. Nrs. Plan: Std. Nrs. Plan Item15LODATDate of Deletionnvarchar80
TOPPatient Accounting
178NTPKIS-H: Header Data of Service Item24LODATDate of Deletionnvarchar80
TOPPatient Management
179N1CORDTYPIS-H: Clinical Order Type18LODATDate of Deletionnvarchar80
180N1STGRIS-H: Cancellation Reasons10LODATDate of Deletionnvarchar80
181N2DTIS-H*MED: Table of Documentation Categories63LODATDate of Deletionnvarchar80
182NDOCIS-H: Assignment of IS-H Objects to Documents in DMS41LODATDate of Deletionnvarchar80
183NPRTIS-H: Preregistration Type29LODATDate of Deletionnvarchar80
184NRSFIS-H: Patient Risk Factors9LODATDate of Deletionnvarchar80
185NVVFIS-H: Case-Related Insurance Relationships14LODATDate of Deletionnvarchar80
TOPPatient Transport Service
186N1TRANSi.s.h.med: Transport Medium13LODATDate of Deletionnvarchar80
187N1TRANSTAi.s.h.med: Means of Transport - Transport Types Assignment7LODATDate of Deletionnvarchar80
TOPPlanning
188N1CSCHGIS-H*MED: Appointment Change Reason10LODATDate of Deletionnvarchar80
189N1RLSTi.s.h.med: Release Status10LODATDate of Deletionnvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
190N2BASEITEMBase Items: Base Item21LODATDate of Deletionnvarchar80
191TNWCH94Fee Recipient Data16LODATDate of Deletionnvarchar80
TOPSimulation
192VSFPLA_CNVersion: Billing schedule16LODATDates fromnvarchar80
TOPVital Signs
193N1VPSVital Signs Master Data30LODATDate of Deletionnvarchar80