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

74 columns | Print definition?ERP 6.0  | ATTR_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTX/SEA_TEMREGRegions used in a search template3ATTR_IDSearch Attribute IDnvarchar200
2BBP_ATTR_ACCESSAttribute Access Mode3ATTR_IDGeneral Attribute Maintenance: Attribute Definitionnvarchar100
3BBP_ATTR_DFTDefault Values of Basic Attributes4ATTR_IDGeneral Attribute Maintenance: Attribute Definitionnvarchar100
4BBP_ATTR_F4CONFSearch Help Configuration for Attributes in Organ. Plan3ATTR_IDGeneral Attribute Maintenance: Attribute Definitionnvarchar100
5BBP_ATTR_PROPScenario-specific attribute properties3ATTR_IDGeneral Attribute Maintenance: Attribute Definitionnvarchar100
6BBP_ATTR_VALUE_TTexts for Attribute Values3ATTR_IDGeneral Attribute Maintenance: Attribute Definitionnvarchar100
7BBP_CT_ATTRDEFAttribute definitions5ATTR_IDAttribute Namenvarchar600
8BBP_CT_ATTRDEF_TAttribute Definitions, Texts7ATTR_IDAttribute Namenvarchar600
9BBP_CT_ATTRPVALPossible Attribute Values10ATTR_IDAttribute Namenvarchar600
10BBP_CT_ATTRPVALTPossible Attribute Values, Texts8ATTR_IDAttribute Namenvarchar600
11BBP_CT_ATTRTOCATLinks Attributes to Categories5ATTR_IDAttribute Namenvarchar600
12BBP_CT_VALRESTRAttribute Value Restrictions10ATTR_IDAttribute Namenvarchar600
13J_3RFREP_ATTRReporting Hierarchy Object Attributes5ATTR_IDReporting Object Attribute IDnvarchar60
14N1SE_INDEX_ATTRISHMED: Search Index Attributes4ATTR_ID3-Byte fieldnvarchar30
TOPBasic Functions
15UDMCASEATTRSYNCFSCM-DM: Relevant Attributes for Synchronization3ATTR_IDAttribute Namenvarchar300
TOPCentral Part of Product Master
16COMC_ATTRIBUTEProduct - Additional Attribute2ATTR_IDAttributenvarchar300
17COMS_ATTR_SETControl Table for the Field Status Depending on Object Type5ATTR_IDLogical Variablenvarchar10
TOPCommunication Services Mail, Fax, SMS, Telephony
18SRIRATGRPBCOM Internal Router: Attribute Group2ATTR_IDRouting: Attribute IDnvarchar320
19SRIRRESPBCOM Internal Router: Scenario Responsibilities4ATTR_IDRouting: Attribute IDnvarchar320
20SRIRSCENATBCOM Internal Router: Scenario Attributes3ATTR_IDRouting: Attribute IDnvarchar320
21SRIRSEARCHBCOM Internal Router: Search Tables (with Addresses)3ATTR_IDRouting: Attribute IDnvarchar320
22SRSATGRPRouting Server: AttribGroup Table2ATTR_IDRouting: Attribute IDnvarchar320
23SRSATGRPTRouting Server: AttribGroup Table Temp2ATTR_IDRouting: Attribute IDnvarchar320
24SRSSRCHTRouting Server: Search Table Table3ATTR_IDRouting: Attribute IDnvarchar320
25SRSSRCHTTRouting Server: Search Table Table Temp3ATTR_IDRouting: Attribute IDnvarchar320
TOPCustomizing Tools Techniques
26TCTM_AT_PRContext Object Type Attribute Prorities2ATTR_IDContext Management Attribute IDnvarchar100
27TCTM_AV_PRContext Management Attribute Valuee Priorities2ATTR_IDContext Management Attribute IDnvarchar100
TOPEnd User Technology
28RSKPI_ATTR_DEFKPI Attribute: Header Data1ATTR_IDName of KPI Attributenvarchar300
29RSKPI_ATTR_DEFTKPI Attribute: Header Data Texts1ATTR_IDName of KPI Attributenvarchar300
30RSKPI_ATTR_USAGEValid Attributes for Each Usage Type of KPI Infrastructure2ATTR_IDName of KPI Attributenvarchar300
31RSKPI_ATTR_VALValues of KPI Attributes1ATTR_IDName of KPI Attributenvarchar300
32RSKPI_ATTR_VALTValues of KPI Attributes1ATTR_IDName of KPI Attributenvarchar300
33RSKPI_KPI_ATTRKPI: Attributes3ATTR_IDName of KPI Attributenvarchar300
34RSKPI_KPI_ATTRTKPI: Language-Dependent Attributes4ATTR_IDName of KPI Attributenvarchar300
35RSRD_ATTRBroadcasting Framework: Producer/Distributor Attributes2ATTR_IDName of an Attribute in a Class in the RD Frameworknvarchar300
36RSRD_ATTRTBroadcasting Framework: Texts for Attributes2ATTR_IDName of an Attribute in a Class in the RD Frameworknvarchar300
37RSRD_ATTR_DEPDependencies Between Attributes2ATTR_IDName of an Attribute in a Class in the RD Frameworknvarchar300
38RSRD_ATTR_VALUEPosible Values for Class Attributes in Broadcasting Framewk2ATTR_IDName of an Attribute in a Class in the RD Frameworknvarchar300
39RSRD_ATTR_VALUETText Table for RSRD_ATTR_VALUE2ATTR_IDName of an Attribute in a Class in the RD Frameworknvarchar300
TOPGraphic
40GFWCUAXGFW Customizing: Axis4ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
41GFWCUAXUGFW Customizing: Axis (Customer Data)5ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
42GFWCUDAGFW Customizing: Plot Area4ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
43GFWCUDAUGFW Customizing: Plot Area (Customer Data)5ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
44GFWCUDCGFW Customizing: Display Context4ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
45GFWCUDCUGFW Customizing: Display Context (Customer Data)5ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
46GFWCUDIGFW Customizing: Chart4ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
47GFWCUDIUGFW Customizing: Chart (Customer Data)5ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
48GFWCUDSGFW Customizing: Data sheet4ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
49GFWCUDSUGFW Customizing: Data Table (Customer Data)5ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
50GFWCUGRGFW Customizing: Grid4ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
51GFWCUGRUGFW Customizing: Grid (Customer Data)5ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
52GFWCUITGFW Customizing: Item4ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
53GFWCUITUGFW Customizing: Item (Customer Data)5ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
54GFWCUPOGFW Customizing: Point4ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
55GFWCUPOUGFW Customizing: Point (Customer Data)5ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
56GFWCUSCGFW Customizing: Scale4ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
57GFWCUSCUGFW Customizing: Scale (Customer Data)5ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
58GFWCUVAGFW Customizing: Value Series4ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
59GFWCUVAUGFW Customizing: Value Series (Customer Data)5ATTR_IDGFW: Attribute ID in attribute bundlenvarchar400
TOPImplementation Guide
60CUS_ATRCOUCountry Assignment for Activities1ATTR_IDCustomizing Attributesnvarchar200
61CUS_ATRHCustomizing Attributes - Header Data1ATTR_IDCustomizing Attributesnvarchar200
62CUS_ATRTText Table for Customizing Attributes2ATTR_IDCustomizing Attributesnvarchar200
63CUS_ATRVCOCustomizing Attributes: Variants for ACH Assignment1ATTR_IDCustomizing Attributesnvarchar200
64CUS_ATRVSEAttribute Variant Sequence1ATTR_IDCustomizing Attributesnvarchar200
TOPNon Profit Organizations
65T7UNPAD_ATTREVE: Attribute Properties3ATTR_IDAttribute IDnvarchar100
66T7UNPAD_ATTR_TEVE: Attribute Texts4ATTR_IDAttribute IDnvarchar100
67T7UNPAD_ENTLATTREVE: Assignment of Attributes to Entitlements4ATTR_IDAttribute IDnvarchar100
68T7UNPAD_RANGESEVE: Range for decision validation5ATTR_IDAttribute IDnvarchar100
TOPQuery Management
69/PLMPCV/D_QATTRQuery attribute3ATTR_IDQuery Attribute IDnvarchar300
70/PLMPCV/D_QATTRTQuery attribute description3ATTR_IDQuery Attribute IDnvarchar300
71/PLMPCV/D_QFPARQuery formula parameter10ATTR_IDID of Query Result Attributenvarchar300
72/PLMPCV/D_QRESAQuery result attribute3ATTR_IDID of Query Result Attributenvarchar300
73/PLMPCV/D_QSELCQuery selection criterion10ATTR_IDQuery Attribute IDnvarchar300
TOPRemaining Beverage - Obsolete Objects
74/BEV3/CHPRUEF_Z4Control Table for Time 4 - Check10ATTR_IDAttribute Identifiernvarchar300