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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

67 columns | Print definition?ERP 6.0  | SUBJECT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GRCPI/GRIANOTCTNotification Message Subjects (Customer)6SUBJECTSubjectnvarchar2550
2/GRCPI/GRIANOTFTNotification Message Subjects (Defaults)5SUBJECTSubjectnvarchar2550
3/OPT/CT_IDH_MAILInbound Document Handler: Email Input Log - obsolete16SUBJECTChar255nvarchar2550
4/OPT/CT_MAIL_SUBTable to maintain Mail Subject4SUBJECTMail Subject/Titlenvarchar700
5/OPT/X203Table to maintain Mail Subject4SUBJECTMail Subject/Titlenvarchar700
6/OPT/Y203Table to maintain Mail Subject4SUBJECTMail Subject/Titlenvarchar700
7/OPT/Z203Table to maintain Mail Subject4SUBJECTMail Subject/Titlenvarchar700
8/OTEB/SWF_TACTxIM activities business data12SUBJECTxIM activity subjectnvarchar790
9/OTEB/SWF_TMPSELTemporary save of selected actkeys (several workitems exist)7SUBJECTxIM activity subjectnvarchar790
10/OTEB/SWF_TSUBJSubject texts for email notification5SUBJECTSubject of workflow emailnvarchar2550
11/OTEI/DU_WD_EMALEmail customizing table6SUBJECTEmail subjectnvarchar2550
12/OTEI/DU_WD_TICDTicket details table7SUBJECTTicket subjectnvarchar1000
13/OTEI/DU_WD_TISTTicket Subject5SUBJECTEmail subjectnvarchar2550
14/OTEI/SWF_TMPSELTemporary save of selected actkeys (several workitems exist)6SUBJECTxIM activity subjectnvarchar790
15/SAPSRM/D_SRVMOSurvey Mail Objects5SUBJECTSubject of a Mail Object for SRM Surveyntext10737418230
16/SYCLO/PSH00Push Scenario Definition12SUBJECTShort description of contentsnvarchar500
17/XFT/COMMAIL02Mail: Subject of Attachments5SUBJECTMail: subjectnvarchar2550
18/XFT/STLCERTFNGPInformationen zu Zertifikaten4SUBJECTSSF-Name für Unterzeichner/Empfängernvarchar2550
19CMCBD_WKLIST_NAWork List: Alert/Notification Table8SUBJECTWork List: Item Subjectnvarchar500
20CMCBD_WKLIST_TKWork List: Tasks Table11SUBJECTWork List: Item Subjectnvarchar500
21EHHSSD_CINSP_RTControl Inspection - Root20SUBJECTSubtypenvarchar210
22EHPRCC_EMLDCP: eMail Definition3SUBJECTPhrase for E-Mail Subject Linenvarchar400
23PIQDB_DE_QRSTATDQuick Report Detail Table5SUBJECTModule Group IDnvarchar80
24STRUSTCRRRevoked Certificates (Minimum Age)4SUBJECTCertificate Subject Namentext10737418230
25STRUSTCRTCertificates table with certificate status6SUBJECTCertificate Subject Namentext10737418230
26ZROOMBOOKEDTable with all reservations7SUBJECTSubject of meetingnvarchar300
27HRT1785Table Part Infotype 17855SUBJECTSchool Subject, Academic Subject, or Qualificationnvarchar80
28T7PIQ_NL_SUBMAPMapping table for subjects3SUBJECTObject IDnvarchar80
TOPAccounts Receivable Accounting Process Integration
29TFDM_DEFCCFSCM-DM: Default Values for Company Code3SUBJECTSubject of Dispute Casenvarchar30
30TFDM_DEFRCFSCM-DM: Default Values for Company Code3SUBJECTSubject of Dispute Casenvarchar30
TOPASAP AcceleratedSAP
31SPERSQADBPersonalization Table for Review Question Filter Values9SUBJECTTopic (Subcategory) for SAP Review Programnvarchar30
32SQADB01REVAdditional Attributes for SAP Review Program Questions7SUBJECTTopic (Subcategory) for SAP Review Programnvarchar30
33SREVSUBCFocus Elements (Subcategories) for SAP Review Program1SUBJECTTopic (Subcategory) for SAP Review Programnvarchar30
34SREVSUBCTText Table for SAP Review Program Focus Elements2SUBJECTTopic (Subcategory) for SAP Review Programnvarchar30
35SROADSUBJIA: Valid Roles for Roadmap2SUBJECTIA: Subject area keynvarchar30
36SSUBJECTIA: Subject Areas for Roadmap1SUBJECTIA: Subject area keynvarchar30
37SSUBJECTTIA: Texttable for subject of roadmap2SUBJECTIA: Subject area keynvarchar30
TOPAuthentication and SSO
38USRCERTMAPCertificate Mapping5SUBJECTSubjectntext10737418230
TOPBRFplus - ABAP-Based Business Rules
39FDT_ACTN_6000FDT: Action - Email5SUBJECTnvarchar2550
40FDT_ACTN_6000AFDT: Action - Email5SUBJECTnvarchar2550
41FDT_ACTN_6000SFDT: Action - Email4SUBJECTnvarchar2550
42FDT_ACTN_6000TFDT: Action - Email4SUBJECTnvarchar2550
TOPBusiness Objects, Common Components
43EHFNDC_ACTTMPLAction Template Code5SUBJECTSubtypenvarchar210
44EHFNDC_CONTROLControls4SUBJECTSubtypenvarchar210
TOPBusiness Package for Manager Self-Service FI
45FPB_EXP_INS_MAILExpress Planning: Standard E-Mails6SUBJECTSubject of E-Mailnvarchar500
TOPCollaboration Folders
46CFX_NTF_ACTIONStatus Managment: Action: Send a Notification7SUBJECTSubject of a Notificationntext10737418230
47CFX_NTF_CONTENTCollaboration Folders: Content Data of Notifications4SUBJECTSubject of a Notificationntext10737418230
48CFX_NTF_TEMPLATETable for storing information about Notification Templates3SUBJECTSubject of a Notificationntext10737418230
TOPCommunication Services Mail, Fax, SMS, Telephony
49BCST_SRBCS: Status of Send Orders38SUBJECTSubject (Without Length Restriction)nvarchar2550
50MIME_DSNCBCOM MIME: Assignment of Message Number to DSN Status Code4SUBJECTBCOM: Status-Code Subject/Detailnvarchar30
TOPConfiguration management
51TCMFOLDERSTable for sending CM folders6SUBJECTSubject line for sending mail of a CEP ordernvarchar1200
TOPContent Management Service
52CREP_FNGPInformation on Certificates3SUBJECTSSF Name for Signatory/Recipientnvarchar2550
TOPCross-Application Components
53ETP_TASKSEasy Task Planning: Tasks4SUBJECTTask Short Textnvarchar600
TOPEnvironment, Health and Safety
54/TDAG/CPC_EMLDCP: eMail Definition3SUBJECTPhrase for E-Mail Subject Linenvarchar400
TOPGovernance, Risk and Compliance
55GRFNNOTIFYMSGCTNotification Message Subjects (Customer)6SUBJECTSubjectnvarchar2550
56GRFNNOTIFYMSGTNotification Message Subjects (Defaults)5SUBJECTSubjectnvarchar2550
TOPIncident Workflow and Tasks
57EHHSSD_IAC_ROOTAction - Root20SUBJECTSubtypenvarchar210
TOPKnowledge Management and Collaboration
58CPETASKLOGDatabase table with log information for Ad hoc Workflow7SUBJECTCharacter 100nvarchar1000
TOPMessages
59DNOD_NOTIFNotification Header19SUBJECTSubjectnvarchar600
TOPProduct Data Management
60CEPFOLDERSTable of CM folder for CEP scenario6SUBJECTSubject line for sending mail of a CEP ordernvarchar1200
TOPRecords and Case Management
61RMPSGENSPHISTHistory Table for Generic SP Objects12SUBJECTLetter Referencenvarchar640
62RMPSU_EVENT_MAILMail recipient information for RMPS Event Notification8SUBJECTMail Subject (SE61)nvarchar600
TOPRegulatory reporting for insurance companies
63ISSR_RPI_MFTISSR: Feste und variable Daten Meldewesen65SUBJECTAbgesicherter Vertragsgegenstand eines derivativen Geschäftsnvarchar20
64TISSR_ADMN_SUBJISSR: Definition Vertragsgegenstand Derivate4SUBJECTAbgesicherter Vertragsgegenstand eines derivativen Geschäftsnvarchar20
65TISSR_ADMN_SUBJTISSR: Texte agesicherter Vertragsgegenstand Derivate5SUBJECTAbgesicherter Vertragsgegenstand eines derivativen Geschäftsnvarchar20
TOPRisk Assessment
66EHHSSD_RAC_ROOTRisk Assesment Actions20SUBJECTSubtypenvarchar210
TOPSecurity
67STRUSTCABCentral Address Book2SUBJECTntext10737418230