P_CmmdtyPrcgTrmInptGenData

CPE Term Changed Input for General Data | view: PTRMINPUTGEN1 | TRAN | Extraction: Not supported | Component: SAP Agricultural Contract Management

Tables used: CPED_TERMINPUT

🔑 Keys (1)
💰 Amounts (4)
∑ Quantities
📅 Dates (2)
☰ Categorical (7)
Other (42)
🔗 Relations (18)

Column Name	Description
TERMINPUT_GUID	CPE Term - GUID of Changed General Input

Column Name	Description
💲 CPE - Currency for Fixed Rate (FIXTERMCURR):
FIXTERMRATE	CPE Term - Fixed Rate
💲 CPE Term - Currency of Rate Calculation Limits (CALCMMCURR):
CALCMIN	CPE Term - Minimum of Commodity Rate Calculation
CALCMAX	CPE Term - Maximum of Commodity Rate Calculation
💲 CPE Term - Currency of Absolute Surcharge (SURCHARGECURR):
SURCHARGEABS	CPE Term - Absolute Surcharge for Commodity

Column Name	Description

Column Name	Description
KEYDATE	Maturity Key Date
EXPIRATIONDATE	Commodity Derivative Order Request Expiration Date

Column Name	Description
REFDOCCAT	CPE Term - Reference Document Category	Show values
QUOTKEY	Quotation Key Type in Document UI (all values)	Show values
DCS_SELECTION_TYPE	Maturity Selection Type	Show values
TIMING	Timing/Periodicity of Commodity Forward Indexes	Show values
DCS_PERIOD_TYPE	Period Type	Show values
PSM_SIMULATION_ERROR	General Flag	Show values
EXPRTNINSTRUCTION	Commodity Derivative Order Request Expiry Instruction	Show values

Column Name	Description	Domain name
REFDOC	CPE Term - Reference Document Number	CPE_DOCUMENT
REFITEM	CPE Term - Reference Document Item Number	CPE_DOCITEM
REFGUID	CPE Term - GUID of Reference Document Item	SYSUUID
REFCOND	CPE Term - Reference Condition Type	KSCHL
FIXTERMPRUN	CPE - Price Unit of Fixed Rate	CPE_PRUN
USERVAL1	CPE Term - Freely Usable Field	CPE_USERVAL1
PRICETYPE	Type of Price Quotation	VVSKURSART
CURVE_TYPE	Commodity Curve Type	TBA_CTY_CURVE_TYPE
KEYDATE_OFFSET_UNITS	CPE Term - Number of Time Units for Date Offset Routine	DEC3
BASIS_TYPE	Basis Type	TBAC_BASIS_TYPE
CALCMMPRUN	CPE Term - Price Unit of Rate Calculation Limits	CPE_PRUN
SURCHARGEABS_DF34	CPE Term - Absolute Surcharge for Commodity in DF34	CPE_INTERNAL_VALUE
SURCHARGEPRUN	CPE Term - Price Unit of Absolute Surcharge	CPE_PRUN
SURCHARGEFACTOR1	CPE Term - Factor 1 when Combining Surcharge and Quotation	CPE_FACTOR
SURCHARGEFACTOR2	CPE Term - Factor 2 when Combining Surcharge and Quotation	CPE_FACTOR
TERMTEXT	Description	TEXT40
CALCMIN_DF34	CPE Term - Minimum of Commodity Rate Calc (up to 14 dec)	CPE_INTERNAL_VALUE
CALCMAX_DF34	CPE Term - Maximum of Commodity Rate Calc (up to 14 dec)	CPE_INTERNAL_VALUE
FIXTERMRATE_DF34	CPE Term - Fixed Rate (up to 14 decimals)	CPE_INTERNAL_VALUE
RATE_CREATED_AT	CPE - Date and Time Created	CPE_TIMESTAMP
RATE_CREATED_BY	Name of User who Created the Object	USNAM
RATE_CHANGED_AT	CPE: Date and Time Changed	CPE_TIMESTAMP
RATE_CHANGED_BY	Name of user who changed the object	USNAM
PSMGUID	PSM GUID	SYSUUID_22
PSMETHOD	Price Setting Method	CPE_PSMETHOD
PSMSTATUS	Price Setting Method Status	CPE_PSMSTATUS
COMMODITYSUBACCOUNT	Commodity Subaccount ID	CMMFSA_SUBACCOUNTID
NUMBER_OF_LOTS	Number of Lots	CPET_NUMBER_OF_LOTS
FILLPACKETUUID	Commodity Derivative Order Fill Packet UUID	/BOBF/CONF_KEY
PRCGEXECINSTRN	Commodity Order Request Pricing and Execution Instruction	CMMFDOR_ORDERPRICINGEXECINST
LMTPRC	Commodity Derivative Order Request Limit Price	CPE_INTERNAL_VALUE
STOPPRICE	Commodity Derivative Order Request Stop Price	CPE_INTERNAL_VALUE
STOPLMTPRC	Commodity Derivative Order Request Stop Limit Price	CPE_INTERNAL_VALUE
FXDPRC	Commodity Derivative Order Request Requested Price	CPE_INTERNAL_VALUE
LEEWAYPRC	Commodity Derivative Order Request Requested Price	CPE_INTERNAL_VALUE
LEEWAYRNGEPRC	Commodity Derivative Order Request Leeway Price	CPE_INTERNAL_VALUE
LMTSPREADPRC	Commodity Derivative Order Request Limit Spread Value	CPE_INTERNAL_VALUE
FXDSPREADPRC	Commodity Derivative Order Request Requested Spread Price	CPE_INTERNAL_VALUE
TICKS	Commodity Order Request Ticks	CMMFDOR_ORDREQTICKS
CMMDTYORDREQCNTRPTYBROKER	Counterparty Broker	CMMFSA_COUNTERPARTY_BROKER
CMMDTYORDREQCNTRPTYREFACCT	Reference Account	CMMFSA_REFERENCEBROKERACCOUNT
SAVETERMRATE_DF34	CPE Term - Fixed Rate (up to 14 decimals)	CPE_INTERNAL_VALUE

Master Data Relations	Join Conditions
CPE Term - Currency of Rate Calculation Limits CPE Term - Currency of Rate Calculation Limits Client	`P_CMMDTYPRCGTRMINPTGENDATA.CALCMMCURR == TCURC.WAERS` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == TCURC.MANDT`
CPE Term - Unit of Measure for Rate Limits CPE Term - Unit of Measure for Rate Limits Client	`P_CMMDTYPRCGTRMINPTGENDATA.CALCMMUOM == T006.MSEHI` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == T006.MANDT`
CPE Term - Calculation Routine ? ? ? Client CPE Term - Calculation Routine	`P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == CPEC_ROUTINE.CLIENT` `P_CMMDTYPRCGTRMINPTGENDATA.CALCROUT == CPEC_ROUTINE.CPE_ROUTINE`
CPE Term - Calculation Rule ? ? Client CPE Term - Calculation Rule	`P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "LOGSYS"] == CPEC_CALCRULE.LOGSYS` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_VALIDFROM"] == CPEC_CALCRULE.VALIDTO` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == CPEC_CALCRULE.CLIENT` `P_CMMDTYPRCGTRMINPTGENDATA.CALCRULE == CPEC_CALCRULE.CALCRULE`
Foreign key for currency of fix term rate Client CPE - Currency for Fixed Rate	`P_CMMDTYPRCGTRMINPTGENDATA.MANDT == TCURC.MANDT` `P_CMMDTYPRCGTRMINPTGENDATA.FIXTERMCURR == TCURC.WAERS`
Foreign key for UoM of fix term rate Client CPE - Unit of Measure of Fixed Rate	`P_CMMDTYPRCGTRMINPTGENDATA.MANDT == T006.MANDT` `P_CMMDTYPRCGTRMINPTGENDATA.FIXTERMUOM == T006.MSEHI`
Latest Evaluation Key Date Routine Latest Evaluation Key Date Routine ? ? Client	`P_CMMDTYPRCGTRMINPTGENDATA.FORECAST_DATE_ROUTINE == CPEC_REFDATEROUT.REFDATEROUT` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "LOGSYS"] == CPEC_REFDATEROUT.LOGSYS` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_REF_DATE_APPLICATION"] == CPEC_REFDATEROUT.APPLICATION` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == CPEC_REFDATEROUT.CLIENT`
CPE Term - Period Determ. Rule for Currency Exchange Rates ? ? Client CPE Term - Period Determ. Rule for Currency Exchange Rates	`P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_VALIDFROM"] == CPEC_PERIODDET.VALIDTO` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "LOGSYS"] == CPEC_PERIODDET.LOGSYS` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == CPEC_PERIODDET.CLIENT` `P_CMMDTYPRCGTRMINPTGENDATA.PERDETRULE_C == CPEC_PERIODDET.PERIODDETRULE`
CPE Term - Period Determination Rule for Commodity Rates ? ? CPE Term - Period Determination Rule for Commodity Rates Client	`P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_VALIDFROM"] == CPEC_PERIODDET.VALIDTO` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "LOGSYS"] == CPEC_PERIODDET.LOGSYS` `P_CMMDTYPRCGTRMINPTGENDATA.PERDETRULE_Q == CPEC_PERIODDET.PERIODDETRULE` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == CPEC_PERIODDET.CLIENT`
CPE Term - Rule for Definition of Price Fixation Option ? ? Client CPE Term - Rule for Definition of Price Fixation Option	`P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "LOGSYS"] == CPEC_PRCFIXRULE.LOGSYS` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_VALIDFROM"] == CPEC_PRCFIXRULE.VALIDTO` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == CPEC_PRCFIXRULE.CLIENT` `P_CMMDTYPRCGTRMINPTGENDATA.PRICEFIXRULE == CPEC_PRCFIXRULE.PRICEFIXRULE`
Foreign key for currency of absolute surcharge CPE Term - Currency of Absolute Surcharge Client	`P_CMMDTYPRCGTRMINPTGENDATA.SURCHARGECURR == TCURC.WAERS` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == TCURC.MANDT`
CPE Term - Surcharge Routine ? ? ? Client CPE Term - Surcharge Routine	`P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == CPEC_ROUTINE.CLIENT` `P_CMMDTYPRCGTRMINPTGENDATA.SURCHARGEROUT == CPEC_ROUTINE.CPE_ROUTINE`
CPE Term - Surcharge Rule ? ? Client CPE Term - Surcharge Rule	`P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_VALIDFROM"] == CPEC_SURCHARGE.VALIDTO` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "LOGSYS"] == CPEC_SURCHARGE.LOGSYS` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == CPEC_SURCHARGE.CLIENT` `P_CMMDTYPRCGTRMINPTGENDATA.SURCHARGERULE == CPEC_SURCHARGE.SURCHARGERULE`
Foreign key for UoM of absolute surcharge Client CPE Term - Unit of Measure of Absolute Surcharge	`P_CMMDTYPRCGTRMINPTGENDATA.MANDT == T006.MANDT` `P_CMMDTYPRCGTRMINPTGENDATA.SURCHARGEUOM == T006.MSEHI`
CPE Term - Term Rule ? ? Client CPE Term - Term Rule	`P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "LOGSYS"] == CPEC_TERMRULE.LOGSYS` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_VALIDFROM"] == CPEC_TERMRULE.VALIDTO` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == CPEC_TERMRULE.CLIENT` `P_CMMDTYPRCGTRMINPTGENDATA.TERMRULE == CPEC_TERMRULE.TERMRULE`
CPE Term - Term Calculation Type ? ? ? Client CPE Term - Term Calculation Type	`P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "LOGSYS"] == CPEC_ROUTINE.LOGSYS` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_LOG_SUBMODULE"] == CPEC_ROUTINE.SUBMODULE` `P_CMMDTYPRCGTRMINPTGENDATA.[column in domain "CPET_MODULE"] == CPEC_ROUTINE.CPE_MODULE` `P_CMMDTYPRCGTRMINPTGENDATA.MANDT == CPEC_ROUTINE.CLIENT` `P_CMMDTYPRCGTRMINPTGENDATA.TERMTYPE == CPEC_ROUTINE.CPE_ROUTINE`