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

46 columns | Print definition?ERP 6.0  | WEIGHT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_MKTGDUPMarketing Attributes For Use During Duplicate Check3WEIGHTMatch Weighttinyint30
2/SAPQUERY/TA04Plane8WEIGHTWeight of planedecimal144
3EHPRCD_DEC_INObsolete23WEIGHTMean Weight of Declarable Substancedecimal177
4FAGL_011CC_XBRLF/S Version: Calculation Rule for F/S Items9WEIGHTWeighting Factor for XBRL Calculation Proceduredecimal63
TOPABAP Workbench, Java IDE and Infrastructure
5SAPLANEPlane8WEIGHTWeight of planedecimal144
TOPAnalyzer
6AFWBM_COMP_RELTRM: Relationships within a Composite Benchmark4WEIGHTWeighting in Percentagedecimal105
TOPBalanced Scorecard
7UMB_CM101Performance Overview: Item6WEIGHTWeight of an Element Within a Scorecarddecimal163
8UMB_SC170Scorecard: Weights for Status Calculation9WEIGHTWeightdecimal163
TOPBasic Data
9VIBDCHARACTFixtures/Fittings6WEIGHTNo. of Points That Fixt/Fitting Characteristic Weighted Withdecimal72
TOPBusiness Planning and Simulation
10UPX_STATUSUPX: Permitted Statuses3WEIGHTUPX: Weight of Status Key Figureint100
TOPBW Service API
11ROVERTYPEATest Type in Verification Scenario6WEIGHTWeight in Verification Scenariodecimal173
TOPClaims Management
12TICL121Weighting, Prioritization of Evaluation Criteria4WEIGHTWeighting of Evaluation Criteriondecimal52
TOPClinical System
13N1MEEVENTIS-H*MED: Medication, Medication Event37WEIGHTMedication: Order - Weight for Calculation - OBSOLETEdecimal73
14TN1MEUNITIS-H*MED: Medication - Units for Orders5WEIGHTMedication: Weight Unit Indicatornvarchar10
TOPCross-Application Components
15SCARGOManagement of freight orders (demo for BC430)11WEIGHTWeight of freightdecimal102
TOPData Mining
16RSDMTC_MEAN_DTLMean Detail5WEIGHTCumulative Weightsdecimal197
17RSDMTD_ATTRFREQClass Frequency of Learnt Data6WEIGHTCumulative Weightsdecimal197
18RSDMTD_ATTRVALAttribute Value List6WEIGHTIndividual Weightsdecimal117
19RSDMTD_CLASSFREQClass Frequency of Learnt Data7WEIGHTCumulative Weightsdecimal197
20RSDMTD_NODE_DISTNode Class Distribution6WEIGHTCumulative Weightsdecimal197
21RSDMTD_TREEHDRTree Header6WEIGHTIndividual Weightsdecimal117
22RSDMTD_TREESTRUCNode Structure15WEIGHTCumulative Weightsdecimal197
23RSDMTPN_COL_VALModel Column Values6WEIGHTIndividual Weightsdecimal117
24RSDMTP_COL_VALModel Column Values5WEIGHTIndividual Weightsdecimal117
TOPEnvironment, Health and Safety
25/TDAG/CPT_DECSUBCP: Declarable Substances24WEIGHTMean Weight of Declarable Substancedecimal177
26/TDAG/CPT_DEC_INCP: Declarable Substances, Independent attributes23WEIGHTMean Weight of Declarable Substancedecimal177
TOPIncentive and Commission Management ICM
27TCACS_TGATgt Agrmts: Assign Elementary to Complex Target Types7WEIGHTTarget Agreements: Weightingdecimal85
TOPIndustrial Hygiene and Safety
28CCIHT_ANSEEHS: Analysis Method - Summated Rating (Details)51WEIGHTWeightingdecimal31
TOPInformation Consistency
29SIC_FM_NODE_FLDSFine Match Profiles for node fields7WEIGHTWeight of Field in Fine Matchingdecimal32
30SIC_FM_NODE_STRCFine Match Profiles for node fields5WEIGHTWeight of Node in Fine Matchdecimal32
TOPKANBAN
31TPKRQDISVerteilung von Bedarfsmengen bei der Kanbanberechnung6WEIGHTGewichtung der Bedarfsanteiledecimal30
TOPMedia Product Sales and Distribution
32JKSDFCITEMIS-M: Media Issue Item Data10WEIGHTIS-M: Weighting of Sales Figuresint100
33JKSDFCITEMPOIS-M: Media Issue Item Data with Planning Organization11WEIGHTIS-M: Weighting of Sales Figuresint100
34JKSDISSFORECITEMIS-M: Media Issue Item Data9WEIGHTIS-M: Weighting of Sales Figuresint100
TOPPortfolio Analyzer
35BMA_BMBMOLD CFM Benchmarking: Benchmark Relationships6WEIGHTOLD CFM. Weighting of a Sub-Benchmarkdecimal105
TOPPrint and Output Management
36TFRT_INFOTypeface Repo - Font Info16WEIGHTFont Weightint100
37TFRT_SRCH_KEYTypeface Repo - Table of Font key for search16WEIGHTFont Weightint100
TOPProduct Configurator
38COMM_CFGSTATUSStatus of a Model Element3WEIGHTStatus namenvarchar300
TOPRemote Logistics Management
39OIO_C1_CNTNRRLM Oil and gas container master data22WEIGHTContainer tare weightdecimal133
TOPSAP NetWeaver Mobile - Use subcomponents
40MEREP_PERSONPerson (Sample Application)8WEIGHTWeight (Sample Application)decimal52
TOPText Retrieval and Information Extraction
41SRETPROFDDocuments/Keywords/Rules on Preference Profiles5WEIGHTint100
TOPTraining Management
42HRP1883DB Table for Infotype 188322WEIGHTWeightingdecimal40
43HRP1884DB Table for Infotype 188422WEIGHTWeightingdecimal40
TOPTransaction Management
44FTR_AVG_SCHEDULESchedule with Rates7WEIGHTWeightingdecimal139
TOPTransport Organizer
45VRSSC_CTGRSField Categories for System Comparison3WEIGHTNatural Numberint100
TOPWithout Description
46RSDMA_DBT_WEIGHTDB: Weights4WEIGHT(Partial) Scorenvarchar600