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

38 columns | Print definition?ERP 6.0  | KVSCH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T5D1IHealth Insurance Contributions for the Compulsory Insured2KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
2T5D1KKAccount Data from Contribution Rate File2KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
3T5D1LSI Withholding Deductions (D)4KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
4T5D1OHealth Insurance Funds, Voluntary Contributions2KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
5T5T1M_NHealth insurers - data for XML3KVSCHHealth insurance key for compulsory HI fundnvarchar80
TOPGermany
6PD3DSAPHR-DDU: Administration Record for Notifications22KVSCHHR-DDU: Health Insurance Fundnvarchar80
7T5D11Calculation Procedures and Indicators of Health Ins. Funds2KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
8T5D16Advanced Payment - Statement of Contributions Paid8KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
9T5D19Assignment of Individual SI Contribution Funds7KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
10T5D1ASocial Insurance Contributions7KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
11T5D1JHealth Insurance Contribution Rates2KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
12T5D1KBranch Offices2KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
13T5D1MHI Contributions Reduced Voluntarily2KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
14T5D1ZContributions to Care Insurance, Voluntarily Insured2KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
15T5D30Attributes for Reimbursing Employer Expenses2KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
16T5D49Assignment SI Contribution Rates U14KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
17T5D4RDEUEV: Assignment to Recipient Funds7KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
18T5D4SDEUEV: File Counter4KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
TOPPayroll
19T5T1KHealth insurance institutions2KVSCHHealth insurance key for compulsory HI fundnvarchar80
20T5T1MZdravotni pojištovny - rozširující informace2KVSCHCíslo zdravotní pojištovnynvarchar80
21T5T1XLast foreign Health insurance - name2KVSCHHealth insurance key for compulsory HI fundnvarchar80
22T5TA2Medium for health insurance4KVSCHHealth insurance key for compulsory HI fundnvarchar80
23T7SK1KHealth insurance institutions2KVSCHHealth insurance key for compulsory HI fundnvarchar80
TOPPublic Sector
24P593RApplication Status: SI Reimbursement for Rehabilitants15KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
25T5D8QProperties of Rehabilitation Programs9KVSCHSI Keynvarchar10
TOPSocial Insurance
26T5D17Subsequent Administration of Locked HI Funds6KVSCHHI Fund Key for Compulsory Health Insurance Fundnvarchar80
TOPSouth Africa
27T5W1HMedical Aid Payment model Assignment2KVSCHSocial Insurance Companynvarchar80
28T5W1KPension Funds and Medical Aid Schemes (RSA)3KVSCHInsurance Companynvarchar80
29T5W1MSocial insurance companies3KVSCHSocial Insurance Companynvarchar80
30T5W1NSocial insurance schemes3KVSCHSocial Insurance Companynvarchar80
31T5W1OContributions for Social Insurances3KVSCHSocial Insurance Companynvarchar80
32T5W1RSocial Insurance schemes ZA Text4KVSCHSocial Insurance Companynvarchar80
33T5W1UContribution class for social insurances ZA3KVSCHSocial Insurance Companynvarchar80
34T5W1VContribution class for social insurances ZA text4KVSCHSocial Insurance Companynvarchar80
35T5W1XSocial Insurance Contributions ZA3KVSCHSocial Insurance Companynvarchar80
36T5W1YMedical Aid contribution (as of 01.01.2000)2KVSCHSocial Insurance Companynvarchar80
37T5W1ZLate Joiner Penalties2KVSCHSocial Insurance Companynvarchar80
TOPStatements
38P01W_ADMIN_01HR: Data Module: Administration for Health Insurance Funds13KVSCHHIF Key of Payee Health Insurance Fundnvarchar80