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

144 columns | Print definition?ERP 6.0  | PATNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ISHCDP/NBDN001Erweiterung Todesdaten für Todesanzeige3PATNRIS-H: Patientennummernvarchar100
2MLAUFKEPHHHistory table for summarized MLAUFKEPH data12PATNRPartner number for costingnvarchar60
3N1MCI_MSGMessage Log6PATNRIS-H: Patient Numbernvarchar100
4N1MESORTORDHDRMedication: Header for Man. Sorting3PATNRIS-H: Patient Numbernvarchar100
5N2CHART_USR_LAYOSL Chart: User-Specific Chart Layout5PATNRIS-H: Patient Numbernvarchar100
6NHCF_QUEUE_MAPIS-H: Map SOA Event Sequence ID to IS-H Business Object3PATNRIS-H: Patient Numbernvarchar100
7NNLCAREREQ_IDXSorgefrage Index3PATNRIS-H: Patientennummernvarchar100
8NNL_FYSIOTabelle Physiotherapie3PATNRIS-H: Patientennummernvarchar100
9NNL_MED_MESSLBZ medizinische Meldungen3PATNRIS-H: Patientennummernvarchar100
10NNL_ZH308_V9_R02ZH308 V09 Record02 Soll Daten10PATNRnvarchar110
11NNL_ZH308_V9_R04ZH308 V09 Record04 Soll Daten7PATNRIS-H: Patientennummernvarchar100
12NNL_ZH308_V9_R06ZH308 V09 Record06 Soll Daten7PATNRIS-H: Patientennummernvarchar100
13NNL_ZH308_V9_R16ZH308 V09 Record16 Soll Daten7PATNRIS-H: Patientennummernvarchar100
TOPActual CostingMaterial Ledger
14CKMLKEPHMaterial Ledger: Cost Component Split (Elements)12PATNRPartner number for costingnvarchar60
15CKMLPRKEPHMaterial Ledger: Cost Component Split (Elements) for Prices9PATNRPartner number for costingnvarchar60
16MLAUFKEPHML: Cost Component Split (Components) for Order History11PATNRPartner number for costingnvarchar60
17MLBEKEPHML: Cost Comp. Split (Elements) for Purchase Order History10PATNRPartner number for costingnvarchar60
18MLKEPHML Document: Cost Component Split (Elements) for Values10PATNRPartner number for costingnvarchar60
19MLPRKEPHML Document: Cost Component Split (Components)for Prices10PATNRPartner number for costingnvarchar60
TOPBasic Data
20NC301IS-HCM: Order Table Data Transmission for EDI29PATNRIS-H: Patient Numbernvarchar100
21NC301SIS-HCM: EDI Status Management45PATNRIS-H: Patient Numbernvarchar100
22NC301TIS-H EDI Temporary Storage for Old EDI Msg. Status Records45PATNRIS-H: Patient Numbernvarchar100
23NFORIS-H: Form Log2PATNRIS-H: Patient Numbernvarchar100
TOPBusiness Partners
24NPNTPatient Master Data51PATNRIS-H: Patient Numbernvarchar100
TOPClinical System
25N1DCS_DAUERDIAIS-H*MEd: DCS: Quick Entry Long-Term Diagnoses3PATNRIS-H: Patient Numbernvarchar100
26N1DCS_DAUERTHEIS-H*MED: DCS: Quick Entry Long-Term Therapies3PATNRIS-H: Patient Numbernvarchar100
27N1MEORDERIS-H*MED: Medication, Medication Order4PATNRIS-H: Patient Numbernvarchar100
28N1MEVOOBSOLETE: Prescription of a Medication5PATNRIS-H: Patient Numbernvarchar100
29N1PATFALIS-H*MED: Relationship between patient and case4PATNRIS-H: Patient Numbernvarchar100
30N1PATMIS-H*MED: Medical Patient Master Record2PATNRIS-H: Patient Numbernvarchar100
31N1POPAKTEIS-H*Med: Patient Organizer - Redundant Structure4PATNRPatient Numbernvarchar100
32N1PRANFIS-H*MED: PATREG: Anforderungen40PATNRIS-H: Hasta numarasinvarchar100
33N1PRDOCIS-H*MED: PATREG: Dokumente8PATNRIS-H: Hasta numarasinvarchar100
34N1PREFETCHSPOOLIS-H*MED: RAD Prefetching Tasks4PATNRIS-H: Patient Numbernvarchar100
35N1PRFALIS-H*MED: PATREG: Fälle5PATNRIS-H: Hasta numarasinvarchar100
36N1PRLEMIS-H*MED: PATREG: Leistungen5PATNRIS-H: Hasta numarasinvarchar100
37N1PRPATLOGIS-H*MED: PATREG: Fehlerprotokoll für Patientenstammdaten3PATNRIS-H: Hasta numarasinvarchar100
38N1PRPATVERGLIS-H*MED: PATREG: bestimmt ob NPAT Satz an PATREG übertrag3PATNRIS-H: Hasta numarasinvarchar100
39N1PRPATZUOIS-H*MED: PATREG: Patientenregisterzuordnungstabelle4PATNRIS-H: Hasta numarasinvarchar100
40N1PRRSFIS-H*MED: PATREG: Risikofaktoren3PATNRIS-H: Hasta numarasinvarchar100
41N1PRTMNIS-H*MED: PATREG: Termine4PATNRIS-H: Hasta numarasinvarchar100
42N1PRTMPCPYPATIS-H*MED: PATREG: NPAT Kopie des Teilnehmers2PATNRIS-H: Hasta numarasinvarchar100
43N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle3PATNRIS-H: Hasta numarasinvarchar100
44N1PRTMPPAT2PRIS-H*MED: PATREG: Zuordnung NPAT -> N1PRPAT Patienten3PATNRIS-H: Hasta numarasinvarchar100
45N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal3PATNRPATREG: Hasta taniticisinvarchar100
46N1PRVKGIS-H*MED: PATREG: Vormerkungen4PATNRIS-H: Hasta numarasinvarchar100
47N1RISMISIS-H*MED: Data transfer error (case - patient)4PATNRIS-H: Patient Numbernvarchar100
48N1SIOBUSAi.s.h.med: Patient Record, Indicator-Object Assignment13PATNRIS-H: Patient Numbernvarchar100
49N1SRVServices: Service Data6PATNRIS-H: Patient Numbernvarchar100
50N1THERSIS-H*MED: Therapeutic Scheme4PATNRIS-H: Patient Numbernvarchar100
51N1THSIS-H*MED: Medication - Order Profile5PATNRIS-H: Patient Numbernvarchar100
52N2AD_ALLERGYAllergy Documentation - Allergies2PATNRIS-H: Patient Numbernvarchar100
53N2AD_PATAllergy Documentation - Overall Allergy Status (OAS)2PATNRIS-H: Patient Numbernvarchar100
54N2AD_REACTAllergy Documentation - Reactions2PATNRIS-H: Patient Numbernvarchar100
55N2BATMPIS-H*MED: Temporary treatment order2PATNRIS-H: Patient Numbernvarchar100
56N2CCF_MSGSCCF: Message Table15PATNRIS-H: Patient Numbernvarchar100
57N2CLIM_OBSVSVital Signs: Examination13PATNRIS-H: Patient Numbernvarchar100
58N2CLIM_PATNRDummy Table for Lock Object3PATNRIS-H: Patient Numbernvarchar100
59N2CLIM_PLDVSVital Signs: Definite Planned Measurement (with Time)6PATNRIS-H: Patient Numbernvarchar100
60N2CLIM_SDLVSVital Signs: Measurement Plan for Patient (Cycles)6PATNRIS-H: Patient Numbernvarchar100
61N2DGAILEMISH*MED : Kontrolltabelle Überleitung med. Leist -> DGAI5PATNRIS-H: Patientennummernvarchar100
62N2DOCFALIS-H*MED: Case Data for Archived Documents5PATNRIS-H: Patient Numbernvarchar100
63N2DOCREFPATIS-H*MED: Empty Table for Lock Object Patient Ref. Level5PATNRIS-H: Patient Numbernvarchar100
64N2DSDEVICE_ARCHISHMED: Archive Transfer Data from Interfaces5PATNRIS-H: Patient Numbernvarchar100
65N2DSDEVICE_DATAISHMED: Transfer Data from Interface5PATNRIS-H: Patient Numbernvarchar100
66N2DWORKLISTIS-H*MED RAD: Work list (RIS - PACS work list)3PATNRIS-H: Patient Numbernvarchar100
67N2DWSWL_TASKDProvisional Task4PATNRIS-H: Patient Numbernvarchar100
68N2DWSWL_WORKDProvisional Situation4PATNRIS-H: Patient Numbernvarchar100
69N2GL_TM_PROFIS-H*MED: Occupational Groups for Subsequent Activity2PATNRIS-H: Patient Numbernvarchar100
70N2GL_TM_SCHEDULEpathways Patient Pathway4PATNRIS-H: Patient Numbernvarchar100
71N2GL_TR_DIATreatment Pathway: Proposal for Patient Pathway3PATNRIS-H: Patient Numbernvarchar100
72N2PHYO_ORDERPhysician Order4PATNRIS-H: Patient Numbernvarchar100
73NDOCAIS-H*MED: Document Management Data for Archived Documents9PATNRIS-H: Patient Numbernvarchar100
74NDOCSTORNOIS-H*MED: Canceled Documents10PATNRIS-H: Patient Numbernvarchar100
75NLEMIS-H*MED: Medical Service4PATNRIS-H: Patient Numbernvarchar100
TOPCommunication
76NHCF_EVENTIS-H: HCF: Triggered Unprocessed Events8PATNRIS-H: Patient Numbernvarchar100
TOPDocuments
77N1IM_STUDYMeta Data of Image Study4PATNRIS-H: Patient Numbernvarchar100
TOPMedical Patient Data Organization Patient Organizer
78N1STRUCMEDRECIS-H*MED: Health Problems (Struct. Med. Patient Record)3PATNRIS-H: Patient Numbernvarchar100
TOPNursing
79N1NRSPHNursing Plan: Header Data6PATNRIS-H: Patient Numbernvarchar100
80N1NRSPKMSNursing Plan: NCPS Classifications4PATNRIS-H: Patient Numbernvarchar100
TOPPatient Accounting
81NCIRIS-H: Insurance Relationships of a Case100PATNRIS-H: Patient Numbernvarchar100
82NEHCHealth Insurance Card EHC6PATNRIS-H: Patient Numbernvarchar100
83NPATVVDEBIIS-H: Table for RNUVVDEBI3PATNRIS-H: Patient Numbernvarchar100
84NPIRIS-H: Insurance Relationship Proposal Pool2PATNRIS-H: Patient Numbernvarchar100
TOPPatient Management
85N1ANFIS-H*MED: Request36PATNRIS-H: Patient Numbernvarchar100
86N1CORDERIS-H: Clinical Order5PATNRIS-H: Patient Numbernvarchar100
87N1VKGIS-H: Item of Clinical Order (Preregistration)9PATNRIS-H: Patient Numbernvarchar100
88NDAT_CHANGEIS-H: Log Data for Unprotecting Fields2PATNRIS-H: Patient Numbernvarchar100
89NDOCIS-H: Assignment of IS-H Objects to Documents in DMS9PATNRIS-H: Patient Numbernvarchar100
90NFALIS-H: Cases5PATNRIS-H: Patient Numbernvarchar100
91NFALAIS-H: Archived Cases: Obsolete as of 4.72 (Info via SARI)5PATNRIS-H: Patient Numbernvarchar100
92NKAVISH: Intermediate File Creation/Borrowing/Transfer of Recrds3PATNRIS-H: Patient Numbernvarchar100
93NPAEIS-H: Patient Master Data (Institution-Related)3PATNRIS-H: Patient Numbernvarchar100
94NPATIS-H: Patient Master Data (General)2PATNRIS-H: Patient Numbernvarchar100
95NPGZIS-H: Assignment of Patient to Business Partner2PATNRIS-H: Patient Numbernvarchar100
96NPIXIS-H: Patient name index3PATNRIS-H: Patient Numbernvarchar100
97NRSFIS-H: Patient Risk Factors2PATNRIS-H: Patient Numbernvarchar100
98NTMNIS-H: Patient-Specific Appointments (Header Table for NAPP)4PATNRIS-H: Patient Numbernvarchar100
99NTRCIS-H: Trace Log Messages16PATNRIS-H: Patient Numbernvarchar100
100NVVPIS-H: Patient-related insurance relationship2PATNRIS-H: Patient Numbernvarchar100
101NWANIS-H: Bad Debt Parties26PATNRIS-H: Patient Numbernvarchar100
TOPPatient Transport Service
102N1FATIS-H*MED: Transport Orders4PATNRIS-H: Patient Numbernvarchar100
TOPPersonnel Administration
103T7CO01Additional data of the company17PATNREmployer registration numbernvarchar150
TOPProduct Cost Planning
104CKISItems Unit Costing/Itemization Product Costing100PATNRPartner number for costingnvarchar60
105KEKOProduct Costing - Header Data107PATNRPartner number for costingnvarchar60
106KEPHProduct Costing: Cost Components for Cost of Goods Mfd9PATNRPartner number for costingnvarchar60
TOPProfit Center Accounting
107PATNPartner number/organizational unit2PATNRPartner number for costingnvarchar60
TOPPublic Sector
108T7MXPBS1PISSSTE branch code and paying agent number6PATNRISSSTE paying agent numbernvarchar60
TOPSAP Ambulatory Care Management
109NREDOMAIS-H: Table Renewable Documents - Header Data2PATNRIS-H: Patient Numbernvarchar100
110NREDOMA_DIAGIS-H: Renewable Documents - Diagnoses8PATNRIS-H: Patient Numbernvarchar100
111NWOINCIS-H: Work Incapacity Certificates2PATNRIS-H: Patient Numbernvarchar100
TOPSAP Healthcare - Industry-Specific Components for Hospitals
112ISH_HCF_HEADERHeader for Index Table7PATNRIS-H: Patient Numbernvarchar100
113ISH_IDX_HEADERHeader for Index Table8PATNRIS-H: Patient Numbernvarchar100
114N2DWSWL_TASKTask4PATNRIS-H: Patient Numbernvarchar100
115N2DWSWL_TASKPROFOccupational Groups of Tasks in Processing3PATNRIS-H: Patient Numbernvarchar100
116N2DWSWL_TPACKProfile4PATNRIS-H: Patient Numbernvarchar100
117N2DWSWL_WORKSituation4PATNRIS-H: Patient Numbernvarchar100
118NLBSNBurgerservice nummer3PATNRIS-H: Patientennummernvarchar100
119NLDBC_005NL-DBC: DBC Tabelle4PATNRIS-H: Patiëntnummernvarchar100
120NLDBC_006_TRJIS-H: NL-DBC: Sorgestrecke5PATNRIS-H: Patiëntnummernvarchar100
121NLGGZ_CARE_PROGeisteskrankheit DBC Sorgestrecke5PATNRIS-H: Patientennummernvarchar100
122NLGGZ_CODEGeisteskrankheit DBC kode3PATNRIS-H: Patientennummernvarchar100
123NLGGZ_CODE_DIAGNGeisteskranheit GGZ zusatz diagnose3PATNRIS-H: Patientennummernvarchar100
124NLGGZ_CODE_LOGGeisteskrankheit DBC protokoltabelle3PATNRIS-H: Patientennummernvarchar100
125NLGGZ_DIAG_LOGGeisteskrankheit DBC zusatz diagnosen protkoltabelle3PATNRIS-H: Patientennummernvarchar100
126NLGGZ_DISGeisteskrankheit DIS protokolle7PATNRIS-H: Patientennummernvarchar100
127NLGGZ_DIS_LOGDIS GGZ protokoltabelle6PATNRIS-H: Patientennummernvarchar100
128NLGGZ_PAT_GRPGeisteskrankheit patient gruppe aktuell5PATNRIS-H: Patientennummernvarchar100
129NLGGZ_SERVICE_CPGeisteskrankheit leistungen Leistungsgruppe kopie3PATNRIS-H: Patientennummernvarchar100
130NLVERKRechnungregister-kopf7PATNRIS-H: Patiëntnummernvarchar100
131NNAUIS-H NL: Confirmation of coverage info from ins. provider7PATNRIS-H: Patient Numbernvarchar100
132NNLEKIS-H NL: Data for treatment certificates3PATNRIS-H: Patiëntnummernvarchar100
133NNLZPIS-H NL: LAZR Bewegingsgegevens LAZR-interface16PATNRIS-H NL: LAZR-patiëntnummernvarchar150
134NPSPATIS-H: Pseudonymized Patient Master Data (General)2PATNRIS-H: Patient Numbernvarchar100
135NPSPIXIS-H: Index of Pseudonymized Patient Names3PATNRIS-H: Patient Numbernvarchar100
136NWAT_GIN_STATIRIS-H AT: Versicherungsstatus des Patienten2PATNRIS-H: Patientennummernvarchar100
137NWCHPATRECIS-H CH: PATREC - erstellte Statistiksätze9PATNRIS-H: numero pazientenvarchar100
138NWCHPATREC_IDIS-H CH: PATREC - künstl. Patienten-, Fall- und Geburtskeys3PATNRIS-H: numero pazientenvarchar100
139NWCHPSYIS-H: Tab. für BFS-Statistik um Psychodaten bereitzustelle4PATNRIS-H: numero pazientenvarchar100
140NWCH_BOA_ARCHProtokoll-Archiv für die Massendeckungsabfrage12PATNRIS-H: Patientennummernvarchar100
141NWCH_BOA_PROTProtokoll für die Massendeckungsabfrage12PATNRIS-H: Patientennummernvarchar100
142TNLGGZ_PAT_GRPGeisteskrankheit patient gruppe4PATNRIS-H: Patientennummernvarchar100
TOPVital Signs
143N1VPVital Sign Movement Data5PATNRIS-H: Patient Numbernvarchar100
144N1VP_PATDummy Table for Vital Signs - Patient Lock2PATNRIS-H: Patient Numbernvarchar100