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  | T881
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Accounting :: Special Purpose Ledger :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T881431Ledger MasterBasic Functions
SQL:  selectupdate insert create

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

SELECT MANDT, RLDNR, GCURR, CLASS, TYP, TRCUR, LCCUR, RCCUR, OCCUR, QUANT, ATQNT, TAB, RCOPY, SHKZ, GLSIP, VORTRAG, DLDNR, XDLDNR, CURT1, CURT2, CURT3, V2POST, LCTYP, FIX, POST, ROLLUP, DEPLD, APPL, SUBAPPL, KOMP, GZLEDGER, EXIT, KLDNR, LOGSYS, VALUTYP, GCOMPRESS, SPLITMETHD, DATE_DET_POPER, GLFLEX, XLEADING, ORIENT_LEDGER, AVG_ROLLUP, XCASH_LEDGER FROM T881
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2RLDNRLedgernvarchar20CHAR(N' ')NoRLDNR Allow NULL? 
3GCURRCurrency key of the ledger currencynvarchar50CUKY(N' ')NoTCURCGCURR Allow NULL? 
4CLASSLedger classchar10CHAR(N' ')NoLDCLS Allow NULL? 
5TYPType of ledger (client in which it is to be maintained)char10CHAR(N' ')NoLEDGER_TYP Allow NULL? 
6TRCURStore transaction currencychar10CHAR(N' ')NoTRCUR Allow NULL? 
7LCCURStore second currencychar10CHAR(N' ')NoLCCUR Allow NULL? 
8RCCURStore third currencychar10CHAR(N' ')NoRCCUR Allow NULL? 
9OCCURManage fourth currencychar10CHAR(N' ')YesOCCUR Allow NULL? 
10QUANTStore quantitieschar10CHAR(N' ')NoQUANT Allow NULL? 
11ATQNTStore additional quantitieschar10CHAR(N' ')NoATQNT Allow NULL? 
12TABTotals Tablenvarchar300CHAR(N' ')No*GLTAB Allow NULL? 
13RCOPYMaintenance by Copying Allowedchar10CHAR(N' ')NoRCOPY Allow NULL? 
14SHKZMaintain debits/credits indicatorchar10CHAR(N' ')NoSHKZ Allow NULL? 
15GLSIPWrite line itemschar10CHAR(N' ')NoGLSIP Allow NULL? 
16VORTRAGSet up balance carry forwardchar10CHAR(N' ')NoVORTR Allow NULL? 
17DLDNRAverage balance ledgernvarchar20CHAR(N' ')No*RLDNR1 Allow NULL? 
18XDLDNRStore average in the same ledgerchar10CHAR(N' ')NoXDLDNR Allow NULL? 
19CURT1Currency type of the local currency (HSL)nvarchar20CHAR(N' ')NoCURT_HSL Allow NULL? 
20CURT2Currency type of the group currency (KSL)nvarchar20CHAR(N' ')NoCURT_KSL Allow NULL? 
21CURT3Currency type of currency 4nvarchar20CHAR(N' ')YesCURT_OSL Allow NULL? 
22V2POSTDelay the ledger updatechar10CHAR(N' ')NoV2POST Allow NULL? 
23LCTYPType of consolidationchar10CHAR(N' ')NoLC_TYP Allow NULL? 
24FIXIndicator: Standard ledgerchar10CHAR(N' ')NoG_LD_FIX Allow NULL? 
25POSTPostings can be made to ledgerchar10CHAR(N' ')NoG_POST Allow NULL? 
26ROLLUPRollup allowed to the ledgerchar10CHAR(N' ')NoG_ROLLUP Allow NULL? 
27DEPLDIs the ledger an additional ledger?char10CHAR(N' ')NoG_ZUSATZLD Allow NULL? 
28APPLOwner applicationnvarchar20CHAR(N' ')No*GLXAPPL Allow NULL? 
29SUBAPPLSubapplicationnvarchar30CHAR(N' ')No*GLXSUBAPPL Allow NULL? 
30KOMPComponentnvarchar30CHAR(N' ')NoGLXKOMP Allow NULL? 
31GZLEDGERIndicator: Ledger cannot be reset (delete)char10CHAR(N' ')NoGZLEDGER Allow NULL? 
32EXITExit no. (S..: standard exits, U..: user exits)nvarchar30CHAR(N' ')NoEXIT_NR_LD Allow NULL? 
33KLDNRExport ledgernvarchar20CHAR(N' ')NoT881G_KLDNR Allow NULL? 
34LOGSYSLogical systemnvarchar100CHAR(N' ')NoTBDLSLOGSYS Allow NULL? 
35VALUTYPValuationchar10NUMC(N'0')NoG_VALUTYP Allow NULL? 
36GCOMPRESSSummarize datachar10CHAR(N' ')NoG_COMPRESS Allow NULL? 
37SPLITMETHDDocument Splitting Methodnvarchar100CHAR(N' ')NoT8G01SPLITMETHD Allow NULL? 
38DATE_DET_POPERDate with which the posting period is determinedchar10NUMC(N'0')YesGLX_DATE_FOR_POS Allow NULL? 
39GLFLEX1-Character Indicator: Type of Ledgerchar10CHAR(N' ')NoFAGL_TYPE_GLFLEX Allow NULL? 
40XLEADINGIndicator: Leading Ledgerchar10CHAR(N' ')NoFAGL_FLAG_LEADING Allow NULL? 
41ORIENT_LEDGERReference Ledger for General Ledger Accountingnvarchar20CHAR(N' ')NoV_FAGL_T881_DBFAGL_ORIENTATION_LEDGER Allow NULL? 
42AVG_ROLLUPIndicator: Rollup Ledger for Daily Average Balanceschar10CHAR(N' ')NoFAGL_TYPE_AVG_ROLLUP Allow NULL? 
43XCASH_LEDGERCash Ledger Indicatorchar10CHAR(N' ')YesFAGL_CASH_LEDGER Allow NULL? 
NamePrimaryUniqueTypeColumns
T881~0YesYesCLUSTEREDRLDNR, MANDT

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