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

40 columns | Print definition?ERP 6.0  | UNIT_OF_MEASURE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GRRMANASSMNTAssessment Table12UNIT_OF_MEASURE32 Char GUIDnvarchar320
2JBRDBCOMBEWEGRM: DB Table BEWEG Extended Category of Primary Transaction9UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
3JBRHCOMBEWEGhRM: Version Table BEWEG for Extended Cat. of Primary Trans.10UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
4JBRSVCOMBEWEGRM: Flow Table for Cat. of Prim. Trans. for Saved Datasets10UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
5J_1UF_TP_PRICESIntervals of Market Prices of Controlled Transactions9UNIT_OF_MEASUREBase Unit of Measurenvarchar30
6J_3RF_TP_PRICESIntervals of Market Prices of Controlled Transactions9UNIT_OF_MEASUREBase Unit of Measurenvarchar30
7TEXT_CTY_EXPOSCommodity Price Exposure30UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
8THAEXT_EXPOS_COPObsolet: Commodity exposure pricing data9UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
9THAEXT_TRANS_COPCommodity exposure pricing data17UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
10THAEXT_TRAN_DCSPCommodity exposure DCS pricing data18UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
TOPBudgeting and Availability Control
11GMBDGTLINEBudget Document Line27UNIT_OF_MEASUREPurchase Order Unit of Measurenvarchar30
12GMHBDGTLINEBudget Line: Held Documents28UNIT_OF_MEASUREPurchase Order Unit of Measurenvarchar30
TOPCentral Part of Product Master
13COMM_PR_GTINGTIN - Global Trade Item Number4UNIT_OF_MEASUREUnits of Measure of Productnvarchar30
14COMM_PR_GTINHGTIN - Global Trade Item Number History5UNIT_OF_MEASUREUnits of Measure of Productnvarchar30
TOPChargeback
15WCOCOICondition Contract: Eligible Partner15UNIT_OF_MEASUREUnit of Measurenvarchar30
TOPExcise Duty
16/BEV2/CS_C_PCODEProduct Codes8UNIT_OF_MEASUREEMCS: Unit of Measurement for Report in e-AADnvarchar30
TOPGRC Risk Management
17GRRMANALASSMNTAssessment Table11UNIT_OF_MEASURE32 Char GUIDnvarchar320
TOPMaster Data
18CMS_ASTAsset Details50UNIT_OF_MEASUREUnit of Measure of Quantitynvarchar30
19CMS_AST_HISTAsset Value History10UNIT_OF_MEASUREUnit of Measure of Quantitynvarchar30
TOPTransaction Management
20TCHT_HD_BEWEG_CYSFGDT Commodity Flows Table9UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
TOPTransaction Manager
21OTC_CONV_FHAPOBackup Table for Financial Transaction Flows142UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
22OTC_CONV_FINKOBackup Table for Financial Transaction Conditions88UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
23OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions87UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
24TCORT_CODCODeal: Conditions74UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
25TCORT_CODULFLDeal: Underlying Flows35UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
26TEXT_POS_FLOWExposure Position Flows49UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
27TEXT_REXP_ITEMRaw Exposure Item11UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
28TEXT_REXP_SUBITSub Raw Exposures (Split Items)8UNIT_OF_MEASUREUnit of measurenvarchar30
29TEXT_TRANSACTIONUnmatched Exposure Business Transactions46UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
30THAEXT_EXPOS_COCommodity exposure7UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
31THAEXT_TRANS_COTransaction for commodity price exposure9UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
32THMHRT_HRHedge Relationship43UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
33THMT_HEDGE_ITEMHedged Item20UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
34VTBFHAPOTransaction Flow142UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
35VTBFHAPO_MIGRMigrated Financial Flows142UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
36VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows142UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
37VTBFINKOTransaction Condition88UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
38VTIFHAPOUnderlying transaction flows78UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
39VTIFINKOUnderlying transaction conditions87UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30
TOPVehicle Management System
40VLCBATCHACTVELO : Variant for Action Execution in Batch12UNIT_OF_MEASUREBase Unit of Measurenvarchar30