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

70 columns | Print definition?ERP 6.0  | ELEMENT_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPC_SUS_BTNDEFDefinition of Displayable Buttons in a View or THTMLB Table5ELEMENT_IDOptional Table Element ID in BSP View for Table Toolbarnvarchar610
2FDT_DDBV_0010BRFplus: Dynamic Database View - Source Field Mapping6ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
3FDT_DDBV_0010ABRFplus: Dynamic Database View - Source Field Mapping6ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
4FDT_DDBV_0010SBRFplus: Dynamic Database View - Source Field Mapping5ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
5FDT_DDBV_0010TBRFplus: Dynamic Database View - Source Field Mapping5ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
6FDT_DDBV_0020BRFplus: Dynamic Database View - Result Field Definition8ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
7FDT_DDBV_0020ABRFplus: Dynamic Database View - Result Field Definition8ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
8FDT_DDBV_0020SBRFplus: Dynamic Database View - Result Field Definition7ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
9FDT_DDBV_0020TBRFplus: Dynamic Database View - Result Field Definition7ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
10IDREPFW_SEDEF_CDynamic Sel.: Selection Parameters, default range values5ELEMENT_IDSelection Parameter IDnvarchar100
11IDREPFW_SEELM_CDynamic Sel.: Selection Parameters5ELEMENT_IDSelection Parameter IDnvarchar100
12IDREPFW_SEELM_TDynamic Sel.: Selection Parameters (Description)6ELEMENT_IDSelection Parameter IDnvarchar100
13IDREPFW_SELPAR_ARep. Framework: Data Storage - Selection Parameters13ELEMENT_IDSelection Parameter IDnvarchar100
14/BOBF/CONF_UI_GGuided Procedures2ELEMENT_IDTree Elementnvarchar30
TOPAppraisal, Valuation, and Survey Tool
15HRHAP_BASICAppraisal Document: Basic Element Data11ELEMENT_IDAppraisal Element IDnvarchar80
16HRHAP_EL_CONFUI Configurations for an Appraisal Element4ELEMENT_IDAppraisal Element IDnvarchar80
17HRHAP_P_DAppraisal Document: Reference Appraisal (Structure)11ELEMENT_IDAppraisal Element IDnvarchar80
18HRHAP_TAB_DATAAppraisal: Layout Configuration Data11ELEMENT_IDAppraisal Element IDnvarchar80
19T77HAP_ASSIGNExternal Objectes Assigned to Template Elements5ELEMENT_IDAppraisal Element IDnvarchar80
TOPBasic Functions
20UDM_SPS_ADMINFSCM-DM Integration: Determination of Element Type4ELEMENT_IDElement Type IDnvarchar320
TOPBRFplus - ABAP-Based Business Rules
21FDT_DOBJ_0100FDT: Data Object Element - Attributes5ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
22FDT_DOBJ_0100AFDT: Data Object Element - Attributes5ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
23FDT_DOBJ_0100SFDT: Data Object Element - Attributes4ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
24FDT_DOBJ_0100TFDT: Data Object Element - Attributes4ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
25FDT_DOBJ_0200FDT: Data Object Structure - Elements5ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
26FDT_DOBJ_0200AFDT: Data Object Structure - Elements5ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
27FDT_DOBJ_0200SFDT: Data Object Structure - Elements4ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
28FDT_DOBJ_0200TFDT: Data Object Structure - Elements4ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
29FDT_EXPR_0241FDT: Expression - Decision Table (Columns)5ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
30FDT_EXPR_0241AFDT: Expression - Decision Table (Columns)5ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
31FDT_EXPR_0241SFDT: Expression - Decision Table (Columns)4ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
32FDT_EXPR_0241TFDT: Expression - Decision Table (Columns)4ELEMENT_IDFDT: Universal Unique Identifiernvarchar320
TOPBusiness Analytics
33UAB_ELMT_CAL_AMTTrigger table to save elements to be costed in qty proc.2ELEMENT_IDInstance IDvarbinary160
34UAB_ELMT_CAL_QTYTrigger table to save elements to be costed in qty proc.2ELEMENT_IDInstance IDvarbinary160
TOPClinical System
35N2KPRO_BLOB_MULTManagem. of Multi-Part Object with Binary Data Store in KPro4ELEMENT_IDElement ID of a Part in Documentnvarchar400
TOPEasy Enhancement Workbench
36AXTD_MIGRATIONRReferences in a migration5ELEMENT_IDGUIDnvarchar320
37AXT_EXT_PART_DTLExtension Part Detail4ELEMENT_IDElement IDnvarchar60
38AXT_REG_BO_DTLGeneration details of extensibility3ELEMENT_IDElement IDnvarchar60
39AXT_REG_BO_FLAGFlag customizing3ELEMENT_IDElement IDnvarchar60
40AXT_REG_BO_GENFurther Generation Objects extensibility3ELEMENT_IDElement IDnvarchar60
41AXT_REG_GRP_ELEMApplication Group Element2ELEMENT_IDElement IDnvarchar60
42AXT_REG_GRP_MP_PMapping parts3ELEMENT_IDElement IDnvarchar60
43AXT_REG_RELATIONBinding objects to AET3ELEMENT_IDElement IDnvarchar60
44AXT_RELATIONRepository relations2ELEMENT_IDElement IDnvarchar60
TOPEnd User Technology
45RSER_ELEM_DATAReport Designer: Reusable Elements (Template/Report Element)1ELEMENT_IDReport Designer: Reusable Element ID for Loading and Savingnvarchar300
46RSER_ELEM_HEADERReport Designer: Header Table BEx Report Elements1ELEMENT_IDReport Designer: Reusable Element ID for Loading and Savingnvarchar300
47RSER_ELEM_TEXTReport Designer: Text Table for Reusable Elements1ELEMENT_IDReport Designer: Reusable Element ID for Loading and Savingnvarchar300
TOPNetWeaver Enterprise Search
48ESH_OM_PC_EXEMPTPlausibility Check: Exemptions8ELEMENT_IDnvarchar500
TOPObjective Setting and Appraisals
49HRHAP_VA_CLL_USESources and Targets for Reuse4ELEMENT_IDAppraisal Templatenvarchar80
TOPProcess Monitoring Infrastructure
50SSPIUICUCESPI: Elements of Step Collection3ELEMENT_IDID of Collection for Processnvarchar320
TOPProcess Orchestration for Built-In Processes
51POC_C_POC_PERSNLPersonalization Settings5ELEMENT_ID30 Charactersnvarchar300
52POC_C_PROCPERSNPersonalization Settings5ELEMENT_ID30 Charactersnvarchar300
53POC_T_POC_PERSNLPersonalization Settings5ELEMENT_ID30 Charactersnvarchar300
TOPSAP Records Management
54RCM_REC_TTBRCM Record: Definition of the Toolbar for Function Profile4ELEMENT_IDRCM Record: Toolbar Element: IDnvarchar400
55RCM_REC_TTBTRCM Record: Definition of Toolbar for Functn Profile (Texts)5ELEMENT_IDRCM Record: Toolbar Element: IDnvarchar400
TOPStatus and Action Management
56SAMDT_ELEMENTSS&AM Elements3ELEMENT_IDS&AM GUIDnvarchar320
TOPTalent Management
57T5TMCSRRESELAES Elements for the Results List of the Search4ELEMENT_IDAppraisal Elements for Results List of the Searchnvarchar80
58T77TMCAESFIELDAES Field Customizing8ELEMENT_IDAppraisal Element IDnvarchar80
59T77TMCELEMPRCAssignments of Elements of Templates to Processes4ELEMENT_IDAppraisal Element IDnvarchar80
TOPTransaction Manager
60IDCFM_FRIM_CELMSData Elements for Selection Parameters - Impairment3ELEMENT_IDSelection Parameter IDnvarchar50
61IDCFM_FRIM_CSELPSelection Parameters - Impairment3ELEMENT_IDSelection Parameter IDnvarchar50
62IDCFM_FRIM_CSELTSelection Parameters - Impairment (Text)4ELEMENT_IDSelection Parameter IDnvarchar50
63IDCFM_FRIM_SELPRSelection Parameters for Impairment Report Run7ELEMENT_IDSelection Parameter IDnvarchar50
TOPUI Configuration Design Layer
64BSPC_DL_FIELDUSEField Property table4ELEMENT_IDGeneric element ID for short text elementsnvarchar700
65BSPC_DL_STXTELEMRepository for custom texts3ELEMENT_IDGeneric element ID for short text elementsnvarchar700
66BSPC_DL_STXTREP2Repository for custom texts4ELEMENT_IDGeneric element ID for short text elementsnvarchar700
67BSP_DDLC_STEXTRPRepository for delivered custom texts3ELEMENT_IDGeneric element ID for short text elementsnvarchar700
68BSP_DLC_STEXTREPRepository for custom texts4ELEMENT_IDGeneric element ID for short text elementsnvarchar700
69BSP_DL_STXTELEMText Repository / Text Elements2ELEMENT_IDGeneric element ID for short text elementsnvarchar700
70BSP_DL_STXTREP2Text Repository3ELEMENT_IDGeneric element ID for short text elementsnvarchar700