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

36 columns | Print definition?ERP 6.0  | TARGET2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OEE/MPH_KPITARGPlant Hierarchy KPI Target Details9TARGET2OEE KPI Targetdecimal3114
TOPFunds Management
2FMDERIVE002Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/10TARGET2Funds Centernvarchar160
3FMDERIVE004Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F8TARGET2Funds Centernvarchar160
4FMDERIVE005Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func6TARGET2Funds Centernvarchar160
5FMDERIVE006Derivation rule:WBS Element/CE to Commitment Item/Funds Ctr/8TARGET2Funds Centernvarchar160
6FMDERIVE008Profit Ctr/CE to Commit Item/Funds Center/Fund/Function8TARGET2Funds Centernvarchar160
7FMDERIVE009Derivation rule:Profit Center to Commitment Item/Funds Ctr/F6TARGET2Funds Centernvarchar160
8FMDT_CHANGEDOCEmpty table for change document on DRULE derivation tables5TARGET2Target value from Derivation tablenvarchar600
TOPGeneral Application Functions
9FMFMOAID38000003Derivation rule:6TARGET2Functional Areanvarchar160
10FMFMOAID38000016Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func6TARGET2Funds Centernvarchar160
11FMFMOAID38000042Derivation rule:Cost Center to all8TARGET2Fundnvarchar100
TOPProfitability Analysis
12ACEDTF7300087Derivation rule:Posting Rule to GL Accounts8TARGET2Start Accountnvarchar100
13ACEID38000035Règle dérivat.:Comptes FR8TARGET2Compte ciblenvarchar100
14ACEID38000040Ableitungsregel:Accounts for other accrual types (costs)12TARGET2Startkontonvarchar100
15ACEID38000042Ableitungsregel:Accounts for accrual type INSURA8TARGET2Startkontonvarchar100
16ACEID38000056Derivation rule:OR Accruals IPM HT - Account Determination8TARGET2Target accountnvarchar100
17FILADTF7300081Derivation rule:Derivation of Classification12TARGET2Check Sequence in Financing Classificationnvarchar100
18FILADTF7300082Derivation rule:Derivation of Useful Life10TARGET2Time Unitnvarchar10
19FOTPDTF7300088Derivation rule:One Time Postings Acc.Princ. 0110TARGET2Offsetting Accountnvarchar100
20FOTPDTF7300089Derivation rule:One Time Postings Acc.Princ. 6010TARGET2Offsetting Accountnvarchar100
21K9RID34000022Derivation rule:12TARGET2Plant used for reading cost estimatenvarchar40
22K9RID34000025Derivation rule:Template determination for sales processes8TARGET2Additional update characteristicnvarchar300
23K9RID34000026Derivation rule:Template determination for sales processes8TARGET2Additional update characteristicnvarchar300
24K9RID38000012Derivation Rule: Procedure Determination for Sales Processes8TARGET2Additional update characteristicnvarchar300
25K9RID38000023Derivation Rule: Access to Cost Estimate for Transfer Prices12TARGET2Second costing key (CO-PA)nvarchar30
26K9RID38000026Derivation Rule: Assignment at Material Type / Plant Level14TARGET2Second costing key (CO-PA)nvarchar30
27K9RID38000028Derivation Rule: Access to Material Type Level12TARGET2Second costing key (CO-PA)nvarchar30
28K9RID38000030Derivation Rule: Access to Cost Estimate for Transfer Prices12TARGET2Second costing key (CO-PA)nvarchar30
29K9RID38000043Ableitungsregel:6TARGET2Kennzeichen AR - Aktivnvarchar10
30K9RID38000044Ableitungsregel:Foreign Exchange8TARGET2Kennzeichen AR - Aktivnvarchar10
31K9RID38000045Ableitungsregel:Loans6TARGET2Kennzeichen AR - Aktivnvarchar10
32K9RID38000046Ableitungsregel:Money Market6TARGET2Kennzeichen AR - Aktivnvarchar10
33K9RID38000047Ableitungsregel:Depot-Gattungsbestand6TARGET2Kennzeichen AR - Aktivnvarchar10
34K9RID38000048Ableitungsregel:Risikoträger6TARGET2Kennzeichen AR - Aktivnvarchar10
TOPRental Accounting
35ACESLN0000003Ableitungsregel:Konten10TARGET2Doelrekeningnvarchar100
36ACESLN1000002Derivation Rule: Accounts10TARGET2Target accountnvarchar100