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  | CPED_TERMGRPOUT
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
Cross-Application Components :: General Application Functions :: Commodity Pricing Engine
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CPED_TERMGRPOUT471CPE Term - Changed Grouping and General Term ResultCommodity Pricing Engine
SQL:  selectupdate insert create

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

SELECT CLIENT, FORMINPUT_GUID, TERMNO, TERMID, TERMINPUT_GUID, TERMCONVIN_GUID, TERMROUNDIN_GUID, TERMGROUP, PROVIS, PROVTERMNO, FACTOR1, FACTOR2, PERCENTAGE, TERMCOMMQUAN, TERMCOMMUOM, USEDQUAN, USEDUOM, TERMCONVOUT_GUID, PERDTOUT_GUID_Q, PERDTOUT_GUID_C, TERMSTATUS, BILLING_BLOCK, TERMVAL, TERMRATE, TERMCURR, TERMPRUN, TERMUOM, FORECAST_STATUS, FORECAST_DATETIME, CURVE_DATE, QUOTATION, QUOTCURR, QUOTPRUN, QUOTUOM, CALC_LIMITUSED, QUOT_UOMSUBST, SURCHARGERATE, SURCHRATECURR, SURCHRATEPRUN, SURCHRATEUOM, SURCH_UOMSUBST, EXTENSION_GROUP, EXTENSION_USAGE, FORMRES_REL, DCS_TYPE, KEYDATE, ZSECURITY_NUMBER FROM CPED_TERMGRPOUT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2FORMINPUT_GUIDCPE Formula - GUID of Changed Input for General Datavarbinary160RAWNoCPET_FORMINPUT_GUID
3TERMNOCPE Term - Number in Formulanvarchar50NUMC(N'00000')NoCPET_TERMNO Allow NULL? 
4TERMIDCPE Term - Keynvarchar100CHAR(N' ')YesCPET_TERMID Allow NULL? 
5TERMINPUT_GUIDCPE Term - GUID of Changed General Inputvarbinary160RAWYesCPED_TERMINPUTCPET_TERMINPUT_GUID
6TERMCONVIN_GUIDCPE Term - GUID for Conversion Inputvarbinary160RAWYesCPED_TERMCONVINCPET_TERMCONVIN_GUID
7TERMROUNDIN_GUIDCPE Term - GUID of Rounding Inputvarbinary160RAWYesCPED_TERMROUNDINCPET_TERMROUNDIN_GUID
8TERMGROUPCPE Term - Term Groupchar10CHAR(N' ')YesCPET_TERMGROUP Allow NULL? 
9PROVISCPE Term - Term Is Used only for Provisional Pricingchar10CHAR(N' ')YesCPET_PROVIS Allow NULL? 
10PROVTERMNOCPE Term - Number of the Corresponding Provisional Termnvarchar50NUMC(N'00000')YesCPET_PROVTERMNO Allow NULL? 
11FACTOR1CPE Term - Factor 1decimal106DEC((0))YesCPET_FACTOR1
12FACTOR2CPE Term - Factor 2decimal106DEC((0))YesCPET_FACTOR2
13PERCENTAGECPE Term - Percentagedecimal106DEC((0))YesCPET_PERCENTAGE
14TERMCOMMQUANCPE Term - Total Commodity Quantity for Calculating Termdecimal153QUAN((0))YesCPET_TERMCOMMQUAN
15TERMCOMMUOMCPE Term - Unit of Measure of Total Commodity Quantitynvarchar30UNIT(N' ')YesT006CPET_TERMCOMMUOM Allow NULL? 
16USEDQUANCPE Term - Calculated Commodity Quantitydecimal153QUAN((0))YesCPET_USEDQUAN
17USEDUOMCPE Term - UoM for Calculated Commodity Quantitynvarchar30UNIT(N' ')YesT006CPET_USEDUOM Allow NULL? 
18TERMCONVOUT_GUIDCPE Term - GUID for Conversion Resultvarbinary160RAWYesCPED_TERMCONVOUTCPET_TERMCONVOUT_GUID
19PERDTOUT_GUID_QCPE Term - GUID for Result of Period Determinationvarbinary160RAWYesCPED_PERIODDTOUTCPET_PERIODDTOUT_GUID
20PERDTOUT_GUID_CCPE Term - GUID for Result of Period Determinationvarbinary160RAWYesCPED_PERIODDTOUTCPET_PERIODDTOUT_GUID
21TERMSTATUSCPE Term - Statusnvarchar20NUMC(N'00')YesCPEC_TERMSTATUSCPET_TERMSTATUS Allow NULL? 
22BILLING_BLOCKCPE Caller - Billing: Blocking Reason for Document Itemsnvarchar20CHAR(N' ')YesCPEC_BLOCKINGCPET_BILLING_BLOCK Allow NULL? 
23TERMVALCPE Term - Valuedecimal152CURR((0))YesCPET_TERMVAL
24TERMRATECPE Term - Rate in Term Currencydecimal152CURR((0))YesCPET_TERMRATE
25TERMCURRCPE Term - Currencynvarchar50CUKY(N' ')YesTCURCCPET_TERMCURR Allow NULL? 
26TERMPRUNCPE Term - Price Unitdecimal50DEC((0))YesCPET_TERMPRUN
27TERMUOMCPE Term - Unit of Measurenvarchar30UNIT(N' ')YesT006CPET_TERMUOM Allow NULL? 
28FORECAST_STATUSStatus of Quotation or Exchange Rate Forecasttinyint30INT1((0))YesCPET_FORECAST_STATUS
29FORECAST_DATETIMEEvaluation Key Date Usednvarchar140CHAR(N' ')YesCPET_USED_EVAL_KEYDATE Allow NULL? 
30CURVE_DATECurve Datenvarchar80DATS(N'00000000')YesTBA_CURVEDATE Allow NULL? 
31QUOTATIONCPE Term - Calculated Quotationdecimal152CURR((0))YesCPET_QUOTATION
32QUOTCURRQuotation Currencynvarchar50CUKY(N' ')YesTCURCCPET_QUOTCURR Allow NULL? 
33QUOTPRUNPrice Unit of Quotationdecimal50DEC((0))YesCPET_QUOTPRUN
34QUOTUOMUnit of Measure of Quotationnvarchar30UNIT(N' ')YesT006CPET_QUOTUOM Allow NULL? 
35CALC_LIMITUSEDCPE Term - Used Limit of Calculation Rulechar10NUMC(N'0')YesCPET_LIMITUSED Allow NULL? 
36QUOT_UOMSUBSTCPE Term - Unit of Measure Substitution for Quotationschar10CHAR(N' ')YesCPET_UOMSUB_QUOT Allow NULL? 
37SURCHARGERATECPE Term - Total Surcharge for Commoditydecimal152CURR((0))YesCPET_SURCHARGERATE
38SURCHRATECURRCPE Term - Currency of Absolute Surchargenvarchar50CUKY(N' ')YesTCURCCPET_SURCHRATECURR Allow NULL? 
39SURCHRATEPRUNCPE Term - Price Unit of Absolute Surchargedecimal50DEC((0))YesCPET_SURCHRATEPRUN
40SURCHRATEUOMCPE Term - Unit of Measure of Absolute Surchargenvarchar30UNIT(N' ')YesT006CPET_SURCHRATEUOM Allow NULL? 
41SURCH_UOMSUBSTCPE Term - Unit of Measure Substitution for Surchargechar10CHAR(N' ')YesCPET_UOMSUB_SUR Allow NULL? 
42EXTENSION_GROUPCPE Extension Groupnvarchar50NUMC(N'00000')YesCPET_EXTENSION_GROUP Allow NULL? 
43EXTENSION_USAGECPE Extension Usagechar10CHAR(N' ')YesCPET_EXTENSION_USAGE Allow NULL? 
44FORMRES_RELRelevance for Formula Resultchar10CHAR(N' ')YesCPET_FORMRES_REL Allow NULL? 
45DCS_TYPEDerivative Categorynvarchar30NUMC(N'000')YesTBA_DERIVATIVETYPE Allow NULL? 
46KEYDATEMaturity Key Datenvarchar80DATS(N'00000000')YesTBA_KEYDATE Allow NULL? 
47ZSECURITY_NUMBERSecurity ID Numbernvarchar130CHAR(N' ')Yes*VVRANLW Allow NULL? 
NamePrimaryUniqueTypeColumns
CPED_TERMGRPOUT~0YesYesCLUSTEREDTERMNO, FORMINPUT_GUID, CLIENT

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