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

33 columns | Print definition?ERP 6.0  | TEXTS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T5A4Process Control for Continued Pay6TEXTSDescription of Agreementnvarchar200
2T5A4ODescription of Attendance/Absence Categories5TEXTSText (20 Characters)nvarchar200
3T5GPBS20TAbsence Evaluation: Texts for Check Window End Definition5TEXTSAbsence Evaluation: Text for Check Window End Rulesnvarchar300
4T5GPBS21TAbsence Evaluation: Texts for Check Window Start Definition5TEXTSAbsence Evaluation: Text for Check Window Start Rulesnvarchar300
5T5GPBS22TAbsence Evaluation: Texts for Qualifying Day Rule Definition5TEXTSAbsence Evaluation: Text for Non Qualifying Day Rulesnvarchar300
6T5GPBS24TAbsence Evaluation: Texts for Time Unit Factor Definition5TEXTSAbsence Evaluation: Text for Time Unitsnvarchar300
7T5GPBS26TAbsence Evaluation: Texts for Qualifying Payment Days7TEXTSAbsence Evaluation: Text for Non Payment Day Rulesnvarchar300
8T5GPBS30TAbsence Evaluation: Texts for Limit Rules5TEXTSAbsence Evaluation: Text for Limit Rulesnvarchar300
9T7QA60FTexts for Rule Group about Qatar Furniture Return4TEXTSText (30 Characters)nvarchar300
10T7QA60HTexts for Rule on Qatar Furniture Return7TEXTSText (30 Characters)nvarchar300
11T7QA70TDocument Provision Category Text4TEXTSText (30 Characters)nvarchar300
12T7QA72TDocument Renewal Provision Text8TEXTSText (30 Characters)nvarchar300
TOPBasic Functions
13FEBEPElectronic Bank Statement Line Items25TEXTSText keynvarchar40
TOPContract Accounts Receivable and Payable
14FKKBEPElectronic Bank Statement Line Items25TEXTSText keynvarchar40
TOPCost Center Accounting
15KPPTTCO Planning: Text table for entity table. planning areas4TEXTSShort Field Labelnvarchar100
TOPFinancial Accounting
16AVIKPayment Advice Header40TEXTSText keynvarchar40
17TNAMNPuffer for Keywords (NAMETAB)4TEXTSShort textnvarchar100
TOPGreat Britain
18T5GQDPTQDP Text table4TEXTSText (30 Characters)nvarchar300
TOPInternational Functions for the Public Sector
19T7PBSDEC_WTGRPTXDEC: Wage Type Group Definition Description5TEXTSXDEC: Text for Base Wage Type Groupingsnvarchar300
TOPPayroll
20T5T4EText of report parameters7TEXTSHeader text of a reportnvarchar150
21T5T4GParameter configuration personal reportts for output by ALV10TEXTSHeader text of a reportnvarchar150
22T5TPSCMTABHRCZ Public sector multitable9TEXTSText 30 místnvarchar300
23T7RO4EReporting engine - Parameter texts7TEXTSText in headernvarchar150
24T7RO4GReporting engine - optional field names8TEXTSText in headernvarchar150
25T7SI4EText of report parameters7TEXTSHeader text of a reportnvarchar150
26T7SK4EText of report parameters7TEXTSHeader text of a reportnvarchar150
27T7SK4GKonfigurace parametru personálních sestav pro výpis v ALV10TEXTSText v nadpise zostavynvarchar150
28T7SKMTABHRCZ Public sector multitable9TEXTSText 30 miestnvarchar300
TOPPersonnel Time Management
29T554OValuation Classes5TEXTSText (20 Characters)nvarchar200
30T556FTexts for Rule Group (Coverage Package)5TEXTSText (30 Characters)nvarchar300
31T556HTexts for Rule on Determining the Coverage History8TEXTSText (30 Characters)nvarchar300
TOPStructures
32PSHLP_CUST_DPROFData Selection Profile6TEXTSTextnvarchar10
33PSHLP_DATASET_DBTo store the user specific datasets chosen7TEXTSSingle-Character Indicatornvarchar10