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

174 columns | Print definition?ERP 6.0  | BO_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BOFU/C_BUS_ENTBusiness Entity : Database Table3BO_NAMENamenvarchar300
2/BOFU/DO_CUSTDO Customizing2BO_NAMEBusiness Objectnvarchar300
3/IAM/C_DOCSCMDocument Schema4BO_NAMEBusiness Objectnvarchar300
4EHFNDC_ACTPDMAction Priority Due Date Mapping2BO_NAMEBusiness Object Namenvarchar300
5EHFNDC_BONODEAuthorization Entity BO Nodes2BO_NAMEBusiness Object Namenvarchar300
6EHFNDC_BO_IMP_MABO Import Mapping for Side by Side migration2BO_NAMEBusiness Object Namenvarchar300
7EHFNDC_BO_IMP_MPBO Import Mapping2BO_NAMEBusiness Object Namenvarchar300
8EHFNDC_BO_IMP_PBO Import Profile2BO_NAMEBusiness Object Namenvarchar300
9EHFNDC_DSC_BOMAPDynamic Statement Creation - Mapping to BO Fields3BO_NAMEBusiness Object Namenvarchar300
10EHFNDC_DSC_CLMAPDynamic Statement Creation: Mapping to Assistant Class3BO_NAMEBusiness Object Namenvarchar300
11EHFNDC_EXP_FLDFields of Data Selection3BO_NAMEBusiness Object Namenvarchar300
12EHFNDC_EXP_FLD_TField Description4BO_NAMEBusiness Object Namenvarchar300
13EHFNDC_EXP_NODNode Structure of Data Selection3BO_NAMEName of a Business Objectnvarchar300
14EHFNDI_TS_SUBJSubject BO Configuration1BO_NAMEBusiness Object Namenvarchar300
15GRFNTASKBOWorkflow Task Business Objects4BO_NAMEObject Type Namenvarchar300
16GRFNTASKBOPARMAvailable BO variant for Task name3BO_NAMEObject Type Namenvarchar300
17LTR_PRESELLTR: Preselection Steps17BO_NAMELTR: Display Namenvarchar400
18NWS_EXT_MAP_DATAMapping Data Extract ByD10BO_NAMEBusiness objectnvarchar600
19QAMI_VALUATE_BOTable with Filter Values for Monitoring Control of BOs3BO_NAMEBusiness Objectnvarchar300
20SNWD_REV_HEADEPM: Review Header Table4BO_NAMEEPM: Business Object Namenvarchar300
21/BOBF/CONF_CHKEXBOPF Configuration Check Exceptions1BO_NAMENamenvarchar300
22/BOBF/D_CC_LOG_HBOPF Contract Compliance Check Log header6BO_NAMENamenvarchar300
23/BOBF/OBM_BOBOPF Configuration: Business Objects1BO_NAMENamenvarchar300
TOPActivity Clipboard
24CRMC_IC_LTX_URLDefinition of URL based Launch Transactions18BO_NAMEBusiness Object Name Within Enterprise Portalnvarchar500
TOPBusiness Configuration Tools Runtime
25SC2REP_CONFDATA(Preliminary) Configuration Repository for C2 Repository2BO_NAMEESF: Business Objectnvarchar300
26SC2_AP_CO_HEADERC2 Server: Business Configuration Object in Applicatn System2BO_NAMEC2: Configuration Objectnvarchar300
27SC2_BCO_ASSOC_FC2 Server: Association Field Links (Inactive)1BO_NAMEC2: Configuration Objectnvarchar300
28SC2_BCO_EXITConfiguration Object Exits1BO_NAMEC2: Configuration Objectnvarchar300
29SC2_BCO_HEADERC2 Server: Meta-Repository: Business Configuration Object1BO_NAMEC2: Configuration Objectnvarchar300
30SC2_BCO_NODEC2 Server: Meta-Repository: Nodes1BO_NAMEC2: Configuration Objectnvarchar300
31SC2_BCO_NODE_TABC2 Server: Node Attributes when Saving Tables1BO_NAMEC2: Configuration Objectnvarchar300
32SC2_BCO_PROPERTYConfiguration Object Attributes1BO_NAMEC2: Configuration Objectnvarchar300
33SC2_BO_ASSOCC2 Server: Associations in Active Configuration Object1BO_NAMEC2: Configuration Objectnvarchar300
34SC2_BO_ASSOC_FC2 Server: Field Links of Associations (Active)1BO_NAMEC2: Configuration Objectnvarchar300
35SC2_BO_EXITExits in Active Configuration Objects1BO_NAMEC2: Configuration Objectnvarchar300
36SC2_BO_FLD_MAPC2 Server: Short Field Names (from Last Activation)1BO_NAMEC2: Configuration Objectnvarchar300
37SC2_BO_HEADERC2 Server: Business Object at Last Activation1BO_NAMEC2: Configuration Objectnvarchar300
38SC2_BO_NODEC2 Server: Nodes at Last Activation1BO_NAMEC2: Configuration Objectnvarchar300
39SC2_BO_NODE_TABC2 Server: Nodes at Last Activation1BO_NAMEC2: Configuration Objectnvarchar300
40SC2_BO_PROPERTYAttributes of Active Configuration Objects1BO_NAMEC2: Configuration Objectnvarchar300
41SC2_CFG_ASSEMBLYAssemble Configuration Data2BO_NAMEESF: Business Objectnvarchar300
42SC2_DATA_CONTEXTChange Context: Configuration Data Assignment3BO_NAMEC2: Configuration Objectnvarchar300
43SC2_IPG_ACCESSC2: Implementation of Access Interface (Inactive)1BO_NAMEC2: Configuration Objectnvarchar300
44SC2_IPG_METHODC2: Generated Proxy Method (Inactive)1BO_NAMEC2: Configuration Objectnvarchar300
45SC2_IPG_METHODTC2: Inactive Generation Method Texts2BO_NAMEC2: Configuration Objectnvarchar300
46SC2_IPG_NODEC2: Inactive Node Generation Details1BO_NAMEC2: Configuration Objectnvarchar300
47SC2_IPG_PARAMC2: Inactive Method Parameters1BO_NAMEC2: Configuration Objectnvarchar300
48SC2_IPG_PARAMTC2: Inactive Description of Method Parameters2BO_NAMEC2: Configuration Objectnvarchar300
49SC2_IPG_QUERYC2: Inactive Generaed Proxy Method1BO_NAMEC2: Configuration Objectnvarchar300
50SC2_PGL_ACCESSC2 Server: Implementation of Access Interface (old)2BO_NAMEC2: Configuration Objectnvarchar300
51SC2_PGL_FLDMAPC2 Server: Field Names2BO_NAMEC2: Configuration Objectnvarchar300
52SC2_PGL_METHODSObject Node Methods2BO_NAMEC2: Configuration Objectnvarchar300
53SC2_PGL_METHODSTMethod Texts3BO_NAMEC2: Configuration Objectnvarchar300
54SC2_PGL_NODEC2 Server: (Old) Node Generation Details (Interface)2BO_NAMEC2: Configuration Objectnvarchar300
55SC2_PGL_NODE_TABC2 Server: Table Assignment to Node (Old)2BO_NAMEC2: Configuration Objectnvarchar300
56SC2_PG_ACCESSC2 Server: Access Interface Implementation2BO_NAMEC2: Configuration Objectnvarchar300
57SC2_PG_METHODC2 Server: Generated Proxy Method1BO_NAMEC2: Configuration Objectnvarchar300
58SC2_PG_METHODTC2 Server: Node Generation Details2BO_NAMEC2: Configuration Objectnvarchar300
59SC2_PG_NODEC2 Server: Node Generation Details2BO_NAMEC2: Configuration Objectnvarchar300
60SC2_PG_PARAMC2 Server: Method Parameters1BO_NAMEC2: Configuration Objectnvarchar300
61SC2_PG_PARAMTC2 Server: Method Parameter Description2BO_NAMEC2: Configuration Objectnvarchar300
62SC2_PG_QUERYC2 Server: Generated Proxy Method Range Table for Query1BO_NAMEC2: Configuration Objectnvarchar300
63SC2_PG_QUERYCC2 Server: Generated Proxy Method Compiled Range Table1BO_NAMEC2: Configuration Objectnvarchar300
TOPBusiness Objects, Common Components
64EHFNDC_BOBusiness Objects relevant for EHSM1BO_NAMEBusiness Object Namenvarchar300
65EHFNDC_BO_ND_DETDescribes a node of a bo in a human readable way1BO_NAMEBusiness Object Namenvarchar300
66EHFNDC_BO_OBNObject-Based Navigation for EHSM Business Objects1BO_NAMEBusiness Object Namenvarchar300
67EHFNDC_CTRL_CONFOBSOLETE Controls Configuration Usage2BO_NAMENamenvarchar300
68EHFNDC_FC_BO_PField Control BO Profile2BO_NAMEBusiness Object Namenvarchar300
69EHFNDC_FC_NDField Control BO Node2BO_NAMEBusiness Object Namenvarchar300
70EHFNDC_FC_NDP_ACField Control BO Node Profile: Action Property2BO_NAMEBusiness Object Namenvarchar300
71EHFNDC_FC_NDP_ASField Control BO Node Profile: Association Property2BO_NAMEBusiness Object Namenvarchar300
72EHFNDC_FC_NDP_ATField Control BO Node Profile: Attribute Property2BO_NAMEBusiness Object Namenvarchar300
73EHFNDC_FC_NDP_NDField Control BO Node Profile: BO Node Property2BO_NAMEBusiness Object Namenvarchar300
74EHFNDC_FC_ND_PField Control BO Node Profile2BO_NAMEBusiness Object Namenvarchar300
75EHFNDC_FC_ND_P_TField Control BO Node Profile (Description)3BO_NAMEBusiness Object Namenvarchar300
76EHFNDC_REG_BOOBSOLETE - Business Object the Regulation is relevant for3BO_NAMEBusiness Object Namenvarchar300
77EHFNDD_MAP_BOPATPath of Mapped BO Node12BO_NAMENamenvarchar300
78EHFNDD_MAP_MAPMapping4BO_NAMEBusiness Object Namentext10737418230
79EHFNDD_MAP_ROOTMapping Root4BO_NAMENamenvarchar300
80EHFNDI_BO_TESTDTable for BO test data (XML)2BO_NAMEBusiness Object Namenvarchar300
81EHFNDI_POWL_CONFPOWL Feeder class input configuration3BO_NAMENamenvarchar300
TOPBusiness Partner
82BPCE_BO_AOOBSOLETE2BO_NAMEOBSOLETEnvarchar300
83BPCE_BO_CHANNELOBSOLETE2BO_NAMEOBSOLETEnvarchar300
84BPCE_BO_LOOBSOLETE2BO_NAMEOBSOLETEnvarchar300
85BPCE_BO_VOOBSOLETE2BO_NAMEOBSOLETEnvarchar300
86CCXO_BO_IO_STRSemantic Structure for Business Objects (Customer)3BO_NAMEName of Business Objectnvarchar300
87CCXO_BO_SOAssignment of Segment Object to Business Object (Customer)3BO_NAMEName of Business Objectnvarchar300
88CCXO_BO_VOAssignment of Validation Object to Business Obj. (Customer)3BO_NAMEName of Business Objectnvarchar300
89CCXO_CHANNEL_BDTDefinition of Channel for Business Data Toolset (BDT)4BO_NAMEName of Business Objectnvarchar300
90CCXO_CNS_BOAssignment CNS and Handler for Each Business Object (Cust.)3BO_NAMEName of Business Objectnvarchar300
91CEXO_BO_IO_STRSemantic Structure for Business Objects3BO_NAMEName of Business Objectnvarchar300
92CEXO_BO_SOAssignment of Segment Object to Business Object3BO_NAMEName of Business Objectnvarchar300
93CEXO_BO_VOAssignment of Validation Object to Business Object3BO_NAMEName of Business Objectnvarchar300
94CEXO_CHANNEL_BDTDefinition of Channel for Business Data Toolset (BDT)4BO_NAMEName of Business Objectnvarchar300
95CEXO_CHANNEL_ESAChannel Definition for Enterprise Service Architecture (ESA)3BO_NAMEName of Business Objectnvarchar300
96CEXO_CNS_BOAssignment Between CNS and Handler for Each Business Object3BO_NAMEName of Business Objectnvarchar300
97FSBP_CC_IMAGETable for CC Image Data4BO_NAMEName of Business Objectnvarchar300
98FSBP_INFMSG_LOGPersistency for Identifying Transferred BP Changes4BO_NAMEName of Business Objectnvarchar300
TOPCross-Application Components
99/EAM/EAMT_BONAMEBackend BO Names4BO_NAMEBackend BO Namenvarchar200
TOPeCATT Extended Computer Aided Test Tool
100ECLOG_FAIL_ESFESF-Specific Message Parts in FAILURE Object10BO_NAMEESF Business Object Namentext10737418230
TOPEnterprise Service Framework Layer
101ESI_MAPPINGESI: External - Internal - Mapping for BO Nodes2BO_NAMEESF: Business Objectnvarchar300
102ESI_MAPPING_DBESI: External - Internal - Mapping for BO Nodes2BO_NAMEESF: Business Objectnvarchar300
103SCOL_BO_ADMINESF: Business Object - Properties1BO_NAMEESF: Business Objectnvarchar300
104SCOL_BO_ADMINTESF: Business Object - Short Description1BO_NAMEESF: Business Objectnvarchar300
105SCOL_BO_HEADERESF: Business Object - Properties1BO_NAMEESF: Business Objectnvarchar300
106SCOL_BO_HEADERTESF : Business Object (Short Description)1BO_NAMEESF: Business Objectnvarchar300
107SCOL_BO_NODEESF : Business Object - Node1BO_NAMEESF: Business Objectnvarchar300
108SCOL_BO_NODETESF : Business Object - Node (Short Description)1BO_NAMEESF: Business Objectnvarchar300
109SCOL_BO_NS_DECLSESF: Business Object - Properties1BO_NAMEESF: Business Objectnvarchar300
110SCOL_BO_PROPERTYESF : Business Object - Property1BO_NAMEESF: Business Objectnvarchar300
111SCOL_BO_QUERYObsolete1BO_NAMEESF: Business Objectnvarchar300
112SCOL_BO_QUERYTObsolete1BO_NAMEESF: Business Objectnvarchar300
113SCOL_BO_USESupported Business Objects of a Service Module2BO_NAMEESF: Business Objectnvarchar300
114SCOL_ND_ACTIONESF : Business Object - Action1BO_NAMEESF: Business Objectnvarchar300
115SCOL_ND_ACTIONTESF : Business Object - Action (Short Description)1BO_NAMEESF: Business Objectnvarchar300
116SCOL_ND_ASSOCESF : Business Object - Association1BO_NAMEESF: Business Objectnvarchar300
117SCOL_ND_ASSOCMAPObsolete1BO_NAMEESF: Business Objectnvarchar300
118SCOL_ND_ASSOCTESF : Business Object - Association (Short Description)1BO_NAMEESF: Business Objectnvarchar300
119SCOL_ND_QUERYESF : Business Object - Query1BO_NAMEESF: Business Objectnvarchar300
120SCOL_ND_QUERYTESF : Business Object - Query (Short Description)1BO_NAMEESF: Business Objectnvarchar300
121SCOL_WB_DATASETESF Test Environment : Test Data Management2BO_NAMEESF: Business Objectnvarchar300
TOPFoundation for EHS Management
122EHFNDC_FW_BI_EXTConfiguration of BI Extractors3BO_NAMEName of BOPF Business Objectnvarchar300
TOPGlobal Performance Analysis Transaction ST3
123AMESISUBGlobal Performance Analysis: ESI Statistics: Single Records6BO_NAMESAP Workload NW Collector: Busines Object Namenvarchar300
TOPIncident Interactive Forms and Print Forms
124EHHSSC_INC_F_REGIncident Report Form Regulation Configuration Table8BO_NAMEBusiness Object Namenvarchar300
TOPIntegration of FPM and Persistency Frameworks like BOPF
125/BOFU/IPBI_POWLAPOWL: Action Definition14BO_NAMEOBN BO namenvarchar500
TOPJapan
126T7JPBT_BSOFFICETBusiness Establishment Text Table4BO_NAMEBusiness Establishment Namenvarchar500
TOPNetWeaver Enterprise Search
127ESH_KEYMAP_RULESLongtext Extraction - Key Mapping Rules4BO_NAMEObject Typenvarchar200
TOPPortal Content
128ISTNLMOBNObject-Based Navigation - Definition of Activities7BO_NAMEName of the OBN Business Objectnvarchar300
129ISTNLMOBNFLObject-Based Navigation - Field Names Definition With Links5BO_NAMEName of the OBN Business Objectnvarchar300
130ISTNLMSVACTIONDefine Activity for Structure View9BO_NAMEName of the OBN Business Objectnvarchar300
TOPProxy Generation
131TPRX_DEMO_ADDCBEtest table for additional data BO cross eventing1BO_NAMEESF: Business Objectnvarchar300
TOPRetail Enterprise Services
132WESC_BOAvailable Business Objects (ESR)3BO_NAMEName in ESRnvarchar1200
TOPReusable Components of Business Suite Foundation
133/BOBF/C_ATT_BOAttachment Types for Business Object Nodes2BO_NAMEBusiness Objectnvarchar300
134/BOBF/I_OTCCode List: Object Type Code2BO_NAMEBusiness Object Namenvarchar300
135/BOFU/CFCNODEField Control: BO Node2BO_NAMEBusiness Objectnvarchar300
136/BOFU/CFCNPRAField Control: Attribute Properties2BO_NAMEBusiness Objectnvarchar300
137/BOFU/CFCNPRCField Control: Node Properties(Core Service Properties)2BO_NAMEBusiness Objectnvarchar300
138/BOFU/CFCNPROField Control: BO Node Profile2BO_NAMEBusiness Objectnvarchar300
139/BOFU/CFCNPRSField Control: Association Properties2BO_NAMEBusiness Objectnvarchar300
140/BOFU/CFCNPRTField Control: Node Profiles (text)3BO_NAMEBusiness Objectnvarchar300
141/BOFU/CFCNPRXField Control: Action Properties2BO_NAMEBusiness Objectnvarchar300
142/BOFU/CFCPROField Control: BO Profiles2BO_NAMEBusiness Objectnvarchar300
143/BOFU/CFCPROAField Control: Active Profiles for BOs2BO_NAMEBusiness Objectnvarchar300
144/BOFU/CFCPROTField Control: BO Profiles (text)3BO_NAMEBusiness Objectnvarchar300
145/BOFU/CFC_BPROFField Control: BO Profiles2BO_NAMEBusiness Objectnvarchar300
146/BOFU/C_AC_BOAuthority Check Customizing for Business Object Node2BO_NAMEBusiness Objectnvarchar300
147/BOFU/C_AC_FLDAuthority Field Mapping to Business Object Attributes2BO_NAMEBusiness Objectnvarchar300
148/BOFU/C_AC_FLTFilter for Authority Check Relevant BO Node Data2BO_NAMEBusiness Objectnvarchar300
149/BOFU/C_AC_OBJAuthority Object Assignment to Business Object NodeAssignmen2BO_NAMEBusiness Objectnvarchar300
150/BOFU/C_ARCHRETPArchiving Adapter: BO Specific Residence Period2BO_NAMEBusiness Objectnvarchar300
151/BOFU/C_TXC_DSText Schema: Assignment to BO/Node2BO_NAMEBusiness Object Namenvarchar300
152/BOFU/I_EXTROBSOLETE: BI Extractor include per Business Object Node1BO_NAMEBusiness Objectnvarchar300
153/BOFU/I_FCNODEField Control: Communication Structure1BO_NAMEBusiness Objectnvarchar300
154/BOFU/I_OBM_ACCBO Specific Auth Check Settings1BO_NAMEBusiness Objectnvarchar300
155/BOFU/I_OBM_ADDRHosting BO specific settings for DO Address1BO_NAMEBusiness Objectnvarchar300
156/BOFU/I_OBM_ARCHArchiving Adapter: BO Specific Settings1BO_NAMEBusiness Objectnvarchar300
157/BOFU/I_OBM_CDOChange Documents Adapter: BO Specific Settings1BO_NAMEBusiness Objectnvarchar300
158/BOFU/SFC_BPROFField Control: BO Profiles2BO_NAMEBusiness Objectnvarchar300
159/BOFU/S_TXC_DSText Schema: Default assignment to BO/Node1BO_NAMEBusiness Object Namenvarchar300
160/BSAM/I_STMSCHSTM Status Schema2BO_NAMEStatus Management: Business Object Namenvarchar300
TOPRisk Assessment
161EHHSSC_REASONReasons for Risk Assessment5BO_NAMEBusiness Object Namenvarchar300
TOPService Implementation Workbench
162TSIW_PROJRoot Table for project17BO_NAMEBusiness Object Name (Full Name, No Blanks)nvarchar1200
TOPStatus and Action Management
163SAMDT_SCHEMASS&AM Schemas3BO_NAMES&AM Business objectsnvarchar300
164SAMSD2BOBO Node to Status Model Relation1BO_NAMES&AM Business objectsnvarchar300
165SAMSDELEMStatus Model Actions, Operators and Derivators1BO_NAMES&AM Business objectsnvarchar300
166SAMSDRELStatus Model Edges1BO_NAMES&AM Business objectsnvarchar300
167SAMSDVARStatus Models Variables1BO_NAMES&AM Business objectsnvarchar300
168SAMSDVVALStatus Values of the Status Variables in Status Model1BO_NAMES&AM Business objectsnvarchar300
169SAM_ELEMENTSSAM elements1BO_NAMES&AM Business objectsnvarchar300
170SAM_HEADERS&AM Header table1BO_NAMES&AM Business objectsnvarchar300
171SAM_RELATIONSSAM Relations1BO_NAMES&AM Business objectsnvarchar300
172SAM_STAT_VALUESAM Status values1BO_NAMES&AM Business objectsnvarchar300
TOPUse AP-MD-BP Components
173TB003ABP role categories7BO_NAMEESF: Business Objectnvarchar300
TOPWeb Services Tool
174CRMC_WSC_OBJTREEWSC Object Tree Table8BO_NAMEExternal Name of Assigned Objectnvarchar300