I_SUBACCOUNT

DDL: I_SUBACCOUNT SQL: PSUBACCOUNT Type: view COMPOSITE
32 Fields 2 Data Sources

Sub Account

I_SUBACCOUNT is a Composite CDS View that provides data about "Sub Account" in SAP S/4HANA. It reads from 2 data sources (I_ContItem, I_ACMContractItemAddldata) and exposes 32 fields.

Data Sources (2)

SourceAliasJoin Type
I_ContItem I_ContItem from
I_ACMContractItemAddldata subaccount inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSUBACCOUNT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sub Account view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (32)

KeyFieldSource TableSource FieldDescription
TradingContractNumber I_ACMContractItemAddldata TradingContractNumber Trading Contract
TradingContractItem I_ACMContractItemAddldata TradingContractItem Item Number
ContractSubItem I_ACMContractItemAddldata ContractSubItem
ValuationPoint I_ACMContractItemAddldata ValuationPoint
ACMPricingApproach I_ACMContractItemAddldata ACMPricingApproach
ACMPrcgIntendedPrcType I_ACMContractItemAddldata ACMPrcgIntendedPrcType
ACMHierTSW I_ACMContractItemAddldata ACMHierTSW
StorageFreeDaysValue I_ACMContractItemAddldata StorageFreeDaysValue
StorageRatesLockedValue I_ACMContractItemAddldata StorageRatesLockedValue
ACMHasStartDate I_ACMContractItemAddldata ACMHasStartDate
ACMHasEndDate I_ACMContractItemAddldata ACMHasEndDate
ACMIncludeQtyBased I_ACMContractItemAddldata ACMIncludeQtyBased
ACMWgtTypePricing I_ACMContractItemAddldata ACMWgtTypePricing
AlternatePaymentType I_ACMContractItemAddldata AlternatePaymentType
AlternatePaymentTerm I_ACMContractItemAddldata AlternatePaymentTerm
PaymentDate I_ACMContractItemAddldata PaymentDate Payment Date
CommoditySubAccountUUID I_ACMContractItemAddldata CommoditySubAccountUUID Key
ACMTrdgContrCmmdtySubAccountId I_ACMContractItemAddldata ACMTrdgContrCmmdtySubAccountId
ACMTrdgContrSubAccountName I_ACMContractItemAddldata ACMTrdgContrSubAccountName
ACMCmmdtySubAccountStatus I_ACMContractItemAddldata ACMCmmdtySubAccountStatus
ACMCmmdtySubAccountStatusRsn I_ACMContractItemAddldata ACMCmmdtySubAccountStatusRsn
CompanyCode I_ACMContractItemAddldata CompanyCode Receiver Company Code
FuturesAccount I_ACMContractItemAddldata FuturesAccount Futures Account
PhysicalCommodity I_ACMContractItemAddldata PhysicalCommodity
ACMMarketIdentifierCode I_ACMContractItemAddldata ACMMarketIdentifierCode
ACMDerivativeContrSpec I_ACMContractItemAddldata ACMDerivativeContrSpec
ReferenceBrokerAccount I_ACMContractItemAddldata ReferenceBrokerAccount Reference Account
Portfolio I_ACMContractItemAddldata Portfolio Portfolio
WBSElementProfitCenter I_ACMContractItemAddldata WBSElementProfitCenter
ACMDummySubAccountExtn I_ACMContractItemAddldata ACMDummySubAccountExtn
ACMContrCmmdtySubAccountMirror I_ACMContractItemAddldata ACMContrCmmdtySubAccountMirror
CommodityMirrorSubAccountName I_ACMContractItemAddldata CommodityMirrorSubAccountName

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_SUBACCOUNT.
-- 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: PSUBACCOUNT

CREATE VIEW I_SUBACCOUNT AS
SELECT
  subaccount.TradingContractNumber AS TradingContractNumber,
  subaccount.TradingContractItem AS TradingContractItem,
  subaccount.ContractSubItem AS ContractSubItem,
  subaccount.ValuationPoint AS ValuationPoint,
  subaccount.ACMPricingApproach AS ACMPricingApproach,
  subaccount.ACMPrcgIntendedPrcType AS ACMPrcgIntendedPrcType,
  subaccount.ACMHierTSW AS ACMHierTSW,
  subaccount.StorageFreeDaysValue AS StorageFreeDaysValue,
  subaccount.StorageRatesLockedValue AS StorageRatesLockedValue,
  subaccount.ACMHasStartDate AS ACMHasStartDate,
  subaccount.ACMHasEndDate AS ACMHasEndDate,
  subaccount.ACMIncludeQtyBased AS ACMIncludeQtyBased,
  subaccount.ACMWgtTypePricing AS ACMWgtTypePricing,
  subaccount.AlternatePaymentType AS AlternatePaymentType,
  subaccount.AlternatePaymentTerm AS AlternatePaymentTerm,
  subaccount.PaymentDate AS PaymentDate,
  subaccount.CommoditySubAccountUUID AS CommoditySubAccountUUID,
  subaccount.ACMTrdgContrCmmdtySubAccountId AS ACMTrdgContrCmmdtySubAccountId,
  subaccount.ACMTrdgContrSubAccountName AS ACMTrdgContrSubAccountName,
  subaccount.ACMCmmdtySubAccountStatus AS ACMCmmdtySubAccountStatus,
  subaccount.ACMCmmdtySubAccountStatusRsn AS ACMCmmdtySubAccountStatusRsn,
  subaccount.CompanyCode AS CompanyCode,
  subaccount.FuturesAccount AS FuturesAccount,
  subaccount.PhysicalCommodity AS PhysicalCommodity,
  subaccount.ACMMarketIdentifierCode AS ACMMarketIdentifierCode,
  subaccount.ACMDerivativeContrSpec AS ACMDerivativeContrSpec,
  subaccount.ReferenceBrokerAccount AS ReferenceBrokerAccount,
  subaccount.Portfolio AS Portfolio,
  subaccount.WBSElementProfitCenter AS WBSElementProfitCenter,
  subaccount.ACMDummySubAccountExtn AS ACMDummySubAccountExtn,
  subaccount.ACMContrCmmdtySubAccountMirror AS ACMContrCmmdtySubAccountMirror,
  subaccount.CommodityMirrorSubAccountName AS CommodityMirrorSubAccountName
FROM I_ContItem
INNER JOIN I_ACMContractItemAddldata AS subaccount ON /* join condition not captured in parsed metadata */
;

Learn More