C_ContractItemSubAccountDet

DDL: C_CONTRACTITEMSUBACCOUNTDET SQL: CTRDGCONTRSUBACC Type: view CONSUMPTION
11 Fields 3 Data Sources

Consumption Query for Trading Contract Sub Account Details

C_ContractItemSubAccountDet is a Consumption CDS View that provides data about "Consumption Query for Trading Contract Sub Account Details" in SAP S/4HANA. It reads from 3 data sources (I_ACMTrdgContractBusinessData, I_ContractItemSubAccountDet, I_ACMTradingContractData) and exposes 11 fields with key fields TradingContractNumber, TradingContractItem.

Data Sources (3)

SourceAliasJoin Type
I_ACMTrdgContractBusinessData Business inner
I_ContractItemSubAccountDet I_ContractItemSubAccountDet from
I_ACMTradingContractData TrdgContrHdr inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CTRDGCONTRSUBACC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view
EndUserText.label Consumption Query for Trading Contract Sub Account Details view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber I_ContractItemSubAccountDet TradingContractNumber Contract
KEY TradingContractItem I_ContractItemSubAccountDet TradingContractItem Contract Item
ContractSubItem ContractSubItem Contract Sub Item
ACMTrdgContrCmmdtySubAccountId ACMTrdgContrCmmdtySubAccountId Commodity Subaccount ID
CommoditySubAccountName CommoditySubAccountName Commodity Subaccount Name
TradingContractType I_ACMTradingContractData TradingContractType Contract Type
SalesOrganization I_ACMTradingContractData SalesOrganization Sales Organization
Division I_ACMTradingContractData Division Internal Division ID
DistributionChannel I_ACMTradingContractData DistributionChannel RefDistCh-Cust/Mat.
PurchasingGroup I_ACMTrdgContractBusinessData PurchasingGroup Purchasing Group
PurchasingOrganization I_ACMTrdgContractBusinessData PurchasingOrganization Purchasing Organization

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 C_ContractItemSubAccountDet.
-- 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: CTRDGCONTRSUBACC

CREATE VIEW C_ContractItemSubAccountDet AS
SELECT
  I_ContractItemSubAccountDet.TradingContractNumber AS TradingContractNumber,
  I_ContractItemSubAccountDet.TradingContractItem AS TradingContractItem,
  ContractSubItem,
  ACMTrdgContrCmmdtySubAccountId,
  CommoditySubAccountName,
  TrdgContrHdr.TradingContractType AS TradingContractType,
  TrdgContrHdr.SalesOrganization AS SalesOrganization,
  TrdgContrHdr.Division AS Division,
  TrdgContrHdr.DistributionChannel AS DistributionChannel,
  Business.PurchasingGroup AS PurchasingGroup,
  Business.PurchasingOrganization AS PurchasingOrganization
FROM I_ContractItemSubAccountDet
INNER JOIN I_ACMTradingContractData AS TrdgContrHdr ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMTrdgContractBusinessData AS Business ON /* join condition not captured in parsed metadata */
;

Learn More