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

35 columns | Print definition?ERP 6.0  | SOBID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XLSO/WAITLISTxLSO Table for maintaining waitlist related data5SOBIDID of Related Objectnvarchar450
2GRPC_UPG_HRP1001Backup Data22SOBIDID of Related Objectnvarchar450
3ZNOTIF_POSPosition created for the General Notification3SOBIDID of Related Objectnvarchar450
4ZRP1001Infotype 1001 DB Table22SOBIDID of Related Objectnvarchar450
5PIQDBAGR_ASSIGNMAppraisal: Appraised Object16SOBIDID of Related Objectnvarchar450
TOPCommand and Support Relationships
6/ISDFPS/FORCMDIDSupply Relationship IDs7SOBIDID of Related Objectnvarchar450
7/ISDFPS/FORMNTIDIDs of Maintenance Relationships7SOBIDID of Related Objectnvarchar450
8/ISDFPS/FOROTHIDIDs of Other Relationships7SOBIDID of Related Objectnvarchar450
9/ISDFPS/FORSUPIDSupply Relationship IDs7SOBIDID of Related Objectnvarchar450
10/ISDFPS/ORCMDTask Organizations16SOBIDID of Related Objectnvarchar450
11/ISDFPS/ORMNTMaintenance Relationships16SOBIDID of Related Objectnvarchar450
12/ISDFPS/OROTHAdditional Relationships16SOBIDID of Related Objectnvarchar450
13/ISDFPS/ORSUPSupply Relationships16SOBIDID of Related Objectnvarchar450
14/ISDFPS/ORTOBTechnical Object Relationships (Maintenance)16SOBIDID of Related Objectnvarchar450
TOPCross-Application Objects in HR
15HRP5586DB Table for Infotype 558619SOBIDID of Related Objectnvarchar450
TOPDay-to-Day Activities
16LSOCRPRECGUIDRecipient: GUID Admin. for Business Partner Simulation5SOBIDID of Related Objectnvarchar450
TOPDefense Forces and Public Security
17HRP1988DB Table for Infotype 198822SOBIDID of Related Objectnvarchar450
TOPE-Recruiting
18HRP5131DB Table for Infotype 513120SOBIDID of Related Objectnvarchar450
19HRP5132DB Table for Infotype 513227SOBIDID of Related Objectnvarchar450
20HRP5152Database Table for Infotype 5152: Group Members20SOBIDID of Related Objectnvarchar450
21T77RCF_AGENCYAgencies in E-Recruiting5SOBIDID of Related Objectnvarchar450
TOPForce Element
22/ISDFPS/FORTOBIDIDs of Relationship to Technical Objects7SOBIDID of Related Objectnvarchar450
TOPFrance
23HRP1681DB Table for Infotype 168123SOBIDID of Related Objectnvarchar450
24HRP1683DB Table for Infotype 168322SOBIDID of Related Objectnvarchar450
TOPOrganizational Management
25HRP1001Infotype 1001 DB Table22SOBIDID of Related Objectnvarchar450
26HRP1001_ARCHInfotype 1001: Inverse Relationship After Archiving22SOBIDID of Related Objectnvarchar450
27HRT1221Table Part Infotype 1221 Excluded Activities5SOBIDID of Related Objectnvarchar450
TOPSouth Africa
28T5W8ORegister of object links to their NQF appraisal models6SOBIDID of Related Objectnvarchar450
TOPStructures Workbench
29HRP1955DB Table for Infotype 195519SOBIDID of Related Objectnvarchar450
30HRP1985DB Talbe for Infotype 198519SOBIDID of Related Objectnvarchar450
31PA0748HR Master Record Infotype 074826SOBIDID of Related Objectnvarchar450
TOPTalent Needs Management
32HRP1689DB Table for Infotype 168919SOBIDID of Related Objectnvarchar450
TOPTraining and Event Management
33T77REFDOCReference Document Table: Training and Event Management15SOBIDID of Related Objectnvarchar450
34T77VPLog File: Correspondence in Training and Event Management6SOBIDObject ID of recipientnvarchar450
TOPTraining Management
35LSOCPSCORMLVALUETable for Saving Learner-Dependent Character Strings4SOBIDID of Related Objectnvarchar450