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

133 columns | Print definition?ERP 6.0  | VAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_10940_REPVARReports relevant for analyse variants5VARABAP: Name of variant (without program name)nvarchar140
2CNV_MBT_SWITCH_DDetailed Table for storing values from Switch Framework8VARABAP: Name of variant (without program name)nvarchar140
3T7RUPACKGRPFR Packages group5VARABAP: Name of variant (without program name)nvarchar140
4T800VRW: Variables3VARReport Writer keywordnvarchar120
TOPBalanced Scorecard
5UMB_MC101Scorecard: Characteristics for the Value Fields of a Measure10VARTechnical Name of Time Variablenvarchar100
6UMB_MC107Scorecard: BW Variables for the Value Fields of a Measure10VARTechnical Name of Time Variablenvarchar100
7UMB_SC100Scorecard: Header Table28VARTechnical Name of a CPM Variablenvarchar150
8UMB_SC107Scorecard: BIC Selections8VARVariable für Selection Conditions for BIC Documentsnvarchar100
9UMB_SC108Scorecard: Perspectives : BIC Selections9VARVariable für Selection Conditions for BIC Documentsnvarchar100
10UMB_SC113Scorecard: Perspective Assignment (Time-Dependent)8VARTechnical Name of a CPM Variablenvarchar150
11UMB_SC120Scorecard: Strategy Assignment (Time-Dependent)8VARTechnical Name of a CPM Variablenvarchar150
12UMB_SC121Scorecard: Strategy: BIC Selection9VARVariable für Selection Conditions for BIC Documentsnvarchar100
13UMB_SC150Scorecard: Objective Assignment (Time-Dependent)8VARTechnical Name of a CPM Variablenvarchar150
14UMB_SC152Scorecard: Objective: BIC Selections9VARVariable für Selection Conditions for BIC Documentsnvarchar100
15UMB_SC160Scorecard: Measure Assignment (Time-Dependent)8VARTechnical Name of a CPM Variablenvarchar150
16UMB_SC166Scorecard: Measures: BIC Selections9VARVariable für Selection Conditions for BIC Documentsnvarchar100
17UMB_SC180Scorecard: Initiatives20VARTechnical Name of a CPM Variablenvarchar150
18UMB_SC190Scorecard: Initiatives: BIC Selections9VARVariable für Selection Conditions for BIC Documentsnvarchar100
19UMB_SC194Scorecard: Characteristics for BW Key Figs of an Initiative10VARVariable für Selection Conditions for Initiativesnvarchar100
20UMB_SC196Scorecard: BW Variables for Value Fields of an Initiative10VARTechnical Name of Time Variablenvarchar100
21UMB_WIZARD102Default Settings for Each User. Used by BSC Wizard7VARTechnical Name of a CPM Variablenvarchar150
TOPBusiness Planning and Simulation
22UPB_PM_VARIABLEVariables of Planning Folders6VARVariablenvarchar80
23UPC_PROFILE_VARPlanning Profiles - Variables4VARVariablenvarchar80
24UPC_VARVariables3VARVariablenvarchar80
25UPC_VARIABLEVariables - Old Version of Database (New is UPC_VAR)3VARVariablenvarchar80
26UPC_VARIABLETVariables - Text Table4VARVariablenvarchar80
27UPC_VAR_ATTRVariables - Attributes3VARVariablenvarchar80
28UPC_VAR_CHAVariables - Characteristics3VARVariablenvarchar80
29UPC_VAR_CHADEPVariables - Selections using Hierarchies3VARVariablenvarchar80
30UPC_VAR_CHADEPAVariables - Selections using Hierarchies3VARVariablenvarchar80
31UPC_VAR_CHA_ACTVariables - Restricted Values3VARVariablenvarchar80
32UPC_VAR_CHA_SELVariables - Selections3VARVariablenvarchar80
33UPC_VAR_EXITVariables3VARVariablenvarchar80
34UPC_VAR_HIEVariables - Hierarchies3VARVariablenvarchar80
35UPC_VAR_HIE_SELVariables - Selections using Hierarchies3VARVariablenvarchar80
36UPC_VAR_HIE_SELAVariables - Selections using Hierarchies (Active Values)3VARVariablenvarchar80
37UPC_VAR_NUM_SELVariables - Numeric Selections3VARVariablenvarchar80
38UPX_VARIABLEUPX: Variable Assignment to Sales Planning3VARVariablenvarchar80
TOPCorporate Performance Monitor
39UMC_TM100Time Variable2VARTechnical Name of Time Variablenvarchar100
40UMC_TM100TTime Variable: Texts2VARTechnical Name of Time Variablenvarchar100
41UMR_RF101RMS: Measure-Risk Value Fields Selection Criteria13VARTechnical Name of Time Variablenvarchar100
42UMR_RF103RMS: Measure-Risk Value Fields BW Variables13VARTechnical Name of Time Variablenvarchar100
43UMR_RI117RMS: Measure Weight Data Selection - Selections - NOT USED10VARTechnical Name of Time Variablenvarchar100
44UMV_TR106Value Driver Tree: Responsible Person8VARTechnical Name of a CPM Variablenvarchar150
45UMV_TR113Obsolete: Value Driver Tree: Selections for the Value Fields10VARTechnical Name of Time Variablenvarchar100
46UMV_TR114Obsolete:Value Driver Tree: BIC Selections for Value Drivers9VARVariable für Selection Conditions for BIC Documentsnvarchar100
47UMV_TR117Obsolete: Value Driver Tree: BW Variables for Value Fields10VARTechnical Name of Time Variablenvarchar100
48UMV_TR213Value Driver Tree: Selections for the Value Fields10VARTechnical Name of Time Variablenvarchar100
49UMV_TR214Value Driver Tree: BIC Selections for Measures9VARVariable für Selection Conditions for BIC Documentsnvarchar100
50UMV_TR217Value Driver Tree: BW Variables for Value Fields10VARTechnical Name of Time Variablenvarchar100
51UMV_TR227Value Driver Tree: Responsible Persons for Measures9VARTechnical Name of a CPM Variablenvarchar150
TOPDirectory
52DBOBJComposition of Hybrid Objects2VARTable Namenvarchar300
53LDAPMAP2Mapping SAP Fields to LDAP Attributes - Fields5VARTable Namenvarchar300
54LDAPPROP2Proposals for Mapping SAP Fields to LDAP Attributes5VARTable Namenvarchar300
TOPIncentive and Commission Management ICM
55CACS00_B_VAR_ACTVariants for Commission Case Activities3VARVariant Namenvarchar140
56CACS00_B_VAR_BDLVariants for Bundling3VARVariant Namenvarchar140
57CACS00_B_VAR_CASVariants for Commission Case3VARVariant Namenvarchar140
58CACS00_B_VAR_INVVariants for Commission Case Participants3VARVariant Namenvarchar140
59CACS00_B_VAR_LINVariants for Alternative Commission3VARVariant Namenvarchar140
60CACS00_B_VAR_OBJVariants for Commission Case Object Data3VARVariant Namenvarchar140
61CACS00_B_VAR_PARVariants for Commission Case Participant3VARVariant Namenvarchar140
62CACS00_B_VAR_RELVariants for Participant Relations3VARVariant Namenvarchar140
63CACS_B_VARVariants for BDTI4VARVariant Namenvarchar140
64YCRM01_B_VAR_ACTVariants for Commission Case Activities3VARVariant Namenvarchar140
65YCRM01_B_VAR_BDLVariants for Bundling3VARVariant Namenvarchar140
66YCRM01_B_VAR_CASVariants for Commission Case3VARVariant Namenvarchar140
67YCRM01_B_VAR_INVVariants for Commission Case Participants3VARVariant Namenvarchar140
68YCRM01_B_VAR_LINVariants for Alternative Commission3VARVariant Namenvarchar140
69YCRM01_B_VAR_OBJVariants for Commission Case Object Data3VARVariant Namenvarchar140
70YCRM01_B_VAR_PARVariants for Commission Case Participant3VARVariant Namenvarchar140
71YCRM01_B_VAR_RELVariants for Participant Relations3VARVariant Namenvarchar140
72YHITEC_B_VAR_ACTVariants for Commission Case Activities3VARVariant Namenvarchar140
73YHITEC_B_VAR_BDLVariants for Bundling3VARVariant Namenvarchar140
74YHITEC_B_VAR_CASVariants for Commission Case3VARVariant Namenvarchar140
75YHITEC_B_VAR_INVVariants for Commission Case Participants3VARVariant Namenvarchar140
76YHITEC_B_VAR_LINVariants for Alternative Commission3VARVariant Namenvarchar140
77YHITEC_B_VAR_OBJVariants for Commission Case Object Data3VARVariant Namenvarchar140
78YHITEC_B_VAR_PARVariants for Commission Case Participant3VARVariant Namenvarchar140
79YHITEC_B_VAR_RELVariants for Participant Relations3VARVariant Namenvarchar140
80YSVMA_B_VAR_ACTVariants for Commission Case Activities3VARVariant Namenvarchar140
81YSVMA_B_VAR_BDLVariants for Bundling3VARVariant Namenvarchar140
82YSVMA_B_VAR_CASVariants for Commission Case3VARVariant Namenvarchar140
83YSVMA_B_VAR_INVVariants for Commission Case Participants3VARVariant Namenvarchar140
84YSVMA_B_VAR_LINVariants for Alternative Commission3VARVariant Namenvarchar140
85YSVMA_B_VAR_OBJVariants for Commission Case Object Data3VARVariant Namenvarchar140
86YSVMA_B_VAR_PARVariants for Commission Case Participant3VARVariant Namenvarchar140
87YSVMA_B_VAR_RELVariants for Participant Relations3VARVariant Namenvarchar140
88YTEL01_B_VAR_ACTVariants for Commission Case Activities3VARVariant Namenvarchar140
89YTEL01_B_VAR_BDLVariants for Bundling3VARVariant Namenvarchar140
90YTEL01_B_VAR_CASVariants for Commission Case3VARVariant Namenvarchar140
91YTEL01_B_VAR_INVVariants for Commission Case Participants3VARVariant Namenvarchar140
92YTEL01_B_VAR_LINVariants for Alternative Commission3VARVariant Namenvarchar140
93YTEL01_B_VAR_OBJVariants for Commission Case Object Data3VARVariant Namenvarchar140
94YTEL01_B_VAR_PARVariants for Commission Case Participant3VARVariant Namenvarchar140
95YTEL01_B_VAR_RELVariants for Participant Relations3VARVariant Namenvarchar140
96YTEL05_B_VAR_ACTVariants for Commission Case Activities3VARVariant Namenvarchar140
97YTEL05_B_VAR_BDLVariants for Bundling3VARVariant Namenvarchar140
98YTEL05_B_VAR_CASVariants for Commission Case3VARVariant Namenvarchar140
99YTEL05_B_VAR_INVVariants for Commission Case Participants3VARVariant Namenvarchar140
100YTEL05_B_VAR_LINVariants for Alternative Commission3VARVariant Namenvarchar140
101YTEL05_B_VAR_OBJVariants for Commission Case Object Data3VARVariant Namenvarchar140
102YTEL05_B_VAR_PARVariants for Commission Case Participant3VARVariant Namenvarchar140
103YTEL05_B_VAR_RELVariants for Participant Relations3VARVariant Namenvarchar140
104ZICMAG_B_VAR_ACTVariants for Commission Case Activities3VARVariant Namenvarchar140
105ZICMAG_B_VAR_BDLVariants for Bundling3VARVariant Namenvarchar140
106ZICMAG_B_VAR_CASVariants for Commission Case3VARVariant Namenvarchar140
107ZICMAG_B_VAR_INVVariants for Commission Case Participants3VARVariant Namenvarchar140
108ZICMAG_B_VAR_LINVariants for Alternative Commission3VARVariant Namenvarchar140
109ZICMAG_B_VAR_OBJVariants for Commission Case Object Data3VARVariant Namenvarchar140
110ZICMAG_B_VAR_PARVariants for Commission Case Participant3VARVariant Namenvarchar140
111ZICMAG_B_VAR_RELVariants for Participant Relations3VARVariant Namenvarchar140
TOPInformation Consistency
112SIC_NORM_ANORMRVAssignment of Variables in Attribute Normalizing Rules7VARVariable of Basic Rule Type or Conditional Rulenvarchar300
113SIC_NORM_BRTYIInterface Variables for Basic Rule Types3VARVariable of Basic Rule Typenvarchar300
114SIC_NORM_BRTYITDescriptioins for Interface Variables for Basic Rule Types3VARVariablenvarchar300
115SIC_NORM_CONDRUCVariables Assignment of Conditions3VARInterface Variable of Basic Rule Type or Condition Typenvarchar300
116SIC_NORM_CONDRUVVariables Assignment of Conditional Rules7VARInterface Variable of Basic Rule Type or Condition Typenvarchar300
117SIC_NORM_CONDTITDescriptions for Interface Variables for Condition Types3VARVariable of Condition Typenvarchar300
118SIC_NORM_CONDTYIInterface Variables for Condition Types3VARVariable of Condition Typenvarchar300
119SIC_NORM_NORMSTVAssignment of Object Attributes to Rule Variables5VARInterface Variable of Attribute Normalizing Rulenvarchar300
TOPInternet Self-Services
120UCES_CUST_ABBPUCES: Customizing for Budget Billing Plan Adjustment3VARVariant of Internet Budget Billing Adjustmentnvarchar10
TOPLocalization
121J_1BECD_HISTORYElectronic-Accounting-File History13VARVariant Register Categorynvarchar10
TOPManagement Cockpit
122UMM_FR101Frames: Dimensions10VARTechnical Name of Time Variablenvarchar100
123UMM_FR115Frame: Replacement of BW Variables9VARTechnical Name of Time Variablenvarchar100
124UMM_FR118Frame: BIC Selections8VARVariable für Selection Conditions for BIC Documentsnvarchar100
TOPMaster Data
125GMREPORTGM Report Tracking8VARReport Variantnvarchar140
TOPPayment Item
126TBKKIRCVControl of the Recipient Bank Detail Identification4VARBank Identification Variantnvarchar10
TOPPrint and Output Management
127T022DSpool: Print control translation4VARSpool: Variant for use of print control sequencesnvarchar10
TOPProfitability Analysis
128TKEPPLLEVSPlanning Level - Selection Table14VARVariable On / Offnvarchar10
129TKEPPLPPSPlanning Package - Selection Table15VARVariable On / Offnvarchar10
TOPRisk Analysis
130JBRBDSVARRM-BDS: VaR Data6VARRM Report Data Memory: Value at Riskfloat1516
TOPService Data Download
131TCUSFUBASummary table of FMs to determine system-specific data2VAR3-Byte fieldnvarchar30
TOPTour Data Entry
132/DSD/DE_FUPRECTour Data Entry Control3VARVariant for Data Transfer from RADBnvarchar140
TOPWithout Description
133IRTEST_URLVariable Replacement CR1VARParameter for URLs of Crystal Reportsnvarchar300