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

29 columns | Print definition?ERP 6.0  | SEL_OPTION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/C_SEL_RANGESelection Range for Simplification5SEL_OPTIONSelection Optionnvarchar20
2/OTEI/RP_T_VARHREFM Report variants - HR selection criteria6SEL_OPTIONCHAR02 data element for SYSTnvarchar20
3/XPPM/ERS_UPARAMUser Parameter store9SEL_OPTIONVersion Number Componentnvarchar20
4DMC_TABNAM_RANGEranges for table name selection4SEL_OPTIONType of OPTION component in row type of a Ranges typenvarchar20
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
5CRMCHKRUNMCheck Messages7SEL_OPTIONnvarchar20
6CRMREQSELOUTDATED - TO BE DELETED - ACCESS STRONGLY DISCOURAGED7SEL_OPTIONnvarchar20
TOPAccounting Engine
7/EACC/DERIV_CONDConditions for Derivation Steps9SEL_OPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPBusiness Rule Framework
8TBRF133BRF: Range - Statement Select-Option Data12SEL_OPTIONRelational Operator for Value Range Conditionnvarchar20
TOPCalculations
9CMS_BCM_CGP_ADMAdmin data of covarage gap monitoring report7SEL_OPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPCollections Management
10UDM_PR_SEL_OPTSelection Options for Parallel Processing7SEL_OPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
11UDM_STR_SELOPSelection Options for Strategies8SEL_OPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
12UDM_STR_SELOP_VSelection Options of Collection Strategies9SEL_OPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPControlling
13SE16N_ROLE_VALUESE16N: Restriction of Authorization to Tables/Fields7SEL_OPTIONTable display: OPTION for selectionnvarchar20
TOPCross-Application Components
14CMPERSPARMPersonalization: User Settings9SEL_OPTIONOperator of Selection Optionnvarchar20
15WPPERSPARMPersonalization: User Settings9SEL_OPTIONOperator of Selection Optionnvarchar20
TOPCross-Application Mass Maintenance
16MASSVARRANGEVariants: Selection Options (Ranges)9SEL_OPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
17MASSVARRANGE_SSystem Variants: Selection Options (Ranges)8SEL_OPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPDocument Management Services
18SDOKCLPROPSDOK: Assessable attributes dependent on document class10SEL_OPTIONRelational operator for context-specific document selectionnvarchar20
TOPElectronic Bank Statement
19FEBIPPosting Parameters for Postprocessing6SEL_OPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
20FEB_IMP_SELOPTSelection Options of Posting Parameters9SEL_OPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
21FEB_PARMT_POSTPosting Parameters for Postprocessing6SEL_OPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
TOPFinancial Supply Chain Management
22TBNK_RULE_SELOPRule select options10SEL_OPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPForms
23TSELRANGES_01HR Forms: Specifications of Selections7SEL_OPTIONType of OPTION component in row type of a Ranges typenvarchar20
TOPFunds Management
24FMFGRCNSLICESELReconciliation data slice: Primary data selection criteria6SEL_OPTIONReconciliation: data selection OPTION vauenvarchar20
TOPMaster Data
25EPDPRODIDSELMD Template: Selection Criteria for Environment Analyzer9SEL_OPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPNet Worth Tax
26IDFIAA_JP_COND1Selection Criteria for Stored Reports10SEL_OPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPPersonalization Framework
27FPB_PERSPARMPersonalization: User Settings16SEL_OPTIONOperator of Selection Optionnvarchar20
TOPSAP Records Management
28SRM_PU_QUERY_DEFPre-Defined Search Based on Selection Criteria6SEL_OPTIONPU: Selection Option: OPTIONnvarchar20
TOPUse Subcomponents
29SOURSAPoffice: Set of Regulations for User Agent7SEL_OPTIONCHAR04 data element for SYSTnvarchar40