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

176 columns | Print definition?ERP 6.0  | OPERATOR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_ACCHECKCheck assignment16OPERATOROperatornvarchar20
2/AIF/T_ACCHECKVCheck assignment18OPERATOROperatornvarchar20
3/AIF/T_FMAPField mapping35OPERATOROperatornvarchar20
4/AIF/T_FMAPCONDField condition mapping34OPERATOROperatornvarchar20
5/AIF/T_FMAPCONDVField condition mapping variant37OPERATOROperatornvarchar20
6/AIF/T_FMAPVField mapping (obsolete)38OPERATOROperatornvarchar20
7/AIF/T_IFCHECKCheck assignment19OPERATOROperatornvarchar20
8/AIF/T_IFCHECKVCheck assignment21OPERATOROperatornvarchar20
9/AIF/T_IFDETVALValues for Interface Determination4OPERATOROperatornvarchar20
10/AIF/T_INFDET_VLValues for Interface Determination8OPERATOROperatornvarchar20
11/AIF/T_INTRECDestination record type for interface7OPERATOROperatornvarchar20
12/AIF/T_SM_FMAPVField mapping condition38OPERATOROperatornvarchar20
13/AIF/T_STRMAPVSelect & Add Structure Mapping10OPERATOROperatornvarchar20
14/AIF/T_TABCHKSingle Check7OPERATOROperatornvarchar20
15/AIF/T_TABCHKVSingle Check9OPERATOROperatornvarchar20
16/AIF/T_TABFLDTable Check Fields6OPERATOROperatornvarchar20
17/AIF/T_TABFLDVTable Check Fields8OPERATOROperatornvarchar20
18/IAM/C_DATSCATLTraffic Lights in Date Schema for Activity7OPERATOROperator for Traffic Light Conditionnvarchar80
19/IAM/C_DATSCITLTraffic Lights in Date Schema for Issue6OPERATOROperator for Traffic Light Conditionnvarchar80
20BBPC_IMSTREX_ECustomizing Table for Duplicate Invoice's Search Criteria4OPERATOROperator Comparisonnvarchar30
21CNV_10020_ACTOCActions for offset determination via value search15OPERATORRelational operatornvarchar20
22CNV_10020_CONDDDConditions for comparison of determination and determ.14OPERATORRelational operatornvarchar20
23CNV_10020_CONDDVConditions for comparison of determation and values14OPERATORRelational operator for determinationnvarchar20
24CNV_10020_CONDFDConditions for comparison of field and determination8OPERATORRelational operatornvarchar20
25CNV_10020_CONDFFConditions for comparison of field and field8OPERATORRelational operatornvarchar20
26CNV_10020_CONDFVConditions for comparison of field and values8OPERATORRelational operatornvarchar20
27CNV_20551_TSTRU2Intransparent fields: Condition for structure description4OPERATOROperatornvarchar30
28CNV_INTR_FLD_STPIntransparent fields: Condition for structure description4OPERATOROperatornvarchar30
29CONDITION_TABLECondition Table6OPERATOR3-Byte fieldnvarchar30
30DD05BDD: Associations for Structured Objects: Fields11OPERATOROperator in a Join Conditionnvarchar20
31DD05FDD: Associations Filter Info for Structured Objects7OPERATOROperator in a Join Conditionnvarchar20
32DMC_ACCESS_PLANDMC: WHERE clauses of an access plan6OPERATORDMC: Logical Operatornvarchar40
33EHHSSC_HSP_AGEHealth Surveillance Protocol Age Criteria3OPERATOROperator for HS Protocol Age Criterianvarchar20
34ESH_HDB_CONSTRConstraints for Application-Table Based Connector Nodes9OPERATOROperatornvarchar20
35GHO_RULE_DETAILGeneric Rule9OPERATORRule Optionnvarchar20
36IDREPFW_CRCCL_CRep.Framework: Cross Check Rule Side Cell Identification10OPERATOROperator in Case of More Valuesnvarchar10
37J_3RFDI_ARCTable for archiving and logging digital invoices30OPERATOROperator of Company Codenvarchar100
38J_3RF_DI_CCOPAssign Electronic ID to Company Code (new)3OPERATOROperator of Company Codenvarchar100
39J_3RF_RGTORG_IFSIndex Electronic Documents File Storage15OPERATOROperator of Company Codenvarchar100
40PIVB_CATALOGReport Catalog Definition2OPERATOROperatornvarchar20
41RSCNVCRITSelections for RSCURRCONV4OPERATOROperator in Select Options and other Expressionsnvarchar20
42SCI_DD28SZeilen einer Selektionsbedingung8OPERATOROperator in einer Join- Bedingungnvarchar20
43T5ITUI_2User Data Table for Report / Legal Form10OPERATORValue operator of a report/legal formnvarchar10
44T77PAODYCONDConditions9OPERATORConditionnvarchar100
45T7CNRMP_DETITMDetermining Factor Item16OPERATORComparison Operatornvarchar20
46T7CNRM_DECITMDetermining Factor Item8OPERATOROperator in Determining Factornvarchar20
47T7CNRM_DECSETDecision Factor SET - OBSOLETE8OPERATOROperator in Determining Factornvarchar20
48ZPPMC_CPL_C_CHCKDefine WBS Element Attribute Checks4OPERATORComparison Operatornvarchar30
TOPAccrual Engine
49TACEDS_OPASGMTAssignment of Operator to Function Module2OPERATOROperator for Derived Accrual Typesnvarchar20
50TACEDS_OPERATROperators for Derived Accrual Types2OPERATOROperator for Derived Accrual Typesnvarchar20
51TACEDS_OPERATRTTexts for Operators for Derived Accrual Types2OPERATOROperator for Derived Accrual Typesnvarchar20
52TACE_ACRTYPE_OPNCalculation Rules for Derived Accrual Types6OPERATOROperator for Derived Accrual Typesnvarchar20
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
53DD28SLines of a selection condition8OPERATOROperator in a Join Conditionnvarchar20
TOPActivity-Based Costing
54COTPLFCCO-OM-ABC: Process Template Control Blocks (TYPE TPLIC_BCB)14OPERATOROperatornvarchar20
TOPAnalysis Process Designer
55RSANT_PRP_TREXFAPD Provider Runtime - TREX Static Filters8OPERATOROperator (EQ, BT, ...)nvarchar20
TOPBRFplus - ABAP-Based Business Rules
56FDT_EXPR_1910FDT/BRF: Expression - Select for table request9OPERATORFDT/BRF: Value request table select operationsnvarchar20
57FDT_EXPR_1910AFDT/BRF: Expression - Select for table request9OPERATORFDT/BRF: Value request table select operationsnvarchar20
58FDT_EXPR_1910SFDT/BRF: Expression - Select for table request8OPERATORFDT/BRF: Value request table select operationsnvarchar20
59FDT_EXPR_1910TFDT/BRF: Expression - Select for table request8OPERATORFDT/BRF: Value request table select operationsnvarchar20
TOPBudgeting
60BUCC_RULEConsistency Checks - Rules21OPERATORConsistency Checks - Comparison operatornvarchar20
TOPBusiness Application Support
61CNV_00001_PARAMSParameter table8OPERATORSingle-Character Indicatornvarchar10
TOPBusiness Configuration Tools Runtime
62SC2_IPG_QUERYC2: Inactive Generaed Proxy Method7OPERATORRelational operator in search querynvarchar20
63SC2_PG_QUERYC2 Server: Generated Proxy Method Range Table for Query7OPERATORRelational operator in search querynvarchar20
TOPBusiness Consolidation
64UCT8010Mapping Rule: Row Content4OPERATORMapping Operatornvarchar40
TOPBusiness Planning and Simulation
65UPX_KFS_CKFKey Figure Schemes for Planning Layouts: Calculated Key Figs5OPERATORPermitted Calculation Operations for Key Figure Schemesnvarchar20
TOPBusiness Rule Framework
66FDT_EXPR_1960FDT/BRF: Expression - Select for table request9OPERATORFDT/BRF: Value Request Table Select Operationsnvarchar20
67FDT_EXPR_1960AFDT/BRF: Expression - Select for table request9OPERATORFDT/BRF: Value Request Table Select Operationsnvarchar20
68FDT_EXPR_1960SFDT/BRF: Expression - Select for table request8OPERATORFDT/BRF: Value Request Table Select Operationsnvarchar20
69FDT_EXPR_1960TFDT/BRF: Expression - Select for table request8OPERATORFDT/BRF: Value Request Table Select Operationsnvarchar20
70TBRF142BRF: Value Request from Structures and Internal Tables12OPERATOROperator, Generalnvarchar80
71TBRF190BRF: Operators2OPERATOROperator, Generalnvarchar80
72TBRF190TBRF: Operators, Texts3OPERATOROperator, Generalnvarchar80
73TBRF191Obsolete - BRF: Operators and Result Types4OPERATOROperator, Generalnvarchar80
74TBRF192BRF: Operators and Result Types - Successor of TBRF1913OPERATOROperator, Generalnvarchar80
75TBRF193BRF: Operators1OPERATOROperator, Generalnvarchar80
76TBRF193TBRF: Operators, Texts2OPERATOROperator, Generalnvarchar80
TOPClinical System
77N2DSERIESIS-H*MED RAD: Description of a DICOM image series10OPERATORExecutor of the examinationnvarchar100
78N2DWORKLISTIS-H*MED RAD: Work list (RIS - PACS work list)6OPERATORExecutor of the examinationnvarchar100
TOPConsolidation
79TF375Validation Steps: Node Structure9OPERATORComparison operator for validationsnvarchar20
TOPCountry-Specific Objects
80DMEE_CHECKS_ABADMEE: Checks14OPERATORDMEE: logical operatornvarchar20
81DMEE_COND_ABADMEE: Format Tree Node Conditions22OPERATORDMEE: logical operatornvarchar20
TOPCross-Application Components
82MPO_CCMON_RULESCost Center Monitor: Rule Definition for Exception Reporting10OPERATORCharacter Field Length 1nvarchar10
TOPCross-System Tools
83SCDTLKEYLocked Objects - Key9OPERATOROperator in Filter Conditionnvarchar20
84SCDTOBJSELCross-System Customizing Object9OPERATOROperator in Filter Conditionnvarchar20
TOPData Collection
85MCCMFOTax table, Copy Management formulas6OPERATOROperator for definition of a computing stepnvarchar10
TOPData Mining
86RSDMTD_RULESDTLRules Details8OPERATORNode Operatornvarchar20
87RSDMTD_TREESTRUCNode Structure9OPERATORNode Operatornvarchar20
TOPDatabase Interface, Database Platforms
88DB6ALRTCFGDB6: Alert Configuration Data8OPERATORnvarchar20
TOPDB2 for OS39
89DBCHECKDB2Configuration of DB2/390 System Check Parameters15OPERATORDB2 for OS/390: check operator (system check)nvarchar20
90DBMSGDB2DB2/390 System Check Messages10OPERATORDB2 for OS/390: check operator (system check)nvarchar20
TOPE-Recruiting
91T77RCF_SM_ELEMAttributes of Search Template Elements11OPERATORType of Operator Listnvarchar40
92T77RCF_SRCH_ATTCSet Up Attributes for Flexible Search Applications17OPERATORLogical Operator Between Two Arguments of Attribute Searchnvarchar30
93T77RCF_SRCH_ATTRSet Up Attributes for Flexible Search Applications16OPERATORLogical Operator Between Two Arguments of Attribute Searchnvarchar30
TOPEnd User Technology
94RSZOPRATORFormula Operators1OPERATOROperatornvarchar50
95RSZOPRATXTTexts of the formula operators2OPERATOROperatornvarchar50
TOPEnterprise Search Integration
96WCFD_ES_BOL_QPARAssign parameters to BOL extraction query8OPERATORSelection operator OPTION for range tablesnvarchar20
TOPEvent Management
97/SAPTRX/EXT_FLDSExtraction fields11OPERATOROperatornvarchar20
TOPFast Search Infrastructure
98SFSG_Q_CONDQuery Condition8OPERATOROperatornvarchar20
TOPFunds Management
99FMFGRCNFACTORReconciliation: Factors in a reconciliation rule5OPERATORReconciliation: operator (plus or minus)nvarchar10
TOPGeneral Application Functions
100SDMONITRESThreashold Values for Key Figures of the SD Applic. Monitor4OPERATORSD Monitor: <ratio value> <operator> <threshold value>nvarchar20
101TABADRSFCharacteristic Derivation: Steps, Fields24OPERATOROperatornvarchar30
TOPGRC Access Control Plug-In
102/VIRSA/RULEATTRHR Triggers - Rule Attributes6OPERATORR/2 tablenvarchar50
103/VIRSA/RULEATTRNHR Triggers - Rule Attributes6OPERATORR/2 tablenvarchar50
TOPHR Information Systems
104HRSEL_COMBINERelationship of Selection IDs6OPERATORRelationship for Selectionsnvarchar10
TOPInterfaces
105VXSIGExpress Delivery Company: Weight Codes4OPERATORWeight operatornvarchar20
TOPItaly
106T5ITCO2Italy: Transferring wage types - Processing14OPERATOROperator for definition of a Computing Stepnvarchar10
107T5ITUAUser Data Table of the Company for Report/ Legal Form11OPERATORValue operator of a report/legal formnvarchar10
108T5ITUIUser Data Table for Report / Legal Form9OPERATORValue operator of a report/legal formnvarchar10
TOPJoint Venture und Production Sharing Accounting
109PSAHDPSA Document Header23OPERATORContractor (operator)nvarchar100
110T8JOH_COMPLEX_FTable of Complex Formulas in Overhead Organizer6OPERATORMathematical Operator to calculate Complex Overheadnvarchar10
111T8JVJoint Venture7OPERATOROperator for Non-Operated Venturenvarchar100
112T8PSA_PSCPSC Master21OPERATORContractor (operator)nvarchar100
TOPLocalization
113DMEE_TREE_CHECKSDMEE: Checks14OPERATORDMEE: logical operatornvarchar20
114DMEE_TREE_CONDDMEE: Format Object - & Mapping Conditions22OPERATORDMEE: logical operatornvarchar20
115ISJPBKCHARGEBank charges5OPERATOROperatornvarchar20
TOPMaintenance Program Definition
116MPDCYCLEMPD: Cycle Data for Maintenance Document Items26OPERATORComparison operator for maint. package cycle durationnvarchar20
TOPMaintenance Task Lists
117MMPTCycle definitions and MeasPoints for MaintPlan4OPERATORComparison operator for maint. package cycle durationnvarchar20
TOPMaterial Master
118WER_EXP_BOOL_ATable of boolean expressions - OBSOLETE6OPERATORDisplay of operator in Boolean Expression Viewnvarchar20
119WER_EXP_BOOL_STable of boolean expressions - OBSOLETE5OPERATORDisplay of operator in Boolean Expression Viewnvarchar20
120WER_EXP_COMP_ATable of comparison expressions5OPERATORDisplay of operator in Boolean Expression Viewnvarchar20
121WER_EXP_COMP_STable of comparison expressions4OPERATORDisplay of operator in Boolean Expression Viewnvarchar20
TOPMDG for Financials
122USMDZ5105Selection rules4OPERATOROperatornvarchar20
TOPMedia Product Sales and Distribution
123TJKSDSALESQUANRDefinition of Sales Indicator4OPERATOROperatornvarchar20
TOPMetadata Repository
124RSOS_ES_OBJ_AUTHAuthorization objects for object type6OPERATOROperator in authorizationnvarchar50
TOPNetWeaver Enterprise Search
125ESH_OM_AOTYPNCCLObject Types: Nodes: Logical Conjunctions of Auth. Checks8OPERATORBoolean Operatornvarchar10
126ESH_OM_COTYPNCCLObject Types: Nodes: Logical Conjunctions of Auth. Checks8OPERATORBoolean Operatornvarchar10
127ESH_OM_IOTYPNCCLObject Types: Nodes: Logical Conjunctions of Auth. Checks8OPERATORBoolean Operatornvarchar10
TOPNetwork Objects
128GHO_IFLOT_EXTFunction location extension table110OPERATOROil and Gas Entity Operatornvarchar400
TOPProduct Configurator
129COMM_CFGCLACOMCompiled Code for Classic Dependencies7OPERATORTerm Operatorint100
130COMM_CFGDEPCOMCompiled Code for Dependency Nets8OPERATORTerm Operatorint100
TOPProduct Safety
131TCGRULOPEHS: Expert Operators1OPERATOROperatornvarchar100
132TCGRULOPNAEHS: Multilingual Description for Operators1OPERATOROperatornvarchar100
133TCGRULPOSIDCHGEHS: Easy Expert Set of Rules, Ident. Changes8OPERATOROperatornvarchar100
134TCGRULPOSMCHANGEEHS: Easy Expert Set of Rules, Changes to Characteristics8OPERATOROperatornvarchar100
TOPProduction and Revenue Accounting
135OIUCM_T8JVPRA Joint Venture Master Data7OPERATOROperator for Non-Operated Venturenvarchar100
136OIUX2_PUIDLOGTax Reporting PUID log9OPERATOROperatornvarchar100
137OIUX2_RE_LOGTax Reporting log table for the Log14OPERATOROperatornvarchar100
138OIU_DO_DPSEVTDOI Accounting Severance Tax Types Table26OPERATOROperatornvarchar100
139OIU_PR_WCVDWell Completion Variable Data15OPERATOROperatornvarchar100
TOPProduction Network
140GHO_PRDENTY_TYPETable for Holding Oil and Gas Entity5OPERATOROil and Gas Entity Operatornvarchar400
TOPProfitability Analysis
141TKEDRSFCharacteristic Derivation: Steps, Fields24OPERATOROperatornvarchar30
TOPProject Risk Management for Contractors
142/SAPPCE/JVA_T8JVE&C table for JVA master data7OPERATOROperatornvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
143TFMCA_BRF236BRF: Check Rules for Form Fields9OPERATORComparison Operatornvarchar20
TOPRegulatory reporting for insurance companies
144ISSR_MACVRUISSR: Converter Tabelle für indirekt zuzuweisende Felder7OPERATORISSR: Operator für die abgeleitete Feldzuweisungnvarchar80
145ISSR_MACVTAISSR: Converter Bedingungen für Ableitungen über U-tab5OPERATORISSR: Operator für Selektion auf Umsetzungstabellennvarchar80
TOPRemaining Beverage - Obsolete Objects
146/BEV3/CHCBPO700KInformation for Evaluating Link Type 0700 - Processing6OPERATORArithmetic Operatorsnvarchar10
147/BEV3/CHCBPO700VBPOs for Link Type 0700: Processing Info for Components7OPERATORArithmetic Operatorsnvarchar10
TOPRisk Analysis
148AFWCH_DRSF_SAMPSample Customizing for Derivation (Fields for Steps)22OPERATOROperatornvarchar30
TOPRoyalty Reporting
149OIUREP_AGY_LSEAgency assigned Leases20OPERATOROperatornvarchar100
TOPSales and Distribution
150SCECLACOMCompilation for Classic Dependencies6OPERATORNatural numberint100
151SCEDEPCOMCompilation of Dependency Nets7OPERATORNatural numberint100
TOPSAP Business Workflow
152SWFRLSOPERSystem Table: Standard Comparison Operators1OPERATORRelational Operatornvarchar40
TOPService Data Download
153/SDF/DB6ALRTCFGDB2 UDB: Alert Configuration Data7OPERATORnvarchar20
TOPTable Maintenance Tool
154SDMEDPSCDME: Dialog Pool Component 'Selection' (Conditions)7OPERATORDME: Operatornvarchar20
155TVIMVextended table maintenance: Selection variants6OPERATOROperator in a Join Conditionnvarchar20
TOPTag Library
156CRMC_THTMLB_OPList of range operators1OPERATORSearch criterion operatornvarchar20
157CRMC_THTMLB_OPTText table for range operators1OPERATORSearch criterion operatornvarchar20
TOPTax Reporting
158OIUX1_MAS_REBReporting entities base table11OPERATOROperatornvarchar100
159OIUX1_PRD_UIDBBase table for Production Units/Leases6OPERATOROperatornvarchar100
160OIUX1_PROD_UNITProduction Units/Leases4OPERATOROperatornvarchar100
161OIUX6_WY_COOSHSTTax 2.0 - Wyoming Out Of Statute Conservation Trans Hist53OPERATORMaster Recordnvarchar100
162OIUX6_WY_COOSTXNTax 2.0 - Wyoming Out Of Statute Conservation Transactions53OPERATORMaster Recordnvarchar100
163OIUX6_WY_CPRDTTax 2.0 - Wyoming Conservation Tax PRA Detail Transactions55OPERATORMaster Recordnvarchar100
164OIUX6_WY_CTAXHSTTax 2.0 - Wyoming Conservation Tax Transactions History53OPERATORMaster Recordnvarchar100
165OIUX6_WY_CTAXSTGTax 2.0 - Wyoming Conservation Tax Transactions Staging53OPERATORMaster Recordnvarchar100
166OIUX6_WY_CTAXTXNTax 2.0 - Wyoming Conservation Tax Transactions53OPERATORMaster Recordnvarchar100
167OIUX7_WY_GSALESTax 2.0 - WYGP Sales23OPERATORMaster Recordnvarchar100
168OIUX7_WY_GSALHSTTax 2.0 - WYGP Sales History22OPERATORMaster Recordnvarchar100
169OIUX7_WY_GSALTXNTax 2.0 - WYGP Sales22OPERATORMaster Recordnvarchar100
TOPTraders and Schedulers Workbench
170TOI0_CP_GRATRAssign Compatibility group with compatibility attributes4OPERATORCompatibility Operatornvarchar100
171TOI0_CP_OPStore Compatibility operators2OPERATORCompatibility Operatornvarchar100
172TOI0_CP_OPTText Table Compatibility operators3OPERATORCompatibility Operatornvarchar100
TOPTransaction Data Pool
173JBDEXPRELPOSItem Table for Export Relevance6OPERATORSelection operator OPTION for range tablesnvarchar20
TOPUpgrade Tools
174CRR_ACCESS_PLANPackage delimitation for initial transfer5OPERATORnvarchar20
TOPValuation
175OIURV_DO_DPSEVTDOI Accounting Severance Tax Types Table8OPERATOROperatornvarchar100
TOPWork Clearance Management
176WCAHEWCM: Work Clearance Document (Header)74OPERATOROperator for Operation Ticketnvarchar100