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
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DIFT_POS_IDENT2520Persistent Flow SelectorsTransaction Manager
SQL:  selectupdate insert create

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

SELECT MANDT, OS_GUID, CONTEXT, IDENTIFIED_OID, IDENTIFIED_CLS, VALUATION_AREA, COM_VAL_CLASS, VALUATION_CLASS, ACCOUNTING_CODE, COMPANY_CODE, PRODUCT_TYPE, SECURITY_ACCOUNT, SECURITY_ID, PORTFOLIO, TRADER, ACCOUNT_GROUP, LOANS_CONTRACT, POSITION_ACCOUNT, FLAG_LONG_SHORT, LOT_ID, DEAL_NUMBER, FUND, GRANT_NBR, EXTERNAL_ACCOUNT, DIFF_CURRENCY FROM DIFT_POS_IDENT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2OS_GUIDObject Identity in Database Formatnvarchar320CHAR(N' ')NoTPM_DB_OS_GUID Allow NULL? 
3CONTEXTContext for Identifiernvarchar30CHAR(N' ')YesDIF_IDENT_CONTEXT Allow NULL? 
4IDENTIFIED_OIDObject Identity in Database Formatnvarchar320CHAR(N' ')YesTPM_DB_OS_GUID Allow NULL? 
5IDENTIFIED_CLSObject Identity in Database Formatnvarchar320CHAR(N' ')YesTPM_DB_OS_GUID Allow NULL? 
6VALUATION_AREAValuation Areanvarchar30CHAR(N' ')YesTRGC_VAL_AREATPM_VAL_AREA Allow NULL? 
7COM_VAL_CLASSGeneral Valuation Classnvarchar40NUMC(N'0000')YesTRGC_COM_VALCLTPM_COM_VAL_CLASS Allow NULL? 
8VALUATION_CLASSValuation Classnvarchar40NUMC(N'0000')YesTRGC_VAL_CLASSTPM_VAL_CLASS Allow NULL? 
9ACCOUNTING_CODEAccounting Codenvarchar40CHAR(N' ')YesTRGC_TR_ACC_CODETPM_ACC_CODE Allow NULL? 
10COMPANY_CODECompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
11PRODUCT_TYPEProduct Typenvarchar30CHAR(N' ')YesTZPAVVSART Allow NULL? 
12SECURITY_ACCOUNTSecurities Accountnvarchar100CHAR(N' ')YesTWD01RLDEPO Allow NULL? 
13SECURITY_IDSecurity ID Numbernvarchar130CHAR(N' ')YesVWPANLAVVRANLW Allow NULL? 
14PORTFOLIOPortfolio as Differentiation Characteristicnvarchar100CHAR(N' ')YesTWPOBTPM_PORTFOLIO_DIFF Allow NULL? 
15TRADERTradernvarchar120CHAR(N' ')YesTZDEARDEALER Allow NULL? 
16ACCOUNT_GROUPSecurities Account Groupnvarchar100CHAR(N' ')YesTRGT_SECACCGRPTPM_SEC_ACCT_GRP Allow NULL? 
17LOANS_CONTRACTContract Numbernvarchar130CHAR(N' ')YesVDARLRANL Allow NULL? 
18POSITION_ACCOUNTFutures Account for Listed Options and Futuresnvarchar100CHAR(N' ')YesTRFT_POS_ACCOUNTTPM_POS_ACCOUNT_FUT Allow NULL? 
19FLAG_LONG_SHORTIndicator: Long or Short Positionchar10CHAR(N' ')YesTPM_FLAG_LONG_SHORT Allow NULL? 
20LOT_IDIdentifier of the Lotvarbinary160RAWYesTPM_LOT_ID
21DEAL_NUMBERFinancial Transactionnvarchar130CHAR(N' ')YesVTBFHATB_RFHA Allow NULL? 
22FUNDFundnvarchar100CHAR(N' ')Yes*FM_FUND Allow NULL? 
23GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
24EXTERNAL_ACCOUNTExternal Accountnvarchar100CHAR(N' ')YesTPM_EXT_ACCOUNT Allow NULL? 
25DIFF_CURRENCYCurrency as Differentiation Termnvarchar50CUKY(N' ')YesTCURCTPM_DIFF_CURRENCY Allow NULL? 
NamePrimaryUniqueTypeColumns
DIFT_POS_IDENT~0YesYesCLUSTEREDOS_GUID, MANDT
DIFT_POS_IDENT~ACNoNoNONCLUSTEREDACCOUNTING_CODE
DIFT_POS_IDENT~AGNoNoNONCLUSTEREDACCOUNT_GROUP
DIFT_POS_IDENT~CCNoNoNONCLUSTEREDCOMPANY_CODE
DIFT_POS_IDENT~CVNoNoNONCLUSTEREDCOM_VAL_CLASS
DIFT_POS_IDENT~DNNoNoNONCLUSTEREDDEAL_NUMBER
DIFT_POS_IDENT~EXANoNoNONCLUSTEREDDIFF_CURRENCY, EXTERNAL_ACCOUNT, COMPANY_CODE, VALUATION_CLASS, VALUATION_AREA, CONTEXT, MANDT
DIFT_POS_IDENT~FDNoNoNONCLUSTEREDFUND
DIFT_POS_IDENT~IDFNoNoNONCLUSTEREDIDENTIFIED_OID, MANDT
DIFT_POS_IDENT~LCNoNoNONCLUSTEREDLOANS_CONTRACT
DIFT_POS_IDENT~LONoNoNONCLUSTEREDLOT_ID
DIFT_POS_IDENT~LSNoNoNONCLUSTEREDFLAG_LONG_SHORT
DIFT_POS_IDENT~PANoNoNONCLUSTEREDPOSITION_ACCOUNT
DIFT_POS_IDENT~PFNoNoNONCLUSTEREDPORTFOLIO
DIFT_POS_IDENT~PTNoNoNONCLUSTEREDPRODUCT_TYPE
DIFT_POS_IDENT~SANoNoNONCLUSTEREDSECURITY_ACCOUNT
DIFT_POS_IDENT~SENoNoNONCLUSTEREDSECURITY_ID
DIFT_POS_IDENT~TRNoNoNONCLUSTEREDTRADER
DIFT_POS_IDENT~VANoNoNONCLUSTEREDVALUATION_AREA
DIFT_POS_IDENT~VCNoNoNONCLUSTEREDVALUATION_CLASS