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

142 columns | Print definition?ERP 6.0  | CTIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/D_WF_013Table of persistent class /SAPSRM/CL_WF_WORKITEM7CTIMEWork Item Creation Timedecimal150
2/SDF/DRM_RESULTSData Readyness Monitoring - Results8CTIMEField of type TIMSnvarchar60
3/SDF/DRM_RES_DEData Readyness Monitoring - Results Details8CTIMEField of type TIMSnvarchar60
4/XFT/MIG_TDOCDocument head7CTIMECreation timenvarchar60
5/XFT/MIG_TDOCPOSDocument head8CTIMECreation timenvarchar60
6BBP_NEWVD_LOGList of Newly Created Vendors6CTIMETime changednvarchar60
7BOE_COUNT_HEADERBOE Count Header6CTIMECount Timenvarchar60
8BOE_D_INVENTORYMaking inventory of bill of exchange receivable9CTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
9BUBAS_LOG_STOREStored Application Logs7CTIMETIME Data Element for SYSTnvarchar60
10CNVMBTACTIVITYUnique ID for all activities,information about execution24CTIMEMBT PCL create/change timestampdecimal150
11CNVMBTCOBJconversion objects19CTIMEMBT PCL create/change timestampdecimal150
12CNVMBTCOPYVARMBT PCL Copy Variants for Process Type Changes3CTIMEMBT PCL create/change timestampdecimal150
13CNVMBTCOTOBJECTSLO Central Object Table11CTIMESLO COT Creation Timenvarchar60
14CNVMBTCUSTCRCustomer defined extension packages5CTIMEMBT PCL create/change timestampdecimal150
15CNVMBTINCLMBT PCL: Includes to be integrated in Conversion Objects12CTIMEMBT PCL create/change timestampdecimal150
16CNVMBTPACKpackage information/creator/creation date/scenarion20CTIMEMBT PCL create/change timestampdecimal150
17CNVMBTPEBUnique ID for all process execution blocks20CTIMEMBT PCL create/change timestampdecimal150
18CNVMBTPEBNOTIFYNotification Header table6CTIMEMBT PCL create/change timestampdecimal150
19CNVMBTSELGRPMBT PCL Selection groups9CTIMEMBT PCL create/change timestampdecimal150
20CNV_10940_HEADAnalyze report variants8CTIMEField of type TIMSnvarchar60
21CNV_10940_RUN_IDSearch Run IDs created in Sol Man for RVS8CTIMEField of type TIMSnvarchar60
22DDCNVCOUNTDD: Logeinträge der inkrementellen Umsetzungen protokolliere3CTIMETageszeitnvarchar60
23DFKKEPRTLog for Inconsistent FI-CA Documents35CTIMETime at Which the Object Was Last Changednvarchar60
24DFKK_TRIGX_CLOutbound Interface: New Trigger Table of Cleared Items16CTIMETIME Data Element for SYSTnvarchar60
25DFKK_TRIGX_OPOutbound Interface: New Trigger Table for Business Partner12CTIMETIME Data Element for SYSTnvarchar60
26DFKK_TRIGX_PAYOutbound Interface: New Trigger Table for Payment Info22CTIMETIME Data Element for SYSTnvarchar60
27DFKK_TRIGX_RCLOI: New Trigger Table for Reopened Items18CTIMETIME Data Element for SYSTnvarchar60
28HRPAD00_SEPA_UPDFlag SEPA Mandates to Be Updated6CTIMETimenvarchar60
29LTR_VERSION_LOGLTR_VERSION_LOG7CTIMEnvarchar60
30SAIS_LOGLog for Usage of Audit Log7CTIMEModification timenvarchar60
31SSF_PSE_HISTPSE History9CTIMEModification timenvarchar60
32SSF_PSE_LConfiguration Table for PSE File Mode7CTIMEModification timenvarchar60
33T5BSDOG0SDoG: Historical and External Data13CTIMESDoG: Declaration Creation Timenvarchar60
34ZSE_CLONE_STATUSClone Status of system6CTIMETIME Data Element for SYSTnvarchar60
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
35TCNVConversion Table for Logging the Conversion Steps14CTIMETimenvarchar60
TOPALE Integration Technology
36BDLSHDRHeader Data for Conversion of Logical System Names13CTIMETIME Data Element for SYSTnvarchar60
TOPBasic Data
37P44VPlanning Versions11CTIMETime of creationnvarchar60
TOPBelgium
38T5BDI0HR-BE: Dimona Central Table26CTIMEDeclaration Creation Timenvarchar60
39T5BSB0HR-BE: Social Balance Historical and External Data12CTIMEDeclaration Creation Timenvarchar60
40T5BSDSI Declaration: directory table8CTIMEnvarchar60
TOPCollectionsDisbursements
41DVIINFOInformation Data7CTIMETIME Data Element for SYSTnvarchar60
42VVKKEXPTRIGGERTrigger for Expiry Notes12CTIMETIME Data Element for SYSTnvarchar60
TOPContract Accounts Receivable and Payable
43DFKKFWBEWManagement Data for Foreign Currency Valuations9CTIMETIME Data Element for SYSTnvarchar60
44DFKKFWBEW_LDManagement Data for Ledger-Specific Foreign Crcy Valuations10CTIMETIME Data Element for SYSTnvarchar60
45DFKKFWTRIGTrigger Table for Inverse Postings5CTIMESystem Timenvarchar60
46DFKK_TRIGGER_CLOutbound Interface: Trigger Table of Cleared Items15CTIMETIME Data Element for SYSTnvarchar60
47DFKK_TRIGGER_OPOutbound Interface: Trigger Table for Business Partner11CTIMETIME Data Element for SYSTnvarchar60
48DFKK_TRIGGER_PAYOutbound Interface: Trigger Table for Payment Information21CTIMETIME Data Element for SYSTnvarchar60
49DFKK_TRIGGER_RCLOutbound Interface: Trigger Table for Reopened Items17CTIMETIME Data Element for SYSTnvarchar60
50TFK020CShort Acct Assignments for Write-Offs from Clarif. Worklist8CTIMEPeriod in Days for Calculation of Key Datenvarchar40
51TFK020KShort Account Assignments for Transfer Postings10CTIMEPeriod in Days for Calculation of Key Datenvarchar40
TOPCorrespondence Tool
52DFKKCOHCorrespondence - Correspondence Header6CTIMETime of Creation (to the Second)nvarchar60
TOPCustomer Interaction Center
53CCMCLBSCall center callback - Whole18CTIMECall center callback - Creation timenvarchar60
TOPData Retention Tool
54TXW_C_V0Data view: Header14CTIMESystem Timenvarchar60
55TXX_ADMI_VWDART Administration: Tax View File15CTIMECreation Timenvarchar60
56TXX_C_V0View: Header Area11CTIMESystem Timenvarchar60
TOPDenmark
57T5MY0HR-DK: Year-End Activities for PBS5CTIMETime of Copying the Company Master Data Recordnvarchar60
TOPDistribution Requirements Planning
58MDRP_DRUNDeployment run9CTIMETime of creationnvarchar60
TOPeCATT Extended Computer Aided Test Tool
59ECTP_JOB_LISTForeground Scheduler: List of test executions9CTIMETest Proxy: Creation time of job entry for executionnvarchar60
TOPEnergy Data Management
60EFORMULAINSTCALCISU EDM Control Data for Calculation Run Number (DB Table)5CTIMETime creatednvarchar60
61EFORMULATRIGKMPISU EDM Compressed Trigger File for Formula Inst. (DB Table)8CTIMETimenvarchar60
TOPEnterprise Service Framework Layer
62SCOOLOBJECTSObject Pattern Model5CTIMECool: Time of Creationnvarchar60
TOPGRC Process Control Plug-in
63/GRCPI/GRIAREPTSAM - Authorized ABAP Reports6CTIMETimenvarchar60
TOPI18N Unicode
64UM4BATTABInfos about running batchjobs4CTIMEnvarchar60
65UM4LOCKTable for Synchronization of Worker Jobs6CTIMEnvarchar60
66UM4PMBATInfo on Running Background Jobs6CTIMEnvarchar60
67UMGBATTABInfos about running batchjobs4CTIMEStart Timenvarchar60
68UMGLOCKTable for Synchronization of Worker Jobs6CTIMETimenvarchar60
69UMGPMBATInfo on Running Background Jobs6CTIMETimenvarchar60
TOPInternet Communication Framework
70ICFATTRIBDescription of ICF Attributes (Trace/Debugging)10CTIMESystem Timenvarchar60
TOPJoint Venture und Production Sharing Accounting
71T8J6NJV EDI Processed Partners/Ventures10CTIMETimenvarchar60
72T8JFRMFarm In/Out & Re-Determination (Farm) Main Table23CTIMETime creatednvarchar60
73T8JFRM_EGFarm In/Out & Re-Determination (Farm) Main Table10CTIMETime creatednvarchar60
74T8JFRM_STPFarm In/Out & Re-Determination (Farm) Main Table16CTIMETime creatednvarchar60
TOPMonitoring
75SGLWLSLISTSAP Workload: User-Specific System List for Global Analysis15CTIMETimenvarchar60
TOPPackage Tools
76PAKDATBUFBufferung for Package Attributes (EXPORT TO SHARED BUFFER)5CTIMETIME Data Element for SYSTnvarchar60
TOPPayroll
77T5TPSDPPROPrirazení datových prvku st.stát.inf.syst. k výstupum9CTIMECas poslední zmenynvarchar60
78T5TPSDPSISPrevodní tabulka datových prvku stand. státního inf.syst.13CTIMECas poslední zmenynvarchar60
TOPPerformance Monitors TCC
79GVD_LOCKCopy of GV$LOCK11CTIMEOracle monitoring: Time since current mode was granteddecimal220
TOPPreconfigured Systems
80ZHRBPJPT_ITLOG38CTIME??nvarchar60
TOPPrint and Output Management
81TSPCPCDSCPC: Distribution status6CTIMECreation timenvarchar140
82TSPCPCDSEExtended distribution status information11CTIMECreation timenvarchar140
83TSPCPCFAVTarget Systems and Target System Groups as Favorite Targets6CTIMECreation timenvarchar140
84TSPCPCPGCCPC: Printer group configuration4CTIMECreation timenvarchar140
85TSPCPCPGLCPC: Printer group list4CTIMECreation timenvarchar140
86TSPCPCPLCPC: List of CPC managed printers on central system5CTIMECreation timenvarchar140
87TSPCPCTPROBSOLETE CPC: Target system group / printer group relations4CTIMECreation timenvarchar140
88TSPCPCTSGCCPC: Target system group configuration4CTIMECreation timenvarchar140
89TSPCPCTSGLCPC: Target system group list4CTIMECreation timenvarchar140
90TSPCPCTSLCPC: Target system list6CTIMECreation timenvarchar140
TOPProduction Orders
91COMPHOCM: Comparison result (header entry)7CTIMETime creatednvarchar60
TOPProfile Maintenance
92TPFYPROPTYParameter attributes18CTIMETime part last profile generationnvarchar60
TOPPurchase Orders
93WBO5Calculated Actual Vendor Service Level11CTIMECalculation time for the actual vendor service levelnvarchar60
TOPRetention Warehouse
94IWP_DB_AREAAudit Areas5CTIMECreated Atnvarchar60
95IWP_DB_REPOSRetention Warehouse: Repository5CTIMECreated Atnvarchar60
96IWP_DB_SETSet of tables5CTIMECreated Atnvarchar60
97IWP_TABLE_DIRDirectory of generated tables for data transfer7CTIMESystem Timenvarchar60
98IWP_WPPAudit Package Template6CTIMECreated Atnvarchar60
99IWP_WP_JOBJobs for the Backgroundprocessing8CTIMECreated Atnvarchar60
100IWP_WP_LOGLog for Backgroundprocessing6CTIMECreated Atnvarchar60
TOPReuse Services for Country Development
101PA3228XSS Online Election30CTIMETimenvarchar60
TOPRFC
102QRFCLOGTrace Description17CTIMESystem Timenvarchar60
103QRFCTRACETrace Description17CTIMESystem Timenvarchar60
TOPSales Plan
104ERKOEvent Header6CTIMETime of creationnvarchar60
105ERZUEvent Assignment15CTIMETime of creationnvarchar60
106LISPLBackground Job for LIS Planning10CTIMETime of creationnvarchar60
107P445VSales and Operations Planning: Versions9CTIMETime of creationnvarchar60
108P445XLIS Planning Versions Table7CTIMETime of creationnvarchar60
109T445PPlanning Types: LIS/SOP15CTIMETime of creationnvarchar60
TOPSAP Business Workflow
110SWFCLOGAutomatisc Customizing (Workflow): Log Table5CTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPSCM Basis
111/SAPAPO/DP440GMaster Forecast Profile (APO0300)34CTIMETime of Creationnvarchar60
112/SAPAPO/DP_ALERTProfile for Filtering Output to Alert Monitor9CTIMETime of Creationnvarchar60
113/SAPAPO/TIMESERITime Series in Forecast19CTIMETime of Creationnvarchar60
TOPSecure Network Communications
114RFCDESSECUSNC extensions for RFC destinations8CTIMEModification timenvarchar60
115SNCSYSACLSNC Access Control List (ACL): Systems13CTIMEModification timenvarchar60
116TXCOMSECUSNC extension for CPIC destinations7CTIMEModification timenvarchar60
117USRACLSNC Access Control List (ACL): User9CTIMEModification timenvarchar60
118USRACLEXTExtended SNC Access Control List (ACL) for Users9CTIMEModification timenvarchar60
119USREXTIDAssignment of External ID to Users12CTIMEModification timenvarchar60
120USREXTIDHExternal ID (Access Using Hash Value)6CTIMEModification timenvarchar60
TOPSecure Store and Forward
121SSF_PSE_HSSF: Personel Security Environment8CTIMEModification timenvarchar60
TOPSelf-Service Procurement
122/SRMERP/D_WF_013Table of persistent class /SRMERP/CL_WF_WORKITEM7CTIMEWork Item Creation Timedecimal150
TOPText Retrieval and Information Extraction
123SRETIDLACDIndexes of client-specific applications18CTIMETime stamp of export for checking against indexnvarchar140
124SRETIDLACIIndexes of cross-client applications17CTIMETime stamp of export for checking against indexnvarchar140
TOPTime Sheet
125PTRV_WAFLOGLog File for Inbound Container in Travel Management7CTIMELast Changed Atnvarchar60
TOPTranslation Tools
126TGRAPHTranslation Graphs: General7CTIMETime Creatednvarchar60
127TGRAPHDEVCTranslation Graphs: General8CTIMETime Creatednvarchar60
128TRMAUTTable for Storing the Parameters for Automatic Distribution12CTIMETimenvarchar60
129TRMMAPPUser values storage table5CTIMETimenvarchar60
130TRMSTMAValues of Settings for Screens in Transaction STMA73CTIMETimenvarchar60
TOPUpgrade Tools
131DDCNVSTATDD: Statistical Data for Conversion3CTIMEField of type TIMSnvarchar60
132DDCSTADD: Conversion, number of table lines3CTIMEField of type TIMSnvarchar60
133DDSTATHISTDD: Statistical Data for Conversion3CTIMEField of type TIMSnvarchar60
134TICNVDD: Status of Incremental Conversions50CTIMETimenvarchar60
TOPUser and Authorization Management
135USR07Object/values of last authorization check that failed28CTIMETimenvarchar60
TOPVehicle Management System
136VLC_DBCONSTATUSVELO : Status of LiveCache Connection6CTIMETimenvarchar60
TOPWeb Service Tools - ABAP
137VEPHEADERVirtual End Point Definition: Administrative Data14CTIMEWebServices: Creation Timenvarchar60
138WSHEADERWeb Services Definition Administrative Data13CTIMEWebServices: Creation Timenvarchar60
139WSHEADER_DARKDark table of WSHEADER (only for transport reasons)14CTIMEWebServices: Creation Timenvarchar60
TOPWork Clearance Management
140WCAAPWCM: Application78CTIMEComplete Timenvarchar60
TOPWorkbench Tools Editors, Painters, Modelers
141COVMVHIDTable for Storing History Versions4CTIMETime Stamp for Coverage Analyzer Historynvarchar60
142COVMVTIMTable for Storing Time Snapshots3CTIMETime Stamp for Coverage Analyzer Historynvarchar60