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

108 columns | Print definition?ERP 6.0  | LONGTEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHPRCC_IMSEGFImport segment fields11LONGTEXTLong Textnvarchar10
2MDGHDB_LONGTEXTTable for Storing Long texts10LONGTEXTLong Textntext10737418230
3MSPT_OIGSIShipment Item to store deleted records17LONGTEXTTD Longtext indicatornvarchar10
4ZCATSDBRecords changed with processing status '10'100LONGTEXTnvarchar10
5ZCATSDB2Records changed with processing status '10'101LONGTEXTnvarchar10
TOPASAP Tools and Contents
6SMAPBP0TSolution Map: Best Practice (Text)5LONGTEXTNamenvarchar1000
7SMAPCOMP0TSolution Map: Component (Text)5LONGTEXTNamenvarchar1000
8SMAPPA0TSolution Map: Partner product (text)5LONGTEXTNamenvarchar1000
9SMAPPD0TSolution Map: Product information (text)5LONGTEXTNamenvarchar1000
10SMAPPI0TSolution Map: Performance Indicator (Text)5LONGTEXTNamenvarchar1000
11SMAPPR0TSolution Map: Process category, main process, process (txt)5LONGTEXTNamenvarchar1000
TOPBasic Market Data
12/BA1/TF4_CACATGTTexts for Corporate Action Categories3LONGTEXTLong Textnvarchar600
13/BA1/TF4_CA_MDLTTexts for Corporate Action Models3LONGTEXTLong Textnvarchar600
14/BA1/TF4_MATSTRTText Table for Maturity Structures4LONGTEXTText Field of Length 60nvarchar600
15/BA1/TF4_SCENDCTData Categories Scenario3LONGTEXTLong Textnvarchar600
16/BA1/TF4_VCALCMTCalculation Methods for Volatilities3LONGTEXTLong Textnvarchar600
17/BA1/TF4_YCMDLTText Table for External Model for Yield Curve3LONGTEXTLong Textnvarchar600
TOPControlling
18QISRSCENARIOBasic Scenario Data5LONGTEXTLong Text Existsnvarchar10
TOPCross-Application Components
19/IXOS/DC_PVL_WDCustomizing Table for Web Dynpro project overview view list6LONGTEXTAdditional description for a web dynpro viewnvarchar2550
20/IXOS/DC_WD_PVLCustomizing Table for Web Dynpro project overview view list6LONGTEXTAdditional description for a web dynpro viewnvarchar2550
TOPEnvironment, Health and Safety
21/TDAG/CPC_IMSEGFImport segment fields11LONGTEXTLong Textnvarchar10
TOPESS Based on WD ABAP
22HRESS_D_CATS_FAVCATS Favorites: database table107LONGTEXTLong Textnvarchar10
TOPFramework for the Principle of Dual Control
23TBCA_OBJECT_CATTText Table of Object Categories3LONGTEXTRelease Object Descriptionnvarchar350
24TBCA_REL_ACTTText Tables for the Release Activities4LONGTEXTFull descriptionnvarchar350
25TBCA_REL_PROCTText Tables for the Release Procedure4LONGTEXTRequired Release Stepsnvarchar350
26TBCA_REL_STATUSTText Table for Release Object Status5LONGTEXTFull descriptionnvarchar350
TOPGlobal Performance Analysis Transaction ST3
27AMSTANOGlobal Performance Analysis: Other Statistics Data6LONGTEXTN3 Workload: Description of Service Typenvarchar1280
TOPMaster Data Framework
28DML_TEXTTYPEMDF Text Types3LONGTEXTLong Textnvarchar10
TOPMedia Product Sales and Distribution
29JKSDSQPEVENTTText Table for JKSDSQPEVENT5LONGTEXTIS-M: Long Textnvarchar400
30TJKSD131FILTERGTText Table for Media Issue Worklist Function Groups5LONGTEXTIS-M: Long Textnvarchar400
31TJKSD131TText Table for Media Issue Worklist Function Groups5LONGTEXTIS-M: Long Textnvarchar400
32TJKSDCALCMETHODTText Table for TJKSDCALCMETHOD5LONGTEXTIS-M: Long Textnvarchar400
33TJKSDCICORDRULETChecking Rule for Orders in CIC - Texts5LONGTEXTIS-M: Long Textnvarchar500
34TJKSDCOLCUSTEXLTExclusion Method for Recall Groups - Texts5LONGTEXTIS-M: Long Textnvarchar400
35TJKSDCOLCUSTGRPTCustomer Recall Group Texts5LONGTEXTIS-M: Long Textnvarchar500
36TJKSDCOMPLTYPE1TCIC: Complaint Types for Delivery - Texts5LONGTEXTIS-M: Long Textnvarchar500
37TJKSDCOMPLTYPE2TCIC: Complaint Types for Returns - Texts5LONGTEXTIS-M: Long Textnvarchar500
38TJKSDCORESTRUCTTDescription - Display Structure for Sales Quantity Planning5LONGTEXTIS-M: Long Textnvarchar500
39TJKSDCQPREASONTText Table for Constant Service Reasons5LONGTEXTIS-M: Long Textnvarchar500
40TJKSDCQPSERVTEXTIS-M: Constant Service Types, Text Table5LONGTEXTIS-M: Long Textnvarchar500
41TJKSDCQPSUPPLYTDelivery Status of Constant Service - Text5LONGTEXTIS-M: Long Textnvarchar500
42TJKSDCRCQPTOSQPTIS-M: Copy Rules Constant Service to Quantity Plan5LONGTEXTIS-M: Long Textnvarchar500
43TJKSDCRSQPTOCQPTIS-M: Copy Rules Quantity Plan to Constant Service5LONGTEXTIS-M: Long Textnvarchar500
44TJKSDEVENTRULETText Table for Transfer Rule in Event Processing5LONGTEXTIS-M: Long Textnvarchar500
45TJKSDFCADDFUNCTTexts for Additional Functions for Reference Issue Selection5LONGTEXTIS-M: Long Textnvarchar400
46TJKSDFCAREATName - Planning Group in Reference Issue Planning5LONGTEXTIS-M: Long Textnvarchar500
47TJKSDFCCOPYRULETText Table for TJKSDFCCOPYRULE5LONGTEXTIS-M: Long Textnvarchar400
48TJKSDFCSECMETHTTexts - Calculation Methods for Safety Stock5LONGTEXTIS-M: Long Textnvarchar400
49TJKSDFCSEGMENTTText Table for Segments in a Planning Area5LONGTEXTIS-M: Long Textnvarchar500
50TJKSDFCSEGMETHDTMethod Definition for Segmentation (Forecast)5LONGTEXTIS-M: Long Textnvarchar500
51TJKSDFCSEGVARTText Table for TJKSDFCSEGVAR5LONGTEXTIS-M: Long Textnvarchar500
52TJKSDFIHIERTFilter Hierarchy Definition for Quantity Planning5LONGTEXTIS-M: Long Textnvarchar500
53TJKSDFILTERTText - Filter for Quantity Planning View5LONGTEXTIS-M: Long Textnvarchar400
54TJKSDHIERSTRUCTText Table for Hierarchy Levels6LONGTEXTIS-M: Long Textnvarchar500
55TJKSDISSUEMETHTText Table for TJKSDISSUEMETHOD5LONGTEXTIS-M: Long Textnvarchar400
56TJKSDMMSTATGRPTText - Cross-Plant Material Status Group5LONGTEXTIS-M: Long Textnvarchar500
57TJKSDPLANORGDTRTText for Det. Group for Planning Org. for Qty Planning5LONGTEXTIS-M: Long Textnvarchar500
58TJKSDPLANORGTPlanning Organization for Quantity Planning - Texts6LONGTEXTIS-M: Long Textnvarchar500
59TJKSDPQPCALC1TTimes for Planning Process in Sales Planning - Texts5LONGTEXTIS-M: Long Textnvarchar500
60TJKSDPQPCALC2TGrouping of Calculation Methods in Purchase Planning - Texts5LONGTEXTIS-M: Long Textnvarchar500
61TJKSDRECHKGRPTReturn Customer Group Text Table5LONGTEXTIS-M: Long Textnvarchar500
62TJKSDRECHKPROCHTCheck Procedure Return Text Table Header Data5LONGTEXTIS-M: Long Textnvarchar400
63TJKSDRECHKPROCTReturn Check Procedure Text Table5LONGTEXTIS-M: Long Textnvarchar400
64TJKSDRECHKRULEHTReturn Checking Rule Text Table5LONGTEXTIS-M: Long Textnvarchar400
65TJKSDRECHKRULETReturn Checking Rule Text Table5LONGTEXTIS-M: Long Textnvarchar400
66TJKSDREISCHKGRPTReturn Issue Group Texts5LONGTEXTIS-M: Long Textnvarchar500
67TJKSDRETLOGHANDTReturn Delivery4LONGTEXTIS-M: Long Textnvarchar500
68TJKSDRETSORTINGTSort Indicators for Return Delivery4LONGTEXTIS-M: Long Textnvarchar500
69TJKSDSBRGRPCONTTText for Replen. Planning Grouping for Contract Items5LONGTEXTIS-M: Long Textnvarchar500
70TJKSDSBRGRPISSUTText for Replen. Planning Grouping for Media Issues5LONGTEXTIS-M: Long Textnvarchar500
71TJKSDSBRRULECALTCalc. Rule for Replenishment Planning Quantities - Texts5LONGTEXTIS-M: Long Textnvarchar500
72TJKSDSBRRULEDATTCalculation Rule for Replenishment Planning Date - Texts5LONGTEXTIS-M: Long Textnvarchar500
73TJKSDSBRTIMESTRTIS-M: Period Patterns for Replenishment Planning - Texts5LONGTEXTIS-M: Long Textnvarchar500
74TJKSDSFDETRULETStock Interpretation Rule - Texts5LONGTEXTIS-M: Long Textnvarchar500
75TJKSDSFSTTYPETStock Type for Stock Determination - Text Table5LONGTEXTIS-M: Long Textnvarchar400
76TJKSDSQPCALC1TTimes for Planning Process in Sales Planning - Texts5LONGTEXTIS-M: Long Textnvarchar500
77TJKSDSQPCALC2TGrouping of Calculation Methods for Sales Planning - Texts5LONGTEXTIS-M: Long Textnvarchar500
78TJKSDSTFRWORKTText Table for Goods Transfer Procedure5LONGTEXTIS-M: Long Textnvarchar400
79TJKSDSTOCKTYPETText Table for Stock Types5LONGTEXTIS-M: Long Textnvarchar400
80TJKSDSTRUCTURETText - Structure for Quantity Planning View5LONGTEXTIS-M: Long Textnvarchar500
81TJKSDSUBSTRUCTTText - Substructure in Sales Quantity Planning5LONGTEXTIS-M: Long Textnvarchar500
82TJKSDSUBSTRUPQPTText - Substructure for Purchase Quantity Planning5LONGTEXTIS-M: Long Textnvarchar500
83TJKSDUPDATERULETText - Update Rules for Quantity Planning View6LONGTEXTIS-M: Long Textnvarchar500
84TJKSDUPDMETHODTText - Calculation Method in Quantity Planning6LONGTEXTIS-M: Long Textnvarchar500
85TJKSDUSRGRPTText - User Group for Quantity Planning View6LONGTEXTIS-M: Long Textnvarchar500
86TJKSDVERIFYRULETRule for Calculating Corrected Sales Figures - Texts5LONGTEXTIS-M: Long Textnvarchar500
87TJKSDVIEWFUNCTText - Calculation Method for Quantity Planning View6LONGTEXTIS-M: Long Textnvarchar400
88TJKSDVIEWLOADERTTexts for Determining Historical Sales Figures5LONGTEXTIS-M: Long Textnvarchar400
89TJKSDVIEWLOADTTexts for Determining Historical Sales Figures5LONGTEXTIS-M: Long Textnvarchar400
90TJKSDVIEWMETHODTText - Distribution Method for Planning View5LONGTEXTIS-M: Long Textnvarchar400
91TJKSDVIEWTText for Quantity Planning View6LONGTEXTIS-M: Long Textnvarchar500
TOPMenu Painter
92D301TTexts for Program Functions and Menu Bars9LONGTEXTGUI: Long text (CUA text until 3.1)nvarchar200
TOPMonitoring
93SWLN3CMPIFNon-R/3 Statistic: Action Type and Service Type Information5LONGTEXTDSR Statistics: Long Text for Action/Service Typenvarchar1280
94SWLN3CMPITNon-R/3 Statistic: Action Type and Service Type Information6LONGTEXTDSR Statistics: Long Text for Action/Service Typenvarchar1280
TOPPost Processing Framework
95PPFTTTCUTPPF: Action Definition in Customizing5LONGTEXTNamenvarchar700
TOPSAP Business Workflow
96SWDSHEADERWF Definition: Basic Data13LONGTEXTWorkflow definition: Long text IDnvarchar10
97SWD_HEADERWF Definition/Runtime: Basic Data14LONGTEXTWorkflow definition: Long text IDnvarchar10
TOPTerminologyGlossary
98STERM_LINKLink Between Concept and Associated Terms16LONGTEXTGeneral Flagnvarchar10
99STERM_Q_CHECKTable for Terminology Check35LONGTEXTGeneral Flagnvarchar10
TOPTime Sheet
100CATSDBCATS: Database Table for Time Sheet100LONGTEXTLong Textnvarchar10
TOPTraders and Schedulers Workbench
101OIJECTD-Transport Unit Master Data Events34LONGTEXTTD - event long text indicatornvarchar10
102OIJEVTD-Vehicle ~ Berth Master Data Events37LONGTEXTTD - event long text indicatornvarchar10
103OIJSUBITEMEVENTSNomination Sub Item Events34LONGTEXTTD - event long text indicatornvarchar10
TOPTransportation and Distribution
104OIGSIShipment Item17LONGTEXTTD Longtext indicatornvarchar10
TOPWeb Application Builder
105W3BHTMFUNCWAB: Business HTML Functions3LONGTEXTLong docu for Business HTML Elementnvarchar300
106W3BHTMPARAWAB: Business HTML Parameters5LONGTEXTLong docu for Business HTML Elementnvarchar300
107W3BHTMVALUWAB: Values for Business HTML Parameters8LONGTEXTLong docu for Business HTML Elementnvarchar300
108W3BHTMWIZZWAB: Business HTML Wizards3LONGTEXTLong docu for Business HTML Elementnvarchar300