I_CommoditySubAccountTP

DDL: I_COMMODITYSUBACCOUNTTP SQL: ICMMDTYSUBACCTTP Type: view TRANSACTIONAL Package: FS_CMM_COMMODITY_SUBACCOUNT
22 Fields 2 Data Sources 1 Associations

Commodity Subaccount Transactional View

I_CommoditySubAccountTP is a Transactional CDS View that provides data about "Commodity Subaccount Transactional View" in SAP S/4HANA. It reads from 2 data sources (I_CmmdtyDrvtvOrdTrdExecRecent, I_CommoditySubAccount) 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 (2)

SourceAliasJoin Type
I_CmmdtyDrvtvOrdTrdExecRecent ExecRecent left_outer
I_CommoditySubAccount I_CommoditySubAccount from

Associations (1)

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

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYSUBACCTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Commodity Subaccount Transactional View view
VDM.viewType #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.writeActivePersistence CMMFSA_D_SUBACCT view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelCategory #BUSINESS_OBJECT view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CommoditySubAccountUUID I_CommoditySubAccount CommoditySubAccountUUID Key
CommoditySubAccount I_CommoditySubAccount CommoditySubAccount Subaccount ID
CommoditySubAccountName I_CommoditySubAccount CommoditySubAccountName Subaccount Name
CmmdtySubAccountStatus I_CommoditySubAccount CmmdtySubAccountStatus Status
CmmdtySubAccountStatusReason I_CommoditySubAccount CmmdtySubAccountStatusReason Invalidation Reason
CompanyCode I_CommoditySubAccount CompanyCode Receiver Company Code
FuturesAccount I_CommoditySubAccount FuturesAccount Futures Account
Commodity I_CommoditySubAccount Commodity Commodity Code
MarketIdentifierCode I_CommoditySubAccount MarketIdentifierCode MIC
DerivativeContrSpecification I_CommoditySubAccount DerivativeContrSpecification DCS ID
ReferenceBrokerAccount I_CommoditySubAccount ReferenceBrokerAccount Reference Account
Portfolio I_CommoditySubAccount Portfolio Portfolio
ProfitCenter I_CommoditySubAccount ProfitCenter Profit Center
Counterparty I_CommoditySubAccount Counterparty Supplier
CommodityDerivativeBroker I_CommoditySubAccount CommodityDerivativeBroker Broker ID
CmmdtySubAcctClearingAccount I_CommoditySubAccount CmmdtySubAcctClearingAccount Clearing Account
CommoditySubAccountClearingKey I_CommoditySubAccount CommoditySubAccountClearingKey Clearing Key
CmmdtySubAccountIsBlocked I_CommoditySubAccount CmmdtySubAccountIsBlocked Order Create Blocked
CreatedByUser I_CommoditySubAccount CreatedByUser User Name
CreationDateTime I_CommoditySubAccount CreationDateTime Timestamp
LastChangedByUser I_CommoditySubAccount LastChangedByUser User Name
LastChangeDateTime I_CommoditySubAccount LastChangeDateTime Timestamp

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_CommoditySubAccountTP.
-- 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: ICMMDTYSUBACCTTP

CREATE VIEW I_CommoditySubAccountTP AS
SELECT
  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,
  I_CommoditySubAccount.CompanyCode AS CompanyCode,
  I_CommoditySubAccount.FuturesAccount AS FuturesAccount,
  I_CommoditySubAccount.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.Counterparty AS Counterparty,
  I_CommoditySubAccount.CommodityDerivativeBroker AS CommodityDerivativeBroker,
  I_CommoditySubAccount.CmmdtySubAcctClearingAccount AS CmmdtySubAcctClearingAccount,
  I_CommoditySubAccount.CommoditySubAccountClearingKey AS CommoditySubAccountClearingKey,
  I_CommoditySubAccount.CmmdtySubAccountIsBlocked AS CmmdtySubAccountIsBlocked,
  I_CommoditySubAccount.CreatedByUser AS CreatedByUser,
  I_CommoditySubAccount.CreationDateTime AS CreationDateTime,
  I_CommoditySubAccount.LastChangedByUser AS LastChangedByUser,
  I_CommoditySubAccount.LastChangeDateTime AS LastChangeDateTime
FROM I_CommoditySubAccount
LEFT OUTER JOIN I_CmmdtyDrvtvOrdTrdExecRecent AS ExecRecent ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_CommoditySubAccount AS _Extension ON CommoditySubAccountUUID = _Extension.CommoditySubAccountUUID  -- association [1..1]
;

Learn More