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

27 columns | Print definition?ERP 6.0  | SIDE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1LOP_D_LIST_HDOption list header14SIDESidenvarchar10
2TEXT_CTY_EXPOSCommodity Price Exposure53SIDEDirection of Transactionnvarchar10
3TLRC_THM_SCHEMEThreshold Scheme Definition6SIDESide to Be Used to Calculate Rolling Average Positionnvarchar10
4TLRT_THM_RES_POSThreshold Result Position Data5SIDEDirection of Transactionnvarchar10
5WBCPM_C_STA_TPCPM Calc Types per Status Type (for Header)8SIDESide Relevance of a Status Typenvarchar10
6ZMTMPERSCM MtM Persistency11SIDEDirection of Transactionnvarchar10
TOPBudgeting
7BUCC_RULE_OPDConsistency Checks - Operands6SIDEConsistency Checks - Operand Sidenvarchar10
TOPFunds Management
8FMFGRCNFACTORReconciliation: Factors in a reconciliation rule4SIDEReconciliation: side of equation for a factornvarchar10
TOPGlobal Trade
9WB2_C_CAT2COMassignment of commodity item category to TC item category3SIDESidenvarchar20
10WB2_C_CAT2PRassignment of pricing categories to comm. item cat.2SIDESidenvarchar20
11WB2_C_COMSUBcommodity item category2SIDESidenvarchar20
12WB2_C_COMSUBTcommodity item category3SIDESidenvarchar20
13WB2_C_PRpricing aspect2SIDESidenvarchar20
14WB2_C_PRTtext table for pricing aspects3SIDESidenvarchar20
15WB2_D_COMSUBTrading Contract: commodity sub items4SIDESidenvarchar20
16WB2_D_PRASPTrading Contract: pricing aspects4SIDESidenvarchar20
17WB2_D_SHD_ITEMShadow Items5SIDESidenvarchar20
18WB2_D_SHD_PRASPPricing aspects of shadow items4SIDESidenvarchar20
TOPPosition Management
19WBCUMULGlobal Trade: Aggregation Table7SIDESidenvarchar10
20WBITAssociation Item at Step Level15SIDESidenvarchar10
TOPTalent Management
21T5TMCTPCATDATCustomizing for Category of Detailed Talent Profile9SIDEScreen Side for Displaying Category in Overviewnvarchar10
22T5TMCTPCATDATSCustomizing for Category of Detailed Profile (S Table)9SIDEScreen Side for Displaying Category in Overviewnvarchar10
TOPTrading Contract
23TPROFIT2_CUSTTrading Contract: Table of Status Fields6SIDESidenvarchar10
24TPROFIT2_CUST_TTrading Contract: Table of Status Fields7SIDESidenvarchar10
25WBGTGlobal Trade: Generic Document Information34SIDESidenvarchar10
TOPTrading Execution Workbench
26TEWSTEPBusiness Process Step10SIDESidenvarchar10
TOPTransaction Manager
27TCORT_CODMDDeal: Main Data6SIDEDirection of Transactionnvarchar10