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

68 columns | Print definition?ERP 6.0  | COL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CCEE/RSFITAXConvert Tax on sales5COLDummy for B20 int1 (Local Everywhere)tinyint30
2CNV_LM_BLACKLISTCritical generation errors in DMIS components11COLColumn of a Location in Souce Codenvarchar100
3CNV_LM_WHITELISTWhitelist for generation errors in DMIS components10COLColumn of a Location in Souce Codenvarchar100
4J_3RVATDECLItem's selection criteria of VAT-Return(Declaration)5COLNumber of VAT Return Section Columnnvarchar10
5J_3RVATDECL_DTDocument types for VAT-Return Items5COLNumber of VAT Return Section Columnnvarchar10
6SCIREST_PS_BUFCode Inspector: Results Table12COLCode Inspector: Column Number for Messagenvarchar40
7SWLT_STATIC_C_DCache for static check data19COLCode Inspector: Column Number for Messagenvarchar40
8TNDCV_SCR_DEFCGeneric Screen Definition (Layout)4COLColumn for Generic Screen Definitionnvarchar10
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
9SCIREST_PSCode Inspector: Results Table12COLCode Inspector: Column Number for Messagenvarchar40
TOPBalanced Scorecard
10UMB_BU100BW Buffer (Cross-Application)8COLTechnical Name of Value Fieldnvarchar100
11UMB_BU101Local Measure Buffer7COLTechnical Name of Value Fieldnvarchar100
12UMB_GS100Value Fields2COLTechnical Name of Value Fieldnvarchar100
13UMB_GS101Value Fields: Texts3COLTechnical Name of Value Fieldnvarchar100
14UMB_MC100Scorecard: Measure Value Fields4COLTechnical Name of Value Fieldnvarchar100
15UMB_MC101Scorecard: Characteristics for the Value Fields of a Measure4COLTechnical Name of Value Fieldnvarchar100
16UMB_MC103Scorecard: Assignment of Columns to Graphics6COLTechnical Name of Value Fieldnvarchar100
17UMB_MC106Scorecard: BW Variables for the Value Fields of a Measure4COLTechnical Name of Value Fieldnvarchar100
18UMB_MC107Scorecard: BW Variables for the Value Fields of a Measure4COLTechnical Name of Value Fieldnvarchar100
19UMB_SC110Scorecard: Column Assignment3COLTechnical Name of Value Fieldnvarchar100
20UMB_SC163Scorecard: Assignment of Formula Argument to Value Fields5COLTechnical Name of Value Fieldnvarchar100
21UMB_SC193Scorecard: BW Key Figure Values of an Initiative4COLTechnical Name of Value Fieldnvarchar100
22UMB_SC194Scorecard: Characteristics for BW Key Figs of an Initiative4COLTechnical Name of Value Fieldnvarchar100
23UMB_SC195Scorecard: BW Variables for Value Fields of an Initiative4COLTechnical Name of Value Fieldnvarchar100
24UMB_SC196Scorecard: BW Variables for Value Fields of an Initiative4COLTechnical Name of Value Fieldnvarchar100
25UMB_SC199Scorecard: Assignment of Formula Argument to Value Fields5COLTechnical Name of Value Fieldnvarchar100
26UMB_SV101Scorecard View: Columns4COLTechnical Name of Value Fieldnvarchar100
TOPBusiness Object Builder
27SBMIGOTIMPBOR Object Type Implementation Components8COLint100
TOPCorporate Performance Monitor
28UMR_EX100RMS: Measure Deviations for Risks8COLTechnical Name of Value Fieldnvarchar100
29UMR_EX110RMS: Measure Targets7COLTechnical Name of Value Fieldnvarchar100
30UMR_RF100RMS: Measure-Risk Value Fields6COLTechnical Name of Value Fieldnvarchar100
31UMR_RF101RMS: Measure-Risk Value Fields Selection Criteria6COLTechnical Name of Value Fieldnvarchar100
32UMR_RF102RMS: Measure-Risk Value Fields BW Variable6COLTechnical Name of Value Fieldnvarchar100
33UMR_RF103RMS: Measure-Risk Value Fields BW Variables6COLTechnical Name of Value Fieldnvarchar100
34UMR_RI105RMS: Assignment of Value Fields for Deviations2COLTechnical Name of Value Fieldnvarchar100
35UMR_RI111RMS: Assignment of TS-Specific Deviation Value Fields4COLTechnical Name of Value Fieldnvarchar100
36UMR_RI115RMS: Measure Formula Argument Assignment7COLTechnical Name of Value Fieldnvarchar100
37UMR_RI118RMS: Measure-Risk Value Fields Read Only Flag6COLTechnical Name of Value Fieldnvarchar100
38UMR_RI128RMS: Measure Deviations for Risks8COLTechnical Name of Value Fieldnvarchar100
39UMV_TR107Value Driver Tree: Value Fields for Simulation3COLTechnical Name of Value Fieldnvarchar100
40UMV_TR108Value Driver Tree: Versions of Value Fields for Simulation3COLTechnical Name of Value Fieldnvarchar100
41UMV_TR112Obsolete: Value Driver Tree: Value Fields of a Value Driver4COLTechnical Name of Value Fieldnvarchar100
42UMV_TR113Obsolete: Value Driver Tree: Selections for the Value Fields4COLTechnical Name of Value Fieldnvarchar100
43UMV_TR116Obsolete: Value Driver Tree: BW Variables for Value Fields4COLTechnical Name of Value Fieldnvarchar100
44UMV_TR117Obsolete: Value Driver Tree: BW Variables for Value Fields4COLTechnical Name of Value Fieldnvarchar100
45UMV_TR121Value Driver Tree: Assignment of Value Fields to Graphics6COLTechnical Name of Value Fieldnvarchar100
46UMV_TR212Value Driver Tree: Value Fields or Measure4COLTechnical Name of Value Fieldnvarchar100
47UMV_TR213Value Driver Tree: Selections for the Value Fields4COLTechnical Name of Value Fieldnvarchar100
48UMV_TR216Value Driver Tree: BW Variables for Value Fields4COLTechnical Name of Value Fieldnvarchar100
49UMV_TR217Value Driver Tree: BW Variables for Value Fields4COLTechnical Name of Value Fieldnvarchar100
50UMV_TR230Value Driver Tree: Assign Value Fields to Formula Arguments5COLTechnical Name of Value Fieldnvarchar100
TOPData Transfer
51KCDEHEADFlexible Excel Upload: Header6COLFlexible Excel upload: column numbernvarchar40
TOPE-Recruiting
52T77RCF_CDCYFLDFields Available for Process1COLAvailable Columnsnvarchar300
53T77RCF_CDCYFLDTCText Table for Column Pool for Process2COLAvailable Columnsnvarchar300
54T77RCF_CDCYFLD_CColumn Pool for Process1COLAvailable Columnsnvarchar300
55T77RCF_CDCYFLD_TText Table for Field Table of Process2COLAvailable Columnsnvarchar300
56T77RCF_CDCY_LISTConfiguring Table Columns and Positions for Process3COLAvailable Columnsnvarchar300
TOPLoans Management
57VDDD_HEADER_COLLoans: Header Data - Columns Layout3COLHeader Columnnvarchar20
TOPLocalization
58J_3RFBS5_COLSSection columns of balance sheet supplement N53COLCode of Section Columnnvarchar20
59J_3RFBS5_COLTSection columns of balance sheet supplement N5 (text table)4COLCode of Section Columnnvarchar20
TOPMaterial Identification and Reconciliation
60RCDEFReconciliation: definition of movement type groups2COLColumn Numbernvarchar20
61RCDEFTReconciliation: definition of movement type groups3COLColumn Numbernvarchar20
TOPPrice Planning Workbench
62WRFT_PPW_TSHP_CTree Profile Column Attributes6COLColumntinyint30
63WRFT_PPW_TSHP_CDDefault for Tree Profile Column Attributes5COLColumntinyint30
TOPProduct Configurator
64COMM_CFGNETBLOBBLOBed Dependency Nets6COLBLOB Lengthint100
TOPRecipe
65RCPC_PP_LYT_COLColumns for Process Parameters2COLColumn for Process Parameter Datanvarchar30
66RCPC_PP_LYT_FLDFields for Process Parameters3COLColumn for Process Parameter Datanvarchar30
67RCPC_PP_LYT_TTLColumn Headings for Process Parameters2COLColumn for Process Parameter Datanvarchar30
TOPTime Sheet
68TCATX_GRIDCATX: Column Assignment for Data Entry Table4COLColumn in Entry Section of Time Sheet for Service Providerstinyint30