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

142 columns | Print definition?ERP 6.0  | CDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/DRM_RESULTSData Readyness Monitoring - Results7CDATEField of type DATSnvarchar80
2/SDF/DRM_RES_DEData Readyness Monitoring - Results Details7CDATEField of type DATSnvarchar80
3/XFT/MIG_TDOCDocument head6CDATECreation datenvarchar80
4/XFT/MIG_TDOCPOSDocument head7CDATECreation datenvarchar80
5BBP_NEWVD_LOGList of Newly Created Vendors5CDATECreation date of the change documentnvarchar80
6BOE_COUNT_HEADERBOE Count Header5CDATECounting date for Boe Recievablenvarchar80
7BOE_D_EXCEPTException Data of BOE Counting7CDATECounting date for Boe Recievablenvarchar80
8BOE_D_INVENTORYMaking inventory of bill of exchange receivable7CDATECounting date for Boe Recievablenvarchar80
9BOE_D_LOCKLock Data of BOE Counting8CDATECounting date for Boe Recievablenvarchar80
10BUBAS_LOG_STOREStored Application Logs6CDATEDate data element for SYSTnvarchar80
11CNVMBTCOTOBJECTSLO Central Object Table10CDATESLO COT Creation Datenvarchar80
12CNV_10940_HEADAnalyze report variants7CDATEDatenvarchar80
13CNV_10940_RUN_IDSearch Run IDs created in Sol Man for RVS7CDATEDatenvarchar80
14DDCNVCOUNTDD: Logeinträge der inkrementellen Umsetzungen protokolliere2CDATEDatumnvarchar80
15DFKKEPRTLog for Inconsistent FI-CA Documents34CDATEChanged Onnvarchar80
16DFKK_TRIGX_CLOutbound Interface: New Trigger Table of Cleared Items15CDATESystem Datenvarchar80
17DFKK_TRIGX_OPOutbound Interface: New Trigger Table for Business Partner11CDATESystem Datenvarchar80
18DFKK_TRIGX_PAYOutbound Interface: New Trigger Table for Payment Info21CDATESystem Datenvarchar80
19DFKK_TRIGX_RCLOI: New Trigger Table for Reopened Items17CDATESystem Datenvarchar80
20HRPAD00_SEPA_UPDFlag SEPA Mandates to Be Updated5CDATEDatenvarchar80
21LTR_VERSION_LOGLTR_VERSION_LOG6CDATEnvarchar80
22RSAUFILESList of Created Audit Log Files1CDATEnvarchar80
23SAIS_LOGLog for Usage of Audit Log6CDATEModification datenvarchar80
24SSF_PSE_HISTPSE History8CDATEModification datenvarchar80
25SSF_PSE_LConfiguration Table for PSE File Mode6CDATEModification datenvarchar80
26STODOINFInformationen zu TODO Meldungen14CDATEDatum der letzten dokumentierten Änderungennvarchar80
27T512ISystem Documentation - Kwic Index7CDATEChanged Onnvarchar80
28T512VRPDSYS00 - Cross References12CDATEChanged Onnvarchar80
29T5BSDOG0SDoG: Historical and External Data12CDATESDoG: Declaration Creation Datenvarchar80
30T7CNRM_DREPORTReport with Dynamic Rows or Columns6CDATECreated Onnvarchar80
31ZSE_CLONE_STATUSClone Status of system5CDATEDate data element for SYSTnvarchar80
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
32TCNVConversion Table for Logging the Conversion Steps13CDATEDatenvarchar80
TOPALE Integration Technology
33BDLSHDRHeader Data for Conversion of Logical System Names12CDATEDate data element for SYSTnvarchar80
TOPBelgium
34T5BDI0HR-BE: Dimona Central Table25CDATEDeclaration Creation Datenvarchar80
35T5BSB0HR-BE: Social Balance Historical and External Data11CDATEDeclaration Creation Datenvarchar80
36T5BSDSI Declaration: directory table7CDATECreation date SI declarationnvarchar80
TOPBudget Management
37HRPMPROTHR-FPM Log Table20CDATEDatenvarchar80
TOPCanada
38T5KRMCanadian Tax Remittance Form PD7A Data14CDATEDatenvarchar80
TOPCollectionsDisbursements
39DVIINFOInformation Data6CDATESystem Datenvarchar80
40VVKKEXPTRIGGERTrigger for Expiry Notes11CDATESystem Datenvarchar80
TOPCompensation Management
41T71LB1Award11CDATECancellation datenvarchar80
TOPConsumption-Based Planning See Also PP-MRP
42MDRDDelivery Relationships: Recipients per Plant and Material6CDATEDelivery Relationship: Creation Datenvarchar80
43MDRD_EXTWGDelivery Relationships: Recipients per Plant and Material6CDATEDelivery Relationship: Creation Datenvarchar80
44WDRDDelivery Relationships: Recipients per Plant and Material6CDATEDelivery Relationship: Creation Datenvarchar80
45WDRD_EXTWGDelivery Relationships: Recipients per Plant and Material6CDATEDelivery Relationship: Creation Datenvarchar80
TOPContract Accounts Receivable and Payable
46DFKKDOCFI-CA DMS: Administrative Data of Documents11CDATECreated Onnvarchar80
47DFKKFWBEWManagement Data for Foreign Currency Valuations8CDATESystem Datenvarchar80
48DFKKFWBEW_LDManagement Data for Ledger-Specific Foreign Crcy Valuations9CDATESystem Datenvarchar80
49DFKKFWTRIGTrigger Table for Inverse Postings4CDATESystem Datenvarchar80
50DFKK_TRIGGER_CLOutbound Interface: Trigger Table of Cleared Items14CDATESystem Datenvarchar80
51DFKK_TRIGGER_OPOutbound Interface: Trigger Table for Business Partner10CDATESystem Datenvarchar80
52DFKK_TRIGGER_PAYOutbound Interface: Trigger Table for Payment Information20CDATESystem Datenvarchar80
53DFKK_TRIGGER_RCLOutbound Interface: Trigger Table for Reopened Items16CDATESystem Datenvarchar80
TOPContract Billing
54BREBI_BILLP_T003Error Log Table3CDATECreated onnvarchar80
55BREBI_BILMS_T003Error Log Table only for Master Installation3CDATECreated onnvarchar80
TOPControlling
56QISROBJECTInternet Service Request: Object Key Table8CDATECreated Onnvarchar80
TOPCorrespondence Tool
57DFKKCOHCorrespondence - Correspondence Header5CDATECreated Onnvarchar80
58DFKKCOHICorrespondence - Correspondence History10CDATECreated Onnvarchar80
TOPCustomer Interaction Center
59CCMCLBSCall center callback - Whole17CDATECall center callback - Creation datenvarchar80
TOPData Retention Tool
60TXW_C_V0Data view: Header13CDATESystem Datenvarchar80
61TXX_ADMI_VWDART Administration: Tax View File14CDATECreation Datenvarchar80
62TXX_C_V0View: Header Area10CDATESystem Datenvarchar80
TOPData Staging
63RSTRAN_R_CURRCurrency Translations for Transformation Runtime Unit Test7CDATEValid-From Datenvarchar80
TOPData Transfer
64T51A1HR: Final Date for HR Postings (Accruals)5CDATEFinal date for postings from HRnvarchar80
TOPDenmark
65T5MY0HR-DK: Year-End Activities for PBS4CDATEDate of Copying the Company's Master Data Recordnvarchar80
TOPeCATT Extended Computer Aided Test Tool
66ECTP_JOB_LISTForeground Scheduler: List of test executions8CDATETest Proxy: Creation date of job entry for executionnvarchar80
TOPEnergy Data Management
67EFORMULAINSTCALCISU EDM Control Data for Calculation Run Number (DB Table)4CDATECreated onnvarchar80
68EFORMULATRIGKMPISU EDM Compressed Trigger File for Formula Inst. (DB Table)7CDATEDate on Which Record Was Creatednvarchar80
TOPEnterprise Service Framework Layer
69SCOOLOBJECTSObject Pattern Model4CDATECreated onnvarchar80
TOPGRC Process Control Plug-in
70/GRCPI/GRIAREPTSAM - Authorized ABAP Reports5CDATEDatenvarchar80
TOPI18N Unicode
71UM4BATTABInfos about running batchjobs3CDATEnvarchar80
72UM4LOCKTable for Synchronization of Worker Jobs5CDATEnvarchar80
73UM4PMBATInfo on Running Background Jobs5CDATEnvarchar80
74UMGBATTABInfos about running batchjobs3CDATEStart Datenvarchar80
75UMGLOCKTable for Synchronization of Worker Jobs5CDATEDatenvarchar80
76UMGPMBATInfo on Running Background Jobs5CDATEDatenvarchar80
TOPInternet Communication Framework
77ICFAPPLICATIONICF: Application Table for Creating Service with API10CDATECreated onnvarchar80
78ICFATTRIBDescription of ICF Attributes (Trace/Debugging)9CDATESystem Datenvarchar80
79ICFINSTACTICF: Table for Activating Services in Installation9CDATESystem Datenvarchar80
TOPJoint Venture und Production Sharing Accounting
80T8J6NJV EDI Processed Partners/Ventures9CDATEDatenvarchar80
TOPLocalization
81J_3RSEXTRACTDExctract details (obsolete)6CDATEContract datenvarchar80
TOPMobiles User Interface
82PUSHLOGWAP Push Logging2CDATEDatenvarchar80
TOPMonitoring
83SGLWLSLISTSAP Workload: User-Specific System List for Global Analysis14CDATEDatenvarchar80
TOPNon Profit Organizations
84T7UN_T52CDSchema-Directory6CDATEErstellungsdatumnvarchar80
TOPNorway
85T5V7BMessages sent to employees/emplyoers register8CDATEDate the message to the AA-register was invalidated/correctdnvarchar80
TOPOLAP Technology
86RSCURTRTCurrency Translation Types8CDATEValid-From Datenvarchar80
TOPPackage Tools
87PAKDATBUFBufferung for Package Attributes (EXPORT TO SHARED BUFFER)4CDATE(8-character) Date for SYSTnvarchar80
TOPPayroll
88T5TPSDPPROPrirazení datových prvku st.stát.inf.syst. k výstupum8CDATEDatum poslední zmenynvarchar80
89T5TPSDPSISPrevodní tabulka datových prvku stand. státního inf.syst.12CDATEDatum poslední zmenynvarchar80
TOPPayroll General Parts
90T514DForm Index8CDATECreated onnvarchar80
91T52CCDirectory of Customer Schemas7CDATECreated onnvarchar80
92T52CDSchema Directory7CDATECreated onnvarchar80
93T52CEDirectory of Personnel Calculation Rules5CDATECreated onnvarchar80
TOPPerformance Assessment Workbench
94SLS_RTESTPAW - Participant's Aggregated Test Results3CDATEField of type DATSnvarchar80
95SLS_YTESTPAW - Participant's Aggregated Test Results3CDATEField of type DATSnvarchar80
TOPPersonnel Administration
96T513IRPDSYS00 - KWIC Index8CDATEChanged Onnvarchar80
97T513VRPDSYS00 - Cross References13CDATEChanged Onnvarchar80
TOPPreconfigured Systems
98ZHRBPJPT_ITLOG37CDATE??nvarchar80
TOPProduct Cost Planning
99CKQS_MAP_IDMapping of Costing Run ID + Data Basis to Variant9CDATEField of type DATSnvarchar80
TOPProduction Orders
100COMPHOCM: Comparison result (header entry)6CDATECreated onnvarchar80
TOPProfile Maintenance
101TPFYPROPTYParameter attributes17CDATEData part last profile generationnvarchar80
TOPPurchase Orders
102WBO5Calculated Actual Vendor Service Level10CDATECalculation date for the actual vendor service levelnvarchar80
TOPPurchasing
103TEMPLATE_HEADERHeader Data: Template5CDATEDate on Which Record Was Creatednvarchar80
TOPRetention Warehouse
104IWP_DB_AREAAudit Areas4CDATECreated Onnvarchar80
105IWP_DB_REPOSRetention Warehouse: Repository4CDATECreated Onnvarchar80
106IWP_DB_SETSet of tables4CDATECreated Onnvarchar80
107IWP_WPPAudit Package Template5CDATECreated Onnvarchar80
108IWP_WP_JOBJobs for the Backgroundprocessing7CDATECreated Onnvarchar80
109IWP_WP_LOGLog for Backgroundprocessing5CDATECreated Onnvarchar80
TOPReuse Services for Country Development
110PA3228XSS Online Election29CDATEChanged Onnvarchar80
TOPRFC
111QRFCLOGTrace Description16CDATESystem Datenvarchar80
112QRFCTRACETrace Description16CDATESystem Datenvarchar80
TOPSales and Distribution
113J_1USEXTRACTDEXTRACTD6CDATEnvarchar80
TOPSecure Network Communications
114RFCDESSECUSNC extensions for RFC destinations7CDATEModification datenvarchar80
115SNCSYSACLSNC Access Control List (ACL): Systems12CDATEModification datenvarchar80
116TXCOMSECUSNC extension for CPIC destinations6CDATEModification datenvarchar80
117USRACLSNC Access Control List (ACL): User8CDATEModification datenvarchar80
118USRACLEXTExtended SNC Access Control List (ACL) for Users8CDATEModification datenvarchar80
119USREXTIDAssignment of External ID to Users11CDATEModification datenvarchar80
120USREXTIDHExternal ID (Access Using Hash Value)5CDATEModification datenvarchar80
TOPSecure Store and Forward
121SSF_PSE_HSSF: Personel Security Environment7CDATEModification datenvarchar80
TOPSecurity
122RSAUPROFAudit: Audit configuration parameters (audit profile)10CDATESecurity Audit: Date when the audit profile was changednvarchar80
TOPSweden
123T5S0SMessages for sickness administration (SE)8CDATEDate the message to the AA-register was invalidated/correctdnvarchar80
TOPTax Reporter
124T51T9Tax pay dates5CDATEPay date for payroll resultnvarchar80
TOPThird Party Remittance
125T51R1Remittance evaluation run data6CDATEDate Specifications Per Payroll Periodnvarchar80
TOPTime Sheet
126PTRV_WAFLOGLog File for Inbound Container in Travel Management5CDATEChanged Onnvarchar80
TOPTransaction Manager
127THMEXT_PLANNERE-HA: Hedge Plan9CDATEDatenvarchar80
TOPTranslation Tools
128LWRKSTASOUSLLS: Source Languages for OTR Translation Statistics7CDATEDate of Last Changenvarchar80
129TRMAUTTable for Storing the Parameters for Automatic Distribution11CDATEDatenvarchar80
130TRMMAPPUser values storage table4CDATEDatenvarchar80
131TRMSTMAValues of Settings for Screens in Transaction STMA72CDATEDatenvarchar80
TOPUpgrade Tools
132DDCDIMDD: Conversion, number of table lines4CDATEDatenvarchar80
133DDCNVSTATDD: Statistical Data for Conversion2CDATEField of type DATSnvarchar80
134DDCSTADD: Conversion, number of table lines2CDATEDatenvarchar80
135DDSTATHISTDD: Statistical Data for Conversion2CDATEField of type DATSnvarchar80
136TICNVDD: Status of Incremental Conversions49CDATEDatenvarchar80
TOPUser and Authorization Management
137USR07Object/values of last authorization check that failed27CDATEDatenvarchar80
TOPVehicle Management System
138VLC_DBCONSTATUSVELO : Status of LiveCache Connection5CDATEDatenvarchar80
TOPWaste Management
139EEWA_CAPAB_KEYIS-U Waste: Capacity Planning - Key and Index Table3CDATEDatenvarchar80
TOPWork Clearance Management
140WCAAPWCM: Application77CDATECompletednvarchar80
TOPWorkbench Tools Editors, Painters, Modelers
141COVMVHIDTable for Storing History Versions3CDATEDate for Coverage Analyzer Historynvarchar80
142COVMVTIMTable for Storing Time Snapshots2CDATEDate for Coverage Analyzer Historynvarchar80