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

35 columns | Print definition?ERP 6.0  | CHECKTABLE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_A_1_TABFSelection of Object Type TABLE (TABF) Master information12CHECKTABLECheck table name of the foreign keynvarchar300
2CNVMBTTABSTRUCField list of tables for file transfer11CHECKTABLETable Namenvarchar300
3DD03NDDD: Attributes of a Node of a Structured Object8CHECKTABLECheck table name of the foreign keynvarchar300
4DDREPLICREFDD: Information on Metadata Transfer: Fields7CHECKTABLECheck table name of the foreign keynvarchar300
5DDREPLINTABFDDD: Nametab Field Structure28CHECKTABLECheck table name of the foreign keynvarchar300
6DDXTF_CONV_UCNametab Feldstruktur für verzögertes Schreiben27CHECKTABLEPrüftabellenname des Fremdschlüsselsnvarchar300
7DDYTF_CONV_UCUsed during UCMIG within DMO of SUM27CHECKTABLECheck table name of the foreign keynvarchar300
8IUUC_DD_SYNC_NTFSystem synchronization: Nametab field data31CHECKTABLECheck table name of the foreign keynvarchar300
9TKEA2CO-PA: Control tab. for managing generated derivation tab.6CHECKTABLECheck table name of the foreign keynvarchar300
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
10DD03LTable Fields9CHECKTABLECheck table name of the foreign keynvarchar300
11DD08LR/3 DD: relationship definitions5CHECKTABLECheck table name of the foreign keynvarchar300
12DDXTFNametab Field Structure for Delayed Writing27CHECKTABLECheck table name of the foreign keynvarchar300
TOPApplication Framework
13MDG_MDF9101Local Data Elements (Storage Only)2CHECKTABLETable Namenvarchar300
14MDG_MDF9102Local Domains (Storage Only)2CHECKTABLETable Namenvarchar300
TOPBusiness Partner
15BPUM_DOMConversion: List of Domains to be Converted5CHECKTABLECheck table name of the foreign keynvarchar300
TOPCross-Application Components
16/IXOS/DC_TAMAGeneral Doculink administraton data for data source9CHECKTABLETable Namenvarchar300
TOPCustomizing Tools Techniques
17TCTM_ATTRTable of Attributes for Context Management2CHECKTABLETable Namenvarchar300
TOPData Conversion
18DMC_FIELDDMC: Data Field of a Structure28CHECKTABLECheck table of the componentnvarchar300
TOPData Staging
19RSMONICTABMonitor IC table5CHECKTABLEInfoCubenvarchar300
TOPHR Information Systems
20T770UText field information on table fields8CHECKTABLETable Namenvarchar300
TOPLegacy System Migration Workbench
21/SAPDMC/LSGBDCBI Name: "Code"18CHECKTABLETable Namenvarchar300
TOPMaster Data Framework
22UGMD9101FIN Master Data: Local Data Elements (Storage Only)2CHECKTABLETable Namenvarchar300
23UGMD9102FIN Master Data: Local Domains (Only Folder)2CHECKTABLETable Namenvarchar300
TOPTreasury
24CML_MIG_BUFFERTable DDIC buffering (migration)10CHECKTABLETable Namenvarchar300
TOPUpgrade - General
25DDMTFNametab Field Structure for Delayed Writing27CHECKTABLECheck table name of the foreign keynvarchar300
26DDMTF_ISUNametab Field Structure for Delayed Writing27CHECKTABLECheck table name of the foreign keynvarchar300
27DDMTF_SAVNametab Feldstruktur für verzögertes Schreiben27CHECKTABLEPrüftabellenname des Fremdschlüsselsnvarchar300
28DDXTF_SAVNametab Feldstruktur für verzögertes Schreiben27CHECKTABLEPrüftabellenname des Fremdschlüsselsnvarchar300
29DDXTF_SHDNametab Feldstruktur für verzögertes Schreiben27CHECKTABLEPrüftabellenname des Fremdschlüsselsnvarchar300
30DDXTF_STDNametab Feldstruktur für verzögertes Schreiben27CHECKTABLEPrüftabellenname des Fremdschlüsselsnvarchar300
31DDYTFSubstitution Nametab (shadow-shadow-nametab for DDXTF)28CHECKTABLE4.0 version of TABNAME (name extension)nvarchar300
TOPUpgrade Tools
32ICNV31LNametab for Incremental Conversion29CHECKTABLEnvarchar300
TOPUser and Authorization Management
33AUTHXAuthorization Fields (Maintain with SU20)3CHECKTABLETable Namenvarchar300
34AUTH_FLDINFO_TMPAuthorization fields: technical info from dictionary6CHECKTABLETable Namenvarchar300
TOPWorkbench Utilities
35SPAR_NTDBParameter Storage: Persistent Nametab Container13CHECKTABLETable Namenvarchar300