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

59 columns | Print definition?ERP 6.0  | OPTI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ARBA/PARAM_TABAriba table to store configurable parameters6OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
2/EHR/S71_DOWNOutput Structures9OPTISelection optionnvarchar20
3/EHR/S71_OBJFObject Filter10OPTIOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
4/EHR/S71_OUTFOutput Field Filter6OPTIOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
5CNVHCM_RSPARAMSTDMS4HCM: Selection Set for Transfer Program7OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
6FIAPSAD_BL_EXPORCustomizing “Expenditure Orders Blocking” (2nd level)5OPTIType of OPTION component in row type of a Ranges typenvarchar20
7FIBKRUC_MO_FILTFilter on FI documents during memo order creation6OPTIType of OPTION component in row type of a Ranges typenvarchar20
8PYD_D_INSTPPayroll Data Source Instance Input Parameter7OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
9PYD_D_RESPPayroll Data Source Result Input Parameter8OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
10PYD_D_UVDPayroll Data Source Framework: User Variant Details8OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
11SCMA_CONT_EL_FCCElements of Workflow Container (TVARV Variable) for FCC8OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
12ZARIBA_PARAM_TABAriba table to store configurable parameters5OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPAccounting Interface
13GLE_ECS_VARIANTPVariants: Parameter Data12OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPAnalyzer
14AFWBM_CHVALTRM: Benchmark: Assignment of Characteristics and Values6OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
15AFWCH_FLDAFWCH: Filter Definition7OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
16AFWCH_FLD_BKBackup Filter Definition8OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPArchive Development Kit
17ADMI_VARIAContents of the Variant for the Archiving Program6OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPBasic Functions
18T800HISTPLog Tables for Program Runs in FI-GL or FI-SL: Items7OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPBusiness Accounting
19URCORD01Selection Conditions in a Realignment Request7OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPBusiness Analytics
20UABATIMPVARSELSelection Condits in Variants for Batch Import, PDCE, EhP46OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
21UADYNVAStore the Dynamic Variant for Batch Processing9OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPConsolidation
22TFMIG11Migration: Control for Cons Charts of Accounts4OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
23TFMIG12Migration: Control for Subitem Categories4OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
24TFMIG13Migration: Control Sets4OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPData Collection
25TKEBYExceptions (reference to reporting object)13OPTIOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
TOPData Retention Tool
26TXW_VARIAContents of Variant of TXW-archive retrieval7OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
27TXX_ADMI_PARDART-Administration ---Segment-Management---7OPTIBRST Selection option (EQ/BT/CP/...)nvarchar20
TOPFrance
28HRPAD940Additional data PAD9409OPTIType of OPTION component in row type of a Ranges typenvarchar20
29T5F2ICriteria for modifying reference period4OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPFreight Processing
30V54IV_SELOPTIncoming Invoice: Selection Transportation Service Provider8OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPFunds Management
31PSBM_URULE_OBJBudget Monitoring User Rules Objects9OPTIOperation for selection choicenvarchar20
TOPHR Administrative Services
32T5ASRSELFLDReport Selection Fields for LPA10OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
33T5ASRSELFLDSFSpecify Report Selection Fields for Reports: Stat.Field Sel.9OPTISelection Optionnvarchar20
TOPHR Information Systems
34HRSEL_RANGESSelection Condition Ranges7OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPLocalization
35IDWT_ADD_VARIANTAdditional variant contents for WT generic tool7OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPLogical DB, Selection Screens, Selection Variants
36TVARVTable of variables in selection criteria5OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
37TVARVCTable of Variant Variables (Client-Specific)6OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
38VARICONSelection variants: Content11OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
39VARICONCISelection Variants: Content (Cross-Client)10OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPMedia Product Sales and Distribution
40JSDVARIANTPARAMSIS-M Selection Variants - Parameters9OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPMulti Currency Accounting
41GLE_MCA_TPARAMSGLE MCA Selection Screen Parameters Table8OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPNon Profit Organizations
42T7UNPAD_RANGESEVE: Range for decision validation12OPTIOperator for decision rulenvarchar20
TOPObject Navigator
43/PLMB/NAV_SETVALNAV - User Specific Navigator Setting data7OPTIType of OPTION component in row type of a Ranges typenvarchar20
TOPPersonnel Time Management
44T559ZConditions for Employee Times in Time Evaluation8OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPProduction Planning
45TCPFS5External planning tool: start parameters for Windows NT9OPTIExternal planning tool: PC drive for optimizernvarchar10
TOPProfitability Analysis
46/EACA/TPMCHARCNDSELECT-OPTION for a Profitability Analysis Characteristic6OPTISelection operator OPTION for range tablesnvarchar20
47TKEBWLSCO-PA Connection to SAP BW: Selection Condition5OPTIOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
48TKECCUCO-PA: Conditional Usage of Segment-Level Characteristics8OPTIOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
49TKENC3CO-PA Realignments: Selection Criteria6OPTIOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
50TKE_DIST_BASE_CCOPA Distribution: Basic Target Credit Characteristics13OPTIOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
51TKE_DIST_SRC_CCOPA Distribution: Source Characteristics9OPTIOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
TOPPurchasing
52WDFR_DISPPerishables Planning Header79OPTIOrder Optimizingnvarchar10
53WDFR_POSPerishables Planninng Item257OPTIOrder Optimizingnvarchar10
TOPRemaining Beverage - Obsolete Objects
54/BEV3/CHCTS05Selection lines (rsdsexpr) per filter and table8OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPRetail Demand Management
55RDM_SEL_RESRestricting Selection Conditions for Distribution Chain8OPTIType of OPTION component in row type of a Ranges typenvarchar20
TOPSAP Query
56AQPROTQuery Logging14OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPSupply Chain Management
57TCM_D_IV_SELOPTIV: Selection TM Transportation Service Provider8OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPTalent Management
58T5TMCRMMOSRVALSearch Configuration Selection Criteria for Talent Monitor6OPTIOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
TOPTransaction Manager
59TEMT_FILTERFilter Values for Planning Profile5OPTIABAP: Selection option (EQ/BT/CP/...)nvarchar20