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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

154 columns | Print definition?ERP 6.0  | TABLE_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BOFU/CLP_FLDCode list provider - White list of field names ( OBSOLETE )1TABLE_NAMETable Namenvarchar300
2/FLDQ/AD_ERRMAPTable to store error codes4TABLE_NAMETable Namenvarchar300
3/FLDQ/AD_SCR_RVWMaintain fields for address reviewer2TABLE_NAMETable Namenvarchar300
4/IWFND/I_DST_TRAstorage for transported items1TABLE_NAMETable name, 16 charactersnvarchar160
5/OPT/COA_UPLCFGTo configure the details of upload file3TABLE_NAMETable namenvarchar300
6/OPT/VIM_UPLCFGTo configure the details of upload file3TABLE_NAMETable namenvarchar300
7/OTOC/BL_T_TRCOCR Request - Trace Export Request - Data6TABLE_NAMEOCR Table Namenvarchar300
8/PERSONAS/C_F4WLPersonas: whitelist for custom f4 help1TABLE_NAMETable Namenvarchar300
9/SAPSRM/C_ET_STCust Tab to store Set type, tab name and table line type3TABLE_NAMETable Namenvarchar300
10/SDF/CSSIZINGSizing estimation details for HDB Row Store1TABLE_NAMETable namenvarchar300
11/SDF/RSSIZINGSizing estimation details for HDB Row Store1TABLE_NAMETable namenvarchar300
12/SMFND/DSF11Data Staging Framework - Data Store Sgements4TABLE_NAMEStaging Data Store Segment Table Namenvarchar160
13/SYCLO/WB005DevTool: client data table3TABLE_NAMEDevTool: Table Namenvarchar400
14CNVMBTCPARAMPIFD Concrete Parameters for a Variant5TABLE_NAMETable Namenvarchar300
15CNVMBTPARAMPIFD Parameter Definitions4TABLE_NAMETable Namenvarchar300
16CNV_TDMS_BPL_CONBPL Conflicting records during data transfer3TABLE_NAMETable Namenvarchar300
17CNV_TDMS_BP_SECBPL Conflicting records during data transfer3TABLE_NAMETable Namenvarchar300
18CTS_AIM_TRC_STMStatements used in AIM execution2TABLE_NAMETable Namenvarchar300
19DIAN_SY_FORMATSDIAN Formats Definition3TABLE_NAMETable name, 16 charactersnvarchar160
20DORDS_TABLEDBOSC-DRS: Request Process Database SQL Table8TABLE_NAME128 characternvarchar1280
21DPP_MASKData Privacy: Customizing table for masking3TABLE_NAMEPersonal Data Destruction: Table Namenvarchar160
22DPP_MASK_RSTRCTData Privacy: Restriction Table for Masking2TABLE_NAMEPersonal Data Destruction: Table Namenvarchar160
23FARR_C_CONFLI_EXExcluding field to conflict contract3TABLE_NAMETable name, 16 charactersnvarchar160
24GRFNFLDDBDB Configurable Fields3TABLE_NAMETable Namenvarchar300
25HRSFI_C_PARAMSParameters6TABLE_NAMEName of Referenced Tablenvarchar300
26HRSFI_RCT_PARAMSParameters6TABLE_NAMEName of Referenced Tablenvarchar300
27IUUC_KB_AIM_TABLTables processed by AIMs8TABLE_NAMETable Namenvarchar300
28IUUC_KB_BUF_INVBuffer Tables and Invalidations2TABLE_NAMETable Namenvarchar300
29IUUC_KB_SPLIT_FLIUUC: Knowl.Base Split fields for parallel processing2TABLE_NAMETable Namenvarchar300
30IUUC_KB_XPRA_TABTables processed by XPRAs4TABLE_NAMETable Namenvarchar300
31IUUC_REPL_FIELDFieldname table for table creation / replication / init load1TABLE_NAMETable Namenvarchar300
32IUUC_REPL_HEADHeader table for table creation / replication / init load1TABLE_NAMETable Namenvarchar300
33IUUC_RS_ORDERTable to keep the history for all actions from RS_ORDER2TABLE_NAMETable Namenvarchar300
34IUUC_RS_STATUSTable to keep the history for all actions from RS_STATUS2TABLE_NAMETable Namenvarchar300
35LTR_ATM_TAB_TABLSLO: Tables contained in TABU Atoms1TABLE_NAMETable Namenvarchar300
36LTR_BO_STRLTR: Business Object - Internal Structure3TABLE_NAMETable Namenvarchar300
37LTR_BO_STR_TLTR: Business Object - Internal Structure3TABLE_NAMETable Namenvarchar300
38LTR_DELIM_MIGROBLTR: Migration Objects7TABLE_NAMETable Namenvarchar300
39LTR_DESTTYPE_FLDLTR: Home Destination Setting (L table)3TABLE_NAMETable Namenvarchar300
40LTR_DESTTYPE_SHPLTR: Home Destination Setting (L table)3TABLE_NAMETable Namenvarchar300
41LTR_DESTTYPE_TABLTR: Home Destination Setting (L table)3TABLE_NAMETable Namenvarchar300
42LTR_KEYC_USGLTR: Transparent Key Field Usages2TABLE_NAMETable Namenvarchar300
43LTR_PRESELLTR: Preselection Steps8TABLE_NAMETable Namenvarchar300
44LTR_PRESEL_CONDPreselection conditions3TABLE_NAMETable Namenvarchar300
45MDS_RES_HEADERResult table for table analysis (Header)4TABLE_NAMETable Namenvarchar300
46MDS_RES_OBJECTResult table for table analysis (Object)4TABLE_NAMETable Namenvarchar300
47MDS_RES_TRKORRResult table for table analysis (Transport)4TABLE_NAMETable Namenvarchar300
48PIQC_DB_ALIAS_CDefine Customer-Specific Table Aliases4TABLE_NAMETable Namenvarchar300
49PIQC_DB_ALIAS_SDisplay Standard Table Aliases4TABLE_NAMETable Namenvarchar300
50REFXCN_TABLEKEYKey in RECN table2TABLE_NAMEHeader table namenvarchar300
51RSSMA_CUBE_FACThelper table3TABLE_NAMETable Namenvarchar300
52RSSMA_CUBE_FACTShelper table3TABLE_NAMETable namenvarchar2560
53SIMDQ_INP_FILTERIM in HANA Filter for input3TABLE_NAMEIM in HANA table model table namenvarchar300
54SIMDQ_INP_MAPIM in HANA input map4TABLE_NAMEIM in HANA table model table namenvarchar300
55SIMDQ_MOD_COLIM in HANA table model column definition5TABLE_NAMEIM in HANA table model table namenvarchar300
56SIMDQ_OUTP_MAPIM in HANA map of table model field to transform output fld4TABLE_NAMEIM in HANA table model table namenvarchar300
57SLIN_LOGGeneric SLIN Log Table3TABLE_NAMETable Namenvarchar300
58SNWD_EPM_SNAPSEPM: Table to hold snapshots (backups) of generated data11TABLE_NAMEnvarchar300
59SWLT_STATIC_DStatic findings cache19TABLE_NAMETable names (comma separated)nvarchar1710
60SWLT_TABLE_MDSWLT: Metadata for tables2TABLE_NAMETable Namenvarchar160
61T77PAOPARAMSParameters6TABLE_NAMEName of Referenced Tablenvarchar300
62TFMCA_TTF_LOOKUPLookup table for generated tables4TABLE_NAMETable name, 16 charactersnvarchar160
63ZTAB_CS_SIZEStatistics collection for HDB Column Store1TABLE_NAMETable Namenvarchar300
64ZTAB_RS_SIZEStatistics collection for HDB Row Store1TABLE_NAMETable Namenvarchar300
65T7PIQADV_CNTXTYPAdvising Context Type4TABLE_NAMEName of a structurenvarchar300
TOPBasic Functions
66WTMIG_PROT1Withholding Tax Changeover: Global Log Data4TABLE_NAMEName of DDIC Tablenvarchar100
67WTMIG_PROT2Withholding Tax Changeover: Detailed Log Data4TABLE_NAMEName of DDIC Tablenvarchar100
68WTMIG_TABKEYWithholding Tax Changeover: Keys of Table Entries Added3TABLE_NAMEName of DDIC Tablenvarchar100
TOPBRFplus - ABAP-Based Business Rules
69FDT_EXPR_2200FDT: Expression - DB Lookup4TABLE_NAMETable Namenvarchar300
70FDT_EXPR_2200AFDT: Expression - DB Lookup4TABLE_NAMETable Namenvarchar300
71FDT_EXPR_2200SFDT: Expression - DB Lookup3TABLE_NAMETable Namenvarchar300
72FDT_EXPR_2200TFDT: Expression - DB Lookup3TABLE_NAMETable Namenvarchar300
TOPBusiness Partner
73BPCE_MOOBSOLETE2TABLE_NAMETable Namenvarchar300
74BPCE_MO_CDOCOBSOLETE2TABLE_NAMETable Namenvarchar300
75BPCE_MO_TXTOBSOLETE2TABLE_NAMETable Namenvarchar300
76CCXO_POPersistence Object Configuration (Customer)6TABLE_NAMETable Namenvarchar300
77CEXO_POPersistence Object Configuration6TABLE_NAMETable Namenvarchar300
TOPBusiness Rule Framework
78TBRF181C(Obsolete) BRF: Classes for Transport of BRF3TABLE_NAMETable Namenvarchar300
TOPCCMS Database Monitors for Oracle
79DBAGRPLookup Table Operation Group Tables5TABLE_NAMETable filled by database operationnvarchar300
TOPCentral Part of Product Master
80COMC_ALTID_FIELDData for Alternative Product ID Fields3TABLE_NAMETable Name for Alternative ID Fieldsnvarchar300
81COMC_CRD_GEN_BW0CRM CRD: Relevant Fields of the Link and Master Data Table3TABLE_NAMETable Namenvarchar300
82COMC_CRD_GEN_BWCCRM CRD: Compound for Fields from Product Extensions2TABLE_NAMETable Namenvarchar300
83COMC_CRD_GEN_BWECRM CRD: Relevant Fields of the Object Tables3TABLE_NAMETable Namenvarchar300
84COMC_CRD_GEN_BWHCRM CRD: Tables of an Object3TABLE_NAMETable Namenvarchar300
85COMC_CRD_GEN_BWICRM CRD: Relevant Fields of the Link and Master Data Table2TABLE_NAMETable Namenvarchar300
86COMC_CRD_GEN_BWTCRM CRD: Application Tables2TABLE_NAMETable Namenvarchar300
TOPClaims Management
87ICL_CCONTEXT_FLDContext-Dependent FS-CM Data Selection - Fields3TABLE_NAMEDatabase Table of Claims Management Systemnvarchar300
88ICL_CCONTEXT_FLTContext-Dependent FS-CM Data Selection - Tables3TABLE_NAMEDatabase Table of Claims Management Systemnvarchar300
TOPClient-System Adapter
89MDMGXC1MDM Check Table Extractor: Ports and Extraction Information5TABLE_NAMETable Namenvarchar300
TOPContract Accounts Receivable and Payable
90DFKKCUST_SHORTData Extract: Customizing3TABLE_NAMETable Namenvarchar300
91DFKK_BRF120BRF: Parameter for Initialization of Buffer Elements10TABLE_NAMEName of Structure/Table in DDICnvarchar300
92TFKKBRFBUFFERReserved Buffer Elements5TABLE_NAMEName of Structure/Table in DDICnvarchar300
93TFKK_EXTR_CUSTExtracts: Customizing1TABLE_NAMETable Namenvarchar300
94TFKK_EXTR_CUSTFExtracts: Customizing, Field Assignment1TABLE_NAMETable Namenvarchar300
TOPData Mining
95RSDMTA_IM_MD_NEUAvailable Mining Models2TABLE_NAMETable Namenvarchar300
96RSDMTA_IM_MODELSAvailable Mining Models2TABLE_NAMETable Namenvarchar300
TOPData Replication Framework
97DRFD_APPL_FILT_CFilterCriteria7TABLE_NAMEDRF Table Namenvarchar300
TOPDB2 Universal Database for UNIX NT
98DB6PMHSTDB6: Snapshot Table History5TABLE_NAMEDB6: General identifiernvarchar200
99DB6_RESET_DATADB6: Datacluster for monitor reset data4TABLE_NAMEDB6: long table namenvarchar1280
TOPDSD Connector
100/DSD/ME_MAP_RULEDSD-Connector: Define Mapping Rules9TABLE_NAMEDSD Connector: Table Namenvarchar160
TOPEasy Enhancement Workbench
101AXT_CAT_DICT_KEYCatalogue object dictionnary entry key9TABLE_NAMETable Namenvarchar300
102AXT_OBJECTS_ILExtensibility GenIL objects9TABLE_NAMETable Namenvarchar300
103AXT_RUN_BO_PARTTExt. runtime access: Table registration for BO and Parts3TABLE_NAMETable Namenvarchar300
TOPEEW Services
104OXT_GENTABHDROXT Object Template Description4TABLE_NAMETable Namenvarchar300
TOPFast Search Infrastructure
105SFSG_Q_TABLEQuery Tables4TABLE_NAMETable Namenvarchar300
TOPFoundation for EHS Management
106EHFNDC_FW_BI_CDTTables for Change Document Evaluation3TABLE_NAMETable Name for Change Document Evaluationnvarchar300
TOPGeneral
107LWMHR_C_PARAMSParameters6TABLE_NAMEName of referenced tablenvarchar300
TOPGeneric Interaction Layer
108CRMC_TBLOBJ_MAPMapping Table for Simple Table Objects2TABLE_NAMETable name, 16 charactersnvarchar160
TOPInformation Retention Manager
109IRM_T_BS_FLD_BVDIRM: Fields with Value Determination with Callback3TABLE_NAMEIRM for BS: Name of a Source Tablenvarchar300
110IRM_T_BS_FLD_DVDIRM: Fields with Direct Value Determination3TABLE_NAMEIRM for BS: Name of a Source Tablenvarchar300
111IRM_T_BS_KFD_BVDIRM: Explicit Inheritance - Inst. Determination in Callback2TABLE_NAMEIRM for BS: Source Table - Expl. Inher. Inst. Determinationnvarchar300
112IRM_T_BS_KOW_BVDIRM: Determination of Own Instance Key with Callback2TABLE_NAMEIRM for BS: Source Table - Own Instance Key Determinationnvarchar300
113IRM_T_BS_STT_BVDIRM: Start Times with Value Determination in Callback3TABLE_NAMEIRM for BS: Name of a Source Tablenvarchar300
114IRM_T_BS_STT_DVDIRM: Start Times with Direct Value Determination3TABLE_NAMEIRM for BS: Name of a Source Tablenvarchar300
115SILM_VIEW_KEYView Definition: Unique Key for Result Structure3TABLE_NAMETable Namenvarchar300
116SILM_VIEW_TABView Definition: Tables (Data Source)3TABLE_NAMETable Namenvarchar300
TOPIRM Run Time
117LRM_T_BS_FLD_BVDFields with Value Determination with Callback3TABLE_NAMEName of a Source Tablenvarchar300
118LRM_T_BS_FLD_DVDFields with Direct Value Determination3TABLE_NAMEName of a Source Tablenvarchar300
119LRM_T_BS_KFD_BVDDetermine Inheriting Instances via Callback2TABLE_NAMESource Table for Determining the Bequeathing Instancesnvarchar300
120LRM_T_BS_KOW_BVDDetermination of BOR Key with Callback2TABLE_NAMESource Table for Determining the Object Instance Keynvarchar300
121LRM_T_BS_STT_BVDStart Times with Value Determination in Callback3TABLE_NAMEName of a Source Tablenvarchar300
122LRM_T_BS_STT_DVDStart Times with Direct Value Determination3TABLE_NAMEName of a Source Tablenvarchar300
123LRM_T_BS_TOValue Determination for Time Offset3TABLE_NAMEName of a Source Tablenvarchar300
TOPMarketing Retail Network
124OIFBRD2SPA/GPA parameters supported for partner link dialog4TABLE_NAMETable Namenvarchar300
125OIFOLD2SPA/GPA parameters supported for link dialog3TABLE_NAMETable namenvarchar300
126OIFXBRD2Fields supp. as SPA/GPA parameters for partner link dialog1TABLE_NAMETable Namenvarchar300
TOPMonitoring
127CSMNUDATACSM CEN CCMS Data to be Processed3TABLE_NAMESystem GUID for ABAP Systems or Other Systemsnvarchar320
TOPNetWeaver Enterprise Search
128ESH_OM_TRANSPORTTable for transport of template and models6TABLE_NAMEName of ABAP Dictionary Objectnvarchar300
TOPOracle Database Monitors
129ORAINDINFOInformation About the Storage Quality of the Indexes6TABLE_NAMEnvarchar300
130ORA_ISQ_DETAILIndex Storage Quality - Objects of a Workingset4TABLE_NAMETable Namenvarchar300
131ORA_ISQ_HISTORYIndex Storage Quality - Objectshistory Data9TABLE_NAMETable Namenvarchar300
TOPPackage Tools
132AKB_INDXObsolete: Temporary BCB Data Storage2TABLE_NAMEnvarchar200
TOPPerformance Monitors TCC
133ORA_DBA_TABLESCopy of DBA_TABLES (currently not provided with snapshots)3TABLE_NAMEOracle monitoring: table namenvarchar300
TOPProduction Orders
134NAVP_SGP_MATCHSET/GET Parameter Matching for the Function of a Profile9TABLE_NAMELVC tab namenvarchar300
TOPPublic Sector Contract Accounts Receivable and Payable
135DFMCA_BRF120Text Name and Text ID for Additional Item10TABLE_NAMEName of Structure/Table in DDICnvarchar300
136DFMCA_BRF140Table for Reserved Structure IDs4TABLE_NAMEName of Structure/Table in DDICnvarchar300
TOPRoyalty Reporting
137OIUREP_ROY_LOGChanges to master data for reporting2TABLE_NAMETable Name for the master data table for Royalty Reportingnvarchar160
TOPRuntime WorkbenchMonitoring
138SXIPERF_REG_TABPerformance Regression - Run Tables1TABLE_NAMEnvarchar200
TOPService Data Download
139/SDF/TAB_INFOTable information1TABLE_NAMEnvarchar600
TOPServices
140FINB_RT_TABRuntime Tables5TABLE_NAMEName of a Runtime Tablenvarchar300
141FINB_RT_TAB_FLDRuntime Tables5TABLE_NAMEName of a Runtime Tablenvarchar300
142FINB_RT_TKEYKey of Runtime Tables5TABLE_NAMEName of a Runtime Tablenvarchar300
143FINB_RT_TKEY_FLDKey of Runtime Tables5TABLE_NAMEName of a Runtime Tablenvarchar300
TOPSoftware Agent Framework
144EIC_SAF_KB_BORknowledge base and BOR definition5TABLE_NAMEDatabase Table Namenvarchar160
TOPStorage and Retention Service
145DAS_ID_LEVELSILM SRS: Maximum Assigned IDs2TABLE_NAMEName of a DAS Tablenvarchar300
TOPTalent Management
146T77TMCPARAMSParameters6TABLE_NAMEName of Referenced Tablenvarchar300
TOPTraders and Schedulers Workbench
147OIJ_RU_CARRFIELDDefine Fields for Carrier Reference Data4TABLE_NAMETable Namenvarchar160
TOPTransaction Manager
148TBSK_SYSTEM_KEYSCurrent System Key per Table2TABLE_NAMETable name, 16 charactersnvarchar160
TOPTransaction Tax Engine
149TTE_CONFIG_TABLEConfiguration table used for copy1TABLE_NAMEOnline Table Namenvarchar160
150TTE_COPY_CONFIGConfiguration table used for copy1TABLE_NAMEOnline Table Namenvarchar160
TOPUse Subcomponents
151SOMFSAPoffice: Address tables for fax screen1TABLE_NAMESAPoffice: Name of the table to be searchednvarchar100
152SOMFTSAPoffice: SOMF language table2TABLE_NAMESAPoffice: Name of the table to be searchednvarchar100
TOPVendor Master
153CDATAChange Data3TABLE_NAMETable Namenvarchar300
TOPWeb Service and SOAP - ABAP
154SRT_TRC_COUNTERtable for counters1TABLE_NAMEnvarchar200