I_ACMTradingContractHdrFeeDet

DDL: I_ACMTRADINGCONTRACTHDRFEEDET SQL: IACMCONTHDRFEE Type: view COMPOSITE
40 Fields 2 Data Sources

Interface View for Contract Header Fees

I_ACMTradingContractHdrFeeDet is a Composite CDS View that provides data about "Interface View for Contract Header Fees" in SAP S/4HANA. It reads from 2 data sources (I_ACMTradingContractHdrFeeData, I_ACMFeeCurrencyDecimal) and exposes 40 fields with key fields ACMFeeFrameworkDocTypeRef, ACMFeeFrameworkRefDocID, ACMFeeFrameworkRefDocumentItem, ACMFeeFrameworkRefDocSubItem, ACMFeeFrameworkRefDocYear.

Data Sources (2)

SourceAliasJoin Type
I_ACMTradingContractHdrFeeData fee from
I_ACMFeeCurrencyDecimal feeCustmCurr inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IACMCONTHDRFEE 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 View for Contract Header Fees view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY ACMFeeFrameworkDocTypeRef ACMFeeFrameworkDocTypeRef TSW Document type
KEY ACMFeeFrameworkRefDocID ACMFeeFrameworkRefDocID Snapshot ID
KEY ACMFeeFrameworkRefDocumentItem ACMFeeFrameworkRefDocumentItem Reference Doc. Item
KEY ACMFeeFrameworkRefDocSubItem ACMFeeFrameworkRefDocSubItem RefDoc Sub-Item
KEY ACMFeeFrameworkRefDocYear ACMFeeFrameworkRefDocYear Ref. Doc. Year
KEY ACMFeeFrameworkRefDocSqncNmbr ACMFeeFrameworkRefDocSqncNmbr Sqnc No. in Ext File
KEY FeeFrameworkFeeID FeeFrameworkFeeID Fee ID
KEY FeeVersion FeeVersion XML Vers.
FeeFrameworkFeeName FeeFrameworkFeeName Fee Name
FeeDocumentLevelName FeeDocType DomainText Short Description
ACMFeeType ACMFeeType Fee Type
ACMFeeTypeName FeeType DomainText Short Description
ACMFeeValidStatus ACMFeeValidStatus Fee Valid Status
ACMFeeAmount ACMFeeAmount Tax Rate
ACMFeeCurrency I_ACMTradingContractHdrFeeData ACMFeeCurrency Valuation Crcy
ACMFeeQuantity ACMFeeQuantity Value
ACMFeeUoM ACMFeeUoM UoM: Conv. to
ACMFeeFrameworkAllocationMode ACMFeeFrameworkAllocationMode Allocation Mode
FeeAllocationModeName AllocationMode DomainText Short Description
ACMFeeExtCurrency I_ACMFeeCurrencyDecimal ACMFeeCurrency Valuation Crcy
ACMDecimalPlace I_ACMTradingContractHdrFeeData ACMDecimalPlace Decimal Places
ACMFeeStopOnPrvsnlSettlmt ACMFeeStopOnPrvsnlSettlmt Stop Stl on Prov
ACMFeeStopOnFinalSettlmt ACMFeeStopOnFinalSettlmt Stop Stl on Final
ACMFeeInchargeAmount ACMFeeInchargeAmount Incharge Rate
ACMInChargeAmtCrcy ACMInChargeAmtCrcy In Charge Currency
ACMInchargeQty ACMInchargeQty In Charge Quantity
ACMInchargeQtyUoM ACMInchargeQtyUoM In Charge UoM
ACMFeeRecrrgChrgAmount ACMFeeRecrrgChrgAmount Recurring Charge Rat
ACMFeeRecrrgChrgCrcy ACMFeeRecrrgChrgCrcy Rec. Charge Currency
ACMFeeRecrrgChrgQty ACMFeeRecrrgChrgQty Rec Charge Quantity
ACMFeeRecrrgChrgUoM ACMFeeRecrrgChrgUoM Rec. Charge UoM
ACMFeeMaxChargeAmount ACMFeeMaxChargeAmount Maximum Charge Rat
ACMFeeMaxChrgCrcy ACMFeeMaxChrgCrcy Max. Charge Currency
ACMFeeMaxChargeQuantity ACMFeeMaxChargeQuantity Max Charge Quantity
ACMFeeMaxChargeUoM ACMFeeMaxChargeUoM Maximum Charge UoM
ACMFeePremCrdtAmount ACMFeePremCrdtAmount Premium Credit Rate
ACMFeePremCrdtCrcy ACMFeePremCrdtCrcy Prem Credit Currency
ACMFeePremCrdtQty ACMFeePremCrdtQty Premium Credit Quant
ACMFeePremCrdtUoM ACMFeePremCrdtUoM Premium Credit UoM
ACMNoPrcgFeeIdfr ACMNoPrcgFeeIdfr

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_ACMTradingContractHdrFeeDet.
-- 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: IACMCONTHDRFEE

CREATE VIEW I_ACMTradingContractHdrFeeDet AS
SELECT
  ACMFeeFrameworkDocTypeRef,
  ACMFeeFrameworkRefDocID,
  ACMFeeFrameworkRefDocumentItem,
  ACMFeeFrameworkRefDocSubItem,
  ACMFeeFrameworkRefDocYear,
  ACMFeeFrameworkRefDocSqncNmbr,
  FeeFrameworkFeeID,
  FeeVersion,
  FeeFrameworkFeeName,
  FeeDocType.DomainText AS FeeDocumentLevelName,
  ACMFeeType,
  FeeType.DomainText AS ACMFeeTypeName,
  ACMFeeValidStatus,
  ACMFeeAmount,
  fee.ACMFeeCurrency AS ACMFeeCurrency,
  ACMFeeQuantity,
  ACMFeeUoM,
  ACMFeeFrameworkAllocationMode,
  AllocationMode.DomainText AS FeeAllocationModeName,
  feeCustmCurr.ACMFeeCurrency AS ACMFeeExtCurrency,
  fee.ACMDecimalPlace AS ACMDecimalPlace,
  ACMFeeStopOnPrvsnlSettlmt,
  ACMFeeStopOnFinalSettlmt,
  ACMFeeInchargeAmount,
  ACMInChargeAmtCrcy,
  ACMInchargeQty,
  ACMInchargeQtyUoM,
  ACMFeeRecrrgChrgAmount,
  ACMFeeRecrrgChrgCrcy,
  ACMFeeRecrrgChrgQty,
  ACMFeeRecrrgChrgUoM,
  ACMFeeMaxChargeAmount,
  ACMFeeMaxChrgCrcy,
  ACMFeeMaxChargeQuantity,
  ACMFeeMaxChargeUoM,
  ACMFeePremCrdtAmount,
  ACMFeePremCrdtCrcy,
  ACMFeePremCrdtQty,
  ACMFeePremCrdtUoM,
  ACMNoPrcgFeeIdfr
FROM I_ACMTradingContractHdrFeeData AS fee
INNER JOIN I_ACMFeeCurrencyDecimal AS feeCustmCurr ON /* join condition not captured in parsed metadata */
;

Learn More