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

128 columns | Print definition?ERP 6.0  | TALST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1NTPKDPIS-H DE: Additional Settings for a PEPP Service4TALSTService in Service Catalognvarchar100
2NTPKDPRELIS-H DE: Remuneration Levels of a PEPP Service4TALSTService in Service Catalognvarchar100
3TN24L_DTProposed Services per Treatment Category/Period5TALSTIS-H: Service to Be Proposed for a Treatment Categorynvarchar100
4TNNL_ACT_EMPTYTabelle Leeren DBC4TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
5TNWAT_FREQULeistungsgenerierung für ambulante Besuche12TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
6TNWCHSDRG03Swiss-DRG - Leistungsregeln DRG-Zusatzentgelte Medikamente13TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
7TNWCH_ADDCHARGELeistungsregel: Altersprüfung bei Zusatzentgelten7TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
8TNWCH_LST_CONSVADefault-Verabreichungsart je Medikament4TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
TOPBasic Data
9NBAUIS-H: Building Units30TALSTService in Service Catalognvarchar100
10NORGIS-H: Organizational Units61TALSTService in Service Catalognvarchar100
11NPTWIS-H: Rules for Charge Factor Value Determ.5TALSTService in Service Catalognvarchar100
12NTPTIS-H: Service Catalog Item Description5TALSTService in Service Catalognvarchar100
13NTPZIS-H: Service Catalog Line Items: Assignments/Groupings5TALSTService in Service Catalognvarchar100
14NTSPIS-H: Columns in Service Catalog4TALSTService in Service Catalognvarchar100
15TN40BIS-H: Scheduling Types11TALSTIS-H: Service Group for Service-Based Appointment Searchnvarchar100
16TNC301ASIS-H: EDI Assign Indicators to Service5TALSTService in Service Catalognvarchar100
17TNS25IS-H: Factors for Determining Std Billing Days4TALSTService in Service Catalognvarchar100
18TNT1IS-H: Specialty-Related Service Catalogs6TALSTService in Service Catalognvarchar100
TOPClinical System
19N1BCP2NTPKBasic Cat.: Catalog Item to Service Assignment8TALSTService in Service Catalognvarchar100
20N1CORDTSIS-H: Service Hit List Clin.Ord.Type - Order Filler Assgmt6TALSTService in Service Catalognvarchar100
21N1ELEIISHMED: External service range4TALSTService in Service Catalognvarchar100
22N1IPLEIS-H*MED:Assignmt of Nursing Anchor Service to the ntpk5TALSTService in Service Catalognvarchar100
23N1KGTPLIS-H*MED: Service quota of the performer for the requester6TALSTService Code for Quota Checknvarchar100
24N1KPLIS-H*MED: VBUND: Leistungsangebot Kommunikationspartner6TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
25N1LAUFISHMED: Service Task4TALSTService in Service Catalognvarchar100
26N1LSTGSPLITIS-H*MED: Surgical service split5TALSTService in Service Catalognvarchar100
27N1PLBAIS-H*MED: Assignment basic hosp.cat.entry to hour.nurs.plans4TALSTService in Service Catalognvarchar100
28N1PLZYIS-H*MED: Cycles with NTPZ reference ->see documentation !!!5TALSTService in Service Catalognvarchar100
29N1TMSTPDURDEFi.s.h.med: Duration Definition of Time Stamps7TALSTService in Service Catalognvarchar100
30N1TPGLIS-H*MED: Service quotas for daily program6TALSTService in Service Catalognvarchar100
31N1TPLABIS-H*MED: Required Laboratory Parameters4TALSTService in Service Catalognvarchar100
32N1TPLOKIS-H*MED: Radiology - Excluded Localization4TALSTService in Service Catalognvarchar100
33N1TPMIS-H*MED: Medical Enhancements for the Service Catalog Items4TALSTService in Service Catalognvarchar100
34N1TPPIS-H*MED: Resource Profile for Services4TALSTService in Service Catalognvarchar100
35N1TPTAIS-H*MED: Excluded Transport Type4TALSTService in Service Catalognvarchar100
36N1TPZIS-H*MED: Nursing attr for NTPZ5TALSTService in Service Catalognvarchar100
37N1VMKIS-H*MED: Table for preselections in the service hit list7TALSTService in Service Catalognvarchar100
38N1XLEIISHMED: Service Range4TALSTService in Service Catalognvarchar100
39N1YLEIIS-H*MED: Requestable services7TALSTService in Service Catalognvarchar100
40N1ZPLSTIS-H*MED: Assignment of standards to STD - nursing plans4TALSTService in Service Catalognvarchar100
41N2ANARTIS-H*MED: Anesthesia types4TALSTKey for Anesthesia Servicenvarchar100
42N2DLIS-H*MED: Table of doc. category to service assignments4TALSTService in Service Catalognvarchar100
43N2DL1IS-H*MED: Table of doc. category to service assignments4TALSTService in Service Catalognvarchar100
44N2MATREFIS-H*MED: Reference table for material external data (N2FM)8TALSTService in Service Catalognvarchar100
45NASCOIS-H: LKF Point valuation synchronous4TALSTService in Service Catalognvarchar100
46TN2KUM02IS-H*MED: Asgmt Services->Groups for cumulative findings6TALSTService in Service Catalognvarchar100
TOPPatient Accounting
47NLAUIS-H: Service Exclusions5TALSTIS-H: Service Group for Service Rulesnvarchar100
48NLGRIS-H: Dynamic Service Groups5TALSTIS-H: Service Group for Service Rulesnvarchar100
49NLKOIS-H: Service Inclusions5TALSTIS-H: Service Group for Service Rulesnvarchar100
50NTFIIS-H: Service Catalog Determination Rules5TALSTService in Service Catalognvarchar100
51NTPKIS-H: Header Data of Service Item4TALSTService in Service Catalognvarchar100
52NTPKDIS-H: Add. Fields for Service Master Germany4TALSTService in Service Catalognvarchar100
53NTPPIS-H: Planned Values Per Service and Org. Unit4TALSTService in Service Catalognvarchar100
54NTPVIS-H: Assign Service to Base Planning Object4TALSTService in Service Catalognvarchar100
55TN24LIS-H: Proposed Services By Treatment Category5TALSTIS-H: Service to Be Proposed for a Treatment Categorynvarchar100
56TNLONGTERMSVCIS-H: Maintain Long-Term Accommodation Services4TALSTService in Service Catalognvarchar100
57TNMATLEIDefine Default Material Service4TALSTService in Service Catalognvarchar100
TOPPatient Management
58NPRTLIS-H*MED: Preregistration Type - Service Hit List6TALSTService in Service Catalognvarchar100
59TNLOC_SERVService to Be Generated for Each Level of Care8TALSTService in Service Catalognvarchar100
TOPSAP Healthcare - Industry-Specific Components for Hospitals
60/ISHFR/MATSERVIS-H FR: Assign Service -> Material7TALSTService in Service Catalognvarchar100
61/ISHFR/NTPKFRIS-H FR: Additional Fields for Service Master France4TALSTService in Service Catalognvarchar100
62/ISHFR/NTPKFR_AKIS-H FR: Asgt Serv. Master France => Activity + Phase4TALSTService in Service Catalognvarchar100
63/ISHFR/NTPKFR_ASIS-H FR: Asgt Serv. Master France => Ass. Serv. + Code4TALSTService in Service Catalognvarchar100
64/ISHFR/NTPKFR_GHIS-H FR: Additional Fields for Service Master France (DRG)4TALSTService in Service Catalognvarchar100
65/ISHFR/NTPKFR_LAIS-H FR: Asgt Service Master France => Service Exclusion4TALSTService in Service Catalognvarchar100
66/ISHFR/NTPKFR_MCIS-H FR: Asgt Service Master France => Modif. Codes4TALSTService in Service Catalognvarchar100
67/ISHFR/TNWFR_CCPIS-H FR: Coordinated Care Path6TALSTService in Service Catalognvarchar100
68/ISHFR/TNWFR_F19Surcharge for Care Path (CCP)9TALSTService in Service Catalognvarchar100
69/ISHFR/TNWFR_F20PSC Patient Contribution Inc. Assignment Type7TALSTService in Service Catalognvarchar100
70/ISHFR/TNWFR_F21Absence Control15TALSTService in Service Catalognvarchar100
71NAHGRSIS-H AT: Höchstgrenzentabelle für Scoring4TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
72NBQS_ZUSCHLBQS: Assignment of Module to Surcharge and Discount9TALSTService in Service Catalognvarchar100
73NCH10IS-H CH: Service Breakdown4TALSTService in Service Catalognvarchar100
74NCH10TIS-H CH: Service Breakdown Text5TALSTService in Service Catalognvarchar100
75NLDBC_014ISH NL: DBC Ablauf steurung8TALSTIS-H: Voor te stellen verrichting uit een behandelcategorienvarchar100
76NLVERZF_005Konversion SAP nach neue fall3TALSTVerrichting binnen een verrichtingencatalogusnvarchar100
77NNPWIS-H NL: Services with charge factors4TALSTService in Service Catalognvarchar100
78NNTFIS-H NL: Service Catalog Determination9TALSTService in Service Catalognvarchar100
79NTDCIS-H: Service Default Coverage4TALSTService in Service Catalognvarchar100
80NTPKATIS-H AT: Zusatzfelder Leistungsstamm Österreich4TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
81NTPKCHIS-H CH: Zusatzfelder Leistungsstamm Schweiz (TARMED)4TALSTPrestazione in un catalogo delle prestazioninvarchar100
82NTPKCH_AGEIS-H CH: Zuordng Leistungsstamm Schweiz (TARMED) => Alter4TALSTPrestazione in un catalogo delle prestazioninvarchar100
83NTPKCH_FACHIS-H CH: Zuord Lei.Stamm Schweiz (Analyse)=>Fachbereich4TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
84NTPKCH_KOMBIS-H CH: Zuo Leiststamm Schweiz (TARMED) => komb. Lei4TALSTPrestazione in un catalogo delle prestazioninvarchar100
85NTPKCH_KUMUIS-H CH: Zuo Leiststamm Schweiz (TARMED) => ausschl. Lei4TALSTPrestazione in un catalogo delle prestazioninvarchar100
86NTPKCH_MAXIS-H CH: Zuordng Leistamm Schweiz (TARMED) => Maximumregel4TALSTPrestazione in un catalogo delle prestazioninvarchar100
87NTPKCH_QLDIIS-H CH: Zuo Leistungsstamm Schweiz (TARMED) => Qualit Dig4TALSTPrestazione in un catalogo delle prestazioninvarchar100
88NTPKCH_QTDIIS-H CH: Zuo Leistungsstamm Schweiz (TARMED) => Quant Dig4TALSTPrestazione in un catalogo delle prestazioninvarchar100
89NTPKCH_SPRTIS-H CH: Zuo Leistungsstamm Schweiz (TARMED) => Sparte4TALSTPrestazione in un catalogo delle prestazioninvarchar100
90NTPKITCV Italy: Enhancement to Service Master4TALSTService in Service Catalognvarchar100
91NWCH10IS-H CH: Zuordnung Leistung - KÜ-Qualifier4TALSTPrestazione in un catalogo delle prestazioninvarchar100
92NWCHLGZUOIS-H CH: Zuordnung Leistungen zu Leistungsgruppen8TALSTPrestazione in un catalogo delle prestazioninvarchar100
93TN22CIS-H: Zuordnung Leistung zu Befreiungsgrund (amb. Zuz.)5TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
94TN41IS-H: Services for Discharge Days (Singapore Only)7TALSTService in Service Catalognvarchar100
95TN48IS-H: Fee on Admission and Discharge Day7TALSTService in Service Catalognvarchar100
96TNA30AIS-H AT: Selektionsschema für Krankenanst.-Statistiken10TALSTVerrichting binnen een verrichtingencatalogusnvarchar100
97TNA30BIS-H: Selection procedure - bed classes and services9TALSTService in Service Catalognvarchar100
98TNAFDIS-H: Outpatient Admission Fee Determination13TALSTService in Service Catalognvarchar100
99TNCH51IS-H CH: Billing Agreement Items6TALSTService in Service Catalognvarchar100
100TNEO_BILLTYP_DETIS-H: External Orders - Billing Type Determination6TALSTService in Service Catalognvarchar100
101TNEO_CHARFAC_DETIS-H: Charge Factor Value Determination for External Orders11TALSTService in Service Catalognvarchar100
102TNNE4NL: Scheine und Leistungen10TALSTPrestación dentro de un catálogo de prestacionesnvarchar100
103TNNLTPIS-H NL: An zu wenden Regeln auf Leistungen4TALSTVerrichting binnen een verrichtingencatalogusnvarchar100
104TNNR1IS-H NL: Service exclusions (calculation rule)6TALSTService in Service Catalognvarchar100
105TNNR2IS-H NL: Service inclusions (calculation rule)6TALSTService in Service Catalognvarchar100
106TNNR3IS-H NL: Time-related rules6TALSTService in Service Catalognvarchar100
107TNNR4IS-H NL: Time-related rules6TALSTService in Service Catalognvarchar100
108TNNR5IS-H NL: Service Rules At Admission7TALSTIS-H: Service to Be Proposed for a Treatment Categorynvarchar100
109TNNRGIS-H NL: Zuweisung leistung(sgruppe) zu werte-regel3TALSTVerrichting binnen een verrichtingencatalogusnvarchar100
110TNWAT_ABB_KBLIS-H AT: Ambulanzbeitrag KB-Leistungen5TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
111TNWAT_SCO_HGRSIS-H AT: Höchstgrenzen für Scoring4TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
112TNWCH107Billing Type Determination for Fee Billing8TALSTService in Service Catalognvarchar100
113TNWCH108Charge Factor Value Determination for Fee Billing7TALSTService in Service Catalognvarchar100
114TNWCH80IS-H CH: Charge Factor Value Determination13TALSTService in Service Catalognvarchar100
115TNWCH81IS-H CH: Billing Type Determination10TALSTService in Service Catalognvarchar100
116TNWCH82IS-H CH: Punktwertermittlung für TARMED-Leistungen11TALSTPrestazione in un catalogo delle prestazioninvarchar100
117TNWCH83Ermittlung der Baserate14TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
118TNWCH84Ermittlung des Kostenteilers6TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
119TNWCHEA10IS-H CH: Abrechnungsartenermittlung für Externe Aufträge6TALSTPrestazione in un catalogo delle prestazioninvarchar100
120TNWCHEA11IS-H CH: Punktwertermittlung für Externe Aufträge10TALSTPrestazione in un catalogo delle prestazioninvarchar100
121TNWCHEA13IS-H CH: Bearbeitungsgebühr pflegen für Externe Aufträge9TALSTPrestazione in un catalogo delle prestazioninvarchar100
122TNWCHSDRG02Swiss-DRG - Leistungsregeln DRG-Zusatzentgelte generieren9TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100
123TNWCHTMABRMATIS-H CH: TARMED - Leistungsregel Abrechenbarkeit Materialien11TALSTPrestazione in un catalogo delle prestazioninvarchar100
124TNWCHTMDIVISIS-H CH: TARMED - Leistungsregel Spartenzuschlag8TALSTPrestazione in un catalogo delle prestazioninvarchar100
125TNWCHXMLROLEIS-H CH: ALIS-XML-Rollenzuordnung6TALSTPrestazione in un catalogo delle prestazioninvarchar100
126TNWCH_AL_EXTRAIS-H CH: ANALYSE - Leistungsregeln Zuschlagsleistungen14TALSTPrestation dans un catalogue de prestationsnvarchar100
127TNWCH_AL_KUMUIS-H CH: ANALYSE - Leistungsregeln Kumulation8TALSTPrestation dans un catalogue de prestationsnvarchar100
128TNWCH_AL_NLHOIS-H CH: ANALYSE: Leistungsregeln Höchstwerte8TALSTLeistung innerhalb eines Leistungskatalogesnvarchar100