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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

51 columns | Print definition?ERP 6.0  | DEFAULT_VALUE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/NAKISA/THRPROGRProgress type detail information6DEFAULT_VALUEGeneral Flagnvarchar10
2/OTX/SEA_TEMREGRegions used in a search template7DEFAULT_VALUESearch region default valuenvarchar2550
3DODP_FIELDDBOSC-DP: Data Provider Field16DEFAULT_VALUEnvarchar320
4DORDS_PARAMETERDBOSC-RDS: Request Process DB SQL Parameter9DEFAULT_VALUEnvarchar1280
5GRACCONFIGConfiguration Parameter Table3DEFAULT_VALUEConfiguration Value Setnvarchar1000
6GRACEUPCONFIGEnd User Personalization Fields4DEFAULT_VALUEDefault value for EUPnvarchar2550
7NWS_EXT_SELData Transport Management Tool SELECT OPTIONS9DEFAULT_VALUENWS-Extraction: Stringnvarchar500
8RSBPC_EN_DEFPREE&N Master User Preferences for Default Values6DEFAULT_VALUEValue of an Item for User Preferencesnvarchar500
9TILM_STOR_CUS_PILM DB Store: Properties5DEFAULT_VALUEILM DB Store: Customizing Value of a Settingnvarchar500
10TILM_STOR_MONCGPILM DB Store: Parameters for Global Monitoring Cust. Table4DEFAULT_VALUEILM DB Store: Customizing Value of a Settingnvarchar500
11TILM_STOR_MONCPILM DB Store: Properties5DEFAULT_VALUEILM DB Store: Customizing Value of a Settingnvarchar500
TOPAuthentication and SSO
12SEC_POLICY_ATTRList of Available Security Policy Attributes4DEFAULT_VALUEDefault Value of a Security Policy Attributeint100
TOPBusiness Configuration Tools Runtime
13SC2_BCO_PROP_DFC2 Server: Configuration Object Attributes (Definition)6DEFAULT_VALUEDefault Attribute Valuenvarchar10
TOPCentral Part of Product Master
14COMC_ALTID_CNFLDSpecify Context Data for ID Types4DEFAULT_VALUEContext Fields with Data Type Stringnvarchar2550
TOPClassification Toolset
15CLS_ATTRIBUTEAttribute11DEFAULT_VALUEAttribute valuenvarchar1840
TOPCollaborative Cross Applications
16/POA/D_ENDEFPREFE&N Master User Preferences for Default Values6DEFAULT_VALUEValue of an Item for User Preferencesnvarchar500
TOPCompliance Check
17EHSBC_RC_ADPARAEHS: Composition Parameters4DEFAULT_VALUEDefault Value on Initial Screennvarchar300
TOPData Mining
18RSDMTPN_SRV_PARParameters required for the services7DEFAULT_VALUEParameter Value as Stringntext10737418230
19RSDMTP_SRV_PARAMParameters required for the services9DEFAULT_VALUEDefault value of the parameternvarchar640
TOPData Replication Framework
20DRFC_PARO_VALSupported Outbound Parameter Values4DEFAULT_VALUEDefault Outbound Parameter Value Flagnvarchar10
TOPEnd User Technology
21RSKPI_ATTR_DEFKPI Attribute: Header Data10DEFAULT_VALUEValue of KPI Attribute (Restricted to 255 Characters)nvarchar2550
22RSRD_ATTRBroadcasting Framework: Producer/Distributor Attributes18DEFAULT_VALUEValue in Parameter Container (CL_RSR_PARAMETER) as Stringnvarchar2550
TOPGRC Access Control Plug-In
23/GRCPI/GRIA_CONCConfiguration Parameter Table2DEFAULT_VALUEParam Valuenvarchar400
TOPIntegration Customer Relationship Management
24ESALES_PSFIELDSField Properties for Set Type Attributes for each Product8DEFAULT_VALUEDefault valuenvarchar1320
TOPPeople Centric UI Framework
25CRMC_LAYOUTLayout table for structureedit element20DEFAULT_VALUEDefault valuenvarchar500
26CRMC_LAYOUTCLayout table for structureedit element21DEFAULT_VALUEDefault valuenvarchar500
TOPPeople Centric UI Framework Customizing
27CRMC_FIELDGRPScreen Structure Field Group Field16DEFAULT_VALUEDefault valuenvarchar500
28CRMC_FIELDGRPCField Group (Cust.)17DEFAULT_VALUEDefault valuenvarchar500
TOPPoint of delivery
29EUISTRUTYPECUSTPoD Structure Category: Screen Settings6DEFAULT_VALUEDefault value for PoD fieldnvarchar500
TOPQuality Management
30QMDS_REMARKRemark for Digital Signature6DEFAULT_VALUEDefault Value for Remark for Digital Signaturenvarchar10
TOPRapid Applications
31AXT_EMB_MAPAMapping of Rapid Application to Tagtable Attr.4DEFAULT_VALUEParameter Valuenvarchar2550
32AXT_EMB_MAP_CAMapping of Rapid Application to Tagtable Attr.5DEFAULT_VALUEParameter Valuenvarchar2550
TOPReturnable Packaging Logistics
33RLUSPROUser Profile for Returnable Packaging Account Postings4DEFAULT_VALUEDefault Value of a Fieldnvarchar400
TOPRevenue
34OIUH_REP_PAR_SETReporting - Parameter Set per Report5DEFAULT_VALUE30 Charactersnvarchar300
TOPService Implementation Workbench
35TSIW_SXF_FIELDSignature Exchange Format - Field12DEFAULT_VALUEDefault Valuenvarchar1000
TOPStatus and Action Management
36SAMDT_ELEMENTSS&AM Elements13DEFAULT_VALUESingle-Character Indicatornvarchar10
TOPUI Configuration Design Layer
37BSP_DLC_DESIGNDesign layer: Design8DEFAULT_VALUEDefault Valuenvarchar500
38BSP_DLC_SDESIGNDesign layer: Design7DEFAULT_VALUEDefault Valuenvarchar500
TOPWeb Dynpro ABAP
39WDG_UR_PROPERTYUnified Rendering: Properties6DEFAULT_VALUEntext10737418230
TOPWeb Dynpro ABAP Runtime
40WDY_URL_PROP_DEFWeb Dynpro: URL Parameter for Web Dynpro ABAP Framework3DEFAULT_VALUESSTRING in Lowercase Lettersnvarchar2550
TOPWeb Screen Tools - ABAP
41WDY_APP_PROP_DEFWeb Dynpro: Application Property Definition4DEFAULT_VALUEWeb Dynpro Metadata APIntext10737418230
42WDY_CTLR_PARAMWeb Dynpro: Parameter of a Controller12DEFAULT_VALUEnvarchar2550
43WDY_CTX_ATTRIBWeb Dynpro: Context Attributes of Controllers9DEFAULT_VALUEnvarchar2550
44WDY_PLUG_PARAMWeb Dynpro : Plug Parameter12DEFAULT_VALUEnvarchar2550
45WDY_VS_PROP_DEFWeb Dynpro : View Set Definition5DEFAULT_VALUEntext10737418230
TOPWeb Service Tools - ABAP
46VEPFIELDREFWS Virtual Interface: Field References, Default Values9DEFAULT_VALUEDefault Value of a Parameternvarchar2550
47VEPPARAMETERWS Virtual Interface: Parameter(s) of a Function9DEFAULT_VALUEDefault Value of a Parameternvarchar2550
TOPWeb Services Tool
48BSDM_ATTRIBUTESBol: Service Data Manager : Mapping table8DEFAULT_VALUEDefault Valuenvarchar500
49CRMC_WSC_OBJTREEWSC Object Tree Table13DEFAULT_VALUEDefault Value for Query Attributentext10737418230
50CRMC_WST_DESIGNOpen Services Tool: Design8DEFAULT_VALUEDefault Valuenvarchar500
TOPWorkbench Tools Editors, Painters, Modelers
51SCCD_ASPECTSCC: Check Aspects8DEFAULT_VALUECheck Aspect Value (Proposal)nvarchar2550