I_TrdgContrPrcFixationFeeDet

DDL: I_TRDGCONTRPRCFIXATIONFEEDET SQL: ITCPRCFIXFEE Type: view COMPOSITE
18 Fields 4 Data Sources

Interface Layer for Trading Contract Price Fix Fee Details

I_TrdgContrPrcFixationFeeDet is a Composite CDS View that provides data about "Interface Layer for Trading Contract Price Fix Fee Details" in SAP S/4HANA. It reads from 4 data sources (I_ACMFeeDetails, P_GenericDomainVH, P_GenericDomainVH, P_GenericDomainVH) and exposes 18 fields with key fields FeeDocumentLevel, TradingContractNumber, TradingContractItem, PricingConditionTerm, RefDocumentYear.

Data Sources (4)

SourceAliasJoin Type
I_ACMFeeDetails I_ACMFeeDetails from
P_GenericDomainVH P_GenericDomainVH left_outer
P_GenericDomainVH P_GenericDomainVH left_outer
P_GenericDomainVH P_GenericDomainVH left_outer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ITCPRCFIXFEE 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 #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view
EndUserText.label Interface Layer for Trading Contract Price Fix Fee Details view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY FeeDocumentLevel FeeDocumentLevel TSW Document type
KEY TradingContractNumber ACMFeeReferenceDocumentID Snapshot ID
KEY TradingContractItem ACMFeeReferenceDocumentItem Reference Doc. Item
KEY PricingConditionTerm ACMFeeReferenceDocumentSubItem RefDoc Sub-Item
KEY RefDocumentYear RefDocumentYear Ref. Doc. Year
KEY FeeSequenceNumber FeeSequenceNumber Sqnc No. in Ext File
KEY FeeFrameworkFeeID FeeFrameworkFeeID Fee ID
KEY FeeVersion FeeVersion XML Vers.
FeeFrameworkFeeName FeeFrameworkFeeName Fee Name
FeeDocumentLevelName FeeDocType DomainText Short Description
FeeFrameworkFeeRate FeeFrameworkFeeRate Tax Rate
TradingContractCurrency ACMFeeCurrency Valuation Crcy
PriceUnitQty PriceUnitQty Price unit
UnitOfMeasure UnitOfMeasure Unit Protected Qty
FeeAllocationMode FeeAllocationMode Allocation Mode
FeeAllocationModeName AllocationMode DomainText Short Description
ACMFeeIsObsolete Fee Obsolete
ACMAssignedFeeDecimalPlaces ACMAssignedFeeDecimalPlaces Decimal Places

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_TrdgContrPrcFixationFeeDet.
-- 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: ITCPRCFIXFEE

CREATE VIEW I_TrdgContrPrcFixationFeeDet AS
SELECT
  FeeDocumentLevel,
  ACMFeeReferenceDocumentID AS TradingContractNumber,
  ACMFeeReferenceDocumentItem AS TradingContractItem,
  ACMFeeReferenceDocumentSubItem AS PricingConditionTerm,
  RefDocumentYear,
  FeeSequenceNumber,
  FeeFrameworkFeeID,
  FeeVersion,
  FeeFrameworkFeeName,
  FeeDocType.DomainText AS FeeDocumentLevelName,
  FeeFrameworkFeeRate,
  ACMFeeCurrency AS TradingContractCurrency,
  PriceUnitQty,
  UnitOfMeasure,
  FeeAllocationMode,
  AllocationMode.DomainText AS FeeAllocationModeName,
  cast( ACMFeeIsObsolete as boole_d preserving type ) AS ACMFeeIsObsolete,
  ACMAssignedFeeDecimalPlaces
FROM I_ACMFeeDetails
LEFT OUTER JOIN P_GenericDomainVH ON /* join condition not captured in parsed metadata */
;

Learn More