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

101 columns | Print definition?ERP 6.0  | APPID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PERSONAS/USRAPPDummy table for User-/AppId-Lockobject /PERSONAS/E_USER4APPIDPersonas : Application ID or Transaction Codenvarchar500
2J1I_EXIM_GEN_TXTEXIM Table for storing general text2APPIDApplication IDnvarchar30
3J_1IEXIM_ATCH_IDEXIM : File Attachment ID2APPIDApplication IDnvarchar30
4J_1IEXPACCEXIM : Account Assignment2APPIDApplication IDnvarchar30
5J_1I_EXIMFILELOGEXIM:: File Log2APPIDApplication IDnvarchar30
6J_1I_EXIMSTATUSEXIM : Status Check Table2APPIDApplication IDnvarchar30
7J_1I_EXIM_ATTREXIM : Custom Attributes1APPIDApplication IDnvarchar30
8J_1I_EXIM_ATTR_TEXIM : Attribute Text Table1APPIDApplication IDnvarchar30
9J_1I_EXIM_STLOGEXIM : Application Status Log2APPIDApplication IDnvarchar30
10J_1I_EXIM_TEXTEXIM : Application Text Table2APPIDApplication IDnvarchar30
11J_1I_EXIM_WFEXIM : Workflow Levels and Approvers at Request Level2APPIDApplication IDnvarchar30
12J_1I_EXIM_WF_LOGEXIM : Workflow Log2APPIDApplication IDnvarchar30
13PA0615HR Master Record: Infotype 061548APPIDHESA: Appointment identifiernvarchar30
14SRA003_T_CONFIGConfiguration Table for Sales Order Change App2APPIDApplication IDsnvarchar40
15SRA018_T_CONFIGConfiguration Table for Sales Order Tracking App2APPIDApplication IDsnvarchar40
16SRA021_T_CONFIGConfiguration Table for Invoice Tracking App2APPIDApplication IDsnvarchar40
17SRA_SOCONFIGConfiguration Table for Sales Order Tracking Apps2APPIDData Type 4 Charactersnvarchar40
18T7TW7ASNHI report history data record8APPIDApplication IDnvarchar300
19VBIC_REST_HNDLRVBI REST Handler1APPIDData type for REST Application IDnvarchar400
TOPAccounting Interface
20ACI_TECS_IF_GENAdministration Information for Generation2APPIDID of an Application in the Business Rule Frameworknvarchar320
TOPAustria
21T5APFImplementation for Dynamic Instance Generation2APPIDSubapplicationnvarchar40
22T5APGCustomer Layer f. Dynamic Instance Generation (Analog T5APF)2APPIDSubapplicationnvarchar40
TOPClinical System
23N2DTAPPLOBSOLETE: New Table TN2DTAPPL !!!1APPIDDocument Category: Applicationnvarchar150
24N2DTAPPLPDFi.s.h.med: Table of Document Categories PDF Application6APPIDApplication ID for Document Categoriesnvarchar150
25N2DTAPPLXMLi.s.h.med: Table of XML Application Document Categories6APPIDApplication ID for Document Categoriesnvarchar150
26N2DTAPPL_PDFi.s.h.med: Table of Document Categories PDF Application5APPIDApplication ID for Document Categoriesnvarchar150
27N2DTAPPL_XMLi.s.h.med: Table of Document Categories XML Application5APPIDApplication ID for Document Categoriesnvarchar150
28N2DTDTAIS-H*MED: Table of Documentation Categs. for Desktop Appl.6APPIDApplication ID for Document Categoriesnvarchar150
29N2DTWORDIS-H*MED: Table of Word application document categories6APPIDApplication ID for Document Categoriesnvarchar150
30N2DT_HTML_TMPLIS-H*MED: DocCateg. addition HTML template6APPIDApplication ID for Document Categoriesnvarchar150
31N2MIDEFIS-H*MED: Definitions for MedImage coupling5APPIDApplication ID for Document Categoriesnvarchar150
32TN2DOCARCHIS-H*MED: Settings for Archiving Documents2APPIDApplication ID for Document Categoriesnvarchar150
33TN2DTAPPLDocument Category: Permitted Applications2APPIDApplication ID for Document Categoriesnvarchar150
34TN2DTAPPLFORMATDocument Category: Special Format of Action2APPIDApplication ID for Document Categoriesnvarchar150
35TN2DTAPPLTDocument Cat.: Permitted Applications - Texts2APPIDApplication ID for Document Categoriesnvarchar150
TOPClosing Operations
36FBRC0010CReconciliation Processes: Attributes7APPIDApplication IDnvarchar320
37FBRC1100CContact Person Databases2APPIDApplication IDnvarchar320
38FBRC1100TContact Person Databases: Texts3APPIDApplication IDnvarchar320
39FBRC1110Contact Persons2APPIDApplication IDnvarchar320
40FBRC1200CMessage Template Groups2APPIDApplication IDnvarchar320
41FBRC1200TMessage Template Groups: Texts3APPIDApplication IDnvarchar320
42FBRC1210CMessage Templates2APPIDApplication IDnvarchar320
43FBRC1210TMessage Templates: Texts3APPIDApplication IDnvarchar320
44FBRC1215Message Templates: Textlines3APPIDApplication IDnvarchar320
45FBRC1220CMessage Placeholders2APPIDApplication IDnvarchar320
46FBRC1220TPlaceholders: Texts3APPIDApplication IDnvarchar320
TOPCommunication Channel
47ICI_CCS_MONI_SUBCCS Monitoring - subscriptions4APPIDCCS CHAR255nvarchar2550
TOPDealer Portal
48/SAPDII/CAPPIDValue Table for Application ID2APPIDApplication IDnvarchar40
49/SAPDII/CCOM_SETComponent View Settings2APPIDApplication IDnvarchar40
50/SAPDII/C_COMPIDValue Table for Component ID2APPIDApplication IDnvarchar40
TOPE-Recruiting
51HRP5133DB Table for Infotype 513327APPIDObject IDnvarchar80
TOPJapan
52PA0147HR Master Record: Infotype 014725APPIDIndicator for Personal Appraisal JPnvarchar20
53T5J14HR Pay Scale Level for Appraisal Point Criteria JPN2APPIDIndicator for Personal Appraisal JPnvarchar20
54T5J15HR Pay Scale Level for Appraisal Rank Criteria JPN2APPIDIndicator for Personal Appraisal JPnvarchar20
55T5J56HR Weighting for Appraisal Main Feature JPN2APPIDIndicator for Personal Appraisal JPnvarchar20
56T5JA2HR Weighting for Appraisal Detail Feature JPN2APPIDIndicator for Personal Appraisal JPnvarchar20
TOPPersonnel Administration
57T5JA3Appraisal-Payscale regrading constants JP2APPIDIndicator for Personal Appraisal JPnvarchar20
TOPPersonnel Time Management
58COIFTInterface to Activity Allocation12APPIDAssignment of data to an applicationnvarchar10
59HRWEB_TRANS_MSGRule Group for Customizing Tables in Web Environment2APPIDApplication IDnvarchar60
60TPT_FIELD_CATField Catalog12APPIDUsage Indicator for UI Frameworknvarchar100
61TPT_SCR_AREAScreen Area9APPIDUsage Indicator for UI Frameworknvarchar100
TOPRemote Logistics Management
62OIO_FS_APPApplication1APPIDApplication for field status handlingnvarchar20
63OIO_FS_APP_TXApplication names2APPIDApplication for field status handlingnvarchar20
64OIO_FS_FGPField status groups1APPIDApplication for field status handlingnvarchar20
65OIO_FS_FGP_TXField status group names2APPIDApplication for field status handlingnvarchar20
66OIO_FS_FLDField status screen fields1APPIDApplication for field status handlingnvarchar20
67OIO_FS_FSTField status assignments2APPIDApplication for field status handlingnvarchar20
68OIO_FS_SGPField status selection groups2APPIDApplication for field status handlingnvarchar20
69OIO_FS_SGP_TXField status selection group names3APPIDApplication for field status handlingnvarchar20
TOPUser Interface Framework
70TPTAPPUsage Indicator for UI Framework1APPIDUsage Indicator for UI Frameworknvarchar100
71TPTAPPTUsage Indicator Text for UI Framework1APPIDUsage Indicator for UI Frameworknvarchar100
72TPTCAPPUsage Indicator for UI Framework (Enhancement Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
73TPTCAPPTUsage Indicator Text for UI Framework2APPIDUsage Indicator for UI Frameworknvarchar100
74TPTGCFRMAssignment of GUI Object to Funct. Module (Enhancemnt Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
75TPTGCLYTGUI Layout (Enhancement Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
76TPTGCLYTSGUI Layout Structure (Enhancement Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
77TPTGCLYTTGUI Layout Text (Enhancement Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
78TPTGCOBJGUI Objects (Enhancement Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
79TPTGCOBJTGUI Objects Text (Enhancement Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
80TPTGCSCRAssignment of GUI Object to Subscreen (Enhancement Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
81TPTGSFRMAssignment of GUI Object to Function Module1APPIDUsage Indicator for UI Frameworknvarchar100
82TPTGSLYTGUI Layout1APPIDUsage Indicator for UI Frameworknvarchar100
83TPTGSLYTSGUI Layout Structure1APPIDUsage Indicator for UI Frameworknvarchar100
84TPTGSLYTTGUI Layout Text1APPIDUsage Indicator for UI Frameworknvarchar100
85TPTGSOBJGUI Objects1APPIDUsage Indicator for UI Frameworknvarchar100
86TPTGSOBJTText for GUI Objects1APPIDUsage Indicator for UI Frameworknvarchar100
87TPTGSSCRAssignment of GUI Object to Subscreen1APPIDUsage Indicator for UI Frameworknvarchar100
88TPTLYTUTYLayout Usage Type1APPIDUsage Indicator for UI Frameworknvarchar100
89TPTLYTUTYTLayout Usage Type1APPIDUsage Indicator for UI Frameworknvarchar100
90TPTUCLYTUIA Layout (Enhancement Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
91TPTUCLYTSUIA Layout Structure (Enhancement Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
92TPTUCLYTTText for UIA Layout (Enhancement Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
93TPTUCOBJUIA Objects (Enhancement Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
94TPTUCOBJTTexts for UIA Objects (Enhancement Layer)2APPIDUsage Indicator for UI Frameworknvarchar100
95TPTUSLYTUIA Layout1APPIDUsage Indicator for UI Frameworknvarchar100
96TPTUSLYTSUIA Layout Structure1APPIDUsage Indicator for UI Frameworknvarchar100
97TPTUSLYTTUIA Layout Text1APPIDUsage Indicator for UI Frameworknvarchar100
98TPTUSOBJUIA Objects1APPIDUsage Indicator for UI Frameworknvarchar100
99TPTUSOBJTTexts for UIA Objects1APPIDUsage Indicator for UI Frameworknvarchar100
TOPVisual Enterprise Generator
100VEG_JOBLOGJob Ids of business objects with status4APPIDApplication Typenvarchar100
101VEG_REGRegistration entries for conversion2APPIDApplication Typenvarchar100