I_TradingContractHdrFeeDet

DDL: I_TRADINGCONTRACTHDRFEEDET SQL: ITRDGCONTHDRFEE Type: view COMPOSITE
37 Fields 4 Data Sources

Interface Layer for Trading Contract Header Fee Details

I_TradingContractHdrFeeDet (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

I_TradingContractHdrFeeDet is a Composite CDS View that provides data about "Interface Layer for Trading Contract Header Fee Details" in SAP S/4HANA. It reads from 4 data sources (I_TradingContractHdrFeeData, P_GenericDomainVH, P_GenericDomainVH, P_GenericDomainVH) and exposes 37 fields with key fields FeeDocumentLevel, TradingContractNumber, TradingContractItem, ContractSubItem, RefDocumentYear.

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentLO-AGR-CC
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select
PackageSales for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (4)

SourceAliasJoin Type
I_TradingContractHdrFeeData I_TradingContractHdrFeeData from
P_GenericDomainVH P_GenericDomainVH left_outer
P_GenericDomainVH P_GenericDomainVH left_outer
P_GenericDomainVH P_GenericDomainVH left_outer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ITRDGCONTHDRFEE 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
EndUserText.label Interface Layer for Trading Contract Header Fee Details view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY FeeDocumentLevel FeeDocumentLevel TSW Document type
KEY TradingContractNumber TradingContractNumber Reference Document ID
KEY TradingContractItem TradingContractItem Reference Document Item
KEY ContractSubItem ContractSubItem Reference Document Sub-Item
KEY RefDocumentYear RefDocumentYear Reference Document Year
KEY FeeSequenceNumber FeeSequenceNumber Reference Document Sequence Number
KEY FeeFrameworkFeeID FeeFrameworkFeeID Fee ID (Fee Framework)
KEY FeeVersion FeeVersion Fee Version
FeeFrameworkFeeName FeeFrameworkFeeName Fee Name
FeeDocumentLevelName FeeDocType DomainText Short Text for Fixed Values
FeeType FeeType Fee Type (Fee Framework)
ACMFeeTypeName FeeType DomainText Short Text for Fixed Values
FeeFrameworkFeeRate FeeFrameworkFeeRate Tax Rate
TradingContractCurrency TradingContractCurrency Valuation Crcy
PriceUnitQty PriceUnitQty Price unit
UnitOfMeasure UnitOfMeasure Unit of Measure for Fee
FeeAllocationMode FeeAllocationMode Allocation Mode
FeeAllocationModeName AllocationMode DomainText Short Text for Fixed Values
ACMFeeStopOnPrvsnlSettlmt ACMFeeStopOnPrvsnlSettlmt Stop Settlement on Provisional
ACMFeeStopOnFinalSettlmt ACMFeeStopOnFinalSettlmt Stop Settlement on Final
ACMFeeInchargeAmount ACMFeeInchargeAmount Incharge Rate
ACMInChargeAmtCrcy ACMInChargeAmtCrcy In Charge Currency
ACMInchargeQty ACMInchargeQty In Charge Quantity
ACMInchargeQtyUoM ACMInchargeQtyUoM In Charge Unit of Measure
ACMFeeRecrrgChrgAmount ACMFeeRecrrgChrgAmount Recurring Charge Rate
ACMFeeRecrrgChrgCrcy ACMFeeRecrrgChrgCrcy Recurring Charge Currency
ACMFeeRecrrgChrgQty ACMFeeRecrrgChrgQty Recurring Charge Quantity
ACMFeeRecrrgChrgUoM ACMFeeRecrrgChrgUoM Recurring Charge Unit of Measure
ACMFeeMaxChargeAmount ACMFeeMaxChargeAmount Maximum Charge Rate
ACMFeeMaxChrgCrcy ACMFeeMaxChrgCrcy Maximum Charge Currency
ACMFeeMaxChargeQuantity ACMFeeMaxChargeQuantity Maximum Charge Quantity
ACMFeeMaxChargeUoM ACMFeeMaxChargeUoM Maximum Charge Unit of Measurement
ACMFeePremCrdtAmount ACMFeePremCrdtAmount Premium Credit Rate
ACMFeePremCrdtCrcy ACMFeePremCrdtCrcy Premium Credit Currency
ACMFeePremCrdtQty ACMFeePremCrdtQty Premium Credit Quantity
ACMFeePremCrdtUoM ACMFeePremCrdtUoM Premium Credit Unit of Measure
ACMNoPrcgFeeIdfr ACMNoPrcgFeeIdfr Fee Type (Fee Framework)

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_TradingContractHdrFeeDet.
-- 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: ITRDGCONTHDRFEE

CREATE VIEW I_TradingContractHdrFeeDet AS
SELECT
  FeeDocumentLevel,
  TradingContractNumber,
  TradingContractItem,
  ContractSubItem,
  RefDocumentYear,
  FeeSequenceNumber,
  FeeFrameworkFeeID,
  FeeVersion,
  FeeFrameworkFeeName,
  FeeDocType.DomainText AS FeeDocumentLevelName,
  FeeType,
  FeeType.DomainText AS ACMFeeTypeName,
  FeeFrameworkFeeRate,
  TradingContractCurrency,
  PriceUnitQty,
  UnitOfMeasure,
  FeeAllocationMode,
  AllocationMode.DomainText AS FeeAllocationModeName,
  ACMFeeStopOnPrvsnlSettlmt,
  ACMFeeStopOnFinalSettlmt,
  ACMFeeInchargeAmount,
  ACMInChargeAmtCrcy,
  ACMInchargeQty,
  ACMInchargeQtyUoM,
  ACMFeeRecrrgChrgAmount,
  ACMFeeRecrrgChrgCrcy,
  ACMFeeRecrrgChrgQty,
  ACMFeeRecrrgChrgUoM,
  ACMFeeMaxChargeAmount,
  ACMFeeMaxChrgCrcy,
  ACMFeeMaxChargeQuantity,
  ACMFeeMaxChargeUoM,
  ACMFeePremCrdtAmount,
  ACMFeePremCrdtCrcy,
  ACMFeePremCrdtQty,
  ACMFeePremCrdtUoM,
  ACMNoPrcgFeeIdfr
FROM I_TradingContractHdrFeeData
LEFT OUTER JOIN P_GenericDomainVH ON /* join condition not captured in parsed metadata */
;

Learn More