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  | VTBFHAPO_UNFIXED
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)
8BSEG345Accounting Document Segment
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
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
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.0VTBFHAPO_UNFIXED1761Non-Fixed Financial Transaction FlowsTransaction Manager
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, RFHA, RFHAZU, DCRDAT, TCRTIM, RFHAZB, CRUSER, UPUSER, DUPDAT, TUPTIM, RANTYP, SFHAZBA, SBKKLAS, SBKTYP, SBERFIMA, SSIGN, SHERKUNFT, SABVERF, RKONDGR, RKOND, DGUEL_KP, NSTUFE, SKOART, RREFKONT, SBZVABW, RAHABKI, RAHKTID, RPZAHL, RPBANK, SZART, ZLSCH, UZAWE, SPAYRQ, SPRSNG, SPRGRD, SCSPAY, ZWELS, PAYGR, SBEWEBE, SSPRGRD, SBFREI, SSTORNOBWG, PRKEY, BELNR, BELNR2, GJAHR, DBUCHUNG, DFAELL, DZTERM, BZBETR, WZBETR, BHWBETR, KHWKURS, ASTUECK, BPRICE, WPRICE, BHWPREIS, BINDEX, VVBASIS, PWKURS, PRKKURS, BNWHR, RHANDPL, SKURSART, DBERVON, DBERBIS, ATAGE, ABASTAGE, PKOND, DPKOND, DZFEST, SZBMETH, SKALIDWT, BBASIS, WBASIS, JEXPOZINS, SINCL, SINCLBIS, SULTBIS, SEXCLVON, SULTVON, SAEND, DVALUT, SVINCL, SVULT, JSOFVERR, DVERRECH, SINCLVERR, SULTVERR, SSTORNOMAN, SSTORNOART, SBWGARTREF, SKHWFIX, ZUONR, RLDEPO, RANL, RTRBELNR, BUPRC, BPPRC, WBBETR, BBBETR, WEBETR, BEBETR, SRUNIT, KZWKURS, KBWKURS, WSBETR, DBESTAND, SSTCKKZ, SSTCKTG, SFLAT, SCOUPON, DCOUPON, AWKEY, INDEX_VALUE, SBASIS, REGI_STATE, RPCODE, RP_TEXT, HEDGE_ID, DBPERIOD, SPAEXCL, SPAULT, DEPERIOD, SPEINCL, SPEULT, AMMRHY, PPAYMENT, AMMRHYZV, LZBKZ, LANDL, BDIRTY, BAMOUNTCOMP, NOMINAL_ORG_AMT, NOM_FACTOR, RLDEPO2, INDEX_PRICE, FLOWUUID, FLAGBYTE1, QUANTITY, UNIT_OF_MEASURE, CONTRACT_PRICE, SPOT_PRICE, CONTANGO_BACKWRD, BPRC_SPOT1, BPRC_SPOT2, COST_FWD, INTEREST_FWD, REF_FLOWUUID, RGATT, COMMODITY_ID, QUOTATION_NAME, QUOTATION_SOURCE, QUOTATION_TYPE, SPREAD, PRICE_CURR_UNIT, PRICE_UOM, DIV_PCTC_OTC, TAINTED, CLEARED, DCSID, MIC, PRICE_TYPE, TIME_TO_MATURITY, TIMING, EXCH_RATE_TYPE, PRICE_PAYM_CURR, SPREAD_PAYM_CURR, FX_TRANSLATION, MNDID, IDCFM_USHA_TYPE, IDCFM_USHA_PERC, IDCFM_USHA_TOTA, IDCFM_USHA_CURR, IDCFM_USHA_FORM FROM VTBFHAPO_UNFIXED
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
3RFHAFinancial Transactionnvarchar130CHAR(N' ')No*TB_RFHA Allow NULL? 
4RFHAZUTransaction activitynvarchar50NUMC(N'00000')NoTB_RFHAZU Allow NULL? 
5DCRDATEntered Onnvarchar80DATS(N'00000000')NoTB_CRDAT Allow NULL? 
6TCRTIMEntry Timenvarchar60TIMS(N'000000')NoTB_TCRTIM Allow NULL? 
7RFHAZBTransaction flownvarchar40NUMC(N'0000')NoTB_RFHAZB Allow NULL? 
8CRUSEREntered bynvarchar120CHAR(N' ')YesTB_CRUSER Allow NULL? 
9UPUSERLast Changed bynvarchar120CHAR(N' ')YesTB_UPUSER Allow NULL? 
10DUPDATChanged onnvarchar80DATS(N'00000000')YesTB_DUPDAT Allow NULL? 
11TUPTIMTime changednvarchar60TIMS(N'000000')YesTB_TUPTIM Allow NULL? 
12RANTYPContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
13SFHAZBAFlow Typenvarchar40CHAR(N' ')YesTZB0ATB_SFHAZBA Allow NULL? 
14SBKKLASClassification of flows and conditionschar10CHAR(N' ')YesTB_SBKKLAS Allow NULL? 
15SBKTYPCategory of Flows and Conditionsnvarchar20CHAR(N' ')YesAT07TB_SBKTYP Allow NULL? 
16SBERFIMACalculation category for cash flow calculatornvarchar40CHAR(N' ')YesAT40SBEWFIMA Allow NULL? 
17SSIGNDirection of flowchar10CHAR(N' ')YesTB_SSIGN Allow NULL? 
18SHERKUNFTDisplay Area of Flow or Conditionnvarchar40CHAR(N' ')YesTB_SHERK Allow NULL? 
19SABVERFProcedure to Generate Derived Flowsnvarchar50CHAR(N' ')YesAT22TB_SABVERF Allow NULL? 
20RKONDGRDirection of Transactionchar10NUMC(N'0')YesTB_RKONDGR Allow NULL? 
21RKONDConditionnvarchar40NUMC(N'0000')YesTB_KOND Allow NULL? 
22DGUEL_KPCondition Item Valid Fromnvarchar80DATS(N'00000000')YesDGUEL_KP Allow NULL? 
23NSTUFELevel number of condition item for recurring paymentsnvarchar20NUMC(N'00')YesNSTUFE Allow NULL? 
24SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40NUMC(N'0000')YesTZK01SKOART Allow NULL? 
25RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Managementnvarchar80CHAR(N' ')YesT037SRREFKONT_OBSOLETE Allow NULL? 
26SBZVABWAlternative payment details stated in flowchar10CHAR(N' ')YesTB_SBZVABW Allow NULL? 
27RAHABKIShort key for own house banknvarchar50CHAR(N' ')YesT012TB_RHABKI Allow NULL? 
28RAHKTIDShort key for house bank accountnvarchar50CHAR(N' ')YesT012KTB_RHKTID Allow NULL? 
29RPZAHLPayer/payeenvarchar100CHAR(N' ')Yes*TB_RPZAHL_NEW Allow NULL? 
30RPBANKPartner bank detailsnvarchar40CHAR(N' ')YesTB_RPBANK Allow NULL? 
31SZARTPayment transactionchar10CHAR(N' ')YesTB_SZART Allow NULL? 
32ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZDZLSCH Allow NULL? 
33UZAWEPayment Method Supplementnvarchar20CHAR(N' ')YesT042FUZAWE Allow NULL? 
34SPAYRQGenerate payment requestchar10CHAR(N' ')YesTB_SPAYRQK Allow NULL? 
35SPRSNGIndividual paymentchar10CHAR(N' ')YesTB_SPRSNGK Allow NULL? 
36SPRGRDDetermine grouping definitionchar10CHAR(N' ')YesTB_SPRGRD Allow NULL? 
37SCSPAYSame direction necessary for joint payment?char10CHAR(N' ')YesTB_SCSPAY Allow NULL? 
38ZWELSList of the Payment Methods to be Considerednvarchar100CHAR(N' ')YesDZWELS Allow NULL? 
39PAYGRGrouping Field for Automatic Paymentsnvarchar200CHAR(N' ')YesPAYGR Allow NULL? 
40SBEWEBEPosting Status of Flowchar10CHAR(N' ')YesTB_SBEWEBE Allow NULL? 
41SSPRGRDReason Why Flow Is Blocked for Postingchar10NUMC(N'0')YesTB_SSPRGRD Allow NULL? 
42SBFREIRelease Given for Flow to Be Posted?char10CHAR(N' ')YesTB_SBFREI Allow NULL? 
43SSTORNOBWGFlow reversal in Treasurychar10CHAR(N' ')YesTB_SBWGSTO Allow NULL? 
44PRKEYKey Number for Payment Requestnvarchar100CHAR(N' ')Yes*PRQ_KEYNO Allow NULL? 
45BELNRAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
46BELNR2Doc. no. of a second accounting doc. for currency swapnvarchar100CHAR(N' ')YesTB_BELNR2 Allow NULL? 
47GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
48DBUCHUNGPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
49DFAELLDue datenvarchar80DATS(N'00000000')YesTB_DFAELL Allow NULL? 
50DZTERMPayment or Delivery Datenvarchar80DATS(N'00000000')YesTB_DZTERM Allow NULL? 
51BZBETRPayment amount in payment currencydecimal132CURR((0))YesTB_BZBETR
52WZBETRPayment Currencynvarchar50CUKY(N' ')YesTCURCTB_WZBETR Allow NULL? 
53BHWBETRPayment Amount in Local Currencydecimal132CURR((0))YesTB_HWBETR
54KHWKURSLocal currency ratedecimal95DEC((0))YesTB_KHWKURS
55ASTUECKNo. of Units for Financial Instrumentsdecimal155DEC((0))YesTB_ASTUECK
56BPRICEPrice per unitdecimal132CURR((0))YesTB_BPRICE
57WPRICEPrice currencynvarchar50CUKY(N' ')YesTCURCTB_WPRICE Allow NULL? 
58BHWPREISPrice in local currencydecimal132CURR((0))YesTB_HWPREIS
59BINDEXValue of a pointdecimal132CURR((0))YesTB_BINDEX
60VVBASISPrice in pointsdecimal116DEC((0))YesTB_VVBASIS
61PWKURSPrice as percentage quotationdecimal107DEC((0))YesTB_PWKURS
62PRKKURSCurrency option premium with price in pointsdecimal139DEC((0))YesTI_PRKUR
63BNWHRNominal amountdecimal132CURR((0))YesTB_BNWHR
64RHANDPLExchangenvarchar100CHAR(N' ')YesTWH01VVRHANDPL Allow NULL? 
65SKURSARTRate/Price Type - Treasury Instrumentsnvarchar20CHAR(N' ')YesTW56TI_KURSART Allow NULL? 
66DBERVONStart of Calculation Periodnvarchar80DATS(N'00000000')YesDBERVON Allow NULL? 
67DBERBISEnd of Calculation Periodnvarchar80DATS(N'00000000')YesDBERBIS Allow NULL? 
68ATAGENumber of daysnvarchar60NUMC(N'000000')YesVVATAGE Allow NULL? 
69ABASTAGENumber of base days in a calculation periodnvarchar60NUMC(N'000000')YesABASTAGE Allow NULL? 
70PKONDPercentage rate for condition itemsdecimal107DEC((0))YesPKOND
71DPKONDDetermination date for percentage rate of condition itemsnvarchar80DATS(N'00000000')YesVVDPKOND Allow NULL? 
72DZFESTInterest rate fixing datenvarchar80DATS(N'00000000')YesTB_DZFEST Allow NULL? 
73SZBMETHInterest Calculation Methodchar10CHAR(N' ')YesSZBMETH Allow NULL? 
74SKALIDWTInterest Calendarnvarchar20CHAR(N' ')Yes*TFMSKALIDWT Allow NULL? 
75BBASISCalculation base amountdecimal132CURR((0))YesBBASIS
76WBASISCurrency of calculation basisnvarchar50CUKY(N' ')YesTCURCTB_WBASIS Allow NULL? 
77JEXPOZINSExponential Interest Calculationchar10CHAR(N' ')YesTB_JZINSRE Allow NULL? 
78SINCLInclusive indicator for beginning and end of a periodchar10NUMC(N'0')YesVVSINCL Allow NULL? 
79SINCLBISInclusive Indicator for the End of a Calculation Periodchar10NUMC(N'0')YesVVSINCLBIS Allow NULL? 
80SULTBISMonth-End Indicator for the End of a Calculation Periodchar10CHAR(N' ')YesVVSULTBIS Allow NULL? 
81SEXCLVONExclusive Indicator for the Start of a Calculation Periodchar10NUMC(N'0')YesVVSEXCLVON Allow NULL? 
82SULTVONMonth-End Indicator for Start of a Calculation Periodchar10CHAR(N' ')YesVVSULTVON Allow NULL? 
83SAENDChange Indicator for FiMa Flow Recordschar10NUMC(N'0')YesTFM_SAEND Allow NULL? 
84DVALUTCalculation Datenvarchar80DATS(N'00000000')YesDVALUT Allow NULL? 
85SVINCLInclusive indicator for value datechar10NUMC(N'0')YesVVSVINCL Allow NULL? 
86SVULTMonth-End Indicator for Value Datechar10CHAR(N' ')YesVVSVULT Allow NULL? 
87JSOFVERRIndicator for Immediate Settlement (Financial Mathematics)char10CHAR(N' ')YesTFMSOFVERR Allow NULL? 
88DVERRECHSettlement datenvarchar80DATS(N'00000000')YesVVDVERRECH Allow NULL? 
89SINCLVERRInclusive Indicator for Clearing Datechar10NUMC(N'0')YesVVSINCLVER Allow NULL? 
90SULTVERRMonth-End Indicator for Clearing Datechar10CHAR(N' ')YesVVSULTVERR Allow NULL? 
91SSTORNOMANManual reversal of flows posted in FIchar10CHAR(N' ')YesTB_SBWGSTM Allow NULL? 
92SSTORNOARTType of manual reversal of flows posted in FInvarchar20CHAR(N' ')YesAT90TB_SSTOART Allow NULL? 
93SBWGARTREFReferenced flow typenvarchar40CHAR(N' ')YesTZB0ATB_SBWGREF Allow NULL? 
94SKHWFIXIndicator for translation into local currencychar10CHAR(N' ')YesTB_SKHWFIX Allow NULL? 
95ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
96RLDEPOSecurities Accountnvarchar100CHAR(N' ')Yes*RLDEPO Allow NULL? 
97RANLSecurity ID Numbernvarchar130CHAR(N' ')Yes*VVRANLW Allow NULL? 
98RTRBELNRInternal document number of derivatives documentnvarchar150CHAR(N' ')YesTPM_DEDOC_RDOCNRINT Allow NULL? 
99BUPRCSecurity Price Without Currency Ref. with Unit Quotationdecimal156DEC((0))YesTB_BUPRC
100BPPRCSecurity Price for Percentage Quotationdecimal156DEC((0))YesTB_BPPRC
101WBBETRCurrency of Position Amountnvarchar50CUKY(N' ')Yes*TB_WBBETR Allow NULL? 
102BBBETRAmount that Changes the Positiondecimal132CURR((0))YesTB_BBBETR
103WEBETRPrice currencynvarchar50CUKY(N' ')Yes*TB_WEBETR Allow NULL? 
104BEBETRMarket Value in Quotation Currencydecimal132CURR((0))YesTB_BEBETR
105SRUNITCurrency Unit of the Ratenvarchar50CHAR(N' ')YesTZUNITB_RUNIT Allow NULL? 
106KZWKURSPayment currency ratedecimal95DEC((0))YesTB_KZWKURS
107KBWKURSPosition currency ratedecimal95DEC((0))YesTB_KBWKURS
108WSBETRCurrency Key for Currency Conversion: Source Currencynvarchar50CUKY(N' ')Yes*TB_WFROM Allow NULL? 
109DBESTANDPosition Value Datenvarchar80DATS(N'00000000')YesTB_DBESTAND Allow NULL? 
110SSTCKKZAccrued interest methodchar10CHAR(N' ')YesSSTCKKZ Allow NULL? 
111SSTCKTGAccrued interest: Daily methodchar10CHAR(N' ')YesSSTCKTG Allow NULL? 
112SFLATIndicator 'Traded flat',i.e.no accrued interest calculationchar10CHAR(N' ')YesVVSFLAT Allow NULL? 
113SCOUPONCoupon ID for interest and accrued interest calculationchar10CHAR(N' ')YesVVSCOUPON Allow NULL? 
114DCOUPONCoupon date of next delivered couponnvarchar80DATS(N'00000000')YesVVDCOUPON Allow NULL? 
115AWKEYReference Keynvarchar200CHAR(N' ')YesAWKEY Allow NULL? 
116INDEX_VALUEIndex Value (Independent of Basis)decimal1812DEC((0))YesTIDX_INDEX_VALUE_NO_RATIO
117SBASISCalculation base indicatornvarchar40CHAR(N' ')Yes*SBASIS Allow NULL? 
118REGI_STATEStatus of Interest Rate Adjustmentnvarchar20CHAR(N' ')YesTB_IRA_REGISTRATION_STATE Allow NULL? 
119RPCODERepetitive Codenvarchar200CHAR(N' ')Yes*RPCODE Allow NULL? 
120RP_TEXTReference Text for Repetitive Codenvarchar500CHAR(N' ')YesRPCODE_TEXT Allow NULL? 
121HEDGE_IDIdentification for Hedging Relationshipnvarchar100CHAR(N' ')YesTPM_HEDGE_ID Allow NULL? 
122DBPERIODPeriod startnvarchar80DATS(N'00000000')YesVVDBPERIOD Allow NULL? 
123SPAEXCLExclusive Indicator for Start Date of a Periodchar10NUMC(N'0')YesTFMSPAEXCL Allow NULL? 
124SPAULTMonth-End Indicator for Start Date of a Periodchar10CHAR(N' ')YesTFMSPAULT Allow NULL? 
125DEPERIODPeriod Endnvarchar80DATS(N'00000000')YesVVDEPERIOD Allow NULL? 
126SPEINCLInclusive Indicator for End Date of a Periodchar10NUMC(N'0')YesTFMSPEINCL Allow NULL? 
127SPEULTMonth-End Indicator for End of a Periodchar10CHAR(N' ')YesTFMSPEULT Allow NULL? 
128AMMRHYFrequency in monthsnvarchar30NUMC(N'000')YesAMMRHY Allow NULL? 
129PPAYMENTPayment Ratedecimal117DEC((0))YesTFM_PPAYMENT
130AMMRHYZVInterest Settlement Frequency for Exponential Interest Calc.nvarchar20NUMC(N'00')YesTFM_AMMRHYZV Allow NULL? 
131LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')YesT015LLZBKZ Allow NULL? 
132LANDLSupplying Countrynvarchar30CHAR(N' ')YesT005LANDL Allow NULL? 
133BDIRTYDirty Pricedecimal132CURR((0))YesTB_BDIRTY
134BAMOUNTCOMPAmount to be Capitalizeddecimal132CURR((0))YesTB_AMOUNTCOMP
135NOMINAL_ORG_AMTOrignal Nominal Amountdecimal132CURR((0))YesTB_BNWHR_ORG
136NOM_FACTORFactordecimal129DEC((0))YesRDPT_FACTOR_VAL
137RLDEPO2Securities Accountnvarchar100CHAR(N' ')Yes*VRLDEPO Allow NULL? 
138INDEX_PRICEIndicator: Security Price Including Price Index Valuechar10CHAR(N' ')YesTB_INDEX_PRICE Allow NULL? 
139FLOWUUIDTransaction Flow UUIDvarbinary160RAWYesTB_FLOWUUID
140FLAGBYTE1Indicator for Financial Transaction Flow (See Documentation)varbinary10RAWYesTB_FLAGBYTE1
141QUANTITYQuantitydecimal133QUAN((0))YesFTR_QUAN
142UNIT_OF_MEASUREUnit of Measure for the Commoditynvarchar30UNIT(N' ')Yes*TPM_CTY_UOM Allow NULL? 
143CONTRACT_PRICECommodity Pricedecimal135DEC((0))YesFTR_COMPRICE
144SPOT_PRICECommodity Spot Pricedecimal135DEC((0))YesFTR_COMSPOT
145CONTANGO_BACKWRDCommodity Contango / Backwardationdecimal135DEC((0))YesFTR_CONBACK
146BPRC_SPOT1Current Spot Rate in Percentagedecimal156DEC((0))YesTB_BPPRC_SPOT1
147BPRC_SPOT2Spot Rate at Maturity in Percentagedecimal156DEC((0))YesTB_BPPRC_SPOT_MAT
148COST_FWDForward Rate Costdecimal156DEC((0))YesTB_COSTFWD
149INTEREST_FWDForward Rate Interestdecimal156DEC((0))YesTB_INTERESTFWD
150REF_FLOWUUIDFlow Reference (UUID)varbinary160RAWYesTB_REFFLOWUUID
151RGATTClassnvarchar130CHAR(N' ')YesTI_RGATT Allow NULL? 
152COMMODITY_IDCommodity IDnvarchar180CHAR(N' ')YesTRCO_COMM_ID Allow NULL? 
153QUOTATION_NAMEQuotation Namenvarchar180CHAR(N' ')YesCPET_QUOTNAME Allow NULL? 
154QUOTATION_SOURCEQuotation Sourcenvarchar20CHAR(N' ')YesTRCOCC_QUOTSRCTCR_CTY_QUOTSRC Allow NULL? 
155QUOTATION_TYPECommodity Quotation Typenvarchar50CHAR(N' ')YesTRCOCC_QUOTTYPETCR_CTY_QUOTTYPE Allow NULL? 
156SPREADCommodity Spreaddecimal135DEC((0))YesFTR_COMSPREAD
157PRICE_CURR_UNITCurrency Unit of the Ratenvarchar50CHAR(N' ')YesTZUNITB_RUNIT Allow NULL? 
158PRICE_UOMUnit of Measure for the Commoditynvarchar30UNIT(N' ')Yes*TPM_CTY_UOM Allow NULL? 
159DIV_PCTC_OTCPercentage of Dividend agreed for Payment in OTC Instrumentsdecimal74DEC((0))YesTB_DIV_PCTC_OTC
160TAINTEDManipulated Cash Flowchar10CHAR(N' ')YesTB_TAINTED_CASHFLOW Allow NULL? 
161CLEAREDClearing at Flow Levelchar10CHAR(N' ')YesFTR_FLOW_CLEARED Allow NULL? 
162DCSIDDerivative Contract Specification IDnvarchar60CHAR(N' ')Yes*TBA_DCSID Allow NULL? 
163MICMarket Identifier Codenvarchar40CHAR(N' ')Yes*TBA_MIC Allow NULL? 
164PRICE_TYPEType of Price Quotationnvarchar20CHAR(N' ')Yes*TBA_PRICETYPE Allow NULL? 
165TIME_TO_MATURITYTime to Maturitynvarchar100CHAR(N' ')Yes*TBA_TENOR Allow NULL? 
166TIMINGTiming/Periodicity of Commodity Forward Indexesnvarchar20NUMC(N'00')YesTBA_TIMING Allow NULL? 
167EXCH_RATE_TYPEExchange Rate Typenvarchar40CHAR(N' ')Yes*KURST_CURR Allow NULL? 
168PRICE_PAYM_CURRCommodity Price in Payment Currencydecimal135DEC((0))YesFTR_COMPRICE_PAYMENT_CURR
169SPREAD_PAYM_CURRCommodity Spread in Payment Currencydecimal135DEC((0))YesFTR_COMSPREAD_PAYMENT_CURR
170FX_TRANSLATIONDefines when quotation crcy is converted into payment crcychar10CHAR(N' ')YesFTR_CURRENCY_CONV_POINT_IN_TIM Allow NULL? 
171MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350CHAR(N' ')YesSEPA_MNDID Allow NULL? 
172IDCFM_USHA_TYPEHaircut Rate Typechar10CHAR(N' ')YesIDCFM_USHA_DEL_TYPE Allow NULL? 
173IDCFM_USHA_PERCPercentage Valuedecimal107DEC((0))YesIDCFM_USHA_DEL_PERC
174IDCFM_USHA_TOTAEnter Haircut Amount in PCdecimal132CURR((0))YesIDCFM_USHA_DEL_TOTA
175IDCFM_USHA_CURRCurrency of Haircut Amountnvarchar50CUKY(N' ')Yes*IDCFM_USHA_DEL_CURR Allow NULL? 
176IDCFM_USHA_FORMEuropean Formula Calculationchar10CHAR(N' ')YesIDCFM_USHA_DEL_FORM Allow NULL? 
NamePrimaryUniqueTypeColumns
VTBFHAPO_UNFIXED~0YesYesCLUSTEREDMANDT, BUKRS, RFHA, RFHAZU, DCRDAT, TCRTIM, RFHAZB

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