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

30 columns | Print definition?ERP 6.0  | FLAG5

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DDREPLINTABHDDD: Nametab Header Structure (for Temporary Storage)21FLAG5Flag of length 1 byte for table attributesvarbinary10
2DDXTT_CONV_UCNametab Headerstruktur für verzögertes Schreiben20FLAG5Flag der Länge 1 Byte für Tabelleneigenschaftenvarbinary10
3DDYTT_CONV_UCUsed during UCMIG within DMO of SUM20FLAG5Flag of length 1 byte for table attributesvarbinary10
4IUUC_DD_SYNC_NTHSystem synchronization: Nametab header fields24FLAG5Flag of length 1 byte for table attributesvarbinary10
5T056SInterest scale interest terms (acct bal.int.calc.)13FLAG5Interest rates depend on total amountnvarchar10
6T056UControl table for calculation of interest on arrears13FLAG5Only calculate interest on debit itemsnvarchar10
TOPABAP Authorization and Role Management
7TOBJVORFLGFlags for Authorization Objects6FLAG5Customized ('C') or standard menu ('S') flagnvarchar10
8USERS_ORGUser settings8FLAG5Customized ('C') or standard menu ('S') flagnvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
9DDXTTNametab header structure for delayed writing20FLAG5Flag of length 1 byte for table attributesvarbinary10
TOPAerospace Defence Industry Solution
10DIWPS_CUSTReallocation: Customizing7FLAG5Reallocation: General Flagnvarchar10
TOPCommunication Services Mail, Fax, SMS, Telephony
11SXADMINTABSAPconnect and SAPphone: Administration25FLAG5SAPconnect: Selectionnvarchar10
TOPKANBAN
12PKUSRUser Settings for Kanban Transactions12FLAG5Single-Character Indicatornvarchar10
TOPMaster Data
13EWATSPCMPNTSFService Frequency17FLAG5Indicatorsnvarchar10
TOPPersonnel Administration
14T5H5DHelp table to infotype p044113FLAG5Flag to help tablenvarchar10
TOPRole Generator
15/ISDFPS/AGR_DEFRole Definitions for the Role Generator18FLAG5General Flagnvarchar10
TOPSAP Ambulatory Care Management
16N3DAFLAGACM: DALE-UV Einstellungen pro Dokument10FLAG5Feld zum Ankreuzennvarchar10
TOPTranslation Tools
17INDTABSShort Text Conversion: Table Attributes14FLAG5Single-Character Indicatornvarchar10
18TRMINTLink Table of Proposal Pool32FLAG5Flag 5 for Proposal Poolnvarchar10
TOPUpgrade - General
19DDMTTNametab header structure for delayed writing20FLAG5Flag of length 1 byte for table attributesvarbinary10
20DDMTT_ISUNametab header structure for delayed writing20FLAG5Flag of length 1 byte for table attributesvarbinary10
21DDMTT_SAVNametab Headerstruktur für verzögertes Schreiben20FLAG5Flag der Länge 1 Byte für Tabelleneigenschaftenvarbinary10
22DDXTT_SAVNametab Headerstruktur für verzögertes Schreiben20FLAG5Flag der Länge 1 Byte für Tabelleneigenschaftenvarbinary10
23DDXTT_SHDNametab Headerstruktur für verzögertes Schreiben20FLAG5Flag der Länge 1 Byte für Tabelleneigenschaftenvarbinary10
24DDXTT_STDNametab Headerstruktur für verzögertes Schreiben20FLAG5Flag der Länge 1 Byte für Tabelleneigenschaftenvarbinary10
25DDYTTSubstitution Nametab (shadow-shadow-nametab for DDXTT)22FLAG5Flag of length 1 byte for table attributesvarbinary10
TOPUpgrade Tools
26ICNV30LNametabs for Incremental Conversion21FLAG5varbinary10
TOPUse Subcomponents
27SOFMSAPoffice: Folder contents34FLAG5Search of private or shared foldersnvarchar10
28SOSUSAPoffice: Substitute for a user53FLAG5Substitute: Flag 5nvarchar10
TOPWaste Management
29EHSWAT_USERUser-Defined Settings8FLAG5General Flagnvarchar10
30EWAOBJHService Frequency -> Services (History for EWAOBJ)43FLAG5Indicatorsnvarchar10