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

72 columns | Print definition?ERP 6.0  | STELL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee15STELLnvarchar80
2/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee17STELLnvarchar80
3CNVLTHCM_APLNOApplication Number Organisational data (Before Conversion)19STELLJobnvarchar80
4CNVLTHCM_PERNRPersonnel Number Organisational data (Before Conversion)19STELLJobnvarchar80
5P2B2_C1HCM Declustering B2 - Cost Distribution Table C135STELLJobnvarchar80
6P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay28STELLJobnvarchar80
7P2PL_RETROADJPayroll Result PL: Retro, originals and changes45STELLJobnvarchar80
8P2PL_RETRODIFPayroll Result PL: Retro, originals and changes45STELLJobnvarchar80
9P2PL_RETROMEMPayroll Result PL: Retro, originals and changes45STELLJobnvarchar80
10P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)52STELLJobnvarchar80
11P2RT_CZDAVP18_0336STELLJobnvarchar80
12P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)52STELLJobnvarchar80
13P2RV_VAPVAP Structure Norway13STELLJobnvarchar80
14P2RX_C1Cost Distribution Table C133STELLJobnvarchar80
15P2RX_WPBPPayroll Results: Work Center/Basic Pay26STELLJobnvarchar80
16T5BPBS13Link Job <-> Employee function code (ONSSAPL / RSZPPO 073)2STELLJobnvarchar80
17T5C13HR-CH: Additional jobs2STELLJobnvarchar80
18T5D13Jobs (Germany)2STELLJobnvarchar80
19T5GPBSH13HESA: Occupational categories for HE jobs2STELLJobnvarchar80
20T5K13Jobs2STELLJobnvarchar80
21T5M13!Not Used: Jobs (Denmark)2STELLJobnvarchar80
22T5REGEmployee Information Log for Destruction of Data21STELLJobnvarchar80
23T5RPDPersonnel Data Deletion Log31STELLJobnvarchar80
24TKCKOFormula Operators2STELLNo. of operandsnvarchar10
25TKCTOLanguage Table: Formula Operators3STELLNo. of operandsnvarchar10
TOPAustria
26T5A4SAssgmt Job/Pos. to Heavy Labor Pos. in Acc. with Sec. 5 Reg.3STELLJobnvarchar80
TOPConfirmations
27AFRVConfirmation pool43STELLJobnvarchar80
28AFRV_DELBackup Copy for Confirmation Pool43STELLJobnvarchar80
TOPConstruction Industry
29T5DBVConstruction Pay: Cost Assignment: Hostels32STELLJobnvarchar80
30T5DBXConstruction Pay: Incentive Wage Connection32STELLJobnvarchar80
TOPCross-Application Objects in HR
31HRP5581DB Table for Infotype 558133STELLJobnvarchar80
TOPDenmark
32T5M15Default Values for DA Job Keys (DK)2STELLJobnvarchar80
33T5MF8FA: Default Work Function, Work Level, Management Level2STELLJobnvarchar80
TOPExternal Services
34ESLLLines of Service Package33STELLJobnvarchar80
35HRMMSRVIFInterface Table: Time Recording in MM-SRV12STELLJobnvarchar80
TOPItaly
36PA3214HR Master Record: Infotype 3214272STELLJobnvarchar80
37T5ITPMCheck Table for Higher Duties : infotype (3214) subtype 00025STELLJobnvarchar80
TOPNorway
38T5V13SSB Positions code assignment3STELLJobnvarchar80
39T5V5BAssignment of job to occupation code2STELLJobnvarchar80
TOPPayroll
40PA3265HR master record, infotype 326532STELLJobnvarchar80
41T5HPBS96Foreign exchange multipliers (for IT3265)6STELLJobnvarchar80
42T5HPBS98FX multipliers for long-term studies abroad6STELLJobnvarchar80
43T5T13Jobs x KZAM2STELLJobnvarchar80
44T5TPSC1SPLITRozdelení nákladu43STELLProfesenvarchar80
45T7SK13Jobs x KZAM2STELLJobnvarchar80
TOPPayroll General Parts
46HRPY_WPBPHR-PAY: Transparent Table WPBP24STELLJobnvarchar80
TOPPersonnel Administration
47PA0001HR Master Record: Infotype 0001 (Org. Assignment)37STELLJobnvarchar80
48T513Jobs2STELLJobnvarchar80
49T513SJob Titles3STELLJobnvarchar80
50T528BPositions15STELLJobnvarchar80
51T5H3CSupplies2STELLJobnvarchar80
TOPPersonnel Time Management
52ASSOBAssignment Objects31STELLJobnvarchar80
53COIFTInterface to Activity Allocation63STELLJobnvarchar80
54PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)64STELLJobnvarchar80
55PTEX2003GENInterface Table for IT 2003: General Information63STELLJobnvarchar80
56PTEX2003SPECInterface Table for IT 2003: Interval Information39STELLJobnvarchar80
57PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)63STELLJobnvarchar80
TOPPlant Data Collection
58RUECKTemp. storage for subsystem confirmations38STELLJobnvarchar80
TOPPublic Sector
59HRP1653DB Table for Infotype 165319STELLJob Codenvarchar40
60PA0509HR-AU-PS: Master Data (Higher Duty Allowance)140STELLJobnvarchar80
61T5D7ZAssignment of Exception Indicator to Job2STELLJobnvarchar80
62T5PBSR6D(Not used, will be deleted in 4.6)3STELLJobnvarchar80
TOPRecruitment
63PB0001HR Master Record: Infotype 0001 (Org. Assignment)37STELLJobnvarchar80
TOPSingapore
64T5R13Occupational group2STELLJobnvarchar80
TOPSouth Africa
65T5W13Link job category occupational level Employment equity.2STELLJobnvarchar80
66T5W15Job to SOC Code Allocation (South Africa)2STELLJobnvarchar80
TOPStatements
67P01W_DBKRData Module: Remuneration Statement for Sick Pay10STELLEmployed asnvarchar200
TOPSwitzerland
68T5C31Salary Comparison: Function Assignment3STELLJobnvarchar80
TOPTravel Planning
69FTPT_REQ_ACCOUNTTravel Request Cost Assignment35STELLJobnvarchar80
TOPUSA
70T5U13Jobs2STELLJobnvarchar80
71T5U25WC: Job Attributes2STELLJobnvarchar80
TOPVenezuela
72T7VES3Function code relationship (Company/IVSS)2STELLJobnvarchar80