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

80 columns | Print definition?ERP 6.0  | CREATION_TIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/NLG_INAGBA Interface: Incoming Message Header23CREATION_TIMEGBA Interface: Creation Time Stamp (Date and Time)decimal150
2/GSINS/NLG_OUTAGBA Interface: Outgoing Message Header13CREATION_TIMEGBA Interface: Creation Time Stamp (Date and Time)decimal150
3/IWBEP/I_SBD_GASB: DM node generated artifact4CREATION_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
4/IWBEP/I_SBD_PRSB: DM node project4CREATION_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
5/SLOAP/DOWNUPLOGDownload / upload log8CREATION_TIMECreation timenvarchar60
6/SLOAP/IMP_LOGImprovement message log9CREATION_TIMESLOAS creation timestampdecimal150
7/SLOAP/LOG_CONTlogging content for sloap logger5CREATION_TIMESLOAS creation timestampdecimal150
8CNVCMIS_G_CVERSSoftware status of sender and receiver systems4CREATION_TIMETimenvarchar60
9CNVMBTACTGRPActivity Groups6CREATION_TIMEdecimal150
10CNVMBTPACKpackage information/creator/creation date/scenarion4CREATION_TIMEPackage Creation timedecimal150
11CNVMBTPROJECTExisting Migration Projects4CREATION_TIMEdecimal150
12CNVMBTSUBPROJECTsupprojects / mass transfer ID- relation to project6CREATION_TIMEdecimal150
13CNV_DOWNUP_LOGDownload / upload log8CREATION_TIMECreation timenvarchar60
14IUUC_CCARD_ORDERorder and status information for credit card de-/encryption10CREATION_TIMEnvarchar60
15OA2_SR_A_CTXOAuth 2.0 Authorization Code Context5CREATION_TIMEOAuth 2.0 Timestamp: Token Creation (UTC)nvarchar140
16OA2_SR_CTXOAuth2 ServerContext (Server Implementation, Runtime)5CREATION_TIMEOAuth 2.0 Timestamp: Token Creation (UTC)nvarchar140
17sap_stmt_workload60creation_timedatetime230
18sap_workload_snapshot7creation_timedatetime230
19TLRT_TARO_DOCTrade Repository: Documents9CREATION_TIMEFile Creation Timenvarchar60
20TREAT_NOVATIONTreasury: Novation6CREATION_TIMECFM: Fixing Timenvarchar60
21TRTM_CHG_PARTNERTreasury: Change partner8CREATION_TIMECFM: Fixing Timenvarchar60
TOPArchiving Connector ABAP
22ARC_TRANS_COMPCompare Units of Measurement and Currencies8CREATION_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPBRFplus - ABAP-Based Business Rules
23FDT_TRSYSTEMFDT Transport: virtual target systems4CREATION_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPBusiness Analytics
24UAPROJECTTransparent Table to Store Costing Projects6CREATION_TIMECreation Timenvarchar60
25UAWORKSETTransparent Table to Store Working Environments of Costing7CREATION_TIMECreation Timenvarchar60
TOPCollateral Management System
26CMS_MESSAGE_CRMKeymapping bei Datenaustausch via XI7CREATION_TIMEHora del díanvarchar60
TOPCollectionsDisbursements
27VVKK_COINSPCoinsurance Shares Item Table18CREATION_TIMETimenvarchar60
TOPCross-Application Components
28/IXOS/DC_WD_DV_Cdoc view cache6CREATION_TIMESystem Timenvarchar60
TOPCustomer Bill of Services
29BOSPS_CLUSTERBOSPS Data Cluster for variants etc6CREATION_TIMESystem Timenvarchar60
TOPE-Recruiting
30HRP5122DB Table for Infotype 512230CREATION_TIMEPublication Created Atnvarchar60
TOPFinancial Supply Chain Management
31EDX_OUTBOUNDEDX: Outbound Messages (Messages Ready to Be Sent)10CREATION_TIMEEDX: Time Message Creatednvarchar60
TOPGeneral Ledger Accounting
32FAGL_EXTR_HISTTransfer History for Summary Documents9CREATION_TIMEIDoc Created atnvarchar60
TOPInvoicing
33ERDKPrint Document/Header Data58CREATION_TIMETime of Print Document Creationnvarchar60
TOPLegal Case Management for ILM
34LHM_LEGAL_HOLDSOBSOLETE10CREATION_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
35SLCM_LH_ALILM: Legal Case Management - Legal Hold Table for AL Doc.9CREATION_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
36SLCM_LH_BORILM: Legal Case Management - Legal Hold Table for BOR Obj.9CREATION_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
37SLHM_CASE_HEADLegal Hold Management - Cases (Header Data)13CREATION_TIMETime Stamp for Legal Case Creationdecimal150
TOPliveCache Applications
38LCA_WARNINGSWarnings in the "liveCache Applications" Area5CREATION_TIMETime Stampdecimal150
TOPLoans Management
39VDCBR_HISTHistory of Data Supplied to Credit Bureau5CREATION_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
40VDCBR_RES_PARTPartner Data Reported to Credit Bureau (Pro Loan)5CREATION_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
41VDCHK_GROSS_NETStorage of data for report RFVD_GROSS_TO_NET20CREATION_TIMESystem Timenvarchar60
TOPMaintenance Processing
42ALM_ME_SIG_LINKSSignature Key - Link Table6CREATION_TIMETime in CHAR Formatnvarchar60
TOPMusing Tools
43WDKSNAPSHOTSSnapshops / Serialization6CREATION_TIMETimenvarchar60
TOPPatient Management
44NDRGIS-H: Table Containing Case-Related DRGs16CREATION_TIMEIS-H: Time when Data Record Creatednvarchar60
TOPProject System
45PSHLP_DRAFT_DBTable holds Draft Workbench Information29CREATION_TIMEDraft Creation Timenvarchar60
46PSHLP_DRAFT_DB_NTable holds Draft Workbench Information29CREATION_TIMEDraft Creation Timenvarchar60
TOPReusable Components of Business Suite Foundation
47/BOBF/DM_CST_HDRCustomer Header9CREATION_TIMECreation Timedecimal150
48/BOBF/DM_LTXT_CLong Text Content8CREATION_TIMECreation Timedecimal150
49/BOBF/DM_LTXT_RTHeader Text Collection9CREATION_TIMECreation Timedecimal150
50/BOBF/DM_PRD_HDRProduct Header (Demo)12CREATION_TIMECreation Timedecimal150
51/BOBF/DM_SORD_RTSales Order Header13CREATION_TIMECreation Timedecimal150
52/BOFU/DM_PRD_HD1Header11CREATION_TIMECreation Timedecimal150
53/BOFU/DM_PRD_HDRHeader12CREATION_TIMECreation Timedecimal150
TOPRuntime Analysis
54SATR_DIRECTORYDirectory of SAT Trace Containers4CREATION_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPSAP Healthcare - Industry-Specific Components for Hospitals
55NAPX_DRGIS-H: Appendix DRG Table15CREATION_TIMEIS-H: Time when Data Record Creatednvarchar60
TOPSAP Records Management
56SRMALATTRLISAttribute Memory, Language-Independent, Single-Value4CREATION_TIMECreated On/Atdecimal150
TOPService Data Download
57/BDL/HEADNachbau: DSVAS: Session data (header)4CREATION_TIMEnvarchar60
58BDLHEADNachbau: DSVAS: Session data (header)4CREATION_TIMEnvarchar60
59BDLSESSIONHEADNachbau: DSVAS: Session data (header)4CREATION_TIMEnvarchar60
TOPStorage and Retention Service
60DAS_COLLECTIONSILM SRS: Collections5CREATION_TIMECreated on/at (Timestamp; UTC)decimal150
61DAS_RESOURCESILM SRS: Resources6CREATION_TIMECreated on/at (Timestamp; UTC)decimal150
62DAS_STORESILM SRS: Store Administration6CREATION_TIMECreated on/at (Timestamp; UTC)decimal150
TOPTemplates
63TFW_DX_MINITPTFW: Data Exchange of Template Changes2CREATION_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPTransaction Management
64TCHT_HD_SFGDTSFGDT Representation of Instruments20CREATION_TIMEEntry Timenvarchar60
65THXET_MEAS_HEADEffectiveness Test Results19CREATION_TIMETime of Initial Entrynvarchar60
TOPTransaction Manager
66TEMT_POLICYHedging Policy20CREATION_TIMETime of Initial Entrynvarchar60
67TEMT_PROFILEPlanning profile18CREATION_TIMETime of Initial Entrynvarchar60
68TEMT_RAWEXPOSRaw Exposure24CREATION_TIMETime of Initial Entrynvarchar60
69TEMT_VERSEXPOSVersioned Exposure39CREATION_TIMETime of Initial Entrynvarchar60
70TEMT_VERSIONVersions of a Planning Profile6CREATION_TIMETime of Initial Entrynvarchar60
71TEXT_POSITIONSExposure Positions56CREATION_TIMETime of Initial Entrynvarchar60
72TEXT_POS_FLOWExposure Position Flows59CREATION_TIMETime of Initial Entrynvarchar60
73TEXT_RAWEXPOSRaw Exposure24CREATION_TIMETime of Initial Entrynvarchar60
TOPUser Interface
74WCF_UST_FOLDERShareBox folders7CREATION_TIMETime Stampdecimal217
TOPWeb Service and SOAP - ABAP
75SRT_TRC_FILESlist of all trace file names5CREATION_TIMEnvarchar60
76SRT_UTIL_ADMSRT Utilities: Administration4CREATION_TIMEnvarchar60
77SRT_UTIL_ADMINSRT Utilities: Administration5CREATION_TIMEnvarchar60
TOPWithout Description
78KAP_PSR_OBJObject: Element, Sample6CREATION_TIMECreated Atnvarchar60
TOPWorkbench Tools Editors, Painters, Modelers
79COVTKEYCoverage Analyzer: Test Key7CREATION_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
80COV_RESULTSEvaluations of Coverage Measurements8CREATION_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150