I_CommoditySubAccount

DDL: I_COMMODITYSUBACCOUNT SQL: ICMMDTYSUBACCT Type: view BASIC Package: FS_CMM_COMMODITY_SUBACCOUNT
22 Fields 1 Data Sources 1 Associations

Commodity Subaccount

I_CommoditySubAccount is a Basic CDS View that provides data about "Commodity Subaccount" in SAP S/4HANA. It reads from 1 data source (cmmfsa_d_subacct) and exposes 22 fields with key field CommoditySubAccountUUID. It has 1 association to related views. Part of development package FS_CMM_COMMODITY_SUBACCOUNT.

Data Sources (1)

SourceAliasJoin Type
cmmfsa_d_subacct CommoditySubAccount from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_CommoditySubAccount _Extension $projection.CommoditySubAccountUUID = _Extension.CommoditySubAccountUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYSUBACCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label Commodity Subaccount view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CommoditySubAccountUUID cmmfsa_d_subacct commoditysubaccountuuid Key
CommoditySubAccount cmmfsa_d_subacct commoditysubaccount Subaccount ID
CommoditySubAccountName cmmfsa_d_subacct commoditysubaccountname Subaccount Name
CmmdtySubAccountStatus cmmfsa_d_subacct cmmdtysubaccountstatus Status
CmmdtySubAccountStatusReason cmmfsa_d_subacct cmmdtysubaccountstatusreason Invalidation Reason
CompanyCode cmmfsa_d_subacct companycode Receiver Company Code
FuturesAccount cmmfsa_d_subacct futuresaccount Futures Account
Commodity cmmfsa_d_subacct commodity Commodity Code
MarketIdentifierCode cmmfsa_d_subacct marketidentifiercode MIC
DerivativeContrSpecification cmmfsa_d_subacct derivativecontrspecification DCS ID
ReferenceBrokerAccount cmmfsa_d_subacct referencebrokeraccount Reference Account
Portfolio cmmfsa_d_subacct portfolio Portfolio
ProfitCenter cmmfsa_d_subacct profitcenter Profit Center
Counterparty cmmfsa_d_subacct counterparty Supplier
CommodityDerivativeBroker cmmfsa_d_subacct commodityderivativebroker Broker ID
CmmdtySubAcctClearingAccount cmmfsa_d_subacct cmmdtysubacctclearingaccount Clearing Account
CommoditySubAccountClearingKey cmmfsa_d_subacct commoditysubaccountclearingkey Clearing Key
CreatedByUser cmmfsa_d_subacct createdbyuser User Name
CreationDateTime cmmfsa_d_subacct creationdatetime Timestamp
LastChangedByUser cmmfsa_d_subacct lastchangedbyuser User Name
LastChangeDateTime cmmfsa_d_subacct lastchangedatetime Timestamp
CmmdtySubAccountIsBlocked cmmfsa_d_subacct cmmdtysubaccountisblocked Order Create Blocked

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CommoditySubAccount.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICMMDTYSUBACCT

CREATE VIEW I_CommoditySubAccount AS
SELECT
  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
FROM cmmfsa_d_subacct AS CommoditySubAccount
LEFT OUTER JOIN E_CommoditySubAccount AS _Extension ON CommoditySubAccountUUID = _Extension.CommoditySubAccountUUID  -- association [1..1]
;

Learn More