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  | OTC_CONV_FHAZU
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.0OTC_CONV_FHAZU671Backup Table for Financial Transaction ActivitiesTransaction Manager
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, RFHA, RFHAZU, CRUSER, DCRDAT, TCRTIM, UPUSER, DUPDAT, TUPTIM, SGSART, SFHAART, SFGZUSTT, SFUNKTV, SFUNKTL, ROFHAZU, RFHAZUX, SAKTIV, SSTOGRD, RDEALER, DVTRAB, TVTRAB, GSPPART, XAKT, NORDEXT, DBLFZ, DELFZ, DFIX, SINCLE, DZSTND, SZNSPRO, DZNSSTD, KKURS, KKASSA, KSWAP, WLWAERS, WFWAERS, LIMITART, LIMITDAT, RKONDGR, LIWAERS, KWLIQUI, SCONFIRM, DEXDAT, UEXNAM, SRECONFIRM, DREDAT, URENAM, DORDER, DANST, TANST, SANST, SSPESEN, BUPRCLIM, SRUNITLIM, BPPRCLIM, JVERK6B, PEFFZINS, PEFFZINS_GIVEN, PEFFZCALL, SEFFMETH, NOTICE_DATE, ROUNDING_RULE, BPPRC_SPOT2, BPPRC_SPOT1, BPPRC_MARG, COC_RATE FROM OTC_CONV_FHAZU
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3RFHAFinancial Transactionnvarchar130CHAR(N' ')NoVTBFHATB_RFHA Allow NULL? 
4RFHAZUTransaction activitynvarchar50NUMC(N'00000')NoTB_RFHAZU Allow NULL? 
5CRUSEREntered bynvarchar120CHAR(N' ')YesTB_CRUSER Allow NULL? 
6DCRDATEntered Onnvarchar80DATS(N'00000000')YesTB_DCRDAT Allow NULL? 
7TCRTIMEntry Timenvarchar60TIMS(N'000000')YesTB_TCRTIM Allow NULL? 
8UPUSERLast Changed bynvarchar120CHAR(N' ')YesTB_UPUSER Allow NULL? 
9DUPDATChanged onnvarchar80DATS(N'00000000')YesTB_DUPDAT Allow NULL? 
10TUPTIMTime changednvarchar60TIMS(N'000000')YesTB_TUPTIM Allow NULL? 
11SGSARTProduct Typenvarchar30CHAR(N' ')YesTZPAVVSART Allow NULL? 
12SFHAARTFinancial Transaction Typenvarchar30CHAR(N' ')YesAT10TB_SFHAART Allow NULL? 
13SFGZUSTTTransaction Activity Categorynvarchar20NUMC(N'00')YesAT02TB_SFGZUTY Allow NULL? 
14SFUNKTVTransition Function from Directly Preceding Activitynvarchar40CHAR(N' ')YesAT60TB_SFUNKTV Allow NULL? 
15SFUNKTLLatest function used in editing activitynvarchar40CHAR(N' ')YesAT60TB_SFUNKTL Allow NULL? 
16ROFHAZUPrevious Activitynvarchar50NUMC(N'00000')YesTB_ROFHAZU Allow NULL? 
17RFHAZUXPrevious activity, which is supplemented by current activitynvarchar50NUMC(N'00000')YesTB_RFHAZUX Allow NULL? 
18SAKTIVActive Status of Transaction or Activitychar10NUMC(N'0')YesTB_SAKTIV Allow NULL? 
19SSTOGRDReason for Reversalnvarchar20CHAR(N' ')YesTZSTSSTOGRD Allow NULL? 
20RDEALERTradernvarchar120CHAR(N' ')YesTZDEARDEALER Allow NULL? 
21DVTRABContract Conclusion Datenvarchar80DATS(N'00000000')YesTB_DVTRAB Allow NULL? 
22TVTRABTime of contract conclusionnvarchar60TIMS(N'000000')YesTB_TVTRAB Allow NULL? 
23GSPPARTContact Personnvarchar190CHAR(N' ')YesTB_GSPPART Allow NULL? 
24XAKTFile Numbernvarchar320CHAR(N' ')YesXAKT Allow NULL? 
25NORDEXTExternal Referencenvarchar160CHAR(N' ')YesTB_NORDEXT Allow NULL? 
26DBLFZTerm Startnvarchar80DATS(N'00000000')YesTB_DBLFZ Allow NULL? 
27DELFZTerm Endnvarchar80DATS(N'00000000')YesTB_DELFZ Allow NULL? 
28DFIXFixing datenvarchar80DATS(N'00000000')YesTB_DFIX Allow NULL? 
29SINCLEEnd of Term Inclusive Indicatorchar10CHAR(N' ')YesTB_SINCLE Allow NULL? 
30DZSTNDLast activity transition date (e.g. for rollover)nvarchar80DATS(N'00000000')YesTB_DZSTND Allow NULL? 
31SZNSPROInterest Handling with Rolloverchar10NUMC(N'0')YesTB_SZNSPRO Allow NULL? 
32DZNSSTDPayment date for deferred interestnvarchar80DATS(N'00000000')YesTB_DZNSSTD Allow NULL? 
33KKURSRate of Forex Transactiondecimal139DEC((0))YesTB_KKURS
34KKASSASpot Ratedecimal139DEC((0))YesTB_KKASSA
35KSWAPSwap Ratedecimal139DEC((0))YesTB_KSWAP
36WLWAERSLeading currencynvarchar50CUKY(N' ')YesTCURCTB_WLWAERS Allow NULL? 
37WFWAERSFollowing Currencynvarchar50CUKY(N' ')YesTCURCTB_WFWAERS Allow NULL? 
38LIMITARTLimit typenvarchar20CHAR(N' ')YesATORTB_LIMITAR Allow NULL? 
39LIMITDATLimit datenvarchar80DATS(N'00000000')YesTB_LIMITDA Allow NULL? 
40RKONDGRDirection of Transactionchar10NUMC(N'0')YesTB_RKONDGR Allow NULL? 
41LIWAERSReference currency for limitnvarchar50CUKY(N' ')YesTCURCTB_LIWAERS Allow NULL? 
42KWLIQUILiquidity effect for rolloverdecimal139DEC((0))YesTX_KWLIQ
43SCONFIRMConfirmation Statuschar10NUMC(N'0')YesTB_CONF Allow NULL? 
44DEXDATConfirmation Datenvarchar80DATS(N'00000000')YesTB_DCONF Allow NULL? 
45UEXNAMConfirmation Executed By (User Responsible)nvarchar120CHAR(N' ')YesTB_UCONF Allow NULL? 
46SRECONFIRMCounterconfirmationchar10NUMC(N'0')YesTB_RECONF Allow NULL? 
47DREDATCounterconfirmation Datenvarchar80DATS(N'00000000')YesTB_DREDAT Allow NULL? 
48URENAMCounterconfirmation Executed by (User Responsible)nvarchar120CHAR(N' ')YesTB_URENAM Allow NULL? 
49DORDEROrder datenvarchar80DATS(N'00000000')YesTB_DORDER Allow NULL? 
50DANSTReservation datenvarchar80DATS(N'00000000')YesTB_DANST Allow NULL? 
51TANSTOrder time of daynvarchar60TIMS(N'000000')YesTB_TANST Allow NULL? 
52SANSTReservation Reasonnvarchar20CHAR(N' ')YesTW14TB_SANST Allow NULL? 
53SSPESENExpenses keychar10CHAR(N' ')YesTB_SPESEN Allow NULL? 
54BUPRCLIMLimit Price for Unit Quotationdecimal156DEC((0))YesTB_BUPRCLIM
55SRUNITLIMCurrency Unit of the Ratenvarchar50CHAR(N' ')YesTZUNITB_RUNIT Allow NULL? 
56BPPRCLIMLimit Price for Percentage Quotationdecimal156DEC((0))YesTB_BPPRCLIM
57JVERK6BFlag for sale from ยง6b - positionchar10CHAR(N' ')YesTB_VERK6B Allow NULL? 
58PEFFZINSEffective Interest Ratedecimal107DEC((0))YesTB_PYIELD
59PEFFZINS_GIVENGiven Effective Interest Ratedecimal107DEC((0))YesTB_PYIELD_GIVEN
60PEFFZCALLEffective interest rate - termination of issuerdecimal107DEC((0))YesTB_PYIELDCALL
61SEFFMETHEffective Interest Method (Financial Mathematics)char10NUMC(N'0')YesSEFFMETH Allow NULL? 
62NOTICE_DATEOTC Notice Datenvarchar80DATS(N'00000000')YesTB_NOTICE_DATE Allow NULL? 
63ROUNDING_RULERounding Rulenvarchar40CHAR(N' ')YesTRSC_ROUND_RULETPM_ROUNDING_RULE Allow NULL? 
64BPPRC_SPOT2Spot Rate at Maturity in Percentagedecimal156DEC((0))YesTB_BPPRC_SPOT_MAT
65BPPRC_SPOT1Current Spot Rate in Percentagedecimal156DEC((0))YesTB_BPPRC_SPOT1
66BPPRC_MARGMargin Rate in Percentagedecimal155DEC((0))YesTB_BPPRC_MARG
67COC_RATEInterest Rate for Cost of Carry Forwarddecimal156DEC((0))YesTB_BPPRC_COC
NamePrimaryUniqueTypeColumns
OTC_CONV_FHAZU~0YesYesCLUSTEREDRFHAZU, RFHA, BUKRS, 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