P_PriceFixationLotDetails

Price Fixation Lot Data | view: PPRCFIXLOTDET | TRAN | Extraction: Not supported | Component: SAP Agricultural Contract Management

Tables used: /ACCGO/T_CAKITM, WBHK, /ACCGO/T_PR_ASP, CPED_FORMDOC, CPED_KNUMVTOGUID, WBHI, WBHD, CPED_TERMGRPOUT, CPED_TERMINPUT, WBHD, CPED_TERMCONVIN, /ACCGO/T_CONDTYP, TBAC_DCST, TBAC_MICT, /ACCGO/T_CPE_BRI, /ACCGO/T_CONDMAP, TBAC_DCS_LOF

🔑 Keys
💰 Amounts
∑ Quantities (3)
📅 Dates (1)
☰ Categorical
Other (27)
🔗 Relations (6)

Column Name	Description

Column Name	Description

Column Name	Description
📏 Priced Quantity Unit of Measurment (FutureFetchPriceUnit):
FutureFetchPriceQty	Priced Quantity
termcommquan	CPE Term - Total Commodity Quantity for Calculating Term
📏 Priced Quantity Unit of Measurment (BasisFetchPriceUnit):
BasisFetchPriceQty	Priced Quantity

Column Name	Description
KEYDATE	Maturity Key Date

Column Name	Description

Column Name	Description	Domain name
SourceLotId	Source Lot ID	/ACCGO/D_PRICINGLOT_ID
termno	CPE Term - Number in Formula	NUMC5
TradingContractNumber	Trading Contract	TKONN
TradingContractItem	Item Number of Trading Contract	TPOSN
AccgoPriceFixationStatus	Price Fixation Status	/ACCGO/D_PRCFIX_STAT
FutCondType	CPE: Condition Type for Commodity Pricing	KSCHL
FutureFx	CPE Term - Fixed Exchange Rate for Currency Conversion	CPE_CONVFACTOR
futureprice	CPE Term - Fixed Rate (up to 14 decimals)	CPE_INTERNAL_VALUE
total_price_doc_curr	Total Amount	/ACCGO/CPE_D_TOTAL_PRICE
PrcgConditionTermFixedRateQty	CPE - Price Unit of Fixed Rate	CPE_PRUN
FutureFetchPrice	Fetched Price	CPE_INTERNAL_VALUE
FutureReasonCode	Reason Code	/ACCGO/D_PROR_RC
PSMGUID	PSM GUID	SYSUUID_22
CommodityProductSymbol	Derivative Contract Specification: Product Symbol	TBA_DCS_SYMBL
CmmdtyMaturityMonthYear	null
DerivativeContractMaturityCode	null
BasisCondType	CPE: Condition Type for Commodity Pricing	KSCHL
BasisFx	CPE Term - Fixed Exchange Rate for Currency Conversion	CPE_CONVFACTOR
basisprice	CPE Term - Fixed Rate (up to 14 decimals)	CPE_INTERNAL_VALUE
PriceUnitBasisFixedRate	CPE - Price Unit of Fixed Rate	CPE_PRUN
BasisFetchPrice	Fetched Price	CPE_INTERNAL_VALUE
BasisReasonCode	Reason Code	/ACCGO/D_PROR_RC
NonHCondType	CPE: Condition Type for Commodity Pricing	KSCHL
NonHedgeableBasisFx	CPE Term - Fixed Exchange Rate for Currency Conversion	CPE_CONVFACTOR
NonHedgeablePrice	CPE Term - Fixed Rate (up to 14 decimals)	CPE_INTERNAL_VALUE
NonHedgeablePriceUnit	CPE - Price Unit of Fixed Rate	CPE_PRUN
TotalPriceNF	Total Amount	/ACCGO/CPE_D_TOTAL_PRICE

Master Data Relations	Join Conditions
Foreign key for UoM of fix term rate Client CPE - Unit of Measure of Fixed Rate CPE - Unit of Measure of Fixed Rate CPE - Unit of Measure of Fixed Rate	`P_PRICEFIXATIONLOTDETAILS.MANDT == T006.MANDT` `P_PRICEFIXATIONLOTDETAILS.FIXEDRATEBASISUNITOFMEASURE == T006.MSEHI` `P_PRICEFIXATIONLOTDETAILS.FIXEDRATEFUTUREUNITOFMEASURE == T006.MSEHI` `P_PRICEFIXATIONLOTDETAILS.NONHEDGEABLEUNITOFMEASURE == T006.MSEHI`
Foreign key for UoM of fix term rate Client CPE - Unit of Measure of Fixed Rate CPE - Unit of Measure of Fixed Rate CPE - Unit of Measure of Fixed Rate	`P_PRICEFIXATIONLOTDETAILS.MANDT == T006.MANDT` `P_PRICEFIXATIONLOTDETAILS.FIXEDRATEBASISUNITOFMEASURE == T006.MSEHI` `P_PRICEFIXATIONLOTDETAILS.FIXEDRATEFUTUREUNITOFMEASURE == T006.MSEHI` `P_PRICEFIXATIONLOTDETAILS.NONHEDGEABLEUNITOFMEASURE == T006.MSEHI`
Foreign key for currency of fix term rate Client CPE - Currency for Fixed Rate CPE - Currency for Fixed Rate CPE - Currency for Fixed Rate	`P_PRICEFIXATIONLOTDETAILS.MANDT == TCURC.MANDT` `P_PRICEFIXATIONLOTDETAILS.NONHEDGEABLETERMCURRENCY == TCURC.WAERS` `P_PRICEFIXATIONLOTDETAILS.PRCGCNDNBASISTERMCURRENCY == TCURC.WAERS` `P_PRICEFIXATIONLOTDETAILS.PRCGCNDNFUTURETERMCURRENY == TCURC.WAERS`
Foreign key for UoM of fix term rate Client CPE - Unit of Measure of Fixed Rate CPE - Unit of Measure of Fixed Rate CPE - Unit of Measure of Fixed Rate	`P_PRICEFIXATIONLOTDETAILS.MANDT == T006.MANDT` `P_PRICEFIXATIONLOTDETAILS.FIXEDRATEBASISUNITOFMEASURE == T006.MSEHI` `P_PRICEFIXATIONLOTDETAILS.FIXEDRATEFUTUREUNITOFMEASURE == T006.MSEHI` `P_PRICEFIXATIONLOTDETAILS.NONHEDGEABLEUNITOFMEASURE == T006.MSEHI`
Foreign key for currency of fix term rate Client CPE - Currency for Fixed Rate CPE - Currency for Fixed Rate CPE - Currency for Fixed Rate	`P_PRICEFIXATIONLOTDETAILS.MANDT == TCURC.MANDT` `P_PRICEFIXATIONLOTDETAILS.NONHEDGEABLETERMCURRENCY == TCURC.WAERS` `P_PRICEFIXATIONLOTDETAILS.PRCGCNDNBASISTERMCURRENCY == TCURC.WAERS` `P_PRICEFIXATIONLOTDETAILS.PRCGCNDNFUTURETERMCURRENY == TCURC.WAERS`
Foreign key for currency of fix term rate Client CPE - Currency for Fixed Rate CPE - Currency for Fixed Rate CPE - Currency for Fixed Rate	`P_PRICEFIXATIONLOTDETAILS.MANDT == TCURC.MANDT` `P_PRICEFIXATIONLOTDETAILS.NONHEDGEABLETERMCURRENCY == TCURC.WAERS` `P_PRICEFIXATIONLOTDETAILS.PRCGCNDNBASISTERMCURRENCY == TCURC.WAERS` `P_PRICEFIXATIONLOTDETAILS.PRCGCNDNFUTURETERMCURRENY == TCURC.WAERS`