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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

144 columns | Print definition?ERP 6.0  | TEMPLATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/D_MP_HDRMaster Project Header26TEMPLATEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
2/OEE/C_HTMPLHierarchy Template2TEMPLATEOEE Hierarchy Templatenvarchar200
3/OEE/C_HTMPLTHierarchy Template Texts3TEMPLATEOEE Hierarchy Templatenvarchar200
4/OEE/C_HTNTHierarchy Template Nodes2TEMPLATEOEE Hierarchy Templatenvarchar200
5/OEE/C_HTNTRELHierrachy Template Parent Child Node Type Relationship2TEMPLATEOEE Hierarchy Templatenvarchar200
6/OEE/C_HTNTTHierarchy Template Node Texts3TEMPLATEOEE Hierarchy Templatenvarchar200
7/OEE/MPH_HDRPlant Hierarchy Header3TEMPLATEOEE Hierarchy Templatenvarchar200
8/PLMI/PPE_C_TMPLTemplate table2TEMPLATETemplate Namenvarchar180
9/PLMI/PPE_TDES_TText table for description of templates2TEMPLATETemplate Namenvarchar180
10/XLSO/TEMPLATESxLSO scenarios and templates4TEMPLATEDocument Namenvarchar300
11/XLSO/TEMP_VARvariables in xLSO templates3TEMPLATEDocument Namenvarchar300
12BBPC_PDC_UI_EXTExternal Screen Objects in SRM Applications9TEMPLATELong Key for IAC Objectsnvarchar1200
13CNV_20305_COTPLSCopy of COTPLFS (full)5TEMPLATEnvarchar100
14DMC_ACS_PLAN_HDRDMC: Access plans for a conversion object14TEMPLATEBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
15DMC_DW_TEMPLATEDynamic WHERE Clause Templates6TEMPLATETemplate for Where-Clausesntext10737418230
16sap_tr2_tracedefs2templatechar10
17SITSTRACERUNITS: Memory Trace10TEMPLATETemplate Memory (Bytes)decimal210
18TSCON_TEMPLATETemplate9TEMPLATE255 Charactersnvarchar2550
19VTB_MD_TMPLTemplate for Market Data Import1TEMPLATEMarkt data: Templatenvarchar400
20/BOBF/CONF_GENGeneration table5TEMPLATENamenvarchar300
TOPAccounting Engine
21/EACC/TBTA1003Assignment of Interface ID to Interface IDs6TEMPLATEType of Generation Templatenvarchar40
22/EACC/TBTA1005Exceptions for Object Type with Statistical Structure Templ.3TEMPLATEType of Generation Templatenvarchar40
TOPActivity-Based Costing
23CBPRCO-ABC: Activity Master Table31TEMPLATETemplate: Allocation of Business Processesnvarchar100
24CMDT_BPGeneric master record business process enhancements38TEMPLATETemplate: Allocation of Business Processesnvarchar100
25COTPLCO-ABC Template Master Data4TEMPLATETemplatenvarchar100
26COTPLFCO-ABC Find Template8TEMPLATETemplatenvarchar100
27COTPLFCCO-OM-ABC: Process Template Control Blocks (TYPE TPLIC_BCB)4TEMPLATETemplatenvarchar100
28COTPLFPCO-OM-ABC: Formula Parameter Lists for Process Template4TEMPLATETemplatenvarchar100
29COTPLFSABC: Sources of Formulas in a Template4TEMPLATETemplatenvarchar100
30COTPLFVCO-OM-ABC: Formula Value Lists for Process Template4TEMPLATETemplatenvarchar100
31COTPLPCO-OM-ABC: Items in Process Template4TEMPLATETemplatenvarchar100
32COTPLPTCO-OM-ABC: Texts for Items in Process Template5TEMPLATETemplatenvarchar100
33COTPLRCO-OM-ABC: Master Data Extension, Process Template (Reports)2TEMPLATETemplatenvarchar100
34COTPLSCO-ABC: Source Text for Formulas in Template5TEMPLATETemplatenvarchar100
35COTPLTCO-OM-ABC: Descriptive Text for Process Template5TEMPLATETemplatenvarchar100
TOPAdvertising Management
36JHAMOTIS-M/AM: Ad Spec56TEMPLATEIS-M: Template for IS-M/AMCnvarchar300
TOPALE Integration Technology
37TBD72ALE Customizing Distribution: Objects in Distribution Group6TEMPLATERequest/Tasknvarchar200
TOPApplication Framework
38MDG_MDF2100Master Data Generation: Object -> Logical Name3TEMPLATEName of Dictionary Typenvarchar300
39MDG_MDF2101List of Generated DDIC Elements3TEMPLATEName of Dictionary Typenvarchar300
TOPASAP AcceleratedSAP
40IALINKURLSLinks with Web Addresses3TEMPLATEURL namenvarchar300
41SQADB04PROProject - Answer set assignment3TEMPLATETemplate IDnvarchar200
TOPBalanced Scorecard
42UMB_SC100Scorecard: Header Table26TEMPLATEScorecard Templatenvarchar100
TOPBasic Functions
43UTSEGDATATime Segment Data Container Template3TEMPLATETemplatenvarchar100
TOPBusiness Analytics
44TCOCORFCRFC Destinations for Concurrent Costing4TEMPLATEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
45UASURCHTEMPLATESAssignment Object Types Templates3TEMPLATEType Namenvarchar100
46UATPLTPLTemplate Selection for Template Call4TEMPLATETemplate Namenvarchar100
TOPBusiness Rule Framework
47TBRF181C(Obsolete) BRF: Classes for Transport of BRF4TEMPLATEABAP Program Namenvarchar400
TOPBW Service API
48RSSGTPCLABW Generation Tool: Program Class5TEMPLATEBW Generation Tool: Template for Code Generationnvarchar400
49RSSGTPDIRBW generation tool: Directory of the generated programs11TEMPLATEBW Generation Tool: Template for Code Generationnvarchar400
50RSSGTPDIRSUBBW Generation Tool: Time Stamp Management for Subtemplates4TEMPLATEBW Generation Tool: Template for Code Generationnvarchar400
TOPClaims Management
51TICL044Claims Management Activity or Prompting Message39TEMPLATEDocument Template for Output in Office Applicationsnvarchar640
52TICL044_2Task/Log Entry: Claim Type Specific Navigation Target5TEMPLATEDocument Template for Output in Office Applicationsnvarchar640
53TICL346Office Integration: Additional Template Attributes3TEMPLATEDocument Template for Output in Office Applicationsnvarchar640
54TICL347Office Integration: Assignment of Field Name to Template2TEMPLATEDocument Template for Output in Office Applicationsnvarchar640
55TICL950Claim Bundle: Task or Prompting Message29TEMPLATEDocument Template for Output in Office Applicationsnvarchar640
TOPClient Copy
56CCPROFClient copy profiles24TEMPLATEProfile templatenvarchar10
TOPCollaboration Folders
57CFS_STATUS_PROFCFS: Additional (Mapping) Data for Status Profile13TEMPLATEObject Can Be Used as Templatenvarchar10
58CFX_COLCollaboration Folders: Collaboration12TEMPLATEObject Can Be Used as Templatenvarchar10
TOPConfiguration management
59TCM_PF_CONTTable for data container for product folder (Conf. Mgmt)8TEMPLATEBooleannvarchar10
TOPControlling
60QISRSCENARIOBasic Scenario Data17TEMPLATECosting Templatenvarchar100
TOPCountry-Specific Objects
61TAXNUMCHKRules for checking tax codes6TEMPLATETax Number Check: Template for Format Checknvarchar400
TOPCustomer Service
62/WSCGMBH/A_TMPLXML Template2TEMPLATEXML Templatenvarchar150
63/WSCGMBH/A_TMPLLXML Template: Row2TEMPLATEXML Templatenvarchar150
TOPData Staging
64RSCOPY_RUNCopy Process (Run for Copy Tool)9TEMPLATECopy Process (Run for Copy Tool)int100
65RSREQPROGSGenerated Programs for Each Request5TEMPLATEBW Generation Tool: Template for Code Generationnvarchar400
TOPDay-to-Day Activities
66HRT5048Table Section Infotype 50486TEMPLATECorrespondence Typenvarchar40
67LSOCRPCNTXTPRTCLLSO Correspondence: Log Area25TEMPLATECorrespondence Typenvarchar40
68LSOCRPCNTXTSTAGELSO Correspondence: Staging Area25TEMPLATECorrespondence Typenvarchar40
69LSOCRPCONTROLOutput Control: Delivery Method-Specific5TEMPLATECorrespondence Typenvarchar40
70LSOCRPSMMStopmarks for Correspondence Requests5TEMPLATECorrespondence Typenvarchar40
TOPDB2 for OS39
71DB2CCMO_IN1History of input table 1 for DB13 jobs executed via DSNACCMO10TEMPLATEDSNACCMO: Use template dynamic allocationnvarchar10
TOPDocument Management System
72CVSE_APPL_DOKOBObject assignments for each search application3TEMPLATEStructure with default fields for search engine indexnvarchar300
TOPE-Recruiting
73T77RCF_DOVR_PMPerformance Management Templates in Overview (Successor)2TEMPLATEAppraisal Templatenvarchar80
TOPEnd User Technology
74RSRPARAMETRIZAParametrization for a query, workbook, webapplication, pla7TEMPLATETechnical Name of a Templatenvarchar300
TOPFinancials Basis
75UGMD1042FIN Master Data: Gen. Templates for Authorization Check2TEMPLATEName of Dictionary Typenvarchar300
76UGMD2100FIN Master Data: Generation: Object -> Logical Name4TEMPLATEName of Dictionary Typenvarchar300
77UGMD2101FIN Master Data: List of Generated DDIC Elements4TEMPLATEName of Dictionary Typenvarchar300
TOPGRC Risk Management
78HRP1847DB Table for Infotype 184720TEMPLATETemplatenvarchar10
TOPHR Administrative Services
79T5ASRFE01Fast Data Entry Template2TEMPLATEFast Data Entry Templatenvarchar320
80T5ASRFE01TFast Data Entry Templates Names3TEMPLATEFast Data Entry Templatenvarchar320
81T5ASRFE02Connection of Fast Data Entry Template to Form Scenario2TEMPLATEFast Data Entry Templatenvarchar320
82T5ASRFE03Assignment of Template to Initiator Role3TEMPLATEFast Data Entry Templatenvarchar320
83T5ASRFE04User-Defined Fast Data Entry Templates4TEMPLATEFast Data Entry Templatenvarchar320
TOPImplementation Guide
84TNOTETEMTemplates for notes3TEMPLATELocal file for upload/downloadnvarchar1280
85TPRCLASSProject Management Project Classes2TEMPLATEUnique ID - 32 charactersnvarchar320
TOPIntercompany Data Exchange
86TINV_INV_TMPLTBill Document: Template2TEMPLATETemplate Number for Incoming Bill/Pay.Advice Note Processingnvarchar180
87TINV_INV_TMPLTTBill Document: Template - Description2TEMPLATETemplate Number for Incoming Bill/Pay.Advice Note Processingnvarchar180
TOPLaunchpad
88APB_ISR_CUST_VRSScenario and Version Customizing6TEMPLATEForm for Scenarionvarchar300
TOPMaterial Master
89WER_TMPL_REF_AReferences to template elements: where-used list (Customers)4TEMPLATEElement unique identifiernvarchar320
90WER_TMPL_REF_SReferences to template elements: where-used list3TEMPLATEElement unique identifiernvarchar320
91WRFMATTEMPLATEReference Values: Core Material Master Data Maintenance3TEMPLATETemplate Number of a Material Groupnvarchar60
TOPNetWeaver Enterprise Search
92ESH_OM_TRANSPORTTable for transport of template and models4TEMPLATEObject Typenvarchar200
93ESH_TAU_CL_PDTClassification Test: Prop. Datatype19TEMPLATETemplatenvarchar300
TOPOLAP Technology
94RSUNIURLDIRURL->IObj3TEMPLATETechnical Name of a Templatenvarchar300
TOPPortfolio Management
95/RPM/CR_SETTINGCollaboration Room Default Settings3TEMPLATECollaboration Room Templatenvarchar400
96ZNPDI_XRPM2CPR_TxRPM -> cPro Integration3TEMPLATEProject Numbernvarchar240
TOPProcess Controls
97GRPC_WF_IT_UPGDUpgrade the incompatible workflow instances1TEMPLATETask IDnvarchar140
TOPProcess Foundation
98EHFNDC_NTFTPLTemplates for Task Notifications3TEMPLATEObject ID of Standard Objectnvarchar80
TOPProcess Management
99CMX_XS_DB_REFXSteps: Step References Table5TEMPLATEXSteps: Unique ID of a Nodenvarchar220
100CMX_XS_DB_STEPXSteps: Step Table5TEMPLATEXSteps: Unique ID of a Nodenvarchar220
TOPProduct Configurator
101COMM_CFGNUMBasic Data for Numeric Characteristics7TEMPLATECharacteristic Templatenvarchar1320
102COMM_CFGSTRINGBasic Data for String Characteristics5TEMPLATECharacteristic Templatenvarchar1320
TOPProduct Cost Planning
103CKCMCosting Model8TEMPLATETemplatenvarchar100
104CKCM_TRCosting Model (Transportable)8TEMPLATETemplatenvarchar100
105CKHSHeader: Unit Costing (Control + Totals)68TEMPLATETemplatenvarchar100
106KEKOProduct Costing - Header Data106TEMPLATETemplatenvarchar100
TOPProfitability Analysis
107/EACA/TPMVARIASSVariant: Assignments5TEMPLATEProfitability Analysis Variant w. Customizing Template Rolenvarchar160
TOPRecipe Development
108/PLMB/RCP_SPECDefaults for Property Specification6TEMPLATETemplatenvarchar100
TOPRetention Warehouse
109IWP_WPAudit Packages14TEMPLATEAudit Package Used as Templatenvarchar10
TOPSales and Distribution
110SCENUMNumeric Characteristics7TEMPLATETemplatenvarchar300
111SCESTRINGAlphanumeric Characteristics5TEMPLATETemplatenvarchar300
TOPSAP Business Workflow
112SWN_CAT2MSGWF Notif: Assignment Category, Message Template7TEMPLATEMessage Template IDnvarchar320
TOPSAP Multiresource Scheduling
113/MRSS/C_SGX_TTYTText Template Types Text Table5TEMPLATEText Templatenvarchar2550
TOPSecurity
114WSS_PROFILEWS Security Profiles3TEMPLATEWeb Services Security Profilenvarchar300
TOPService Processing
115/WSCGMBH/C_TMPLClickSchedule: Assignment Templates3TEMPLATEXML Templatenvarchar150
TOPSet Types and Attributes
116COMS_SETTYPESettings for Generating Set Types4TEMPLATETemplate Name for Generating Set Typenvarchar400
117COMS_SETTYPE_GENSettings for Generating Set Types6TEMPLATETemplate Name for Generating Set Typenvarchar400
TOPSingle Transaction Costing
118JBTKABCAssignment of CO-ABC Templates to Costing Rules5TEMPLATETemplatenvarchar100
TOPSpecification
119/PLMI/SPC_CPDEFDefault Values for Copying Specifications3TEMPLATETemplatenvarchar100
TOPStakeholder Relationship Management
120USC_TEMPLATEForms / SmartForms by Communication Type3TEMPLATEName of a Smarformnvarchar300
TOPSyntax, Compiler, Runtime
121SCC_ATL_USERABAP Code Completion: ATL User Templates3TEMPLATEDW: Includenvarchar400
TOPSystem Administration Assistant
122SAASYSTSystems used (System Administration Assistant)2TEMPLATEnvarchar10
TOPTime Sheet
123CATS_TEMPCATS: Database Table for Templates4TEMPLATEData Entry Profilenvarchar80
124TCATSCATS: Data Entry Profiles72TEMPLATEPersonal Templatesnvarchar10
TOPTraining Management
125HRP5046DB Table for Infotype 504618TEMPLATETemplate Profilenvarchar80
126LSO_COL_PROFProfiles3TEMPLATECollaboration Room Templatenvarchar360
127LSO_COL_TMPLTemplates2TEMPLATETemplate Profilenvarchar80
128LSO_COL_TMPL_CATTemplates / Categories2TEMPLATETemplate Profilenvarchar80
129LSO_COL_TMPL_PARTemplates / Parameters2TEMPLATETemplate Profilenvarchar80
130LSO_COL_TMPL_TXTTemplates / Titles2TEMPLATETemplate Profilenvarchar80
TOPTravel Expenses
131T706ESS2Travel Expenses Customizing for ESS Scenario4TEMPLATELogical Path of Finished Excel Templatenvarchar1280
TOPTravel Planning
132FTPT_CARTravel Request Item - Car Rental Service45TEMPLATETemplate indicatornvarchar10
133FTPT_FLIGHTTravel Request Item - Flight Service26TEMPLATETemplate indicatornvarchar10
134FTPT_HOTELTravel Request Item - Hotel Service43TEMPLATETemplate indicatornvarchar10
135FTPT_ITEMTravel Service Request Item24TEMPLATETemplate indicatornvarchar10
136FTPT_TRAINTravel Request Item - Train Service23TEMPLATETemplate indicatornvarchar10
137FTPT_VARIANTTable of Travel Plan Variants13TEMPLATETemplate indicatornvarchar10
TOPTreasury
138VTB_MDTABKALIndividual Settings: Spreadsheet5TEMPLATEMarkt data: Templatenvarchar400
TOPWeb Services Tool
139CRMOST_GEN_TEMPLGeneration templates for Open Services Tool2TEMPLATEABAP Program Namenvarchar400
TOPWorkforce Management Application
140WFAC_CONTR_RL_TContract Rule Text Table2TEMPLATEContract Rule Template IDnvarchar200
141WFAC_CONTR_RULEContract Rule2TEMPLATEContract Rule Template IDnvarchar200
142WFAC_CONTR_RULEHContract Rule2TEMPLATEContract Rule Template IDnvarchar200
143WFA_EMP_CONTREmployee contract assignment6TEMPLATEContract Rule Template IDnvarchar200
TOPWorkplace FrontendMiddleware
144PBLAYOUTLayout Data for Portal Builder (Internal Data)2TEMPLATETemplate Name for the Portal Builder Layout Informationnvarchar300