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

164 columns | Print definition?ERP 6.0  | APPL_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/UI2/TMUI BE: Target Mapping9APPL_IDntext10737418230
2/UI2/TM_CLIENTUI BE: Target Mapping - client specific10APPL_IDntext10737418230
3/XFT/SRM_CAN10CAN: Classification and Navigation6APPL_IDCAN: Application IDnvarchar1200
4/XFT/UG_001User Groups4APPL_IDApplication IDnvarchar1200
5CNVTDMSSCR_APLNKLink Table : Connects Rules and Proc Types4APPL_IDApplication IDnvarchar320
6CNVTDMSSCR_APPLApplication Master Table for Scrambling4APPL_IDApplication IDnvarchar320
7CNVTDMSSCR_APPLTApplication Text Table4APPL_IDApplication IDnvarchar320
8CNVTDMSSCR_GRPScrambling Groups5APPL_IDApplication IDnvarchar320
9CNVTDMSSCR_MIDMapping ID's for Scrambling.7APPL_IDApplication IDnvarchar320
10CNVTDMSSCR_RULEScrambling Rules5APPL_IDApplication IDnvarchar320
11EHFNDI_POWL_EASYPOWL feeder class easy search configuration1APPL_IDApplication IDnvarchar300
12FDT_BRS_DSM_0010BRS DSM: Assignment of Applications to Managed Systems2APPL_IDFDT: Universal Unique Identifiernvarchar320
13GHO_APPLICATIONApplication Master2APPL_IDApplication IDnvarchar50
14GHO_APPL_OBJ_IDApplication Object Table2APPL_IDApplication IDnvarchar50
15GHO_APPL_TText Table for Application Master2APPL_IDApplication IDnvarchar50
16HRP1107DB Table for Infotype 110730APPL_IDApplication IDnvarchar480
17HRSFI_D_ONB_ERRSuccessFactors: Messages from Onboarding Integration4APPL_IDApplication IDnvarchar1280
18HRSFI_D_ONB_GERSuccessFactors: General Messages from Onboarding Integration5APPL_IDApplication IDnvarchar1280
19HRSFI_D_ONB_IMPSuccessFactors: Staging Area for Onboarding Applicants4APPL_IDApplication IDnvarchar1280
20HRSFI_D_RCT_ERRSuccessFactors: Messages from Recruiting Import2APPL_IDApplication IDnvarchar480
21HRSFI_D_RCT_GERSuccessFactors: General Messages from Recruiting Import4APPL_IDApplication IDnvarchar480
22HRSFI_D_RCT_LOGSuccessFactors: Staging Area for Recruiting Import2APPL_IDApplication IDnvarchar480
23HRSFI_D_RCT_REQChange Pointer Table for Job Requisitions25APPL_IDApplication IDnvarchar480
24MASS_C_PARALLELSetting for MASS parallel customizing2APPL_IDApplication Enabled for Mass Processingnvarchar20
25RSBPCA_APPLBPC model information2APPL_IDBPC: Application IDnvarchar200
26RSBPCA_APPLTBPC Model description text2APPL_IDBPC: Application IDnvarchar200
27RSBPCA_APPL_IPRVBPC information about infoproviders in model2APPL_IDBPC: Application IDnvarchar200
28RSBPCE_DAP_DIMBPC: DAP Dimension & Hierarchy5APPL_IDBPC: Application IDnvarchar200
29RSBPCK_AO_RBPC IP Extension: Workbook relationship3APPL_IDBPC: Application IDnvarchar200
30RSBPCU_DA_CTLBPC-PAK: Data Audit Control Table2APPL_IDBPC: Application IDnvarchar200
31RSBPCW_APP_STATUApplication lock status cache2APPL_IDBPC: Application IDnvarchar200
32RSBPCW_EMAIL_CFGWork Status Email Confiuration2APPL_IDBPC: Application IDnvarchar200
33RSBPCW_LCK_DIMBPC Work Status - Lock Dimension Table2APPL_IDBPC: Application IDnvarchar200
34RSBPCW_STATCODEBPC Work Status - Status Code Table2APPL_IDBPC: Application IDnvarchar200
35RSBPCW_STATCODETBPC Work Status - Status Code Text Table2APPL_IDBPC: Application IDnvarchar200
36RSBPCW_STATCOMPBPC Work Status - Component Enablement Status for Work State2APPL_IDBPC: Application IDnvarchar200
37RSBPCW_WK_STATUSBPC Work Status: Meta Info for Work Status2APPL_IDBPC: Application IDnvarchar200
38T7PIQAPPStudent Self Service Adobe Applications2APPL_IDApplication IDnvarchar40
TOPBasic Data
39NCEM_REG_EVENTSaves Events in Relation to Event Handler4APPL_IDApplication ID for ISH-CM Event Frameworknvarchar300
40TNCEM_ELListener Attributes Managed by Event Manager2APPL_IDApplication ID for ISH-CM Event Frameworknvarchar300
41TNCEM_ORDDetermines Event Sequence Relation2APPL_IDApplication ID for ISH-CM Event Frameworknvarchar300
42TNCEM_SUBSCRIPTListener Subscription Data for Event Manager2APPL_IDApplication ID for ISH-CM Event Frameworknvarchar300
TOPBRFplus - ABAP-Based Business Rules
43FDT_ADMN_0201FDT: GTABKEY - APPL Name + UUID Registration3APPL_IDFDT: Universal Unique Identifiernvarchar320
44FDT_CURR_CONV0Currency Conversion Info - Application specific2APPL_IDFDT: Universal Unique Identifiernvarchar320
45FDT_CURR_CONV1Currency Conversion Info - Expression specific7APPL_IDFDT: Universal Unique Identifiernvarchar320
46FDT_TEST_XMLFDT: Table for Test Data to be processed in UnitTest1APPL_IDFDT: Universal Unique Identifiernvarchar320
TOPBusiness Objects, Common Components
47EHFNDI_POWL_CONFPOWL Feeder class input configuration1APPL_IDApplication IDnvarchar300
48EHFNDI_POWL_RESPOWL feeder class result layout view configuration5APPL_IDApplication IDnvarchar300
TOPBusiness Partner
49CCXO_CHANNEL_CNSAssignment of a CNS Application ID to BO Type (Customer)2APPL_IDApplication in Change Notification Servicenvarchar40
50CEXO_CHANNEL_CNSAssignment of CNS Application ID to BO Type2APPL_IDApplication in Change Notification Servicenvarchar40
TOPCentral Part of Product Master
51COMC_CRD_GEN_BW0CRM CRD: Relevant Fields of the Link and Master Data Table2APPL_IDIdentification Application for Extractor-Generationnvarchar300
52COMC_CRD_GEN_BWACRM CRD: Applications for the Extractor-Generation1APPL_IDIdentification Application for Extractor-Generationnvarchar300
53COMC_CRD_GEN_BWCCRM CRD: Compound for Fields from Product Extensions1APPL_IDIdentification Application for Extractor-Generationnvarchar300
54COMC_CRD_GEN_BWDCRM CRD: Generated Text DataSources for Domains1APPL_IDIdentification Application for Extractor-Generationnvarchar300
55COMC_CRD_GEN_BWICRM CRD: Relevant Fields of the Link and Master Data Table1APPL_IDIdentification Application for Extractor-Generationnvarchar300
56COMC_CRD_GEN_BWJCRM CRD: Do Not Use1APPL_IDIdentification Application for Extractor-Generationnvarchar300
57COMC_CRD_GEN_BWKCRM CRD: Join-Conditions of the Object Tables1APPL_IDIdentification Application for Extractor-Generationnvarchar300
58COMC_CRD_GEN_BWOCRM CRD: Generated Objects for Attribute-DataSources1APPL_IDIdentification Application for Extractor-Generationnvarchar300
59COMC_CRD_GEN_BWSCRM CRD: Selection Fields for Generated Attribute DataSource1APPL_IDIdentification Application for Extractor-Generationnvarchar300
60COMC_CRD_GEN_BWTCRM CRD: Application Tables1APPL_IDIdentification Application for Extractor-Generationnvarchar300
61COMC_CRD_GEN_BWVCRM CRD: Join-Conditions of the Link and (Master) Data Tab.1APPL_IDIdentification Application for Extractor-Generationnvarchar300
TOPChange Pointer Service
62CNS_CPCNS: Change Pointer3APPL_IDApplication IDnvarchar40
63TCNS_APPLCNS: Applications1APPL_IDApplication IDnvarchar40
64TCNS_APPLTCNS: Application Description1APPL_IDApplication IDnvarchar40
65TCNS_BASIC_CUSTCNS: Settings for Export Object Types2APPL_IDApplication IDnvarchar40
66TCNS_EXPOBJCNS: Export Object Types1APPL_IDApplication IDnvarchar40
67TCNS_EXPOBJTCNS: Export Object Type Description1APPL_IDApplication IDnvarchar40
68TCNS_EXP_RECCNS: Export Object Type for Recipient Combination1APPL_IDApplication IDnvarchar40
69TCNS_MAPPIN_CUSTCNS: Mapping Receiver to Export Object Types2APPL_IDApplication IDnvarchar40
70TCNS_RECV_CUSTCNS: Recipient Settings2APPL_IDApplication IDnvarchar40
71TCNS_SET_EXPOBJOBSOLETE: Settings for Export Object Type2APPL_IDApplication IDnvarchar40
72TCNS_SET_RECVOBSOLETE: Assignment of Recipient to Export Object Type2APPL_IDApplication IDnvarchar40
TOPCollaborative Cross Applications
73/POA/C_CLM_APGAPI Groups and Application3APPL_IDApplication IDnvarchar30
74/POA/C_CLM_APPApplication2APPL_IDApplication IDnvarchar30
75/POA/D_CLM_MD01Metadata7APPL_IDApplication IDnvarchar30
76/POA/I_CLM_APPApplication1APPL_IDApplication IDnvarchar30
77/POA/I_CLM_APP_TApplication Descriptions1APPL_IDApplication IDnvarchar30
TOPCommunication Services Mail, Fax, SMS, Telephony
78BCST_SRBCS: Status of Send Orders30APPL_IDApplication IDnvarchar40
TOPEmployee Self-Service for Concurrent Employment
79T7XSSCESTATFLTRStatus validity filtering for an assignment2APPL_IDApplication Identifier for Self-Servicesnvarchar400
80T7XSSCE_GRPGroup definition settings for ESS CE applications2APPL_IDApplication Identifier for Self-Servicesnvarchar400
81T7XSSSERINFTYInfotype for ESS PersInfo Services1APPL_IDApplication Identifier for Self-Servicesnvarchar400
TOPEnterprise SOA
82BSSOA_RSPR_CORResponse Receiver Correlation6APPL_IDApplication IDntext10737418230
TOPHierarchical Derivation Service
83THDS_GENCATLCatalog for Generation2APPL_IDApplication IDnvarchar200
84THDS_GENCATLFCatalog for Generation2APPL_IDApplication IDnvarchar200
85THDS_GENCATLF_ACatalog for Generation2APPL_IDApplication IDnvarchar200
86THDS_GENCATLF_SCatalog for Generation1APPL_IDApplication IDnvarchar200
87THDS_GENCATL_ACatalog for Generation2APPL_IDApplication IDnvarchar200
88THDS_GENCATL_SCatalog for Generation1APPL_IDApplication IDnvarchar200
89THDS_NODENodes of a Derivation Tree2APPL_IDApplication IDnvarchar200
90THDS_NODETText Table for THDS_NODE3APPL_IDApplication IDnvarchar200
91THDS_NODET_AText Table for THDS_NODE_A3APPL_IDApplication IDnvarchar200
92THDS_NODET_SText Table for THDS_NODE_S2APPL_IDApplication IDnvarchar200
93THDS_NODE_ANodes of a Derivation Tree2APPL_IDApplication IDnvarchar200
94THDS_NODE_SNodes of a Derivation Tree1APPL_IDApplication IDnvarchar200
95THDS_TREEHeader of a Derivation Tree2APPL_IDApplication IDnvarchar200
96THDS_TREETText Table for THDS_TREE3APPL_IDApplication IDnvarchar200
97THDS_TREET_AText Table for THDS_TREE_A3APPL_IDApplication IDnvarchar200
98THDS_TREET_SText Table for THDS_TREE_S2APPL_IDApplication IDnvarchar200
99THDS_TREE_AHeader of a Derivation Tree2APPL_IDApplication IDnvarchar200
100THDS_TREE_ACTIVEComprises Active Versions of Trees2APPL_IDApplication IDnvarchar200
101THDS_TREE_ACT_AComprises Active Versions of Trees2APPL_IDApplication IDnvarchar200
102THDS_TREE_ACT_SComprises Active Versions of Trees1APPL_IDApplication IDnvarchar200
103THDS_TREE_HISTHistory Table - HDS Trees2APPL_IDApplication IDnvarchar200
104THDS_TREE_HIST_AHistory Table - HDS Trees2APPL_IDApplication IDnvarchar200
105THDS_TREE_HIST_SHistory Table - HDS Trees1APPL_IDApplication IDnvarchar200
106THDS_TREE_SHeader of a Derivation Tree1APPL_IDApplication IDnvarchar200
TOPOffice Suite Program
107/OSP/T_BHV_APPLApplication Details2APPL_IDApplication IDnvarchar40
108/OSP/T_BHV_APPLTText Table for Application3APPL_IDApplication IDnvarchar40
109/OSP/T_BHV_SCNScenario Details2APPL_IDApplication IDnvarchar40
110/OSP/T_BHV_SCNTText Table for Scenario3APPL_IDApplication IDnvarchar40
111/OSP/T_MDR_APPLApplication Details2APPL_IDApplication IDnvarchar40
112/OSP/T_MDR_APPLTText Table for Application3APPL_IDApplication IDnvarchar40
113/OSP/T_MDR_SCNScenario Details2APPL_IDApplication IDnvarchar40
114/OSP/T_MDR_SCNTText Table for Scenario3APPL_IDApplication IDnvarchar40
115SOSP_T_APPL_CHTable to maintain API info for Applications2APPL_IDApplication IDnvarchar60
116SOSP_T_APPL_INFOApplication / Scenario Information2APPL_IDApplication IDnvarchar60
117SOSP_T_APPL_TEXTApplication Description3APPL_IDApplication IDnvarchar60
118SOSP_T_SAPPL_DETSub Application Detail2APPL_IDApplication IDnvarchar60
119SOSP_T_STATCOD_TStatus Code description3APPL_IDApplication IDnvarchar60
120SOSP_T_STAT_ACTNStatus Transition - Action customization3APPL_IDApplication IDnvarchar60
121SOSP_T_STAT_CODEStatus Definition2APPL_IDApplication IDnvarchar60
122SOSP_T_STAT_TRAStatus Transition Maintenance2APPL_IDApplication IDnvarchar60
123SOSP_T_TASK_INFOTable for Maintaining Task Info2APPL_IDApplication IDnvarchar60
124SOSP_T_WF_DECSNWorkflow Decision2APPL_IDApplication IDnvarchar60
125SOSP_T_WF_DECS_TWorkflow Decision Description3APPL_IDApplication IDnvarchar60
126SOSP_T_WF_IDTable to Maintain WF ID for Applications2APPL_IDApplication IDnvarchar60
127SOSP_T_WF_INFOTable to Maintain WF info for Applications2APPL_IDApplication IDnvarchar60
TOPProcess Management
128TCOOPC_APPL_IDOPC: Control Table for Application IDs1APPL_IDOPC: Application ID (for OPC Callbacks)nvarchar40
129TCOOPC_APPL_IDTOPC: Text Table for Application IDs1APPL_IDOPC: Application ID (for OPC Callbacks)nvarchar40
TOPProduct Cost Planning
130CKQS_MAP_IDMapping of Costing Run ID + Data Basis to Variant5APPL_IDApplication IDnvarchar50
TOPProduct Lifecycle Management
131CPROW_GUIDMAPAssignment: GUID <-> External ID4APPL_IDWebDAV Identifier for Applicationnvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
132TFMCA_FPF_BRFPAPFPF: determination of BRF+ application and function6APPL_IDFDT: Universal Unique Identifiernvarchar320
TOPReal Estate
133TCMS_RE_ACS_SASAcs type - Sub Asset relation2APPL_IDParticipating application IDnvarchar60
134TCMS_RE_APPLCustomizing table for Applications2APPL_IDParticipating application IDnvarchar60
135TCMS_RE_APPL_TApplication name(Text table)2APPL_IDParticipating application IDnvarchar60
136TCMS_RE_EX_BPRLCustomizing table for External BuPa roles2APPL_IDParticipating application IDnvarchar60
137TCMS_RE_EX_DOCCustomizing table for External Doc types2APPL_IDParticipating application IDnvarchar60
138TCMS_RE_EX_TYPCustomizing table for External object types2APPL_IDParticipating application IDnvarchar60
139TCMS_RE_PRT_SASBuilding Part type - Sub Asset relation2APPL_IDParticipating application IDnvarchar60
TOPReport Tree
140SERPTUSERReporting: User trees3APPL_IDApplication ID for reporting treesnvarchar40
TOPSAP Business Workflow
141SWFSLSAPPLCUSDeadline Service: Application Customizing1APPL_IDApplication Componentnvarchar200
142SWFSLSAPPLCUSTDeadline Service: Description of the Application2APPL_IDApplication Componentnvarchar200
143SWFSLSDEADLDeadline Service: Deadline Table3APPL_IDApplication Componentnvarchar200
TOPSession Manager
144SRTAPPLAssignment of Report Tree IDs to Application IDs2APPL_IDApplication ID for reporting treesnvarchar40
TOPSuite Inbox
145IBO_C_BE_SYSTConnected Back-End Systems for Inbox2APPL_IDApplication IDnvarchar300
146IBO_C_WF_ACCActions of Inbox2APPL_IDApplication IDnvarchar300
147IBO_C_WF_ACSActions of Inbox2APPL_IDApplication IDnvarchar300
148IBO_C_WF_APCList of properties for actions2APPL_IDApplication IDnvarchar300
149IBO_C_WF_APSList of properties for actions2APPL_IDApplication IDnvarchar300
150IBO_C_WF_CACList of custom attributes for the task types2APPL_IDApplication IDnvarchar300
151IBO_C_WF_CASList of custom attributes for the task types2APPL_IDApplication IDnvarchar300
152IBO_C_WF_CUSTInbox View Customizing Table2APPL_IDApplication IDnvarchar300
153IBO_C_WF_TACTasks for Inbox Configuration2APPL_IDApplication IDnvarchar300
154IBO_C_WF_TAETasks for Inbox Configuration (Exceptions in Multibackend)2APPL_IDApplication IDnvarchar300
155IBO_C_WF_TASTasks for Inbox Configuration2APPL_IDApplication IDnvarchar300
156IBO_C_WF_TA_P_HCAssociation of Workflow Task ID to POWL Type (Hide)2APPL_IDApplication IDnvarchar300
157IBO_C_WF_TA_P_SCAssociation of Workflow Task ID to POWL Type (Show)2APPL_IDApplication IDnvarchar300
158IBO_C_WF_TA_P_TYAssociation of Workflow Task ID to POWL Type2APPL_IDApplication IDnvarchar300
159IBO_C_WF_TTAClist of actions allowed per task2APPL_IDApplication IDnvarchar300
160IBO_C_WF_TTAEList of Allowed Actions per Task2APPL_IDApplication IDnvarchar300
161IBO_C_WF_TTASList of Allowed Actions per Task2APPL_IDApplication IDnvarchar300
TOPWeb Channel Builder
162COM_WCB_CFG_WFWCB Configuration Approval Status Details6APPL_IDWCB Config Application IDnvarchar500
TOPWeb Service and SOAP - ABAP
163SRT_SOAM_APPL_IDSOAManager Connectivity : List of Application IDs & Version1APPL_IDSOAManager Connectivity : Application IDnvarchar300
164SRT_SOAM_CONNECTSOAManager Connectivity : Application data for distribution9APPL_IDSOAManager Connectivity : Application IDnvarchar300