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

63 columns | Print definition?ERP 6.0  | ERBOE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TNPEPPIS-H: PEPP Billing Parameters for Psychiatry/Psychosomatics5ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
TOPBasic Data
2NLSUIS-H: Totals File for Service Statistics8ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
TOPClinical System
3N1ABWMSGIS-H*MED: Assignment of service/check/message3ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
4N1DWSWL_SUGSURGi.s.h.med DWS: Active Surgery Proposal Criteria6ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
5N1DWSWL_SUGSURG1i.s.h.med DWS: Inactive Surgery Proposal Criteria6ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
6N1KGTPLIS-H*MED: Service quota of the performer for the requester3ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
7N1LAPPservices without case or movement reference8ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
8N1LSTGSPLITIS-H*MED: Surgical service split3ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
9N1NURSHIFTIS-H*MED: Nurse shift times3ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
10N1OEAIS-H*MED: Involved org.units dependent on task3ERBOEPerforming/Documenting Organizational Unitnvarchar80
11N1PREFETCHSPOOLIS-H*MED: RAD Prefetching Tasks6ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
12N1PRLEMIS-H*MED: PATREG: Leistungen10ERBOEIS-H: Hizmeti gerçeklestiren organizasyon brm.taniticisinvarchar80
13N1ROLZUOIS-H*MED: Function assignment IS-H -> IS-H*MED3ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
14N1STAALIS-H*MED: Statuses for cost breakdown3ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
15N1URLIS-H*MED: Addresses of files for browser6ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
16NLEMIS-H*MED: Medical Service30ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
17TN1ROUTINGIS-H*MED: Routing Rules6ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
18TN2ERFABTCardiological Departments with Separate Number Ranges2ERBOECardiology: Department Which Performs Servicenvarchar60
TOPDocuments
19N1IM_STUDYMeta Data of Image Study11ERBOEOrganizational Unit Which Performs the Servicenvarchar80
TOPPatient Accounting
20NGLTIS-H: Intermediate table for service statistics18ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
21NLCOIS-HCO: Transfer information13ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
22NLEVIS-H: Preliminary entered services33ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
23NMATPIS-H: Material planned for case14ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
24NMATVIS-H: Material Entered for Case15ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
25NSL2IS-H: Online error records of service statistics18ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
26NSLFIS-H: Error records of service statistics18ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
27TNVSLIS-H: Rules for Determining Multiplication Factors10ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
TOPPatient Management
28NLEIIS-H: Services Performed12ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
29NWPLACE_001IS-H / IS-H*MED: Work Environment (Specialization)7ERBOEPerforming OU in Work Environmentnvarchar80
TOPRadiology
30N1PREFSPOOLIS-H*MED: RAD Prefetching Tasks9ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
31/ISHFR/TNGAPHIS-H FR: Supplements (Header Data)8ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
32/ISHFR/TNGAPPIS-H FR: Supplements (Item Data)8ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
33NAH01IS-H AT: Umschlüsselung Sachkontonummer auf Kreditor4ERBOEIS-H: ID der Organisationeinheit, die die Leistung erbringtnvarchar80
34NCH42IS-H CH: Service Rules Service Maximum Values10ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
35NCH43IS-H CH: Leistungsregeln Zuschlagsleistungen7ERBOEIS-H: ID unità organizzativa che eroga la prestazionenvarchar80
36NCH43AIS-H CH: Rollenumschlüsselung für Arztzuordnungen7ERBOEIS-H: ID unità organizzativa che eroga la prestazionenvarchar80
37NKLPIS-H: Individual outpatient srv / ins.providers (AT)8ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
38NWATAGBAIS-H AT: Ambulanzgebühren - Ergebnisse / zu verteilen9ERBOEIS-H: ID der Organisationeinheit, die die Leistung erbringtnvarchar80
39NWATALSEIS-H AT: Amb. Leistungsstatistik - Ergebnisse6ERBOEIS-H: ID der Organisationeinheit, die die Leistung erbringtnvarchar80
40NWCHLCOEAIS-HCO: Überleitungsinformationen14ERBOEIS-H: ID unità organizzativa che eroga la prestazionenvarchar80
41NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)33ERBOEIS-H: ID unità organizzativa che eroga la prestazionenvarchar80
42TN1OEPRIS-H*MED: Physician-OU Relatshp for Expanding Med.Basic Srvs2ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
43TNA40ZIS-H AT: Zeiten für Zuschlagsleistungen6ERBOEIS-H: ID der Organisationeinheit, die die Leistung erbringtnvarchar80
44TNAUMLEIIS-H AT: Umschlüsselung Leistung9ERBOEIS-H: ID der Organisationeinheit, die die Leistung erbringtnvarchar80
45TNCH51IS-H CH: Billing Agreement Items10ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
46TNCH52IS-h CH: Determination of Billing Agreements13ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
47TNCH60IS-H CH: Times for Surcharge Services6ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
48TNEO_BILLTYP_DETIS-H: External Orders - Billing Type Determination4ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
49TNEO_CHARFAC_DETIS-H: Charge Factor Value Determination for External Orders8ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
50TNEO_FEEDIST_DETIS-H: External Orders - Determine Fee Breakdown Code10ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
51TNWAT_LEIKOM_HDRIS-H AT: Leistungskombinationen umschlüsseln - Header7ERBOEIS-H: ID der Organisationeinheit, die die Leistung erbringtnvarchar80
52TNWCH103Fees: Determination of Breakdown Code12ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
53TNWCH80IS-H CH: Charge Factor Value Determination7ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
54TNWCH82IS-H CH: Punktwertermittlung für TARMED-Leistungen7ERBOEIS-H: ID unità organizzativa che eroga la prestazionenvarchar80
55TNWCH83Ermittlung der Baserate9ERBOEIS-H: ID der Organisationeinheit, die die Leistung erbringtnvarchar80
56TNWCHCOIS-H: Aufträge bestimmen für Überleitung ins CO7ERBOEIS-H: ID unità organizzativa che eroga la prestazionenvarchar80
57TNWCHEA10IS-H CH: Abrechnungsartenermittlung für Externe Aufträge4ERBOEIS-H: ID unità organizzativa che eroga la prestazionenvarchar80
58TNWCHEA11IS-H CH: Punktwertermittlung für Externe Aufträge7ERBOEIS-H: ID unità organizzativa che eroga la prestazionenvarchar80
59TNWCHEA12Determine Fee Breakdown Code for Transfer of Ext. Order10ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
60TNWCHFEEPHYSService Rule Fee Physician for Fee-Based Services9ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80
61TNWCHTMABRMATIS-H CH: TARMED - Leistungsregel Abrechenbarkeit Materialien9ERBOEIS-H: ID unità organizzativa che eroga la prestazionenvarchar80
62TNWCH_AL_EXTRAIS-H CH: ANALYSE - Leistungsregeln Zuschlagsleistungen8ERBOEIS-H : ID de l'unité org. réalisant la prestationnvarchar80
63TNWCH_DRG_ACCSwiss-DRG - Bewertungsrelation für Erlösabgrenzung4ERBOEIS-H: ID der Organisationeinheit, die die Leistung erbringtnvarchar80