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

64 columns | Print definition?ERP 6.0  | OPERA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRICP_D_CH_PTRChange Pointer for Infotype Changes19OPERAOperation Indicatornvarchar10
2HRSFI_D_RCT_REQChange Pointer Table for Job Requisitions10OPERAOperation Indicatornvarchar10
3T589AStatus and Input Mode in Screen Painter Screens2OPERAInfotype operationnvarchar200
4T5A2MDamaging Actions/Reasons2OPERAOperation Indicatornvarchar10
5T77KZD3Limit Rules8OPERAProcessing indicatornvarchar10
6T77PAODYDAMAPMapping View: Dynamic Actions to Dynamic Processing Rules5OPERAFunction character of stepnvarchar20
7T77PAYRUWTGRPWPYD: Wage Type Group Wage Type Assignment6OPERAOperationnvarchar10
8T7AEPBS22Service Duration Deduction9OPERAService Duration Operatornvarchar10
9T7AEPBS23Service Duration Deductions / Additions12OPERAService Duration Operatornvarchar10
10T7RUSSAB_OPERType of Sickness Certificate -> Absences Subtypes Mapping3OPERASpecial Operation ID for Subtype Mappingnvarchar10
11TKCKOFormula Operators1OPERAArithmetic operator for key figuresnvarchar30
12TKCTOLanguage Table: Formula Operators2OPERAArithmetic operator for key figuresnvarchar30
13TVGZUView Control: Special Table Access8OPERAOperator for HERFD and BISFDnvarchar10
TOPAustria
14T5A7DPayslip Checking Rules6OPERACheck Operationnvarchar50
TOPBalanced Scorecard
15UMB_SC164Scorecard: Formula to Calculate the Status of a Measure5OPERAFormula Operatornvarchar50
TOPBelgium
16T5BSB1HR-Belgium: Social Balance SAP Code Attributes12OPERAOperationnvarchar30
TOPCompensation Management
17T510DDynamic Standard Pay Increase13OPERAOperation indicator for indirect valuationnvarchar10
TOPContract Accounts Receivable and Payable
18FKKPREPACC_CLOSEPrepaid Account: Trigger for Closing Operations4OPERAPrepaid Account: Operation with Action Event or Write-Offnvarchar10
TOPCorporate Performance Monitor
19UMC_GS111Formula Detail4OPERAFormula Operatornvarchar50
20UMK_MB200Measure Formula4OPERAFormula Operatornvarchar50
TOPData Collection
21TKCKFKey Figure Formula Stages7OPERAArithmetic operator for key figuresnvarchar30
TOPEnd User Technology
22RSZCALCDefinition of a formula element4OPERAFormula operatornvarchar50
TOPExpenditure Certification
23FMEUFAUDAuditing (Operation)2OPERAOperation Identificationnvarchar240
24FMEUFCERTINFOCertification Run Info6OPERAOperation Identificationnvarchar240
25FMEUFEXPCertified Expenditure Documents9OPERAOperation Identificationnvarchar240
26FMEUFLNKFinancing Source and Operation Link2OPERAOperation Identificationnvarchar240
27FMEUFOPHDefine Operation Header2OPERAOperation Identificationnvarchar240
28FMEUFOPLOBSOLETE Define Operation Lines2OPERAOperation Identificationnvarchar240
29FMEUFOPPFPerformance Indicator per Operation2OPERAOperation Identificationnvarchar240
30FMEUFOPTDefine Operation Header - Text Table2OPERAOperation Identificationnvarchar240
TOPGreat Britain
31T5G15Court Order Deductions4OPERAFunction character of stepnvarchar10
TOPHR Administrative Services
32T5ASRDABHISTORYMaster Data Changes By User10OPERAOperation Indicatornvarchar10
TOPInformation System
33T007KTable for Grouping Tax Basis Balances8OPERAType of Arithmetical Operationnvarchar10
34T007LTable for Grouping Tax Balances8OPERAType of Arithmetical Operationnvarchar10
TOPItaly
35T5ITCIWT which form the tax base9OPERABase calculation operatornvarchar10
36T5ITPBEvaluation of calculation base - Italy only8OPERABase calculation operatornvarchar10
37T5ITWCConditions8OPERAOperator in a selection condition (screen field)nvarchar80
TOPKorea
38T7KRS1Weighted value for service period6OPERAOperatornvarchar30
TOPLocalization
39IDCN_ACCITEMChina Golden Audit Interface: Account Lines9OPERAType of arithmetical operationnvarchar10
40IDCN_TOTLINEChina Golden Audit Interface: Subtotal lines6OPERAType of arithmetical operationnvarchar10
TOPMexico
41T7MX18Wage types for forming the state tax basis7OPERAArithmetic symbolnvarchar10
TOPPatient Management
42TN14BIS-H: Movement types13OPERAIS-H: Indicator for Admission Type "Surgery"nvarchar10
TOPPayroll
43T5HAACumulation interrelations8OPERAOperation 2nvarchar30
44T7UAD3Limit Rules8OPERAProcessing indicatornvarchar10
TOPPayroll General Parts
45T51D4Limit Rules7OPERAProcessing indicatornvarchar10
TOPPension fund General Parts
46T5CAEPC Operations3OPERAPC operationnvarchar20
47T5CAFOperation Descriptions4OPERAPC operationnvarchar20
48T5CAGPC Method Definitions11OPERAPC operationnvarchar20
49T5CAKPC: Text Templates for Operation Conditions4OPERAPC operationnvarchar20
50T5CAKEPC: Text Templates for Operation Conditions3OPERAPC operationnvarchar20
51T5CALPC: Operation Parameter Descriptions3OPERAPC operationnvarchar20
52T5CAMOperation Parameter Names4OPERAPC operationnvarchar20
53T5CBNMessages for PC Operation Conditions4OPERAPC operationnvarchar20
TOPPeriodical Sales and Distribution
54TJ181IS-M: GUI Status Control for Function Code Exclusion4OPERAOperation on current screennvarchar40
TOPPersonnel Administration
55T531Deadline Types6OPERAOperator for Task Typesnvarchar10
56T588ZDynamic Actions5OPERAFunction character of stepnvarchar20
TOPPersonnel Time Management
57T554CAbsence Valuation140OPERAOperation IDnvarchar10
TOPPreconfigured Systems
58ZHRBPJPT_ITLOG35OPERA????nvarchar10
TOPReuse Services for Country Development
59T5F99FGForms: Source field groups8OPERAArithmetic symbolnvarchar10
60T5F99FWForms: Wage type source group definition11OPERAArithmetic symbolnvarchar10
61T5F99FXForms: Wage type source group customer extension11OPERAArithmetic symbolnvarchar10
TOPRussia
62T7RUD3Limit Rules8OPERAProcessing indicatornvarchar10
TOPSales Plan
63ERPOEvent Item7OPERAOperatornvarchar20
TOPSpain
64T5E67Special contracts according to Social Insurance7OPERAOperator in a selection condition (screen field)nvarchar80