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

126 columns | Print definition?ERP 6.0  | TEMPLATE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/C_CHK_MAPCustomizing for Milestone Checklist Mapping3TEMPLATE_IDChecklist Groupnvarchar60
2/CPD/C_CHK_TEMPLDefine Checklist Groups2TEMPLATE_IDChecklist Groupnvarchar60
3/CPD/C_CHK_TEMPTChecklist Templates Texts2TEMPLATE_IDChecklist Groupnvarchar60
4/CPD/C_MC_OBJMAPTable to map milestone checklist items to project elements6TEMPLATE_IDChecklist Groupnvarchar60
5/CPD/C_OBJ_MAPTable to map milestone checklist items to project elements4TEMPLATE_IDChecklist Groupnvarchar60
6/CPD/C_REASON_CDMilestone Checklist: Reason Codes3TEMPLATE_IDChecklist Groupnvarchar60
7/CPD/C_REASON_CTMilestone Checklist: Reason Codes (Text)3TEMPLATE_IDChecklist Groupnvarchar60
8/CPD/PWSC_TLA_ARStatus Management : Template to Area mapping3TEMPLATE_IDTemplate for Status Managementnvarchar40
9/CPD/PWSC_TMPLATStatus Management : Templates2TEMPLATE_IDTemplate for Status Managementnvarchar40
10/CPD/PWSC_TMPL_TTemplate Description2TEMPLATE_IDTemplate for Status Managementnvarchar40
11/SAPSRM/C_ESH_EXSRM Extractor Classes for Enterprise Search Connectors5TEMPLATE_IDSearch Connector Model IDnvarchar1200
12/SAPSRM/C_SRC_SVSearch: Service Customizing9TEMPLATE_IDSearch Connector Model IDnvarchar1200
13/SAPSRM/C_WF_WSub-Workflow Template Assignment Of Process Level Type3TEMPLATE_IDWorkflow Template Identifiernvarchar80
14/SAPSRM/D_WF_003Table for persistent class /SAPSRM/CL_WF_PROCESS_LEVEL7TEMPLATE_IDWorkflow Template Identifier (Concatenatd PD-Org. Type & ID)nvarchar140
15/SLOAP/OUTP_CATCxml templates4TEMPLATE_IDtemplate idnvarchar700
16/SLOAP/OUTP_CATTtransport table for /SLOAS/OUTP_CAT6TEMPLATE_IDtemplate idnvarchar700
17/XFT/EPA_T0000Basic Settings7TEMPLATE_IDTemplate used to create personnel filesnvarchar320
18/XFT/SRM_REC02Record: Header5TEMPLATE_IDTemplate IDnvarchar320
19/XFT/SRM_RECT02Template: Header5TEMPLATE_IDTemplate IDnvarchar320
20BBPD_BWREP_HDRBW Reports: General Data4TEMPLATE_IDTechnical Template Name BW Reportnvarchar300
21CBESH_ANNO_DISPAnnotation file creation data2TEMPLATE_IDnvarchar1200
22CBESH_ANNO_FACETFacet Table for annotation file data2TEMPLATE_IDSearch Connector Model IDnvarchar1200
23CBESH_ANNO_KFConfiguration Table for1TEMPLATE_IDchar120nvarchar1200
24CBESH_AN_DISPLAYAnnotation file creation data2TEMPLATE_IDSearch Connector Model IDnvarchar1200
25CBESH_SOESHSemantic Object Names for Enterprise Search Models2TEMPLATE_IDSearch Connector Model IDnvarchar1200
26CBESH_SOESH_FMField Mapping from Semantic Names to Enterprise Search Model2TEMPLATE_IDSearch Connector Model IDnvarchar1200
27CBESH_SOESH_FMAPField Mapping from Semantic Names to Enterprise Search Model2TEMPLATE_IDSearch Connector Model IDnvarchar1200
28CEBN_SOESHSemantic Object Names for Enterprise Search Models2TEMPLATE_IDSearch Connector Model IDnvarchar1200
29CEBN_SOESH_FMAPField Mapping from Semantic Names to Enterprise Search Model2TEMPLATE_IDSearch Connector Model IDnvarchar1200
30CNVMBTMEPACMAPSME CWB Interface - Mappings associated with Packages3TEMPLATE_IDID of a Mapping Templatenvarchar320
31CNVMBTNOTETEMPLMBT PCL Notes templates3TEMPLATE_IDDocumentation Objectnvarchar600
32CNVMBTNOTETEMPLTText table for CNVMBTNOTETEMPL3TEMPLATE_IDDocumentation Objectnvarchar600
33CNV_00300_MAPSCWB-ME Interface - Mappings associated with Packages3TEMPLATE_IDID of a Mapping Templatenvarchar320
34CNV_00300_MAPSPCCWB-ME Interface - Template ID - Profile Class - Check Class3TEMPLATE_IDID of a Mapping Templatenvarchar320
35GRACEUPCRITEnd User Personalization Criteria3TEMPLATE_IDTemplate IDnvarchar320
36GRACREQRequest Header13TEMPLATE_IDUUID of the GRC object (char32)nvarchar320
37GRACREQTEMPLATEAccess request Templates Table2TEMPLATE_IDUUID of the GRC object (char32)nvarchar320
38GRACREQTEMPLATETAccess request Templates Text Table3TEMPLATE_IDUUID of the GRC object (char32)nvarchar320
39GRFNMWCNGLBNOTMSMP Global Settings - Process Level Notifications4TEMPLATE_IDMSMP Notification - Template IDnvarchar600
40GRFNMWNOTIFRECPTMSMP Stage Notification Recipents6TEMPLATE_IDMSMP Notification - Template IDnvarchar600
41GRFNMWNOTIFRECPVMSMP Stage Notification Recipents - Versions7TEMPLATE_IDMSMP Notification - Template IDnvarchar600
42GRFNMWNOTIFTEMPMSMP:Notification Template3TEMPLATE_IDMSMP Notification - Template IDnvarchar600
43HRHAP_GOAL_TMPLObjectives: Form ID Enhancement for HRPAD7134TEMPLATE_IDAppraisal Templatenvarchar80
44HRP1107DB Table for Infotype 110720TEMPLATE_IDTemplate IDnvarchar480
45HRSFI_D_COMP_ERRSuccessFactors: Comp Log Table for Errors in Delta Handling6TEMPLATE_IDSFSF Template IDnvarchar300
46HRSFI_D_COMP_IMPSuccessFactors: Imported Comp data3TEMPLATE_IDSFSF Template IDnvarchar300
47HRSFI_D_COMP_STASuccessFactors: Comp Log Table for Status Information6TEMPLATE_IDSFSF Template IDnvarchar300
48HRSFI_D_RCT_REQChange Pointer Table for Job Requisitions15TEMPLATE_IDTemplate IDnvarchar480
49HRSFI_D_VARPY_IMImported Variable Pay data3TEMPLATE_IDSFSF Template IDnvarchar300
50HRSFI_D_VARPY_STVariable Pay Log Table for Status Information6TEMPLATE_IDSFSF Template IDnvarchar300
51T77PAOSSPESSearch Category5TEMPLATE_IDObject Typenvarchar200
52T77SFI_VARPAY_DTSuccessFactors: SFSF Variable Pay8TEMPLATE_IDSFSF Template IDnvarchar300
TOPAppraisal, Valuation, and Survey Tool
53T77HAP_ASSIGNExternal Objectes Assigned to Template Elements3TEMPLATE_IDAppraisal Templatenvarchar80
TOPBusiness Context Viewer
54/BCV/C_DSESData Provider Enterprise Search3TEMPLATE_IDID of Search Connector Templatenvarchar1200
TOPClaims Management
55ICL_CNOTE_TEMPLID of a Text Template2TEMPLATE_IDText Template for Capture of Notes in Claimnvarchar40
56ICL_CNOTE_TEMPL1Internal Claim Type: Permitted Text Templates6TEMPLATE_IDText Template for Capture of Notes in Claimnvarchar40
57ICL_CNOTE_TEMPLTID of a Text Template3TEMPLATE_IDText Template for Capture of Notes in Claimnvarchar40
TOPControlling
58QISRSCENARIOBasic Scenario Data26TEMPLATE_IDForm for ISR Scenarionvarchar300
59QISRTEMPLATETemplate for Basic Data4TEMPLATE_IDForm for ISR Scenarionvarchar300
TOPCross-Application Components
60/IXOS/DC61_TCCMTCM: Template storage table6TEMPLATE_IDTemplate IDnvarchar40
TOPeCATT Extended Computer Aided Test Tool
61ECET_SDC_BUFFERBuffer Table for SDC Names8TEMPLATE_IDTemplate IDnvarchar150
62ECET_SDC_TSAT_BFBuffer Table for SDC Names8TEMPLATE_IDTemplate IDnvarchar150
TOPEmployee Interaction Center
63THREIC_TEMPLATEList of templates for the employee survey8TEMPLATE_IDObject ID for AES (Template)nvarchar80
TOPEnd User Technology
64RSRA_BC_AUTHDisplay Auth. for Precalculated Templates by Redirect URL2TEMPLATE_IDTechnical Name of a Templatenvarchar300
65RSWR_PERSPersonalization Data2TEMPLATE_IDObject Name in Object Directorynvarchar400
TOPEnterprise Search Integration
66CRMD_ES_ACT_FUNCEnable WEBCUIF Enterprise Search functions3TEMPLATE_IDTemplate ID for CRM ESnvarchar200
67CRMD_ES_ATTRNode attributes3TEMPLATE_IDTemplate ID for CRM ESnvarchar200
68CRMD_ES_KEYSTOREEnterprise search Extraction temporary database2TEMPLATE_IDTemplate ID for CRM ESnvarchar200
69CRMD_ES_LOADMODEExceptions for load mode3TEMPLATE_IDTemplate ID for CRM ESnvarchar200
70CRMD_ES_LOGSStores logs per template2TEMPLATE_IDTemplate ID for CRM ESnvarchar200
71CRMD_ES_MAPSTRMapping fpr structures during extraction3TEMPLATE_IDTemplate ID for CRM ESnvarchar200
72CRMD_ES_PATHSNode paths3TEMPLATE_IDTemplate ID for CRM ESnvarchar200
73CRMD_ES_PATHSTEPPath steps3TEMPLATE_IDTemplate ID for CRM ESnvarchar200
74CRMD_ES_TMPLHDRTemplates for ES3TEMPLATE_IDTemplate ID for CRM ESnvarchar200
75CRMD_ES_TMPLHDRTTemplate Texts for ES3TEMPLATE_IDTemplate ID for CRM ESnvarchar200
76CRMD_ES_TMPLRELRelations of templates for ES3TEMPLATE_IDTemplate ID for CRM ESnvarchar200
77WCFD_ES_BOL_QMap Enterprise Search template to BOL extraction query3TEMPLATE_IDObject Typenvarchar200
78WCFD_ES_BOL_QPARAssign parameters to BOL extraction query3TEMPLATE_IDObject Typenvarchar200
79WCFD_ES_CPOINTERDelta pointer handling: Map BOL root object to template2TEMPLATE_IDObject Typenvarchar200
TOPEnvironment, Health and Safety
80/TDAG/RCSC_SSRTHSpreadsheet report thresholds/settings3TEMPLATE_IDSpreadsheet Report Templatenvarchar320
TOPGRC Risk Management
81GRRMPROPOSERISKPropose risk6TEMPLATE_IDObject IDnvarchar80
TOPIncentive and Commission Management ICM
82TCACS_TGTTarget Agreements: Complex Target Type11TEMPLATE_IDAppraisal Templatenvarchar80
TOPMovables
83CMS_MOVABLESMovable Details - Vehicles, Devices & Aircraft24TEMPLATE_IDTemplate IDvarbinary160
TOPNetWeaver Enterprise Search
84ESH_ADM_SC_MAINSearch Connectors4TEMPLATE_IDSearch Connector Model IDnvarchar1200
TOPObjective Setting and Appraisals
85HRHAP_ARC_GRSTDestruction Log for Archiving/Data Destruction6TEMPLATE_IDObject IDnvarchar80
86HRHAP_GOAL_ERRORGoals: An cascading error occurred in the existing document12TEMPLATE_IDObject IDnvarchar80
87T77HAP_RTG_DISTPerformance-Goal Distribution2TEMPLATE_IDAppraisal Templatenvarchar80
88T77HAP_VA_CONFIGAppraisal Template Configuration for PMP2TEMPLATE_IDAppraisal Templatenvarchar80
TOPPublic Sector Contract Accounts Receivable and Payable
89TFMCA_ECMD_DEFDefinition of Template Structure for ECMD2TEMPLATE_IDNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
90TFMCA_ECMD_ENTTemplates for Simplified Master Data Creation (ECMD)2TEMPLATE_IDNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
TOPRecords and Case Management
91RMPSC_TRF_HEADDoD: Transfer - export/import configuration - header4TEMPLATE_IDDoD: Transfer - Configuration template IDnvarchar200
92RMPSC_TRF_STDoD: Transfer - export/import configuration - ST templates5TEMPLATE_IDDoD: Transfer - ST template IDnvarchar400
TOPRuntime for ABAP based automated TC
93STC_SESSIONTask List Runs4TEMPLATE_IDTask List Variantnvarchar140
94STC_SESSION_EXIMTask List Runs for Refresh4TEMPLATE_IDTask List Variantnvarchar140
95STC_TEMPLATETask List Variants3TEMPLATE_IDTask List Variantnvarchar140
96STC_TEMPLATE_TTask List Variant Description3TEMPLATE_IDTask List Variantnvarchar140
TOPSearch Integration
97/PLMPCV/C_DSESData Source Enterprise Search3TEMPLATE_IDID of Search Connector Templatenvarchar1200
TOPSelf-Service Procurement
98/SRMERP/C_WF_WSub-Workflow Template Assignment Of Process Level Type3TEMPLATE_IDWorkflow Template Identifiernvarchar80
99/SRMERP/D_WF_003Table for persistent class /SRMERP/CL_WF_PROCESS_LEVEL7TEMPLATE_IDWorkflow Template Identifier (Concatenatd PD-Org. Type & ID)nvarchar140
TOPSupplier Lifecycle Management ERP-Integration
100SMC_C_EVENT_EVALEvents for SLC Vendor Evaluation7TEMPLATE_IDSLC Template IDnvarchar200
TOPTalent Management
101T5TMCRMMOSRCFGSearch Configurations for Talent Monitor4TEMPLATE_IDTemplate Name in Enterprise Searchnvarchar320
102T5TMCSRCFGSearch Configurations3TEMPLATE_IDTemplate Name in Enterprise Searchnvarchar320
103T5TMCSRCHPControl Change Pointer for Enterprise Search5TEMPLATE_IDTemplate Name in Enterprise Searchnvarchar320
104T5TMCSRDEFFLDField Names for Search Configuration2TEMPLATE_IDTemplate Name in Enterprise Searchnvarchar320
105T5TMCSRDEFFLDTField Names for Search Configurations3TEMPLATE_IDTemplate Name in Enterprise Searchnvarchar320
106T5TMCSREXNODESEnterprise Search Nodes2TEMPLATE_IDTemplate Name in Enterprise Searchnvarchar320
107T5TMCSROBJECTSHR Objects in Enterprise Search2TEMPLATE_IDTemplate Name in Enterprise Searchnvarchar320
108T5TMCSROBJFLDField Name for Object ID of Root Node in Search2TEMPLATE_IDTemplate Name in Enterprise Searchnvarchar320
109T77TMCAESFIELDAES Field Customizing5TEMPLATE_IDAppraisal Templatenvarchar80
110T77TMCDELEMPRCAssignments of Dyn. Elements of Templates to Processes2TEMPLATE_IDAppraisal Templatenvarchar80
111T77TMCELEMPRCAssignments of Elements of Templates to Processes2TEMPLATE_IDAppraisal Templatenvarchar80
112T77TMC_PRC_TMPL(Obsolete) Assignment of Templates to Processes7TEMPLATE_IDAppraisal Templatenvarchar80
113T77TMC_PROC_TAssignment of Generic Templates to Processes3TEMPLATE_IDAppraisal Templatenvarchar80
114T77TMC_P_TAssignment of Templates to Processes3TEMPLATE_IDAppraisal Templatenvarchar80
115T77TMC_P_VProcess Period and Grouping5TEMPLATE_IDAppraisal Templatenvarchar80
116T77TMC_S_TStatus Flows of Appraisal Templates2TEMPLATE_IDAppraisal Templatenvarchar80
TOPVariant Configuration
117PMEVC_AFFIX_TMPLTemplate with affix (i.e. prefix and postfix) rules2TEMPLATE_IDTemplate IDnvarchar300
TOPWorkforce Management Application
118WFAC_TRK_RT_MAPSchedule Track Group - Page Mapping3TEMPLATE_IDSchedule Track Template Idnvarchar100
119WFAC_TRK_TEMPSchedule Track Templates2TEMPLATE_IDSchedule Track Template Idnvarchar100
120WFAC_TRK_TEMP_TSchedule Track Templates2TEMPLATE_IDSchedule Track Template Idnvarchar100
121WFAC_TRK_TG_MAPSchedule Track Template - Group Mapping2TEMPLATE_IDSchedule Track Template Idnvarchar100
122WFA_EMP_WR_PERMEmployee work rule assigment and values4TEMPLATE_IDWork Rule Template Set IDnvarchar200
TOPWorkforce Management Core
123WFMC_TRK_RT_MAPSchedule Track Group - Page Mapping3TEMPLATE_IDSchedule Track Template Idnvarchar100
124WFMC_TRK_TEMPSchedule Track Templates2TEMPLATE_IDSchedule Track Template Idnvarchar100
125WFMC_TRK_TEMP_TSchedule Track Templates2TEMPLATE_IDSchedule Track Template Idnvarchar100
126WFMC_TRK_TG_MAPSchedule Track Template - Group Mapping2TEMPLATE_IDSchedule Track Template Idnvarchar100