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

146 columns | Print definition?ERP 6.0  | CONFIG_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/PWSC_UIBBTable to maintain UIBB4CONFIG_IDConfiguration Identificationnvarchar320
2/FLDQ/AD_HNAPROC`4CONFIG_IDHana Configurationtinyint30
3/SAPSRM/C_VIEW_UTable to switch UIBB5CONFIG_IDConfiguration Identificationnvarchar320
4/UI2/CACHE_CONFUI2: Cache for Configuration data5CONFIG_IDConfiguration Identificationnvarchar320
5CRR_TFW_CONF_RDCRR, Test Framework, Log2CONFIG_IDTest Configuration Identificationnvarchar200
6CTS_SAVED_SEARCHCTS Table for Saved Searches3CONFIG_IDConfiguration Identificationnvarchar320
7CTS_SEARCH_APPLCTS Table for Saved Searches3CONFIG_IDConfiguration Identificationnvarchar320
8GRFNNAVENTITYNavigation Targets for Entities4CONFIG_IDConfiguration Identificationnvarchar320
9GRFNNAVTASKNavigation Targets for Tasks3CONFIG_IDConfiguration Identificationnvarchar320
10HRHAPCN_FPROPSField Properties2CONFIG_IDConfiguration Identificationnvarchar320
11J_1I_EXIM_DOCSETEXIM : Document Set7CONFIG_IDConfiguration IDnvarchar320
12MDGM_SEARCHFPM Table for saved searches3CONFIG_IDConfiguration Identificationnvarchar320
13MDGM_SEARCH_APPLFPM Table for saved searches3CONFIG_IDConfiguration Identificationnvarchar320
14SECM_CONFIGSECM: Configuration1CONFIG_IDSECM: Configuration IDnvarchar320
15SECM_LOG_CACHESECM: Log Cache Directory2CONFIG_IDSECM: Configuration IDnvarchar320
16SRAL_BCTX_FIELDSRAL: Fields of Business Context2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
17SRAL_BUS_CTXTSRAL: Business Contexts2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
18SRAL_CFG_LNKRead Access Logging: Used configuration in log entry3CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
19SRAL_COND_FIELDSRAL: Condition for field2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
20SRAL_COND_TRead Access Logging: Condition Description2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
21SRAL_CONFIGRead Access Logging: configuration entries for all channels2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
22SRAL_CONFIG_DYNPRAL: Configuration for Dynpro2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
23SRAL_CONFIG_PROPRAL: Read Access Logging Configuration Properties2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
24SRAL_CONFIG_RFCRAL: Configuration for Remote Function Calls2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
25SRAL_CONFIG_RTRead Access Logging: Configurations4CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
26SRAL_CONFIG_TRAL: Text table for SRAL_CONFIG (Configurations)2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
27SRAL_CONFIG_WDRAL: Configuration for Web Dynpro ABAP2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
28SRAL_CONFIG_WSRAL: Configuration for Web Services2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
29SRAL_EXP_LOGRAL expanded log - header table19CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
30SRAL_FIELDSRAL: Generic channel fields2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
31SRAL_FIELDS_DYNPRAL: Channel specific fields2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
32SRAL_FIELDS_RFCRAL: Channel specific fields2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
33SRAL_FIELDS_SYRAL: System Field2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
34SRAL_FIELDS_WDRAL: Channel specific fields2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
35SRAL_FIELDS_WSRAL: Channel specific fields2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
36SRAL_KERNEL_RFCRAL: function modules to be logged (checked from kernel)4CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
37SRAL_LG_CONDRAL: Assign Log groups / Fields to Conditions2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
38SRAL_LOGRead Access Logging: Log17CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
39SRAL_LOG_FIELDSRAL: Log group fields2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
40SRAL_LOG_GROUPSRAL: Log Group2CONFIG_IDRead Access Logging: Log Configuration IDnvarchar320
41T5ASRFSCNBOLCFGConfigurations5CONFIG_IDConfiguration IDnvarchar320
42T5ASRFSCNBOLCONFObsolete: Configurations(donot use)4CONFIG_IDConfiguration IDnvarchar320
43T5ASRFSCNFPMCFGTText table for form scenario FPM configuration description4CONFIG_IDConfiguration Identificationnvarchar320
44T5ASRFSCNFPMCONFFPM Configurations Data for Form Scenario4CONFIG_IDConfiguration Identificationnvarchar320
45T5ASRFSCNMSTCONFMass Processing Configurations Data for Form Scenario4CONFIG_IDConfiguration Identificationnvarchar320
46T7UNESS_INITUIBBNPO: EG Initial screen uibb data2CONFIG_IDConfiguration Identificationnvarchar320
47WDR_USAGE_LOGWeb Dynpro: Recording of Usage Log Data4CONFIG_IDConfiguration Identificationnvarchar320
48WDY_CFG_CHANGESTemporary Changes to a Configuration1CONFIG_IDConfiguration Identificationnvarchar320
49WDY_CFG_CUSTCHGTemporary Changes to a Configuration Customizing2CONFIG_IDConfiguration Identificationnvarchar320
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
50SATC_AC_CHKCFGTransaction data: Check configuration IDs2CONFIG_IDCheck configuration IDnvarchar300
51SATC_AC_R3TR_BTransaction data: 'R3TR Set' basic & attribute6CONFIG_IDCheck configuration IDnvarchar300
TOPAccounting Engine
52/EACC/CONFIGS_LIConfigurations2CONFIG_IDConfiguration IDnvarchar220
53/EACC/CONFIGS_PLConfigurations for Line Item Persistence2CONFIG_IDConfiguration IDnvarchar220
54/EACC/MPTAB0CTitle Element for the Entry Sheet Header2CONFIG_IDSubstitute for 22 character GUIDnvarchar220
55/EACC/MPTAB0TTitle Element for the Entry Sheet Header3CONFIG_IDSubstitute for 22 character GUIDnvarchar220
56/EACC/PLIMA_CONFConfigurations2CONFIG_IDConfiguration IDnvarchar220
57/EACC/PLIMA_INDIndexes2CONFIG_IDUUID in compressed form (22 character UUENCODEd)nvarchar220
58/EACC/PLIMA_INDXIndexes2CONFIG_IDConfiguration IDnvarchar220
59/EACC/PL_INDXNAMIndex Names2CONFIG_IDUUID in compressed form (22 character UUENCODEd)nvarchar220
60/EACC/TMPDYNCOLSLayout of the Entry Sheet Header Screen2CONFIG_IDSubstitute for 22 character GUIDnvarchar220
61/EACC/TMPDYNFLDFFixed Fields in the Entry Items2CONFIG_IDSubstitute for 22 character GUIDnvarchar220
62/EACC/TMPDYNFLDSPosition of the Screen Fields2CONFIG_IDSubstitute for 22 character GUIDnvarchar220
63/EACC/TMPDYNHDROFields with Required Entry in the Document Header2CONFIG_IDSubstitute for 22 character GUIDnvarchar220
64/EACC/TMPDYNPROSSubscreens for the Header of an Entry Transaction2CONFIG_IDSubstitute for 22 character GUIDnvarchar220
65/EACC/TMPSTRUSStructure for Entry Sheet Header, Lines and Transfer2CONFIG_IDSubstitute for 22 character GUIDnvarchar220
TOPBusiness Analytics
66UAREP_CONFIG1Configuration for UA Reports4CONFIG_IDUUID in compressed form (22 character UUENCODEd)nvarchar220
TOPBusiness Context Viewer
67/BCV/C_DASHBADashboard - PageBuilder Assignments4CONFIG_IDConfiguration Identificationnvarchar320
68/BCV/C_PRVIEWOverview Definitions4CONFIG_IDConfiguration Identificationnvarchar320
69/BCV/D_SSHOTSnapshot6CONFIG_IDConfiguration Identificationnvarchar320
TOPClinical System
70TN1PRECCONFUSERAi.s.h.med: Patient Record, User-Configuration Assignment3CONFIG_IDConfiguration Identificationnvarchar320
71TN2CLIO_USAGEClinical Overview: Usage5CONFIG_IDClinical Overview: Key of Web Dynpro Configurationnvarchar320
TOPCross-Application Components
72/IXOS/RM_TCOLDCustomizing settings for batch import in the RM1CONFIG_IDConfiguration ID (R3_RM_Config_ID)nvarchar100
73/IXOS/RM_TPROTLog table7CONFIG_IDConfiguration ID (R3_RM_Config_ID)nvarchar100
74/IXOS/RM_TUEXITUser exits of Config_id for Batch import2CONFIG_IDConfiguration ID (R3_RM_Config_ID)nvarchar100
TOPECM Core Infrastructure
75NWECMC_APPCONSAP settings Application Configuration2CONFIG_IDMapping IDnvarchar220
76NWECM_APPCON_DEFSAP settings Application Configuration1CONFIG_IDMapping IDnvarchar220
TOPFinancials Basis
77FINB_DMT_CHARData Retention: Characteristics2CONFIG_IDConfiguration IDnvarchar220
78FINB_DMT_CONFIGData Retention, Configuration Object of Totals Persistence2CONFIG_IDConfiguration IDnvarchar220
79FINB_DMT_KEYFData Retention: Key Figures2CONFIG_IDConfiguration IDnvarchar220
80FINB_DMT_NRANGEData Retention: Number Range Intervals3CONFIG_IDConfiguration IDnvarchar220
81FINB_DMT_TINDEXData Retention: Indexes2CONFIG_IDConfiguration IDnvarchar220
TOPFloorplan Manager Web Dynpro ABAP
82FPM_SAVED_SEARCHFPM Table for saved searches4CONFIG_IDConfiguration Identificationnvarchar320
83FPM_SSEARCH_APPLFPM Table for saved searches4CONFIG_IDConfiguration Identificationnvarchar320
TOPGeneral Ledger
84/EACA/TGLBALREPConfiguration for G/L Balance Reporting3CONFIG_IDUUID in compressed form (22 character UUENCODEd)nvarchar220
85/EACA/TGLDYNTAB1Title Element for the Header of a Document3CONFIG_IDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
86/EACA/TGLMPCONASConfiguration of Manual Posting Transaction for Acc. System3CONFIG_IDSubstitute for 22 character GUIDnvarchar220
87/EACA/TGLMPCONDBConfiguration of Manual Posting Transaction for Data Basis3CONFIG_IDSubstitute for 22 character GUIDnvarchar220
TOPGeographical Information System
88GHO_GISCMCONFIDCustomizing Table for Context Menu Configurations3CONFIG_IDContext Menu Configuration IDnvarchar20
89GHO_GISCMOBJTYPECustomizing Table for Configuration Object Types3CONFIG_IDContext Menu Configuration IDnvarchar20
TOPLean Staffing
90TSAWE_TRANSFORMStaff Assignment Definition for Transformation2CONFIG_IDConfiguration Identificationnvarchar320
TOPOLAP Technology
91RSDRI_DF_CONFIGData Federator: Configuration1CONFIG_IDObjectnvarchar300
TOPRecipe Development
92/PLMI/LBL_UIBBOBSOLETE. DON’T USE!4CONFIG_IDConfiguration Identificationnvarchar320
TOPSAP Business Workflow
93SWFDLCONFIGWorkflow: Deadline configuration2CONFIG_IDTask Setnvarchar240
94SWFDLCONFIG2TASKWorkflow: Configured tasks for special deadline handling2CONFIG_IDTask Setnvarchar240
95SWFDLJOBWorkflow: Active jobs for special deadline handling3CONFIG_IDTask Setnvarchar240
TOPService Implementation Workbench
96TSIW_CONFIGSIW Configurations1CONFIG_IDConfiguration IDnvarchar200
97TSIW_CONFIGTConfiguration Texts2CONFIG_IDConfiguration IDnvarchar200
98TSIW_PROJRoot Table for project6CONFIG_IDConfiguration IDnvarchar200
TOPServices
99FINB_RP_CONFIG1Customizing by Report2CONFIG_IDUUID in compressed form (22 character UUENCODEd)nvarchar220
100FINB_RP_CONFIG2Customizing for Fields in Reporting2CONFIG_IDUUID in compressed form (22 character UUENCODEd)nvarchar220
TOPSyntax, Compiler, Runtime
101TPDA_TABLE_CONFCSpalten3CONFIG_IDID einer Tabellenkonfigurationnvarchar1500
102TPDA_TABLE_CONFHSpaltenkonfigurationen für User und Session3CONFIG_IDID einer Tabellenkonfigurationnvarchar1500
TOPTalent Management
103T5TMCSRC_SAVEDTMC CSI: Table for Saved Combined Searches4CONFIG_IDConfiguration Identificationnvarchar320
104T77TMCDRCNFConfigurations for Data Retrieval3CONFIG_IDConfiguration IDnvarchar320
105T77TMCDRCNFFLDFields of Configurations3CONFIG_IDConfiguration IDnvarchar320
106T77TMCDRCNFFLDTFields of Configurations4CONFIG_IDConfiguration IDnvarchar320
107T77TMCDRCNFTConfigurations for Data Retrieval4CONFIG_IDConfiguration IDnvarchar320
108T77TMCDRFLTCNFFilter Configurations2CONFIG_IDConfiguration IDnvarchar320
109T77TMCDRFLTCNFTFilter Configuration3CONFIG_IDConfiguration IDnvarchar320
110T77TMCDRFLTFLDFields of Configurations2CONFIG_IDConfiguration IDnvarchar320
111T77TMCDRFLTFLDTFields of Filter Configurations3CONFIG_IDConfiguration IDnvarchar320
TOPUpgrade Tools
112CRR_TFW_CONF_DTCRR, Test Framework, Log2CONFIG_IDTest Configuration Identificationnvarchar200
113CRR_TFW_CONF_DTNCRR, Test Framework, Log2CONFIG_IDTest Configuration Identificationnvarchar200
114CRR_TFW_CONF_IDCRR, Test Framework, Log2CONFIG_IDTest Configuration Identificationnvarchar200
115CRR_TFW_CONF_STCRR, Test Framework, Log2CONFIG_IDTest Configuration Identificationnvarchar200
TOPWD ABAP Page Builder
116CHIP_CACHE_PAGEConfiguration Data for Web Dynpro Components1CONFIG_IDConfiguration Identificationnvarchar320
117CHIP_CACHE_PAGEHCHIP Cache: Page Header1CONFIG_IDConfiguration Identificationnvarchar320
118CHIP_CACHE_PAGEMWeb Dynpro: Configuration Data for User4CONFIG_IDConfiguration Identificationnvarchar320
119CHIP_CACHE_PAGMHCHIP Cache: Page Header4CONFIG_IDConfiguration Identificationnvarchar320
120CHIP_NAMESPACETest Namespace2CONFIG_IDConfiguration Identificationnvarchar320
121CHIP_PFCG_MAPAssignment of Page to PFCG Menu Entry4CONFIG_IDConfiguration Identificationnvarchar320
TOPWeb Channel Builder
122COM_WCB_CFG_WFWCB Configuration Approval Status Details7CONFIG_IDWCB Configuration IDnvarchar500
TOPWeb Dynpro ABAP
123WDY_CFG_CMP_WULWhere-Used List for Component Configurations1CONFIG_IDConfiguration Identificationnvarchar320
124WDY_CFG_EMPTYWDA Configuration: List of Non-Existing Component Configs2CONFIG_IDConfiguration Identificationnvarchar320
125WDY_CONFIG_APPLConfiguration Data for Web Dynpro Components1CONFIG_IDConfiguration Identificationnvarchar320
126WDY_CONFIG_APPTDescription Texts for WDY_CONFIG_APPL1CONFIG_IDConfiguration Identificationnvarchar320
127WDY_CONFIG_COMPTDescription Texts for WDY_CONFIG_APPL1CONFIG_IDConfiguration Identificationnvarchar320
128WDY_CONFIG_DATAConfiguration Data for Web Dynpro Components1CONFIG_IDConfiguration Identificationnvarchar320
129WDY_CONFIG_DATTDescription Texts for WDY_CONFIG_DATA1CONFIG_IDConfiguration Identificationnvarchar320
130WDY_CONF_APPLUCustomizing Data for Web Dynpro Applications4CONFIG_IDConfiguration Identificationnvarchar320
131WDY_CONF_APPLUTCustomizing Data for Web Dynpro Applications4CONFIG_IDConfiguration Identificationnvarchar320
132WDY_CONF_DELAConfiguration Delegation1CONFIG_IDConfiguration Identificationnvarchar320
133WDY_CONF_DELCConfiguration Delegation1CONFIG_IDConfiguration Identificationnvarchar320
134WDY_CONF_UDEFWeb Dynpro: Configuration Data for User4CONFIG_IDConfiguration Identificationnvarchar320
135WDY_CONF_USERWeb Dynpro: Configuration Data for User4CONFIG_IDConfiguration Identificationnvarchar320
136WDY_CONF_USERTWeb Dynpro: Configuration Data for User4CONFIG_IDConfiguration Identificationnvarchar320
137WDY_CONF_USERT2Web Dynpro: Configuration Data for User4CONFIG_IDConfiguration Identificationnvarchar320
TOPWeb Dynpro ALV for ABAP
138SALV_WD_BL_APPLRelated BLOBs to SAP Configuration Data1CONFIG_IDConfiguration Identificationnvarchar320
139SALV_WD_BL_USERRelated BLOBs to Customer Configuration Data4CONFIG_IDConfiguration Identificationnvarchar320
TOPWeb Screen Tools - ABAP
140WDY_CHIP_DEFCHIP Definition3CONFIG_IDConfiguration Identificationnvarchar320
TOPWeb Service and SOAP - ABAP
141SRT_TRANSPTemporary transport data for WS configuration objects4CONFIG_IDntext10737418230
142SRT_TRANSP_ATemporary transport data for WS configuration objects4CONFIG_IDntext10737418230
TOPWorkbench Tools Editors, Painters, Modelers
143SCCD_CFG_ELEMSCC: Check Configuration Elements1CONFIG_IDCheck Configurationnvarchar300
144SCCD_CONFIGSCC: Check Configurations1CONFIG_IDCheck Configurationnvarchar300
145SCCD_CONFIG_TSCC: Check Configuration Texts1CONFIG_IDCheck Configurationnvarchar300
146SCCD_RULE_ELEMSCC: Check Elements4CONFIG_IDCheck Configurationnvarchar300