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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

34 columns | Print definition?ERP 6.0  | VARGU

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T536AAddresses3VARGULayout rule for address typenvarchar80
2T703Incentive Wages: Operation Features4VARGUVariable key in T703nvarchar180
TOPBenefits
3T74HEBenefit payment model assignment4VARGUVariable key from featurenvarchar40
TOPCompensation Management
4T510RPay Scale Reclassification8VARGUVariable Key for Table T510R (Pay Scale Reclassification)nvarchar30
5T510_PSRCLPay scale reclassification8VARGUVariable Key for Table T510R (Pay Scale Reclassification)nvarchar30
TOPHong Kong
6T7HK1CTax grouping for report6VARGULayout rule for address typenvarchar80
TOPPayroll
7T5T1KHealth insurance institutions25VARGULayout rule for address typenvarchar80
8T5T1LBank accounts of authorities (tax,insurance)20VARGULayout rule for address typenvarchar80
9T5TPS1LBank accounts of authorities (tax,insurance)22VARGULayout rule for address typenvarchar80
10T7RO10Insurance institutions6VARGULayout rule for address typenvarchar80
11T7RO20Tax institutions7VARGULayout rule for address typenvarchar80
12T7RO536ACompany information2VARGULayout rule for address typenvarchar80
13T7ROG1EE register - ER history4VARGULayout rule for address typenvarchar80
14T7ROG2EE register - EE history7VARGULayout rule for address typenvarchar80
15T7ROG3EE register - EE history7VARGULayout rule for address typenvarchar80
16T7ROG5EE register - ER history4VARGULayout rule for address typenvarchar80
17T7ROG6EE register - EE history8VARGULayout rule for address typenvarchar80
18T7ROG7EE register - Contract History8VARGULayout rule for address typenvarchar80
19T7SK1LBank accounts of authorities (tax,insurance)23VARGULayout rule for address typenvarchar80
TOPPersonnel Administration
20T549BCompany Features3VARGUVariable key for T549Bnvarchar180
21T549CDecision Trees for Features (Customers)4VARGUVariable key for T549Bnvarchar180
22T549VRecurr. Pymts/Deds: Default Values for Payment Model3VARGUVariable key from featurenvarchar40
TOPPersonnel Management
23PA0564HR Master Record: Infotype 056425VARGUStatistical unitnvarchar80
24T7HR01PPersonnel Area/Subarea Groupings for Croatia5VARGUStatistical unitnvarchar80
TOPPublic Sector
25PA0230Personnel Master Data Infotype 0230/View 0008 PSG37VARGUVariable Key for Table T510R (Pay Scale Reclassification)nvarchar30
26T5APBS06Pay scale reclassification8VARGUType of Pay Scalenvarchar30
27T5APBS09Variable SI Percentages for Public Sector6VARGUVariable Key for T5APBS09nvarchar30
28T5D7LNNext Pay Scale Group for Higher/Lower Grouping7VARGUVariable Key for Table T510R (Pay Scale Reclassification)nvarchar30
29T5DPBS1FVariable Key for Step Increase2VARGUVariable Key for Table T510R (Pay Scale Reclassification)nvarchar30
30T5DPBS1FTVariable Key for Step Increase (Texts)3VARGUVariable Key for Table T510R (Pay Scale Reclassification)nvarchar30
31T5DPBS1GValidity of Variable Key for Each Pay Scale Group7VARGUVariable Key for Table T510R (Pay Scale Reclassification)nvarchar30
TOPSouth Africa
32T5W1HMedical Aid Payment model Assignment4VARGUVariable key from featurenvarchar40
33T5W66SARS Interface : PAYE Reference Number Attributes6VARGULayout rule for address typenvarchar80
34T5W71UIF interface : Reference number attributes5VARGULayout rule for address typenvarchar80