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  | CONTROL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IAM/C_STPRFACStatus Profile Action Condition8CONTROLAction Controlnvarchar10
2CNV_10992CONTROLControl table for 'Find unknown texts'4CONTROLAnalysis mode for text objectsnvarchar10
3CNV_10994CONTROLControl table for 'Find unknown change documents'4CONTROLAnalysis mode for change document objectsnvarchar10
4EHFNDD_DEF_CTRDefault Controls - Root8CONTROLControl Key Referencevarbinary160
5T7PIQFS_CONTROLControl Table3CONTROLObject Type Namenvarchar300
6T7PIQFS_CONTROLSControls Entity Table1CONTROLObject Type Namenvarchar300
TOPAgency Business Global Trade
7TMPAAgency Business: Control Data Profit Simulation4CONTROLAgency Business: Profit Analysis Controlnvarchar20
TOPBatches
8TCUDB_PRODUCTDocumentary Batch - Product (Material Type)3CONTROLDefine Documentary Batches per Material Typenvarchar10
TOPClinical System
9N1MEIMPORTi.s.h.med: Medication, Master Data Import Table5CONTROLMedication: Class of Drug Categorynvarchar10
10TN1MEDGROUPIS-H*MED: Medication Groups4CONTROLMedication: Class of Drug Categorynvarchar10
TOPCross-Application Components
11CRMPRLSName of the Logical System for Download4CONTROLText (20 Characters)nvarchar200
TOPGlobal Trade Services
12/SAPSLL/PRODWLGTS: Product Master: Global: Worklist6CONTROLControl Structure for Product Master Displaynvarchar200
TOPInternet Self-Services
13EIAC_SERVICEControl parameter: define internet self-services3CONTROLIAC Services Controlnvarchar10
14ISU_CUSTESERVICEControl Parameter for Utility Customer E-Services3CONTROLData Processingnvarchar10
TOPManagement of Internal Controls
15FOPCPRTUSERPARAUser Parameters for Print10CONTROLPrint Reports: Process Stepnvarchar90
16FOPCRBFAGLUEReporting Buffer: Account Group - Fin. Statement Assertion5CONTROLMIC Reporting: Control IDnvarchar90
17FOPCRBFCASETEXTSReport Buffer: Cases - Texts7CONTROLMIC Reporting: Control IDnvarchar90
18FOPCRBFISReporting Buffer: Cases - Issues7CONTROLMIC Reporting: Control IDnvarchar90
19FOPCRBFPGLUEReporting Buffer: P-CO-R5CONTROLMIC Reporting: Control IDnvarchar90
20FOPCRBFPLReporting Buffer: Cases - Remediation Plans7CONTROLMIC Reporting: Control IDnvarchar90
21FOPCRBFSTRReporting Buffer: Buffered Structures6CONTROLMIC Reporting: Control IDnvarchar90
22FOPCRBFTLReporting Buffer: Cases - Test Logs7CONTROLMIC Reporting: Control IDnvarchar90
TOPProcess Controls
23GRPCPRTUSERPARAUser Parameters for Print10CONTROLPrint Reports: Process Stepnvarchar90
24GRPCRBFAGLUEReporting Buffer: Account Group - Fin. Statement Assertion5CONTROLControl IDnvarchar90
25GRPCRBFASReporting Buffer: Cases - Assessments7CONTROLControl IDnvarchar90
26GRPCRBFCASETEXTSReport Buffer: Cases - Texts7CONTROLControl IDnvarchar90
27GRPCRBFISReporting Buffer: Cases - Issues7CONTROLControl IDnvarchar90
28GRPCRBFPGLUEReporting Buffer: P-CO-R5CONTROLControl IDnvarchar90
29GRPCRBFPLReporting Buffer: Cases - Remediation Plans7CONTROLControl IDnvarchar90
30GRPCRBFSTRReporting Buffer: Buffered Structures6CONTROLControl IDnvarchar90
31GRPCRBFTLReporting Buffer: Cases - Test Logs7CONTROLControl IDnvarchar90
TOPProduct definition
32TBKKG1Media6CONTROLPayment Method or Medium Controlnvarchar20
TOPProject System
33PSHLP_DRAFT_DBTable holds Draft Workbench Information15CONTROLControl Datanvarchar10
34PSHLP_DRAFT_DB_NTable holds Draft Workbench Information15CONTROLControl Datanvarchar10
TOPStructures
35PSHLP_CUST_DPROFData Selection Profile9CONTROLControl Datanvarchar10
36PSHLP_DATASET_DBTo store the user specific datasets chosen10CONTROLSingle-Character Indicatornvarchar10
TOPSyntax, Compiler, Runtime
37TTPDATOOLIDtpda: Customizing - Tools2CONTROLGeneral Flagnvarchar10
TOPTransportation and Distribution
38OIGSVMQMTD On Board Movements References8CONTROLControl flag for technical use in TDnvarchar10
TOPWork Clearance Management
39WCAITWCM: Work Clearance Document (Item)31CONTROLSwitching Locationnvarchar400
40WCAMEWCM: (Temporary) Log of Operational Lists (Items)33CONTROLSwitching Locationnvarchar400
41WCAMIWCM: Log of Operational Lists (Items)33CONTROLSwitching Locationnvarchar400