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

47 columns | Print definition?ERP 6.0  | QTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/QRFC_S_IDXqRFC Standard index table43QTYPEQueue Typenvarchar10
2/AIF/Q_STD_IDX_TqRFC Standard index table43QTYPEQueue Typenvarchar10
3P2B2_QTACCHCM Declustering B2 - Generating Absence Quotas8QTYPEAbsence Quota Typenvarchar20
4P2B2_QTTRANSHCM Declustering B2 - Transfer Pool for Quota Deduction8QTYPEAbsence Quota Typenvarchar20
5P2RR_RMPayroll Results: Table for Master data (SG)54QTYPEAbsence Quota Typenvarchar20
6T7AEPBS66Absence Type Limit Condition7QTYPENot usednvarchar20
7T7INLEMET_WT_MAPMap quota compensation method with WT for 267 infotype5QTYPEQuota type (attendance/absence quota)nvarchar10
8T7RUT577Russian Family Characteristics7QTYPEAbsence Quota Typenvarchar20
9T7RU_T559DRussian Validity Period: Absence Quotas for Default Values4QTYPEAbsence Quota Typenvarchar20
TOPBrazil
10T7BRCPWage type assignment for absence double compensation4QTYPEQuota type (attendance/absence quota)nvarchar10
11T7BRQCQuota compensation types4QTYPEQuota type (attendance/absence quota)nvarchar10
TOPClaims Management
12TBSFC001Facts capture: Question8QTYPEStructure Facts Capture: Question Categorynvarchar10
TOPCross-Application Topics
13/SPE/T_WME_QUEUEConfiguration of Q-RFC communication to EWM3QTYPEQueue Typenvarchar10
TOPFrance
14T5F2QQuota classification for France.2QTYPEAbsence Quota Typenvarchar20
TOPMonitoring
15ALQRFCMONDefine Additional Message Container for qRFC Queue Mon.16QTYPEqRFC Queue Type (Inbound/Outbound)nvarchar10
TOPNew Zealand
16PT0416Time Quota Compensation Infotype: Database Table27QTYPEAbsence Quota Typenvarchar20
TOPOccupational Health
17T7EHS00_QCATALOGQuestion Catalog3QTYPECatalog Entry Categorynvarchar20
TOPOLAP Technology
18RSR_CACHE_FFBCache, BLOB Tables: Storage for Selections6QTYPESingle-Character Indicatornvarchar10
TOPPayroll
19T5TL5Krácení kontingentu pro dovolenou v IT20065QTYPETyp kontingentu neprítomnostinvarchar20
20T7BGQ1Quota algorithm4QTYPEAbsence Quota Typenvarchar20
21T7SKL5Quota reduction for leave in IT20065QTYPEAbsence Quota Typenvarchar20
22T7SKL6Quota reduction for leave in IT20066QTYPEAbsence Quota Typenvarchar20
TOPPersonnel Time Management
23HRCCE_T_QR_PAIRSCE Shared Quotas : Grouping Rules for Different Quota Types2QTYPEAbsence Quota Typenvarchar20
24PA0416Time Quota Compensation Infotype: Database Table27QTYPEAbsence Quota Typenvarchar20
25T556RRules for Deduction Sequence for Absence Quotas4QTYPEQuota type (attendance/absence quota)nvarchar10
26T556STexts for Deduction Sequence Rules for Absence Quotas5QTYPEQuota type (attendance/absence quota)nvarchar10
27T556UAttendance/Absence Quota Compensation Types4QTYPEQuota type (attendance/absence quota)nvarchar10
28T556VTexts for Attendance/Absence Quota Compensation Types5QTYPEQuota type (attendance/absence quota)nvarchar10
29T556WWage Type Assignment for Att./Absence Quota Compensations5QTYPEQuota type (attendance/absence quota)nvarchar10
30T559DValidity/Deduction Interval for Absence Quotas4QTYPEAbsence Quota Typenvarchar20
31T559D_WEBESS Leave Request: Obsolete; Now T556A_WEB5QTYPEAbsence Quota Typenvarchar20
32T559EBase Entitlement for Leave Accrual5QTYPEAbsence Quota Typenvarchar20
33T559FProcessing of Absence Quota Remainders7QTYPEAbsence Quota Typenvarchar20
34T559LAutomatic Absence Quota Generation15QTYPEAbsence Quota Typenvarchar20
TOPPortfolio Management
35/RPM/QNNR_RESULTQuestionnaire Result9QTYPEQuestion Typenvarchar40
36/RPM/QSTN_CUSTQuestion Customer Attributes5QTYPEQuestion Typenvarchar40
TOPProduction Orders
37COCF_CONF_QTYConfirmation: Table for Subdivided Quantity Postings6QTYPEQuantity Type for Confirmationnvarchar10
38COCF_CU_Q_LINRows of Quantity/Error Combination4QTYPEQuantity Type for Confirmationnvarchar10
TOPPublic Sector
39T5QPBS2NOrgn change & simulation quota for Absence Quotas4QTYPEAbsence Quota Typenvarchar20
40T5QPBS2OImpact of Organizational change5QTYPEAbsence Quota Typenvarchar20
TOPRFC
41QRFCEVENTEvent Control in qRFC2QTYPECHAR01 data element for SYSTnvarchar10
42QRFCLOGTrace Description4QTYPECHAR01 data element for SYSTnvarchar10
43QRFCTRACETrace Description4QTYPECHAR01 data element for SYSTnvarchar10
TOPSouth Africa
44HRP1631DB Table for Infotype 163122QTYPEQualification typenvarchar30
45T5W8CQualifiaction types2QTYPEQualification typenvarchar30
46T5W8CTQualifiaction type text3QTYPEQualification typenvarchar30
47T5W8PStrategic Skills Priorities8QTYPEObject Typenvarchar20