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

31 columns | Print definition?ERP 6.0  | CONTAINER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPQUERY/T211Single Container Flight Booking11CONTAINERContainer Sizenvarchar10
2DMC_STREE_TRACEMWB: Trace storage for table DMC_STREE5CONTAINERMWB: GUID of a Container for Metadatanvarchar220
TOPAlert Framework
3SALRTAlert: Instance Table7CONTAINERGUID in 'CHAR' Format in Uppercasenvarchar320
TOPApplication Framework
4MDG_TR_TCATDirectory of Transport Objects5CONTAINERContainer Transport Indicatornvarchar10
5MDG_TR_TCATOAttributes of Obsolete Transport Objects6CONTAINERContainer Transport Indicatornvarchar10
TOPBasic Functions
6VESEDSED / AERP Export34CONTAINERID: Goods cross border in a containernvarchar10
7VEXAVEXTRASTAT / VAR Export/Import17CONTAINERID: Goods cross border in a containernvarchar10
TOPBusiness Partner
8TXO_GEN_DBXO-User-Specific Generic Database Table7CONTAINERimage21474836470
TOPData Conversion
9DMC_STREEDMC: Tree Structure for Administration of Structures2CONTAINERMWB: GUID of a Container for Metadatanvarchar220
10DMC_STREETDMC: Structure Names3CONTAINERGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
TOPElectronic Data Interchange
11PRICAT_K003PRICAT: Catalog item basic data20CONTAINERContainer requirementsnvarchar20
12PRICAT_K003_PROIndication of Data to be Adopted from PRICAT_K00318CONTAINERIndicator for copying catalog datanvarchar10
TOPFinancials Basis
13FINB_TR_TCATFINB TR: Directory of Transport Objects5CONTAINERFINB TR: Container Transport Flagnvarchar10
14FINB_TR_TCATOFINB TR: Attributes of Obsolete Transport Objects6CONTAINERFINB TR: Container Transport Flagnvarchar10
TOPFunds Management
15FMDERIVE_LOCKSReference to data container which contains the intervals3CONTAINERGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
TOPGeneral Ledger Accounting
16FAGL_VAL_LOCKSReference to the Data Container Containing the Intervals3CONTAINERGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
TOPIncentive and Commission Management ICM
17FPP_RUNSRun Data for Parallel Processing8CONTAINERIdentification of a Data Containernvarchar220
TOPManagement of Internal Controls
18FOPCSTARTPAGEStart Page Configuration3CONTAINERInformation Container on the MIC Start Pagenvarchar100
TOPPost Processing Framework
19PPFTMETHCUPPF: Medium Method Call (Customizing)4CONTAINERID for Parameter Conditionnvarchar320
20PPFTMETHRUPPF: Medium Method Call (Runtime)10CONTAINERID for Parameter Conditionnvarchar320
21PPFTMETHTEPPF: Medium Method Call (Template)10CONTAINERID for Parameter Conditionnvarchar320
22PPFTWFRUPPF: Workflow Medium (Runtime)12CONTAINERID for Parameter Conditionnvarchar320
23PPFTWFTEPPF: Workflow Medium (Template)10CONTAINERID for Parameter Conditionnvarchar320
TOPProcess Controls
24GRPCSTARTPAGEStart Page Configuration3CONTAINERInformation Container on the PC Start Pagenvarchar100
TOPProduct Cost Planning
25WSCONTENTWorkspace Content (Unit Costing)6CONTAINERName of worklist or of container in worklistnvarchar200
TOPTransaction Variant and Table Control Settings
26SHDFVTransaction variants: Field contents15CONTAINERBDC field namenvarchar1320
27SHDFVCITransaction variants: Field contents (cross-client)14CONTAINERBDC field namenvarchar1320
28SHDSVFVCIScreen variants: Field contents11CONTAINERBDC field namenvarchar1320
TOPTranslation Tools
29LXE_TMTranslation19CONTAINERSingle-Character Indicatornvarchar10
TOPWaste Management
30EWACUSTENVIS-U Waste, Information Cluster Builder: Parameters16CONTAINERDisplay Activation for Cluster Builder Object Levelnvarchar10
31EWA_ORDER_OBJECTItem Table for Waste Disposal Order4CONTAINERSerial Number of Containernvarchar180