I_CommoditySubAccountTP

Commodity Subaccount Transactional View | view: ICMMDTYSUBACCTTP | Extraction: Not supported | Component: Commodity Derivative Order and Trade Execution
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
CmmdtyDrvtvOrdTrdExecIsRecent null
Master Data Relations Join Conditions
Commodity
  • Commodity
  • Client
Company Code
  • Client
  • Company Code
  • I_COMMODITYSUBACCOUNTTP.MANDT == T001.MANDT
  • I_COMMODITYSUBACCOUNTTP.COMPANYCODE == T001.BUKRS
Derivative Contract Specification (DCS) I_COMMODITYSUBACCOUNTTP.MANDT == TBAC_DCS.CLIENT
Treasury Futures Account
  • Treasury Futures Account
  • Client
  • ?
Market Identifier Code (MIC)
  • Client
  • Market Identifier Code (MIC)
  • I_COMMODITYSUBACCOUNTTP.MANDT == TBAC_MIC.CLIENT
  • I_COMMODITYSUBACCOUNTTP.MARKETIDENTIFIERCODE == TBAC_MIC.MIC
Profit Center
  • Client
  • Profit Center
  • ?
  • ?
  • I_COMMODITYSUBACCOUNTTP.MANDT == CEPC.MANDT
  • I_COMMODITYSUBACCOUNTTP.PROFITCENTER == CEPC.PRCTR
  • I_COMMODITYSUBACCOUNTTP.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_COMMODITYSUBACCOUNTTP.[column in domain "DATBI"] == CEPC.DATBI
Other Relations | to Master Data Relations ↑ Join Conditions
Commodity Subaccount Clearing Account
  • Client
  • Commodity Subaccount Clearing Account
  • Commodity Derivative Broker