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

32 columns | Print definition?ERP 6.0  | SVSPA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T5D1BSpecial SI Rules2SVSPASI Divisionnvarchar10
2T5D1CTexts for Special Rules for SI3SVSPASI Divisionnvarchar10
3T5D1FReasons for Exemption from SI Contributions3SVSPASI Divisionnvarchar10
4T5D1GContribution Scales for Supplementary Insurance2SVSPASocial Insurance Divisionnvarchar10
5T5D1WSupplementary Pensions2SVSPASocial Insurance Divisionnvarchar10
6T5D1XSupplementary Pension (D) Percentage Rates2SVSPASocial Insurance Divisionnvarchar10
TOPGermany
7T5D12Reason for Exemption from Insurance Liability2SVSPASI Divisionnvarchar10
8T5D1HSupplementary Insurance2SVSPASocial Insurance Divisionnvarchar10
9T5D1PSocial Insurance Keys3SVSPASI Divisionnvarchar10
10T5D1SGross SI8SVSPASI Division Calculationnvarchar10
11T5D1YSocial Insurance Divisions w/ Valid SAP Contribution Groups2SVSPASI Divisionnvarchar10
12T5D4MOfficial Social Insurance Key1SVSPASI Divisionnvarchar10
13T5DP9Conversion of HI Fund Infotypes 0013/0079 -> PAISY3SVSPASocial Insurance Divisionnvarchar10
TOPPayroll
14T5T3ASI insurance calculation4SVSPAType of SP/ZPnvarchar10
15T5T3BForms for changes of eval.base of SI4SVSPAType of SP/ZPnvarchar10
16T5T3CCalculation of SI4SVSPAType of SP/ZPnvarchar10
17T7SK3AInsurance calculation configuration3SVSPAType of SP/ZPnvarchar10
18T7SK3BChanges of evaluated insurance bases3SVSPAType of SP/ZPnvarchar10
19T7SK3CRoutines for calculation of HI&SI payment3SVSPAType of SP/ZPnvarchar10
TOPSouth Africa
20T5W1FRSA SI Exemption Reasons3SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10
21T5W1GRSA SI Exemption Reasons2SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10
22T5W1KPension Funds and Medical Aid Schemes (RSA)2SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10
23T5W1MSocial insurance companies2SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10
24T5W1NSocial insurance schemes2SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10
25T5W1OContributions for Social Insurances2SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10
26T5W1PRSA Definitions of Social Insurances3SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10
27T5W1QSocial insurance indicator2SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10
28T5W1RSocial Insurance schemes ZA Text3SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10
29T5W1UContribution class for social insurances ZA2SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10
30T5W1VContribution class for social insurances ZA text3SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10
31T5W1XSocial Insurance Contributions ZA2SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10
32T5W3AWagetypes to Subtype relation5SVSPASocial Insurance Type (1=MA, 2=PF, 3=UIF)nvarchar10