I_COMMODITYSUBACCOUNT

CDS View

Commodity Subaccount

I_COMMODITYSUBACCOUNT is a CDS View in S/4HANA. Commodity Subaccount. It contains 22 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 22 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_CommodityOrderRequest view left_outer CONSUMPTION Cmmdty Drvtv Order Request Details
I_CmmdtyOrdReqBracketItm view left_outer COMPOSITE Cmmdty Order Bracket Item Interface View
I_CmmdtySubAcctMappedExternal view from BASIC Join Subacct with mapping table depending on derivation mode
I_CmmdtySubAcctMappingVH view from BASIC Value Help for Active/Inactive SubAcc
I_CommodityOrderRequest view left_outer BASIC Commodity Order Request Interface View
I_CommoditySubAccountText view from BASIC Commodity Subaccount Text
I_CommoditySubAccountTP view from TRANSACTIONAL Commodity Subaccount Transactional View
I_CommoditySubAccountVH view from COMPOSITE Commodity Subaccount Value Help View

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CmmdtySubAccountStatus CmmdtySubAccountStatus 3
KEY CommoditySubAccount CommoditySubAccount 4
KEY CommoditySubAccountName CommoditySubAccountName 6
KEY CommoditySubAccountUUID CommoditySubAccountUUID 2
CmmdtySubAccountIsBlocked CmmdtySubAccountIsBlocked 1
CmmdtySubAccountStatusReason CmmdtySubAccountStatusReason 2
CmmdtySubAcctClearingAccount CmmdtySubAcctClearingAccount 1
Commodity Commodity 4
CommodityDerivativeBroker CommodityDerivativeBroker 3
CommoditySubAccountClearingKey CommoditySubAccountClearingKey 1
CompanyCode CompanyCode 4
Counterparty Counterparty 2
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
DerivativeContrSpecification DerivativeContrSpecification 3
FuturesAccount FuturesAccount 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
MarketIdentifierCode MarketIdentifierCode 3
Portfolio Portfolio 2
ProfitCenter ProfitCenter 2
ReferenceBrokerAccount ReferenceBrokerAccount 3 
@AbapCatalog.sqlViewName                : 'ICMMDTYSUBACCT'
@AbapCatalog.compiler.compareFilter     : true
@AbapCatalog.preserveKey                : true
@ClientHandling.algorithm               : #SESSION_VARIABLE
@AccessControl.authorizationCheck       : #CHECK
@VDM.viewType                           : #BASIC
@EndUserText.label                      : 'Commodity Subaccount'
@ObjectModel.usageType.sizeCategory     : #S
@ObjectModel.usageType.serviceQuality   : #B
@ObjectModel.usageType.dataClass        : #MASTER
@Metadata.ignorePropagatedAnnotations   :true

-- Basic View for Commodity Subaccount
define view I_CommoditySubAccount
  as select from cmmfsa_d_subacct as CommoditySubAccount

  -- Extension View for Free Characteristics
  association [1..1] to E_CommoditySubAccount as _Extension on $projection.CommoditySubAccountUUID = _Extension.CommoditySubAccountUUID
{
  key    CommoditySubAccount.commoditysubaccountuuid                   as CommoditySubAccountUUID,
         CommoditySubAccount.commoditysubaccount                       as CommoditySubAccount,
         CommoditySubAccount.commoditysubaccountname                   as CommoditySubAccountName,
         CommoditySubAccount.cmmdtysubaccountstatus                    as CmmdtySubAccountStatus,
         CommoditySubAccount.cmmdtysubaccountstatusreason              as CmmdtySubAccountStatusReason,
         CommoditySubAccount.companycode                               as CompanyCode,
         CommoditySubAccount.futuresaccount                            as FuturesAccount,
         CommoditySubAccount.commodity                                 as Commodity,
         CommoditySubAccount.marketidentifiercode                      as MarketIdentifierCode,
         CommoditySubAccount.derivativecontrspecification              as DerivativeContrSpecification,
         CommoditySubAccount.referencebrokeraccount                    as ReferenceBrokerAccount,
         CommoditySubAccount.portfolio                                 as Portfolio,
         CommoditySubAccount.profitcenter                              as ProfitCenter,
         CommoditySubAccount.counterparty                              as Counterparty,
         CommoditySubAccount.commodityderivativebroker                 as CommodityDerivativeBroker,
         CommoditySubAccount.cmmdtysubacctclearingaccount              as CmmdtySubAcctClearingAccount,
         CommoditySubAccount.commoditysubaccountclearingkey            as CommoditySubAccountClearingKey,
         CommoditySubAccount.createdbyuser                             as CreatedByUser,
         CommoditySubAccount.creationdatetime                          as CreationDateTime,
         CommoditySubAccount.lastchangedbyuser                         as LastChangedByUser,
         CommoditySubAccount.lastchangedatetime                        as LastChangeDateTime,
         CommoditySubAccount.cmmdtysubaccountisblocked                 as CmmdtySubAccountIsBlocked
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CMMFSA_D_SUBACCT"
],
"ASSOCIATED":
[
"E_COMMODITYSUBACCOUNT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More