I_ACMTradingContractItemFeeDet

DDL: I_ACMTRADINGCONTRACTITEMFEEDET SQL: IACMCONTITEMFEE Type: view COMPOSITE
55 Fields 2 Data Sources

Trading Contract Item Fee Details

I_ACMTradingContractItemFeeDet is a Composite CDS View that provides data about "Trading Contract Item Fee Details" in SAP S/4HANA. It reads from 2 data sources (I_ACMTradingContractHdrFeeData, I_ACMFeeCurrencyDecimal) and exposes 55 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 IACMCONTITEMFEE 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 Trading Contract Item Fee Details view

Fields (55)

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.
ACMFeeType ACMFeeType Fee Type
ACMFeeTypeName FeeType DomainText Short Description
FeeFrameworkFeeName FeeFrameworkFeeName Fee Name
FeeDocumentLevelName FeeDocType DomainText Short Description
ACMFeeValidStatus ACMFeeValidStatus Fee Valid Status
ACMFeeValidStatusName ValidStatus DomainText Short Description
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
ACMFeeGovDateEvent ACMFeeGovDateEvent Governing Date Event
ACMFeeGovEndDateEvent ACMFeeGovEndDateEvent Governing Date Event
ACMFeeInchargeAmount ACMFeeInchargeAmount Incharge Rate
ACMInChargeAmtCrcy ACMInChargeAmtCrcy In Charge Currency
ACMInchargeQty ACMInchargeQty In Charge Quantity
ACMInchargeQtyUoM ACMInchargeQtyUoM In Charge UoM
ACMInchargeBeginDate ACMInchargeBeginDate In Charge Begin Date
ACMInchargeEndDate ACMInchargeEndDate In Charge End Date
ACMFeeRecrrgChrgAmount ACMFeeRecrrgChrgAmount Recurring Charge Rat
ACMFeeRecrrgChrgCrcy ACMFeeRecrrgChrgCrcy Rec. Charge Currency
ACMFeeRecrrgChrgQty ACMFeeRecrrgChrgQty Rec Charge Quantity
ACMFeeRecrrgChrgUoM ACMFeeRecrrgChrgUoM Rec. Charge UoM
ACMFeeRecChargeBegDateEvent ACMFeeRecChargeBegDateEvent Rec. Charge Start DE
ACMFeeRecChargeEndDateEvent ACMFeeRecChargeEndDateEvent Rec Charg End D Even
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
ACMFeePremCreditGovEvent ACMFeePremCreditGovEvent Governing Date Event
ACMFeePremCreditEndDateEvent ACMFeePremCreditEndDateEvent Governing Date Event
ACMFeeGovDateEventTxt GovDateEventText DomainText Short Description
ACMFeeGovEndDateEventTxt GovEndDateEventText DomainText Short Description
ACMFeeRecChargeBegDateEventTxt RecChargeBegDateEventText DomainText Short Description
ACMFeeRecChargeEndDateEventTxt RecChargeEndDateEventText DomainText Short Description
ACMFeePremCreditGovEventTxt PremCreditGovEventText DomainText Short Description
ACMFeePremCrdtEndDteEvtTxt PremCreditEndDateEventText DomainText Short Description

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_ACMTradingContractItemFeeDet.
-- 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: IACMCONTITEMFEE

CREATE VIEW I_ACMTradingContractItemFeeDet AS
SELECT
  ACMFeeFrameworkDocTypeRef,
  ACMFeeFrameworkRefDocID,
  ACMFeeFrameworkRefDocumentItem,
  ACMFeeFrameworkRefDocSubItem,
  ACMFeeFrameworkRefDocYear,
  ACMFeeFrameworkRefDocSqncNmbr,
  FeeFrameworkFeeID,
  FeeVersion,
  ACMFeeType,
  FeeType.DomainText AS ACMFeeTypeName,
  FeeFrameworkFeeName,
  FeeDocType.DomainText AS FeeDocumentLevelName,
  ACMFeeValidStatus,
  ValidStatus.DomainText AS ACMFeeValidStatusName,
  ACMFeeAmount,
  fee.ACMFeeCurrency AS ACMFeeCurrency,
  ACMFeeQuantity,
  ACMFeeUoM,
  ACMFeeFrameworkAllocationMode,
  AllocationMode.DomainText AS FeeAllocationModeName,
  feeCustmCurr.ACMFeeCurrency AS ACMFeeExtCurrency,
  fee.ACMDecimalPlace AS ACMDecimalPlace,
  ACMFeeStopOnPrvsnlSettlmt,
  ACMFeeStopOnFinalSettlmt,
  ACMFeeGovDateEvent,
  ACMFeeGovEndDateEvent,
  ACMFeeInchargeAmount,
  ACMInChargeAmtCrcy,
  ACMInchargeQty,
  ACMInchargeQtyUoM,
  ACMInchargeBeginDate,
  ACMInchargeEndDate,
  ACMFeeRecrrgChrgAmount,
  ACMFeeRecrrgChrgCrcy,
  ACMFeeRecrrgChrgQty,
  ACMFeeRecrrgChrgUoM,
  ACMFeeRecChargeBegDateEvent,
  ACMFeeRecChargeEndDateEvent,
  ACMFeeMaxChargeAmount,
  ACMFeeMaxChrgCrcy,
  ACMFeeMaxChargeQuantity,
  ACMFeeMaxChargeUoM,
  ACMFeePremCrdtAmount,
  ACMFeePremCrdtCrcy,
  ACMFeePremCrdtQty,
  ACMFeePremCrdtUoM,
  ACMNoPrcgFeeIdfr,
  ACMFeePremCreditGovEvent,
  ACMFeePremCreditEndDateEvent,
  GovDateEventText.DomainText AS ACMFeeGovDateEventTxt,
  GovEndDateEventText.DomainText AS ACMFeeGovEndDateEventTxt,
  RecChargeBegDateEventText.DomainText AS ACMFeeRecChargeBegDateEventTxt,
  RecChargeEndDateEventText.DomainText AS ACMFeeRecChargeEndDateEventTxt,
  PremCreditGovEventText.DomainText AS ACMFeePremCreditGovEventTxt,
  PremCreditEndDateEventText.DomainText AS ACMFeePremCrdtEndDteEvtTxt
FROM I_ACMTradingContractHdrFeeData AS fee
INNER JOIN I_ACMFeeCurrencyDecimal AS feeCustmCurr ON /* join condition not captured in parsed metadata */
;

Learn More