I_CmmdtySubAcctMappedExternal

Join Subacct with mapping table depending on derivation mode | view: ICMMSAMPGEXT | 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
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
CommodityDerivativeBroker Commodity Derivative Broker BU_PARTNER
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
  • Client
  • Company Code
  • I_CMMDTYSUBACCTMAPPEDEXTERNAL.MANDT == T001.MANDT
  • I_CMMDTYSUBACCTMAPPEDEXTERNAL.COMPANYCODE == T001.BUKRS
Derivative Contract Specification (DCS) I_CMMDTYSUBACCTMAPPEDEXTERNAL.MANDT == TBAC_DCS.CLIENT
Treasury Futures Account
  • Client
  • ?
  • Treasury Futures Account
Market Identifier Code (MIC)
  • Client
  • Market Identifier Code (MIC)
  • I_CMMDTYSUBACCTMAPPEDEXTERNAL.MANDT == TBAC_MIC.CLIENT
  • I_CMMDTYSUBACCTMAPPEDEXTERNAL.MARKETIDENTIFIERCODE == TBAC_MIC.MIC
Plant
  • Client
  • Plant
  • I_CMMDTYSUBACCTMAPPEDEXTERNAL.MANDT == T001W.MANDT
  • I_CMMDTYSUBACCTMAPPEDEXTERNAL.PLANT == T001W.WERKS
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • I_CMMDTYSUBACCTMAPPEDEXTERNAL.MANDT == CEPC.MANDT
  • I_CMMDTYSUBACCTMAPPEDEXTERNAL.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_CMMDTYSUBACCTMAPPEDEXTERNAL.[column in domain "DATBI"] == CEPC.DATBI
  • I_CMMDTYSUBACCTMAPPEDEXTERNAL.PROFITCENTER == CEPC.PRCTR