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

139 columns | Print definition?ERP 6.0  | NOTE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/TDPDTendering Payment Details of an RFx Responder13NOTENote Textnvarchar2550
2BBPC_SUS_BTNDEFDefinition of Displayable Buttons in a View or THTMLB Table16NOTEButton Group to Define Named Toolbarsnvarchar600
3BPC_FIL_ROLETable for Filtering Roles (in Inbound)3NOTECommentnvarchar500
4CMCBD_BRF_HSTRYCash Budget Workflow History for BRF+9NOTEntext10737418230
5CMCBD_COMMENT_PLCash Budgeting Workflow History6NOTEntext10737418230
6CMCBD_WF_HISTORYCash Budgeting Workflow History8NOTEntext10737418230
7CMCBD_WKLIST_NAWork List: Alert/Notification Table10NOTEWork List: Item Notenvarchar2550
8CMCBD_WKLIST_TKWork List: Tasks Table12NOTEWork List: Item Notenvarchar2550
9DFKKEPRTLog for Inconsistent FI-CA Documents61NOTEItem textnvarchar500
10GRACROLETSTRole Testing Header7NOTEIndicatornvarchar10
11IDGT_GTDHGT Document Header22NOTEGT Notenvarchar1600
12IDGT_VATHVAT Invoice Header17NOTEGT Notenvarchar1600
13LXE_CSN_LOGLog Data for Notes1NOTESAP Note Numbernvarchar100
14MRP_REQ_NOTERequests and Notes for MRP Cockpit21NOTENote for the Change Requestntext10737418230
15OBJM_EXTExtension of OBJM8NOTENote numbernvarchar100
16SLAPISOBJ: API called by an after import method6NOTENote numbernvarchar100
17T77PAODYRULEDynamic Processing Rules11NOTENotenvarchar2550
18T7CNTPM_PROCRECTPM: Process Record7NOTENote Textnvarchar1000
19ZTRL_PEXPTAusnahmen Übersetzung (Kopie LANG_PEXPT)8NOTETextfeldnvarchar500
20ZTRL_PEXPT1Ausnahmen Übersetzung (Kopie LANG_PEXPT)8NOTETextfeldnvarchar500
21PIQPROC_ED_GRPED Activity Document: Transferred Work Grouping5NOTEGUID - Unique Note Identifiernvarchar320
22PIQPROC_ED_HED Activity Document: Header Data6NOTEGUID - Unique Note Identifiernvarchar320
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
23CRMCHKMSG_REMOTEOUTDATED - TO BE DELETED - ACCESS STRONGLY DISCOURAGED4NOTEnvarchar800
24CRMCHKPRFCheck Profiles5NOTEDescriptionnvarchar600
25SCIEXCEPTNCode Inspector: Exception Table13NOTESCI: Comments for an Exceptionnvarchar720
26SCIEXCEPTN_APPLCode Inspector: Table of Exception Requests16NOTECHAR72 data element for SYSTnvarchar720
TOPAccounting - General
27FAGL_CLOCO_COMNTComments for Closing Cockpit11NOTECommentntext10737418230
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
28UKRSTCourse Enrollment (Results)5NOTEMarkdecimal21
29UKRTBCourse Participation (Results)4NOTEMarkdecimal21
TOPAP-LIM Logistics Inventory Management Engine
30/LIME/COLL_APSCollection for Planning System16NOTENotesnvarchar500
31/LIME/COLL_BWCollection for Business Warehouse16NOTENotesnvarchar500
32/LIME/COLL_FINCollection for Financial System16NOTENotesnvarchar500
33/LIME/COLL_INVCollection for Inventory System16NOTENotesnvarchar500
34/LIME/COLL_LEGCollection for External System16NOTENotesnvarchar500
35/LIME/COLL_MMIMCollection for R/3 Inventory Management16NOTENotesnvarchar500
36/LIME/COLL_W2IMCollection for WME after ERP-MMIM16NOTENotesnvarchar500
37/LIME/PN_ITEMTable to Save Prima Nota Item Data69NOTENotesnvarchar500
TOPApplication-Specific Upgrade
38/ASU/CONTENTASU: Content15NOTEASU: Note Numbernvarchar100
39/ASU/STEPSASU Steps16NOTEASU: Note Numbernvarchar100
40/ASU/STEPS_VASU Steps (Version)15NOTEASU: Note Numbernvarchar100
TOPArchiveLink
41TOAPISAP ArchiveLink interface38NOTESingle-Character Indicatornvarchar10
TOPBalanced Scorecard
42UMB_SC187Scorecard: Initiative: Message for Team Members6NOTENotenvarchar600
43UMB_SC198Scorecard: Initiative: Milestones (Text Table)7NOTEDescriptionntext10737418230
TOPBank Customer Accounts
44TBKKIHB1In-House Bank ID from Payment Notes in Bank Statement6NOTECharacter Sequence in Payment Notes of Bank Statementnvarchar700
TOPBasic Functions
45TPAMATText Table for Search String TPAMA5NOTEDescriptionnvarchar640
46UDM_T_CORRCONTFSCM-DM: Container (Dialog Correspondence)4NOTENamenvarchar700
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
47COAT_NOTESCOAT: Notes6NOTECharacter Field Length = 10nvarchar100
TOPBusiness Package for Manager Self-Service FI
48FPB_EXP_COMMENTExpress Planning: Comments11NOTEntext10737418230
TOPCheck Input
49OIUCI_NOTESNotes for Suspended Line item of Incoming Check6NOTENote Text for Line itemsnvarchar1320
TOPClaims Management
50ICLDRGITEMDRG Item25NOTENote for Diagnosis Related Groupsnvarchar800
51ICLITEMEQDamaged Item37NOTENote on Salvagenvarchar500
52ICLITEMREDamaged Real Estate30NOTENote on Salvagenvarchar500
53ICLPAYClaim Payment31NOTEPayment Notenvarchar500
54ICL_BENSPLIT_ITMBenefit Split Item (One-Time)23NOTEPayment Notenvarchar500
55ICL_BENSPPER_ITMBenefit Split Item (Periodic)18NOTEPayment Notenvarchar500
56ICSDRGITEMDRG Item25NOTENote for Diagnosis Related Groupsnvarchar800
57ICSITEMEQDamaged Item37NOTENote on Salvagenvarchar500
58ICSITEMREDamaged Real Estate30NOTENote on Salvagenvarchar500
59ICSPAYPayment31NOTEPayment Notenvarchar500
60ICS_BENSPLIT_ITMBenefit Split Item (Shadow Table)23NOTEPayment Notenvarchar500
61ICS_BENSPPER_ITMBenefit Split Item (Shadow Table)18NOTEPayment Notenvarchar500
TOPClinical System
62N2GL_ACT_NOTEPathways: Comment on Activity9NOTEpathways Notentext10737418230
TOPCollaboration Folders
63CFX_NTF_TEMPLATETable for storing information about Notification Templates6NOTECommentary Text for Notificationsntext10737418230
TOPCollateral Management System
64CMS_PCN_CRChange Requests15NOTEChange Request Notenvarchar600
65CMS_TSKTasks14NOTETask Notenvarchar600
66TCMS_CD_BUSINFOClassification of a change to a business object - internal5NOTENote for the changenvarchar600
TOPConnection to External Systems
67DPR_OBJLINK_SCObject Link to SRM Shopping Carts12NOTEDescription of Requestnvarchar400
68DPR_OBJLINK_SC_IItems for SRM Shopping Cart24NOTEDescription of Requestnvarchar400
TOPCorporate Performance Monitor
69UMR_RI141TRMS: Risk-Reducing Activities - Milestones - Text Table8NOTEDescriptionntext10737418230
70UMR_RI142RMS: Risk-Reducing Activities - Team Members9NOTENotenvarchar600
TOPCross-Application Components
71TASUTREPASU: Toolbox: Reports to be started19NOTEASU: Toolbox: According notenvarchar100
TOPCustomer Enhancements
72SMODIPROJCustomer Modifications to WB Objects in Several Projects9NOTECustomer enhancement: Textnvarchar600
TOPDocument Builder
73/IPRO/TDOCMNTDocument Builder Documents39NOTEText, 255 Charactersnvarchar2550
74/IPRO/TTEMPLDocument Builder Templates10NOTETemplate Notentext10737418230
75/IPRO/TUSRTMPLTable of user template data8NOTETemplate Notentext10737418230
TOPE-Recruiting
76HRP5112DB Table for Infotype 511220NOTENotes of Talent Consultant About a Candidatenvarchar60
77HRP5125DB Table for Infotype 512520NOTENotes on Requisition (Pointer)nvarchar60
78HRP5135DB Table for Infotype 513524NOTEActivity Note (Pointer)nvarchar60
79HRP5136DB Table for Infotype 513624NOTEActivity Note (Pointer)nvarchar60
80HRP5137DB Table for Infotype 513724NOTEActivity Note (Pointer)nvarchar60
81HRP5138DB Table for Infotype 513824NOTEActivity Note (Pointer)nvarchar60
82HRP5139DB Table for Infotype 513924NOTEActivity Note (Pointer)nvarchar60
83HRP5140DB Table for Infotype 514024NOTEActivity Note (Pointer)nvarchar60
84HRP5141DB Table for Infotype 514124NOTEActivity Note (Pointer)nvarchar60
85HRP5142DB Table for Infotype 514224NOTEActivity Note (Pointer)nvarchar60
86HRP5143Database Table for Infotype 514324NOTEActivity Note (Pointer)nvarchar60
87HRP5144Database Table for Infotype 514424NOTEActivity Note (Pointer)nvarchar60
88HRP5145Database Table for Infotype 514524NOTEActivity Note (Pointer)nvarchar60
89T77RCF_CANDNOTESCandidate Notes8NOTEntext10737418230
TOPEnergy Data Management
90EDEXTASKCONFERRData Exchange Task Confirmation Msssages Log7NOTEMessage Textnvarchar2200
TOPEnterprise Compensation Management
91T71ADM_EE_NOTECompensation Tracking of Employee notes4NOTEntext10737418230
92T71ADM_PROC_NOTENotes for Compensation Process Tracking6NOTEntext10737418230
TOPError and Conflict Handler
93FEH_MESS_PERSPersistence of the Payload and other Data Relevant to FEH12NOTEPayload Notentext10737418230
TOPIntegration Engine
94SXMSDCONFIntegration Engine: Settings for Deletion Concept7NOTEXMS: Flag (true/false)nvarchar10
TOPKnowledge Warehouse
95IWADMData for KEN Administration20NOTECommentnvarchar640
TOPLocalization
96IDGT_INFOGTI China: Data sent to GT10NOTEGT Notenvarchar1600
TOPMaster Data
97ENOTEAllocation of Object to Note for Field Service6NOTEStatic note to field servicenvarchar20
98ENOTETText Table for Field Service Notes6NOTEStatic note to field servicenvarchar20
TOPMedical Patient Data Organization Patient Organizer
99N1STRUCMEDRECCATIS-H*MED: Health Problems Catalog14NOTEComment for Health Problemnvarchar2550
TOPMeter Reading
100TE580NDynamic Notes to Field Service2NOTEDynamic note to field servicenvarchar20
101TE580TDynamic Notes to Field Service (Texts)3NOTEDynamic note to field servicenvarchar20
102TE582Static Notes to Field Service2NOTEStatic note to field servicenvarchar20
103TE582TStatic Notes to Field Service (Texts)3NOTEStatic note to field servicenvarchar20
TOPNetWeaver Enterprise Search
104ESH_QP_QUE_GRAMQuery Grammar8NOTEQuery Parser Mappingntext10737418230
TOPNon Profit Organizations
105T7UNSLWOP_RCSLWOP periods to be ignored for next reclassification date3NOTEnvarchar200
TOPPackage Tools
106AKB_PRODUCTSProduct Catalog8NOTELong Textntext10737418230
107AKB_PRODUCT_COMPObsolete: Product Composition6NOTEObsolete: Commentnvarchar800
108AKB_TRANS_CHECKObsolete: Compatibility Control26NOTEObsolete: Commentnvarchar800
TOPPrint and Output Management
109TSPOPIPPrinter / device type repations9NOTENote numbernvarchar80
110TSPOPIPRNPrinter / device type relations9NOTENote numbernvarchar80
111TSPOPIPRN_WORKPrinter / device type relations9NOTENote numbernvarchar80
TOPProcessing
112TEOBJRESPDef. Partner Roles and Note for Persons Responsible for Obj.2NOTEStatic note to field servicenvarchar20
TOPSAP Business Partner
113COMM_CLEAR_STACKData Cleansing Cases10NOTEData Cleansing: Notenvarchar500
TOPSAP Business Workflow
114SWDANOTESReferences to Notes for Ad Hoc Agents3NOTEObject IDnvarchar900
TOPSAP Note Assistant
115SMODIUSERProcessor of Customer Modifications15NOTECustomer Enhancement: Text with 132 Charactersnvarchar1320
TOPSAP Utilities
116TEAMI_LOG_MSGMessages for AMI Communication (TEAMI_LOG_DATA)7NOTEText for translationnvarchar2000
TOPSuite Inbox
117IBO_C_WF_TACTasks for Inbox Configuration6NOTEDefine Notes Enablementnvarchar10
118IBO_C_WF_TAETasks for Inbox Configuration (Exceptions in Multibackend)7NOTEDefine Notes Enablementnvarchar10
119IBO_C_WF_TASTasks for Inbox Configuration6NOTEDefine Notes Enablementnvarchar10
TOPTrading Contract
120WB2_C_PF_MTHD_PMExecution Paramter in Method for Processing of Follow-on doc6NOTEShort Descriptionnvarchar600
TOPTranslation Tools
121LANG_LEXPTLocal Supplement for Exceptions: Translation8NOTEText Fieldnvarchar500
122LANG_PEXPTTranslation exception8NOTEText Fieldnvarchar500
123LXE_CSNObject Lists2NOTENumeric Character Field, Length 10nvarchar100
124LXE_CSN_BKNotes2NOTENumeric Character Field, Length 10nvarchar100
125LXE_CSN_HDNotes2NOTESAP Note Numbernvarchar100
126LXE_CSN_HD2Notes2NOTENumeric Character Field, Length 10nvarchar100
127LXE_CSN_PRIONotes2NOTENumeric Character Field, Length 10nvarchar100
128LXE_CSN_TXLNotes2NOTENumeric Character Field, Length 10nvarchar100
129LXE_CSN_TXSNotes2NOTENumeric Character Field, Length 10nvarchar100
130LXE_LEXPTTranslation exception8NOTEText Line With 50 Charactersnvarchar500
131LXE_PEXPTTranslation exception8NOTEText Line With 50 Charactersnvarchar500
TOPTransport Management System
132TMSQWLFTMS QA: Worklist - QA Flags for Requests14NOTEGeneral Flagnvarchar10
133TMSQWLFHTMS QA: Worklist - QA Flags for Requests14NOTEGeneral Flagnvarchar10
TOPUpgrade - General
134MERGENEGLNExclusion Objects Merger Central Maintenance Table12NOTENote numbernvarchar100
TOPUpgrade Tools
135CRRERRORCRR Error Messages19NOTENote numbernvarchar100
TOPVendor Evaluation
136EVAL_IV_RES_HDResults of Vendor Evaluation (Header)18NOTEScore variancedecimal30
137EVAL_IV_RES_ITMResults of Vendor Evaluation (Item)12NOTEScore variancedecimal30
TOPWaste Management
138EWA_WA_WEIGHPROCWeighing Transaction102NOTEDescriptionnvarchar2540
TOPWork Management Mobile Business
139EWM_DEFAULTSMAU: Define Default Values for Selection Fields2NOTEStatic note to field servicenvarchar20