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

96 columns | Print definition?B1 8.8  | OBJECTTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1CDPMDynamic Permission3ObjectTypeObject TypeInt110
2OCMNCustomized Menu7ObjectTypeTarget Object TypeInt110
3OUTBUser Tables4ObjectTypeObject TypenVarChar20000=No Object, 1=Master Data, 2=Master Data Lines, 3=Document, 4=Document Lines
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
16IGE4Goods Issue - Tax Amount per Document17ObjectTypeObject TypenVarChar20013
17IGN12Goods Receipt - Tax Extension26ObjectTypeObject TypenVarChar20059
18IGN4Goods Receipt - Tax Amount per Document17ObjectTypeObject TypenVarChar20013
19WTR12Inventory Transfer - Tax Extension26ObjectTypeObject TypenVarChar20067
20WTR4Inventory Transfer - Tax Amount per Document17ObjectTypeObject TypenVarChar20013
TOPMarketing Documents
21ADO12A/R Invoice - Tax Extension - History26ObjectTypeObject TypenVarChar200
22ADO14Invoice - Assembly - Rows - History9ObjectTypeobject typenVarChar200
23ADO4Documents - Tax - History17ObjectTypeBase Amount (SC)nVarChar200
24CIN12Correction Invoice - Tax Extension26ObjectTypeObject TypenVarChar200132
25CIN4Correction Invoice - Tax Amount per Document17ObjectTypeObject TypenVarChar200132
26CPI12A/P Correction Invoice - Tax Extension26ObjectTypeObject TypenVarChar200163
27CPI14A/P Correction Invoice - Assembly - Rows9ObjectTypeobject typenVarChar200163
28CPI4A/P Correction Invoice - Tax Amount per Document17ObjectTypeObject TypenVarChar200163
29CPV12A/P Correction Invoice Reversal - Tax Extension26ObjectTypeObject TypenVarChar200164
30CPV14A/P Correction Invoice Reversal - Assembly - Rows9ObjectTypeobject typenVarChar200164
31CPV4A/P Correction Invoice Reversal - Tax Amt per Doc.17ObjectTypeObject TypenVarChar200164
32CSI12A/R Correction Invoice - Tax Extension26ObjectTypeObject TypenVarChar200165
33CSI14A/R Correction Invoice - Assembly - Rows9ObjectTypeobject typenVarChar200165
34CSI4A/R Correction Invoice - Tax Amount Per Document17ObjectTypeObject TypenVarChar200165
35CSV12A/R Correction Invoice Reversal - Tax Extension26ObjectTypeObject TypenVarChar200166
36CSV14A/R Correction Invoice Reversal - Assembly - Rows9ObjectTypeobject typenVarChar200166
37CSV4A/R Correction Invoice Reversal - Tax Amount Per Document17ObjectTypeObject TypenVarChar200166
38DLN12Delivery - Tax Extension26ObjectTypeObject TypenVarChar20015
39DLN14Delivery Notes - Assembly - Rows9ObjectTypeobject typenVarChar20015
40DLN4Delivery - Tax Amount per Document17ObjectTypeObject TypenVarChar20015
41DPI12Down Payment In - Tax Extension26ObjectTypeObject TypenVarChar200203
42DPI14A/R Down Payment - Assembly - Rows9ObjectTypeobject typenVarChar200203
43DPI4A/R Down Payment - Tax Amount per Document17ObjectTypeObject TypenVarChar200203
44DPO12Down Payment - Tax Extension26ObjectTypeObject TypenVarChar200204
45DPO14A/P Down Payment - Assembly - Rows9ObjectTypeobject typenVarChar200204
46DPO4A/P Down Payment - Tax Amount per Document17ObjectTypeObject TypenVarChar200204
47DRF12Draft - Tax Extension26ObjectTypeObject TypenVarChar200112
48DRF14Draft - Assembly - Rows9ObjectTypeobject typenVarChar200
49DRF4Draft Documents - Tax17ObjectTypeObject TypenVarChar20013
50IEI12Incoming Excise Invoice - Tax Extension26ObjectTypeObject TypenVarChar200140000010
51IEI14Incoming Excise Invoice - Assembly - Rows9ObjectTypeobject typenVarChar200140000010
52IEI4Incoming Excise Invoice - Tax Amount per Document17ObjectTypeObject TypenVarChar200140000010
53IGE14Goods Issue - Assembly - Rows9ObjectTypeobject typenVarChar20060
54IGN14Goods Receipt - Assembly - Rows9ObjectTypeobject typenVarChar20059
55INV12A/R Invoice - Tax Extension26ObjectTypeObject TypenVarChar20013
56INV14A/R Invoice - Assembly - Rows9ObjectTypeobject typenVarChar20013
57INV4A/R Invoice - Tax Amount per Document17ObjectTypeObject TypenVarChar20013
58OEI12Outgoing Excise Invoice - Tax Extension26ObjectTypeObject TypenVarChar200140000009
59OEI14Outgoing Excise Invoice - Assembly - Rows9ObjectTypeobject typenVarChar200140000009
60OEI4Outgoing Excise Invoice - Tax Amount per Document17ObjectTypeObject TypenVarChar200140000009
61PCH12A/P Invoice - Tax Extension26ObjectTypeObject TypenVarChar20018
62PCH14A/P Invoice - Assembly - Rows9ObjectTypeobject typenVarChar20018
63PCH4A/P Invoice - Tax Amount per Document17ObjectTypeObject TypenVarChar20018
64PDN12Goods Receipt PO - Tax Extension26ObjectTypeObject TypenVarChar20020
65PDN14Goods Receipt PO - Assembly - Rows9ObjectTypeobject typenVarChar20020
66PDN4Goods Receipt PO - Tax Amount per Document17ObjectTypeObject TypenVarChar20020
67POR12Purchase Order - Tax Extension26ObjectTypeObject TypenVarChar20022
68POR14Purchase Order - Assembly - Rows9ObjectTypeobject typenVarChar20022
69POR4Purchase Order - Tax Amount per Document17ObjectTypeObject TypenVarChar20022
70QUT12Sales Quotation - Tax Extension26ObjectTypeObject TypenVarChar20023
71QUT14Sales Quotation - Assembly - Rows9ObjectTypeobject typenVarChar20023
72QUT4Sales Quotation - Tax Amount per Document17ObjectTypeObject TypenVarChar20023
73RDN12Returns - Tax Extension26ObjectTypeObject TypenVarChar20016
74RDN14Return - Assembly - Rows9ObjectTypeobject typenVarChar20016
75RDN4Returns - Tax Amount per Document17ObjectTypeObject TypenVarChar20016
76RDR12Sales Order - Tax Extension26ObjectTypeObject TypenVarChar20017
77RDR14Sales Order - Assembly - Rows9ObjectTypeobject typenVarChar20017
78RDR4Sales Order - Tax Amount per Document17ObjectTypeObject TypenVarChar20017
79RIN12A/R Credit Memo - Tax Extension26ObjectTypeObject TypenVarChar20014
80RIN14A/R Credit Memo - Assembly - Rows9ObjectTypeobject typenVarChar20014
81RIN4A/R Credit Memo - Tax Amount per Document17ObjectTypeObject TypenVarChar20014
82RPC12A/P Credit Memo - Tax Extension26ObjectTypeObject TypenVarChar20019
83RPC14A/P Credit Memo - Assembly - Rows9ObjectTypeobject typenVarChar20019
84RPC4A/P Credit Memo - Tax Amount per Document17ObjectTypeObject TypenVarChar20019
85RPD12Goods Return - Tax Extension26ObjectTypeObject TypenVarChar20021
86RPD14Goods Return - Assembly - Rows9ObjectTypeobject typenVarChar20021
87RPD4Goods Return - Tax Amount per Document17ObjectTypeObject TypenVarChar20021
88WTR14Inventory Transfer - Assembly - Rows9ObjectTypeobject typenVarChar20067
TOPService
89ASC2Service Call Inventory Expenses - History12ObjectTypeObject Type - HistorynVarChar200191
90ASC3Service Call Travel/Labor Expenses - History12ObjectTypeObject TypenVarChar200191
91ASC4Service Call Travel/Labor Expenses - History7ObjectTypeObject TypenVarChar200191
92ASC5Service Call Activities - History4ObjectTypeObject TypenVarChar200191
93SCL2Service Call Inventory Expenses12ObjectTypeObject TypenVarChar200191
94SCL3Service Call Travel/Labor Expenses12ObjectTypeObject TypenVarChar200191
95SCL4Expense Documents7ObjectTypeObject TypenVarChar200191
96SCL5Service Call Activities4ObjectTypeObject TypenVarChar200191