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

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TEXT_POSITIONS624Exposure PositionsTransaction Manager
SQL:  selectupdate insert create

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

SELECT MANDT, OS_GUID, POSITION_ID, EXP_TYPE, RISK_CAT, COUNTRY, COMPANY_CODE, TRANSACTION_CAT, TRANSACTIVITY, ATTRIBUTE_SH01, ATTRIBUTE_SH02, ATTRIBUTE_LH01, ATTRIBUTE_DH01, PROFIT_CENTER, COMMODITY_ID, FOREIGN_CURR, TARGET_CURR, ATTRIBUTE_LI01, ATTRIBUTE_LI02, ATTRIBUTE_LI03, ATTRIBUTE_LI04, ATTRIBUTE_MI01, ATTRIBUTE_MI02, ATTRIBUTE_SI01, ATTRIBUTE_DI01, PLANNING_PERIOD, PLANNING_YEAR, DUE_DATE, EXPOSURE_ID, ITEM_ID, SUBEXPOS_ID, EXP_APPROACH_CAT, FIXING_STATUS, VAR_PRICE_CAT, ZZCM_BS1_DEMO_ID, ZZCM_BS2_ENTITY, ZZCM_BS3_REGION, ZZCM_BS4_PORTFOLIO, ZZCM_BS5_STRATEGY, ZZCM_BS6_MISC1, ZZCM_BS7_MISC2, ZZCM_BS8_MISC3, ZZCM_BS9_HEDGE_ID, PRODUCT_TYPE, HED_COMPANY_CODE, HEDGE_PLAN_ID, HED_EXPOSURE_ID, HED_TRANS_ID, OBJNR, DUE_DATE_ATTR, TRANSACTION_ACT, REFERENCE, DESCRIPTION, ARCHIVE_STATE, CREATION_DATE, CREATION_TIME, CREATION_USER, CREATION_TCODE, LASTCHANGE_DATE, LASTCHANGE_TIME, LASTCHANGE_USER, LASTCHANGE_TCODE FROM TEXT_POSITIONS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2OS_GUIDGlobally Unique Identifiervarbinary160RAWNoOS_GUID
3POSITION_IDExposure Position IDnvarchar200CHAR(N' ')Yes*FTR_POSITION_ID Allow NULL? 
4EXP_TYPEExposure Position Typenvarchar50CHAR(N' ')YesTEXC_EXP_TYPEFTR_EXPOSURE_TYPE Allow NULL? 
5RISK_CATExposure Risk Categorychar10CHAR(N' ')YesFTR_RISK_CAT Allow NULL? 
6COUNTRYCountry Keynvarchar30CHAR(N' ')YesT005LAND1 Allow NULL? 
7COMPANY_CODECompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
8TRANSACTION_CATExposure Category of Raw Exposurenvarchar20CHAR(N' ')YesTEXC_EXP_CATFTR_RAWEXPOS_TRANSCAT Allow NULL? 
9TRANSACTIVITYExposure Activitynvarchar20NUMC(N'00')YesTEXC_EXP_ACTFTR_TRANSACT Allow NULL? 
10ATTRIBUTE_SH01Value of a free attribute (Char4)nvarchar40CHAR(N' ')YesTEXC_ATTR_SFTR_ATTRIBUTE_SHORT Allow NULL? 
11ATTRIBUTE_SH02Value of a free attribute (Char4)nvarchar40CHAR(N' ')YesTEXC_ATTR_SFTR_ATTRIBUTE_SHORT Allow NULL? 
12ATTRIBUTE_LH01Value of a free attribute (Char 20)nvarchar200CHAR(N' ')YesTEXC_ATTR_LFTR_ATTRIBUTE_LONG Allow NULL? 
13ATTRIBUTE_DH01Value of a free attribute (Date)nvarchar80DATS(N'00000000')YesFTR_ATTRIBUTE_DATE Allow NULL? 
14PROFIT_CENTERProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
15COMMODITY_IDCommodity IDnvarchar180CHAR(N' ')Yes*TRCO_COMM_ID Allow NULL? 
16FOREIGN_CURRExposure Amount Currencynvarchar50CUKY(N' ')Yes*FTR_EXPOSURE_CURR Allow NULL? 
17TARGET_CURRTarget Currency of Exposurenvarchar50CUKY(N' ')Yes*FTR_EXPOSURE_CURRENCY_TARGET Allow NULL? 
18ATTRIBUTE_LI01Value of a free attribute (Char 20)nvarchar200CHAR(N' ')YesTEXC_ATTR_LFTR_ATTRIBUTE_LONG Allow NULL? 
19ATTRIBUTE_LI02Value of a free attribute (Char 20)nvarchar200CHAR(N' ')YesTEXC_ATTR_LFTR_ATTRIBUTE_LONG Allow NULL? 
20ATTRIBUTE_LI03Value of a free attribute (Char 20)nvarchar200CHAR(N' ')YesTEXC_ATTR_LFTR_ATTRIBUTE_LONG Allow NULL? 
21ATTRIBUTE_LI04Value of a free attribute (Char 20)nvarchar200CHAR(N' ')YesTEXC_ATTR_LFTR_ATTRIBUTE_LONG Allow NULL? 
22ATTRIBUTE_MI01Value of a free attribute (Char10)nvarchar100CHAR(N' ')YesTEXC_ATTR_MFTR_ATTRIBUTE_MEDIUM Allow NULL? 
23ATTRIBUTE_MI02Value of a free attribute (Char10)nvarchar100CHAR(N' ')YesTEXC_ATTR_MFTR_ATTRIBUTE_MEDIUM Allow NULL? 
24ATTRIBUTE_SI01Value of a free attribute (Char4)nvarchar40CHAR(N' ')YesTEXC_ATTR_SFTR_ATTRIBUTE_SHORT Allow NULL? 
25ATTRIBUTE_DI01Value of a free attribute (Date)nvarchar80DATS(N'00000000')YesFTR_ATTRIBUTE_DATE Allow NULL? 
26PLANNING_PERIODPlanning Periodnvarchar30CHAR(N' ')YesTEMC_PERIODTEM_PLANNING_PERIOD Allow NULL? 
27PLANNING_YEARPlanning Yearnvarchar40NUMC(N'0000')YesFTR_PLANNING_YEAR Allow NULL? 
28DUE_DATEDue Date of an Exposure Position as a Differentiating Termnvarchar80DATS(N'00000000')Yes*FTR_DUE_DATE_DIFF Allow NULL? 
29EXPOSURE_IDRaw Exposure IDnvarchar130CHAR(N' ')Yes*FTR_RAW_EXPOS_ID Allow NULL? 
30ITEM_IDRaw Exposure Line Item IDnvarchar50NUMC(N'00000')Yes*FTR_ITEM_ID Allow NULL? 
31SUBEXPOS_IDSub Raw Exposure IDnvarchar40NUMC(N'0000')YesFTR_SUBITEM_ID Allow NULL? 
32EXP_APPROACH_CATCommodity Exposure Approach Categorychar10NUMC(N'0')YesFTR_EXP_APPR_CAT Allow NULL? 
33FIXING_STATUSFixing Statuschar10CHAR(N' ')YesFTR_FIXING_STATUS Allow NULL? 
34VAR_PRICE_CATFloating Price Categorychar10CHAR(N' ')YesFTR_VARIABLE_PRICE_CATEGORY Allow NULL? 
35ZZCM_BS1_DEMO_IDCM Demo IDnvarchar200CHAR(N' ')YesZZCM_BS1_DEMO_ID Allow NULL? 
36ZZCM_BS2_ENTITYCM Entitynvarchar200CHAR(N' ')YesZZCM_BS2_ENTITY Allow NULL? 
37ZZCM_BS3_REGIONCM Regionnvarchar200CHAR(N' ')YesZZCM_BS3_REGION Allow NULL? 
38ZZCM_BS4_PORTFOLIOCM Portfolionvarchar200CHAR(N' ')YesZZCM_BS4_PORTFOLIO Allow NULL? 
39ZZCM_BS5_STRATEGYCM Strategynvarchar200CHAR(N' ')YesZZCM_BS5_STRATEGY Allow NULL? 
40ZZCM_BS6_MISC1CM Miscellaneous 1nvarchar200CHAR(N' ')YesZZCM_BS6_MISC1 Allow NULL? 
41ZZCM_BS7_MISC2CM Miscellaneous 2nvarchar200CHAR(N' ')YesZZCM_BS7_MISC2 Allow NULL? 
42ZZCM_BS8_MISC3CM Miscellaneous 3nvarchar200CHAR(N' ')YesZZCM_BS8_MISC3 Allow NULL? 
43ZZCM_BS9_HEDGE_IDCM_Hedge IDnvarchar200CHAR(N' ')YesZZCM_BS9_HEDGE_ID Allow NULL? 
44PRODUCT_TYPEProduct Typenvarchar30CHAR(N' ')YesTZPAVVSART Allow NULL? 
45HED_COMPANY_CODECompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
46HEDGE_PLAN_IDHedge Plan IDnvarchar130CHAR(N' ')YesTHMEXT_PLANNERTHM_PLANNERID Allow NULL? 
47HED_EXPOSURE_IDExposure IDnvarchar50NUMC(N'00000')Yes*THM_EXPOSUREID Allow NULL? 
48HED_TRANS_IDE-HA: Transactionnvarchar110CHAR(N' ')Yes*THM_TRANSACTION Allow NULL? 
49OBJNRFinancial Object Numbernvarchar220CHAR(N' ')Yes*FTR_OBJNR Allow NULL? 
50DUE_DATE_ATTRDate on Which Exposure Is Due / Expiresnvarchar80DATS(N'00000000')Yes*FTR_EXPOSURE_DATE Allow NULL? 
51TRANSACTION_ACTTransaction Activity (E-HA)nvarchar20NUMC(N'00')Yes*THM_TRANSACT Allow NULL? 
52REFERENCEReferencenvarchar160CHAR(N' ')YesFTR_EXPOSURE_REFERENCE Allow NULL? 
53DESCRIPTIONDescription of an exposure positionnvarchar500CHAR(N' ')YesFTR_EXPOSURE_TEXT Allow NULL? 
54ARCHIVE_STATEArchive Statuschar10CHAR(N' ')YesFTR_ARCHIVE_STATE Allow NULL? 
55CREATION_DATEFirst Entered onnvarchar80DATS(N'00000000')YesDERF Allow NULL? 
56CREATION_TIMETime of Initial Entrynvarchar60TIMS(N'000000')YesTERF Allow NULL? 
57CREATION_USEREntered bynvarchar120CHAR(N' ')YesRERF Allow NULL? 
58CREATION_TCODETransaction Codenvarchar200CHAR(N' ')Yes*TCODE Allow NULL? 
59LASTCHANGE_DATELast Edited onnvarchar80DATS(N'00000000')YesDBEAR Allow NULL? 
60LASTCHANGE_TIMELast Edited atnvarchar60TIMS(N'000000')YesTBEAR Allow NULL? 
61LASTCHANGE_USEREmployee IDnvarchar120CHAR(N' ')YesRBEAR Allow NULL? 
62LASTCHANGE_TCODETransaction Codenvarchar200CHAR(N' ')Yes*TCODE Allow NULL? 
NamePrimaryUniqueTypeColumns
TEXT_POSITIONS~0YesYesCLUSTEREDMANDT, OS_GUID
TEXT_POSITIONS~010NoNoNONCLUSTEREDMANDT, PLANNING_YEAR, PLANNING_PERIOD
TEXT_POSITIONS~020NoYesNONCLUSTEREDMANDT, POSITION_ID
TEXT_POSITIONS~FOBNoNoNONCLUSTEREDMANDT, OBJNR