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

83 columns | Print definition?ERP 6.0  | INTLEN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMFND/GS001AGeospatial service - Service Provider Attributes Meta Info15INTLENInternal Length in Bytesnvarchar60
2/SYCLO/CA003DMDO DOF Table Rule - Meta Data12INTLENInternal Length in Bytesnvarchar60
3CNVCMIS_A_1_TABFSelection of Object Type TABLE (TABF) Master information15INTLENInternal Length in Bytesnvarchar60
4CNVCMIS_A_20_DICTable fields for Cross-Client Customizing Comparison11INTLENInternal Length in Bytesnvarchar60
5CNVMBTTABSTRUCField list of tables for file transfer15INTLENInternal Length in Bytesnvarchar60
6CNV_20308_FLDCATField Catalog for Download8INTLENInternal Length in Bytesnvarchar60
7DD03NDDD: Attributes of a Node of a Structured Object11INTLENInternal Length in Bytesnvarchar60
8IUUC_RL_TABSTRstructural historical information for tables(Transp,Cluster)8INTLENInternal Length in Bytesnvarchar60
9T370ZHistory-related fields7INTLENInternal Length in Bytesnvarchar60
10ZCLUSTDATAData "piece" definitions for data cluster reporting10INTLENInternal Length in Bytesnvarchar60
11ZCLUSTKEYCluster key definitions for data cluster reporting9INTLENInternal Length in Bytesnvarchar60
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
12DD03LTable Fields12INTLENInternal Length in Bytesnvarchar60
13DD16SR/3 DD: SQL table fields10INTLENInternal Length in Bytesnvarchar60
TOPApplication Framework
14MDG_MDF2005Properties of Master Data Fields17INTLENInternal Length in Bytesnvarchar60
TOPBusiness Planning and Simulation
15UPC_CHAPROProperties of a Characteristic7INTLENInternal Length in Bytesnvarchar60
16UPC_KYFPROProperties of a Characteristic7INTLENInternal Length in Bytesnvarchar60
TOPChange Documents
17CDSOLMIG_DDChange Document Objects to be Migrated15INTLENInternal Length in Bytesnvarchar60
TOPClient-System Adapter
18MDMEXTRFLDMDM Field Table for Extraktor Metadata9INTLENInternal Length in Bytesnvarchar60
TOPControlling
19COAS_ATTRIBUTESMetadata for Attributes in Attribute Service4INTLENInternal Length in Bytesnvarchar60
TOPCross-Application Components
20/IXOS/DC_TAMAGeneral Doculink administraton data for data source11INTLENInternal Length in Bytesnvarchar60
21/IXOS/DC_TTC03LTable fields, created by using DDIF_NAMETAB_GET5INTLENInternal Length in Bytesnvarchar60
22TASUVSVDASU: Variants: transparent saved data9INTLENInternal Length in Bytesnvarchar60
TOPData Basis
23RSBOHFIELDSFields of the Open Hub Destination8INTLENInternal Length in Bytesnvarchar60
TOPData Staging
24RSBATCHDEBUGVALDebugging of Batch Processes - Variable List7INTLENInternal Length in Bytesnvarchar60
25RSBATCHWAITVALDebugging of Batch Processes - Variable List6INTLENInternal Length in Bytesnvarchar60
26RSISFIELDSHShadow table: InfoSource fields10INTLENInternal Length in Bytesnvarchar60
27RSISOFIELDInfoSource fields (provider structure of a source system)10INTLENInternal Length in Bytesnvarchar60
28RSKSFIELDNEWFields for New InfoSource10INTLENInternal Length in Bytesnvarchar60
29RSKSFIELDSHShadow table: Communication structure fields8INTLENInternal Length in Bytesnvarchar60
30RSOLTPSOURCEFDSHShadow Table: OLTP Source Fields10INTLENInternal Length in Bytesnvarchar60
31RSOLTPSOURCEFIEOLTP Source Fields10INTLENInternal Length in Bytesnvarchar60
32RSOLTPSOURCESFISegment Fields of a DataSource11INTLENInternal Length in Bytesnvarchar60
33RSOSATTFDSHShadow table: InfoSource attributes10INTLENInternal Length in Bytesnvarchar60
34RSOSFIELDSHShadow table: InfoSource fields10INTLENInternal Length in Bytesnvarchar60
35RSOSOATTFDInfoSource attributes of a source system10INTLENInternal Length in Bytesnvarchar60
36RSOSOFIELDInfoSource fields of a source system9INTLENInternal Length in Bytesnvarchar60
37RSTRAN_R_IOBJInfoObjects for UnitTest Transformation Runtime5INTLENInternal Length of InfoObjects in BW - see Docunvarchar60
38RSTRFIELDSHShadow table: Transfer Structure Fields10INTLENInternal Length in Bytesnvarchar60
39RSTSFIELDTransfer structure fields8INTLENInternal Length in Bytesnvarchar60
40RSTSFIELDSHShadow table: Transfer structure fields10INTLENInternal Length in Bytesnvarchar60
41RSTSIDOCFIELDFields for the IDoc Operational Data Store8INTLENInternal Length in Bytesnvarchar60
42RSTSODSFIELDFields for the Operational Data Store9INTLENInternal Length in Bytesnvarchar60
TOPFast Search Infrastructure
43SFSRFW_IDX_IFDReplication Framework - Definition of Index Fields9INTLENInternal Length in Bytesnvarchar60
44SFSRFW_IDX_KEY_DReplication Framework - Doc. ID Description of an Index8INTLENInternal Length in Bytesnvarchar60
45SFSRFW_REQ_OBJSReplication Framework Requested Tables11INTLENInternal Length in Bytesnvarchar60
TOPFinancials Basis
46UGMD2005FIN Master Data: Field Properties18INTLENInternal Length in Bytesnvarchar60
47UGMD2040FIN Master Data: Definition of BW Info Objects20INTLENInternal Length in Bytesnvarchar60
48UGMD2050FIN Master Data: Active Definition of BW Info Objects19INTLENInternal Length in Bytesnvarchar60
49UGMD2060FIN Master Data: Properties Valid During Generation3INTLENInternal Length in Bytesnvarchar60
50UGMD2140FIN Master Data: (Role-independent) Definition of Fields12INTLENInternal Length in Bytesnvarchar60
51UGMD2150FIN Master Data: Active (Role-Indep.) Definition of Fields11INTLENInternal Length in Bytesnvarchar60
52UGR31008FIN Master Data: Dummy Field Names with Properties16INTLENInternal Length in Bytesnvarchar60
53UGR31022FIN Master Data: Buffer Table f.Fields of Extract Structures14INTLENInternal Length in Bytesnvarchar60
TOPHierarchical Derivation Service
54THDS_GENCATLFCatalog for Generation8INTLENInternal Length in Bytesnvarchar60
55THDS_GENCATLF_ACatalog for Generation8INTLENInternal Length in Bytesnvarchar60
56THDS_GENCATLF_SCatalog for Generation7INTLENInternal Length in Bytesnvarchar60
TOPI18N Unicode
57UMGCONResults Table for Container Search7INTLENInternal Length in Bytesnvarchar60
TOPLegacy System Migration Workbench
58/SAPDMC/LSGBDCBI Name: "Code"20INTLENInternal Length in Bytesnvarchar60
TOPMetadata Repository
59RSDCHABASBasic characteristics (for chars, XXL, time-chars and units)5INTLENInternal Length of InfoObjects in BW - see Docunvarchar60
60RSDDPAData package characteristics7INTLENInternal Length of InfoObjects in BW - see Docunvarchar60
TOPNetWeaver Enterprise Search
61ESH_OM_ADATATYData Types9INTLENInternal Length in Bytesnvarchar60
62ESH_OM_CDATATYData Types9INTLENInternal Length in Bytesnvarchar60
63ESH_OM_IDATATYData Types9INTLENInternal Length in Bytesnvarchar60
64ESH_OM_SDATATYData Types9INTLENInternal Length in Bytesnvarchar60
TOPOrganizational Management
65T77OMATTRGeneral Attribute Maintenance: Definition of Attributes13INTLENInternal Length in Bytesnvarchar60
TOPPlanning
66T8PL01DDFI Planning: Dimensions Table Index - Dictionary Information9INTLENInternal Length in Bytesnvarchar60
67T8PL01DPFI Planning : Field Dependency for Validation10INTLENInternal Length in Bytesnvarchar60
68T8PLUATTRFI-Planning: Key Figures for Planning11INTLENInternal Length in Bytesnvarchar60
TOPProfitability Analysis
69TKEPEAdmin.table for transferring plan data from CO-PA to SOP9INTLENInternal Length in Bytesnvarchar60
TOPProject System
70FILTER_PS_LOGFilter for PS EHP412INTLENInternal Length in Bytesnvarchar60
TOPPurchasing
71WRFT_BUDG_KSSet of Key Figures6INTLENLength (No. of Characters)nvarchar60
72WRFT_BUDG_LEVBudget Level5INTLENLength (No. of Characters)nvarchar60
TOPSAP Business Partner
73MDMEXTRFLD_PREFMDM Field Table Extractor Metadata (Copy)9INTLENInternal Length in Bytesnvarchar60
TOPService Data Download
74/BDL/FUPTYPParameters or tables for the re-import8INTLENInternal Length in Bytesnvarchar60
75/BDL/IFFIELD/BDL/SDCC: fiels, dataelements and domains of table11INTLENnvarchar60
76BDLFUPTYPParameters or tables for the re-import8INTLENInternal Length in Bytesnvarchar60
77BDLIFFIELDBDL SDCC: Table's Fields, Data Elements, Domains11INTLENnvarchar60
TOPTransport Organizer
78VERSNTABStructures of the sub-objects of versionable objects20INTLENNumber of Decimal Placesnvarchar60
TOPTreasury
79CML_MIG_BUFFERTable DDIC buffering (migration)12INTLENInternal Length in Bytesnvarchar60
TOPUser Administration
80SPERS_OBJPersonalization object repository9INTLENInternal Length in Bytesnvarchar60
TOPUser and Authorization Management
81AUTH_FLDINFO_TMPAuthorization fields: technical info from dictionary8INTLENInternal Length in Bytesnvarchar60
TOPWithout Description
82RSKSFIELDFields of the communication structure8INTLENInternal Length in Bytesnvarchar60
TOPWorkbench Utilities
83SPAR_NTDBParameter Storage: Persistent Nametab Container15INTLENInternal Length in Bytesnvarchar60