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

51 columns | Print definition?ERP 6.0  | SCLAS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XLSO/WAITLISTxLSO Table for maintaining waitlist related data4SCLASType of Related Objectnvarchar20
2GRPC_UPG_HRP1001Backup Data21SCLASType of Related Objectnvarchar20
3T5FDSNSECTNDSN: references classes for section10SCLASnvarchar300
4T77PAOSESINFTCInfotype for Change Pointer Creation6SCLASType of Related Objectnvarchar20
5T77PAOSESINFTYInfotype for Change Pointer Creation5SCLASType of Related Objectnvarchar20
6TC30CWork center category screen selection5SCLASType of Related Objectnvarchar20
7ZRP1001Infotype 1001 DB Table21SCLASType of Related Objectnvarchar20
8PIQDBAGR_ASSIGNMAppraisal: Appraised Object15SCLASType of Related Objectnvarchar20
9T7PIQBW_DELTABW Extraction: Map Infotype <-> BW Data Source4SCLASType of Related Objectnvarchar20
10T7PIQ_GB_SOCIALMUCAS: Mapping table social class2SCLASSocial Classnvarchar20
TOPCommand and Support Relationships
11/ISDFPS/FORCMDIDSupply Relationship IDs6SCLASType of Related Objectnvarchar20
12/ISDFPS/FORMNTIDIDs of Maintenance Relationships6SCLASType of Related Objectnvarchar20
13/ISDFPS/FOROTHIDIDs of Other Relationships6SCLASType of Related Objectnvarchar20
14/ISDFPS/FORSUPIDSupply Relationship IDs6SCLASType of Related Objectnvarchar20
15/ISDFPS/ORCMDTask Organizations15SCLASType of Related Objectnvarchar20
16/ISDFPS/ORMNTMaintenance Relationships15SCLASType of Related Objectnvarchar20
17/ISDFPS/OROTHAdditional Relationships15SCLASType of Related Objectnvarchar20
18/ISDFPS/ORSUPSupply Relationships15SCLASType of Related Objectnvarchar20
19/ISDFPS/ORTOBTechnical Object Relationships (Maintenance)15SCLASType of Related Objectnvarchar20
TOPCross-Application Objects in HR
20HRP5586DB Table for Infotype 558618SCLASType of Related Objectnvarchar20
TOPDefense Forces and Public Security
21HRP1988DB Table for Infotype 198821SCLASType of Related Objectnvarchar20
TOPE-Recruiting
22HRP5131DB Table for Infotype 513119SCLASType of Related Objectnvarchar20
23HRP5132DB Table for Infotype 513226SCLASType of Related Objectnvarchar20
24HRP5152Database Table for Infotype 5152: Group Members19SCLASType of Related Objectnvarchar20
25T77RCF_AGENCYAgencies in E-Recruiting4SCLASType of Related Objectnvarchar20
TOPForce Element
26/ISDFPS/FORTOBIDIDs of Relationship to Technical Objects6SCLASType of Related Objectnvarchar20
TOPFrance
27HRP1681DB Table for Infotype 168122SCLASType of Related Objectnvarchar20
28HRP1683DB Table for Infotype 168321SCLASType of Related Objectnvarchar20
TOPHR Information Systems
29HRSEL_TABFIELDSTable Name and Field Name of Selection14SCLASType of Related Objectnvarchar20
TOPOrganizational Management
30HRP1001Infotype 1001 DB Table21SCLASType of Related Objectnvarchar20
31HRP1001_ARCHInfotype 1001: Inverse Relationship After Archiving21SCLASType of Related Objectnvarchar20
32HRT1221Table Part Infotype 1221 Excluded Activities4SCLASType of Related Objectnvarchar20
33T777BIRTHExrend relationship maintenance until birthday5SCLASType of Related Objectnvarchar20
34T77AWDefinition of Evaluation Paths8SCLASType of Related Objectnvarchar20
35T77EVExternal Relationships5SCLASType of Related Objectnvarchar20
36T77ITEXHierarchy Framework: Copy Object: Exclude Infotypes5SCLASType of Related Objectnvarchar20
37T77ITEX_CHierarchy Framework: Copy Object: Exclude Infotypes6SCLASType of Related Objectnvarchar20
38T77SOStructurally-Dependent Object Types5SCLASType of Related Objectnvarchar20
39T77ZRInfotype 1001 Time Constraint (Target Object Type-Dependent)5SCLASType of Related Objectnvarchar20
TOPPersonnel Categories
40/ISDFPS/OPRRELPermitted Relationships for Operational Readiness (IT 1988)4SCLASType of Related Objectnvarchar20
TOPSouth Africa
41T5W8ORegister of object links to their NQF appraisal models5SCLASType of Related Objectnvarchar20
TOPStaffing
42T777ACTIONActivities for special personnel actions4SCLASType of Related Objectnvarchar20
TOPStructural Graphics
43T77GFDefinition of Object Data6SCLASType of Related Objectnvarchar20
TOPStructures Workbench
44/ISDFPS/CFDPDA5Customizing of Title Element for Support Relationships6SCLASType of Related Objectnvarchar20
45/ISDFPS/CFDPDA5TText Table for Customizing Relationship Types7SCLASType of Related Objectnvarchar20
46HRP1955DB Table for Infotype 195518SCLASType of Related Objectnvarchar20
47HRP1985DB Talbe for Infotype 198518SCLASType of Related Objectnvarchar20
48PA0748HR Master Record Infotype 074825SCLASType of Related Objectnvarchar20
TOPTalent Needs Management
49HRP1689DB Table for Infotype 168918SCLASType of Related Objectnvarchar20
TOPTraining and Event Management
50HRP1023Infotype 1023 DB table26SCLASInstance object typenvarchar20
51T77VPLog File: Correspondence in Training and Event Management5SCLASObject type of recipientnvarchar20