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  | FINACITCASH
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.0FINACITCASH472Line Items in the Cash 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, FIN_EEW_ACITCASH, FIN_EEW_CASHR, FOBJ_TYPE_NAME, FOBJ_OBJECT_ID, FIN_PAYID, FIN_PAYTYPE, FIN_CASHLOC, FIN_COMPELCASH, FIN_CALYEARDOC, FIN_CALMONTHDOC, FIN_CALYRMTHDOC, FIN_AMTPOS, FIN_CURRPOS FROM FINACITCASH
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? 
35FIN_EEW_ACITCASHExtension Point for Cash Line Itemchar10CHAR(N' ')YesFIN_EEW_ACITCASH Allow NULL? 
36FIN_EEW_CASHRExtension Point for Reporting in CASH Journalchar10CHAR(N' ')YesFIN_EEW_CASHR Allow NULL? 
37FOBJ_TYPE_NAMEName of an Object Typenvarchar100CHAR(N' ')YesFOBJ_TYPE_NAME Allow NULL? 
38FOBJ_OBJECT_IDObject IDvarbinary160RAWYesFOBJ_OBJECT_ID
39FIN_PAYIDPayment Order Itemnvarchar350CHAR(N' ')YesFIN_PAYID Allow NULL? 
40FIN_PAYTYPEPayment Typenvarchar40CHAR(N' ')Yes*FIN_PAYTYPE Allow NULL? 
41FIN_CASHLOCCash Locationnvarchar320CHAR(N' ')Yes*FIN_CASHLOC Allow NULL? 
42FIN_COMPELCASHComposition Element Cashnvarchar100CHAR(N' ')Yes*FIN_COMPELCASH Allow NULL? 
43FIN_CALYEARDOCCalendar Year of Document Datenvarchar40NUMC(N'0000')YesFIN_CALYEARDOC Allow NULL? 
44FIN_CALMONTHDOCCalendar Month of Document Datenvarchar30NUMC(N'000')YesFIN_CALMONTHDOC Allow NULL? 
45FIN_CALYRMTHDOCCalendar Month/Year of Document Date in the Form YYYYMMMnvarchar70NUMC(N'0000000')YesFIN_CALYRMTHDOC Allow NULL? 
46FIN_AMTPOSAmount in Position Currencydecimal232CURR((0))YesFIN_AMTPOS
47FIN_CURRPOSPosition Currencynvarchar50CUKY(N' ')Yes*FIN_CURRPOS Allow NULL? 
NamePrimaryUniqueTypeColumns
FINACITCASH~0YesYesCLUSTEREDFIN_ITEMNO, FIN_TECHDOCNO, CLIENT
FINACITCASH~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