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

146 columns | Print definition?ERP 6.0  | OPT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_AODSMAPMap AOF package versions to valid DS versions4OPTnvarchar20
2/MRE/RSC_FIL_VALRetail Execution: Define Filter Values9OPTOperation for selection choicenvarchar20
3CNVCMIS_A_20_SELSelect options for manual selection of table names (CCCC)5OPTSelection Optionnvarchar20
4CNV_10400_HEAD_SRange area for storing the select option for characteristics5OPTOPTION field for selection optionsnvarchar20
5CNV_10940_CONVSTVariant conversion status10OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
6CNV_10940_FSELStoring free selections12OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
7CNV_10940_VARDETStoring values of variants16OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
8CNV_20100_CEFORMCEFORMF records with rel. org. units + addit. VALUE field11OPTOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
9DMF_D_SELOPTSelect Options used for initial promotion transfer4OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
10ESH_OM_AOTYPNRPVObject Types: Nodes: Related perspectives: Fixed Values9OPTOptionnvarchar20
11ESH_OM_AOTYPNRRVObject Types: Nodes: Related requests: Fixed Values9OPTOptionnvarchar20
12ESH_OM_COTYPNRPVObject Types: Nodes: Related perspectives: Fixed Values9OPTOptionnvarchar20
13ESH_OM_COTYPNRRVObject Types: Nodes: Related requests: Fixed Values9OPTOptionnvarchar20
14ESH_OM_IOTYPNRPVObject Types: Nodes: Related perspectives: Fixed Values9OPTOptionnvarchar20
15ESH_OM_IOTYPNRRVObject Types: Nodes: Related requests: Fixed Values9OPTOptionnvarchar20
16FAGL_SLL_ACTVITYActivity Model3OPTType of OPTION component in row type of a Ranges typenvarchar20
17GRACBGRANGERange table values for Background Job variant8OPTSelection Operator OPTION (According to Range Table) - Copynvarchar20
18IUUC_RC_TMPL_PATTemplate-Table for holding patterns5OPTsign for range tablenvarchar20
19IUUC_RL_SELCONDIUUC ReplicationLogging Selection-Conditions5OPTsign for range tablenvarchar20
20IUUC_RL_SLC_HISTIUUC ReplicationLogging Selection History4OPTsign for range tablenvarchar20
21MEP_BOOST_CONDME Boost Conditions6OPTType of OPTION component in row type of a Ranges typenvarchar20
22RSBPCB_MEM_ATTRBPC: BPF Driver Dimension Attribute Member Item10OPTSelection criteria: OPTIONnvarchar20
23RSCRMPACK_H.7OPTSelection operator OPTION for range tablesnvarchar20
24RSDAADDARCHIVEBW Archiving: Select Initial Loading for Archive6OPTSelection criteria: OPTIONnvarchar20
25RSIPRORANGESemantic Partitioning: Data Distribution8OPTOperator in Select Options and other Expressionsnvarchar20
26RSOSFILTERBW Search: Filter Information on Table Fields4OPTOperator in Select Options and other Expressionsnvarchar110
27SRAL_COND_FIELDSRAL: Condition for field10OPTRAL: Optionnvarchar20
28SRT_CONDITIONSSRT: Conditions10OPTSRT: Optionnvarchar20
29TWFSAWorkflow: transfer rule: actions in current status5OPTOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
TOPAccounting - General
30TFC_INST_VALCharacteristic Values of Org Units per Node7OPTOPTION for Rangesnvarchar20
31TFC_TEMPL_VALCharacteristic Values of Org Units per Node7OPTOPTION for Rangesnvarchar20
TOPASAP AcceleratedSAP
32TCUSTEMPCTemplate country assignment4OPTVersion Number Componentnvarchar20
TOPBackground Processing
33BTC_CRITERIASelection Criteria: Criteria7OPTVersion Number Componentnvarchar20
TOPBatch-Oriented Parallel Processing of Mass Data
34BANK_REP_PARAMSCurrent Selection Values for Report6OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
35TBANK_PP_APPLRELRelevant Applications for an Application (Par. Processing)4OPTType of OPTION component in row type of a Ranges typenvarchar20
36TBANK_PP_LKAPPLRelevant Application Types4OPTnvarchar20
TOPBusiness Planning and Simulation
37UPC_VAR_CHA_ACTVariables - Restricted Values8OPTSelection Condition: EQ, BT,...nvarchar20
38UPC_VAR_CHA_SELVariables - Selections8OPTSelection Condition: EQ, BT,...nvarchar20
39UPS_HEADERHeader Selections for STS7OPTSelection Condition: EQ, BT,...nvarchar20
TOPBW Service API
40RSFHSELDummy Table for Selections3OPTSelection criteria: OPTIONnvarchar20
TOPClient-System Adapter
41MDMEXVARISELMDM Extractor: Selection Criteria7OPTSelection criteria: OPTIONnvarchar20
42MDM_SELECT_TRANSMDM: Storage Location of Selections and Transfer Segments9OPTSelection Operator OPTIONnvarchar20
TOPClinical System
43N1DCS_AGR_RANGEDCS: Quick Entry of Settings for Roles (Ranges)9OPTIS-H: OPTION Parameter of Range Tablenvarchar20
44N1DCS_USR_RANGEIS-H*MED: DCS: Quick Entry User Settings (Ranges)9OPTIS-H: OPTION Parameter of Range Tablenvarchar20
TOPCollectionsDisbursements
45VVKKSORESReservation Table for Simultaneous Runs6OPTOption (like RANGES table)nvarchar20
TOPCross-Application Components
46CRMFILCONDTable for Temporary Saving of Filter Conditions11OPTSelection Operator OPTION (according to Table Range)nvarchar20
47CRMFILTABFilter Conditions for Download8OPTSelection Operator OPTION (according to Table Range)nvarchar20
48HDB_RANGESERP Accelerators: Generic Restrictions9OPTOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
49TASUVSVDASU: Variants: transparent saved data11OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPData Basis
50RSBREQUIDSELSETSelection Options of a Request5OPTSelection criteria: OPTIONnvarchar20
51RSBSPOKESELSETInfoSpokes Directory6OPTSelection criteria: OPTIONnvarchar20
52RSBSPOKEVSELSETInfoSpokes Directory6OPTSelection criteria: OPTIONnvarchar20
53RSDIPROIOBJRANGEPartitioning Areas: InfoProvider6OPTOperator in Select Options and other Expressionsnvarchar20
54RSLPOPARTRANGELogical Partitioning: Partitioning Criteria7OPTOperator in Select Options and other Expressionsnvarchar20
TOPData Mining
55RSDMESC_ABC_SELThreshold Values for Filling ABC Indicator4OPTSelection criteria: OPTIONnvarchar20
56RSDMESC_ABC_VARVariable Values for ABC Analysis5OPTSelection operator OPTION for range tablesnvarchar20
TOPData Replication Framework
57DRFD_APPL_FILTDefinition of Explicit Filters9OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
58DRFD_APPL_FILT_CFilterCriteria10OPTDRF ABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPData Staging
59RSBKDATAPAKSELDTP: Data Package Selections6OPTSelection criteria: OPTIONnvarchar20
60RSDAARCHREQSELBW Archiving: Absolute Selections of the Archive Request5OPTSelection criteria: OPTIONnvarchar20
61RSDELDONEBW: Selection Table for Deletion with Full Update Scheduler7OPTSelection criteria: OPTIONnvarchar20
62RSLDPDELBW: Selection Table for Deleting with Full Update Scheduler8OPTSelection criteria: OPTIONnvarchar20
63RSLDPDELSHBW: Selection Table for Deletion with Full Update Scheduler7OPTSelection criteria: OPTIONnvarchar20
64RSLDPSELSelection table for fields scheduler7OPTSelection criteria: OPTIONnvarchar20
65RSLDPSELHISTSelection Table for Fields of Scheduler - Changes/History8OPTSelection criteria: OPTIONnvarchar20
66RSLDPSELSHSelection table for fields scheduler6OPTSelection criteria: OPTIONnvarchar20
67RSPCINSTANCEGeneric Instance Storage7OPTSelection criteria: OPTIONnvarchar20
68RSPCRUNVARIABLESVariables for Process Chains for Runtime5OPTSelection criteria: OPTIONnvarchar20
69RSPCVARIANTGeneric Variant Storage7OPTSelection criteria: OPTIONnvarchar20
70RSSELDONEMonitor: Selections for executed request6OPTSelection criteria: OPTIONnvarchar20
71RSSELMONMonitor: Selection Variants7OPTSelection criteria: OPTIONnvarchar20
TOPDocument Management Framework
72SKWF_QUALKW Framework: Query Settings6OPTRelational operator in search querynvarchar20
TOPEnd User Technology
73RSKPI_KPI_DASINKPI: Data Access Services Input Parameters8OPTSelection criteria: OPTIONnvarchar20
74RSKPI_KPI_INVALKPI: Values for Input Parameters7OPTSelection criteria: OPTIONnvarchar20
75RSKPI_VNT_INVALKPI Variant: Input Parameter Values8OPTSelection criteria: OPTIONnvarchar20
76RSRA_BB_PARAMParameter Table for Bucket Setting7OPTSelection criteria: OPTIONnvarchar20
77RSRA_BT_PARAMGeneral Parameter Table7OPTSelection criteria: OPTIONnvarchar20
78RSRA_ER_PARAMParameter Table for Exception Setting7OPTSelection criteria: OPTIONnvarchar20
79RSRA_MESSAGEData for the Message Object7OPTSelection criteria: OPTIONnvarchar20
80RSRA_MX_PARAMParameter Table for MDX Setting7OPTSelection criteria: OPTIONnvarchar20
81RSRA_RA_PARAMGeneral Parameter Table7OPTSelection criteria: OPTIONnvarchar20
82RSVHSVALUESETValue help services user setting A segment13OPTOperator in Select Options and other Expressionsnvarchar20
83RSZGLOBVGlobal Variables in Reporting29OPTOperator in Select Options and other Expressionsnvarchar20
84RSZRANGESelection specification for an element13OPTOperator in Select Options and other Expressionsnvarchar20
TOPFront Office
85ECICACCCONDCIC Auto Activity Component: Conditions9OPTSelection option (EQ/BT/CP/...)nvarchar20
TOPFSCM In-House Cash
86IHC_DB_RT_NODEIHC: Routing Node10OPTnvarchar20
87IHC_TAB_SELECTIHC: Selections in Selection Variants12OPTnvarchar20
TOPGateway Business Eventing and Provisioning
88/IWBEP/D_SUBS_FLSubscription Filter Criteria6OPTSelection operator OPTION for range tablesnvarchar20
TOPGeneral Ledger Accounting
89FAGL_RPACK_RESReorganization: Package Restrictions7OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
90FAGL_RPLAN_RESReorganization: Restrictions of the Plan6OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPGeneral Ledger Reorganization
91FAGL_R_PL_RES_GReorganization: General Restrictions of the Plan7OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
92FAGL_R_PL_RES_SReorganization: Specific Restrictions for Object Types8OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPIntegrated Product and Process Engineering
93PPEFILTATTRSELField Catalog Attributes7OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPInterestCharge Calculation
94TBKKMLOCKAPPLRelevant Application Types4OPTOperation for selection choicenvarchar20
TOPInvestment Programs
95TAI15Select-options for org. units5OPTSelection optionsnvarchar20
TOPMaster Data Synchronization
96MDSM_SYNC_HIST_FSelection Conditions for Load History8OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPNetWeaver Enterprise Search
97ESH_OM_AAUTHCVPBPath based Authorization Checks: Check Values for Free Style8OPTOptionnvarchar20
98ESH_OM_AAUTHNLNWSAP_NW Authorizations: Assg. of Auth. Objects: Control Flds12OPTOptionnvarchar20
99ESH_OM_ADPRVDFLCData Providers: Filters: Filter Conditions10OPTOptionnvarchar20
100ESH_OM_ARELATFVRelations: Fixed Values10OPTOptionnvarchar20
101ESH_OM_CAUTHCVPBPath based Authorization Checks: Check Values for Free Style8OPTOptionnvarchar20
102ESH_OM_CAUTHNLNWObs:SAP_NW Authorizations: Assg. of Auth. Objects: Ctrl Flds12OPTOptionnvarchar20
103ESH_OM_CDPRVDFLCData Providers: Filters: Filter Conditions10OPTOptionnvarchar20
104ESH_OM_CRELATFVRelations: Fixed Values10OPTOptionnvarchar20
105ESH_OM_IAUTHCVPBPath based Authorization Checks: Check Values for Free Style8OPTOptionnvarchar20
106ESH_OM_IAUTHNLNWSAP_NW Authorizations: Assg. of Auth. Objects: Control Flds12OPTOptionnvarchar20
107ESH_OM_IDPRVDFLCData Providers: Filters: Filter Conditions10OPTOptionnvarchar20
108ESH_OM_IRELATFVRelations: Fixed Values10OPTOptionnvarchar20
109ESH_OM_SAUTHNLNWSAP_NW Authorizations: Assg. of Auth. Objects: Control Flds12OPTOptionnvarchar20
110ESH_OM_SDPRVDFLCData Providers: Filters: Filter Conditions10OPTOptionnvarchar20
TOPOLAP Technology
111RSDDAGGRCHECKSELSelection Options for the Aggregate Check6OPTOperator in Select Options and other Expressionsnvarchar20
112RSDDTPSFMLVARVariables for CKF/RKF5OPTOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
113RSDRDLOGPOSITIONLog Delete Actions (Positions)4OPTSelection criteria: OPTIONnvarchar20
114RSECLOPDLOGFLOPD Protocol: Filter7OPTSelection criteria: OPTIONnvarchar20
115RSECLOPDQFILTERFilter within Queries6OPTSelection criteria: OPTIONnvarchar20
116RSRVARIANTVariant Values9OPTOperator in Select Options and other Expressionsnvarchar20
TOPOperational Data Provisioning ODP
117RODPS_REPL_SELSelections on Queues for Enterprise Search8OPTSelection criteria: OPTIONnvarchar20
TOPPlanning
118RSPLF_SRV_CONDRule Condition in Planning Service8OPTOperator in Select Options and other Expressionsnvarchar20
119RSPLF_SRV_PSParameter Value (Selection Type)10OPTOperator in Select Options and other Expressionsnvarchar20
120RSPLPPM_OPTTABMaster Data Table PPM Selection Option1OPTType of OPTION component in row type of a Ranges typenvarchar20
121RSPLPPM_OPTTABTText Table for RSPLPPM_OPTTAB2OPTType of OPTION component in row type of a Ranges typenvarchar20
122RSPLS_CR_RANGEChar.Relationship: Range (for example, for DataStore Object)8OPTOperator in Select Options and other Expressionsnvarchar20
123RSPLS_DS_RANGEData Slices: Selection8OPTOperator in Select Options and other Expressionsnvarchar20
TOPProcess Monitoring Infrastructure
124SSPIAGCNDLocal SPI: Agent Runtime; Configurations6OPTSelection operator OPTION for range tablesnvarchar20
125SSPIPVCSPI: Process Variant - Definition9OPTSelection operator OPTION for range tablesnvarchar20
126SSPISGCONSPI: Signature Condition Records7OPTSelection operator OPTION for range tablesnvarchar20
127SSPITRCCNDE2E Trace Conditions7OPTSelection operator OPTION for range tablesnvarchar20
TOPProfitability Analysis
128CEFORMETable of descriptions of element structures10OPTEQ, NE, BT, NB, CP, NP, LE, LT, GE, GTnvarchar20
129CEFORMFCO: Definition of contents of element in row/col.str.10OPTEQ, NE, BT, NB, CP, NP, LE, LT, GE, GTnvarchar20
130TKEPPLLEVSPlanning Level - Selection Table9OPTOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
131TKEPPLPPSPlanning Package - Selection Table10OPTOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
TOPResourcen Management
132RMSAC_STATSELOPTSelection Options Status Allowed for Lower-Level Object8OPTSelection Optionnvarchar20
TOPRetail Enterprise Services
133WESD_APPL_FILTDefinition of Explicit Filters9OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPSAP Business Partner
134MDM_SEL_TRANS_PRMDM: Storage of Selections and Transfer Segments (Copy)9OPTSelection Operator OPTION (Copy of MDM_OPTION)nvarchar20
TOPSAP Business Workflow
135SWELCFSelection Criteria for Selective Logging5OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPSAP NetWeaver Mobile - Use subcomponents
136MEREP_104Selection Criteria(Download): Mobile ID10OPTOption for Selection Criterianvarchar20
137MEREP_203Selection Criteria(Download): SyncBO9OPTOption for Selection Criterianvarchar20
138MEREP_204Selection Criteria (Download): Mobile Group10OPTOption for Selection Criterianvarchar20
TOPSAP Records Management
139SRMUSERQUERYStored Search Query v. Users According to Element Type9OPTnvarchar20
TOPService Data Download
140/SDF/AL_OBJECTFilter Objects for Application Log2OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
141/SDF/RBE_CS3_SSQL Check Step Select Options in SDA Analysis7OPTVersion Number Componentnvarchar20
TOPServices
142FINB_CONDITIONSConditions6OPTABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPTime Sheet
143CATS_BIW_SELOPTSelection Criteria for Delta Management (CATS -> BW)5OPTSelection criteria: OPTIONnvarchar20
TOPTransaction Manager
144TCORITS_CHK_FLDCheck Framework: Fields4OPTOption of a field in SWIFT formatsnvarchar10
145TCORITS_CHK_FLDTCheck Framework: Fields - Text table4OPTOption of a field in SWIFT formatsnvarchar10
TOPWithout Description
146RSENQ_PROT_DATATable log for lock manager (info table)6OPTObject name in where-used listnvarchar720