I_CommoditySubAccount

Commodity Subaccount | view: ICMMDTYSUBACCT | Extraction: Not supported | Component: Commodity Derivative Order and Trade Execution
Tables used: CMMFSA_D_SUBACCT
Column Name Description
CommoditySubAccountUUID UUID serving as key (parent key, root key)
Column Name Description
Column Name Description
Column Name Description
Column Name Description
CmmdtySubAccountStatus Lifecycle Status of Commodity Subaccount Show values
CmmdtySubAccountIsBlocked Commodity Subaccount Blocked for Order Creation Show values
Column Name Description Domain name
CommoditySubAccount Commodity Subaccount ID CMMFSA_SUBACCOUNTID
CommoditySubAccountName Commodity Subaccount Name CMMFSA_SUBACCOUNTNAME
CmmdtySubAccountStatusReason Invalidation Reason CMMFSA_SUBACCOUNTSTATUSREASON
ReferenceBrokerAccount Reference Account CMMFSA_REFERENCEBROKERACCOUNT
Portfolio Portfolio RPORTB
Counterparty Internal Exchange Counterparty BU_PARTNER
CommodityDerivativeBroker Commodity Derivative Broker BU_PARTNER
CommoditySubAccountClearingKey Commodity Subaccount Clearing Key CMMFSA_SUBACCTCLEARINGKEY
CreatedByUser Created By User USNAM
CreationDateTime Timestamp of record creation TZNTSTMPS
LastChangedByUser Last changed by user ID USNAM
LastChangeDateTime Timestamp of last change TZNTSTMPS
Master Data Relations Join Conditions
Commodity
  • Client
  • Commodity
Company Code
  • Company Code
  • Client
  • I_COMMODITYSUBACCOUNT.COMPANYCODE == T001.BUKRS
  • I_COMMODITYSUBACCOUNT.MANDT == T001.MANDT
Derivative Contract Specification (DCS) I_COMMODITYSUBACCOUNT.MANDT == TBAC_DCS.CLIENT
Treasury Futures Account
  • Treasury Futures Account
  • ?
  • Client
Market Identifier Code (MIC)
  • Client
  • Market Identifier Code (MIC)
  • I_COMMODITYSUBACCOUNT.MANDT == TBAC_MIC.CLIENT
  • I_COMMODITYSUBACCOUNT.MARKETIDENTIFIERCODE == TBAC_MIC.MIC
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • I_COMMODITYSUBACCOUNT.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_COMMODITYSUBACCOUNT.[column in domain "DATBI"] == CEPC.DATBI
  • I_COMMODITYSUBACCOUNT.MANDT == CEPC.MANDT
  • I_COMMODITYSUBACCOUNT.PROFITCENTER == CEPC.PRCTR
Other Relations | to Master Data Relations ↑ Join Conditions
Commodity Subaccount Clearing Account
  • Commodity Derivative Broker
  • Commodity Subaccount Clearing Account
  • Client