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

39 columns | Print definition?ERP 6.0  | SCHEM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P08P1CLSCLASS CPX INTERFACE Snapshot Table11SCHEMCLASS CPX INTERFACE Scheme Idnvarchar30
2P2RX_VERSIONInformation on Creation10SCHEMPersonnel calculation schemanvarchar40
3PTRV_DELETE_LOGLog Table for Deleted Trips9SCHEMTrip schemanvarchar20
4T5GPBS1CLASS CPX Pension Scheme Cross Reference2SCHEMPension schemenvarchar30
5T5GPBS42Declare vehicle types for private and business miles3SCHEMCar schemenvarchar40
6T5GPBS_VEHTYPEDerive vehicle types from car information2SCHEMVehicle Classificationnvarchar40
TOPGreat Britain
7PA0222HR Master Record for Infotype 0222 (Company Cars GB)49SCHEMCar schemenvarchar40
TOPNon Profit Organizations
8T7UN_T52C0Abrechnungsschemen1SCHEMPersonalrechenschemanvarchar40
9T7UN_T52C2Texte zu Abrechnungsschemen2SCHEMPersonalrechenschemanvarchar40
TOPPayroll General Parts
10T52C0Payroll Schemas1SCHEMPersonnel calculation schemanvarchar40
11T52C1Payroll Schemas (Customer)2SCHEMPersonnel calculation schemanvarchar40
12T52C2Texts for Personnel Calculation Schemas2SCHEMPersonnel calculation schemanvarchar40
13T52C3Texts for Personnel Calculation Schemas3SCHEMPersonnel calculation schemanvarchar40
TOPPension fund General Parts
14T5CB4PC Schemas4SCHEMPC schemanvarchar20
15T5CB5Texts for PC Schemas5SCHEMPC schemanvarchar20
16T5CBAPC Schema of PC Evaluation Type5SCHEMPC schemanvarchar20
17T5CBCCompatibility of PC Schemas and Output Sequences4SCHEMPC schemanvarchar20
18T5CBFIndividual Processing of a PC Schema4SCHEMPC schemanvarchar20
19T5CBOAdditional Selection Parameters for Reports4SCHEMPC schemanvarchar20
20T5CBXSettings for PC Schema4SCHEMPC schemanvarchar20
21T5CP4HR-CH: Value assignment for fields (BI)3SCHEMPC schemanvarchar20
22T5CP5HR-CH: Infotypes for BI3SCHEMPC schemanvarchar20
23T5CPIHR-CH: Settings for PC Schemata for PF2SCHEMPC schemanvarchar20
24T72A7HR-PF: ESS Control for Universal Evaluations5SCHEMPC schemanvarchar20
TOPPublic Sector
25PA0488HR-SG-PS: Leave scheme24SCHEMScheme codenvarchar20
26PB0488HR-SG-PS: Leave scheme24SCHEMScheme codenvarchar20
27T5PBSR3ALeave scheme types2SCHEMScheme codenvarchar20
28T5PBSR3ATText table for leave schemes3SCHEMScheme codenvarchar20
TOPSingapore
29PA0186HR Master Record: Infotype 0186 [Social Insurance] (SG)49SCHEMSwitch for the CPF voluntarynvarchar10
TOPTravel Expenses
30PTRV_ARCH_HEADPrearchiving FI-TV: Entries from PTRV_HEAD (Temporary)7SCHEMTrip schemanvarchar20
31PTRV_HEADGeneral Trip Data7SCHEMTrip schemanvarchar20
32PTRV_SBACKLOGTrip Statistics - Batch/Backlog Processing5SCHEMTrip schemanvarchar20
33T706STrip Schema3SCHEMTrip schemanvarchar20
34T706S_RECEIPTTrip Schemas: Assignment of Travel Expense Types3SCHEMTrip schemanvarchar20
35T706TNames for trip schema4SCHEMTrip schemanvarchar20
36T706Z1Single Field Control for Dialog4SCHEMTrip schemanvarchar20
37T706Z1_TXTText table: Individual Field Control for Dialog5SCHEMTrip schemanvarchar20
TOPTravel Planning
38FTPT_TM_MEMOMemo table for Travel Management4SCHEMTrip schemanvarchar20
39TA22BAssignment trip schema - travel plan type5SCHEMTrip schemanvarchar20