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

53 columns | Print definition?ERP 6.0  | UDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_A_1_CMODcustmer exit objetcs inforamtion for cmis analysis10UDATChanged Onnvarchar80
2CNVCMIS_A_1_REPSSelection of Object Type Prog Master information17UDATChanged Onnvarchar80
3CNVCMIS_A_1_TYPEType Pool Information Table(CMIS)21UDATChanged Onnvarchar80
4CNVC_SCOL_CCACHEChecksum cache for SCOL6UDATChanged Onnvarchar80
5CNVMBTINCLMBT PCL: Includes to be integrated in Conversion Objects7UDATChanged Onnvarchar80
6CNV_10940_REPTable for Reports8UDAT(8-character) Date for SYSTnvarchar80
7DDSQLSCSRCSource Code Buffer for Database Procedure Proxies9UDATChanged Onnvarchar80
8SAPACOREPOSITORYRepository for SAP ABAP Connector7UDATChanged Onnvarchar80
9SDDIC_DDLS_MOCKDDLS Mock Data4UDATChanged Onnvarchar80
10T801UReport Writer: Standard Layouts (Language-Independent Part)7UDATDate on which object was last changednvarchar80
TOPBasic Data
11P444VPlanning Versions: Info Structures8UDATChanged Onnvarchar80
12P44VPlanning Versions8UDATChanged Onnvarchar80
TOPBasic Functions
13T800OObject management FI-GL/FI-SL6UDATChanged Onnvarchar80
14T807HRollup Header Information17UDATDate on which object was last changednvarchar80
15T888MFI-SL Field Assignments9UDATChanged Onnvarchar80
TOPClientServer Technology
16D342LTable for long CUA objects6UDATCHAR08 data element for SYSTnvarchar80
17D345TTable for Long GUI Objects (Texts)6UDATCHAR08 data element for SYSTnvarchar80
18D346TTable for Long GUI Objects (Texts)5UDATCHAR08 data element for SYSTnvarchar80
19REPOLOADReport Loads (Loads and Line References)6UDATChanged Onnvarchar80
20REPOSRCReport Source Code20UDATChanged Onnvarchar80
21REPOTEXTReport Texts5UDATChanged Onnvarchar80
TOPCost Center Accounting
22TKSR1Summarization - header data17UDATDate on which object was last changednvarchar80
TOPCustomer Enhancements
23MODATTRAttributes of Extension Projects6UDATChanged Onnvarchar80
24MODSAPAAttributes SAP Extensions6UDATChanged Onnvarchar80
TOPDistribution Requirements Planning
25MDRP_DRUNDeployment run11UDATChanged Onnvarchar80
TOPGeneral Ledger Accounting
26FAGL_BCF_FIELDSSummarization: Balance Carryforward for P&L Accounts5UDATChanged Onnvarchar80
27FAGL_CUST_FIELDSCustomer fields for flexible general ledger5UDATChanged Onnvarchar80
28FAGL_FIELD_MOVECConversion Table for Customer Fields of General Ledger8UDATChanged Onnvarchar80
29FAGL_LEDGER_SCENActive Scenarios of a Ledger5UDATChanged Onnvarchar80
30T800FConversion Table for New General Ledger Fields6UDATChanged Onnvarchar80
31T888GCustomer fields for flexible general ledger6UDATChanged Onnvarchar80
32T888SUpdate flexible general ledger: Standard scenarios10UDATChanged Onnvarchar80
TOPInformation System
33T800Report Writer: Reports8UDATDate on which object was last changednvarchar80
34T801HReport Writer: Parallel Reports9UDATDate on which object was last changednvarchar80
35T801KReport Writer: Libraries7UDATDate on which object was last changednvarchar80
36T801XReport Writer: Standard Layout - Lang. Independent (new)89UDATDate on which object was last changednvarchar80
TOPPayroll
37T5HPBS_HAVIBONTComm. - payments monthly breakdown by persons16UDATDate of bank transfernvarchar80
TOPPrint Workbench
38EFRMGENTRDIRPrint Workbench: TRDIR Entry in Form Class Library in Gener.12UDATChanged Onnvarchar80
TOPRemaining Beverage - Obsolete Objects
39/BEV1/RBDNUMScreen for Value Field of CO-PA Individual Record Postings5UDATChanged Onnvarchar80
TOPSales Plan
40ERKOEvent Header8UDATChanged Onnvarchar80
41ERZUEvent Assignment17UDATChanged Onnvarchar80
42LISPLBackground Job for LIS Planning12UDATChanged Onnvarchar80
43P445VSales and Operations Planning: Versions11UDATChanged Onnvarchar80
44P445XLIS Planning Versions Table9UDATChanged Onnvarchar80
45T445PPlanning Types: LIS/SOP17UDATChanged Onnvarchar80
TOPSCM Basis
46/SAPAPO/DP440GMaster Forecast Profile (APO0300)36UDATChanged Onnvarchar80
47/SAPAPO/DP_ALERTProfile for Filtering Output to Alert Monitor11UDATChanged Onnvarchar80
48/SAPAPO/TIMESERITime Series in Forecast21UDATChanged Onnvarchar80
TOPSyntax, Compiler, Runtime
49SHMM_TRC_GLOBALShared Memory Monitor Trace: Global Control4UDATnvarchar80
50TODOSTODO: Exclude programs from individual SLIN checks14UDATnvarchar80
TOPTools
51T52SMHRPAY-Status Management: Attributes of a Process Model6UDATChanged Onnvarchar80
TOPWorkbench Tools Editors, Painters, Modelers
52CONTCOMPControl Composites7UDATChanged Onnvarchar80
53COVTKEYCoverage Analyzer: Test Key6UDATChanged Onnvarchar80