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
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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

23 columns | Print definition?ERP 6.0  | TARGET3

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OEE/MPH_KPITARGPlant Hierarchy KPI Target Details10TARGET3OEE KPI Targetdecimal3114
TOPFunds Management
2FMDERIVE002Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/11TARGET3Fundnvarchar100
3FMDERIVE004Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F9TARGET3Fundnvarchar100
4FMDERIVE005Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func7TARGET3Fundnvarchar100
5FMDERIVE006Derivation rule:WBS Element/CE to Commitment Item/Funds Ctr/9TARGET3Fundnvarchar100
6FMDERIVE008Profit Ctr/CE to Commit Item/Funds Center/Fund/Function9TARGET3Fundnvarchar100
7FMDERIVE009Derivation rule:Profit Center to Commitment Item/Funds Ctr/F7TARGET3Fundnvarchar100
8FMDT_CHANGEDOCEmpty table for change document on DRULE derivation tables6TARGET3Target value from Derivation tablenvarchar600
TOPGeneral Application Functions
9FMFMOAID38000016Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func7TARGET3Fundnvarchar100
10FMFMOAID38000042Derivation rule:Cost Center to all9TARGET3Funds Centernvarchar160
TOPProfitability Analysis
11K9RID34000025Derivation rule:Template determination for sales processes9TARGET3Additional update characteristicnvarchar300
12K9RID34000026Derivation rule:Template determination for sales processes9TARGET3Additional update characteristicnvarchar300
13K9RID38000012Derivation Rule: Procedure Determination for Sales Processes9TARGET3Additional update characteristicnvarchar300
14K9RID38000023Derivation Rule: Access to Cost Estimate for Transfer Prices13TARGET3Type of error handlingnvarchar10
15K9RID38000026Derivation Rule: Assignment at Material Type / Plant Level15TARGET3Third costing key (CO-PA)nvarchar30
16K9RID38000028Derivation Rule: Access to Material Type Level13TARGET3Third costing key (CO-PA)nvarchar30
17K9RID38000030Derivation Rule: Access to Cost Estimate for Transfer Prices13TARGET3Third costing key (CO-PA)nvarchar30
18K9RID38000043Ableitungsregel:7TARGET3Limitproduktgruppe ohne und mit Rahmenzusagenvarchar30
19K9RID38000044Ableitungsregel:Foreign Exchange9TARGET3Limitproduktgruppe ohne und mit Rahmenzusagenvarchar30
20K9RID38000045Ableitungsregel:Loans7TARGET3Limitproduktgruppe ohne und mit Rahmenzusagenvarchar30
21K9RID38000046Ableitungsregel:Money Market7TARGET3Limitproduktgruppe ohne und mit Rahmenzusagenvarchar30
22K9RID38000047Ableitungsregel:Depot-Gattungsbestand7TARGET3Limitproduktgruppe ohne und mit Rahmenzusagenvarchar30
23K9RID38000048Ableitungsregel:Risikoträger7TARGET3Limitproduktgruppe ohne und mit Rahmenzusagenvarchar30