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

52 columns | Print definition?ERP 6.0  | LOWERCASE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/NMTPCMComponents of types of numbering strategies4LOWERCASEAllow Lowercasenvarchar10
2/SYCLO/STG04Syclo cluster data cache storage - data structure meta data11LOWERCASELowercase letters allowed/not allowednvarchar10
3CNVCMIS_A_1_DOMASelection of Object Type Master information11LOWERCASELowercase letters allowed/not allowednvarchar10
4CNVCMIS_A_1_DTELSelection of Object Type Master information36LOWERCASELowercase letters allowed/not allowednvarchar10
5CNVMBTTECHELEPIFD Technical Element Descriptions for Variants7LOWERCASELowercase letters allowed/not allowednvarchar10
6CNV_10020_ACTOCActions for offset determination via value search17LOWERCASEIndicator for use of small lettersnvarchar10
7CNV_10020_CONDDVConditions for comparison of determation and values16LOWERCASEIndicator for use of small lettersnvarchar10
8CNV_10020_CONDFVConditions for comparison of field and values10LOWERCASEIndicator for use of small lettersnvarchar10
9CNV_10020_VLISTValue lists - Header data4LOWERCASEIndicator for use of small lettersnvarchar10
10DOUI_ELEMDBOS Cockpit: Screen Element33LOWERCASEnvarchar10
11LTR_DESTTYPE_DOMLTR: Home Destination Setting (L table)8LOWERCASELowercase letters allowed/not allowednvarchar10
12RSDODSODDICFIELDDataStore Object: Predefined DDIC Type Fields8LOWERCASELowercase letters allowed/not allowednvarchar10
13RSFBPSRCTYPEDEFDefinition of source types in the Open ODS View5LOWERCASELowercase letters allowed/not allowednvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
14DD01LDomains8LOWERCASELowercase letters allowed/not allowednvarchar10
15DD04LData elements28LOWERCASELowercase letters allowed/not allowednvarchar10
TOPApplication Framework
16MDG_MDF2005Properties of Master Data Fields30LOWERCASELowercase letters allowed/not allowednvarchar10
TOPBI Content Analyzer
17RSCONTIOBCHECKReference table check incompatible changes of InfoObjects20LOWERCASELowercase letters allowed/not allowednvarchar10
TOPBusiness Object Builder
18SWOT21Parameter Object Types 2.19LOWERCASELowercase letters allowed/not allowednvarchar10
19SWOTLQRuntime Table Parameters, Exceptions25LOWERCASELowercase letters allowed/not allowednvarchar10
20SWOTLVRuntime Table Verbs31LOWERCASELowercase letters allowed/not allowednvarchar10
TOPCross-Application Components
21/IXOS/DC_TAMAGeneral Doculink administraton data for data source35LOWERCASELowercase letters allowed/not allowednvarchar10
TOPData Conversion
22DMC_TRPARMDMC: Recoding Object Parameters (LOOKUP_PARAMETER)7LOWERCASELowercase letters allowed/not allowednvarchar10
TOPData Staging
23RSDSSEGFDDataSource - Segment Fields19LOWERCASELowercase letters allowed/not allowednvarchar10
24RSDSSEGFDSHDataSource in BW - Shadow Table Fields19LOWERCASELowercase letters allowed/not allowednvarchar10
25RSTSODSFIELDFields for the Operational Data Store16LOWERCASELowercase letters allowed/not allowednvarchar10
26RSUIFIELDSFields for Generated User Interfaces7LOWERCASELowercase letters allowed/not allowednvarchar10
TOPFast Search Infrastructure
27SFSRFW_IDX_IFDReplication Framework - Definition of Index Fields13LOWERCASELowercase letters allowed/not allowednvarchar10
28SFSRFW_IDX_KEY_DReplication Framework - Doc. ID Description of an Index12LOWERCASELowercase letters allowed/not allowednvarchar10
29SFSRFW_REQ_OBJSReplication Framework Requested Tables15LOWERCASELowercase letters allowed/not allowednvarchar10
TOPFinancials Basis
30UGMD2005FIN Master Data: Field Properties31LOWERCASELowercase letters allowed/not allowednvarchar10
31UGMD2040FIN Master Data: Definition of BW Info Objects23LOWERCASELowercase letters allowed/not allowednvarchar10
32UGMD2050FIN Master Data: Active Definition of BW Info Objects22LOWERCASELowercase letters allowed/not allowednvarchar10
33UGMD2140FIN Master Data: (Role-independent) Definition of Fields32LOWERCASELowercase letters allowed/not allowednvarchar10
34UGMD2150FIN Master Data: Active (Role-Indep.) Definition of Fields31LOWERCASELowercase letters allowed/not allowednvarchar10
TOPFSCM In-House Cash
35IHC_TAB_GUI_WLIHC: Setting for Browser Worklist8LOWERCASELowercase letters allowed/not allowednvarchar10
TOPInternationalization I18N
36I18NSRHGRGlobal Results (Search) of an I18N_SEARCH analysis7LOWERCASEAre lower case character allowed ?nvarchar10
TOPLegacy System Migration Workbench
37/SAPDMC/LSGBDCBI Name: "Code"24LOWERCASELowercase letters allowed/not allowednvarchar10
TOPMetadata Repository
38RSDCHABASBasic characteristics (for chars, XXL, time-chars and units)9LOWERCASELowercase letters allowed/not allowednvarchar10
39RSDDPAData package characteristics11LOWERCASELowercase letters allowed/not allowednvarchar10
TOPMobile Applications
40/ISDFPS/ME_SFLDDO Segement Fields18LOWERCASELowercase letters allowed/not allowednvarchar10
TOPNetWeaver Enterprise Search
41ESH_OM_ADATATYData Types11LOWERCASELowercase letters allowed/not allowednvarchar10
42ESH_OM_CDATATYData Types11LOWERCASELowercase letters allowed/not allowednvarchar10
43ESH_OM_IDATATYData Types11LOWERCASELowercase letters allowed/not allowednvarchar10
44ESH_OM_SDATATYData Types11LOWERCASELowercase letters allowed/not allowednvarchar10
TOPProject System
45FILTER_PS_LOGFilter for PS EHP415LOWERCASELowercase letters allowed/not allowednvarchar10
TOPQuery Management
46/PLMPCV/D_QVARQuery variable9LOWERCASELowercase Letters Allowed in Query Variable Valuesnvarchar10
TOPRepository Browser
47RSEUMODSettings for ABAP Workbench4LOWERCASEDisplay texts in lowercase on the screennvarchar10
TOPSAP NetWeaver Mobile - Use subcomponents
48MEREP_405Mapping Result for Synchronization (BAPI)22LOWERCASELowercase letters allowed/not allowednvarchar10
TOPTransport Organizer
49TLOGOObsolete13LOWERCASE'X' if lowercase is allowed, otherwise uppercase translatenvarchar10
TOPTreasury
50CML_MIG_BUFFERTable DDIC buffering (migration)36LOWERCASELowercase letters allowed/not allowednvarchar10
TOPUser and Authorization Management
51AUTH_FLDINFO_TMPAuthorization fields: technical info from dictionary32LOWERCASELowercase letters allowed/not allowednvarchar10
TOPWorkbench Utilities
52SPAR_NTDBParameter Storage: Persistent Nametab Container39LOWERCASELowercase letters allowed/not allowednvarchar10