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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

35 columns | Print definition?ERP 6.0  | PERYR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRP1789DB Table for Infotype 178918PERYRAcademic Yearnvarchar40
2HRP1798DB Table for Infotype 179818PERYRAcademic Yearnvarchar40
3HRP1707Database Table for Infotype 170722PERYRNote Reference to an Academic Yearnvarchar40
4HRP1739DB Table for Infotype 173918PERYRAcademic Yearnvarchar40
5HRP1750DB Table for Infotype 175018PERYRAcademic Yearnvarchar40
6HRPAD506Additional Data for PAD50618PERYRAcademic Yearnvarchar40
7HRPAD512Additional Data for PAD5123PERYRAcademic Yearnvarchar40
8HRPAD532Additional Data for PAD50814PERYRAcademic Yearnvarchar40
9HRPAD547Additional Data PAD5475PERYRAcademic Yearnvarchar40
10HRT1737Table Section for Infotype 173716PERYRAcademic Year for Progression Resultnvarchar40
11HRT1750Table Section for Infotype 17505PERYRAcademic Yearnvarchar40
12HRT1764Table Section for Infotype 17649PERYRAcademic Yearnvarchar40
13HRT1773Table Section for Infotype 177333PERYRAcademic Yearnvarchar40
14PIQDBCMPRRECORDSAssessment Process8PERYRAcademic Yearnvarchar40
15PIQDBEVOBOFFERScheduled Assessment5PERYRAcademic Yearnvarchar40
16PIQDBEVOBOFFER2Scheduled Assessment: Functions5PERYRAcademic Yearnvarchar40
17PIQDBEVOBOFFER3Scheduled Assessment: Location/Time5PERYRAcademic Yearnvarchar40
18PIQDBLMSLPIDLearning Product UUID - LMS4PERYRAcademic Yearnvarchar40
19PIQDBOFFERMP1Templates Copied for Academic Period3PERYRAcademic Yearnvarchar40
20PIQDBOFFERMP2Business Events Copied for Academic Period4PERYRAcademic Yearnvarchar40
21PIQPROC_ED_INT_WED Activity Document: Transferred Internal Academic Work18PERYRAssigned Academic Year of Internal Academic Work/Qualif.nvarchar40
22PIQPROC_PG_DTActivity Document: Progression Details17PERYRAcademic Year for Progression Resultnvarchar40
23PIQPROC_PG_MBActivity Document: Module Booking11PERYRAcademic Yearnvarchar40
24T7PIQOFFERPATDEFSession Pattern Definition4PERYRFirst Academic Yearnvarchar40
25T7PIQSTDYEARPRDStandard Academic Year/Session Assignments2PERYRAcademic Yearnvarchar40
26T7PIQYEARAcademic Years2PERYRAcademic Yearnvarchar40
27T7PIQYEARPRDAcademic Year/Session Assignments2PERYRAcademic Yearnvarchar40
28T7PIQYEARTText Table for Academic Years3PERYRAcademic Yearnvarchar40
29T7PIQ_NL_ENRNMMapping Table for Year/ Session and Enrollment Moment Code2PERYRAcademic Yearnvarchar40
30T7PIQ_US_APPFRMUS IPEDS: Customizing to Map Relavent Prior Reporting Years2PERYRAcademic Yearnvarchar40
31T7PIQ_US_PERIODUS IPEDS: Customizing table for Mapping periods2PERYRReporting Yearnvarchar40
32T7PIQ_US_PREPYRUS IPEDS: Customizing to Map Relavent Prior Reporting Years2PERYRAcademic Yearnvarchar40
33T7PIQ_US_PTINDXCustomizing to map Program Full time and Performance Index5PERYRAcademic Yearnvarchar40
34TCMACGRHDGrants Document Header3PERYRAcademic Yearnvarchar40
35TCMACGRITGrants Document Items4PERYRAcademic Yearnvarchar40