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

78 columns | Print definition?ERP 6.0  | BO_KEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BOBF/ACF_MAPBOPF Configuration: ACF mapping7BO_KEYBusiness Objectvarbinary160
2/BOBF/AUTH_OBJBOPF Configuration: ACF Definition6BO_KEYBusiness Objectvarbinary160
3/BOBF/OBM_AK_FLDBOPF Configuration: Fieldnames for Alternative Key7BO_KEYBusiness Objectvarbinary160
4/BOBF/TUI_SELFLDContains selected field by user2BO_KEYBusiness Objectvarbinary160
5/IAM/C_NOTIF_QRYQuery used to determine BO instances for reminder3BO_KEYBusiness Objectnvarchar300
6/IAM/C_STATAActions for Status Changes5BO_KEYBusiness Object Key (with Conversion Exit)nvarchar320
7/IAM/C_STPRFStatus Profile4BO_KEYBusiness Object Key (with Conversion Exit)nvarchar320
8/IAM/I_NOTIF_QRYQuery used to determine BO instances for reminder3BO_KEYBusiness Object Key (with Conversion Exit)nvarchar320
9EHFNDD_BO_INDEXIndex table for BO search3BO_KEYBO Reference - Definition Key of the Business Objectvarbinary160
10EHPRCD_TASK_MIGTask to Workflow Migration table4BO_KEYBusiness Objectvarbinary160
11/BOBF/ACT_CONFBOPF Configuration: Assignment of Action to a Node Category5BO_KEYBusiness Objectvarbinary160
12/BOBF/ACT_LISTBOPF Configuration: Action5BO_KEYBusiness Objectvarbinary160
13/BOBF/ACT_LISTTBOPF Configuration: Text Table for /BOPF/ACT_LIST6BO_KEYBusiness Objectvarbinary160
14/BOBF/DAC_DATABOPF: Generic Data Storage for Rapid Prototyping3BO_KEYnvarchar320
15/BOBF/DET_CONFBOPF Configuration: Execution times of determinations5BO_KEYBusiness Objectvarbinary160
16/BOBF/DET_LISTBOPF Configuration: Determination5BO_KEYBusiness Objectvarbinary160
17/BOBF/DET_LISTTBOPF Configuration: Text Table for /BOPF/DET_LIST6BO_KEYBusiness Objectvarbinary160
18/BOBF/DET_NETBOPF Configuration: Determination sequence definition5BO_KEYBusiness Objectvarbinary160
19/BOBF/FRW_ADNACTActivation of addons4BO_KEYBusiness Objectvarbinary160
20/BOBF/OBM_ALTKETBOPF Configuration: Text Table for /BOPF/OBM_ALTKEY6BO_KEYBusiness Objectvarbinary160
21/BOBF/OBM_ALTKEYBOPF Configuration: Alternative Keys5BO_KEYBusiness Objectvarbinary160
22/BOBF/OBM_ASSOCBOPF Configuration: Association5BO_KEYBusiness Objectvarbinary160
23/BOBF/OBM_ASSOCBBOPF Configuration: Association Binding5BO_KEYBusiness Objectvarbinary160
24/BOBF/OBM_ASSOCCBOPF Configuration: Node Category assignment to associations5BO_KEYBusiness Objectvarbinary160
25/BOBF/OBM_ASSOCTBOPF Configuration: Text Table for /BOPF/OBM_ASSOC6BO_KEYBusiness Objectvarbinary160
26/BOBF/OBM_BOBOPF Configuration: Business Objects4BO_KEYBusiness Objectvarbinary160
27/BOBF/OBM_CODE_LBOPF Code Lists for Code Value Sets5BO_KEYBusiness Objectvarbinary160
28/BOBF/OBM_DISELBOPF Configuration: Disabled Elements5BO_KEYBusiness Objectvarbinary160
29/BOBF/OBM_FINORDBOBF finalization order5BO_KEYBusiness Objectvarbinary160
30/BOBF/OBM_GEN_INBOPF Configuration: Generation information5BO_KEYBusiness Objectvarbinary160
31/BOBF/OBM_GROUPBOPF Configuration: Group5BO_KEYBusiness Objectvarbinary160
32/BOBF/OBM_GROUPCBOPF Configuration: Assignment Group / Content5BO_KEYBusiness Objectvarbinary160
33/BOBF/OBM_GROUPTBOPF Configuration: Text Table for /BOPF/OBM_GROUP6BO_KEYBusiness Objectvarbinary160
34/BOBF/OBM_MAPBOPF Configuration: Mapping of External and Internal Field N5BO_KEYBusiness Objectvarbinary160
35/BOBF/OBM_NCATBOPF Configuration: Node Category5BO_KEYBusiness Objectvarbinary160
36/BOBF/OBM_NCATTBOPF Configuration: Text Table for /BOPF/OBM_NCAT6BO_KEYBusiness Objectvarbinary160
37/BOBF/OBM_NODEBOPF Configuration: Node5BO_KEYBusiness Objectvarbinary160
38/BOBF/OBM_NODETBOPF Configuration: Text Table for /BOPF/OBM_NODE6BO_KEYBusiness Objectvarbinary160
39/BOBF/OBM_OBJBOPF Configuration: Version5BO_KEYBusiness Objectvarbinary160
40/BOBF/OBM_OBJTBOPF Configuration: Text Table for /BOPF/OBM_OBJ6BO_KEYBusiness Objectvarbinary160
41/BOBF/OBM_PROPTYBOPF Configuration: Static Properties5BO_KEYBusiness Objectvarbinary160
42/BOBF/OBM_PRXPTYBOPF Configuration: Static Proxy Properties5BO_KEYBusiness Objectvarbinary160
43/BOBF/OBM_QUERYBOPF Configuration: Query5BO_KEYBusiness Objectvarbinary160
44/BOBF/OBM_QUERYTBOPF Configuration: Text Table for /BOPF/OBM_QUERY6BO_KEYBusiness Objectvarbinary160
45/BOBF/OBM_RTWBOPF Configuration: Dependencies between Logic and Nodes5BO_KEYBusiness Objectvarbinary160
46/BOBF/OBM_RTW_ABOPF Configuration: Attributes for Trigger definitions5BO_KEYBusiness Objectvarbinary160
47/BOBF/OBM_SUBSCRBOBF BO subscriptions5BO_KEYBusiness Objectvarbinary160
48/BOBF/OBM_VRSBOPF Configuration: Model Versions4BO_KEYBusiness Objectvarbinary160
49/BOBF/OBM_VSETBOPF Configuration: Value Set5BO_KEYBusiness Objectvarbinary160
50/BOBF/OBM_VSETTBOPF Configuration: Text Table of /BOPF/OBM_VSET6BO_KEYBusiness Objectvarbinary160
51/BOBF/STA_DERIVBOPF Configuration: Status Derivator5BO_KEYBusiness Objectvarbinary160
52/BOBF/STA_DERIVTBOPF Configuration: Text Table of /BOPF/STA_DERIV6BO_KEYBusiness Objectvarbinary160
53/BOBF/STA_SCHEMABOPF Configuration: Status Scheme5BO_KEYBusiness Objectvarbinary160
54/BOBF/STA_SCHEMTBOPF Configuration: Text Table of /BOPF/STA_SCHEME6BO_KEYBusiness Objectvarbinary160
55/BOBF/STA_VARBOPF Configuration: Status Variable5BO_KEYBusiness Objectvarbinary160
56/BOBF/STA_VARTBOPF Configuration: Text Table of /BOPF/STA_ATTR6BO_KEYBusiness Objectvarbinary160
57/BOBF/TOOL_ACCTRTracedata for Node Access Trace Tool2BO_KEYBusiness Objectvarbinary160
58/BOBF/TOOL_TRACEBOPF Trace Activation3BO_KEYBusiness Objectvarbinary160
59/BOBF/TUI_QRYVARContains Query Variants3BO_KEYBusiness Objectvarbinary160
60/BOBF/VAL_CONFBOPF Configuration: Assignment of Validations to Actions5BO_KEYBusiness Objectvarbinary160
61/BOBF/VAL_LISTBOPF Configuration: List of all validations5BO_KEYBusiness Objectvarbinary160
62/BOBF/VAL_LISTTBOPF Configuration: Text Table for /BOPF/VAL_LIST6BO_KEYBusiness Objectvarbinary160
63/BOBF/VAL_NETBOPF Configuration: Sequence definition of validations5BO_KEYBusiness Objectvarbinary160
TOPBusiness Objects, Common Components
64EHFNDD_BO_ASAVEBOBF BO auto save4BO_KEYBusiness Objectvarbinary160
65EHFNDI_POWL_CONFPOWL Feeder class input configuration7BO_KEYBusiness Objectvarbinary160
66EHFNDI_POWL_RESPOWL feeder class result layout view configuration2BO_KEYBusiness Objectvarbinary160
TOPPost Processing Framework Adapter
67/BOFU/C_PPF_CONFBO Node Specific settings for PPF usage15BO_KEYBusiness Objectvarbinary160
68/BOFU/C_PPF_DOADirect Outputs: w/o PPF, w/o History; Immediate Outputs12BO_KEYBusiness Objectvarbinary160
69/BOFU/C_PPF_PROFAssign PPF Profiles for Business Object Nodes11BO_KEYBusiness Objectvarbinary160
70/BOFU/DPPFCNTRPPF Container: Persistant connection to PPF from BOPF2BO_KEYBusiness Object Key (with Conversion Exit)nvarchar320
71/BOFU/DPPFEXT_COutput Management: Ext Comm - PDF Content Repository6BO_KEYBusiness Object Key (with Conversion Exit)nvarchar320
TOPReusable Components of Business Suite Foundation
72/BOBF/C_ATT_BOAttachment Types for Business Object Nodes6BO_KEYNodeIDvarbinary160
73/BOFU/C_TXC_DSText Schema: Assignment to BO/Node6BO_KEYNodeIDvarbinary160
74/BOFU/FDTEXP100Expression BO Retrieve: Header Data (client specific)4BO_KEYBusiness Object Key (with Conversion Exit)nvarchar320
75/BOFU/FDTEXP100AExpression BO Retrieve: Header Data (Master Data: ClientDep)4BO_KEYBusiness Object Key (with Conversion Exit)nvarchar320
76/BOFU/FDTEXP100SExpression BO Retrieve: Header Data (system)3BO_KEYBusiness Object Key (with Conversion Exit)nvarchar320
77/BOFU/FDTEXP100TExpression BO Retrieve: Header Data (BCF)3BO_KEYBusiness Object Key (with Conversion Exit)nvarchar320
78/BOFU/S_TXC_DSText Schema: Default assignment to BO/Node3BO_KEYNodeIDvarbinary160