SAP Table CPED_FORMDOC
CPE Formula - Grouping and General Result
CPED_FORMDOC (CPE Formula - Grouping and General Result) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link CPED_FORMDOC to other SAP tables.
CPED_FORMDOC table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT | 3 | 0 | |||||||||||||||||||
| DOCITEM_GUID | CPE Caller - GUID of Document Item | CPET_DOCITEM_GUID | RAW | 16 | 0 | |||||||||||||||||||
| COND_TYPE | CPE: Condition Type for Commodity Pricing | CPET_COND_TYPE | CHAR | 4 | 0 | |||||||||||||||||||
| FORMID | CPE Formula - Key | CPET_FORMID | CPEC_FORMULA | CHAR | 10 | 0 | ||||||||||||||||||
| FORMINPUT_GUID | CPE Formula - GUID of Changed Input for General Data | CPET_FORMINPUT_GUID | CPED_FORMINPUT | RAW | 16 | 0 | ||||||||||||||||||
| FORMCONVIN_GUID | CPE Formula - GUID of Input for Conversion | CPET_FORMCONVIN_GUID | CPED_FORMCONVIN | RAW | 16 | 0 | ||||||||||||||||||
| FORMROUNDIN_GUID | CPE Formula - GUID for Rounding Input | CPET_FORMROUNDIN_GUID | CPED_FORMROUNDIN | RAW | 16 | 0 | ||||||||||||||||||
| FORMCONVOUT_GUID | CPE Formula - GUID of Conversion Result | CPET_FORMCONVOUT_GUID | CPED_FORMCONVOUT | RAW | 16 | 0 | ||||||||||||||||||
| FORMSTATUS | CPE Formula - Status of Evaluation | CPET_FORMSTATUS | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||
| BILLING_BLOCK | CPE Caller - Billing: Blocking Reason for Document Items | CPET_BILLING_BLOCK | CPEC_BLOCKING | CHAR | 2 | 0 | ||||||||||||||||||
| EVALTIMESTAMP | Not used anymore !!! CPE Formula - Evaluation Date and Time | CPET_EVALTIMESTAMP | DATS | 8 | 0 | |||||||||||||||||||
| FORMVAL | CPE Formula -Value in Formula Currency | CPET_FORMVAL | CURR | 15 | 2 | |||||||||||||||||||
| FORMRATE | CPE Formula - Rate in Formula Currency | CPET_FORMRATE | CURR | 15 | 2 | |||||||||||||||||||
| FORMCURR | CPE Formula - Currency | CPET_FORMCURR | TCURC | CUKY | 5 | 0 | ||||||||||||||||||
| FORMPRUN | CPE Formula - Price Unit | CPET_FORMPRUN | DEC | 5 | 0 | |||||||||||||||||||
| FORMUOM | CPE Formula - Unit of Measure | CPET_FORMUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||
| FORMCOMMQUAN | CPE Formula - Total Quantity of Commodity in Document Item | CPET_FORMCOMMQUAN | QUAN | 15 | 3 | |||||||||||||||||||
| FORMCOMMUOM | CPE Formula - Unit of Measure of Commodity Used in Formula | CPET_FORMCOMMUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||
| QUANCNV_COMM | CPE - Comm. Qty for Conversion from Product UoM to Comm. UoM | CPET_QUANCNV_COMM | QUAN | 15 | 3 | |||||||||||||||||||
| QUANCNV_ITEM | CPE - Item Qty for Conversion from Product UoM to Comm. UoM | CPET_QUANCNV_ITEM | QUAN | 15 | 3 | |||||||||||||||||||
| CONTRACTGUID | CPE Formula - GUID of Contract Item Related to Document Item | CPET_CONTRACT_GUID | RAW | 16 | 0 | |||||||||||||||||||
| ORIG_GUID | CPE Caller - GUID of Original Item of the Document Item | CPET_ORIG_GUID | RAW | 16 | 0 | |||||||||||||||||||
| LOGSYS | CPE Formula - Original Logical System | CPET_FORMLOGSYS | CHAR | 10 | 0 | |||||||||||||||||||
| SRCSYSTEMTYPE | CPE - Source System Type | CPET_SRCSYSTEMTYPE | CHAR | 4 | 0 | |||||||||||||||||||
| FORMVAL_DOCCURR | CPE Formula - Value in Document Currency | CPET_FORMVAL_DOCCURR | CURR | 15 | 2 | |||||||||||||||||||
| DOCCURR | CPE Caller - Document Currency | CPET_DOCCURR | CUKY | 5 | 0 | |||||||||||||||||||
| EVAL_TIMESTAMP | CPE Formula - Evaluation Date and Time | CPET_EVAL_TIMESTAMP | CHAR | 14 | 0 | |||||||||||||||||||
| ITEMPRODUOM | CPE Caller - Unit of Measure of Product in Document Item | CPET_ITEMPRODUOM | UNIT | 3 | 0 | |||||||||||||||||||
CPED_FORMDOC foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| CPED_FORMDOC | BILLING_BLOCK | SYST | MANDT | CPEC_BLOCKING | CPE Billing Block to be set for Document Items | CLIENT |
| CPED_FORMDOC | BILLING_BLOCK | CPED_FORMDOC | BILLING_BLOCK | CPEC_BLOCKING | CPE Billing Block to be set for Document Items | BILLING_BLOCK |
| CPED_FORMDOC | FORMCOMMUOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| CPED_FORMDOC | FORMCOMMUOM | CPED_FORMDOC | FORMCOMMUOM | T006 | Units of Measurement | MSEHI |
| CPED_FORMDOC | FORMCONVIN_GUID | * | CPED_FORMCONVIN | CPE Formula - Input for Conversion | CURRFROM | |
| CPED_FORMDOC | FORMCONVIN_GUID | SYST | MANDT | CPED_FORMCONVIN | CPE Formula - Input for Conversion | .INCLUDE |
| CPED_FORMDOC | FORMCONVIN_GUID | * | CPED_FORMCONVIN | CPE Formula - Input for Conversion | UOMFROM | |
| CPED_FORMDOC | FORMCONVIN_GUID | CPED_FORMDOC | FORMCONVIN_GUID | CPED_FORMCONVIN | CPE Formula - Input for Conversion | CLIENT |
| CPED_FORMDOC | FORMCONVIN_GUID | * | CPED_FORMCONVIN | CPE Formula - Input for Conversion | FORMCONVIN_GUID | |
| CPED_FORMDOC | FORMCONVIN_GUID | * | CPED_FORMCONVIN | CPE Formula - Input for Conversion | .INCLUDE | |
| CPED_FORMDOC | FORMCONVIN_GUID | * | CPED_FORMCONVIN | CPE Formula - Input for Conversion | CONVPLACE | |
| CPED_FORMDOC | FORMCONVOUT_GUID | SYST | MANDT | CPED_FORMCONVOUT | CPE Formula - Result of Conversion | .INCLUDE |
| CPED_FORMDOC | FORMCONVOUT_GUID | CPED_FORMDOC | FORMCONVOUT_GUID | CPED_FORMCONVOUT | CPE Formula - Result of Conversion | CLIENT |
| CPED_FORMDOC | FORMCONVOUT_GUID | * | CPED_FORMCONVOUT | CPE Formula - Result of Conversion | FORMCONVOUT_GUID | |
| CPED_FORMDOC | FORMCURR | CPED_FORMDOC | FORMCURR | TCURC | Currency Codes | WAERS |
| CPED_FORMDOC | FORMCURR | SYST | MANDT | TCURC | Currency Codes | MANDT |
| CPED_FORMDOC | FORMID | SYST | MANDT | CPEC_FORMULA | CPE Formula | CLIENT |
| CPED_FORMDOC | FORMID | ' ' | CPEC_FORMULA | CPE Formula | LOGSYS | |
| CPED_FORMDOC | FORMID | CPED_FORMDOC | FORMID | CPEC_FORMULA | CPE Formula | FORMID |
| CPED_FORMDOC | FORMID | * | CPEC_FORMULA | CPE Formula | COND_TYPE | |
| CPED_FORMDOC | FORMID | * | CPEC_FORMULA | CPE Formula | VALIDTO | |
| CPED_FORMDOC | FORMINPUT_GUID | CPED_FORMDOC | FORMINPUT_GUID | CPED_FORMINPUT | CPE Formula - Changed Input for General Data | CLIENT |
| CPED_FORMDOC | FORMINPUT_GUID | SYST | MANDT | CPED_FORMINPUT | CPE Formula - Changed Input for General Data | .INCLUDE |
| CPED_FORMDOC | FORMROUNDIN_GUID | SYST | MANDT | CPED_FORMROUNDIN | CPE Formula - Input for Rounding | .INCLUDE |
| CPED_FORMDOC | FORMROUNDIN_GUID | CPED_FORMDOC | FORMROUNDIN_GUID | CPED_FORMROUNDIN | CPE Formula - Input for Rounding | CLIENT |
| CPED_FORMDOC | FORMROUNDIN_GUID | * | CPED_FORMROUNDIN | CPE Formula - Input for Rounding | FORMROUNDIN_GUID | |
| CPED_FORMDOC | FORMROUNDIN_GUID | * | CPED_FORMROUNDIN | CPE Formula - Input for Rounding | CONVPLACE | |
| CPED_FORMDOC | FORMUOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| CPED_FORMDOC | FORMUOM | CPED_FORMDOC | FORMUOM | T006 | Units of Measurement | MSEHI |
