I_CmmdtySubAcctMappedExternal

@AbapCatalog.sqlViewName: 'ICMMSAMPGEXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@EndUserText.label: 'Join Subacct with mapping table depending on derivation mode'
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MASTER

define view I_CmmdtySubAcctMappedExternal
  as select from I_CommoditySubAccount
    inner join   cmmfsa_d_sa_map on  I_CommoditySubAccount.CommoditySubAccount = cmmfsa_d_sa_map.commoditysubaccount
                                 and I_CommoditySubAccount.mandt               = cmmfsa_d_sa_map.mandt

  -- Extension View for Free Characteristics
  association [1..1] to E_CommoditySubAccount as _Extension on $projection.CommoditySubAccountUUID = _Extension.CommoditySubAccountUUID

{
  key    I_CommoditySubAccount.CommoditySubAccountUUID               as CommoditySubAccountUUID,
         I_CommoditySubAccount.CommoditySubAccount                   as CommoditySubAccount,
         I_CommoditySubAccount.CommoditySubAccountName               as CommoditySubAccountName,
         I_CommoditySubAccount.CmmdtySubAccountStatus                as CmmdtySubAccountStatus,
         I_CommoditySubAccount.CmmdtySubAccountStatusReason          as CmmdtySubAccountStatusReason,
         cmmfsa_d_sa_map.companycode                                 as CompanyCode,
         I_CommoditySubAccount.FuturesAccount                        as FuturesAccount,
         cmmfsa_d_sa_map.commodity                                   as Commodity,
         I_CommoditySubAccount.MarketIdentifierCode                  as MarketIdentifierCode,
         I_CommoditySubAccount.DerivativeContrSpecification          as DerivativeContrSpecification,
         I_CommoditySubAccount.ReferenceBrokerAccount                as ReferenceBrokerAccount,
         I_CommoditySubAccount.Portfolio                             as Portfolio,
         I_CommoditySubAccount.ProfitCenter                          as ProfitCenter,
         I_CommoditySubAccount.CommodityDerivativeBroker             as CommodityDerivativeBroker,
         I_CommoditySubAccount.CreatedByUser                         as CreatedByUser,
         I_CommoditySubAccount.CreationDateTime                      as CreationDateTime,
         I_CommoditySubAccount.LastChangedByUser                     as LastChangedByUser,
         I_CommoditySubAccount.LastChangeDateTime                    as LastChangeDateTime,
         cmmfsa_d_sa_map.plant                                       as Plant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMMODITYSUBACCOUNT",
"CMMFSA_D_SA_MAP"
],
"ASSOCIATED":
[
"E_COMMODITYSUBACCOUNT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/