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

33 columns | Print definition?ERP 6.0  | MDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/MIG_TDOCDocument head8MDATEChange datenvarchar80
2/XFT/MIG_TDOCPOSDocument head9MDATEChange datenvarchar80
3CNVMBTCOTOBJECTSLO Central Object Table16MDATESLO COT Modification Datenvarchar80
4SSF_PSE_HISTPSE History11MDATEModification datenvarchar80
5SSF_PSE_LConfiguration Table for PSE File Mode9MDATEModification datenvarchar80
6T7CNTPM_PROCRECTPM: Process Record9MDATEDatenvarchar80
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
7DBDIFFINFOFurther Info on DBDIFF (Differences between DD and DB)11MDATEDate of Last Changenvarchar80
TOPDictionary Maintenance
8GSUBT_LOCALControl Table for GSUBTYPE Registration5MDATESystem Datenvarchar80
9SUBT_LOCAL_CHECKControl Table for Consistency Check5MDATESystem Datenvarchar80
TOPGlobal Trade Services
10/SAPSLL/ITARAUDDITAR Tracking: Log - Item Data12MDATEDate of Relevant Goods Movementdecimal150
TOPInternet Communication Framework
11ICFAPPLICATIONICF: Application Table for Creating Service with API13MDATEChanged Onnvarchar80
TOPMaster Data
12PLSCPlanning scenarios in long-term planning7MDATEPlng scenario: key date for chnge status of material masternvarchar80
TOPProfile Maintenance
13TPFHSPrototype: Profile header, administration data for profiles7MDATEData of last profile changenvarchar80
14TPFHTProfile header, administration data for profiles in DB7MDATEData of last profile changenvarchar80
15TPFYPROPTYParameter attributes14MDATEData of last profile changenvarchar80
TOPPublic Sector Contract Accounts Receivable and Payable
16DFMCA_BRF_MSGTax Calculation and Validation: Error Messages11MDATEDatenvarchar80
TOPReal Estate Slovakia
17VIXCSKTAXASSESProperty Tax - Tax Assessment11MDATEDatenvarchar80
TOPSecure Network Communications
18RFCDESSECUSNC extensions for RFC destinations10MDATEModification datenvarchar80
19SNCSYSACLSNC Access Control List (ACL): Systems15MDATEModification datenvarchar80
20TXCOMSECUSNC extension for CPIC destinations9MDATEModification datenvarchar80
21USRACLSNC Access Control List (ACL): User11MDATEModification datenvarchar80
22USRACLEXTExtended SNC Access Control List (ACL) for Users11MDATEModification datenvarchar80
23USREXTIDAssignment of External ID to Users14MDATEModification datenvarchar80
24USREXTIDHExternal ID (Access Using Hash Value)8MDATEModification datenvarchar80
TOPSecure Store and Forward
25SSF_PSE_HSSF: Personel Security Environment10MDATEModification datenvarchar80
TOPSystem Administration Assistant
26SAACOMPValid components for System Administration Assistant9MDATESystem Datenvarchar80
27SAACONTC2Customizing for more system administration (SSAA)3MDATESystem Datenvarchar80
TOPTransport Organizer
28CUSDVCLANGDevelopment Class: Original Language for Table Entries6MDATESystem Datenvarchar80
29CUSDVCORIGDevelopment Class: Original Location for Table Entries8MDATESystem Datenvarchar80
30TABDIRDEVCAssignment of Development Class to Table Entries9MDATESystem Datenvarchar80
31TABDIRLANGAssignment of Original Language to Table Entries9MDATESystem Datenvarchar80
32TABDIRORIGAssignment of Original Language to Table Entries11MDATESystem Datenvarchar80
33TABREFINEDetermines Granularity for Originality Attributes9MDATESystem Datenvarchar80