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

104 columns | Print definition?B1 8.82  | OBJECTTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1CDPMDynamic Permission3ObjectTypeObject TypeInt110
2OCMNCustomized Menu7ObjectTypeTarget Object TypeInt110
3OUTBUser Tables4ObjectTypeObject TypenVarChar2000
TOPBanking
4ARC7Incoming Payments - Tax Amount per Document - History12ObjectTypeObject TypenVarChar20024
5ARC8Incoming Payment - TDS Entries - History6ObjectTypeObject TypenVarChar20024
6PDF7Payment Draft - Tax Amount per Document12ObjectTypeObject TypenVarChar20024
7PDF8Payment Draft - TDS Entries6ObjectTypeObject TypenVarChar200
8PMV8Incoming Payment - TDS Entries6ObjectTypeObject TypenVarChar20024
9RCT7Incoming Pmt - Tax Amount per Document12ObjectTypeObject TypenVarChar20024
10RCT8Incoming Payment - TDS Entries6ObjectTypeObject TypenVarChar20024
11TMP8Incoming Payment - TDS Entries6ObjectTypeObject TypenVarChar20024
12VPM7Outgoing Payments - Tax Amount per Document12ObjectTypeObject TypenVarChar20046
13VPM8Outgoing Payment - TDS Entries6ObjectTypeObject TypenVarChar20046
TOPFinance
14VTR1Tax Groups5ObjectTypeObject TypeVarChar10
TOPInventory and Production
15IGE12Goods Issue - Tax Extension26ObjectTypeObject TypenVarChar20060
16IGE14Goods Issue - Assembly - Rows9ObjectTypeobject typenVarChar20060
17IGE4Goods Issue - Tax Amount per Document17ObjectTypeObject TypenVarChar20013
18IGN12Goods Receipt - Tax Extension26ObjectTypeObject TypenVarChar20059
19IGN14Goods Receipt - Assembly - Rows9ObjectTypeobject typenVarChar20059
20IGN4Goods Receipt - Tax Amount per Document17ObjectTypeObject TypenVarChar20013
21WTQ12Inventory Transfer Request - Tax Extension26ObjectTypeObject TypenVarChar2001250000001
22WTQ14Inventory Transfer Request - Assembly - Rows9ObjectTypeObject TypenVarChar2001250000001
23WTQ4Inventory Transfer Request - Tax Amount per Document17ObjectTypeBase Amount (SC)nVarChar200
24WTR12Inventory Transfer - Tax Extension26ObjectTypeObject TypenVarChar20067
25WTR14Inventory Transfer - Assembly - Rows9ObjectTypeobject typenVarChar20067
26WTR4Inventory Transfer - Tax Amount per Document17ObjectTypeObject TypenVarChar20013
TOPMarketing Documents
27ADO12A/R Invoice - Tax Extension - History26ObjectTypeObject TypenVarChar200
28ADO14Invoice - Assembly - Rows - History9ObjectTypeobject typenVarChar200
29ADO4Documents - Tax - History17ObjectTypeBase Amount (SC)nVarChar200
30CIN12Correction Invoice - Tax Extension26ObjectTypeObject TypenVarChar200132
31CIN4Correction Invoice - Tax Amount per Document17ObjectTypeObject TypenVarChar200132
32CPI12A/P Correction Invoice - Tax Extension26ObjectTypeObject TypenVarChar200163
33CPI14A/P Correction Invoice - Assembly - Rows9ObjectTypeobject typenVarChar200163
34CPI4A/P Correction Invoice - Tax Amount per Document17ObjectTypeObject TypenVarChar200163
35CPV12A/P Correction Invoice Reversal - Tax Extension26ObjectTypeObject TypenVarChar200164
36CPV14A/P Correction Invoice Reversal - Assembly - Rows9ObjectTypeobject typenVarChar200164
37CPV4A/P Correction Invoice Reversal - Tax Amt per Doc.17ObjectTypeObject TypenVarChar200164
38CSI12A/R Correction Invoice - Tax Extension26ObjectTypeObject TypenVarChar200165
39CSI14A/R Correction Invoice - Assembly - Rows9ObjectTypeobject typenVarChar200165
40CSI4A/R Correction Invoice - Tax Amount Per Document17ObjectTypeObject TypenVarChar200165
41CSV12A/R Correction Invoice Reversal - Tax Extension26ObjectTypeObject TypenVarChar200166
42CSV14A/R Correction Invoice Reversal - Assembly - Rows9ObjectTypeobject typenVarChar200166
43CSV4A/R Correction Invoice Reversal - Tax Amount Per Document17ObjectTypeObject TypenVarChar200166
44DLN12Delivery - Tax Extension26ObjectTypeObject TypenVarChar20015
45DLN14Delivery Notes - Assembly - Rows9ObjectTypeobject typenVarChar20015
46DLN4Delivery - Tax Amount per Document17ObjectTypeObject TypenVarChar20015
47DPI12Down Payment In - Tax Extension26ObjectTypeObject TypenVarChar200203
48DPI14A/R Down Payment - Assembly - Rows9ObjectTypeobject typenVarChar200203
49DPI4A/R Down Payment - Tax Amount per Document17ObjectTypeObject TypenVarChar200203
50DPO12Down Payment - Tax Extension26ObjectTypeObject TypenVarChar200204
51DPO14A/P Down Payment - Assembly - Rows9ObjectTypeobject typenVarChar200204
52DPO4A/P Down Payment - Tax Amount per Document17ObjectTypeObject TypenVarChar200204
53DRF12Draft - Tax Extension26ObjectTypeObject TypenVarChar200112
54DRF14Draft - Assembly - Rows9ObjectTypeobject typenVarChar200
55DRF4Draft Documents - Tax17ObjectTypeObject TypenVarChar20013
56IEI12Incoming Excise Invoice - Tax Extension26ObjectTypeObject TypenVarChar200140000010
57IEI14Incoming Excise Invoice - Assembly - Rows9ObjectTypeobject typenVarChar200140000010
58IEI4Incoming Excise Invoice - Tax Amount per Document17ObjectTypeObject TypenVarChar200140000010
59INV12A/R Invoice - Tax Extension26ObjectTypeObject TypenVarChar20013
60INV14A/R Invoice - Assembly - Rows9ObjectTypeobject typenVarChar20013
61INV4A/R Invoice - Tax Amount per Document17ObjectTypeObject TypenVarChar20013
62OEI12Outgoing Excise Invoice - Tax Extension26ObjectTypeObject TypenVarChar200140000009
63OEI14Outgoing Excise Invoice - Assembly - Rows9ObjectTypeobject typenVarChar200140000009
64OEI4Outgoing Excise Invoice - Tax Amount per Document17ObjectTypeObject TypenVarChar200140000009
65PCH12A/P Invoice - Tax Extension26ObjectTypeObject TypenVarChar20018
66PCH14A/P Invoice - Assembly - Rows9ObjectTypeobject typenVarChar20018
67PCH4A/P Invoice - Tax Amount per Document17ObjectTypeObject TypenVarChar20018
68PDN12Goods Receipt PO - Tax Extension26ObjectTypeObject TypenVarChar20020
69PDN14Goods Receipt PO - Assembly - Rows9ObjectTypeobject typenVarChar20020
70PDN4Goods Receipt PO - Tax Amount per Document17ObjectTypeObject TypenVarChar20020
71POR12Purchase Order - Tax Extension26ObjectTypeObject TypenVarChar20022
72POR14Purchase Order - Assembly - Rows9ObjectTypeobject typenVarChar20022
73POR4Purchase Order - Tax Amount per Document17ObjectTypeObject TypenVarChar20022
74PQT12Purchase Quotation - Tax Extension26ObjectTypeObject TypenVarChar200540000006
75PQT14Purchase Quotation - Assembly - Rows9ObjectTypeobject typenVarChar200540000006
76PQT4Purchase Quotation - Tax Amount per Document17ObjectTypeObject TypenVarChar200540000006
77QUT12Sales Quotation - Tax Extension26ObjectTypeObject TypenVarChar20023
78QUT14Sales Quotation - Assembly - Rows9ObjectTypeobject typenVarChar20023
79QUT4Sales Quotation - Tax Amount per Document17ObjectTypeObject TypenVarChar20023
80RDN12Returns - Tax Extension26ObjectTypeObject TypenVarChar20016
81RDN14Return - Assembly - Rows9ObjectTypeobject typenVarChar20016
82RDN4Returns - Tax Amount per Document17ObjectTypeObject TypenVarChar20016
83RDR12Sales Order - Tax Extension26ObjectTypeObject TypenVarChar20017
84RDR14Sales Order - Assembly - Rows9ObjectTypeobject typenVarChar20017
85RDR4Sales Order - Tax Amount per Document17ObjectTypeObject TypenVarChar20017
86RIN12A/R Credit Memo - Tax Extension26ObjectTypeObject TypenVarChar20014
87RIN14A/R Credit Memo - Assembly - Rows9ObjectTypeobject typenVarChar20014
88RIN4A/R Credit Memo - Tax Amount per Document17ObjectTypeObject TypenVarChar20014
89RPC12A/P Credit Memo - Tax Extension26ObjectTypeObject TypenVarChar20019
90RPC14A/P Credit Memo - Assembly - Rows9ObjectTypeobject typenVarChar20019
91RPC4A/P Credit Memo - Tax Amount per Document17ObjectTypeObject TypenVarChar20019
92RPD12Goods Return - Tax Extension26ObjectTypeObject TypenVarChar20021
93RPD14Goods Return - Assembly - Rows9ObjectTypeobject typenVarChar20021
94RPD4Goods Return - Tax Amount per Document17ObjectTypeObject TypenVarChar20021
TOPService
95ASC2Service Call Inventory Expenses - History12ObjectTypeObject Type - HistorynVarChar200191
96ASC3Service Call Travel/Labor Expenses - History12ObjectTypeObject TypenVarChar200191
97ASC4Service Call Travel/Labor Expenses - History7ObjectTypeObject TypenVarChar200191
98ASC5Service Call Activities - History4ObjectTypeObject TypenVarChar200191
99MDC1Master Data Cleanup - Log3ObjectTypeObject TypenVarChar200
100MDC2Master Data Cleanup - MD Log2ObjectTypeObject TypenVarChar200
101SCL2Service Call Inventory Expenses12ObjectTypeObject TypenVarChar200191
102SCL3Service Call Travel/Labor Expenses12ObjectTypeObject TypenVarChar200191
103SCL4Expense Documents7ObjectTypeObject TypenVarChar200191
104SCL5Service Call Activities4ObjectTypeObject TypenVarChar200191