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
Financials :: Business Accounting :: Inventory Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0UAINVDEBCRI242Document Item for Revaluation Through Material Debit/CreditInventory Accounting
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DOC_NO, DOC_ITEM_NO, FIN_POSTDAT, FIN_CURRTYPE, FINB_SND_ID, FINB_SNDKEY, FIN_PRICELABEL, FOBJ_OBJECT_ID, FIN_QTYVAL, FIN_UOMVAL, FIN_AMOUNT, FIN_CURRENCY, CURRENCY_RATE, UAINV_PR_O, UAINV_PR_FIX_O, UAINV_PR_BASE_O, UAINV_PR_N, UAINV_PR_FIX_N, UAINV_PR_BASE_N, UAINV_VALUE_O, UAINV_VALUE_N, UAINV_QUANTITY, FOBJ_TYPE_NAME FROM UAINVDEBCRI
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2DOC_NODocument Number for Material Debit/Creditnvarchar150 Allow NULL? 
3DOC_ITEM_NODocument Item for Material Debit/Creditnvarchar60 Allow NULL? 
4FIN_POSTDATPosting Datenvarchar80 Allow NULL? 
5FIN_CURRTYPECurrency Typenvarchar20 Allow NULL? 
6FINB_SND_IDSender Identificationnvarchar250 Allow NULL? 
7FINB_SNDKEYDocument Key of the Sending Systemnvarchar350 Allow NULL? 
8FIN_PRICELABELPrice Typenvarchar30 Allow NULL? 
9FOBJ_OBJECT_IDObject IDvarbinary160
10FIN_QTYVALValuation Quantitydecimal233
11FIN_UOMVALValuation Unit of Measurenvarchar30 Allow NULL? 
12FIN_AMOUNTAmountdecimal232
13FIN_CURRENCYCurrency Keynvarchar50 Allow NULL? 
14CURRENCY_RATEAlternative Exchange Ratedecimal95
15UAINV_PR_OPrice Before Revaluationdecimal232
16UAINV_PR_FIX_OFixed Component of Price Before Inventory Price Changedecimal232
17UAINV_PR_BASE_OBase Quantity for Price Before Revaluationdecimal233
18UAINV_PR_NPrice After Revaluationdecimal232
19UAINV_PR_FIX_NFixed Component of Price After Inventory Revaluationdecimal232
20UAINV_PR_BASE_NBase Quantity for Price After Revaluationdecimal233
21UAINV_VALUE_OInventory Value Before Revaluationdecimal232
22UAINV_VALUE_NInventory Value After Revaluationdecimal232
23UAINV_QUANTITYInventory Quantity for Revaluationdecimal233
24FOBJ_TYPE_NAMEName of an Object Typenvarchar100 Allow NULL? 
NamePrimaryUniqueTypeColumns
UAINVDEBCRI~0YesYesCLUSTEREDMANDT, DOC_NO, DOC_ITEM_NO, FIN_POSTDAT, FIN_CURRTYPE
UAINVDEBCRI~FOBNoNoNONCLUSTEREDFOBJ_OBJECT_ID