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

56 columns | Print definition?ERP 6.0  | ATTRIBUTE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SYCLO/WB002ADevTool: Object attributes2ATTRIBUTE_IDDevTool: Attribute Idnvarchar320
2/SYCLO/WB006ADevTool: Client transaction attributes2ATTRIBUTE_IDDevTool: Attribute Idnvarchar320
3BBP_CT_ATTSchema Attributes5ATTRIBUTE_IDAttribute Namenvarchar600
4GHO_PS_ATTRLST_TAttribute List Texts2ATTRIBUTE_IDAttribute IDnvarchar100
5GHO_PS_ATTR_LISTList of Attributes for Primary Selector2ATTRIBUTE_IDAttribute IDnvarchar100
6GHO_PS_OBJ_ATTRAttributes for a Group Selector Pair3ATTRIBUTE_IDAttribute IDnvarchar100
7LTR_BO_ATTRLTR: Business Object Attributes2ATTRIBUTE_IDLTR: Business Object Attribute IDnvarchar320
TOPApplication Frame
8WCTXTD_ADJUSTAdjustments to Working Context Attributes4ATTRIBUTE_IDWorking Context Attribute IDnvarchar320
9WCTXTD_ADJUST_TAdjustments to Working Context Attributes - Text Table4ATTRIBUTE_IDWorking Context Attribute IDnvarchar320
TOPBusiness Context Viewer
10/BCV/C_DISPLAVDisplay Values7ATTRIBUTE_IDID of Query Result Fieldnvarchar300
11/BCV/C_EXPAROutput Parameter3ATTRIBUTE_IDField IDnvarchar300
12/BCV/C_EXPARTOutput Parameter Description4ATTRIBUTE_IDField IDnvarchar300
13/BCV/C_INPARInput Parameter3ATTRIBUTE_IDField IDnvarchar300
14/BCV/C_INPARTInput Parameter Description4ATTRIBUTE_IDField IDnvarchar300
15/BCV/C_QATTRQuery Field3ATTRIBUTE_IDQuery Field IDnvarchar300
16/BCV/C_QATTRTQuery Field Description3ATTRIBUTE_IDQuery Field IDnvarchar300
17/BCV/C_QFPARQuery formula parameter10ATTRIBUTE_IDID of Query Result Fieldnvarchar300
18/BCV/C_QRESAQuery Result Field3ATTRIBUTE_IDID of Query Result Fieldnvarchar300
19/BCV/C_QSELCQuery selection criterion10ATTRIBUTE_IDQuery Field IDnvarchar300
20/BCV/C_STRUCQuery View Structure Defintion5ATTRIBUTE_IDQuery Field IDnvarchar300
TOPCentral Part of Product Master
21COMC_SETTYP_ATTRAdministrative Table for Set Type Attribute Information5ATTRIBUTE_IDAttributenvarchar300
22COMM_PRFREEATTRFree Attributes for a Product3ATTRIBUTE_IDFree Attribute IDnvarchar1000
23COMM_PRFREEATTRHFree Attributes for a Product - History3ATTRIBUTE_IDFree Attribute IDnvarchar1000
24COMS_SETTYPE_WZStatus of the Input Fields and Tables in the Set Type Wizard12ATTRIBUTE_IDStatus of the Input Fields in the Set Type Wizardnvarchar40
TOPDialog People-Centric UI for Products
25COMC_SET_BSP_CNTEvent Controlling for Set Types in BSP5ATTRIBUTE_IDAttributenvarchar300
TOPError and Conflict Handler
26ECHC_PLA_ATTRIBDefinition of Attributes for Payload Analysis2ATTRIBUTE_IDAttribute IDnvarchar300
27ECHC_PLA_ATTRIBTDefinition of Attributes for Payload Analysis3ATTRIBUTE_IDAttribute IDnvarchar300
28ECHC_PLA_EXTRACTExtraction Paths of Attributes for Payload Analysis5ATTRIBUTE_IDAttribute IDnvarchar300
29ECH_PLA_VALUESExtracted Values of Attributes for Payload Analysis3ATTRIBUTE_IDAttribute IDnvarchar300
TOPMaterial Master
30WGDS_ATTRIBUTESGDS storage: Attributes assignement2ATTRIBUTE_IDAttribute unique idnvarchar320
TOPPortfolio Management
31/RPM/QNNRQuestionnaire Header3ATTRIBUTE_IDField Namenvarchar300
32/RPM/QNNR_RESULTQuestionnaire Result3ATTRIBUTE_IDField Namenvarchar300
TOPSearch Integration
33/PLMPCV/C_EXPAROutput Parameter3ATTRIBUTE_IDAttribute IDnvarchar300
34/PLMPCV/C_EXPARTOutput Parameter Description4ATTRIBUTE_IDAttribute IDnvarchar300
35/PLMPCV/C_INPARInput Parameter3ATTRIBUTE_IDAttribute IDnvarchar300
36/PLMPCV/C_INPARTInput Parameter Description4ATTRIBUTE_IDAttribute IDnvarchar300
TOPTag Library
37WCF_CDS_TESTDATATest Data Entries for Central Data Source Test Application4ATTRIBUTE_IDnvarchar300
TOPUser Interface
38/PLMPCV/D_STRUCQuery Variant Structure Defintion4ATTRIBUTE_IDQuery Attribute IDnvarchar300
TOPWebClient UI
39WCFC_CDS_BOLTAGCentral Data Source BOL Tag Attribute3ATTRIBUTE_IDAttribute IDnvarchar300
40WCFC_CDS_BOLTAGTCentral Data Source Constant Attributes texts table3ATTRIBUTE_IDAttribute IDnvarchar300
41WCFC_CDS_CONSTCentral Data Source Constant Attributes3ATTRIBUTE_IDAttribute IDnvarchar300
42WCFC_CDS_CONST_TCentral Data Source Constant Attributes texts table3ATTRIBUTE_IDAttribute IDnvarchar300
43WCFC_CDS_FUNCTCentral Data Source Custom Functions3ATTRIBUTE_IDAttribute IDnvarchar300
44WCFC_CDS_FUNCT_TCentral Data Source Custom Functions texts3ATTRIBUTE_IDAttribute IDnvarchar300
45WCFC_CDS_USERVCentral Data Source User Variable Attribute3ATTRIBUTE_IDAttribute IDnvarchar300
46WCFC_CDS_USERV_TCentral Data Source Constant Attributes texts table3ATTRIBUTE_IDAttribute IDnvarchar300
47WCF_CDS_BOLTAGCentral Data Source BOL Tag Attribute2ATTRIBUTE_IDAttribute IDnvarchar300
48WCF_CDS_BOLTAG_TCentral Data Source Constant Attributes texts table2ATTRIBUTE_IDAttribute IDnvarchar300
49WCF_CDS_CONSTCentral Data Source Constant Attributes2ATTRIBUTE_IDAttribute IDnvarchar300
50WCF_CDS_CONST_TCentral Data Source Constant Attributes texts table2ATTRIBUTE_IDAttribute IDnvarchar300
51WCF_CDS_FUNCTCentral Data Source Custom Functions2ATTRIBUTE_IDAttribute IDnvarchar300
52WCF_CDS_FUNCT_TCentral Data Source Custom Functions texts2ATTRIBUTE_IDAttribute IDnvarchar300
53WCF_CDS_USERVCentral Data Source User Variable Attribute2ATTRIBUTE_IDAttribute IDnvarchar300
54WCF_CDS_USERV_TCentral Data Source Constant Attributes texts table2ATTRIBUTE_IDAttribute IDnvarchar300
55WCF_MLC_OBJ_FLDSFields for UI Object types3ATTRIBUTE_IDAttribute IDnvarchar300
56WCF_ML_OBJ_FLDSFields for UI Object types2ATTRIBUTE_IDAttribute IDnvarchar300