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

175 columns | Print definition?ERP 6.0  | STDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RG_RTIReal Time Information6STDATStart date of this employmentnvarchar80
2P2RM_MFAHR-DK: Payroll Results for FA Statistics18STDATHiring Date "ansættelsesdato" for FA Statisticsnvarchar80
3ZEIM_VBAPSales Document: Item Data74STDATKey date of the bill of materialnvarchar80
TOPBasic Data
4TNOBJIS-H: Objects for Client Reset Program12STDATDate of Cancellationnvarchar80
TOPClinical System
5N1BEZYIS-H*MED: Cycles with NLEI reference30STDATDate of Cancellationnvarchar80
6N1CYDEFISHMED: Cycle Definition30STDATDate of Cancellationnvarchar80
7N1DCSCLASSIS-H*MED: Classifications for Services and Diagnoses21STDATDate of Cancellationnvarchar80
8N1DCS_DAUERDIAIS-H*MEd: DCS: Quick Entry Long-Term Diagnoses16STDATDate of Cancellationnvarchar80
9N1DCS_DAUERTHEIS-H*MED: DCS: Quick Entry Long-Term Therapies22STDATDate of Cancellationnvarchar80
10N1EADDOCIS-H*MED: Medication, Event Administration Document19STDATDate of Cancellationnvarchar80
11N1EDRUGIS-H*MED: Drug Event - Drug Assignment30STDATDate of Cancellationnvarchar80
12N1EPREPDOCIS-H*MED: Preparation Documentation of Event10STDATDate of Cancellationnvarchar80
13N1IPBAIS-H*MED: Asnmt. of Indiv. Nurs. Plan to Basic HospCat.Entry15STDATDate of Cancellationnvarchar80
14N1IPLEIS-H*MED:Assignmt of Nursing Anchor Service to the ntpk13STDATDate of Cancellationnvarchar80
15N1IPSTIS-H*MED: Asgmt of Stnd. Nursing Plans to Ind. Nursing Plans10STDATDate of Cancellationnvarchar80
16N1LSMAZIS-H*MED: Service/employee assign. (delete after 3.03!)11STDATDate of Cancellationnvarchar80
17N1LSTEAMIS-H*MED: Tasks/Employees for a Service18STDATDate of Cancellationnvarchar80
18N1MEALERTi.s.h.med: Drug Alerts30STDATDate of Cancellationnvarchar80
19N1MEALMOAi.s.h.med: Medication: Assign Drug Alert to Medication Order13STDATDate of Cancellationnvarchar80
20N1MEDOBSOLETE: Patient-Related Medication Data for a Prescription20STDATDate of Cancellationnvarchar80
21N1MEEVENTIS-H*MED: Medication, Medication Event45STDATDate of Cancellationnvarchar80
22N1MEOACTi.s.h.med: Medication, Order Activities22STDATDate of Cancellationnvarchar80
23N1MEORDERIS-H*MED: Medication, Medication Order77STDATDate of Cancellationnvarchar80
24N1MEORDERTHCLAi.s.h.med: Medication, Order -> Indication15STDATDate of Cancellationnvarchar80
25N1MERGOBSOLETE: Medication Event22STDATDate of Cancellationnvarchar80
26N1MEVOOBSOLETE: Prescription of a Medication30STDATDate of Cancellationnvarchar80
27N1ODRUGIS-H*MED: Medication, Drugs of Order41STDATDate of Cancellationnvarchar80
28N1ORATEIS-H*MED: Medication, Dosage Quantities Infusions28STDATDate of Cancellationnvarchar80
29N1PRANFIS-H*MED: PATREG: Anforderungen37STDATIS-H: Iptal tarihinvarchar80
30N1PRBEWIS-H*MED: PATREG: Bewegungen27STDATIS-H: Iptal tarihinvarchar80
31N1PRDIAIS-H*MED: PATREG: Diagnosen37STDATIS-H: Iptal tarihinvarchar80
32N1PRDOCIS-H*MED: PATREG: Dokumente43STDATIS-H: Iptal tarihinvarchar80
33N1PRFALIS-H*MED: PATREG: Fälle21STDATIS-H: Iptal tarihinvarchar80
34N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle77STDATIS-H: Iptal tarihinvarchar80
35N1PRPATZUOIS-H*MED: PATREG: Patientenregisterzuordnungstabelle8STDATIS-H: Iptal tarihinvarchar80
36N1PRTMNIS-H*MED: PATREG: Termine26STDATIS-H: Iptal tarihinvarchar80
37N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle78STDATIS-H: Iptal tarihinvarchar80
38N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal78STDATIS-H: Iptal tarihinvarchar80
39N1PRVKGIS-H*MED: PATREG: Vormerkungen22STDATIS-H: Iptal tarihinvarchar80
40N1TMSTPDURi.s.h..med: Duration for Time Stamps17STDATDate of Cancellationnvarchar80
41N1TPGCLAi.s.h. med: Medication: Template Group - Classif. Code Asgmt14STDATDate of Cancellationnvarchar80
42N1TPGDIAGAi.s.h.med: Medication: Template Group - Diagnosis Assignment15STDATDate of Cancellationnvarchar80
43N1TPGOUAi.s.h.med: Medication OU Template Group Assignment12STDATDate of Cancellationnvarchar80
44N1TPGROUPMedication: Order Template Group19STDATDate of Cancellationnvarchar80
45N1TPGSTRUCAi.s.h.med: Medication Template Group - Problem Assignment14STDATDate of Cancellationnvarchar80
46N1TPGUSERAi.s.h.med: Medication User Template Group Assignment11STDATDate of Cancellationnvarchar80
47N1TPMEORDERIS-H*MED: Medication, Medication Order Template61STDATDate of Cancellationnvarchar80
48N1TPODRUGIS-H*MED: Medication, Drugs of Templates41STDATDate of Cancellationnvarchar80
49N1TPORATEIS-H*MED: Dosage Quantities of Template33STDATDate of Cancellationnvarchar80
50N1TPTPGRAIS-H*MED: Template - Template Group Assignment12STDATDate of Cancellationnvarchar80
51N2CA_CORD_CARDISHMED: Data for Cardiology Order Component21STDATDate of Deletionnvarchar80
52N2CA_CORD_ECGISHMED: Data for ECG Order Component22STDATDate of Deletionnvarchar80
53N2CA_CORD_HCATISHMED: Data for Cardiac Catheter Order Component32STDATDate of Deletionnvarchar80
54N2CA_CORD_HCAT_IISHMED: Interventions for Cardiac Catheter Order Component13STDATDate of Deletionnvarchar80
55N2CLIM_OBSVSVital Signs: Examination31STDATDate of Cancellationnvarchar80
56N2CLIM_PLDVSVital Signs: Definite Planned Measurement (with Time)24STDATDate of Cancellationnvarchar80
57N2CLIM_SDLVSVital Signs: Measurement Plan for Patient (Cycles)24STDATDate of Cancellationnvarchar80
58N2CLIM_VALVSVital Signs: Measured Values37STDATDate of Cancellationnvarchar80
59N2DLV_RECEIVERi.s.h.med: Dispatch - Recipient31STDATIS-H: Cancellation Datenvarchar80
60N2DOCFALIS-H*MED: Case Data for Archived Documents35STDATDate of Cancellationnvarchar80
61N2MV_ADRARTAddress Type Control Table13STDATDate of Deletionnvarchar80
62N2MV_EMTYPRecipient Type Control Table14STDATDate of Deletionnvarchar80
63N2MV_SCRMODField Control Control Table42STDATDate of Deletionnvarchar80
64N2MV_VSDATRecipient Data Table50STDATDate of Deletionnvarchar80
65N2MV_VSVORPresetting Control Table23STDATDate of Deletionnvarchar80
66N2MV_VSWEGDispatch Route Control Table14STDATDate of Deletionnvarchar80
67N2OKIS-H*MED: Surgery Complications (AVB)17STDATDate of Cancellationnvarchar80
68NDOCAIS-H*MED: Document Management Data for Archived Documents24STDATDate of Cancellationnvarchar80
69NDOCSTORNOIS-H*MED: Canceled Documents25STDATDate of Cancellationnvarchar80
TOPCompany Pension Scheme Germany
70P01CETIncorrect Actions CPS3STDATRelevant Status Datenvarchar80
71P01CSTStatus Information CPS3STDATRelevant Status Datenvarchar80
72PDAVLTData for Valuation Assignment3STDATRelevant Status Datenvarchar80
73PDAVRTResult Table: Data for Future Pension Rights3STDATRelevant Status Datenvarchar80
TOPContract Accounts Receivable and Payable
74DFKKEXCExternal Payment Information33STDATReversal Document Posting Datenvarchar80
75DFKKEXCJCash Journal: Data Store for Inbound Services25STDATReversal Document Posting Datenvarchar80
76DFKKRAPClearing/Reversal History (Line Item Level) < 4.6215STDATReversal Document Posting Datenvarchar80
77DFKKRAPTClearing/Reversal History (Line Item Level)15STDATReversal Document Posting Datenvarchar80
TOPCross-Application Components
78AAUUFKOrder master data23STDATDate of last status changenvarchar80
79VVBAPSales Document: Item Data74STDATKey date of the bill of materialnvarchar80
TOPData Collection
80S008Communications Table SD -> CO/Projects42STDATKey date of the bill of materialnvarchar80
TOPDenmark
81PA0204HR Master Record, Infotype 0204 (DA/DS Statistics DK)99STDATHiring Date "ansættelsesdato" for FA Statisticsnvarchar80
TOPFinancial Accounting
82/CCEE/SIFIDDVSpecial Tax Table24STDATReversal document datenvarchar80
TOPFrance
83HRT1680Table Part Infotype 16806STDATTraining Need Status Datenvarchar80
TOPGermany
84T5D4X_STATStatus - Admin. Contrib. Statmt Certificates E-Mail Proc.8STDATB2A: Datenvarchar80
TOPGlobal Trade Services
85/SAPSLL/CORSTHChronological Status of a Document8STDATStatus Datenvarchar80
TOPLogistics - General
86WBHITrading Contract: Item Data127STDATKey date of the bill of materialnvarchar80
TOPMaterials Management
87/SAPNEA/JSCCHHI[SC] Chargeable <-> Nonchargeable changing history10STDATDatenvarchar80
TOPMedical Patient Data Organization Patient Organizer
88N1STRUCMEDRECIS-H*MED: Health Problems (Struct. Med. Patient Record)19STDATDate of Cancellationnvarchar80
TOPOverhead Cost Orders
89AUFKOrder master data23STDATDate of last status changenvarchar80
TOPPatient Accounting
90NCIRIS-H: Insurance Relationships of a Case51STDATDate of Cancellationnvarchar80
91NFAGIS-H: Case accrual13STDATDate of Cancellationnvarchar80
92NFAGACPIS-H: Daily delimitation: check multiple execution10STDATDate of Cancellationnvarchar80
93NICPIS-H: Surgical Procedure Codes Performed18STDATDate of Cancellationnvarchar80
94NICP2IS-H: INACTIVE since 4.71 - DO NOT USE !18STDATDate of Cancellationnvarchar80
95NPIRIS-H: Insurance Relationship Proposal Pool50STDATDate of Cancellationnvarchar80
96TN22PIS-H: Control Parameters FI Posting Down Payment29STDATIS-H: Determ. Altern. Reversal Date for DP Clearing Reversalnvarchar10
TOPPatient Management
97N1ANFIS-H*MED: Request33STDATDate of Cancellationnvarchar80
98N1APCNIS-H: Appointment Defaults35STDATDate of Cancellationnvarchar80
99N1APCNDIS-H*MED: Appointment Template Dependencies14STDATDate of Cancellationnvarchar80
100N1CORDERIS-H: Clinical Order43STDATDate of Cancellationnvarchar80
101N1VKGIS-H: Item of Clinical Order (Preregistration)40STDATDate of Cancellationnvarchar80
102NAPPIS-H: Provisional Appointments for Visit Scheduling28STDATDate of Cancellationnvarchar80
103NATMIS-H/IS-H*MED: Time Slot Modification24STDATDate of Cancellationnvarchar80
104NBEWIS-H: Movements for Case49STDATDate of Cancellationnvarchar80
105NBKZIS-H: Movement assignments for Ins. Verifications/Certific.8STDATDate of Cancellationnvarchar80
106NCTOContext-to-Object Assignment10STDATDate of Cancellationnvarchar80
107NCTXIS-H: Context14STDATDate of Cancellationnvarchar80
108NDIAIS-H: Diagnoses37STDATDate of Cancellationnvarchar80
109NDIPIS-H: Diagnoses for Preregistered Patient14STDATDate of Cancellationnvarchar80
110NDOCIS-H: Assignment of IS-H Objects to Documents in DMS24STDATDate of Cancellationnvarchar80
111NFALIS-H: Cases35STDATDate of Cancellationnvarchar80
112NFFZIS-H: Assignment of a case to another case13STDATDate of Cancellationnvarchar80
113NFPZIS-H: Assignment of a case to a person14STDATDate of Cancellationnvarchar80
114NGEBIS-H: Birth Data of Newborns22STDATDate of Cancellationnvarchar80
115NIPPIS-H: Provisional Insurance Relationship of Preregistration19STDATDate of Cancellationnvarchar80
116NKSKIS-H: Insurance verification/certificate - Header data33STDATDate of Cancellationnvarchar80
117NKSPIS-H: Insurance verification/certificate - item data16STDATDate of Cancellationnvarchar80
118NPAEIS-H: Patient Master Data (Institution-Related)11STDATDate of Cancellationnvarchar80
119NPAPIS-H: Provisional Patient Master Data27STDATDate of Cancellationnvarchar80
120NPATIS-H: Patient Master Data (General)88STDATDate of Cancellationnvarchar80
121NPCPIS-H: Procedures for Preregistered Patient14STDATDate of Cancellationnvarchar80
122NTMNIS-H: Patient-Specific Appointments (Header Table for NAPP)56STDATDate of Cancellationnvarchar80
123NVVFIS-H: Case-Related Insurance Relationships21STDATDate of Cancellationnvarchar80
124NVVPIS-H: Patient-related insurance relationship43STDATDate of Cancellationnvarchar80
125NWANIS-H: Bad Debt Parties21STDATDate of Cancellationnvarchar80
126NWLMIS-H: Absences From Waiting List14STDATDate of Cancellationnvarchar80
TOPPatient Transport Service
127N1FATIS-H*MED: Transport Orders25STDATDate of Cancellationnvarchar80
TOPPayment Transactions
128CRFILEHDPayment Card File: Header6STDATPayment Cards: Settlement Date (Statement Date)nvarchar80
129CRFILEPOSPayment Card File: Individual Records18STDATPayment Cards: Settlement Date (Statement Date)nvarchar80
TOPPlanning
130N1APPLANIS-H*MED: Plan12STDATDate of Cancellationnvarchar80
131N1PGPRINTSETTINGi.s.h.med: Planning Grid Print Settings22STDATDate of Cancellationnvarchar80
132N1WPLACE_PGIS-H*MED: Spezialization for Planning Grid Display Variant12STDATDate of Cancellationnvarchar80
133N1WVIEW_PG_CLIS-H*MED: Planning Grid Settings of Planning Objects16STDATDate of Cancellationnvarchar80
134N1WVIEW_PG_DTIS-H*MED: Planning Grid Tab Page for Date View Type20STDATDate of Cancellationnvarchar80
135N1WVIEW_PG_DT_OUIS-H*MED: PG Org. Unit Setting for DT and PO View Type15STDATDate of Cancellationnvarchar80
136N1WVIEW_PG_OUIS-H*MED: Planning Grid Tab Page for OU View Type22STDATDate of Cancellationnvarchar80
137N1WVIEW_PG_POIS-H*MED: Planning Grid Tab Page for Plan. Object View Type22STDATDate of Cancellationnvarchar80
TOPProduct Cost by Period
138CKPHMaster Record: Cost Object ID Number20STDATDate of last status changenvarchar80
TOPPublic Sector
139T5APBS14SI Public Sector: SI Modifier - Percentages Assignment4STDATKey Datenvarchar80
TOPRemaining Beverage - Obsolete Objects
140/BEV1/RBVBAPSales Document: Item Data74STDATKey date of the bill of materialnvarchar80
TOPSales
141VBAPSales Document: Item Data74STDATKey date of the bill of materialnvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
142/ISHFR/COSTCOVIS-H FR: Coverage16STDATDate of Cancellationnvarchar80
143NAKR2IS-H AT: LKF - Scoring Leistungen (MELs)15STDATIS-H: Stornierungsdatumnvarchar80
144NAPXIS-H: Appendix Main Data10STDATDate of Cancellationnvarchar80
145NEO_NFALIS-H: External Orders - Order Data30STDATDate of Cancellationnvarchar80
146NLBSNBurgerservice nummer23STDATIS-H: Stornierungsdatumnvarchar80
147NNLEKIS-H NL: Data for treatment certificates20STDATIS-H: Datum van de storneringnvarchar80
148NSRVPProvisional Services in Service-Based Appointment Search19STDATDate of Cancellationnvarchar80
149NWATINTENSIS-H AT: Intensivdokumentation - Patientenadministration21STDATIS-H: Stornierungsdatumnvarchar80
150NWATPHYSIS-H AT: Intensivdokumentation - Physiologische Daten44STDATIS-H: Stornierungsdatumnvarchar80
151NWATTISS28Intensivdoku. - Pflege- u. Therapiedoku. (TISS-28 / TISS-A )43STDATIS-H: Stornierungsdatumnvarchar80
152NWATTRISSIS-H AT: Intensivdoku. - Erfass. traumatologischer Patienten27STDATIS-H: Stornierungsdatumnvarchar80
153NWAT_EDI_KOMIS-H AT: EDI Kommentar (K12)29STDATIS-H: Stornierungsdatumnvarchar80
154NWAT_GIN_ERSStatus der e-Überweisung13STDATIS-H: Stornierungsdatumnvarchar80
155NWAT_SCO_KALLKF - amb. Scoring Leistungen (KALs)14STDATIS-H: Stornierungsdatumnvarchar80
156NWAT_SCO_MELLKF - Scoring Leistungen (MELs)14STDATIS-H: Stornierungsdatumnvarchar80
157NWAT_SCO_WIKRAFIS-H AT: Scoring - manuelle Eingabe der V01-Daten16STDATIS-H: Stornierungsdatumnvarchar80
158NWCH150IS-H CH: Zeitmarken zur Leistung (ALT => wird gelöscht !)15STDATIS-H: data di stornonvarchar80
159NWCH70IS-H CH: Insurance Verification36STDATDate of Cancellationnvarchar80
160NWCHLS_NFALIS-H CH: ALIS-Fehlerhandlung - Falldaten (für Fall-API)17STDATIS-H: data di stornonvarchar80
161NWCHLS_RETURNIS-H CH: ALIS-Fehlerhandlung - Fehlermeldungen von APIs23STDATIS-H: data di stornonvarchar80
162NWCHLS_RNDIAFLAGIS-H CH: ALIS-Fehlerhandlung - Diagnose zum Fall (RNDIAFLAG)15STDATIS-H: data di stornonvarchar80
163NWCHLS_RNLRGIS-H CH: ALIS-Fehlerhandlung - Arztzuordnungen (RNLRG)30STDATIS-H: data di stornonvarchar80
164NWCHLS_RNLRZIS-H CH: ALIS-Fehlerhandlung - Leistungszuordnungen (RNLRZ)19STDATIS-H: data di stornonvarchar80
165NWCHLS_RNLRZEIS-H CH: ALIS-Fehlerhandlung - externes System (RNLRZE_CH)13STDATIS-H: data di stornonvarchar80
166NWCHLS_RNLRZMIS-H CH: ALIS-Fehlerhandlung - Zeitmarken (RNLRZM)29STDATIS-H: data di stornonvarchar80
167NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)216STDATIS-H: data di stornonvarchar80
168NWCHPAKLZIS-H CH: Patientenabrechnung - LstVerteilung Nachträge17STDATIS-H: data di stornonvarchar80
169NWCHZMIS-H CH: Zeitmarken zur Bewegung/Leistung17STDATIS-H: data di stornonvarchar80
170NWCHZMEIS-H CH: Zeit- /Maßangaben zur Bewegung/Leistung18STDATIS-H: data di stornonvarchar80
TOPSimulation
171VSAUFK_CNVersion: Order master data24STDATDate of last status changenvarchar80
172VSVBAP_CNVersion: Sales document: Item data75STDATKey date of the bill of materialnvarchar80
TOPSouth Africa
173T5WITA88ITA88 Transaction Table4STDATRecovery Datenvarchar80
TOPVital Signs
174N1VPVital Sign Movement Data20STDATDate of Cancellationnvarchar80
TOPWarehouse Management
175LTAKWM transfer order header43STDATStart Date of the Transfer Ordernvarchar80