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

Home | ERP 6.0  | FINACITWIP
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
Financials :: Business Accounting :: Accounting Engine
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FINACITWIP512Line Items in the WIP JournalAccounting Engine
SQL:  selectupdate insert create

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

SELECT CLIENT, FIN_TECHDOCNO, FIN_ITEMNO, FIN_GLITEMNO, FIN_DRCRIND, FIN_GLACCT, FIN_GLIND, FIN_ITEMTEXT, FIN_SEGMENT, FIN_PROFITCTR, FIN_FUNCAREA, FIN_SEGMENT_P, FIN_PROFITCTR_P, FIN_FUNCAREA_P, FIN_AMTTRA, FIN_CURRTRA, FIN_AMTCOMP, FIN_CURRCOMP, FIN_AMTACCSYS, FIN_CURRACCSYS, FIN_AMTHARD, FIN_CURRHARD, FIN_AMTINDEX, FIN_CURRINDEX, FIN_AMTCOMPGLOB, FIN_CURRCOMPGLOB, FIN_EEW_AMTAMT, FIN_QTYGL, FIN_UOMGL, FIN_ITEMSIGN, FIN_POSTYPE, FIN_JOURNAL, FIN_GLTRATYPE, FIN_EEW_ACIT, FOBJ_TYPE_NAME, FOBJ_OBJECT_ID, FOBJ_TYPE_NAME_P, FOBJ_OBJECT_ID_P, FOBJ_TYPE_NAME_O, FOBJ_OBJECT_ID_O, FIN_QTYETR, FIN_UOMETR, FIN_QTYREF, FIN_UOMREF, FIN_QTYVAL, FIN_UOMVAL, FIN_COMPEL, FIN_CHARGEIND, FIN_EEW_ACITWIP, FIN_LOCATION, FIN_EEW_ACITWIPR FROM FINACITWIP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2FIN_TECHDOCNOTechnical Identifier of a Documentnvarchar220CHAR(N' ')NoFIN_TECHDOCNO Allow NULL? 
3FIN_ITEMNOLine Item Numbernvarchar60NUMC(N'000000')NoFIN_ITEMNO Allow NULL? 
4FIN_GLITEMNOItem Number of General Ledger Documentnvarchar60NUMC(N'000000')YesFIN_GLITEMNO Allow NULL? 
5FIN_DRCRINDDebit/Credit Indicatorchar10CHAR(N' ')YesFIN_DRCRIND Allow NULL? 
6FIN_GLACCTG/L Accountnvarchar100CHAR(N' ')Yes*FIN_GLACCT Allow NULL? 
7FIN_GLINDRelevant for General Ledgerchar10CHAR(N' ')YesFIN_GLIND Allow NULL? 
8FIN_ITEMTEXTDocument Item Textnvarchar500CHAR(N' ')YesFIN_ITEMTEXT Allow NULL? 
9FIN_SEGMENTSegmentnvarchar220CHAR(N' ')YesFIN_SEGMENT Allow NULL? 
10FIN_PROFITCTRProfit Centernvarchar220CHAR(N' ')Yes*FIN_PROFITCTR Allow NULL? 
11FIN_FUNCAREAFunctional Areanvarchar160CHAR(N' ')Yes*FIN_FUNCAREA Allow NULL? 
12FIN_SEGMENT_PPartner Segmentnvarchar220CHAR(N' ')YesFIN_SEGMENT_P Allow NULL? 
13FIN_PROFITCTR_PPartner Profit Centernvarchar220CHAR(N' ')Yes*FIN_PROFITCTR_P Allow NULL? 
14FIN_FUNCAREA_PPartner Functional Areanvarchar160CHAR(N' ')Yes*FIN_FUNCAREA_P Allow NULL? 
15FIN_AMTTRAAmount in Transaction Currencydecimal232CURR((0))YesFIN_AMTTRA
16FIN_CURRTRATransaction Currencynvarchar50CUKY(N' ')Yes*FIN_CURRTRA Allow NULL? 
17FIN_AMTCOMPAmount in Local Currencydecimal232CURR((0))YesFIN_AMTCOMP
18FIN_CURRCOMPLocal Currencynvarchar50CUKY(N' ')Yes*FIN_CURRCOMP Allow NULL? 
19FIN_AMTACCSYSAmount in Accounting System Currencydecimal232CURR((0))YesFIN_AMTACCSYS
20FIN_CURRACCSYSAccounting System Currencynvarchar50CUKY(N' ')Yes*FIN_CURRACCSYS Allow NULL? 
21FIN_AMTHARDAmount in Hard Currencydecimal232CURR((0))YesFIN_AMTHARD
22FIN_CURRHARDHard Currencynvarchar50CUKY(N' ')Yes*FIN_CURRHARD Allow NULL? 
23FIN_AMTINDEXAmount in Index-Based Currencydecimal232CURR((0))YesFIN_AMTINDEX
24FIN_CURRINDEXIndex-Based Currencynvarchar50CUKY(N' ')Yes*FIN_CURRINDEX Allow NULL? 
25FIN_AMTCOMPGLOBAmount in Global Company Currencydecimal232CURR((0))YesFIN_AMTCOMPGLOB
26FIN_CURRCOMPGLOBGlobal Company Currencynvarchar50CUKY(N' ')Yes*FIN_CURRCOMPGLOB Allow NULL? 
27FIN_EEW_AMTAMTExtension Include for Additional Currencieschar10CHAR(N' ')YesFIN_EEW_AMT Allow NULL? 
28FIN_QTYGLQuantity in General Ledgerdecimal233QUAN((0))YesFIN_QTYGL
29FIN_UOMGLUnit of Measure for General Ledgernvarchar30UNIT(N' ')Yes*FIN_UOMGL Allow NULL? 
30FIN_ITEMSIGN+/- Sign for a Line Itemchar10CHAR(N' ')YesFIN_ITEMSIGN Allow NULL? 
31FIN_POSTYPEItem Categorynvarchar50CHAR(N' ')Yes*FIN_POSTYPE Allow NULL? 
32FIN_JOURNALJournalnvarchar80CHAR(N' ')Yes*FIN_JOURNAL Allow NULL? 
33FIN_GLTRATYPETransaction Type for General Ledgernvarchar50CHAR(N' ')Yes*FIN_GLTRATYPE Allow NULL? 
34FIN_EEW_ACITExtension Point for Item of ACC Documentchar10CHAR(N' ')YesFIN_EEW_ACIT Allow NULL? 
35FOBJ_TYPE_NAMEName of an Object Typenvarchar100CHAR(N' ')YesFOBJ_TYPE_NAME Allow NULL? 
36FOBJ_OBJECT_IDObject IDvarbinary160RAWYesFOBJ_OBJECT_ID
37FOBJ_TYPE_NAME_PName of Partner Object Typenvarchar100CHAR(N' ')YesFOBJ_TYPE_NAME_P Allow NULL? 
38FOBJ_OBJECT_ID_PPartner Object IDvarbinary160RAWYesFOBJ_OBJECT_ID_P
39FOBJ_TYPE_NAME_OName of an Object Typenvarchar100CHAR(N' ')YesFOBJ_TYPE_NAME Allow NULL? 
40FOBJ_OBJECT_ID_OObject IDvarbinary160RAWYesFOBJ_OBJECT_ID
41FIN_QTYETRQuantity in Unit of Entrydecimal233QUAN((0))YesFIN_QTYETR
42FIN_UOMETRUnit of Entrynvarchar30UNIT(N' ')Yes*FIN_UOMETR Allow NULL? 
43FIN_QTYREFQuantity in Reference Unit of Measuredecimal233QUAN((0))YesFIN_QTYREF
44FIN_UOMREFReference Unit of Measurenvarchar30UNIT(N' ')Yes*FIN_UOMREF Allow NULL? 
45FIN_QTYVALValuation Quantitydecimal233QUAN((0))YesFIN_QTYVAL
46FIN_UOMVALValuation Unit of Measurenvarchar30UNIT(N' ')Yes*FIN_UOMVAL Allow NULL? 
47FIN_COMPELComposition Elementnvarchar100CHAR(N' ')Yes*FIN_COMPEL Allow NULL? 
48FIN_CHARGEINDCharge Indicator for Assets Accountschar10CHAR(N' ')YesFIN_CHARGEIND Allow NULL? 
49FIN_EEW_ACITWIPExtension Point for LI in WIP Journalchar10CHAR(N' ')YesFIN_EEW_ACITWIP Allow NULL? 
50FIN_LOCATIONLocationnvarchar220CHAR(N' ')Yes*FIN_LOCATION Allow NULL? 
51FIN_EEW_ACITWIPRExtension Point for Reporting in WIP Journalchar10CHAR(N' ')YesFIN_EEW_ACITWIPR Allow NULL? 
NamePrimaryUniqueTypeColumns
FINACITWIP~0YesYesCLUSTEREDFIN_ITEMNO, FIN_TECHDOCNO, CLIENT
FINACITWIP~001NoNoNONCLUSTEREDFOBJ_TYPE_NAME, FOBJ_OBJECT_ID, CLIENT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy