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

33 columns | Print definition?ERP 6.0  | ANSVH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee36ANSVHnvarchar20
2/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee21ANSVHnvarchar20
3CNVLTHCM_APLNOApplication Number Organisational data (Before Conversion)15ANSVHWork Contractnvarchar20
4CNVLTHCM_PERNRPersonnel Number Organisational data (Before Conversion)15ANSVHWork Contractnvarchar20
5P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay26ANSVHWork Contractnvarchar20
6P2RX_WPBPPayroll Results: Work Center/Basic Pay24ANSVHWork Contractnvarchar20
7T5FDSNCTTemp table for PAYFR_RESULT-CT18ANSVHType de contratnvarchar20
8T5REGEmployee Information Log for Destruction of Data17ANSVHWork Contractnvarchar20
9T5RPDPersonnel Data Deletion Log27ANSVHWork Contractnvarchar20
TOPCanada
10T5KB4Account Number Organizational assignment, Canada4ANSVHWork Contractnvarchar20
TOPCompensation Management
11PA0395HR Master Record: Infotype 0395 (External Org.Assignment)26ANSVHWork Contractnvarchar20
TOPCross-Application Objects in HR
12HRP5581DB Table for Infotype 558132ANSVHWork Contractnvarchar20
TOPGermany
13T5D03Employee Group/Subgroup6ANSVHWork Contractnvarchar20
TOPGreat Britain
14T5G0AEmployee Group/Subgroup4ANSVHWork Contractnvarchar20
TOPJapan
15PA0853HR Master Record: Infotype 085330ANSVHWork Contractnvarchar20
TOPNorway
16T5V03Employee group/subgrouping for employment contracts (NO)4ANSVHWork Contractnvarchar20
17T5VSTAssignment of granularity to EE status/travel tax key2ANSVHWork Contractnvarchar20
TOPPayroll General Parts
18HRPY_WPBPHR-PAY: Transparent Table WPBP22ANSVHWork Contractnvarchar20
TOPPersonnel Administration
19PA0001HR Master Record: Infotype 0001 (Org. Assignment)33ANSVHWork Contractnvarchar20
20PB0395HR Master Record: Infotype 0395 (External Org.Assignment)26ANSVHWork Contractnvarchar20
21T542AWork Contract3ANSVHWork Contractnvarchar20
22T542TEmployment Contracts4ANSVHWork Contractnvarchar20
23T7GR1APD1Customizing table for KAD and EMPLOYER DEPARTMENT5ANSVHWork Contractnvarchar20
24T7GR1APD2Customizing Table for SPECIALTY IKA6ANSVHWork Contractnvarchar20
25T7GR1APD3Customizing Table for ALL_DAYS and FULL_SCHD5ANSVHWork Contractnvarchar20
26T7GR1INSSocial Insurance Fund Agreement5ANSVHWork Contractnvarchar20
27T7GR2AVEHIncrement Collecting Time Period6ANSVHWork Contractnvarchar20
28T7GR2OCStandard Payroll Elements for Off Cycles5ANSVHWork Contractnvarchar20
29T7GR2QUOQuota Elements5ANSVHWork Contractnvarchar20
30T7GR2STDPayroll Groupings & Standard Elements5ANSVHWork Contractnvarchar20
31T7SI42AConversion of contract types to M1 values2ANSVHWork Contractnvarchar20
TOPRecruitment
32PB0001HR Master Record: Infotype 0001 (Org. Assignment)33ANSVHWork Contractnvarchar20
TOPSweden
33T5S03Employee Group/Subgroup (SE)4ANSVHWork Contractnvarchar20