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

123 columns | Print definition?ERP 6.0  | SHORTTEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1UCONHTTPSERVTEXTHTTP Service Text Table4SHORTTEXTUnified Connectivity Text (short)nvarchar2550
2UCONRFCSERVTEXTUCON: RFC Service Text Table4SHORTTEXTUnified Connectivity Text (short)nvarchar2550
3UCONSERVASTEXTUnified Connectivity Service Assembly Header4SHORTTEXTUnified Connectivity Text (short)nvarchar2550
TOPAlert Framework
4SALRTCCNTTAlerts: Container Text Table6SHORTTEXTDescriptionnvarchar800
5SALRTCNTTAlerts: Container Text Table6SHORTTEXTDescriptionnvarchar800
TOPBusiness Object Builder
6SWOTLQRuntime Table Parameters, Exceptions30SHORTTEXTDescriptionnvarchar800
7SWOTLVRuntime Table Verbs38SHORTTEXTDescriptionnvarchar800
8SWOTTOShort Texts for Aggregated Objects4SHORTTEXTDescriptionnvarchar800
9SWOTTOLEWorkflow Object Types: Texts OLE Applications4SHORTTEXTDescriptionnvarchar800
10SWOTTQVerbs Parameters Texts7SHORTTEXTDescriptionnvarchar800
11SWOTTVTexts for Verbs5SHORTTEXTDescriptionnvarchar800
TOPBusiness Process Engine
12BRR_TEXTLanguage-Dependent Rule Text6SHORTTEXTntext10737418230
13BRR_TEXT_CText for a Language-Dependent Rule7SHORTTEXTntext10737418230
14SWFDXMPCNTTXML Message Proxy: Container Definition (Text)5SHORTTEXTDescriptionnvarchar800
TOPClinical System
15N2HIT_EN_OTHL: Text Table for /MED/N2HIT_EN_OB6SHORTTEXTText (80 Characters)nvarchar800
TOPCross-Application Components
16/IXOS/DC_TTC03TTexts for table fields, created by using DDIF_FIELDINFO_GET5SHORTTEXTMedium Field Labelnvarchar200
TOPCustomer Interaction Center
17ECCPCALLBACKRVTReasons for callback (texts)4SHORTTEXTTextnvarchar500
18ECCPRECEIVETConfiguration of office-recipient for workflow start (texts)5SHORTTEXTTextnvarchar500
TOPEvent Management
19/SAPTRX/AOTYPESTApplication object type descriptions (texts)6SHORTTEXTText Length 20nvarchar200
20/SAPTRX/EVTYPESTEvent Type Descriptions (Texts)6SHORTTEXTText Length 20nvarchar200
TOPFramework for the Principle of Dual Control
21TBCA_REL_ACTTText Tables for the Release Activities3SHORTTEXTShort Namenvarchar100
22TBCA_REL_PROCTText Tables for the Release Procedure3SHORTTEXTRequired Release Stepsnvarchar100
23TBCA_REL_STATUSTText Table for Release Object Status4SHORTTEXTShort Namenvarchar100
TOPFront Office
24ECVCONFTIS-U customer overview: configuration texts5SHORTTEXTText (30 Characters)nvarchar300
25ECVHTMLTIS-U customer overview: configuration texts7SHORTTEXTText (30 Characters)nvarchar300
26ECVNODETIS-U customer overview: configuration texts6SHORTTEXTText (30 Characters)nvarchar300
TOPImplementation Guide
27DSYAANo longer used from 3.0 onwards4SHORTTEXTModule Titlenvarchar600
28DSYAWStructures: Short text for views on a book4SHORTTEXTModule Titlenvarchar600
TOPIncentive and Commission Management ICM
29TCACS_GOACTRL_TText Table for Cross-Application Generation Control Table3SHORTTEXTShort Description of Repository Objectsnvarchar600
30TCACS_VALSTAT1_TAllowed Status Combinations Process/Version5SHORTTEXTnvarchar360
31TCACS_VALSTAT2_TAllowed Status Combinations Process/Item5SHORTTEXTnvarchar360
32TCACS_VALTARG1_TAllowed Target/Status Combinations Process/Version6SHORTTEXTText (30 Characters)nvarchar300
33TCACS_VALTARG2_TAllowed Target/Status Combinations Process/Version6SHORTTEXTText (30 Characters)nvarchar300
TOPLocalization
34J_3RFBS5_COLTSection columns of balance sheet supplement N5 (text table)5SHORTTEXTTitle of Column in ALV Listnvarchar400
35J_3RFBS5_ROWTRows of balance sheet supplement N5 (text table)5SHORTTEXTTitle of Row in ALV Listnvarchar800
TOPMaintenance Notifications
36QNAOD_AOBJECTAssigned Objects for Notification Item10SHORTTEXTComment for Assigned Objectnvarchar400
TOPMedia Product Sales and Distribution
37JKSDSQPEVENTTText Table for JKSDSQPEVENT4SHORTTEXTIS-M: Short Textnvarchar150
38TJKSD131FILTERGTText Table for Media Issue Worklist Function Groups4SHORTTEXTIS-M: Short Textnvarchar150
39TJKSD131TText Table for Media Issue Worklist Function Groups4SHORTTEXTIS-M: Short Textnvarchar150
40TJKSDCALCMETHODTText Table for TJKSDCALCMETHOD4SHORTTEXTIS-M: Short Textnvarchar150
41TJKSDCICORDRULETChecking Rule for Orders in CIC - Texts4SHORTTEXTIS-M: Short Textnvarchar150
42TJKSDCOLCUSTEXLTExclusion Method for Recall Groups - Texts4SHORTTEXTIS-M: Short Textnvarchar150
43TJKSDCOLCUSTGRPTCustomer Recall Group Texts4SHORTTEXTIS-M: Short Textnvarchar150
44TJKSDCOMPLTYPE1TCIC: Complaint Types for Delivery - Texts4SHORTTEXTIS-M: Short Textnvarchar150
45TJKSDCOMPLTYPE2TCIC: Complaint Types for Returns - Texts4SHORTTEXTIS-M: Short Textnvarchar150
46TJKSDCORESTRUCTTDescription - Display Structure for Sales Quantity Planning4SHORTTEXTIS-M: Short Textnvarchar150
47TJKSDCQPREASONTText Table for Constant Service Reasons4SHORTTEXTIS-M: Short Textnvarchar150
48TJKSDCQPSERVTEXTIS-M: Constant Service Types, Text Table4SHORTTEXTIS-M: Short Textnvarchar150
49TJKSDCQPSUPPLYTDelivery Status of Constant Service - Text4SHORTTEXTIS-M: Short Textnvarchar150
50TJKSDCRCQPTOSQPTIS-M: Copy Rules Constant Service to Quantity Plan4SHORTTEXTIS-M: Short Textnvarchar150
51TJKSDCRSQPTOCQPTIS-M: Copy Rules Quantity Plan to Constant Service4SHORTTEXTIS-M: Short Textnvarchar150
52TJKSDEVENTRULETText Table for Transfer Rule in Event Processing4SHORTTEXTIS-M: Short Textnvarchar150
53TJKSDFCADDFUNCTTexts for Additional Functions for Reference Issue Selection4SHORTTEXTIS-M: Short Textnvarchar150
54TJKSDFCAREATName - Planning Group in Reference Issue Planning4SHORTTEXTIS-M: Short Textnvarchar150
55TJKSDFCCOPYRULETText Table for TJKSDFCCOPYRULE4SHORTTEXTIS-M: Short Textnvarchar150
56TJKSDFCSECMETHTTexts - Calculation Methods for Safety Stock4SHORTTEXTIS-M: Short Textnvarchar150
57TJKSDFCSEGMENTTText Table for Segments in a Planning Area4SHORTTEXTIS-M: Short Textnvarchar150
58TJKSDFCSEGMETHDTMethod Definition for Segmentation (Forecast)4SHORTTEXTIS-M: Short Textnvarchar150
59TJKSDFCSEGVARTText Table for TJKSDFCSEGVAR4SHORTTEXTIS-M: Short Textnvarchar150
60TJKSDFIHIERTFilter Hierarchy Definition for Quantity Planning4SHORTTEXTIS-M: Short Textnvarchar150
61TJKSDFILTERTText - Filter for Quantity Planning View4SHORTTEXTIS-M: Short Textnvarchar150
62TJKSDHIERSTRUCTText Table for Hierarchy Levels5SHORTTEXTIS-M: Short Textnvarchar150
63TJKSDISSUEMETHTText Table for TJKSDISSUEMETHOD4SHORTTEXTIS-M: Short Textnvarchar150
64TJKSDMMSTATGRPTText - Cross-Plant Material Status Group4SHORTTEXTIS-M: Short Textnvarchar150
65TJKSDPLANORGDTRTText for Det. Group for Planning Org. for Qty Planning4SHORTTEXTIS-M: Short Textnvarchar150
66TJKSDPLANORGTPlanning Organization for Quantity Planning - Texts5SHORTTEXTIS-M: Short Textnvarchar150
67TJKSDPQPCALC1TTimes for Planning Process in Sales Planning - Texts4SHORTTEXTIS-M: Short Textnvarchar150
68TJKSDPQPCALC2TGrouping of Calculation Methods in Purchase Planning - Texts4SHORTTEXTIS-M: Short Textnvarchar150
69TJKSDRECHKGRPTReturn Customer Group Text Table4SHORTTEXTIS-M: Short Textnvarchar150
70TJKSDRECHKPROCHTCheck Procedure Return Text Table Header Data4SHORTTEXTIS-M: Short Textnvarchar150
71TJKSDRECHKPROCTReturn Check Procedure Text Table4SHORTTEXTIS-M: Short Textnvarchar150
72TJKSDRECHKRULEHTReturn Checking Rule Text Table4SHORTTEXTIS-M: Short Textnvarchar150
73TJKSDRECHKRULETReturn Checking Rule Text Table4SHORTTEXTIS-M: Short Textnvarchar150
74TJKSDREISCHKGRPTReturn Issue Group Texts4SHORTTEXTIS-M: Short Textnvarchar150
75TJKSDSBRGRPCONTTText for Replen. Planning Grouping for Contract Items4SHORTTEXTIS-M: Short Textnvarchar150
76TJKSDSBRGRPISSUTText for Replen. Planning Grouping for Media Issues4SHORTTEXTIS-M: Short Textnvarchar150
77TJKSDSBRRULECALTCalc. Rule for Replenishment Planning Quantities - Texts4SHORTTEXTIS-M: Short Textnvarchar150
78TJKSDSBRRULEDATTCalculation Rule for Replenishment Planning Date - Texts4SHORTTEXTIS-M: Short Textnvarchar150
79TJKSDSBRTIMESTRTIS-M: Period Patterns for Replenishment Planning - Texts4SHORTTEXTIS-M: Short Textnvarchar150
80TJKSDSFDETRULETStock Interpretation Rule - Texts4SHORTTEXTIS-M: Short Textnvarchar150
81TJKSDSFSTTYPETStock Type for Stock Determination - Text Table4SHORTTEXTIS-M: Short Textnvarchar150
82TJKSDSQPCALC1TTimes for Planning Process in Sales Planning - Texts4SHORTTEXTIS-M: Short Textnvarchar150
83TJKSDSQPCALC2TGrouping of Calculation Methods for Sales Planning - Texts4SHORTTEXTIS-M: Short Textnvarchar150
84TJKSDSTFRWORKTText Table for Goods Transfer Procedure4SHORTTEXTIS-M: Short Textnvarchar150
85TJKSDSTOCKTYPETText Table for Stock Types4SHORTTEXTIS-M: Short Textnvarchar150
86TJKSDSTRUCTURETText - Structure for Quantity Planning View4SHORTTEXTIS-M: Short Textnvarchar150
87TJKSDSUBSTRUCTTText - Substructure in Sales Quantity Planning4SHORTTEXTIS-M: Short Textnvarchar150
88TJKSDSUBSTRUPQPTText - Substructure for Purchase Quantity Planning4SHORTTEXTIS-M: Short Textnvarchar150
89TJKSDUPDATERULETText - Update Rules for Quantity Planning View5SHORTTEXTIS-M: Short Textnvarchar150
90TJKSDUPDMETHODTText - Calculation Method in Quantity Planning5SHORTTEXTIS-M: Short Textnvarchar150
91TJKSDUSRGRPTText - User Group for Quantity Planning View5SHORTTEXTIS-M: Short Textnvarchar150
92TJKSDVERIFYRULETRule for Calculating Corrected Sales Figures - Texts4SHORTTEXTIS-M: Short Textnvarchar150
93TJKSDVIEWFUNCTText - Calculation Method for Quantity Planning View5SHORTTEXTIS-M: Short Textnvarchar150
94TJKSDVIEWLOADERTTexts for Determining Historical Sales Figures4SHORTTEXTIS-M: Short Textnvarchar150
95TJKSDVIEWLOADTTexts for Determining Historical Sales Figures4SHORTTEXTIS-M: Short Textnvarchar150
96TJKSDVIEWMETHODTText - Distribution Method for Planning View4SHORTTEXTIS-M: Short Textnvarchar150
97TJKSDVIEWTText for Quantity Planning View5SHORTTEXTIS-M: Short Textnvarchar150
TOPMenu Painter
98D301TTexts for Program Functions and Menu Bars10SHORTTEXTGUI: Short textnvarchar200
TOPMonitoring
99SWLN3CMPIFNon-R/3 Statistic: Action Type and Service Type Information4SHORTTEXTDSR Statistics: Short Text for Action/Service Typenvarchar200
100SWLN3CMPITNon-R/3 Statistic: Action Type and Service Type Information5SHORTTEXTDSR Statistics: Short Text for Action/Service Typenvarchar200
TOPOracle Database Monitors
101ORA_STT_HEADDBACockpit: Header table for RSORASTT2SHORTTEXTOracle: Data element for textntext10737418230
TOPProject System
102PSHLP_CACHE_DBMaintains Project Cache Information19SHORTTEXTntext10737418230
103PSHLP_CACHE_DB_NMaintains Project Cache Information19SHORTTEXTimage21474836470
TOPSAP Business Workflow
104SWDSWFCTXTWF Definition: Container Text (All Releases)10SHORTTEXTDescriptionnvarchar800
105SWD_WFCTXTWorkflow definition: Container texts11SHORTTEXTDescriptionnvarchar800
106SWFDCRLHCTCorrelation: Parameter Texts (XML Container)5SHORTTEXTDescriptionnvarchar800
107SWFSLSAPPLCUSTDeadline Service: Description of the Application4SHORTTEXTDescriptionnvarchar800
108SWJPCTXTContainer Definition for Parameter Condition (Text Table)6SHORTTEXTDescriptionnvarchar800
TOPSAP NetWeaver Mobile - Use subcomponents
109MDK_INVENTORYMDK Inventory Example - Data Table3SHORTTEXTCharacter field of length 40nvarchar400
TOPService Data Download
110/SDF/CMO_T_64CCCMC Service: CDMC checks clearing analysis - Duplicate dom.2SHORTTEXTShort Description of Repository Objectsnvarchar600
111/SDF/CMO_T_64DCCMC Service: CDMC checks clearing analysis - Empty tables2SHORTTEXTShort Description of Repository Objectsnvarchar600
TOPStructures
112CNLDST_SHORTTXTable of Language-Dependent Short Texts6SHORTTEXTLanguage-Dependent Short Textnvarchar400
TOPSyntax, Compiler, Runtime
113ICONTIcon Texts3SHORTTEXTDescription of an iconnvarchar300
114SAMTESAMT: Information about tasks4SHORTTEXTSAMT: Short textnvarchar400
115SAMTXSAMT: (Language-specific) texts about tasks4SHORTTEXTSAMT: Short textnvarchar400
116SAMT_PSINFSAMT: Administrative information for program quantities4SHORTTEXTSAMT: Short textnvarchar400
TOPTransaction Manager
117TERTVWERKOExecutable Rights (Header)21SHORTTEXTShort text/description of the objectnvarchar400
TOPTransport Management System
118CTWFPROPOSTransport Proposal: Header3SHORTTEXTCharacter field of length 60nvarchar600
TOPUse BC-FES-CTL see SAP Note 842824
119TOLETWorkflow Object Types: Texts OLE Applications4SHORTTEXTText for an OLE applicationnvarchar800
TOPWeb Application Builder
120SW3M_ADMTShort Texts for MiniApp Catalog4SHORTTEXTMedium Field Labelnvarchar200
121W3DEVTYPTDevice Types Short Text3SHORTTEXTMiniApp Short Descriptionnvarchar750
TOPWorkbench Tools Editors, Painters, Modelers
122W3ADMTXMinApp Text Table4SHORTTEXTMedium Field Labelnvarchar200
123W3DEVTYPTXDevice Types Short Text3SHORTTEXTLong Web Application Descriptionnvarchar750