C_TrdgContractOptionItemDet

Consumption Query for Trading Contract Optionality Details | view: CTRDGCONTOPTITM | TRAN | Extraction: Not supported | Component: Commodity Contracts, Expenses, Basic Functions
Tables used: WBHK, /ACCGO/T_CAKOPTN, WBHD, /ACCGO/T_CRPSSNT, T006A, /ACCGO/T_OPCATGT
Column Name Description
TradingContractNumber Trading Contract
TradingContractItem Item Number of Trading Contract
ACMContractOptionsID Optionality Category ID
ACMContractOptionsValueType Value Type
ACMContractOptionsSequenceNmbr Sequence No.
Column Name Description
💲 Premium/Discount Currency (ACMContractOptionsPremDiscCrcy):
ACMContractOptionsPremDiscAmt Premium/Discount Value
Column Name Description
Column Name Description
Column Name Description
ACMTradingContractOptionsType Optionality Type Show values
Column Name Description Domain name
ACMContractOptionsValue Optionality Value
ACMContractOptionsPremDiscType Premium/Discount Type
DurationUnitName Unit of Measurement Text (Maximum 10 Characters) TEXT10
ACMContractOptionsPremDiscQty Condition pricing unit
ACMIsDefaultContractOptions Default Indicator
ACMContractOptionsCategoryName Optionality Category Description TEXT40
Master Data Relations Join Conditions
Crop Season ID
  • Crop Season ID
  • Client
Source Location
  • Source Location
  • Client
  • C_TRDGCONTRACTOPTIONITEMDET.ACMCONTROPTIONSSOURCELOCATION == BUT000.PARTNER
  • C_TRDGCONTRACTOPTIONITEMDET.MANDT == BUT000.CLIENT
Check Distribution Channel
  • Client
  • Sales Organization
  • Distribution Channel
  • C_TRDGCONTRACTOPTIONITEMDET.MANDT == TVKOV.MANDT
  • C_TRDGCONTRACTOPTIONITEMDET.SALESORGANIZATION == TVKOV.VKORG
  • C_TRDGCONTRACTOPTIONITEMDET.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Check Division
  • Division
  • Client
  • Sales Organization
  • Distribution Channel
  • C_TRDGCONTRACTOPTIONITEMDET.DIVISION == TVTA.SPART
  • C_TRDGCONTRACTOPTIONITEMDET.MANDT == TVTA.MANDT
  • C_TRDGCONTRACTOPTIONITEMDET.SALESORGANIZATION == TVTA.VKORG
  • C_TRDGCONTRACTOPTIONITEMDET.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Mode of Transport. Nomination Line Item
  • Mode of Transport. Nomination Line Item
  • Client
  • C_TRDGCONTRACTOPTIONITEMDET.MODEOFTRANSPORT == TVTR.VKTRA
  • C_TRDGCONTRACTOPTIONITEMDET.MANDT == TVTR.MANDT
Check Purchasing Group
  • Client
  • Purchasing Group
  • C_TRDGCONTRACTOPTIONITEMDET.MANDT == T024.MANDT
  • C_TRDGCONTRACTOPTIONITEMDET.PURCHASINGGROUP == T024.EKGRP
Check Purchasing Organization
  • Client
  • Purchasing organization
  • C_TRDGCONTRACTOPTIONITEMDET.MANDT == T024E.MANDT
  • C_TRDGCONTRACTOPTIONITEMDET.PURCHASINGORGANIZATION == T024E.EKORG
Check Sales Organization
  • Client
  • Sales Organization
  • C_TRDGCONTRACTOPTIONITEMDET.MANDT == TVKO.MANDT
  • C_TRDGCONTRACTOPTIONITEMDET.SALESORGANIZATION == TVKO.VKORG
Check Trading Contract Type
  • Trading Contract Type
  • Client
  • C_TRDGCONTRACTOPTIONITEMDET.TRADINGCONTRACTTYPE == TB2BE.TCTYP
  • C_TRDGCONTRACTOPTIONITEMDET.MANDT == TB2BE.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Means of Transport ID
  • Mode of Transport. Nomination Line Item
  • Client
  • Means of Transport ID
  • C_TRDGCONTRACTOPTIONITEMDET.MODEOFTRANSPORT == /ACCGO/T_MEANS.MODE_ID
  • C_TRDGCONTRACTOPTIONITEMDET.MANDT == /ACCGO/T_MEANS.MANDT
  • C_TRDGCONTRACTOPTIONITEMDET.ACMCONTROPTIONSMNSOFTRANSPORT == /ACCGO/T_MEANS.MEANS_ID