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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
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 TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2STEP_CATType of Stepnvarchar30 Allow NULL? 
3STEP_PROCProcedure for a Stepnvarchar40 Allow NULL? 
4PRICE_TYPESecurity Price Typenvarchar20 Allow NULL? 
5CV_TYPEPrice/NPV Type for OTC Transactionsnvarchar30 Allow NULL? 
6RATE_CATEGORYExchange Rate Typenvarchar40 Allow NULL? 
7RULE_UPWrite-Up Rulechar10 Allow NULL? 
8RULE_DOWNWrite-Down Rulechar10 Allow NULL? 
9FLG_COSTSWrite Off Costs Fullychar10 Allow NULL? 
10RESOLVE_TIIndicator: Clear Gains/Losseschar10 Allow NULL? 
11RESOLVE_FEIndicator: Clear Gains/Losseschar10 Allow NULL? 
12GAIN_LOSS_HANDLHandling of Gains/Losseschar10 Allow NULL? 
13RESET_TITLE_VALFlag for reset of Title valuation during year end valuationchar10 Allow NULL? 
14COMPUTATION_CATCalculation Category for Amortizationnvarchar20 Allow NULL? 
15BRUTTO_NETTOIndicator Gross or Net Procedurechar10 Allow NULL? 
16RATE_CALC_METHODEffective Interest Method (Financial Mathematics)char10 Allow NULL? 
17PURCHASE_GAAPPurchase GAAP Indicatornvarchar30 Allow NULL? 
18DISSOLVEFlag: Reset is Possiblechar10 Allow NULL? 
19AMORT_ENDAmortization to Final Due Date / Terminationtinyint30
20RATE_CAT_SPOTPRate Type for Spot - Purchase Currency/Valuation Currencynvarchar40 Allow NULL? 
21RATE_CAT_SPOTSRate Type for Spot - Selling Currency/Valuation Currencynvarchar40 Allow NULL? 
22RATE_CAT_SWAPPRate Type for Spot - Purchase Currency/Valuation Currencynvarchar40 Allow NULL? 
23RATE_CAT_SWAPSRate Type for Swap - Selling Currency/Valuation Currencynvarchar40 Allow NULL? 
24FORWARD_CATRate Valuation Category Forwardchar10 Allow NULL? 
25CROSS_VALIndicator: Cross Valuation for Forward Exchange Transactionchar10 Allow NULL? 
26ACCRUE_COMPAdditional Components Managednvarchar20 Allow NULL? 
27SP_VAL_SECIndicator: Enable Special Write-Up/Write-Down for Securitieschar10 Allow NULL? 
28NPV_CATEGORYNPV Categorychar10 Allow NULL? 
29INCL_INTERESTInclusion of Interest in Amortization Calculationchar10 Allow NULL? 
30EFF_INT_SACTreatment of Effect. Interest Rate for Amort. Acc. to SACchar10 Allow NULL? 
31SULTVONMonth-End Indicator for Start of a Calculation Periodchar10 Allow NULL? 
32SULTBISMonth-End Indicator for the End of a Calculation Periodchar10 Allow NULL? 
33AMORT_CUTCut SAC Amortizationchar10 Allow NULL? 
34ALLOW_CALC_AMORTAllow Calculation of Derived Business Transactionschar10 Allow NULL? 
35VAD_AMORTAmortization of Value Adjustment Componentschar10 Allow NULL? 
36COMP_VALSelect Component for Valuationchar10 Allow NULL? 
37POSTING_SPEC_VALPosting Specifications Selectionchar10 Allow NULL? 
38FX_NETTING_DEALIndicator: Offsetting Transaction for Forward Exchange Transchar10 Allow NULL? 
39CV_TYPE_STARTPrice/NPV Type for OTC Transactionsnvarchar30 Allow NULL? 
40INTEREST_RISKInterest Rate Risk Yes/Nochar10 Allow NULL? 
41CREDIT_RISKCredit Risk Yes/Nochar10 Allow NULL? 
42FXRATE_RISKFx Risk Yes/Nochar10 Allow NULL? 
43PRICE_RISKPrice Risk Yes/Nochar10 Allow NULL? 
44EVAL_TYPID of Risk Management Evaluationnvarchar40 Allow NULL? 
45CONV_RATE_AMORTAmortization Rate Conversion Categorytinyint30
46FLG_DIRTY_PRICEUse Dirty Price (Market Price + Interest Accrual)char10 Allow NULL? 
47ACCRUAL_INCLIndicator for Including Key Datechar10 Allow NULL? 
48ACCRUAL_ULTIMOMonth-End Indicator for Key Datechar10 Allow NULL? 
49FLG_CLR_VAL_CURRClear Amount in Valuation Currency if Valuation is Resolvedchar10 Allow NULL? 
50FLG_AMORT_END_EXExclude Final Amortization Date from Amortization Periodchar10 Allow NULL? 
51FLG_EXCL_TBExclude Interest-Like Flows from Calculationchar10 Allow NULL? 
52CUSTOM_ATTRIBCustom Setting for Valuation Stepnvarchar40 Allow NULL? 
53ACCRUAL_FUNCTIONAccrual/Deferral Methodnvarchar30 Allow NULL? 
54FLG_HREL_LIMITEDExecute Solely in the Case of Hedge Accountingchar10 Allow NULL? 
55FLG_ADJ_TRANSL4AAdjustment of Translation Flows for Amortizationchar10 Allow NULL? 
56AFFECT_DERIV_COMPAffect Derive Componentschar10 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