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

26 columns | Print definition?ERP 6.0  | KANTO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RC_STPayroll Results: Taxes (Switzerland)8KANTOCanton Indicatornvarchar20
2T5C1O_EXCantons/Municipalities/Postcodes5KANTOCanton Indicatornvarchar20
3T5C1SWithholding Tax Rates (CH)2KANTOCanton Indicatornvarchar20
4T5C1TTexts for Withholding Tax3KANTOCanton Indicatornvarchar20
5T5C1YFee for Withholding Tax2KANTOTax cantonnvarchar20
6T5C2QPayroll Unit WHT Return As of ELM 4.05KANTOELM 4.0 WHT: Tax Canton (Payroll Unit WHT ELM)nvarchar20
7T5C72Withholding tax calculation fee3KANTOTax cantonnvarchar20
8T5CSWHR-CH: Work Center ELM 4.017KANTOELM (Work Center): Place of Work Cantonnvarchar20
TOPSwitzerland
9PA0038HR Master Record: Infotype 0038 (Fiscal Data CH)24KANTOCanton Indicatornvarchar20
10T5C10FAK Contributions (CH)2KANTOFamily Equalization Fund (FAK)nvarchar20
11T5C11Training Bonuses2KANTOFamily Equalization Fund (FAK)nvarchar20
12T5C12Bonus Paid After Birth of Child2KANTOFamily Equalization Fund (FAK)nvarchar20
13T5C1MFamily-Related Bonuses2KANTOFamily Equalization Fund (FAK)nvarchar20
14T5C1OCantons/Municipalities (CH)2KANTOCanton Indicatornvarchar20
15T5C2BWithholding Tax Bases2KANTOTax cantonnvarchar20
16T5C2CWithholding Tax Liability2KANTOTax cantonnvarchar20
17T5C2DWithholding Tax Calculation2KANTOTax cantonnvarchar20
18T5C2ESpecial Table 13th Monthly Wages2KANTOCanton Indicatornvarchar20
19T5C2FTax Cantons2KANTOTax cantonnvarchar20
20T5C2GTexts for Withholding Tax3KANTOTax cantonnvarchar20
21T5C2HWhT Tax Records2KANTOTax cantonnvarchar20
22T5C2H_EXTWTx Rates (Basis as of 100,000)2KANTOTax cantonnvarchar20
23T5C2IWhT Accounting Number4KANTOTax cantonnvarchar20
24T5C2KWhT Table Structure2KANTOTax cantonnvarchar20
25T5C2LWithholding tax - payroll number3KANTOTax cantonnvarchar20
26T5C4AMunicipality4KANTOCanton Indicatornvarchar20