C_ContractItemSubAccountDet

Consumption Query for Trading Contract Sub Account Details | view: CTRDGCONTRSUBACC | TRAN | Extraction: Not supported | Component: Commodity Contracts, Expenses, Basic Functions
Tables used: WBHK/ACCGO/T_CAKITMWBHD
Column Name Description
TradingContractNumber Trading Contract
TradingContractItem Item Number of Trading Contract
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
ContractSubItem Sub-Item Number of Trading Contract
ACMTrdgContrCmmdtySubAccountId Commodity Subaccount ID
CommoditySubAccountName Commodity Subaccount Name
Master Data Relations Join Conditions
Check Distribution Channel
  • Sales Organization
  • Distribution Channel
  • Client
  • C_CONTRACTITEMSUBACCOUNTDET.SALESORGANIZATION == TVKOV.VKORG
  • C_CONTRACTITEMSUBACCOUNTDET.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_CONTRACTITEMSUBACCOUNTDET.MANDT == TVKOV.MANDT
Check Division
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • C_CONTRACTITEMSUBACCOUNTDET.SALESORGANIZATION == TVTA.VKORG
  • C_CONTRACTITEMSUBACCOUNTDET.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_CONTRACTITEMSUBACCOUNTDET.MANDT == TVTA.MANDT
  • C_CONTRACTITEMSUBACCOUNTDET.DIVISION == TVTA.SPART
Check Purchasing Group
  • Purchasing Group
  • Client
  • C_CONTRACTITEMSUBACCOUNTDET.PURCHASINGGROUP == T024.EKGRP
  • C_CONTRACTITEMSUBACCOUNTDET.MANDT == T024.MANDT
Check Purchasing Organization
  • Client
  • Purchasing organization
  • C_CONTRACTITEMSUBACCOUNTDET.MANDT == T024E.MANDT
  • C_CONTRACTITEMSUBACCOUNTDET.PURCHASINGORGANIZATION == T024E.EKORG
Check Sales Organization
  • Sales Organization
  • Client
  • C_CONTRACTITEMSUBACCOUNTDET.SALESORGANIZATION == TVKO.VKORG
  • C_CONTRACTITEMSUBACCOUNTDET.MANDT == TVKO.MANDT
Check Trading Contract Type
  • Client
  • Trading Contract Type
  • C_CONTRACTITEMSUBACCOUNTDET.MANDT == TB2BE.MANDT
  • C_CONTRACTITEMSUBACCOUNTDET.TRADINGCONTRACTTYPE == TB2BE.TCTYP