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

77 columns | Print definition?ERP 6.0  | KEYFLAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/CSSIZINGSizing estimation details for HDB Row Store4KEYFLAGIdentifies a primary key fieldnvarchar10
2/SDF/RSSIZINGSizing estimation details for HDB Row Store3KEYFLAGIdentifies a primary key fieldnvarchar10
3CNVCMIS_A_1_ENQDENQU Data (FIELDNAMES)11KEYFLAGFlag for field belonging to key areanvarchar10
4CNVCMIS_A_1_MCOFMCOF type Repository Analysis11KEYFLAGFlag for field belonging to key areanvarchar10
5CNVCMIS_A_1_TABFSelection of Object Type TABLE (TABF) Master information10KEYFLAGIdentifies a key field of a tablenvarchar10
6CNVCMIS_A_1_VIEFVIEF type Repository Analysis11KEYFLAGFlag for field belonging to key areanvarchar10
7CNVCMIS_A_20_DICTable fields for Cross-Client Customizing Comparison8KEYFLAGTable Key Fieldnvarchar10
8CNVMBTTABSTRUCField list of tables for file transfer9KEYFLAGIdentifies a key field of a tablenvarchar10
9CNVTDMS_BP_DATAStore table and fields data from remote (sender) system4KEYFLAGIdentifies a key field of a tablenvarchar10
10CNV_20308_DFDATALog for Deviations5KEYFLAGIndicator: Key fieldnvarchar10
11CNV_20308_FLDCATField Catalog for Download6KEYFLAGIdentifies a key field of a tablenvarchar10
12CNV_TDMS_16_DCMPDDIC Comparison results8KEYFLAGIdentifies a key field of a tablenvarchar10
13DD03NDDD: Attributes of a Node of a Structured Object6KEYFLAGIdentifies a key field of a tablenvarchar10
14DDREPLICNVDATADD: Information on Metadata Transfer: Fields - Data Convers.7KEYFLAGIdentifies a key field of a tablenvarchar10
15DDREPLINDATADD: Information on Metadata Transfer: New Fields7KEYFLAGIdentifies a key field of a tablenvarchar10
16HRP5342DB Table for Infotype 534227KEYFLAGIdentifies a key field of a tablenvarchar10
17IUUC_REPL_FIELDFieldname table for table creation / replication / init load4KEYFLAGIdentifies a key field of a tablenvarchar10
18IUUC_RL_TABSTRstructural historical information for tables(Transp,Cluster)13KEYFLAGIdentifies a key field of a tablenvarchar10
19MBO_FIELDBO - Table to maintain key information4KEYFLAGIdentifies a key field of a tablenvarchar10
20NWS_EXT_MAP_DATAMapping Data Extract ByD9KEYFLAGIdentifies a key field of a tablenvarchar10
21SXVIEW_MOCK_COLXView Mock Data: Columns5KEYFLAGFlag: field belongs to primary keynvarchar10
22TKEA2CO-PA: Control tab. for managing generated derivation tab.4KEYFLAGIdentifies a key field of a tablenvarchar10
23ZTAB_CS_SIZEStatistics collection for HDB Column Store4KEYFLAGIdentifies a key field of a tablenvarchar10
24ZTAB_RS_SIZEStatistics collection for HDB Row Store3KEYFLAGIdentifies a key field of a tablenvarchar10
TOPAccounting Engine
25/EACC/PLIMA_CONFConfigurations5KEYFLAGKey per Levelnvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
26DD03LTable Fields6KEYFLAGIdentifies a key field of a tablenvarchar10
27DD16SR/3 DD: SQL table fields6KEYFLAGIdentifies a key field of a tablenvarchar10
28DD27SFields in an Aggregate (View, MC Object, Lock Object)8KEYFLAGFlag for field belonging to key areanvarchar10
29TSPDDTable, Old SAP Version5KEYFLAGIdentifies a key field of a tablenvarchar10
30TSPDD2Table, Old SAP Version5KEYFLAGIdentifies a key field of a tablenvarchar10
TOPArchive Information System
31AIND_STR3Archive information structure: field catalog5KEYFLAGIndicator "Field is in the key"nvarchar10
TOPBusiness Partner
32BPUMConversion: Tables/Fields to be Converted5KEYFLAGIdentifies a key field of a tablenvarchar10
TOPChange Documents
33CDSOLMIG_DDChange Document Objects to be Migrated11KEYFLAGIdentifies a key field of a tablenvarchar10
TOPCondition Technique
34/SAPCND/T681ECondition Table Structure Field4KEYFLAG'X' .. Search Field, ' ' .. No Search Fieldnvarchar10
35/SAPCND/T688CFields from Condition Tables Sorted Acc. To Dependency20KEYFLAGBoolean Variablenvarchar10
TOPCross-Application Components
36/IXOS/DC_TACAAdministrator maintenance for Editing10KEYFLAGIdentifies a key field of a tablenvarchar10
37/IXOS/DC_TADAAdministrator maintenance for Details10KEYFLAGIdentifies a key field of a tablenvarchar10
38/IXOS/DC_TADUDetail user maintenance11KEYFLAGIdentifies a key field of a tablenvarchar10
39/IXOS/DC_TAHAHitlist Administrator maintenance (hierachy/separat)24KEYFLAGIdentifies a key field of a tablenvarchar10
40/IXOS/DC_TAHUHitlist User maintenance (hierachy/separat)26KEYFLAGIdentifies a key field of a tablenvarchar10
41/IXOS/DC_TAIAAdministrator maintenance for Creating10KEYFLAGIdentifies a key field of a tablenvarchar10
42/IXOS/DC_TAMAGeneral Doculink administraton data for data source34KEYFLAGIdentifies a key field of a tablenvarchar10
43/IXOS/DC_TASASelectionscreen Administrator maintenance16KEYFLAGIdentifies a key field of a tablenvarchar10
44/IXOS/DC_TASUSelectionscreen user maintenance17KEYFLAGIdentifies a key field of a tablenvarchar10
TOPData Basis
45RSBOHFIELDSFields of the Open Hub Destination6KEYFLAGOpen Hub: Indicator for Semantic Keynvarchar10
46RSBTRANSFIELDTarget Structure InfoObjects for Open Hub Transformation3KEYFLAGIdentifies a key field of a tablenvarchar10
47RSDODSOIOBJInfoObject in DataStore5KEYFLAGIdentifies a key field of a tablenvarchar10
TOPData Conversion
48DMC_FIELDDMC: Data Field of a Structure6KEYFLAGIdentifies a key field of a tablenvarchar10
TOPData Staging
49RSKSFIELDNEWFields for New InfoSource6KEYFLAGIdentifies a key field of a tablenvarchar10
50RSTRANFIELDMapping of Rule Parameters - Structure Fields10KEYFLAGIdentifies a key field of a tablenvarchar10
51RSTSODSFIELDFields for the Operational Data Store5KEYFLAGIdentifies a key field of a tablenvarchar10
TOPDirectory
52DBOBJComposition of Hybrid Objects4KEYFLAGSwitch (yes / no)nvarchar10
TOPEEW Services
53OXT_GENTABLINOXT Object Template Description8KEYFLAGFlag for Key Fieldnvarchar10
TOPFinancials Basis
54UGR31008FIN Master Data: Dummy Field Names with Properties13KEYFLAGIdentifies a key field of a tablenvarchar10
55UGR31021FIN Master Data: Buffer Table for DataSource Properties16KEYFLAGIdentifies a key field of a tablenvarchar10
56UGR31022FIN Master Data: Buffer Table f.Fields of Extract Structures11KEYFLAGIdentifies a key field of a tablenvarchar10
TOPForms
57TMETADIMFLD_02HR Forms: MetaFields4KEYFLAGIdentifies a key field of a tablenvarchar10
TOPI18N Unicode
58UMGNTCD6List of offsets and lengths5KEYFLAGIdentifies a key field of a tablenvarchar10
TOPIncentive and Commission Management ICM
59TCACS_ADDFIELDSObsolete - replaced by TCACS_DESFIELDS3KEYFLAGIdentifies a key field of a tablenvarchar10
60TCACS_CUSTFIELDSObsolete - replaced by TCACS_ADDFIELDS4KEYFLAGIdentifies a key field of a tablenvarchar10
61TCACS_DESFIELDSAdditional Fields for Generated Objects5KEYFLAGIdentifies a key field of a tablenvarchar10
62TCACS_OBJSETSNumber of structures that create alternatives (see OBJREL)3KEYFLAGIdentifies a key field of a tablenvarchar10
TOPLocal Currency Changeover
63EWUFZField-related control6KEYFLAGIdentifies a key field of a tablenvarchar10
64EWUFZSFField-related control6KEYFLAGIdentifies a key field of a tablenvarchar10
TOPMetadata Repository
65RSQFOBJField Objects in the InfoSet8KEYFLAGGeneral Type (InfoSet)nvarchar10
TOPPension fund Netherlands
66T5NKCTariff Calculation: Tabeltype kolom5KEYFLAGKeyveldnvarchar10
67T5NKRActuarial File: Actuarieel bestandstype kolom8KEYFLAGKeyveldnvarchar10
TOPProduct Structure Browser
68USRLISTPROFILEVariable List Definition in PDM Environment9KEYFLAGIdentifies a key field of a tablenvarchar10
TOPRemaining Beverage - Obsolete Objects
69/BEV3/CHTABLERenamed Tables and Fields4KEYFLAGIdentifies a key field of a tablenvarchar10
TOPSAP NetWeaver Mobile - Use subcomponents
70MEREP_405Mapping Result for Synchronization (BAPI)12KEYFLAGKey Flagnvarchar10
TOPService Data Download
71/BDL/IFFIELD/BDL/SDCC: fiels, dataelements and domains of table7KEYFLAGnvarchar10
72BDLIFFIELDBDL SDCC: Table's Fields, Data Elements, Domains7KEYFLAGnvarchar10
TOPTable Maintenance Tool
73FIELDDIFTBMemory table Field_dif13KEYFLAGIdentifies a key field of a tablenvarchar10
74SDMEDPVFDME: OBSOLETE Dialog Pool Component 'View' (Fields)5KEYFLAGDME: Key Attributenvarchar10
TOPTreasury
75CML_MIG_BUFFERTable DDIC buffering (migration)35KEYFLAGIdentifies a key field of a tablenvarchar10
TOPUser and Authorization Management
76AUTH_FLDINFO_TMPAuthorization fields: technical info from dictionary31KEYFLAGIdentifies a key field of a tablenvarchar10
TOPWorkbench Utilities
77SPAR_NTDBParameter Storage: Persistent Nametab Container38KEYFLAGIdentifies a key field of a tablenvarchar10