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

41 columns | Print definition?ERP 6.0  | CREATION_USER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/NLG_INAGBA Interface: Incoming Message Header22CREATION_USERCreated Bynvarchar120
2/GSINS/NLG_OUTAGBA Interface: Outgoing Message Header12CREATION_USERCreated Bynvarchar120
3CNVCDOP_PROJDEFCDOP - Master table for Definition of CDOP Projects3CREATION_USERCDOP - Project Definition Created Bynvarchar120
4CNVCDOP_PROJECTSCDOP - Projects3CREATION_USERCDOP - Project Created Bynvarchar120
5CNVMBTACTGRPActivity Groups5CREATION_USERnvarchar300
6CNVMBTCUSTTREECustomizing data for a displayed tree9CREATION_USERGeneral Flagnvarchar10
7CNVMBTPACKpackage information/creator/creation date/scenarion5CREATION_USERnvarchar300
8CNVMBTPROJECTExisting Migration Projects5CREATION_USERnvarchar300
9CNVMBTSUBPROJECTsupprojects / mass transfer ID- relation to project7CREATION_USERnvarchar300
10TLRT_TARO_DOCTrade Repository: Documents10CREATION_USERFile Creation Usernvarchar120
11TN11SLocks for Building Units10CREATION_USERIS-H: Name of Employee who Created Recordnvarchar120
12TREAT_NOVATIONTreasury: Novation4CREATION_USERCFM: Fixing Processornvarchar120
13TRTM_CHG_PARTNERTreasury: Change partner6CREATION_USERCFM: Fixing Processornvarchar120
TOPArchiving Connector ABAP
14ARC_TRANS_COMPCompare Units of Measurement and Currencies7CREATION_USERUser Name in User Master Recordnvarchar120
TOPBusiness Analytics
15UAPROJECTTransparent Table to Store Costing Projects7CREATION_USERCreated Bynvarchar120
16UAWORKSETTransparent Table to Store Working Environments of Costing8CREATION_USERCreated Bynvarchar120
TOPBusiness Partner
17RATINGSRatings10CREATION_USERUser Who Created Ratingnvarchar120
TOPCustom Development Management Cockpit
18CNVCDMC_PROJDEFCDMC - Master table for Definition of CDMC Projects3CREATION_USERCDMC - Project Definition Created Bynvarchar120
19CNVCDMC_PROJECTSCDMC - Projects3CREATION_USERCDMC - Project Created Bynvarchar120
TOPMaterial Master
20WER_EVENT_ARule Engine event7CREATION_USERUser Namenvarchar120
21WER_EVENT_SRule Engine event6CREATION_USERUser Namenvarchar120
TOPNetWeaver Enterprise Search
22ESH_AT_CONFIGRegister connectors for auto tagging6CREATION_USERUser namenvarchar120
23ESH_AT_TAGGINGData of last tagging11CREATION_USERUser namenvarchar120
24ESH_CM_SYS_COUPSystem Coupling for Tagging scenarios9CREATION_USERUser namenvarchar120
TOPPatient Management
25NDRGIS-H: Table Containing Case-Related DRGs17CREATION_USERIS-H: Name of Employee who Created Recordnvarchar120
TOPSAP Healthcare - Industry-Specific Components for Hospitals
26NAPX_DRGIS-H: Appendix DRG Table16CREATION_USERIS-H: Name of Employee who Created Recordnvarchar120
TOPService Data Download
27/BDL/HEADNachbau: DSVAS: Session data (header)5CREATION_USERnvarchar120
28BDLHEADNachbau: DSVAS: Session data (header)5CREATION_USERnvarchar120
29BDLSESSIONHEADNachbau: DSVAS: Session data (header)5CREATION_USERnvarchar120
TOPStorage and Retention Service
30DAS_COLLECTIONSILM SRS: Collections6CREATION_USERUser who created the objectnvarchar120
31DAS_RESOURCESILM SRS: Resources7CREATION_USERUser who created the objectnvarchar120
32DAS_STORESILM SRS: Store Administration5CREATION_USERUser who created the objectnvarchar120
TOPTransaction Management
33THXET_MEAS_HEADEffectiveness Test Results20CREATION_USEREntered bynvarchar120
TOPTransaction Manager
34TEMT_POLICYHedging Policy21CREATION_USEREntered bynvarchar120
35TEMT_PROFILEPlanning profile19CREATION_USEREntered bynvarchar120
36TEMT_RAWEXPOSRaw Exposure25CREATION_USEREntered bynvarchar120
37TEMT_VERSEXPOSVersioned Exposure40CREATION_USEREntered bynvarchar120
38TEMT_VERSIONVersions of a Planning Profile7CREATION_USEREntered bynvarchar120
39TEXT_POSITIONSExposure Positions57CREATION_USEREntered bynvarchar120
40TEXT_POS_FLOWExposure Position Flows60CREATION_USEREntered bynvarchar120
41TEXT_RAWEXPOSRaw Exposure25CREATION_USEREntered bynvarchar120