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  | JBTKREG
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
Industry Specific :: Bank Components :: Profitability Analysis :: Single Transaction Costing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JBTKREG831Costing RuleSingle Transaction Costing
SQL:  selectupdate insert create

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

SELECT MANDT, RKALRG, SGSART, SKALRT, SAKPAS, SBILRL, SZSTRM, SDSVOL, SZINKO, SZINBE, SOPPBE, SOPPZS, NOZZTE, XOZZTE, NOZDSP, BSTRA, SRUECK, SSALBL, SEZDUR, SWATRA, SMINRK, SMBWPR, SBWVOL, SABRKA, SMARBW, SWTBBW, SKNVOL, SMKVOL, SOPVOL, SOPKOS, SKVBER, SGLDKR, SRKUGV, SSKUGV, SANLF, SERTRZ, SHKOBE, SDISAB, RKURSA, RKURST, RKURSG, RKURSB, SZKART, SZKAT1, SZKAT2, SLEIST, RUKRST, SOPPSU, BEINWE, SOPPKD, RVOLAG, RVOLAB, SFEVER, SEFFZS, SOPPBH, SOPPZH, NOZZTH, XOZZTH, NOZDSH, SPRPAY, SDURAT, SOPPER, AUSWT, SRKUGVB, SUXAL1, SUXAL2, SUXAL3, SUXAL4, RHANDPL, SNOMOZ, SKUGVS, SOPBAS, SSPRDS, SEGEPBW, SEGEPBE, ORIGIN, INTINV_ENABLED, INTINV_YILDCRVTP, INTINV_TRMNRUNTS, INTINV_TRMUNIT, INTINV_INTRPLT, INTINV_INCLINTCO, PERIOD_COMM_INTR FROM JBTKREG
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2RKALRGCosting Rulenvarchar80CHAR(N' ')NoJBRKALRG Allow NULL? 
3SGSARTType of Transaction (Costing-Based)nvarchar20CHAR(N' ')YesJBSGSART Allow NULL? 
4SKALRTCosting Rule Categorychar10CHAR(N' ')YesJBSKALRT Allow NULL? 
5SAKPASAsset/Liability Indicatorchar10CHAR(N' ')YesJBSAKPAS Allow NULL? 
6SBILRLBalance Sheet Relevancechar10CHAR(N' ')YesJBSBILRL Allow NULL? 
7SZSTRMCash Flow for Costing Rulechar10CHAR(N' ')YesJBSZSTRM Allow NULL? 
8SDSVOLAverage Volumenvarchar20CHAR(N' ')YesJBSDSVOL Allow NULL? 
9SZINKOSAP Banking: Net Interest Margin Contributionchar10CHAR(N' ')YesJBSZINKO Allow NULL? 
10SZINBEInterest Contributionchar10CHAR(N' ')YesJBSZINBE Allow NULL? 
11SOPPBEOpportunity Contributionchar10CHAR(N' ')YesJBSOPPBE Allow NULL? 
12SOPPZSOpportunity Interest Ratenvarchar20CHAR(N' ')YesJBSOPPZS Allow NULL? 
13NOZZTENumber of Time Units for Interest Ratesmallint50INT2((0))YesJBNOZZTE
14XOZZTETime Unit for Interest Ratechar10CHAR(N' ')YesJBXOZZTE Allow NULL? 
15NOZDSPNumber of Reporting Periods for Determining OI Averagesmallint50INT2((0))YesJBNOZDSP
16BSTRAValuation Strategy (SAP Banking / Profitability)nvarchar30CHAR(N' ')YesTKEVASJBBSTRAT Allow NULL? 
17SRUECKControl of Backdated Transactionschar10CHAR(N' ')YesJBSRUECK Allow NULL? 
18SSALBLBalance Formationchar10CHAR(N' ')YesJBSSALBL Allow NULL? 
19SEZDURAverage Customer Interest Ratechar10CHAR(N' ')YesJBSEZDUR Allow NULL? 
20SWATRACurrency Translation Contributionchar10CHAR(N' ')YesJBSWATRA Allow NULL? 
21SMINRKReserve Requirement Costschar10CHAR(N' ')YesJBSMINRK Allow NULL? 
22SMBWPRDistribution to Periodschar10CHAR(N' ')YesJBSMBWPR Allow NULL? 
23SBWVOLNPV of Average Effective Capitalchar10CHAR(N' ')YesJBSBWVOL Allow NULL? 
24SABRKASettlement calculationchar10CHAR(N' ')YesJBSABRKA Allow NULL? 
25SMARBWNPV Marginchar10CHAR(N' ')YesJBSMARBW Allow NULL? 
26SWTBBWNPV of Currency Translation Contributionchar10CHAR(N' ')YesJBSWTBBW Allow NULL? 
27SKNVOLContract Volumechar10CHAR(N' ')YesJBSKNVOL Allow NULL? 
28SMKVOLMarket Volumechar10CHAR(N' ')YesJBSMKVOL Allow NULL? 
29SOPVOLOpportunity Volumechar10CHAR(N' ')YesJBSOPVOL Allow NULL? 
30SOPKOSOpportunity Expense/Revenue in Own-Account Tradingchar10CHAR(N' ')YesJBSOPKOS Allow NULL? 
31SKVBERPurchases and Sales within the Periodchar10CHAR(N' ')YesJBSKVBER Allow NULL? 
32SGLDKRPosition Calculationchar10CHAR(N' ')YesJBSGLDKR Allow NULL? 
33SRKUGVRealized Price Gains and Losseschar10CHAR(N' ')YesJBSRKUGV Allow NULL? 
34SSKUGVUnrealised Price Gains and Losseschar10CHAR(N' ')YesJBSSKUGV Allow NULL? 
35SANLFProcedure Groupnvarchar30NUMC(N'000')YesJBSVERFG Allow NULL? 
36SERTRZOwn-account revenueschar10CHAR(N' ')YesJBSERTRZ Allow NULL? 
37SHKOBETrading Terms Contributionchar10CHAR(N' ')YesJBSHKOBE Allow NULL? 
38SDISABDiscount Accrual/Deferralchar10CHAR(N' ')YesJBSDISAB Allow NULL? 
39RKURSAExchange Rate Indicator for Market Valuationnvarchar20CHAR(N' ')YesTW56JBRKURSA Allow NULL? 
40RKURSTExchange Rate Type for Foreign Currency Valuationnvarchar40CHAR(N' ')YesTCURVJBRKURST Allow NULL? 
41RKURSGExchange Rate Type: Bidnvarchar40CHAR(N' ')YesTCURVJBRKURSG Allow NULL? 
42RKURSBExchange Rate Type: Asknvarchar40CHAR(N' ')YesTCURVJBRKURSB Allow NULL? 
43SZKARTYield Curve Typenvarchar40NUMC(N'0000')YesJBD14JBSZKART Allow NULL? 
44SZKAT1Yield Curve Type - Bidnvarchar40NUMC(N'0000')YesJBD14JBSZKATG Allow NULL? 
45SZKAT2Yield Curve Type - Asknvarchar40NUMC(N'0000')YesJBD14JBSZKATB Allow NULL? 
46SLEISTCash Flow Disturbancechar10CHAR(N' ')YesJBSLEIST Allow NULL? 
47RUKRSTExchange Rate Typenvarchar40CHAR(N' ')YesTCURVJBRUKRST Allow NULL? 
48SOPPSUInterpolation of Opportunity Interest Rateschar10CHAR(N' ')YesJBSOPPSU Allow NULL? 
49BEINWEPurchase Pricechar10CHAR(N' ')YesJBSEINWE Allow NULL? 
50SOPPKDYield Curve Validity Datechar10CHAR(N' ')YesJBSOPPKD Allow NULL? 
51RVOLAGVolatility Type: Bidnvarchar30CHAR(N' ')YesATVO1JBRVOLAG Allow NULL? 
52RVOLABVolatility Type: Asknvarchar30CHAR(N' ')YesATVO1JBRVOLAB Allow NULL? 
53SFEVERControl Indicator for Executing Fixed Procedureschar10CHAR(N' ')YesJBSFEVE Allow NULL? 
54SEFFZSControl Indicator for Calculating Effective Interest Ratechar10CHAR(N' ')YesJBSEFFZ Allow NULL? 
55SOPPBHOpportunity Contribution in Local Currencychar10CHAR(N' ')YesJBSOPPBH Allow NULL? 
56SOPPZHOpportunity Interest Rate in Local Currencynvarchar20CHAR(N' ')YesJBSOPPZH Allow NULL? 
57NOZZTHNumber of Time Units for Opportunity Interest Rate in LCsmallint50INT2((0))YesJBNOZZTH
58XOZZTHTime Unit for Opportunity Interest Rate in Local Currencychar10CHAR(N' ')YesJBXOZZTH Allow NULL? 
59NOZDSHNumber of Reporting Periods for OI LC Averagesmallint50INT2((0))YesJBNOZDSH
60SPRPAYControl Indicator for Calculating Prepaymentschar10CHAR(N' ')YesJBSPRPAY Allow NULL? 
61SDURATControl Indicator for Calculating Additional OIchar10CHAR(N' ')YesJBSDURAT Allow NULL? 
62SOPPERControl Indicator for Transfer of Opportunity Interest Ratechar10CHAR(N' ')YesJBSOPPER Allow NULL? 
63AUSWTRisk Management Evaluation Typenvarchar40CHAR(N' ')Yes*JBTKREVAL Allow NULL? 
64SRKUGVBRealized Price Gains/Losses (Position)char10CHAR(N' ')YesJBSRKUGVB Allow NULL? 
65SUXAL1Control Indicator for User Exit before Fixed Procedureschar10CHAR(N' ')YesJBSUXAL1 Allow NULL? 
66SUXAL2Control Indicator for User Exit after Fixed Procedureschar10CHAR(N' ')YesJBSUXAL2 Allow NULL? 
67SUXAL3Control Indicator for User Exit before Flexible Procedureschar10CHAR(N' ')YesJBSUXAL3 Allow NULL? 
68SUXAL4Control Indicator for User Exit after Flexible Procedureschar10CHAR(N' ')YesJBSUXAL4 Allow NULL? 
69RHANDPLExchangenvarchar100CHAR(N' ')YesTWH01VVRHANDPL Allow NULL? 
70SNOMOZGap Determination of Nominal OI Rate using STCchar10CHAR(N' ')YesJBSNOMOZ Allow NULL? 
71SKUGVSSplit Price Gains and Losseschar10CHAR(N' ')YesJBSKUGVS Allow NULL? 
72SOPBASBase Values for Opportunity Revenue / Expensechar10CHAR(N' ')YesJBSOPBAS Allow NULL? 
73SSPRDSControl Indicator for Markups and Markdowns on Opp. Interestchar10CHAR(N' ')YesJBSSPRDS Allow NULL? 
74SEGEPBWNPV Charges/Commissionchar10CHAR(N' ')YesJBSEGEPBW Allow NULL? 
75SEGEPBECharges/Commission Contribution (in Period)char10CHAR(N' ')YesJBSEGEPBE Allow NULL? 
76ORIGINOrigin of Transactionchar10CHAR(N' ')YesJBORIGIN Allow NULL? 
77INTINV_ENABLEDCalculate Int. Earnings from Interim Investmentchar10CHAR(N' ')YesJBT_DTE_INTINV_ENABLED Allow NULL? 
78INTINV_YILDCRVTPYield Curve Type for Interim Investmentnvarchar40NUMC(N'0000')Yes*JBT_DTE_INTINV_YIELD_CURV_TYPE Allow NULL? 
79INTINV_TRMNRUNTSTerm of Interim Investment - Number of Time Unitsint100INT4((0))YesJBT_DTE_INTINV_TERM_NR_UNITS Allow NULL? 
80INTINV_TRMUNITTime Unitchar10CHAR(N' ')YesTIMEUNIT Allow NULL? 
81INTINV_INTRPLTYield Curve Interpolation for Interim Investmentchar10CHAR(N' ')YesJBT_DTE_INTINV_IF_INTERPOLATE Allow NULL? 
82INTINV_INCLINTCOInclude Int. Earnings from Interim Inv. in Int. Contr. Cal.char10CHAR(N' ')YesJBT_DTE_INTINV_INCLDE_IN_INTCO Allow NULL? 
83PERIOD_COMM_INTRCommittment Interest (in Period)char10CHAR(N' ')YesJBT_DTE_PERIOD_COMMITMENT_INTR Allow NULL? 
NamePrimaryUniqueTypeColumns
JBTKREG~0YesYesCLUSTEREDRKALRG, 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