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

45 columns | Print definition?ERP 6.0  | ABREINHEIT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T5C0PHR CH: Personnel Subarea Supplements12ABREINHEITEnterprise (ELM)nvarchar80
2T5C2QPayroll Unit WHT Return As of ELM 4.02ABREINHEITPayroll Unit: Withholding Tax Return As of ELM 4.0nvarchar80
3T5C2QTPayroll Unit WHT Return As of ELM 4.0 - Texts3ABREINHEITPayroll Unit: Withholding Tax Return As of ELM 4.0nvarchar80
4T5C72Withholding tax calculation fee2ABREINHEITPayroll Unit - Withholding Taxnvarchar80
5T5CSWHR-CH: Work Center ELM 4.02ABREINHEITHR-CH: Payroll Unit Work Center ELMnvarchar80
6T5CSWTHR-CH: Work Center ELM 4.03ABREINHEITHR-CH: Payroll Unit Work Center ELMnvarchar80
TOPSwitzerland
7T5C2LWithholding tax - payroll number2ABREINHEITPayroll Unit - Withholding Taxnvarchar80
8T5C2MPayroll unit - withholding tax2ABREINHEITPayroll Unit - Withholding Taxnvarchar80
9T5C2MTPayroll unit: Withholding tax texts3ABREINHEITPayroll Unit - Withholding Taxnvarchar80
10T5C2NPayroll unit - wage statement2ABREINHEITPayroll unit - wage statementnvarchar80
11T5C2NBRemarks for Payroll Unit Wage Statement3ABREINHEITPayroll unit - wage statementnvarchar80
12T5C2NTPayroll unit - wage statement texts3ABREINHEITPayroll unit - wage statementnvarchar80
13T5C51ELM: Grouping Payroll Units for Enterprise2ABREINHEITHR-CH: Payroll unitnvarchar80
14T5CS9HR-CH: Payroll unit - AHV/UI2ABREINHEITHR-CH: Payroll unit - AHV/UInvarchar80
15T5CS9THR-CH: Payroll unit - AHV/UI3ABREINHEITHR-CH: Payroll unit - AHV/UInvarchar80
16T5CSAHR-CH: Payroll unit UVG2ABREINHEITHR-CH: Payroll unit UVGnvarchar80
17T5CSATHR-CH: Payroll unit UVG3ABREINHEITHR-CH: Payroll unit UVGnvarchar80
18T5CSBHR-CH: Payroll unit: Social Funds2ABREINHEITHR-CH: Payroll unit: Social Fundsnvarchar80
19T5CSBTHR-CH: Payroll unit: Social Funds3ABREINHEITHR-CH: Payroll unit: Social Fundsnvarchar80
20T5CSCHR-CH: Payroll Unit: Voluntary Accident Insurance2ABREINHEITHR-CH: Payroll unit: Voluntary Insurancenvarchar80
21T5CSCTHR-CH: Payroll Unit: Voluntary Accident Insurance3ABREINHEITHR-CH: Payroll unit: Voluntary Insurancenvarchar80
22T5CSDHR-CH: Payroll Unit - Sickness Indemnity Insurance2ABREINHEITHR-CH: Payroll unit - Sickness indemnity insurancenvarchar80
23T5CSDTHR-CH: Payroll Unit - Sickness Indemnity Insurance3ABREINHEITHR-CH: Payroll unit - Sickness indemnity insurancenvarchar80
24T5CSEHR-CH: Payroll unit: NBU additional insurance2ABREINHEITHR-CH: Payroll unit: NBU additional insurancenvarchar80
25T5CSETHR-CH: Payroll unit: NBU additional insurance3ABREINHEITHR-CH: Payroll unit: NBU additional insurancenvarchar80
26T5CSFHR-CH: Payroll Unit - ASM2ABREINHEITHR-CH: Payroll unit - ASMnvarchar80
27T5CSFTHR-CH: Payroll Unit - ASM3ABREINHEITHR-CH: Payroll unit - ASMnvarchar80
28T5CSGHR-CH: Payroll Unit BFS2ABREINHEITHR-CH: Payroll unit BFSnvarchar80
29T5CSGTHR-CH: Payroll Unit BFS Text3ABREINHEITHR-CH: Payroll unit BFSnvarchar80
30T5CSJPayroll Units for the Employer Statement2ABREINHEITPayroll Unit Employer Statementnvarchar80
31T5CSJTHR-CH; Payroll Unit AGBE3ABREINHEITPayroll Unit Employer Statementnvarchar80
32T5CSKHR-CH: PAyroll Unit Compensation Fund VD2ABREINHEITHR-CH: Payroll Unit Compensation Fund VDnvarchar80
33T5CSKTHR-CH: Payroll Unit Compensation Fund VD3ABREINHEITHR-CH: Payroll Unit Compensation Fund VDnvarchar80
34T5CSLValue Table Enterprises for ELM2ABREINHEITEnterprise (ELM)nvarchar80
35T5CSLTText for Value Table Enterprises for ELM3ABREINHEITEnterprise (ELM)nvarchar80
36T5CSMHR-CH: Payroll Unit BVG ELM2ABREINHEITHR-CH: Payroll Unit BVGnvarchar80
37T5CSMTHR-CH: Payroll Unit BVG ELM3ABREINHEITHR-CH: Payroll Unit BVGnvarchar80
38T5CSXHR-CH: Payroll unit: Customer insurance 12ABREINHEITHR-CH: Payroll unit: Customer insurance 1nvarchar80
39T5CSXTHR-CH: Payroll unit: Customer insurance 13ABREINHEITHR-CH: Payroll unit: Customer insurance 1nvarchar80
40T5CSYHR-CH: Payroll unit: Customer insurance 22ABREINHEITHR-CH: Payroll unit: Customer insurance 2nvarchar80
41T5CSYTHR-CH: Payroll unit: Customer insurance 23ABREINHEITHR-CH: Payroll unit: Customer insurance 2nvarchar80
42T5CSZHR-CH: Payroll unit: Customer insurance 32ABREINHEITHR-CH: Payroll unit: Customer insurance 3nvarchar80
43T5CSZTHR-CH: Payroll unit: Customer insurance 33ABREINHEITHR-CH: Payroll unit: Customer insurance 3nvarchar80
44T5CZ1HR-CH: Payroll Unit: Family-Related Bonuses2ABREINHEITHR-CH: Payroll unit: Family-related bonusesnvarchar80
45T5CZ1THR-CH: Payroll Unit: Family-Related Bonuses3ABREINHEITHR-CH: Payroll unit: Family-related bonusesnvarchar80