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

88 columns | Print definition?ERP 6.0  | CREATION_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/C_PGSBasis Table of the Partner Grouping Schema5CREATION_DATEUTC timestamp in short form (YYYYMMDDhhmmss)decimal150
2/SLOAP/DOWNUPLOGDownload / upload log6CREATION_DATECreation datenvarchar80
3/XFT/EPA_RECPOSProperty extension: File nodes ArchiveLink documents7CREATION_DATEField of type DATSnvarchar80
4/XFT/EPA_TBARCOOpen barcodes11CREATION_DATEField of type DATSnvarchar80
5/XFT/EPA_TPROTLog22CREATION_DATECreation Datenvarchar80
6CIAP_D_RECORDCIAP Record6CREATION_DATECIAP Record Creation Datenvarchar80
7CNVCDOP_PROJDEFCDOP - Master table for Definition of CDOP Projects4CREATION_DATECDOP - Project Definition Created Ondecimal150
8CNVCDOP_PROJECTSCDOP - Projects4CREATION_DATECDOP - Project Created ondecimal150
9CNVCMIS_G_CVERSSoftware status of sender and receiver systems3CREATION_DATEDatenvarchar80
10CNV_10996_ALVOUTALV output of archiving sessions for conversion5CREATION_DATECreation Date of Archive Filenvarchar80
11CNV_10996_ARCHIVArchiving sessions for conversion5CREATION_DATECreation Date of Archive Filenvarchar80
12CNV_DOWNUP_LOGDownload / upload log6CREATION_DATECreation datenvarchar80
13EHPRCD_CMP_ROOTCampaign Root16CREATION_DATECampaign Creation Datenvarchar80
14FIWTQAD_TAXQatar Tax Details4CREATION_DATEDate and Time Createddecimal150
15HRP1107DB Table for Infotype 110722CREATION_DATEField of type DATSnvarchar80
16HRSFI_D_RCT_REQChange Pointer Table for Job Requisitions17CREATION_DATEField of type DATSnvarchar80
17IDSAU_CR_DATAVendor Certificates13CREATION_DATECertificate Creation Datenvarchar80
18IUUC_CCARD_ORDERorder and status information for credit card de-/encryption9CREATION_DATEnvarchar80
19KCONSConsent Data: Consent data provided for legal entity13CREATION_DATEConsent Data: Consent creation datenvarchar80
20TLRT_TARO_DOCTrade Repository: Documents8CREATION_DATEFile Creation Datenvarchar80
21TN11SLocks for Building Units9CREATION_DATEIS-H: Date when Record Creatednvarchar80
22TREAT_NOVATIONTreasury: Novation5CREATION_DATECFM: Fixing Datenvarchar80
23TRTM_CHG_PARTNERTreasury: Change partner7CREATION_DATECFM: Fixing Datenvarchar80
24UCONSTATMONITORAStorage of UCON Statistics Data (Cross Client; aggregated)20CREATION_DATECreation Datenvarchar80
25WDY_HISTORYField History for Web Dynpro ABAP4CREATION_DATEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPAccounting Engine
26/EACC/T_MSG_CTXTReduced Persistent View of Message Context Objects6CREATION_DATEDatenvarchar80
TOPBank Accounting
27DFPAYMENT_KEY_IDContains ID for Payment Data Key9CREATION_DATEDatenvarchar80
TOPBases
28T77OMAHQ_GARBAGETable with Selections/Queries to be Deleted2CREATION_DATEField of type DATSnvarchar80
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
29DFPM_NUMBSequential Numbers4CREATION_DATEnvarchar80
TOPBusiness Analytics
30UAPROJECTTransparent Table to Store Costing Projects5CREATION_DATECreation Datenvarchar80
31UAWORKSETTransparent Table to Store Working Environments of Costing6CREATION_DATECreation Datenvarchar80
TOPBusiness Partner
32RATINGSRatings9CREATION_DATEDate When Rating Was Creatednvarchar210
TOPCollateral Management System
33CMS_MESSAGE_CRMKeymapping bei Datenaustausch via XI6CREATION_DATEFechanvarchar80
TOPCollectionsDisbursements
34VVKK_COINSPCoinsurance Shares Item Table17CREATION_DATEDatenvarchar80
TOPCommon Functions
35INM_S_PARAMShares parameter for navigation5CREATION_DATEField of type DATSnvarchar80
TOPContract Accounts Receivable and Payable
36DFKKCRCL_DOCSTable for Checks To Be Clarified10CREATION_DATEDatenvarchar80
37DPAYNSequential Number Assignment4CREATION_DATEnvarchar80
TOPCross-Application Components
38/IXOS/DC_WD_DV_Cdoc view cache5CREATION_DATESystem Datenvarchar80
39ZGADGETS_FILESGadget file database5CREATION_DATECreated and change datenvarchar80
TOPCustom Development Management Cockpit
40CNVCDMC_PROJDEFCDMC - Master table for Definition of CDMC Projects4CREATION_DATECDMC - Project Definition Created Ondecimal150
41CNVCDMC_PROJECTSCDMC - Projects4CREATION_DATECDmC - Project Created ondecimal150
TOPCustomer Bill of Services
42BOSPS_CLUSTERBOSPS Data Cluster for variants etc5CREATION_DATE(8-character) Date for SYSTnvarchar80
TOPData Replication Framework
43DRFD_APPL_FILT_CFilterCriteria13CREATION_DATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
44DRFD_APPL_FILT_HData Replication Filter Root Node9CREATION_DATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPE-Recruiting
45HRP5115Database Table for Infotype 511520CREATION_DATECreation Date of Talent Groupnvarchar80
TOPECM ABAP Stack
46NWECMD_LOCKTable for persistent Lock objects7CREATION_DATEnwecm: Timestamp (DATS + TIMS)decimal217
47NWECMD_NODEtable for persistent node objects14CREATION_DATEnwecm: Timestamp (DATS + TIMS)decimal217
48NWECMD_RELATIONSnwecm: persistent representation of relations10CREATION_DATEnwecm: Timestamp (DATS + TIMS)decimal217
TOPFinancial Supply Chain Management
49EDX_OUTBOUNDEDX: Outbound Messages (Messages Ready to Be Sent)9CREATION_DATEEDX: Date Message Creatednvarchar80
TOPGeneral Ledger Accounting
50FAGL_EXTR_HISTTransfer History for Summary Documents8CREATION_DATEIDoc Created Onnvarchar80
TOPGeneric eSOA Tools
51BSSOA_CHK_DATCFGConfiguration values for BS_SOA checks3CREATION_DATEField of type DATSnvarchar80
TOPInternet Communication Framework
52ICF_SERV_STATInterim Storage of ICF Statistics Data6CREATION_DATECreated onnvarchar80
TOPLoans Management
53VDCBR_HISTHistory of Data Supplied to Credit Bureau4CREATION_DATECreated Onnvarchar80
54VDCBR_RES_HTHeader and Totals Records for Data Reported to Credit Bur.13CREATION_DATECreated Onnvarchar80
55VDCBR_RES_PARTPartner Data Reported to Credit Bureau (Pro Loan)4CREATION_DATECreated Onnvarchar80
56VDCHK_GROSS_NETStorage of data for report RFVD_GROSS_TO_NET19CREATION_DATESystem Datenvarchar80
TOPMain Process
57/VSO/M_I_SHP_HDRInput Data: Shipment Header (Vehicle Space Optimization)26CREATION_DATECreated on (Vehicle Space Optimization)nvarchar80
TOPMaintenance Processing
58ALM_ME_SIG_LINKSSignature Key - Link Table5CREATION_DATEField of type DATSnvarchar80
TOPMaterial Master
59WER_EVENT_ARule Engine event8CREATION_DATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
60WER_EVENT_SRule Engine event7CREATION_DATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPMusing Tools
61WDKSNAPSHOTSSnapshops / Serialization7CREATION_DATEDatenvarchar80
TOPPatient Management
62NDRGIS-H: Table Containing Case-Related DRGs15CREATION_DATEIS-H: Date when Record Creatednvarchar80
TOPPortfolio
63VDBILL_CONTROLBill Control6CREATION_DATEBill Creation Datenvarchar80
64VDBILL_HISTBilling History11CREATION_DATEBill Creation Datenvarchar80
TOPProduct Data Management
65CONV_FILEClipboard for Objects to Convert7CREATION_DATEDate and Time When This Conversion Was Initiateddecimal150
TOPPurchasing
66MMPURUI_CFDOCcFolders ID for Purchasing Documents10CREATION_DATEDate on Which Record Was Creatednvarchar80
TOPReceivablesPayment Management
67VDAD_CONTROLTable with Dates for Auto Debit Run5CREATION_DATECalculation Datenvarchar80
TOPRecords and Case Management
68RMPSDOD_RULEBASEDisposal Rulebase19CREATION_DATEnvarchar80
69RMPSPRO_RULEBASEDisposal Rulebase19CREATION_DATEnvarchar80
70RMPSTNA_RULEBASETNA: Schedules for the Disposal According to PRO Standard8CREATION_DATEField of type DATSnvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
71NAPX_DRGIS-H: Appendix DRG Table14CREATION_DATEIS-H: Date when Record Creatednvarchar80
TOPSAP Records Management
72SRM_ECM_NNTLookup table for RM node names in ECM integration9CREATION_DATEnvarchar80
TOPService Data Download
73/BDL/HEADNachbau: DSVAS: Session data (header)3CREATION_DATEnvarchar80
74BDLHEADNachbau: DSVAS: Session data (header)3CREATION_DATEnvarchar80
75BDLSESSIONHEADNachbau: DSVAS: Session data (header)3CREATION_DATEnvarchar80
TOPTransaction Management
76THXET_MEAS_HEADEffectiveness Test Results18CREATION_DATEFirst Entered onnvarchar80
TOPTransaction Manager
77TEMT_POLICYHedging Policy19CREATION_DATEFirst Entered onnvarchar80
78TEMT_PROFILEPlanning profile17CREATION_DATEFirst Entered onnvarchar80
79TEMT_RAWEXPOSRaw Exposure23CREATION_DATEFirst Entered onnvarchar80
80TEMT_VERSEXPOSVersioned Exposure38CREATION_DATEFirst Entered onnvarchar80
81TEMT_VERSIONVersions of a Planning Profile5CREATION_DATEFirst Entered onnvarchar80
82TEXT_POSITIONSExposure Positions55CREATION_DATEFirst Entered onnvarchar80
83TEXT_POS_FLOWExposure Position Flows58CREATION_DATEFirst Entered onnvarchar80
84TEXT_RAWEXPOSRaw Exposure23CREATION_DATEFirst Entered onnvarchar80
TOPWeb Service and SOAP - ABAP
85SRT_TRC_FILESlist of all trace file names4CREATION_DATEnvarchar80
86SRT_UTIL_ADMSRT Utilities: Administration3CREATION_DATEnvarchar80
87SRT_UTIL_ADMINSRT Utilities: Administration4CREATION_DATEnvarchar80
TOPWithout Description
88KAP_PSR_OBJObject: Element, Sample5CREATION_DATECreated onnvarchar80