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

42 columns | Print definition?ERP 6.0  | CREA_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/MIG_REQUESTMigrationsauftrag4CREA_DATEErzugungsdatum Migrationsauftragnvarchar80
2/XFT/SRMSWORGARLSwitch Table for Original ARL3CREA_DATEField of type DATSnvarchar80
3/XFT/SRMSWORGDOCSwitch Table for Original DOC3CREA_DATEField of type DATSnvarchar80
4LXE_PPProposals11CREA_DATEDatenvarchar80
5LXE_PP_ABBAbbreviations9CREA_DATEDatenvarchar80
6SCI_DCTHDB_TEWA Data for HDB Index Check (Filled via WebService)7CREA_DATEnvarchar80
7SCI_DCTHDB_WEWA Data for HDB Index Check (Filled via WebService)7CREA_DATEnvarchar80
8STERM_COMP_WEBCustomer-Defined Components for Terminology Maintenance5CREA_DATECreated Onnvarchar80
9ZSKSYSUSERuser in den IDES-Systemen15CREA_DATEnvarchar80
TOPBasic functions
10HUINV_HDRHandling Unit: Phys. Inv. Document Header8CREA_DATEDate on which the data record was addednvarchar80
TOPBusiness Object Builder
11TOJTBBusiness object repository: Basic data12CREA_DATEDate of first changenvarchar80
TOPContract Accounts Receivable and Payable
12IST_BTACTIS-T Disconnection Number: Disconnection Activity17CREA_DATEDate of first changenvarchar80
TOPCountry-Specific Objects
13DMEE_ABADMEE Format Tree: General Data4CREA_DATEDMEE: date on which a DMEE format tree was creatednvarchar80
TOPCross-Application Components
14/IXOS/DC_TBCDOCLink table for changeable word documents10CREA_DATESystem Datenvarchar80
TOPCustomer Interaction Center
15EWBPROCXFront Office Process6CREA_DATEDate of first changenvarchar80
16EWFCONFront Office Configuration16CREA_DATEDate of first changenvarchar80
TOPCustomer Service
17EDISCACTDiscDoc.: Activities31CREA_DATEDate of first changenvarchar80
TOPEngineering Change Management
18CCSEQ_ACTIVE(De)activate Change Sequence Graph4CREA_DATECreated onnvarchar80
TOPF1 Help
19HLPRESOLCClient-Dependent Context Chains6CREA_DATEChanged Onnvarchar80
20HLPRESOLSDefault Context Chain5CREA_DATEChanged Onnvarchar80
TOPFSCM In-House Cash
21IHC_DB_RT_TREEIHC: Routing Tree5CREA_DATEDate Object Created or Changednvarchar80
TOPIntegration Customer Relationship Management
22EPDESCIS-U MD template description: header entries12CREA_DATEDate of first changenvarchar80
TOPKnowledge Warehouse
23IWAREADESTKEN: AREA-Specific Destinations (for KEN Interfaces)5CREA_DATECreation datenvarchar80
24IWDOCFRMTDocument Formats that are Supported in KW4CREA_DATECreated onnvarchar80
25IWEXTENDEnhancement Information: Add-On and Customer4CREA_DATEChanged Onnvarchar80
26IWFLDRGRPFolder groups3CREA_DATECreated onnvarchar80
27IWINDUSTRYKEN: Industry sectors and their root sectors5CREA_DATEChanged Onnvarchar80
28IWPROPVALValid Attribute Values (Classes or Area-Specific)5CREA_DATECreated onnvarchar80
29KWCHAINKEN: Industry sectors and their root sectors9CREA_DATEChanged Onnvarchar80
TOPLocalization
30DMEE_TREEDMEE Format Tree: General Data4CREA_DATEDMEE: date on which a DMEE format tree was creatednvarchar80
TOPSAP Ambulatory Care Management
31NREDOMAIS-H: Table Renewable Documents - Header Data13CREA_DATERenewable Document - Determination Datenvarchar80
TOPSAP Business Workflow
32SWEQUEUEEvent Queue for Temporary Storage of Triggered Events18CREA_DATESystem Datenvarchar80
33SWFREVTPOQProcess Observation : Event Queue10CREA_DATESystem Datenvarchar80
34SWF_MLOBJWorkflow: Relation Mail/Work Item6CREA_DATEWorkflow: Creation Time Stampdecimal217
TOPTerminologyGlossary
35STERM_ADDCCustomer-Defined Components for Terminology Maintenance5CREA_DATECreated Onnvarchar80
36STERM_EXTDEnhancement Information: Add-On and Customer4CREA_DATEnvarchar80
37STERM_XTNDEnhancement Information: Add-On and Customer4CREA_DATEnvarchar80
TOPTransaction Tax Engine
38TTED_INDOC_COMInput Document5CREA_DATECreated Onnvarchar80
39TTED_OUTDOC_COMOutput Document5CREA_DATECreated Onnvarchar80
40TTEPD3_DOCUMENT3.0 TTE Persistency Document9CREA_DATECreated Onnvarchar80
41TTEPDT_DOCUMENTTTE Persistency Document9CREA_DATECreated Onnvarchar80
42TTESDT_DOCUMENTTTE Simulaton Document7CREA_DATECreated Onnvarchar80