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

152 columns | Print definition?ERP 6.0  | TARIF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1NNK2IS-H NL: Zusatz Datei für Kostenträgers - BP Model5TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
2NNL_ZH308_V9_R06ZH308 V09 Record06 Soll Daten24TARIFnvarchar80
3NTPKDPIS-H DE: Additional Settings for a PEPP Service3TARIFIS-H: Service Catalog Identification Keynvarchar20
4NTPKDPRELIS-H DE: Remuneration Levels of a PEPP Service3TARIFIS-H: Service Catalog Identification Keynvarchar20
5T704OBatch Requests for Statements8TARIFIndicator: Remuneration Increase (Statements)nvarchar10
6TN24L_DTProposed Services per Treatment Category/Period4TARIFIS-H: Svce Catalog for Service of Treatm.Category (In-House)nvarchar20
7TNNLGGZ_ACT_STAYGeisteskrankheit: Tariff Aufenthalt8TARIFGeisteskrankheit DBC tariffnvarchar80
8TNNL_ACT_EMPTYTabelle Leeren DBC3TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
9TNWCHSDRG03Swiss-DRG - Leistungsregeln DRG-Zusatzentgelte Medikamente12TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
10TNWCH_LST_CONSVADefault-Verabreichungsart je Medikament3TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
TOPBasic Data
11NPTWIS-H: Rules for Charge Factor Value Determ.4TARIFIS-H: Service Catalog Identification Keynvarchar20
12NTPTIS-H: Service Catalog Item Description4TARIFIS-H: Service Catalog Identification Keynvarchar20
13NTPZIS-H: Service Catalog Line Items: Assignments/Groupings4TARIFIS-H: Service Catalog Identification Keynvarchar20
14NTSIIS-H: Service catalog column information3TARIFIS-H: Service Catalog Identification Keynvarchar20
15NTSPIS-H: Columns in Service Catalog3TARIFIS-H: Service Catalog Identification Keynvarchar20
16TN40BIS-H: Scheduling Types10TARIFIS-H: Service Catalog Identification Keynvarchar20
17TNC301ASIS-H: EDI Assign Indicators to Service4TARIFIS-H: Service Catalog Identification Keynvarchar20
18TNS25IS-H: Factors for Determining Std Billing Days3TARIFIS-H: Service Catalog Identification Keynvarchar20
19TNT1IS-H: Specialty-Related Service Catalogs5TARIFIS-H: Service Catalog Identification Keynvarchar20
TOPClinical System
20N1ABWMSGIS-H*MED: Assignment of service/check/message5TARIFIS-H: Service Catalog Identification Keynvarchar20
21N1BCP2NTPKBasic Cat.: Catalog Item to Service Assignment7TARIFIS-H: Service Catalog Identification Keynvarchar20
22N1CORDTSIS-H: Service Hit List Clin.Ord.Type - Order Filler Assgmt5TARIFIS-H: Service Catalog Identification Keynvarchar20
23N1ELEIISHMED: External service range3TARIFIS-H: Service Catalog Identification Keynvarchar20
24N1IPLEIS-H*MED:Assignmt of Nursing Anchor Service to the ntpk4TARIFIS-H: Service Catalog Identification Keynvarchar20
25N1KGTPLIS-H*MED: Service quota of the performer for the requester5TARIFIS-H: Service Catalog Identification Keynvarchar20
26N1KPLIS-H*MED: VBUND: Leistungsangebot Kommunikationspartner5TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
27N1LAUFISHMED: Service Task3TARIFIS-H: Service Catalog Identification Keynvarchar20
28N1LSTGSPLITIS-H*MED: Surgical service split4TARIFIS-H: Service Catalog Identification Keynvarchar20
29N1MLZUOIS-H*MED: Service-related material proposal5TARIFIS-H: Service Catalog Identification Keynvarchar20
30N1PLBAIS-H*MED: Assignment basic hosp.cat.entry to hour.nurs.plans3TARIFIS-H: Service Catalog Identification Keynvarchar20
31N1PLZYIS-H*MED: Cycles with NTPZ reference ->see documentation !!!4TARIFIS-H: Service Catalog Identification Keynvarchar20
32N1PREFETCHSPOOLIS-H*MED: RAD Prefetching Tasks10TARIFIS-H: Service Catalog Identification Keynvarchar20
33N1TMSTPDURDEFi.s.h.med: Duration Definition of Time Stamps6TARIFIS-H: Service Catalog Identification Keynvarchar20
34N1TPGLIS-H*MED: Service quotas for daily program5TARIFIS-H: Service Catalog Identification Keynvarchar20
35N1TPLABIS-H*MED: Required Laboratory Parameters3TARIFIS-H: Service Catalog Identification Keynvarchar20
36N1TPLOKIS-H*MED: Radiology - Excluded Localization3TARIFIS-H: Service Catalog Identification Keynvarchar20
37N1TPMIS-H*MED: Medical Enhancements for the Service Catalog Items3TARIFIS-H: Service Catalog Identification Keynvarchar20
38N1TPPIS-H*MED: Resource Profile for Services3TARIFIS-H: Service Catalog Identification Keynvarchar20
39N1TPTAIS-H*MED: Excluded Transport Type3TARIFIS-H: Service Catalog Identification Keynvarchar20
40N1TPZIS-H*MED: Nursing attr for NTPZ4TARIFIS-H: Service Catalog Identification Keynvarchar20
41N1VMKIS-H*MED: Table for preselections in the service hit list6TARIFIS-H: Service Catalog Identification Keynvarchar20
42N1XLEIISHMED: Service Range3TARIFIS-H: Service Catalog Identification Keynvarchar20
43N1YLEIIS-H*MED: Requestable services6TARIFIS-H: Service Catalog Identification Keynvarchar20
44N1ZPLSTIS-H*MED: Assignment of standards to STD - nursing plans3TARIFIS-H: Service Catalog Identification Keynvarchar20
45N1ZSLSTIS-H*Med: Extra services5TARIFIS-H: Service Catalog Identification Keynvarchar20
46N2ANARTIS-H*MED: Anesthesia types3TARIFIS-H: Service Catalog Identification Keynvarchar20
47N2DLIS-H*MED: Table of doc. category to service assignments3TARIFIS-H: Service Catalog Identification Keynvarchar20
48N2DL1IS-H*MED: Table of doc. category to service assignments3TARIFIS-H: Service Catalog Identification Keynvarchar20
49N2GL_PROCIS-H*MED: Procedure String of a Pathway for Assignment4TARIFIS-H: Service Catalog Identification Keynvarchar20
50NASCOIS-H: LKF Point valuation synchronous3TARIFIS-H: Service Catalog Identification Keynvarchar20
51TN2DS_GDT_SRVService-Releated GDT ID3TARIFIS-H: Service Catalog Identification Keynvarchar20
52TN2KUM02IS-H*MED: Asgmt Services->Groups for cumulative findings5TARIFIS-H: Service Catalog Identification Keynvarchar20
53TN2RADVBTDANRAD: Default Table (Techn. Parameter Angiography)3TARIFIS-H: Service Catalog Identification Keynvarchar20
54TN2RADVBTDCTRAD: Default Table (Techn. Parameter CT)3TARIFIS-H: Service Catalog Identification Keynvarchar20
55TN2RADVBTDKRRAD: Default Table (Techn. Parameter Convent. X-ray)3TARIFIS-H: Service Catalog Identification Keynvarchar20
56TN2RADVBTDMRRAD: Default Table (Techn. Parameter MRT)3TARIFIS-H: Service Catalog Identification Keynvarchar20
57TN2RADVBTDNURAD: Default Table (Techn. Parameter Nuclear Medicine)3TARIFIS-H: Service Catalog Identification Keynvarchar20
58TN2RADVBTDSODefaults for the Examination Documentation (Sonography)3TARIFIS-H: Service Catalog Identification Keynvarchar20
TOPCommunication
59NTSI_SE_MAPIS-H: Service Catalog Column Information3TARIFIS-H: Service Catalog Identification Keynvarchar20
TOPControlling
60COPPP_ITMCO Postprocessing List - Items29TARIFTotal Price per Unit of Measuredecimal112
TOPPatient Accounting
61NLEVIS-H: Preliminary entered services43TARIFIS-H: Service Catalog Identification Keynvarchar20
62NLH1IS-H: Service Maximum Values for Service Groups4TARIFIS-H: Service Catalog Identification Keynvarchar20
63NLHOIS-H: Service Maximum Values4TARIFIS-H: Service Catalog Identification Keynvarchar20
64NSL2IS-H: Online error records of service statistics27TARIFIS-H: Indicator for Errors During Service Code Mappingnvarchar10
65NSLFIS-H: Error records of service statistics27TARIFIS-H: Indicator for Errors During Service Code Mappingnvarchar10
66NTPKIS-H: Header Data of Service Item3TARIFIS-H: Service Catalog Identification Keynvarchar20
67NTPKDIS-H: Add. Fields for Service Master Germany3TARIFIS-H: Service Catalog Identification Keynvarchar20
68NTPPIS-H: Planned Values Per Service and Org. Unit3TARIFIS-H: Service Catalog Identification Keynvarchar20
69NTPVIS-H: Assign Service to Base Planning Object3TARIFIS-H: Service Catalog Identification Keynvarchar20
70NTSTIS-H: Text column information charge catalog4TARIFIS-H: Service Catalog Identification Keynvarchar20
71TN20AIS-H: Service Catalog Column Determination4TARIFIS-H: Service Catalog Identification Keynvarchar20
72TN20KService-to-Class Assignment4TARIFIS-H: Service Catalog Identification Keynvarchar20
73TN24LIS-H: Proposed Services By Treatment Category4TARIFIS-H: Svce Catalog for Service of Treatm.Category (In-House)nvarchar20
74TNFPSEIS-H: Rule Table for FRs Per Case and PSs14TARIFIS-H: Service Catalog Identification Keynvarchar20
75TNLONGTERMSVCIS-H: Maintain Long-Term Accommodation Services3TARIFIS-H: Service Catalog Identification Keynvarchar20
76TNMATLEIDefine Default Material Service3TARIFIS-H: Service Catalog Identification Keynvarchar20
77TNVSLIS-H: Rules for Determining Multiplication Factors4TARIFIS-H: Service Catalog Identification Keynvarchar20
TOPPatient Management
78NLEIIS-H: Services Performed29TARIFIS-H: Service Catalog Identification Keynvarchar20
79NPRTLIS-H*MED: Preregistration Type - Service Hit List5TARIFIS-H: Service Catalog Identification Keynvarchar20
80TNLOC_SERVService to Be Generated for Each Level of Care7TARIFIS-H: Service Catalog Identification Keynvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
81/ISHFR/MATSERVIS-H FR: Assign Service -> Material6TARIFIS-H: Service Catalog Identification Keynvarchar20
82/ISHFR/NTPKFRIS-H FR: Additional Fields for Service Master France3TARIFIS-H: Service Catalog Identification Keynvarchar20
83/ISHFR/NTPKFR_AKIS-H FR: Asgt Serv. Master France => Activity + Phase3TARIFIS-H: Service Catalog Identification Keynvarchar20
84/ISHFR/NTPKFR_ASIS-H FR: Asgt Serv. Master France => Ass. Serv. + Code3TARIFIS-H: Service Catalog Identification Keynvarchar20
85/ISHFR/NTPKFR_GHIS-H FR: Additional Fields for Service Master France (DRG)3TARIFIS-H: Service Catalog Identification Keynvarchar20
86/ISHFR/NTPKFR_LAIS-H FR: Asgt Service Master France => Service Exclusion3TARIFIS-H: Service Catalog Identification Keynvarchar20
87/ISHFR/NTPKFR_MCIS-H FR: Asgt Service Master France => Modif. Codes3TARIFIS-H: Service Catalog Identification Keynvarchar20
88/ISHFR/SERVF04IS-H FR: LPP Pricing4TARIFIS-H: Service Catalog Identification Keynvarchar20
89/ISHFR/SERVF14EMI/ETI Margin Service6TARIFIS-H: Service Catalog Identification Keynvarchar20
90/ISHFR/TNWFR_CCPIS-H FR: Coordinated Care Path5TARIFIS-H: Service Catalog Identification Keynvarchar20
91/ISHFR/TNWFR_F19Surcharge for Care Path (CCP)8TARIFIS-H: Service Catalog Identification Keynvarchar20
92/ISHFR/TNWFR_F20PSC Patient Contribution Inc. Assignment Type6TARIFIS-H: Service Catalog Identification Keynvarchar20
93/ISHFR/TNWFR_F21Absence Control14TARIFIS-H: Service Catalog Identification Keynvarchar20
94N2PRZ_HIT_HEADIS-H*MED: Names of Individual SPC Hit Lists3TARIFIS-H: Service Catalog Identification Keynvarchar20
95N2PRZ_OPS_HEADIS-H*MED: Label for SPC Catalog3TARIFIS-H: Service Catalog Identification Keynvarchar20
96N2PRZ_OPS_KATIS-H*MED: SPC Catalog in Hierarchical Structure3TARIFIS-H: Service Catalog Identification Keynvarchar20
97NAHGRSIS-H AT: Höchstgrenzentabelle für Scoring3TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
98NBQS_ZUSCHLBQS: Assignment of Module to Surcharge and Discount8TARIFIS-H: Service Catalog Identification Keynvarchar20
99NCH10IS-H CH: Service Breakdown3TARIFIS-H: Service Catalog Identification Keynvarchar20
100NCH10TIS-H CH: Service Breakdown Text4TARIFIS-H: Service Catalog Identification Keynvarchar20
101NCH42IS-H CH: Service Rules Service Maximum Values11TARIFIS-H: Service Catalog Identification Keynvarchar20
102NLDBC_014ISH NL: DBC Ablauf steurung7TARIFIS-H: Ver.cat. vooor verrichting van beh.categorie (b.tar.)nvarchar20
103NLDIS_002ISH NL: DIS - Leistungen Spezielle Strecke3TARIFIS-H: Identificatie van een verrichtingencatalogusnvarchar20
104NLHCO_TARIFIS-H NL: Plan auftrag tarif uber NL splittungs profile7TARIFfloat150
105NNK1IS-H NL: Additional file for insurance providers5TARIFIS-H: Service Catalog Identification Keynvarchar20
106NNPWIS-H NL: Services with charge factors3TARIFIS-H: Service Catalog Identification Keynvarchar20
107NTDCIS-H: Service Default Coverage3TARIFIS-H: Service Catalog Identification Keynvarchar20
108NTPKATIS-H AT: Zusatzfelder Leistungsstamm Österreich3TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
109NTPKCHIS-H CH: Zusatzfelder Leistungsstamm Schweiz (TARMED)3TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
110NTPKCH_AGEIS-H CH: Zuordng Leistungsstamm Schweiz (TARMED) => Alter3TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
111NTPKCH_FACHIS-H CH: Zuord Lei.Stamm Schweiz (Analyse)=>Fachbereich3TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
112NTPKCH_KOMBIS-H CH: Zuo Leiststamm Schweiz (TARMED) => komb. Lei3TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
113NTPKCH_KUMUIS-H CH: Zuo Leiststamm Schweiz (TARMED) => ausschl. Lei3TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
114NTPKCH_MAXIS-H CH: Zuordng Leistamm Schweiz (TARMED) => Maximumregel3TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
115NTPKCH_QLDIIS-H CH: Zuo Leistungsstamm Schweiz (TARMED) => Qualit Dig3TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
116NTPKCH_QTDIIS-H CH: Zuo Leistungsstamm Schweiz (TARMED) => Quant Dig3TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
117NTPKCH_SPRTIS-H CH: Zuo Leistungsstamm Schweiz (TARMED) => Sparte3TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
118NTPKITCV Italy: Enhancement to Service Master3TARIFIS-H: Service Catalog Identification Keynvarchar20
119NWATLH1IS-H AT: Leistungshöchstwerte für Leistungsgruppen4TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
120NWATLHOIS-H AT: Leistungshöchstwerte3TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
121NWCH10IS-H CH: Zuordnung Leistung - KÜ-Qualifier3TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
122NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)57TARIFIS-H: identificatore di un catalogo prestazioni alternativonvarchar20
123TN16PIS-H SG: Contract Scheme Items15TARIFIS-H: Service Catalog Identification Keynvarchar20
124TN20SSpaltenermittlung EBM3TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
125TN22CIS-H: Zuordnung Leistung zu Befreiungsgrund (amb. Zuz.)4TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
126TN22DIS-H: Steuerungstabelle für Art der ambulanten Zuzahlung8TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
127TN41IS-H: Services for Discharge Days (Singapore Only)6TARIFIS-H: Service Catalog Identification Keynvarchar20
128TN48IS-H: Fee on Admission and Discharge Day6TARIFIS-H: Service Catalog Identification Keynvarchar20
129TNA30AIS-H AT: Selektionsschema für Krankenanst.-Statistiken9TARIFIS-H: Identificatie van een verrichtingencatalogusnvarchar20
130TNA30BIS-H: Selection procedure - bed classes and services8TARIFIS-H: Service Catalog Identification Keynvarchar20
131TNAFDIS-H: Outpatient Admission Fee Determination12TARIFIS-H: Service Catalog Identification Keynvarchar20
132TNEO_BILLTYP_DETIS-H: External Orders - Billing Type Determination5TARIFIS-H: Service Catalog Identification Keynvarchar20
133TNEO_CHARFAC_DETIS-H: Charge Factor Value Determination for External Orders10TARIFIS-H: Service Catalog Identification Keynvarchar20
134TNLGGZ_TARIFFGeisteskrankheit DBC tariff8TARIFGeisteskrankheit DBC tariffnvarchar80
135TNNA2IS-H NL: Dummy services by billing party6TARIFIS-H: Service Catalog Identification Keynvarchar20
136TNNC3IS-H NL: Kostenübernahme von leistungen5TARIFIS-H: Identificatie van een verrichtingencatalogusnvarchar20
137TNNE4NL: Scheine und Leistungen8TARIFIS-H: Identificador de un catálogo de prestacionesnvarchar20
138TNNLTPIS-H NL: An zu wenden Regeln auf Leistungen3TARIFIS-H: Identificatie van een verrichtingencatalogusnvarchar20
139TNNR5IS-H NL: Service Rules At Admission6TARIFIS-H: Svce Catalog for Service of Treatm.Category (In-House)nvarchar20
140TNWAT_ABB_KBLIS-H AT: Ambulanzbeitrag KB-Leistungen4TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
141TNWAT_SCO_HGRSIS-H AT: Höchstgrenzen für Scoring3TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
142TNWCH107Billing Type Determination for Fee Billing7TARIFIS-H: Service Catalog Identification Keynvarchar20
143TNWCH108Charge Factor Value Determination for Fee Billing6TARIFIS-H: Service Catalog Identification Keynvarchar20
144TNWCH80IS-H CH: Charge Factor Value Determination12TARIFIS-H: Service Catalog Identification Keynvarchar20
145TNWCH81IS-H CH: Billing Type Determination9TARIFIS-H: Service Catalog Identification Keynvarchar20
146TNWCH82IS-H CH: Punktwertermittlung für TARMED-Leistungen10TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
147TNWCHEA10IS-H CH: Abrechnungsartenermittlung für Externe Aufträge5TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
148TNWCHEA11IS-H CH: Punktwertermittlung für Externe Aufträge9TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
149TNWCHSDRG02Swiss-DRG - Leistungsregeln DRG-Zusatzentgelte generieren8TARIFIS-H: Identifikation eines Leistungskatalogesnvarchar20
150TNWCHTMABRMATIS-H CH: TARMED - Leistungsregel Abrechenbarkeit Materialien10TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
151TNWCHTMDIVISIS-H CH: TARMED - Leistungsregel Spartenzuschlag7TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20
152TNWCHXMLROLEIS-H CH: ALIS-XML-Rollenzuordnung5TARIFIS-H: identificatore di un catalogo di prestazioninvarchar20