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

51 columns | Print definition?ERP 6.0  | READONLY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/I_SBU_FSB: UI commands (function codes)4READONLYSB: UI indicator for read-only modenvarchar10
2CNVCMIS_A_1_ENQUENQU Data (Header)10READONLYRead-Only Flag for Views (old)nvarchar10
3CNVCMIS_A_1_MCOBMCOB type Repository Analysis20READONLYRead-Only Flag for Views (old)nvarchar10
4CNVCMIS_A_1_VIEWVIEW type Repository Analysis10READONLYRead-Only Flag for Views (old)nvarchar10
5CNVCMIS_FIELDSExplicit conversion rules for fields during migration10READONLYRead-Onlynvarchar10
6CNVMBTFIELDSexplicite conversion rules for fields during migration10READONLYRead-Onlynvarchar10
7CNVMBTTABLESexplicite list of tables to be handled during migration15READONLYRead-Onlynvarchar10
8CNVTDMS_08_FIELDexplicite conversion rules for fields during migration11READONLYRead-Onlynvarchar10
9CNV_10996_FIELDSSpecific conversion routines6READONLYConversion: Qualifier for read-only table fieldnvarchar10
10DOUI_ELEMDBOS Cockpit: Screen Element17READONLYDBOSC-CR: Generated ID (30)nvarchar300
11T7UN_ESS_PROPSNPO: Field Properties of Approver screen8READONLYHR: Output Fieldnvarchar10
12TEWAWATEXTASSGNAllocation of Text IDs to Text Profiles in Fast Entry Wghng4READONLYBehavioral Control "Read Only" Propertynvarchar10
13TEWA_EL_OBJBHUIFBehavioral Control User Interface Fields6READONLYBehavioral Control "Read Only" Propertynvarchar10
14UCONHTTPCUSTHEADUnified Connectivity Service Sub Services15READONLYUCON: Only display of servicenvarchar10
15UCONPROFHEADUCON: Profile Header Table13READONLYUCON: Only display of servicenvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
16CD0TBSH001Veri-Struktur mit Suchhilfe-Anbindung7READONLYRead-Only Flag fuer Views (old)nvarchar10
17DD25LAggregate Header (Views, MC Objects, Lock Objects)7READONLYRead-Only Flag for Views (old)nvarchar10
TOPArchive Information System
18ASPART_ACTArchiveInfoSys: Actual Partitioning7READONLYAS: Partition is Read Onlynvarchar10
TOPBusiness Application Support
19CNVFIELDSConversion: Table fields affected6READONLYConversion: Qualifier for read-only table fieldnvarchar10
20CNVFIELDSCConversion: Table fields with conflicts in blending7READONLYConversion: Qualifier for read-only table fieldnvarchar10
21CNVFIELDSCUConversion: User-defined table fields affected6READONLYConversion: Qualifier for read-only table fieldnvarchar10
TOPBusiness Planning and Simulation
22UPX_KFS_COMMONKey Figure Schemes for Planning Layouts: General Fields5READONLYOnly Display Key Figurenvarchar10
TOPBW Service API
23ROOSOURCETable Header for SAP BW OLTP Sources (Relevant From 2.0)11READONLYKey Figures for Extractor Tests in Delta Modenvarchar10
TOPCorporate Performance Monitor
24UMR_RI118RMS: Measure-Risk Value Fields Read Only Flag7READONLYFlag (X or Blank)nvarchar10
TOPData Conversion
25DMC_STRUCTSender Structure or Recipient Structure18READONLYBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPDirectory
26LDAPUSERLDAP System User3READONLYUser only has read authorizationnvarchar10
TOPEnd User Technology
27RSTHEMESBEx Themes3READONLYBooleannvarchar10
TOPFinancials Basis
28UGR31021FIN Master Data: Buffer Table for DataSource Properties6READONLYFIN Master Data: Indicator for Extractor Tests in Delta Modenvarchar10
TOPGeneral
29T588MFPROPCHR: Field Properties8READONLYHR: Output Fieldnvarchar10
30T588MFPROPSHR: Field Properties7READONLYHR: Output Fieldnvarchar10
TOPGovernance, Risk and Compliance
31GRPC_MCF_CUSFLDCustom Field UI configuration6READONLYRead only Flagnvarchar10
32GRPC_MCF_SAP_ATTDynamic SAP Attributes properties5READONLYRead only Flagnvarchar10
TOPInternet Communication Framework
33ICFALIASExternal Aliases in ICF Services66READONLYICF: Display Only for Servicenvarchar10
34ICFBUFFERBuffer for URL Display in Service List76READONLYICF: Display Only for Servicenvarchar10
35ICFSERVICEICF Service Tree in Internet Communication Framework69READONLYICF: Display Only for Servicenvarchar10
TOPMaintenance Processing
36/MRSS/C_DPR_UIConfiguration of UI elements in C Projects4READONLYReadOnlynvarchar10
TOPOrganizational Management
37T777IFPROPCHRBAS: Infotype Field Properties10READONLYOutputnvarchar10
38T777IFPROPSHRBAS: Infotype Field Properties9READONLYOutputnvarchar10
TOPPension fund Netherlands
39T5NKSActuarial File: Actuarieel bestand5READONLYAlleen lezennvarchar10
TOPPeople Centric UI Framework
40CRMC_LAYOUTLayout table for structureedit element16READONLYRead Onlynvarchar10
41CRMC_LAYOUTCLayout table for structureedit element17READONLYRead Onlynvarchar10
TOPPeople Centric UI Framework Customizing
42CRMC_FIELDGRPScreen Structure Field Group Field12READONLYRead Onlynvarchar10
43CRMC_FIELDGRPCField Group (Cust.)13READONLYRead Onlynvarchar10
TOPProcess Management
44POC_DB_STEPDomain Model: Table for Step Basic Data9READONLYNatural Numberint100
TOPProduct Data Management
45CEPRECEIVERSRecipients of the distributed CM folder in CEP scenario5READONLYRead-onlynvarchar10
46TPROF_CEPProfile for CEP5READONLYRead-onlynvarchar10
TOPScripting
47CRMD_IC_SCRUFInteractive Scripting fields3READONLYRead-Only Indicatornvarchar10
TOPTable Maintenance Tool
48SDMECLSATRDME: Maintenance Object Attribute14READONLYDME: Read-Only Field Flagnvarchar10
49SDMEDPDADME: Dialog Pool Component 'Dialog' (Area)11READONLYDME: Read-Only Field Flagnvarchar10
50SDMEDPDCDME: Dialog Pool Component 'Dialog' (Components)11READONLYDME: Read-Only Field Flagnvarchar10
51SDMEDPVFDME: OBSOLETE Dialog Pool Component 'View' (Fields)6READONLYDME: Read-Only Field Flagnvarchar10