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

46 columns | Print definition?ERP 6.0  | INFOTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/NAKISA/CTRLINFOControl Info Table1INFOTYPEInfoType Structurenvarchar200
2/NAKISA/PESEINFOSecurity Info Table1INFOTYPEInfoTypenvarchar40
3/XFT/EPA_CDTALDocument types: Alias/visibility12INFOTYPEInfotypenvarchar40
4/XFT/EPA_T0002Customizing header data7INFOTYPEInfotypenvarchar40
5/XFT/EPA_T0005Visibility of Document Types by Infotype6INFOTYPEInfotypenvarchar40
6/XFT/EPA_T0017Visibility file info types5INFOTYPEInfotypenvarchar40
7/XFT/EPA_T0018Visibility folder for info type6INFOTYPEInfotypenvarchar40
8GRFNFLDHRHR Configurable Fields3INFOTYPEInfotypenvarchar40
9PAOCFEC_EXTMAPEmployee Central Extensibility Mapping Configuration4INFOTYPEInfotypenvarchar40
10PAOCFEC_S_INFTYAllowed Infotypes for Extensibility Mapping2INFOTYPEInfotypenvarchar40
11T77PAO_DRPAITPA Infotype Fields for Data Retrieval3INFOTYPEInfotypenvarchar40
12T77SFEC_EXTMAPEmployee Central Extensibility Mapping Configuration4INFOTYPEInfotypenvarchar40
13T77SFEC_S_INFTYAllowed Node Names for Extensibility Mapping2INFOTYPEInfotypenvarchar40
14T7CNRMP_CUST_PDConfiguration Table for Fields in Organization Management3INFOTYPEInfotypenvarchar40
15T7CNRMP_DETITMDetermining Factor Item10INFOTYPEInfotypenvarchar40
16T7CNRMP_RPTGRPGrouping Dimension for Report12INFOTYPEInfotypenvarchar40
17T7CNRMP_RPTSTAStatistical Dimension for Report25INFOTYPEInfotypenvarchar40
18T7CNRMP_TEXTMAPMapping Table of the Corresponding Text Table and Text Field2INFOTYPEInfotypenvarchar40
19T7CNRMP_VALUEITMValue Item of Statistical Item with Value Reading Type11INFOTYPEInfotypenvarchar40
20T7UN_ESS_ATTCHNPO : Details of attachments for ESS Scenarios3INFOTYPEInfotypenvarchar40
21T7UN_ESS_WFLOWNPO : Details of workflows triggered from ESS3INFOTYPEInfotypenvarchar40
22TEWADMRCHECKSettings For "Actual Follow-On Doc" Check Of Debit Memos3INFOTYPEMessage Typenvarchar10
TOPBasic Functions
23UKM_INFOTYPInfo Types3INFOTYPEType of Additional Information for Business Partnernvarchar20
24UKM_INFOTYP0TTexts for Info Types4INFOTYPEType of Additional Information for Business Partnernvarchar20
TOPCommon Parts
25T7XSSPERBIZFLDAvailable fields on bizcards on PersInfo Overview screen2INFOTYPEInfotypenvarchar40
26T7XSSPERBIZFLDCCustomize fields for bizcards on PersInfo Overview screen2INFOTYPEInfotypenvarchar40
27T7XSSPERBIZFLDCTText table for T7XSSPERBIZFLDC3INFOTYPEInfotypenvarchar40
28T7XSSPERBIZFLDTText table for T7XSSPERBIZFLD3INFOTYPEInfotypenvarchar40
29T7XSSPERSUBTYPEInfotypes and Subtypes for ESS PersInfo3INFOTYPEInfotypenvarchar40
TOPDB2 for OS39
30DB2COPYIDB2 copy information from SYSIBM.SYSCOPY1INFOTYPEnvarchar100
TOPE-Recruiting
31T77RCF_WL_SELPossible Selection Fields in Worklists3INFOTYPEInfotypenvarchar40
TOPEmployee Self-Service for Concurrent Employment
32T7XSSSERINFTYInfotype for ESS PersInfo Services2INFOTYPEInfotypenvarchar40
TOPForms
33TMETASTAR_I02HR Forms: Read Data for Infotypes2INFOTYPEInfotypenvarchar40
TOPGRC Access Control Plug-In
34/VIRSA/FLDMAPHR Triggers - Field Mapping4INFOTYPEInfotypenvarchar40
TOPJapan
35T7JPBP_CALDECDecision Factor4INFOTYPEInfotypenvarchar40
36T7JPBP_PNTTYPRetirement Benefit Point Type4INFOTYPEInfotypenvarchar40
37T7JPCP_CBDECDecision Factors for Re-assessment Rate4INFOTYPEInfotypenvarchar40
38T7JPCP_CLBSDASCalculation Basis Parameter Basic Pay Data Source5INFOTYPEFixed infortype Source for Calc.Basis Para. Basic Paynvarchar40
39T7JPCP_CLDECFCDecision Factor4INFOTYPEInfotypenvarchar40
40T7JPCP_PRDECFCDecision Factors for Premium Rate/Amount4INFOTYPEInfotypenvarchar40
TOPManagement of Global Employees
41T76MGE_DITStorage of Document Types4INFOTYPEInfotypenvarchar40
42T76MGE_FACFactors for compensation packages3INFOTYPEInfotypenvarchar40
43T76MGE_MAPMapping Table from Global Employees to Standard7INFOTYPEInfotypenvarchar40
TOPPerformance Assessment Workbench
44SLS_PARINFPAW - Participant Information5INFOTYPEPAW - Participant Info Typenvarchar20
TOPPersonnel Time Management
45PTARQ_DIRESA: Interface Table for Infotypes (Directory Table)4INFOTYPEInfotypenvarchar40
46PTREQ_ATTABSDATARequest Data for Attendances/Absences4INFOTYPEInfotypenvarchar40