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

159 columns | Print definition?ERP 6.0  | CREATE_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/ALERT_IDXStandard index table for multiple recipients9CREATE_DATECreation Datenvarchar80
2/AIF/CFUNC_DETFunction Information19CREATE_DATECreation Datenvarchar80
3/AIF/CIFPP_TJSELDefine Selection for CIF Postprocessing9CREATE_DATECreation Datenvarchar80
4/AIF/CLINKCustom Data Link11CREATE_DATECreation Datenvarchar80
5/AIF/CTEXTCustom Message Text11CREATE_DATECreation Datenvarchar80
6/AIF/DOCUDocumentation5CREATE_DATESystem Datenvarchar80
7/AIF/DOCU_ID_IDXDocument search index table23CREATE_DATECreation Datenvarchar80
8/AIF/ERRSTAT_DError statistic (with date)7CREATE_DATECreation Datenvarchar80
9/AIF/FLBOOK_IDXStandard index table20CREATE_DATECreation Datenvarchar80
10/AIF/IDC_IDX_TBLStandard index table20CREATE_DATECreation Datenvarchar80
11/AIF/MIDX_TEMPLTemplate for a multi index table21CREATE_DATECreation Datenvarchar80
12/AIF/MSGSTAT_LGTMessage statistics for log7CREATE_DATECreation Datenvarchar80
13/AIF/MSG_SNAP_HDMessage statistics: snapshot header3CREATE_DATECreation Datenvarchar80
14/AIF/MSG_STATMessage statistics7CREATE_DATECreation Datenvarchar80
15/AIF/NS_LOCKDefine Namespace10CREATE_DATECreation Datenvarchar80
16/AIF/PERS_QMSGAIF Persistence: Runtime Queue6CREATE_DATECreation Datenvarchar80
17/AIF/PERS_RTCFGRAIF Persistence: Runtime Configuration Group6CREATE_DATECreation Datenvarchar80
18/AIF/PERS_RUNAIF Persistence: Run9CREATE_DATECreation Datenvarchar80
19/AIF/PERS_RUNPCKAIF Persistence: Run Packet7CREATE_DATECreation Datenvarchar80
20/AIF/PERS_XMLAIF XML Persistency: Message Header9CREATE_DATECreation Datenvarchar80
21/AIF/QRFC_S_IDXqRFC Standard index table20CREATE_DATECreation Datenvarchar80
22/AIF/QRFC_TJ_SOSelection Options for qRFC transfer job7CREATE_DATECreation Datenvarchar80
23/AIF/QRFC_TJ_SYSSelection Options for qRFC Transfer Job10CREATE_DATECreation Datenvarchar80
24/AIF/Q_STD_IDX_TqRFC Standard index table20CREATE_DATECreation Datenvarchar80
25/AIF/RUNNING_WFRunning Workflow for AIF8CREATE_DATECreation Datenvarchar80
26/AIF/STD_IDX_MULStandard index table for multiple recipients9CREATE_DATECreation Datenvarchar80
27/AIF/STD_IDX_TBLStandard index table20CREATE_DATECreation Datenvarchar80
28/AIF/TEST_BP_IDXStandard index table20CREATE_DATECreation Datenvarchar80
29/AIF/TICKETSTicket content table for Ticket System14CREATE_DATECreation Datenvarchar80
30/AIF/TIDOC_STRAIF IDoc structure mapping table10CREATE_DATECreation Datenvarchar80
31/AIF/TRFC_S_IDXtRFC Standard index table20CREATE_DATECreation Datenvarchar80
32/AIF/TRFC_TJ_SOSelection Options for tRFC transfer job4CREATE_DATECreation Datenvarchar80
33/AIF/TRFC_TJ_SYSSelection Options for Transfer Job8CREATE_DATECreation Datenvarchar80
34/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing20CREATE_DATECreation Datenvarchar80
35/AIF/T_FG_MAPmapping table for created objects8CREATE_DATESystem Datenvarchar80
36/AIF/T_MMSG_IDXMulti Msg class&No. search index table25CREATE_DATECreation Datenvarchar80
37/AIF/T_QRFC_LOGLog table for Playback Functions generation6CREATE_DATECreation Datenvarchar80
38/AIF/T_RFC_FGLOGFunction Module List Generation Log25CREATE_DATECreation Datenvarchar80
39/AIF/T_STD_IDX_TtRFC Standard index table20CREATE_DATECreation Datenvarchar80
40/AIF/T_TJ_SSSelection set for transfer job8CREATE_DATECreation Datenvarchar80
41/AIF/T_TRFC_FUNCPlayback Functions for tRFC Reader10CREATE_DATECreation Datenvarchar80
42/AIF/VALID_PERIOAIF Validity Period6CREATE_DATECreation Datenvarchar80
43/AIFX/ECH_STD_TBStandard ECH key fields table35CREATE_DATECreation Datenvarchar80
44/AIFX/T_PPOAIF PPO7CREATE_DATECreation Datenvarchar80
45/OTEI/DU_WD_TICDTicket details table13CREATE_DATECreation datenvarchar80
46/OTEI/DU_WD_TICKTicket master table5CREATE_DATECreation datenvarchar80
47/SDF/CMO_TOC_LOGLogging of transport of copies3CREATE_DATEVesting Datenvarchar80
48/SLOAE/EX_ANALYSAnalysis table4CREATE_DATEField of type DATSnvarchar80
49/UI2/NWBC_CFG_GTSAP GUI Tags: SAP Delivery12CREATE_DATEnvarchar80
50/UI2/NWBC_C_GTSAP GUI Tags: Tags of Customer13CREATE_DATEnvarchar80
51/UI2/NWBC_L_GTSAP GUI Tags: Buffer Table12CREATE_DATEnvarchar80
52DFMCA_RM_RPRFRisk Profile Transaction Data3CREATE_DATECreated Atdecimal150
53EDOCUMENTeDocument15CREATE_DATECreation Datenvarchar80
54EDOCUMENTFILEeDocument: File8CREATE_DATEFile Creation Datenvarchar80
55EDOCUMENTHISTORYeDocument: History15CREATE_DATECreation Datenvarchar80
56EHPRCD_ICMDSCustomer MDS41CREATE_DATECreation Datenvarchar80
57EHPRCD_ISMDSSupplier MDS23CREATE_DATECreation Datenvarchar80
58EHPRCD_OBL_ROOTObject List Root13CREATE_DATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
59GRFNACTIONISSUEAudit Management Action and Ad hoc Issue Mapping10CREATE_DATEField of type DATSnvarchar80
60MDS_VERSIONMDS: Headertable for analysis versions4CREATE_DATESystem Datenvarchar80
61REQHEADAdministrative Header Data: Requirement Coverage Request4CREATE_DATERequirement Coverage Request Entered Onnvarchar80
62RSBPCF_DOCBPC File Service Document Master Table7CREATE_DATEBPC: Create Datenvarchar80
63RSBPCW_UPD_LOGBPC Work Status - Locks Update Log Table6CREATE_DATEBPC: Create Datenvarchar80
64T7CNRMP_DREPORTReport with Dynamic Rows or Columns6CREATE_DATECreation Datenvarchar80
65TKESS_SCRGeneric Selection Screen - Definition Header7CREATE_DATEDisplay variant creation datenvarchar80
66TRCCT_CURRCHANGECurrency changeover12CREATE_DATEFirst Entered onnvarchar80
67TRCCT_TRANSCurrency Changeover Transaction16CREATE_DATEFirst Entered onnvarchar80
68WDR_TEST_PCKGRepository for Packages for WD ABAP Test Cases6CREATE_DATEDate data element for SYSTnvarchar80
69WDR_TEST_RECORDRepository for WD ABAP Test Cases8CREATE_DATEDate data element for SYSTnvarchar80
70ZAIF_D01_SIDX_01Single index table for DEMO BUPA_IN20CREATE_DATECreation Datenvarchar80
TOPBack Office
71TRET_POOLAdditional Pool Data for Fund12CREATE_DATEFirst Entered onnvarchar80
72TRET_SEC_POOLAdditional Pool Data for Security13CREATE_DATEFirst Entered onnvarchar80
73TRFT_BUSTRANSTreasury: TRF Business Transaction7CREATE_DATECreation Date of the Operative Business Transactionnvarchar80
74TRFT_MATCH_TRANSTreasury: Matching Process Business Transaction11CREATE_DATECreation Date of the Operative Business Transactionnvarchar80
TOPBasis Components
75/XFT/INV_QInvoice receipt queue: Header12CREATE_DATECreation Datenvarchar80
76/XFT/INV_Q_SInvoice receipt queue: Header12CREATE_DATECreation Datenvarchar80
TOPBatches
77DRVLOG_HEADERDerivation: Header table for log file4CREATE_DATECreated Onnvarchar80
78KONDRConditions: Derivation strategy - data part7CREATE_DATECreated Onnvarchar80
TOPClaims Management
79ICLPARTCANCELLEDParticipant Created Temporarily and Creation Cancelled8CREATE_DATECreated Onnvarchar80
TOPClinical System
80N2AD_ALLERGYAllergy Documentation - Allergies26CREATE_DATEIS-H: Date when Record Creatednvarchar80
81N2AD_PATAllergy Documentation - Overall Allergy Status (OAS)13CREATE_DATEIS-H: Date when Record Creatednvarchar80
82N2AD_REACTAllergy Documentation - Reactions12CREATE_DATEIS-H: Date when Record Creatednvarchar80
83N2DI_DICTATDictation - Administration Data9CREATE_DATEIS-H: Date when Record Creatednvarchar80
84N2DI_RECORDAdministration Data of Speech Recording12CREATE_DATEIS-H: Date when Record Creatednvarchar80
TOPCollaborative Cross Applications
85/POA/D_CLM_IODICDictionary of IO files and objects for CLM6CREATE_DATEUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
TOPCollectionsDisbursements
86DIMAPARBROKIO: Insurance Object-Broker Relationship in FS-CD4CREATE_DATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
87DIMAPARPPLANIO: Payment Plan Changes in Insurance Object4CREATE_DATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPContract Billing
88EPPM_QS03Request for Automated Meter Reading7CREATE_DATECreation Date of QS Formnvarchar80
89EPPM_QS06Request for quotation7CREATE_DATECreation Date of QS Formnvarchar80
90EPPM_QS07Supplier Complaint9CREATE_DATECreation Date of QS Formnvarchar80
91EPPM_QS08Changes to Meter Rate Data20CREATE_DATECreation Date of QS Formnvarchar80
92EPPM_QS09Reason for Meter Removal6CREATE_DATECreation Date of QS Formnvarchar80
TOPCross-Application Components
93/OPT/VIM_HD_DPVIM IE Monitor: Header Data for DP Invoices19CREATE_DATECreation Date of Work Itemnvarchar80
94/OPT/VIM_NPO_WIDVIM IE Monitortable: WI Header Data for NPO Invoices13CREATE_DATECreation Date of Work Itemnvarchar80
95/OPT/VIM_NPO_WIHVIM IE Monitortable: WI Header Data for NPO Invoices14CREATE_DATECreation Date of Work Itemnvarchar80
96/OPT/VIM_PO_WIDVIM Report: WI Header Data for PO Invoices14CREATE_DATECreation Date of Work Itemnvarchar80
97/OPT/VIM_PO_WIHVIM Report: WI Header Data for PO Invoices15CREATE_DATECreation Date of Work Itemnvarchar80
98ALM_ME_SYNC_ARCHMAM 1.0 Obsolete13CREATE_DATEnvarchar80
99CACNS_PM_PROJEasyProjectMarket21CREATE_DATEField of type DATSnvarchar80
TOPCross-System and Cross-Partner Document Flow
100/SCMB/DF_CC_TRANTransport Table for Doc. Flow Appl. Data During Client Copy6CREATE_DATE(8-character) Date for SYSTnvarchar80
TOPCustomer Bill of Services
101/SAPBOQ/HD_SESQTO header table11CREATE_DATEDate on Which Record Was Creatednvarchar80
TOPCustomer Interaction Center
102CCMOBJLSTList of information objects in a container5CREATE_DATESystem Datenvarchar80
TOPDocument Builder
103/IPRO/TVAR_CMPVariable table25CREATE_DATEField of type DATSnvarchar80
TOPE-Recruiting
104T77RCF_RP_ACTProcess Templates7CREATE_DATECreation Date of Process Template (Activities)nvarchar80
TOPEnvironment, Health and Safety
105/TDAG/CPA_ICMDSCustomer MDS38CREATE_DATECreation Datenvarchar80
106/TDAG/CPA_ISMDSSupplier MDS22CREATE_DATECreation Datenvarchar80
TOPIncentive and Commission Management ICM
107CACS00_STAT_CASStatistics for Memory Requirement of Commission Cases (DB)2CREATE_DATECreated Onnvarchar80
108CACS00_STAT_DOCStatistics for Memory Requirement of Commission Docs (DB)2CREATE_DATECreated Onnvarchar80
TOPInformation System
109FTI_BI_REP_ODSReparation Records for Inconsistent Data in ODS 0CFM_O01 /BW165CREATE_DATEFirst Entered onnvarchar80
TOPJoint Venture und Production Sharing Accounting
110T8PSA_PSCPSC Master14CREATE_DATECreated onnvarchar80
111T8PSCMSTRProduction Sharing Contract10CREATE_DATECreated onnvarchar80
TOPLoans Management
112VDCBR_CONTROLData Selection for Credit Bureau4CREATE_DATECreated Onnvarchar80
113VDCORR_ALOILoans: Search Index for Correspondence (Document Finder)4CREATE_DATEField of type DATSnvarchar80
TOPMaintenance Processing
114ALM_ME_SYNCSync Status13CREATE_DATEDate on Which Record Was Creatednvarchar80
TOPMarket Risk Analyzer
115VTVBARNPVs of OTC transactions20CREATE_DATEFirst Entered onnvarchar80
TOPMaster Data
116JYT_LOGIS-M: Log5CREATE_DATECreated Onnvarchar80
117JYT_LOG_HEADERIS-M: Log, Header8CREATE_DATECreated Onnvarchar80
TOPMaterial Master
118WRF_HIER_NODESHierarchy Node9CREATE_DATECreation Datenvarchar80
119WRF_HIER_OBJObjects of a Hierarchy9CREATE_DATECreation Datenvarchar80
TOPNetweaver Business Client
120NWBC_CFG_GUI_TAGDefinition of SAPGUI Tags which can be linked to Chips12CREATE_DATEnvarchar80
121NWBC_C_GUI_TAGDefinition of SAPGUI Tags by Customer13CREATE_DATEnvarchar80
TOPOccupational Health
122T7EHS00_RESPCRITCriteria for Corresponding Questions t7ehs00_resquest11CREATE_DATECreated Onnvarchar80
123T7EHS00_RESQINFOHeader Information for Questionnaires4CREATE_DATECreated Onnvarchar80
124T7EHS00_RESQUESTTable for Questions Answered15CREATE_DATECreated Onnvarchar80
TOPOverhead Cost Controlling
125KCR_T_LINKAssignment of Link to Data (Double-Concatenated List)8CREATE_DATEEntered onnvarchar80
TOPProcess Controls
126GRPC_S_EVENTEvent6CREATE_DATEDatenvarchar80
TOPProduction Orders
127NAVP_PROFILENavigation Profile10CREATE_DATECreation Date of the Navigation Profilenvarchar80
TOPProfitability Analysis
128/EACA/TPMVARIProfitabiliy Analysis Variant9CREATE_DATEVariant Created onnvarchar80
TOPSales and Distribution
129ZZDEA_MSTDrug Enforcement Administration (DEA)15CREATE_DATEDatenvarchar80
TOPSAP NetWeaver Mobile - Use subcomponents
130MEMGMT_CFG_TEMPLConfiguration Template for Device Management4CREATE_DATESystem Datenvarchar80
131MEMGMT_DEV_TEMPLDevice Template for the Device Configuration4CREATE_DATESystem Datenvarchar80
132MEMSDMobile Solution Descriptor: Main Table4CREATE_DATESystem Datenvarchar80
TOPSAP Utilities
133EQDPROCERRDefine Incorrect Installations According to QD Indicator3CREATE_DATECreated onnvarchar80
TOPService Data Download
134/SDF/CD_CCONNECTPersistency for /SDF/CD_CUSTOM_CODE_CONNECT7CREATE_DATESystem Datenvarchar80
135/SDF/CMO_T_430CCMC Service: Enhancement10CREATE_DATECreated onnvarchar80
136/SDF/RBE_JOBJobs for SQL Check Step Execution in SDA Analysis8CREATE_DATEJob start datenvarchar80
137/SDF/UPL_LOGPersistency Table for Usage and Procedure Logging1CREATE_DATESystem Datenvarchar80
TOPStakeholder Relationship Management
138USS_COMP_FIGSKey Figures Related to Company11CREATE_DATECreation Datenvarchar80
139USS_SHARE_FIGSKey Figure Related to Securities11CREATE_DATECreation Datenvarchar80
TOPTransaction Manager
140SLDT_TRANSACTIONSubledger Distributor Business Transactions16CREATE_DATECreation Date of the Operative Business Transactionnvarchar80
141TCAT_TRANSACTIONBusiness Transaction: Corporate Action9CREATE_DATECreation Date of the Operative Business Transactionnvarchar80
142TCORT_CODCODeal: Conditions15CREATE_DATEEntered Onnvarchar80
143TCORT_CODCOFODeal: Condition's Formula14CREATE_DATEEntered Onnvarchar80
144TCORT_CODMDDeal: Main Data11CREATE_DATEEntered Onnvarchar80
145TCORT_CODPIDeal: Payment Information11CREATE_DATEEntered Onnvarchar80
146TCORT_CODULCODeal : Underlying's Conditions16CREATE_DATEEntered Onnvarchar80
147TCORT_CODULCOFODeal: Underlying's Formula16CREATE_DATEEntered Onnvarchar80
148TERT_TRANSACTIONBusiness Transaction: Exercise of Rights15CREATE_DATECreation Date of the Operative Business Transactionnvarchar80
149THMEXT_LOGLog: External Exposure Data Applied to E-HA9CREATE_DATEDate E-HA Data Created via External Exposurenvarchar80
150TRDT_TRDBUSTRANSTreasury: Persistent distributor business transaction17CREATE_DATECreation Date of the Operative Business Transactionnvarchar80
151TRGT_USER_DATATR Position Management - User Data4CREATE_DATEFirst Entered onnvarchar80
152TRLT_TRANS_DELDeleted TRL Transactions (BW Only)7CREATE_DATEFirst Entered onnvarchar80
153TRLT_VCL_FLOWFlows Valuation Class Transfer20CREATE_DATECreation Date of the Operative Business Transactionnvarchar80
154TRQT_BUSTRANSTreasury: Business Transactions4CREATE_DATECreation Date of the Operative Business Transactionnvarchar80
TOPTransfer to Financial Accounting
155TRLT_DERIVTRANSDerived Business Transactions11CREATE_DATECreation Date of the Operative Business Transactionnvarchar80
156TRLT_LOCKTreasury Ledger Position Lock9CREATE_DATEDatenvarchar80
157TRLT_TRANSACTIONTreasury Ledger Business Transactions7CREATE_DATECreation Date of the Operative Business Transactionnvarchar80
158TRPRT_PAYMENTSPersistent Data for Payment Requests51CREATE_DATEFirst Entered onnvarchar80
TOPTreasury and Risk Management
159TREAT_FLOWTreasury: TREA Flows19CREATE_DATECreation Date of the Operative Business Transactionnvarchar80