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

59 columns | Print definition?ERP 6.0  | STXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1SFTT_EQUITEquipment Operating Statuses4STXTOperating Status Descriptionnvarchar300
2TTS_QUALTPersonnel qualification in TTS(Texts)4STXTDescriptive Short Textnvarchar400
3TTS_WCCSTTTS: Selection Fields for Data Transfer (Texts)4STXTDescriptive Short Textnvarchar400
TOPBalanced Scorecard
4UMB_BC_OB101Strategy Elements: Texts (Business Content)6STXTShort textnvarchar150
5UMB_BC_PE101Perspectives: Texts (Business Content)6STXTShort textnvarchar150
6UMB_BC_ST101Strategies: Texts (Business Content)6STXTShort textnvarchar150
7UMB_CI101General Initiatives: Texts6STXTShort textnvarchar150
8UMB_CO101General Objectives: Texts6STXTShort textnvarchar150
9UMB_CO103General Objectives: Measure Label Text7STXTShort textnvarchar150
10UMB_GS101Value Fields: Texts6STXTShort textnvarchar150
11UMB_GS105TStatus: Texts4STXTShort textnvarchar150
12UMB_HI101Scorecard Hierarchy: Texts6STXTShort textnvarchar150
13UMB_OB101Objectives: Texts6STXTShort textnvarchar150
14UMB_PE101Perspectives : Texts6STXTShort textnvarchar150
15UMB_SC101Scorecard: Texts6STXTShort textnvarchar150
16UMB_SC181Scorecard: Texts for Initiatives7STXTShort textnvarchar150
17UMB_ST101Strategies: Texts6STXTShort textnvarchar150
TOPClinical System
18N1MEDS_DS01TMedication: Text Table for Alternate Names for Search Fields4STXTMedication: Character for Search Fieldsnvarchar10
TOPCorporate Performance Monitor
19UMC_GS120TAssignment of Formula Result: Texts6STXTShort textnvarchar150
20UMR_RI000TRisk: Category Text Table6STXTShort textnvarchar150
21UMR_RI010TRisk: Group Text Table6STXTShort textnvarchar150
22UMR_RI100TRisk: Text Table6STXTShort textnvarchar150
23UMR_RI140TRMS: Risk-Reducing Activities (Text Table)8STXTShort textnvarchar150
24UMR_TL100TThreat Level: Text Table6STXTShort textnvarchar150
25UMV_HI101Value Driver Tree Hierarchy: Text Table4STXTShort textnvarchar150
26UMV_TR101Value Driver Tree: Text Table4STXTShort textnvarchar150
27UMV_VD101Obsolete: Value Drivers: Text Tables4STXTShort textnvarchar150
TOPIndustry-Specific Component Automotive
28MGV_LAMASCRLAYOULAMA Screen Fields35STXTTextnvarchar1320
TOPLogbook
29DIACL_LOG_ENTRYLogbook: log entry3STXTLogbook: log entry short textnvarchar400
TOPManagement Cockpit
30UMM_CO103Cockpits: Texts6STXTShort textnvarchar150
31UMM_CO105Cockpits: Texts for the Hierarchy Nodes6STXTShort textnvarchar150
32UMM_FR103Frames: Texts6STXTShort textnvarchar150
33UMM_LV102Logical Views: Texts6STXTShort textnvarchar150
34UMM_VA101Variables: Texts6STXTShort textnvarchar150
35UMM_WA102Walls: Texts6STXTShort textnvarchar150
TOPMedical Rounds
36TN1BALANCETYPETi.s.h.med: Fluid Balancing, Inflow/Outflow Types, Text Table4STXTi.s.h.med: Balancing, Inflow/Outflow Type Short Namenvarchar150
TOPMessages
37DNOC_FUNC_PARTPartner func.5STXTPartner Function Short Textnvarchar200
38DNOC_PRIORITYTPriority Texts5STXTPriority Short Textnvarchar200
39DNOC_TYPE_NOTETNote Types: Texts4STXTNote Type Short Textnvarchar200
40DNOC_TYPE_PARTPartner Categories: Texts4STXTPartner Types Short Textnvarchar200
41DNOC_TYPE_TEXTTText Segment Types: Texts5STXTText Segment Type Short Textnvarchar200
TOPProduction Allocation
42GHO_SIMU_H_TSimulation Header Language Dependent Texts5STXTSimulation Descriptionnvarchar400
TOPWork Clearance Management
43WCAAPWCM: Application6STXTDescriptive Short Textnvarchar400
44WCACGWCM: WCM Object <-> Catalog8STXTDescriptive Short Textnvarchar400
45WCACGQWCM: Log (WCM Object <-> Catalog)9STXTDescriptive Short Textnvarchar400
46WCAHEWCM: Work Clearance Document (Header)6STXTDescriptive Short Textnvarchar400
47WCAITWCM: Work Clearance Document (Item)11STXTDescriptive Short Textnvarchar400
48WCAJWCM: Lineup4STXTDescriptive Short Textnvarchar400
49WCAKWCM: Verification List (Header Data)5STXTDescriptive Short Textnvarchar400
50WCAMEWCM: (Temporary) Log of Operational Lists (Items)13STXTDescriptive Short Textnvarchar400
51WCAMIWCM: Log of Operational Lists (Items)13STXTDescriptive Short Textnvarchar400
52WCAWWCM: Work Approval5STXTDescriptive Short Textnvarchar400
53WCCLTWCM: Print (Texts)6STXTDescriptive Short Textnvarchar400
54WCCOGTWCM: WCM Object (General Texts)5STXTDescription of WCM Objectnvarchar400
55WCCOTWCM: WCM Object (Texts)6STXTDescription of WCM Objectnvarchar400
56WCCSTWCM: Selection Fields for Data Transfer (Texts)4STXTDescriptive Short Textnvarchar400
57WCCUTWCM: Use of Work Clearance Document (Texts)6STXTDescription of WCM Objectnvarchar400
58WCCXTWCM: Use of Work Approval (Texts)6STXTDescription of WCM Objectnvarchar400
59WCCYTWCM: Use of Application (Texts)6STXTDescription of WCM Objectnvarchar400