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

42 columns | Print definition?ERP 6.0  | BEWTY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBasic Data
1TN14AIS-H: Movement Categories3BEWTYMovement Categorynvarchar10
2TN14TIS-H: Texts of Movement Categories4BEWTYMovement Categorynvarchar10
3TN14UIS-H: Texts for Movement Types4BEWTYMovement Categorynvarchar10
4TNRELIS-H: Insurance Provider Assignments6BEWTYMovement Categorynvarchar10
TOPBenefits
5T5UBABenefit plan49BEWTYBenefit wage type for bonus employee pre-tax amountnvarchar40
TOPClinical System
6N1PRBEWIS-H*MED: PATREG: Bewegungen5BEWTYIS-H: Islem tipinvarchar10
7N1STAALIS-H*MED: Statuses for cost breakdown4BEWTYMovement Categorynvarchar10
8N2DOCBEWLEIIS-H*MED: Movement and Service Data for Archived Documents8BEWTYMovement Categorynvarchar10
TOPCommunication
9TN14B_SE_MAPMap Movement types3BEWTYMovement Categorynvarchar10
10TN14G_SE_MAPMap Movement Reasons (EDI)2BEWTYMovement Categorynvarchar10
11TN14H_SE_MAPMap Referral Types3BEWTYMovement Categorynvarchar10
TOPPatient Accounting
12TN19DProposal of Treatment Certificates5BEWTYMovement Categorynvarchar10
13TNVSLIS-H: Rules for Determining Multiplication Factors11BEWTYMovement Categorynvarchar10
TOPPatient Management
14N1APCNIS-H: Appointment Defaults4BEWTYMovement Categorynvarchar10
15N1CORDTYPIS-H: Clinical Order Type13BEWTYCORD/PREG: Clinical Order Type - Movement Categorynvarchar10
16N1VKGIS-H: Item of Clinical Order (Preregistration)84BEWTYMovement Categorynvarchar10
17NBEWIS-H: Movements for Case5BEWTYMovement Categorynvarchar10
18NTMNIS-H: Patient-Specific Appointments (Header Table for NAPP)66BEWTYMovement Categorynvarchar10
19NWPLACE_DTMIS-H: Determination of Work Environment at Callup11BEWTYMovement Categorynvarchar10
20TN14BIS-H: Movement types3BEWTYMovement Categorynvarchar10
21TN14GIS-H: Movement Reasons (EDI)2BEWTYMovement Categorynvarchar10
22TN14HIS-H: Referral Types3BEWTYMovement Categorynvarchar10
23TN14RIS-H: Movement reasons (§301) - Text3BEWTYMovement Categorynvarchar10
24TN14YIS-H: Texts for referral types4BEWTYMovement Categorynvarchar10
25TNVRGCIS-H: Bus.Transaction Check on Single Field Level (Customer)6BEWTYMovement Categorynvarchar10
26TNVRGRIS-H: Business Transaction Check on Single Field Level (SAP)4BEWTYMovement Categorynvarchar10
TOPSAP Ambulatory Care Management
27TNAMB_BWART2FATYIS-H: Assignment of Movement Types to Case Categories4BEWTYMovement Categorynvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
28/ISHFR/TNWFR_F10IS-H FR: Per Diem Fee4BEWTYMovement Categorynvarchar10
29/ISHFR/TNWFR_F19Surcharge for Care Path (CCP)4BEWTYMovement Categorynvarchar10
30/ISHFR/TNWFR_F21Absence Control4BEWTYMovement Categorynvarchar10
31N2DWSWL_SUGGESTCriteria for Situation Template Proposal7BEWTYMovement Category Search Criterianvarchar10
32N2DWSWL_SUGGEST1Criteria for Proposal of Situation Template / Changes7BEWTYMovement Category Search Criterianvarchar10
33NLVERZF_006Konversion SAP bewegungsart nach VEKTIS bewegingsart3BEWTYIS-H: Bewegingstypenvarchar10
34NLWARTE_001NL - Warteliste Bewegungen zum Fall5BEWTYIS-H: Bewegingstypenvarchar10
35NS01IS-H: Statistics database - movements6BEWTYMovement Categorynvarchar10
36TN22EErmittlung der Verwendung für ambulante Zuzahlung3BEWTYIS-H: Bewegungstypnvarchar10
37TN48IS-H: Fee on Admission and Discharge Day3BEWTYMovement Categorynvarchar10
38TN50EMaximum Patient Contribution3BEWTYMovement Categorynvarchar10
39TNAFDIS-H: Outpatient Admission Fee Determination3BEWTYMovement Categorynvarchar10
40TNCH51IS-H CH: Billing Agreement Items12BEWTYMovement Categorynvarchar10
41TNLMR5IS-H NL: LMR Bewegingscodes3BEWTYIS-H: Bewegingstypenvarchar10
42TNNL1IS-H NL: LMR discharge type3BEWTYMovement Categorynvarchar10