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

152 columns | Print definition?ERP 6.0  | DATASOURCE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/X104Indexing field mapping for IDOC processing4DATASOURCEField Value Determination Typenvarchar10
2/OPT/Y104Indexing field mapping for IDOC processing4DATASOURCEField Value Determination Typenvarchar10
3/OPT/Z104Indexing field mapping for IDOC processing4DATASOURCEField Value Determination Typenvarchar10
4/OTEB/T_XIM_UMaintain DocuLink attribute object dependent user-exits4DATASOURCEAttribute objectnvarchar120
5/OTEI/T_NODEIM: Definitions5DATASOURCEAttribute objectnvarchar120
6/OTEI/T_UMaintain attribute object dependent user-exits4DATASOURCEAttribute objectnvarchar120
7/OTEI/T_XIM_UXIM: Dependent Userexits4DATASOURCEAttribute objectnvarchar120
8BBP_BW_DELTAMGNTBBP BW: Data Extraction, Table for Delta Management2DATASOURCEDataSource (OSOA/OSOD)nvarchar300
9CNVTDMSBW_PSATDMS 4.0: Table to store PSA tablenames4DATASOURCE30 Charactersnvarchar300
10DBESTA_BWTRIGOrder for Updating BW Sales Statistics2DATASOURCEAdditional Data Source of Invoicingnvarchar300
11DBESTA_BWTRIGESingle Order for Updating BW Sales Statistics2DATASOURCEAdditional Data Source of Invoicingnvarchar300
12FUCN_DSRUN_STAGEChina Growth Reporting: Run Staging Table4DATASOURCEnvarchar300
13GRFNEXTRACTLOGExtraction log2DATASOURCEDataSource (OSOA/OSOD)nvarchar300
14RSBPCB_ACTION_CVBPC: BPF action context8DATASOURCEntext10737418230
15RSBPCR_CNTXT_HDRBPC: Resource context header5DATASOURCEntext10737418230
16RSCNVFIXCUKYConversion Table for Fixed Currencies3DATASOURCEInfoSourcenvarchar300
17RSCNVPROVConversion Table for Currency Translation3DATASOURCEInfoSourcenvarchar300
18RSDSEXTOBJDataSource: External Object1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
TOPAccounting Engine
19/EACC/DMB_CHACharacteristics of a DataSource and InfoSource2DATASOURCEDataSourcenvarchar300
20/EACC/DMB_DEBUGDebugging Support Depending on DataSource2DATASOURCEDataSourcenvarchar300
21/EACC/DMB_DSRCEDataSources of Accounting Engine3DATASOURCEDataSourcenvarchar300
22/EACC/DMB_QUEUEDataSource/InfoSource Link to InfoCube2DATASOURCEDataSourcenvarchar300
23/EACC/DMB_SOURCEDataSource and InfoSource3DATASOURCEDataSourcenvarchar300
24/EACC/DMFC_REQUEData Retention - Flow Control: Requests2DATASOURCEDataSourcenvarchar300
25/EACC/DMFC_SRMAXData Retention - Flow Control: Highest Serial No. of DataSrc2DATASOURCEDataSourcenvarchar300
26/EACC/DM_FC_REQUData Retention - Flow Control: Requests5DATASOURCEDataSourcenvarchar300
27/EACC/DM_SERIMAXData Retention - Flow Control: Highest Serial No. of DataSrc5DATASOURCEDataSourcenvarchar300
TOPBilling in Contract Accounts Receivable and Payable
28DFKKBI_BWTRIGBI: Extraction Orders for Billing Account Intervals4DATASOURCEDataSource of Billingnvarchar300
29DFKKBI_BWTRIGHBI: History Records for Extraction4DATASOURCEDataSource of Billingnvarchar300
30DFKKBI_BWTRIGSBI: Individual Extraction Orders for EDRs4DATASOURCEDataSource of Billingnvarchar300
31TFK8012Active EDR Categories5DATASOURCEDataSource of Billingnvarchar300
TOPBudgeting
32BUKF_CATDSRCKey Figures - Category/Data source relation3DATASOURCEKey Figures - Data sourcenvarchar40
33BUKF_DSRCKey Figures - Data source2DATASOURCEKey Figures - Data sourcenvarchar40
34BUKF_DSRC_FIELDKey Figures - Data source field2DATASOURCEKey Figures - Data sourcenvarchar40
35BUKF_DSRC_TKey Figures - Texts for Data Sources2DATASOURCEKey Figures - Data sourcenvarchar40
36BUKF_FGKey Figures - Field group2DATASOURCEKey Figures - Data sourcenvarchar40
37BUKF_FG_FIELDKey Figures - Fields of field group2DATASOURCEKey Figures - Data sourcenvarchar40
38BUKF_FG_TKey Figures - Texts for Field Groups2DATASOURCEKey Figures - Data sourcenvarchar40
39BUKF_FIELD_VALUEKey Figures - Data source fields checks per category3DATASOURCEKey Figures - Data sourcenvarchar40
40BUKF_KFDSRCKey Figures - Key Figure Datasources relation4DATASOURCEKey Figures - Data sourcenvarchar40
41FMKF_DSRC_EVALKey Figures - Evaluation class of data source2DATASOURCEKey Figures - Data sourcenvarchar40
42FMKF_TERMKey Figures - FM Terms3DATASOURCEKey Figures - Data sourcenvarchar40
43FMKF_TERM_AVCKey Figures - FM AVC Term3DATASOURCEKey Figures - Data sourcenvarchar40
44FMKF_TERM_RBKey Figures - FM Terms3DATASOURCEKey Figures - Data sourcenvarchar40
TOPBusiness Accounting
45/EACC/DMM_QUEUEBW Objects in the Extraction Lines5DATASOURCEDataSourcenvarchar300
TOPBusiness Analytics
46UABWTDEXTBW Objects for Transaction Data Extraction4DATASOURCEDataSource (OSOA/OSOD)nvarchar300
TOPBW Service API
47ROREQUESTPRMSRequest Attributes (Source System)4DATASOURCEDataSource (OSOA/OSOD)nvarchar300
TOPClaims Management
48ICLCCEVENTClaim Bundle28DATASOURCEData Originnvarchar20
49ICLPROCUREClaim Item Groupings42DATASOURCEData Originnvarchar20
50ICSCCEVENTShadow Table Claim Bundle28DATASOURCEData Originnvarchar20
51ICSPROCUREClaim Item Groupings42DATASOURCEData Originnvarchar20
52TICL136Data Origin2DATASOURCEData Originnvarchar20
53TICL136TName: Data Origin3DATASOURCEData Originnvarchar20
TOPCross-Application Components
54/EAM/EAMT_ATTMNTSetting for attachments5DATASOURCEDatasource of documentsnvarchar10
55/IXOS/DC46TAREPBGenerated reports for the detail screen > 4.6 systems5DATASOURCEAttribute objectnvarchar120
56/IXOS/DC46TAREPEGenerated reports for the create screen > 4.6 systems5DATASOURCEAttribute objectnvarchar120
57/IXOS/DC46TAREPFGenerated reports for the change screen > 4.6 systems5DATASOURCEAttribute objectnvarchar120
58/IXOS/DC46_TBGOSDocuLink Customizing for GOS (Generic Object Services)7DATASOURCEAttribute objectnvarchar120
59/IXOS/DC46_TCGDSActivate GOS Services at attribute object4DATASOURCEAttribute objectnvarchar120
60/IXOS/DC61_CRESCCM: Create Screen settings5DATASOURCEAttribute objectnvarchar120
61/IXOS/DC61_TCCMRCM: Rendition settings4DATASOURCEAttribute objectnvarchar120
62/IXOS/DC61_TCCMTCM: Template storage table4DATASOURCEAttribute objectnvarchar120
63/IXOS/DCRSA_TRCETrace Table Rendering10DATASOURCEAttribute objectnvarchar120
64/IXOS/DC_TACAAdministrator maintenance for Editing5DATASOURCEAttribute objectnvarchar120
65/IXOS/DC_TACUChange user maintenance - not used5DATASOURCEAttribute objectnvarchar120
66/IXOS/DC_TADAAdministrator maintenance for Details5DATASOURCEAttribute objectnvarchar120
67/IXOS/DC_TADUDetail user maintenance5DATASOURCEAttribute objectnvarchar120
68/IXOS/DC_TAHAHitlist Administrator maintenance (hierachy/separat)4DATASOURCEAttribute objectnvarchar120
69/IXOS/DC_TAHUHitlist User maintenance (hierachy/separat)5DATASOURCEAttribute objectnvarchar120
70/IXOS/DC_TAIAAdministrator maintenance for Creating5DATASOURCEAttribute objectnvarchar120
71/IXOS/DC_TAIUCapture user maintenance - not used5DATASOURCEAttribute objectnvarchar120
72/IXOS/DC_TAREPCGenerated reports for the change mask5DATASOURCEAttribute objectnvarchar120
73/IXOS/DC_TAREPDGenerated reports for the detail mask5DATASOURCEAttribute objectnvarchar120
74/IXOS/DC_TAREPHGenerated reports for hitlists6DATASOURCEAttribute objectnvarchar120
75/IXOS/DC_TAREPIGenerated reports for the insert mask5DATASOURCEAttribute objectnvarchar120
76/IXOS/DC_TASASelectionscreen Administrator maintenance5DATASOURCEAttribute objectnvarchar120
77/IXOS/DC_TASUSelectionscreen user maintenance5DATASOURCEAttribute objectnvarchar120
78/IXOS/DC_TAXFCAOScreens: Excluded function codes for attr. object screens4DATASOURCEAttribute objectnvarchar120
79/IXOS/DC_TBCROverflow table for duplicate COLD records7DATASOURCEAttribute objectnvarchar120
80/IXOS/DC_TBPROTLog table7DATASOURCEAttribute objectnvarchar120
81/IXOS/DC_TBPROT1New Log table10DATASOURCEAttribute objectnvarchar120
82/IXOS/DC_TBRBRecycle bin7DATASOURCEAttribute objectnvarchar120
83/IXOS/DC_TCDSData sources (attribute objects) (j_8AGTC05)4DATASOURCEAttribute objectnvarchar120
84/IXOS/DC_TCDSAData source and action for authority check4DATASOURCEAttribute objectnvarchar120
85/IXOS/DC_TCDSAFData source, actions and fields of authority object4DATASOURCEAttribute objectnvarchar120
86/IXOS/DC_TCDSAFVData source, actions, fields of authority obj. and values4DATASOURCEAttribute objectnvarchar120
87/IXOS/DC_TCDSTData sources Description (Attribute objects)5DATASOURCEAttribute objectnvarchar120
88/IXOS/DC_TCHIERHierarchy of a view9DATASOURCEAttribute objectnvarchar120
89/IXOS/DC_TCLDSEXUserexits at data source4DATASOURCEAttribute objectnvarchar120
90/IXOS/DC_TCLDSSFLink data source/selection field4DATASOURCEAttribute objectnvarchar120
91/IXOS/DC_TCSTACM: Status table4DATASOURCEAttribute objectnvarchar120
92/IXOS/DC_TCSTAFLCM: Status flow table4DATASOURCEAttribute objectnvarchar120
93/IXOS/DC_TCSTATCM: Status text table5DATASOURCEAttribute objectnvarchar120
94/IXOS/DC_TTCSTACM: temporary status table, used at f4-help flow4DATASOURCEAttribute objectnvarchar120
95/IXOS/DC_TTCSTATCM: temporary status text table, used for f4 help - flow5DATASOURCEAttribute objectnvarchar120
TOPData Basis
96RSBOHDESTDirectory of Open Hub Destinations17DATASOURCEDataSource, (3.x DataSource)nvarchar300
97RSEUROConversion Table for Euro Conversion3DATASOURCEInfoSourcenvarchar300
TOPData Mining
98RSDMTP_DSRC_BWDMining Source to Datasource Relation3DATASOURCEDataSource (OSOA/OSOD)nvarchar300
99RSDMTX_DSRC_KEYSModel keys to Datasource relation1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
TOPData Staging
100RSCRT_RDA_LOGEffective Utilization of RDA Daemons2DATASOURCEDataSourcenvarchar300
101RSDSDataSource in BW1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
102RSDSACCESSACTLOGActivation Time Methods with Exit1DATASOURCEDataSourcenvarchar300
103RSDSACCESSATTRDataSource - Attribute Access Method1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
104RSDSACCESSATTRSHDataSource in BW - Shadow Table Attribute Access Method1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
105RSDSESRMAPMapping DataSource ESR (serialized object)1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
106RSDSEXPORTDataSource Metadata (Migration)1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
107RSDSGENDELTALast Delta State1DATASOURCEDataSourcenvarchar300
108RSDSGENDELTADPLast Delta State by Data Package (for Numeric Pointer)1DATASOURCEDataSourcenvarchar300
109RSDSRTCOUNTDataSource: Object ID Counter1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
110RSDSRTSEGCOUNTDataSource: Data Package ID Counter, Record1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
111RSDSSEGDataSource - Segments1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
112RSDSSEGFDDataSource - Segment Fields1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
113RSDSSEGFDSHDataSource in BW - Shadow Table Fields1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
114RSDSSEGFDTDataSource - Texts for Segment Fields2DATASOURCEDataSource (OSOA/OSOD)nvarchar300
115RSDSSEGFDTSHDataSource in BW - Shadow Table Field Texts2DATASOURCEDataSource (OSOA/OSOD)nvarchar300
116RSDSSEGSHDataSource in BW - Shadow Table Segments1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
117RSDSSEGTDataSource - Segment Texts2DATASOURCEDataSource (OSOA/OSOD)nvarchar300
118RSDSSEGTSHDataSource in BW - Shadow Table Segment Texts2DATASOURCEDataSource (OSOA/OSOD)nvarchar300
119RSDSSHDataSource in BW - Shadow Table1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
120RSDSTDataSource - Texts2DATASOURCEDataSource (OSOA/OSOD)nvarchar300
121RSDSTRANSTRUDataSource: Transfer Structures1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
122RSDSTSHDataSource in BW - Shadow Table Texts2DATASOURCEDataSource (OSOA/OSOD)nvarchar300
123RSDS_QUEUE_DATADataSource Queue: Data (Binary)1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
124RSDS_QUEUE_HEADDataSource Queue; Header Table of Active Delta Processes1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
125RSGENISOSMAPHeader Mapping for Generating Applications3DATASOURCEDataSource (OSOA/OSOD)nvarchar300
126RSSRCTYPE_MAPBehavior of Source System Types7DATASOURCEDataSources can be maintained in BWnvarchar10
TOPFinancial Accounting
127/OPT/VIM_T124Indexing field mapping for IDOC processing4DATASOURCEField Value Determination Typenvarchar10
TOPFinancial Services
128BWFS_DATASRC_DDataSources for Delta Position1DATASOURCEDataSource for Delta Positionnvarchar300
129BWFS_DATASRC_IDataSources for Position Initialization1DATASOURCEDataSource for Position Initializationnvarchar300
130BWFS_SETTINGS_0DInfoSources for Delta Bestand3DATASOURCEDataSource for Delta Positionnvarchar300
131BWFS_SETTINGS_0IInfoSources for Position Initialization5DATASOURCEDataSource for Position Initializationnvarchar300
TOPFrance
132T5F5R2DADS-U check: Origin of ALV data nodes5DATASOURCEDADS-U: Check - data sourcenvarchar1320
TOPGeneral Ledger Accounting
133FAGL_BW_LOG_HEADFI-GL: Log for BW Extraction: Control Data2DATASOURCEInfoSourcenvarchar300
134FAGL_BW_LOG_ITEMFI-GL: Log for BW Extraction: Line Items2DATASOURCEInfoSourcenvarchar300
135FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records2DATASOURCEInfoSourcenvarchar300
136FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis2DATASOURCEInfoSourcenvarchar300
TOPInformation system
137FMBWDELTACustomizing Table for Controlling Delta-Update2DATASOURCEDataSourcenvarchar300
138FMKF_REPTERMKey Figure Terms for Reporting Because of New Budget Tables3DATASOURCEKey Figures - Data sourcenvarchar40
139FMKF_REPTERM2Key Figure Terms for Reporting Because of New Budget Tables3DATASOURCEKey Figures - Data sourcenvarchar40
TOPInventory Accounting
140CONACCDATASOURCEDataSources Inventory Accounting1DATASOURCEnvarchar300
TOPInvoicing in Contract Accounts Receivable and Payable
141DFKKINV_BWTRIGBW: Group Extraction Order for Invoicing Documents/FIKEY3DATASOURCEInvoicing DataSource (Sales Statistics)nvarchar300
142DFKKINV_BWTRIGHBI: History Record for Extraction of Invoicing Documents3DATASOURCEInvoicing DataSource (Sales Statistics)nvarchar300
143DFKKINV_BWTRIGSBW: Individual Extraction Order for Invoicing Documents3DATASOURCEInvoicing DataSource (Sales Statistics)nvarchar300
144TFK2602Invoicing Processes6DATASOURCEInvoicing DataSource (Sales Statistics)nvarchar300
TOPOLAP Technology
145RSCURRConversion Table for Euro Conversion3DATASOURCEInfoSourcenvarchar300
TOPOperational Data Provisioning ODP
146RODPS_TEST_SNAPSSnapshot of All Test Data Sources2DATASOURCEDataSource (OSOA/OSOD)nvarchar300
TOPOperational Information Provider
147BSANLY_OIP10Modeling Workbench: Generated DataSources1DATASOURCEDataSource (OSOA/OSOD)nvarchar300
TOPOverhead Cost Controlling
148COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis2DATASOURCEInfoSourcenvarchar300
TOPPosition Budgeting and Control
149HRBWDELTACustomizing Table for Controlling Delta-Update2DATASOURCEDataSourcenvarchar300
TOPRegulatory reporting for insurance companies
150TISSR_OUT_DTSRCISSR: Datenquellen für Listaufbau4DATASOURCEMW-Kennung für Vorsystemnvarchar100
TOPStatistics
151DBESTA_BWPROTHHistory Record for Extraction to BW Sales Statistics2DATASOURCEInfoSourcenvarchar300
TOPWithout Description
152RSDMTU_AWB_MONMonitoring AWB9DATASOURCESource Namenvarchar720