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

43 columns | Print definition?ERP 6.0  | KZTXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBasic Data
1NABGIS-H: Employer (Business Partner)3KZTXTIS-H: Comment on Employernvarchar500
2NBAUIS-H: Building Units10KZTXTIS-H: Comment on Building Unitnvarchar500
3NDEBIS-H: Business Partner/IS-H Customer Supplement5KZTXTIS-H: Comment on Customernvarchar500
4NGPAIS-H: Business Partners29KZTXTIS-H: Comment on Business Partnernvarchar500
5NKRHIS-H: Hospitals (Business Partners)3KZTXTIS-H: Comment on Hospitalnvarchar500
6NKTRIS-H: Business Partners/Insurance Providers10KZTXTIS-H: Comment on Insurance Providernvarchar500
7NORGIS-H: Organizational Units17KZTXTIS-H: Comment on Organizational Unitnvarchar500
8NPERIS-H: Persons14KZTXTIS-H: Comment on Personnvarchar500
9TN11PIS-H: Planning Characteristics of Building Unit11KZTXTIS-H: Comment on service offer building unitnvarchar300
10TNE0TIS-H: SAP User Exit - Description3KZTXTIS-H: Short description user exit eventnvarchar500
11TNP0TIS-H: Controlling the Customizing of Parameters - Texts4KZTXTIS-H: Short Documentation on Parameternvarchar600
TOPClinical System
12N1PRBEWIS-H*MED: PATREG: Bewegungen10KZTXTIS-H: Olgu islemine iliskin açiklamanvarchar500
13N1PRDIAIS-H*MED: PATREG: Diagnosen30KZTXTIS-H: Taniya iliskin açiklamanvarchar500
14N1PRFALIS-H*MED: PATREG: Fälle7KZTXTIS-H: Olgu için açiklamanvarchar300
15N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle68KZTXTIS-H: Hasta için açiklamanvarchar500
16N1PRRSFIS-H*MED: PATREG: Risikofaktoren6KZTXTIS-H: Hastanin risk faktörlerine iliskin açiklamanvarchar300
17N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle69KZTXTIS-H: Hasta için açiklamanvarchar500
18N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal69KZTXTIS-H: Hasta için açiklamanvarchar500
19N2DOCFALIS-H*MED: Case Data for Archived Documents10KZTXTIS-H: Comment on Casenvarchar300
TOPDenmark
20T5V3DTexts for T5V3C (DK/N)6KZTXTShort Text for Wage Typenvarchar80
TOPFrance
21T5F63Dynamic Mapping for Interface: Interfaced Wage Types5KZTXTShort Text for Wage Typenvarchar80
TOPPatient Accounting
22NCIRIS-H: Insurance Relationships of a Case43KZTXTIS-H: Comment on Patient-Related Insurance Relationshipnvarchar500
23NPIRIS-H: Insurance Relationship Proposal Pool42KZTXTIS-H: Comment on Patient-Related Insurance Relationshipnvarchar500
TOPPatient Management
24NAPPIS-H: Provisional Appointments for Visit Scheduling16KZTXTComment on Case Movementnvarchar500
25NBEWIS-H: Movements for Case19KZTXTComment on Case Movementnvarchar500
26NDIAIS-H: Diagnoses27KZTXTIS-H: Comment on Diagnosisnvarchar500
27NFALIS-H: Cases10KZTXTIS-H: Comment on Casenvarchar300
28NFFZIS-H: Assignment of a case to another case9KZTXTIS-H: Comment on Case-to-Case Assignmentnvarchar500
29NFPZIS-H: Assignment of a case to a person10KZTXTIS-H: Comment on case-to-person assignmentnvarchar500
30NGEBIS-H: Birth Data of Newborns13KZTXTIS-H: Comment on Birthnvarchar500
31NPATIS-H: Patient Master Data (General)74KZTXTIS-H: Comment on Patientnvarchar500
32NRSFIS-H: Patient Risk Factors5KZTXTIS-H: Comment on Patient Risk Factorsnvarchar300
33NVVFIS-H: Case-Related Insurance Relationships10KZTXTIS-H: Comment on Case-Related Insurance Relationshipnvarchar500
34NVVPIS-H: Patient-related insurance relationship35KZTXTIS-H: Comment on Patient-Related Insurance Relationshipnvarchar500
35NWANIS-H: Bad Debt Parties17KZTXTIS-H: Comment on Bad Debt Partynvarchar300
36TN15XIS-H: Texts for Employee Types5KZTXTIS-H: Text for employee typenvarchar200
TOPPayroll
37T7TRIC01Ücret Türü Tanim Tablosu4KZTXTÜcret Türü Kisaltmasinvarchar100
TOPPayroll General Parts
38T512STexts for Cumulation Wage Types in Forms7KZTXTShort Text for Wage Typenvarchar80
TOPPersonnel Administration
39T512TWage Type Texts6KZTXTShort Text for Wage Typenvarchar80
40T7PLSONumber range subobjects3KZTXTText (30 Characters)nvarchar300
TOPSAP Ambulatory Care Management
41NREDOMAIS-H: Table Renewable Documents - Header Data19KZTXTRenewable Document - Short Textnvarchar400
TOPSAP Healthcare - Industry-Specific Components for Hospitals
42TNCH32TIS-H CH: Service Text Codes - text5KZTXTIS-H CH: Short text for service text codenvarchar400
43TNCH33TIS-H CH: Tariff Types5KZTXTIS-H CH: Short text for tariff typesnvarchar400