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

71 columns | Print definition?ERP 6.0  | VIEW_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_CUST_VSAIF customizing views (for authorization check)2VIEW_NAMECustomizing Viewnvarchar300
2/AIF/T_CUST_VSTAIF customizing views (for authorization check) text3VIEW_NAMECustomizing Viewnvarchar300
3/AIF/T_VMAPValue mapping24VIEW_NAMEView/Table Namenvarchar300
4/SAPSRM/C_TS_EXTTab Strip Extensions for the Web Dynpro SRM UI2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
5/SAPSRM/C_TS_VISTab - set type association to control tab visibility2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
6/SAPSRM/C_WD_TESettings for Standard Display of Table Extensions on UI5VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
7/SAPSRM/C_WD_TECSettings for Columm Visibility of Table Extensions on UI8VIEW_NAMEText, 40 Characters Longnvarchar400
8BBPC_SUS_ACTIONActions on SUS UI6VIEW_NAMEController of the Actionnvarchar1000
9BSCL_CLASS_VIEWAdministration of generated Class Views8VIEW_NAMEView Namentext10737418230
10FIN_AR_VIEW_FLDHDB View field names (prevent renaming when adding tables)1VIEW_NAMEName of ABAP Dictionary Objectnvarchar300
11FIN_AR_VIEW_REDUFI table fields to be suppressed in FI-AR HDB views1VIEW_NAMEName of ABAP Dictionary Objectnvarchar300
12IWP_HDB_MODELSVDM's for HANA Model Replication2VIEW_NAMECharacter field of length 40nvarchar400
13IWP_HDB_QUERY_VContains mapping of Reporting package to Query Views3VIEW_NAMEHANA table name/View name for ILM usagenvarchar800
14RSOGUICONTEXTWeb Dynpro Context Data Exchange6VIEW_NAMEnvarchar200
15SRAL_FIELDS_WDRAL: Channel specific fields10VIEW_NAMERAL: Name of a Web Dynpro Viewntext10737418230
16TFK_VT_C2TCounter Groups for Display (Text Table)4VIEW_NAMEName of Counter Group for Displaynvarchar500
TOPAccounting Engine
17/EACC/V_TOTALS_JJournal Totals6VIEW_NAMEHome Class of an Accounting Componentnvarchar300
TOPArchiving
18RZPT_ACTIONSArchiving: RZPT - permitted actions1VIEW_NAMEName of SAP table viewnvarchar300
19RZPT_RZArchiving: RZPT - Views for Maintenance of Residence Time1VIEW_NAMEName of SAP table viewnvarchar300
20RZPT_RZTArchiving: RZPT - Text for Maintenance View2VIEW_NAMEName of SAP table viewnvarchar300
TOPCentral Part of Product Master
21COMC_CRD_GEN_BWOCRM CRD: Generated Objects for Attribute-DataSources3VIEW_NAMEName of SAP table viewnvarchar300
TOPDealer Portal
22/SAPDII/CCOM_SETComponent View Settings5VIEW_NAMEView Namenvarchar400
TOPEasy Enhancement Workbench
23AXT_CAT_DICT_KEYCatalogue object dictionnary entry key10VIEW_NAMEName of SAP table viewnvarchar300
24AXT_REG_BO_UIExtensible UI elements5VIEW_NAMEBSP Viewnvarchar700
25AXT_REG_MODELModel of the extensibility registry1VIEW_NAMETable or view namenvarchar300
26AXT_REG_SPLACEUIExtensible UI elements5VIEW_NAMEBSP Viewnvarchar700
27AXT_VIEW_TITLESDefault titles for views1VIEW_NAMEBSP Viewnvarchar700
TOPFast Search Infrastructure
28SFSG_QR_DEFRepository Table for Query Definition6VIEW_NAMESearch Definition Name of Generic Fast Searchnvarchar250
29SFSRFW_JDX_JVReplication Framework - Join View Attributes8VIEW_NAMEnvarchar100
30SFSRFW_REQ_HReplication Framework - Requester3VIEW_NAMEReplication Framework - Join Index Viewnvarchar100
TOPGeneric Interaction Layer
31CRMC_GIL_APPVIEWAssignment: View <-> Component Set2VIEW_NAMEName of Read Viewnvarchar300
32CRMC_VIEWREGView Definitions for Generic Interaction Layer2VIEW_NAMEName of Read Viewnvarchar300
TOPI18N BiDi
33LST_WDA_DDIC_REPLST repository for DDIC texts2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
34LST_WDA_OTR_REPLST repository for OTR texts2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
TOPImplementation Guide
35TCUSRAssignment of view to project1VIEW_NAMEStructures: Name of Viewnvarchar120
36TCUSR40Assignment of view to project1VIEW_NAMEUnique ID - 32 charactersnvarchar320
TOPIntegration of FPM and Persistency Frameworks like BOPF
37/BOFU/IFBIVUView Usage: Header2VIEW_NAMEFBI Viewnvarchar500
38/BOFU/LFBIV_MAPView: DDic Type mapping1VIEW_NAMEFBI Viewnvarchar500
TOPInteraction Center WebClient
39CRMC_IC_NBEVIEWSTarget Views and View Sets3VIEW_NAMENavigation Bar Entry to View/View Set Mappingnvarchar700
TOPProcess Orchestration for Built-In Processes
40POC_C_POC_PERSNLPersonalization Settings4VIEW_NAMEChar 20nvarchar200
41POC_C_PROCPERSNPersonalization Settings4VIEW_NAMEChar 20nvarchar200
42POC_T_POC_PERSNLPersonalization Settings4VIEW_NAMEChar 20nvarchar200
TOPPublic Sector Contract Accounts Receivable and Payable
43TFMCA_ACT_ITEMAmendment Action Items6VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
TOPReport Selection for Product Costing
44FCOM_HDBHDB Customzing for Analytic Views3VIEW_NAMEAnalytic Viewntext10737418230
45FCOM_HDB_CHDB Customzing for Customers Analytic Views3VIEW_NAMEAnalytic Viewntext10737418230
TOPSearch
46CSEARCHC_OBJObjects supported by Central Search6VIEW_NAMEName of BSP Page (Upper and Lower Case)nvarchar700
TOPTag Library
47WCFC_AVF_EXCExceptions for Asynch Value Fetch feature3VIEW_NAMEInternal Name (Key) of BSP Pagenvarchar700
TOPUI Configuration Design Layer
48BSPC_DL_VIEWSConfiguration: General View Settings3VIEW_NAMEView Namenvarchar700
TOPUI Runtime Environment
49BSPWD_ADH_DSBLDelta Handling disablement config for individual views2VIEW_NAMEInternal Name (Key) of BSP Pagenvarchar700
50BSPWD_ADH_DSBLCCustomising DH disablement config for individual views2VIEW_NAMEInternal Name (Key) of BSP Pagenvarchar700
51CRMS_DEF_MSGHANDDefault message handler assignment5VIEW_NAMEFixed length and case sensitive view namenvarchar2550
TOPWeb Screen Tools - ABAP
52WDY_CTX_CHANGEDWeb Dynpro: Table to Make Context Changes Persistent2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
53WDY_IOBOUND_PLGTWeb Dynpro : Short Description of Inbound/Outbound Plugs2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
54WDY_IOBOUND_PLUGWeb Dynpro: Inbound/Outbound Plugs of Views2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
55WDY_PLUG_PARAMWeb Dynpro : Plug Parameter2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
56WDY_PLUG_PARAMTWeb Dynpro : Short Texts of the Plug Parameters2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
57WDY_UI_CTX_BINDWeb Dynpro: Context Binding of UI Elements2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
58WDY_UI_DDIC_BINDWeb Dynpro : Dictionary Binding of View Elements2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
59WDY_UI_ELEMENTWeb Dynpro: UI Element2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
60WDY_UI_EVT_BINDWeb Dynpro: Event Binding of UI Elements2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
61WDY_UI_PROPERTYWeb Dynpro: UI Element2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
62WDY_VIEWWeb Dynpro: View2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
63WDY_VIEWTWeb Dynpro : Short Description of a View2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
64WDY_VIEW_CNTRWeb Dynpro: View Container2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
65WDY_VIEW_CNTRTWeb Dynpro : Short Descriptions of View Containers2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
66WDY_VIEW_TEXTWeb Dynpro : Text Repository for Views2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
67WDY_WB_GENINF_VSWebDynpro: Generation Information for Viewsets4VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Metadata Objectnvarchar300
68WDY_WB_VD_CDWeb Dynpro: Chart Designer Customizing2VIEW_NAMEWeb Dynpro: Name of a Web Dynpro Viewnvarchar300
TOPWeb Service and SOAP - ABAP
69SRT_SR_VW_ASSIGNUser-View Assignment Table2VIEW_NAMEName of Service Registry Viewnvarchar300
70SRT_SR_VW_DETAILView detail for Service Registry2VIEW_NAMEName of Service Registry Viewnvarchar300
71SRT_SR_VW_HEADERHeader table for views2VIEW_NAMEName of Service Registry Viewnvarchar300