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  | TRGC_STEP_PROC
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
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager :: Transfer to Financial Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TRGC_STEP_PROC561Procedure for StepsTransfer to Financial Accounting
SQL:  selectupdate insert create

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

SELECT MANDT, STEP_CAT, STEP_PROC, PRICE_TYPE, CV_TYPE, RATE_CATEGORY, RULE_UP, RULE_DOWN, FLG_COSTS, RESOLVE_TI, RESOLVE_FE, GAIN_LOSS_HANDL, RESET_TITLE_VAL, COMPUTATION_CAT, BRUTTO_NETTO, RATE_CALC_METHOD, PURCHASE_GAAP, DISSOLVE, AMORT_END, RATE_CAT_SPOTP, RATE_CAT_SPOTS, RATE_CAT_SWAPP, RATE_CAT_SWAPS, FORWARD_CAT, CROSS_VAL, ACCRUE_COMP, SP_VAL_SEC, NPV_CATEGORY, INCL_INTEREST, EFF_INT_SAC, SULTVON, SULTBIS, AMORT_CUT, ALLOW_CALC_AMORT, VAD_AMORT, COMP_VAL, POSTING_SPEC_VAL, FX_NETTING_DEAL, CV_TYPE_START, INTEREST_RISK, CREDIT_RISK, FXRATE_RISK, PRICE_RISK, EVAL_TYP, CONV_RATE_AMORT, FLG_DIRTY_PRICE, ACCRUAL_INCL, ACCRUAL_ULTIMO, FLG_CLR_VAL_CURR, FLG_AMORT_END_EX, FLG_EXCL_TB, CUSTOM_ATTRIB, ACCRUAL_FUNCTION, FLG_HREL_LIMITED, FLG_ADJ_TRANSL4A, AFFECT_DERIV_COMP FROM TRGC_STEP_PROC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2STEP_CATType of Stepnvarchar30NUMC(N'000')NoTRGTS_STEPDEFTPM_VAL_STEP_CAT Allow NULL? 
3STEP_PROCProcedure for a Stepnvarchar40CHAR(N' ')NoTPM_STEP_PROCEDURE Allow NULL? 
4PRICE_TYPESecurity Price Typenvarchar20CHAR(N' ')YesTW56VVSKURSART Allow NULL? 
5CV_TYPEPrice/NPV Type for OTC Transactionsnvarchar30CHAR(N' ')YesATVOKTV_OKUART Allow NULL? 
6RATE_CATEGORYExchange Rate Typenvarchar40CHAR(N' ')YesTCURVKURST_CURR Allow NULL? 
7RULE_UPWrite-Up Rulechar10CHAR(N' ')YesTPM_UP Allow NULL? 
8RULE_DOWNWrite-Down Rulechar10CHAR(N' ')YesTPM_DOWN Allow NULL? 
9FLG_COSTSWrite Off Costs Fullychar10CHAR(N' ')YesTPM_COSTS Allow NULL? 
10RESOLVE_TIIndicator: Clear Gains/Losseschar10CHAR(N' ')YesTPM_PARTITION Allow NULL? 
11RESOLVE_FEIndicator: Clear Gains/Losseschar10CHAR(N' ')YesTPM_PARTITION Allow NULL? 
12GAIN_LOSS_HANDLHandling of Gains/Losseschar10CHAR(N' ')YesTPM_GAIN_LOSS_HANDLING Allow NULL? 
13RESET_TITLE_VALFlag for reset of Title valuation during year end valuationchar10CHAR(N' ')YesTPM_FLG_RESET_TITLE_VAL Allow NULL? 
14COMPUTATION_CATCalculation Category for Amortizationnvarchar20CHAR(N' ')YesTPM_COMPUTATION_CAT Allow NULL? 
15BRUTTO_NETTOIndicator Gross or Net Procedurechar10CHAR(N' ')YesTPM_BRUTTO_NETTO Allow NULL? 
16RATE_CALC_METHODEffective Interest Method (Financial Mathematics)char10NUMC(N'0')YesSEFFMETH Allow NULL? 
17PURCHASE_GAAPPurchase GAAP Indicatornvarchar30NUMC(N'000')YesTPM_PURCHASE_GAAP Allow NULL? 
18DISSOLVEFlag: Reset is Possiblechar10CHAR(N' ')YesTPM_DISSOLVE Allow NULL? 
19AMORT_ENDAmortization to Final Due Date / Terminationtinyint30INT1((0))YesTPM_AMORT_END
20RATE_CAT_SPOTPRate Type for Spot - Purchase Currency/Valuation Currencynvarchar40CHAR(N' ')YesTCURVTPM_RATE_CAT_SPOTP Allow NULL? 
21RATE_CAT_SPOTSRate Type for Spot - Selling Currency/Valuation Currencynvarchar40CHAR(N' ')YesTCURVTPM_RATE_CAT_SPOTS Allow NULL? 
22RATE_CAT_SWAPPRate Type for Spot - Purchase Currency/Valuation Currencynvarchar40CHAR(N' ')YesTCURVTPM_RATE_CAT_SWAPP Allow NULL? 
23RATE_CAT_SWAPSRate Type for Swap - Selling Currency/Valuation Currencynvarchar40CHAR(N' ')YesTCURVTPM_RATE_CAT_SWAPS Allow NULL? 
24FORWARD_CATRate Valuation Category Forwardchar10CHAR(N' ')YesTPM_FORWARD_CAT Allow NULL? 
25CROSS_VALIndicator: Cross Valuation for Forward Exchange Transactionchar10CHAR(N' ')YesTPM_CROSS Allow NULL? 
26ACCRUE_COMPAdditional Components Managednvarchar20CHAR(N' ')YesTPM_ACCRUE_COMP Allow NULL? 
27SP_VAL_SECIndicator: Enable Special Write-Up/Write-Down for Securitieschar10CHAR(N' ')YesTPM_SP_VAL_SEC Allow NULL? 
28NPV_CATEGORYNPV Categorychar10CHAR(N' ')YesTPM_NPV_CATEGORY Allow NULL? 
29INCL_INTERESTInclusion of Interest in Amortization Calculationchar10NUMC(N'0')YesTPM_INCL_INTEREST Allow NULL? 
30EFF_INT_SACTreatment of Effect. Interest Rate for Amort. Acc. to SACchar10NUMC(N'0')YesTPM_EFF_INTEREST_SAC Allow NULL? 
31SULTVONMonth-End Indicator for Start of a Calculation Periodchar10CHAR(N' ')YesVVSULTVON Allow NULL? 
32SULTBISMonth-End Indicator for the End of a Calculation Periodchar10CHAR(N' ')YesVVSULTBIS Allow NULL? 
33AMORT_CUTCut SAC Amortizationchar10CHAR(N' ')YesTPM_AMORT_CUT Allow NULL? 
34ALLOW_CALC_AMORTAllow Calculation of Derived Business Transactionschar10CHAR(N' ')YesTPM_ALLOW_CALC_DERIVED Allow NULL? 
35VAD_AMORTAmortization of Value Adjustment Componentschar10CHAR(N' ')YesTPM_VAD_AMORT Allow NULL? 
36COMP_VALSelect Component for Valuationchar10CHAR(N' ')YesTPM_COMP_VAL Allow NULL? 
37POSTING_SPEC_VALPosting Specifications Selectionchar10CHAR(N' ')YesTPM_POSTING_SPEC_VAL Allow NULL? 
38FX_NETTING_DEALIndicator: Offsetting Transaction for Forward Exchange Transchar10CHAR(N' ')YesTPM_NETTING Allow NULL? 
39CV_TYPE_STARTPrice/NPV Type for OTC Transactionsnvarchar30CHAR(N' ')YesATVOKTV_OKUART Allow NULL? 
40INTEREST_RISKInterest Rate Risk Yes/Nochar10CHAR(N' ')YesTPM_RISK_IR Allow NULL? 
41CREDIT_RISKCredit Risk Yes/Nochar10CHAR(N' ')YesTPM_RISK_CR Allow NULL? 
42FXRATE_RISKFx Risk Yes/Nochar10CHAR(N' ')YesTPM_RISK_FX Allow NULL? 
43PRICE_RISKPrice Risk Yes/Nochar10CHAR(N' ')YesTPM_RISK_PR Allow NULL? 
44EVAL_TYPID of Risk Management Evaluationnvarchar40CHAR(N' ')YesJBREVALJBREVAL_D Allow NULL? 
45CONV_RATE_AMORTAmortization Rate Conversion Categorytinyint30INT1((0))YesTPM_CONV_RATE_AMORT
46FLG_DIRTY_PRICEUse Dirty Price (Market Price + Interest Accrual)char10CHAR(N' ')YesTPM_FLG_DIRTY_PRICE Allow NULL? 
47ACCRUAL_INCLIndicator for Including Key Datechar10CHAR(N' ')YesTPM_KEY_DATE_INCL Allow NULL? 
48ACCRUAL_ULTIMOMonth-End Indicator for Key Datechar10CHAR(N' ')YesTPM_KEY_DATE_ULT Allow NULL? 
49FLG_CLR_VAL_CURRClear Amount in Valuation Currency if Valuation is Resolvedchar10CHAR(N' ')YesTPM_TI_CLEAR_VAL_CURR_AMT Allow NULL? 
50FLG_AMORT_END_EXExclude Final Amortization Date from Amortization Periodchar10CHAR(N' ')YesTPM_FLG_AMORT_END_EXCL Allow NULL? 
51FLG_EXCL_TBExclude Interest-Like Flows from Calculationchar10CHAR(N' ')YesTPM_FLG_AMORT_EXCL_TB_FLOWS Allow NULL? 
52CUSTOM_ATTRIBCustom Setting for Valuation Stepnvarchar40CHAR(N' ')YesTPM_VAL_STEP_ATTRIB Allow NULL? 
53ACCRUAL_FUNCTIONAccrual/Deferral Methodnvarchar30CHAR(N' ')YesTPM_TRLI_AD_FUNCTION Allow NULL? 
54FLG_HREL_LIMITEDExecute Solely in the Case of Hedge Accountingchar10CHAR(N' ')YesTPM_HREL_LIMITED Allow NULL? 
55FLG_ADJ_TRANSL4AAdjustment of Translation Flows for Amortizationchar10CHAR(N' ')YesTPM_ADJUST_AMORT_TRANSL Allow NULL? 
56AFFECT_DERIV_COMPAffect Derive Componentschar10CHAR(N' ')YesTPM_AFFECT_DERIV_COMP Allow NULL? 
NamePrimaryUniqueTypeColumns
TRGC_STEP_PROC~0YesYesCLUSTEREDMANDT, STEP_CAT, STEP_PROC

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