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

92 columns | Print definition?ERP 6.0  | STRATEGY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/I_SBD_GSSB: DM Generation Strategies2STRATEGYService Builder: Generation Strategy Namenvarchar40
2/IWBEP/I_SBD_GSTSB: DM Generation Strategy descriptions2STRATEGYService Builder: Generation Strategy Namenvarchar40
3/MRSS/D_BUND_ORIBundled Demand Original data23STRATEGYScheduling strategynvarchar100
4L2TC_RDP_PROFILERisk Distribution Plan: Profile table3STRATEGYRisk Distribution Strategynvarchar300
5LOGTRM_RDP_HDRRisk Distribution Plan: Header10STRATEGYRisk Distribution Strategynvarchar300
6SLINSEC_LOGObsolete: Internal SLINSEC Statistics (structure can change)4STRATEGYnvarchar10
7SLINSEC_LOG2Internal SLINSEC statistics. Warning: Structure can change4STRATEGYnvarchar10
TOPBalanced Scorecard
8UMB_BC_SM101Strategy Map: Strategy Assignment3STRATEGYTechnical Name of Strategynvarchar100
9UMB_BC_SM102Strategy Map: Objective Assignment2STRATEGYTechnical Name of Strategynvarchar100
10UMB_BC_ST100Strategies: Header Table (Business Content)2STRATEGYTechnical Name of Strategynvarchar100
11UMB_BC_ST101Strategies: Texts (Business Content)3STRATEGYTechnical Name of Strategynvarchar100
12UMB_SC104Scorecard: Strategy Assignment3STRATEGYTechnical Name of Strategynvarchar100
13UMB_SC120Scorecard: Strategy Assignment (Time-Dependent)3STRATEGYTechnical Name of Strategynvarchar100
14UMB_SC121Scorecard: Strategy: BIC Selection3STRATEGYTechnical Name of Strategynvarchar100
15UMB_SC122Scorecard: Strategies: Assigned BW Queries3STRATEGYTechnical Name of Strategynvarchar100
16UMB_SC140Scorecard: Objective Assignment (Time-Dependent)3STRATEGYTechnical Name of Strategynvarchar100
17UMB_SC211Scorecard: Strategy Score & A&C BDS Doc ID3STRATEGYTechnical Name of Strategynvarchar100
18UMB_ST100Strategies: Header Table2STRATEGYTechnical Name of Strategynvarchar100
19UMB_ST101Strategies: Texts3STRATEGYTechnical Name of Strategynvarchar100
TOPBasic Market Data
20/BA1/TF4_SCSECSecurity Price Scenarios6STRATEGYRead Strategynvarchar40
21/BA1/TF4_SEQUCEDefinition of Read Sequence3STRATEGYRead Strategynvarchar40
22/BA1/TF4_STRTGYDefinition of Read Strategy3STRATEGYRead Strategynvarchar40
23/BA1/TF4_STRTGYTDefinition of Price Symbols4STRATEGYRead Strategynvarchar40
TOPBasis Services Communication Interfaces
24TCSTRCommunication strategy2STRATEGYCommunication strategynvarchar40
25TCSTRPCommunication types in communication strategy2STRATEGYCommunication strategynvarchar40
26TCSTRTDescription of communication strategies3STRATEGYCommunication strategynvarchar40
TOPClaims Management
27ICL_CRBPOMASRBP-OM Assignment Strategy2STRATEGYAssignment Strategynvarchar40
28ICL_CRBPOMASEXECAssignment: RBP-OM Strategie / Strategy Class2STRATEGYAssignment Strategynvarchar40
29ICL_CRBPOMASTRBP-OM Assignment Strategy: Name3STRATEGYAssignment Strategynvarchar40
TOPCollections Management
30UDM_WL_ITEMWorklist Item9STRATEGYCollection Strategynvarchar100
TOPControlling
31QISRSCENARIOBasic Scenario Data20STRATEGYDetermination Strategy for Account Assignment Objectnvarchar30
TOPLogistics Basic Data
32CMMD_CDT1Category4STRATEGYNode Strategynvarchar200
33CMMD_CDT2Master Data Subcategory3STRATEGYNode Strategynvarchar200
34CMMD_CDT3Master Data Segment3STRATEGYNode Strategynvarchar200
35CMMD_CDT4Master Data Subsegment3STRATEGYNode Strategynvarchar200
36CMMD_CDT5Master Data Sub-Subsegment3STRATEGYNode Strategynvarchar200
37CMMD_CDT6Master Data Product Group3STRATEGYNode Strategynvarchar200
38CMMD_CDT7Master Data Brand3STRATEGYNode Strategynvarchar200
39CMMD_SKUCDT-SKU Assignment Table4STRATEGYNode Strategynvarchar200
40MATGRP_SKUArticle Assignments Table5STRATEGYNode Strategynvarchar200
41MATGRP_STRATEGYCategory Strategy2STRATEGYNode Strategynvarchar200
42MATGRP_STRATEGYTStrategy Name2STRATEGYNode Strategynvarchar200
43MATGRP_STRUCCategory Structure7STRATEGYNode Strategynvarchar200
44WRF_CMMD_CDT1Category4STRATEGYNode Strategynvarchar200
45WRF_CMMD_CDT2Subcategory3STRATEGYNode Strategynvarchar200
46WRF_CMMD_CDT3Segment3STRATEGYNode Strategynvarchar200
47WRF_CMMD_CDT4Subsegment3STRATEGYNode Strategynvarchar200
48WRF_CMMD_CDT5Sub-Subsegment3STRATEGYNode Strategynvarchar200
49WRF_CMMD_CDT6Product Group3STRATEGYNode Strategynvarchar200
50WRF_CMMD_CDT7Brand3STRATEGYNode Strategynvarchar200
51WRF_CMMD_SKUCDT-SKU Assignment Table4STRATEGYNode Strategynvarchar200
52WRF_MATGRP_MD1Hierarchy Level 1 - Time-Dependent7STRATEGYNode Strategynvarchar200
53WRF_MATGRP_MD10Hierarchy Level 10 - Time-Dependent7STRATEGYNode Strategynvarchar200
54WRF_MATGRP_MD2Hierarchy Level 2 - Time-Dependent7STRATEGYNode Strategynvarchar200
55WRF_MATGRP_MD3Hierarchy Level 3 - Time-Dependent7STRATEGYNode Strategynvarchar200
56WRF_MATGRP_MD4Hierarchy Level 4 - Time-Dependent7STRATEGYNode Strategynvarchar200
57WRF_MATGRP_MD5Hierarchy Level 5 - Time-Dependent7STRATEGYNode Strategynvarchar200
58WRF_MATGRP_MD6Hierarchy Level 6 - Time-Dependent7STRATEGYNode Strategynvarchar200
59WRF_MATGRP_MD7Hierarchy Level 7 - Time-Dependent7STRATEGYNode Strategynvarchar200
60WRF_MATGRP_MD8Hierarchy Level 8 - Time-Dependent7STRATEGYNode Strategynvarchar200
61WRF_MATGRP_MD9Hierarchy Level 9 - Time-Dependent7STRATEGYNode Strategynvarchar200
62WRF_MATGRP_PRODHierarchy-Product Assignment Table7STRATEGYNode Strategynvarchar200
63WRF_MATGRP_SKUArticle Assignments Table8STRATEGYNode Strategynvarchar200
64WRF_MATGRP_STRACategory Strategy2STRATEGYNode Strategynvarchar200
65WRF_MATGRP_STRATStrategy Name2STRATEGYNode Strategynvarchar200
66WRF_MATGRP_STRUCCategory Structure10STRATEGYNode Strategynvarchar200
TOPMaintenance Orders
67/MRSS/C_RSG_STEUMultiresource Planning Control Keys4STRATEGYScheduling Strategynvarchar100
68/MRSS/D_DEM_PLRData required for planning-relevant items23STRATEGYScheduling strategynvarchar100
TOPMerchandise and Assortment Planning
69S214CatMan: Indizees für ROP30STRATEGYKnooppuntstrategienvarchar200
70S214BIW1S214BIW1 * CatMan: Indexes for Space Management Program30STRATEGYNode Strategynvarchar200
71S214BIW2S214BIW2 * CatMan: Indexes for Space Management Program30STRATEGYNode Strategynvarchar200
TOPObject Links
72OLR3_TABLEDEFR/3 Object + Action <-> Table/View in ERP System4STRATEGYStrategynvarchar20
73OLR3_TABLEDF_TExplanitory Text for Strategy in OLR3_TABLEDEF5STRATEGYStrategynvarchar20
TOPOutput Determination
74T685BCondition Types: Additional Data for Sending Output38STRATEGYCommunication strategynvarchar40
TOPPosition Budgeting and Control
75T77HRFPM_DERFILDerivation Strategy for Filter Determination for Check Rules2STRATEGYDerivation Strategy for Filter Valuesnvarchar100
76T77HRFPM_DERFILTFilter Values for BAdI for Staff Asignment Rules: Texts3STRATEGYDerivation Strategy for Filter Valuesnvarchar100
TOPPost Processing Framework
77PPFTCSTRCommunication strategy2STRATEGYCommunication strategynvarchar40
78PPFTTCSTRPCommunication types in communication strategy2STRATEGYCommunication strategynvarchar40
79PPFTTCSTRTDescription of communication strategies3STRATEGYCommunication strategynvarchar40
TOPProfitability Analysis
80TKEPPLSZPlanning Scenarios: Derivation Parameters4STRATEGYStrategy IDnvarchar40
TOPRemaining Beverage - Obsolete Objects
81/BEV3/CHCBDGSTRTCustomizing: Condition Strategy Formula ID Texts3STRATEGYCondition Strategy IDnvarchar40
82/BEV3/CHCTBDGSTFCustomizing: Condition Strategy Formula2STRATEGYCondition Strategy IDnvarchar40
83/BEV3/CHCTBDGSTRCustomizing Condition Strategy Formula ID2STRATEGYCondition Strategy IDnvarchar40
84/BEV3/CHRGSTRATCondition Rule10STRATEGYCondition Strategy IDnvarchar40
TOPSoftware Agent Framework
85CRMC_SAF_APP_ISSAF: Links between application and information security4STRATEGYSAF: Information security strategynvarchar100
TOPUpgrade Tools
86CRRPARATESTTest table for CRR parallelisation test11STRATEGYCRR task error handling strategynvarchar10
87CRRTASKINFOCRR task information11STRATEGYCRR task error handling strategynvarchar10
88DDCSTATDD: Statistics table for conversions8STRATEGYABAP: Name of variant (without program name)nvarchar140
TOPWorkforce Management Core
89WFDC_PLGS_SEQ_LCLRP Strategy: Sequence of Planning Steps for LC3STRATEGYEXternal key for scheduling startegynvarchar100
90WFDC_STRGScheduling Strategy3STRATEGYEXternal key for scheduling startegynvarchar100
91WFDC_STRG_LCLRP Strategies Supported by the LC Dispatcher3STRATEGYEXternal key for scheduling startegynvarchar100
92WFDC_STRG_TScheduling Strategy Text3STRATEGYEXternal key for scheduling startegynvarchar100