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_FORMDOC
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_FORMDOC331CPE Formula - Grouping and General ResultCommodity Pricing Engine
SQL:  selectupdate insert create

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

SELECT CLIENT, DOCITEM_GUID, COND_TYPE, FORMID, FORMINPUT_GUID, FORMCONVIN_GUID, FORMROUNDIN_GUID, FORMCONVOUT_GUID, FORMSTATUS, BILLING_BLOCK, EVALTIMESTAMP, FORMVAL, FORMRATE, FORMCURR, FORMPRUN, FORMUOM, FORMCOMMQUAN, FORMCOMMUOM, QUANCNV_COMM, QUANCNV_ITEM, CONTRACTGUID, ORIG_GUID, LOGSYS, SRCSYSTEMTYPE, FORMVAL_DOCCURR, DOCCURR, EVAL_TIMESTAMP, ITEMPRODUOM, REQUESTED_EVAL_KEYDATE, LATEST_EVAL_KEYDATE, USED_EVAL_KEYDATE, FORECAST_REQUESTED, FORECAST_STATUS FROM CPED_FORMDOC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DOCITEM_GUIDCPE Caller - GUID of Document Itemvarbinary160RAWNoCPET_DOCITEM_GUID
3COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40CHAR(N' ')No*CPET_COND_TYPE Allow NULL? 
4FORMIDCPE Formula - Keynvarchar100CHAR(N' ')YesCPEC_FORMULACPET_FORMID Allow NULL? 
5FORMINPUT_GUIDCPE Formula - GUID of Changed Input for General Datavarbinary160RAWYesCPED_FORMINPUTCPET_FORMINPUT_GUID
6FORMCONVIN_GUIDCPE Formula - GUID of Input for Conversionvarbinary160RAWYesCPED_FORMCONVINCPET_FORMCONVIN_GUID
7FORMROUNDIN_GUIDCPE Formula - GUID for Rounding Inputvarbinary160RAWYesCPED_FORMROUNDINCPET_FORMROUNDIN_GUID
8FORMCONVOUT_GUIDCPE Formula - GUID of Conversion Resultvarbinary160RAWYesCPED_FORMCONVOUTCPET_FORMCONVOUT_GUID
9FORMSTATUSCPE Formula - Status of Evaluationnvarchar20NUMC(N'00')YesCPEC_FORMSTATUSCPET_FORMSTATUS Allow NULL? 
10BILLING_BLOCKCPE Caller - Billing: Blocking Reason for Document Itemsnvarchar20CHAR(N' ')YesCPEC_BLOCKINGCPET_BILLING_BLOCK Allow NULL? 
11EVALTIMESTAMPNot used anymore !!! CPE Formula - Evaluation Date and Timenvarchar80DATS(N'00000000')YesCPET_EVALTIMESTAMP Allow NULL? 
12FORMVALCPE Formula -Value in Formula Currencydecimal152CURR((0))YesCPET_FORMVAL
13FORMRATECPE Formula - Rate in Formula Currencydecimal152CURR((0))YesCPET_FORMRATE
14FORMCURRCPE Formula - Currencynvarchar50CUKY(N' ')YesTCURCCPET_FORMCURR Allow NULL? 
15FORMPRUNCPE Formula - Price Unitdecimal50DEC((0))YesCPET_FORMPRUN
16FORMUOMCPE Formula - Unit of Measurenvarchar30UNIT(N' ')YesT006CPET_FORMUOM Allow NULL? 
17FORMCOMMQUANCPE Formula - Total Quantity of Commodity in Document Itemdecimal153QUAN((0))YesCPET_FORMCOMMQUAN
18FORMCOMMUOMCPE Formula - Unit of Measure of Commodity Used in Formulanvarchar30UNIT(N' ')YesT006CPET_FORMCOMMUOM Allow NULL? 
19QUANCNV_COMMCPE - Comm. Qty for Conversion from Product UoM to Comm. UoMdecimal153QUAN((0))YesCPET_QUANCNV_COMM
20QUANCNV_ITEMCPE - Item Qty for Conversion from Product UoM to Comm. UoMdecimal153QUAN((0))YesCPET_QUANCNV_ITEM
21CONTRACTGUIDCPE Formula - GUID of Contract Item Related to Document Itemvarbinary160RAWYesCPET_CONTRACT_GUID
22ORIG_GUIDCPE Caller - GUID of Original Item of the Document Itemvarbinary160RAWYesCPET_ORIG_GUID
23LOGSYSCPE Formula - Original Logical Systemnvarchar100CHAR(N' ')Yes*CPET_FORMLOGSYS Allow NULL? 
24SRCSYSTEMTYPECPE - Source System Typenvarchar40CHAR(N' ')YesCPET_SRCSYSTEMTYPE Allow NULL? 
25FORMVAL_DOCCURRCPE Formula - Value in Document Currencydecimal152CURR((0))YesCPET_FORMVAL_DOCCURR
26DOCCURRCPE Caller - Document Currencynvarchar50CUKY(N' ')Yes*CPET_DOCCURR Allow NULL? 
27EVAL_TIMESTAMPCPE Formula - Evaluation Date and Timenvarchar140CHAR(N' ')YesCPET_EVAL_TIMESTAMP Allow NULL? 
28ITEMPRODUOMCPE Caller - Unit of Measure of Product in Document Itemnvarchar30UNIT(N' ')Yes*CPET_ITEMPRODUOM Allow NULL? 
29REQUESTED_EVAL_KEYDATERequested Evaluation Key Datenvarchar140CHAR(N' ')YesCPET_REQUESTED_EVAL_KEYDATE Allow NULL? 
30LATEST_EVAL_KEYDATELatest Evaluation Key Datenvarchar140CHAR(N' ')YesCPET_LATEST_EVAL_KEYDATE Allow NULL? 
31USED_EVAL_KEYDATEEvaluation Key Date Usednvarchar140CHAR(N' ')YesCPET_USED_EVAL_KEYDATE Allow NULL? 
32FORECAST_REQUESTEDForecast Proposedchar10CHAR(N' ')YesCPET_FORECAST_REQUESTED Allow NULL? 
33FORECAST_STATUSStatus of Quotation or Exchange Rate Forecasttinyint30INT1((0))YesCPET_FORECAST_STATUS
NamePrimaryUniqueTypeColumns
CPED_FORMDOC~0YesYesCLUSTEREDCOND_TYPE, DOCITEM_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