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

79 columns | Print definition?ERP 6.0  | FILTER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBTTSINCLEXCLInclude or exclude phases for executing activities4FILTERInclude or excludenvarchar10
2CNVMBTTSPHASEMBT PCL Trouble shooting - include or exclude phases4FILTERInclude or exclude phasesnvarchar10
3EHPRCC_IMCIXMCP: XML Import Conversion of Identifiers7FILTERFilternvarchar10
4EHPRCC_IMCXMLCP: XML Import Conversion of Classes/Characteristics7FILTERFilternvarchar10
5LTR_PRESELLTR: Preselection Steps10FILTERntext10737418230
6RSDMDM_IOBJ_DTLSCustomizing for Master Data Maintenance5FILTERAttribute may be used for the Filternvarchar10
7SIMDQ_INP_FILTERIM in HANA Filter for input4FILTERFilter For input fieldnvarchar6120
8T7CNTC_BR_DETAILDetail of Calculation Base Rule8FILTERFilter in BAdI: Calculation Base in Tax Calculation Rulenvarchar100
9TCY01Combination of selection sets2FILTERName of a combination of setsnvarchar300
10TCY02Combinations of selection sets - descriptions2FILTERName of a combination of setsnvarchar300
11UCFV400Check Table for BAdI Filter Values2FILTERBAdI: Filter Valuenvarchar300
12UCFV40TText Table for BAdi Filter Values3FILTERBAdI: Filter Valuenvarchar300
13T7PIQMSGCNTLFLTFilter for Business Add-In (BadI) for Message Control1FILTERFilter for Business Add-In (BadI) for Message Controlnvarchar40
14T7PIQMSGCNTLFLTTFilter for Message Control BAdI (Texts)1FILTERFilter for Business Add-In (BadI) for Message Controlnvarchar40
15T7PIQRLFILTERAssign Filters to Subrequirements3FILTERFilter for Performance Index or Subrequirementnvarchar40
16T7PIQ_SI2_FILPADefine Filters1FILTERFilter for Performance Index or Subrequirementnvarchar40
17T7PIQ_SI2_FILTERAcademic Performance Index Filter1FILTERFilter for Performance Index or Subrequirementnvarchar40
18T7PIQ_SI2_FILTTText Table for Academic Performance Index Filters1FILTERFilter for Performance Index or Subrequirementnvarchar40
19T7PIQ_SI2_INDXFIFilter/Academic Performance Index Assignments3FILTERFilter for Performance Index or Subrequirementnvarchar40
TOPABAP Authorization and Role Management
20AGR_INFOFilter Values from Generation Run4FILTERnvarchar150
TOPABAP XML Processing
21TIXBCHTSEiXML BC Registration Table for HTTP Servers5FILTERFilter class name for iXML BC http server registrationnvarchar320
TOPAerospace Defence Industry Solution
22DIT434KDI-IS Stock determination PM/CS: Header table6FILTERFilter for BADInvarchar10
TOPASAP AcceleratedSAP
23SAPHASFILTSolution Architect/IA: Assign Filter to Phase3FILTERUnique ID - 32 charactersnvarchar320
TOPAudit Management
24PLMC_AUDIT_EXT1Audit - Object Check Algorithm1FILTERInput Help for Audit Object (BAdI PLM_AUDIT_OBJECT)nvarchar20
25PLMC_AUDIT_EXT1TAudit Object Check Algorithm, Text1FILTERInput Help for Audit Object (BAdI PLM_AUDIT_OBJECT)nvarchar20
26PLMC_AUDIT_TYPEInvestigation Type (for Audit, FMEA,...)7FILTERInput Help for Audit Object (BAdI PLM_AUDIT_OBJECT)nvarchar20
TOPAustria
27T5A8HRAT_CLCP_FTHRAT: Cust. Text Table for Pension Calculation (BAdI Filter)3FILTERBAdI Filter for Pension Calculationnvarchar300
28T5A8HRAT_CLCP_FVHRAT: Cust. Table for Pension Calculation (BAdI Filter)5FILTERBAdI Filter for Pension Calculationnvarchar300
TOPAuto-ID Infrastructure
29/AIN/DM_DEVCS_FIFilter List of Common Subscription4FILTERDevice Filternvarchar1800
TOPAvailability Control
30FMAVC_RBE_FDEAVC Filter Definition for RBE2FILTERAVC Commitment/Actual Filter for RBEnvarchar20
31FMAVC_RBE_FDETText Table for AVC Filter Definition for RBE3FILTERAVC Commitment/Actual Filter for RBEnvarchar20
32FMAVC_RBE_FSEAVC Filter Settings for RBE2FILTERAVC Commitment/Actual Filter for RBEnvarchar20
TOPBasic Functions
33TPAFILTERFilter Table for Displaying Partner Subscription 1000 (V09C)3FILTERText field (length 6)nvarchar60
TOPBusiness Analytics
34UAB_PPE_SEL_F4UAB_PPE_SEL_F42FILTERCharacter field of length 40nvarchar400
TOPCapacity Evaluations
35TCY03Kombinations of sel. sets - assignment of sets to combin.2FILTERName of a combination of setsnvarchar300
TOPClinical System
36N1BCRC2BCSMCBasic Cat.: Display Config. - Main Catalog Assignment8FILTERBasic Cat.: "Only Display Display Configuration Data" Ind.nvarchar10
TOPCustomizing Project Management IMG
37TPR_INDEXList of nodes sorted by project5FILTERUnique ID - 32 charactersnvarchar320
TOPData Replication Framework
38DRFC_APPL_FILTConfiguration: Filters Used in an Application4FILTERFilter for a Filter Objectnvarchar20
39DRFC_APPL_IMPLConfiguration: Excluded Filters in a Outbound Implementation4FILTERFilter for a Filter Objectnvarchar20
40DRFC_FILTAvailable Filters on Filter Objects2FILTERFilter for a Filter Objectnvarchar20
41DRFC_FILTTDescription of Available Filters on Entities3FILTERFilter for a Filter Objectnvarchar20
TOPEEW Services
42OXT_CUS_USROXT User Data3FILTERWB Request: (Internal) Type of an ABAP Workbench Objectnvarchar30
TOPEnvironment, Health and Safety
43/TDAG/CPC_IMCIXMCP: XML Import Conversion of Identifiers7FILTERFilternvarchar10
44/TDAG/CPC_IMCXMLCP: XML Import Conversion of Classes/Characteristics7FILTERFilternvarchar10
TOPFunds Management
45FMBLSPLITLEDGERAssign split ledger to BL extension2FILTERFilter for Budgetary Ledger Implementationsnvarchar20
TOPGlobal Performance Analysis Transaction ST3
46SMEC_METAMEC check related metadata4FILTERMEC item Filter for different Check Scenariosnvarchar100
TOPImplementation Guide
47TNOTFPRNotes: Project link3FILTERUnique ID - 32 charactersnvarchar320
48TSTAFPRTest Workbench status: Connection to test package2FILTERUnique ID - 32 charactersnvarchar320
TOPIncentive and Commission Management ICM
49TCACS_DETAFLAccess Type Characteristics2FILTERDisplay Filter in Dialognvarchar10
TOPInfrastructure
50UCXI100Check Table for BAdi Filter Values1FILTERSEM-BCS: BAdI Filter (for Service Implementation)nvarchar30
TOPInteraction Center WebClient
51CRMC_IC_ACPROFFActivity Clipboard Filters for Profile Entries4FILTERActivity Clipboard Entry Filternvarchar200
52CRMS_IC_ACFILTERActivity Clipboard Possible Filters2FILTERActivity Clipboard Entry Filternvarchar200
TOPInternet Communication Framework
53PPROXY_FProxy Setting for HTTP/HTTPS Client (Filter)3FILTERFilter for Proxy Configurationnvarchar2000
TOPNetwork Operations
54GHO_PP_PT_FILTABFilter Settings Table for Planning Table2FILTERFilter for Planning Tablenvarchar120
55GHO_PP_PT_FILTXTTexttable for Filter Planning Table2FILTERFilter for Planning Tablenvarchar120
56GHO_PP_PT_UDATAUser specific Data for the Planning Table5FILTERFilter for Planning Tablenvarchar120
TOPProcess Management
57TC52ACustomizing of Process Instruction Positions in PI Sheet8FILTERName of the report variant of the filternvarchar140
TOPProduct Safety
58TCGA8EHS: Source for symbol generation6FILTEREHS: Scope of symbol generation for sourcenvarchar10
TOPRemaining Beverage - Obsolete Objects
59/BEV3/CHCCLSFFLTAssignment: Classification to filter2FILTERFilter Identifiernvarchar40
60/BEV3/CHCFLTFilter2FILTERFilter Identifiernvarchar40
61/BEV3/CHCFLTTFilter - Text2FILTERFilter Identifiernvarchar40
62/BEV3/CHTVWDARTContract Handling Document Type10FILTERFilter Identifiernvarchar40
TOPResourcen Management
63RMSLC_RULECustomizing: Apply Rule3FILTEREnhancement BAdI Filter IDnvarchar300
64RMSLC_RULETCustomizing: Texts for Apply Rule4FILTEREnhancement BAdI Filter IDnvarchar300
TOPRetail Enterprise Services
65WESC_APPL_FILTConfiguration: Filters Used in an Application4FILTERFilter for a Filter Objectnvarchar20
66WESC_APPL_IMPLConfiguration: Filters Used in a Service Implementation4FILTERFilter for a Filter Objectnvarchar20
67WESC_FILTAvailable Filters on Filter Objects3FILTERFilter for a Filter Objectnvarchar20
68WESC_FILTTDescription of Available Filters on Entities3FILTERFilter for a Filter Objectnvarchar20
TOPSAP Business Workflow
69SWN_COLSCHEDWF Notif: Selection Schedule4FILTERFilter IDnvarchar320
70SWN_FILTVALWF Notif: Filter Values3FILTERFilter IDnvarchar320
71SWN_NOTIFWF Notif: Notifications19FILTERFilter IDnvarchar320
TOPSearch
72/PLMB/CSEA_FILTRcustomizing for search filters3FILTERSearch Filter IDnvarchar300
TOPSelf-Service Procurement
73/SRMERP/C_MSG_FERP Shopping cart Message Filtering / Mapping5FILTERMessage Filternvarchar10
TOPTraders and Schedulers Workbench
74OIJ_3WP_SS3WP Selection Screen BADI filter table1FILTER3WP Selection Screen BAdInvarchar200
75OIJ_3WP_SST3WP Selection Screen BADI filter text table2FILTER3WP Selection Screen BAdInvarchar200
76TOIJ_NOM_FILTNomination data filters1FILTERNomination data filternvarchar200
77TOIJ_NOM_FILTTNomination data filters2FILTERNomination data filternvarchar200
78TOIJ_NOM_VIEWStores different nomination views3FILTERNomination data filternvarchar200
79TOIJ_REFDOC_BADIOIL-TSW: Update of scheduled documents - BADI selection3FILTERNomination update sched.line BADInvarchar200