I_ACMTrdgContrPrcgLotFeeDetail

DDL: I_ACMTRDGCONTRPRCGLOTFEEDETAIL SQL: IACMCONTPLOTFEE Type: view COMPOSITE
39 Fields 1 Data Sources

Trading Contract Price Lot Fee Details

I_ACMTrdgContrPrcgLotFeeDetail is a Composite CDS View that provides data about "Trading Contract Price Lot Fee Details" in SAP S/4HANA. It reads from 1 data source (I_ACMTradingContractHdrFeeData) and exposes 39 fields with key fields ACMFeeFrameworkDocTypeRef, ACMFeeFrameworkRefDocID, ACMFeeFrameworkRefDocumentItem, ACMFeeFrameworkRefDocSubItem, ACMFeeFrameworkRefDocYear.

Data Sources (1)

SourceAliasJoin Type
I_ACMTradingContractHdrFeeData I_ACMTradingContractHdrFeeData from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IACMCONTPLOTFEE 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 Price Lot Fee Details view

Fields (39)

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 ACMFeeCurrency Valuation Crcy
ACMFeeQuantity ACMFeeQuantity Value
ACMFeeUoM ACMFeeUoM UoM: Conv. to
ACMFeeFrameworkAllocationMode ACMFeeFrameworkAllocationMode Allocation Mode
FeeAllocationModeName AllocationMode DomainText Short Description
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_ACMTrdgContrPrcgLotFeeDetail.
-- 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: IACMCONTPLOTFEE

CREATE VIEW I_ACMTrdgContrPrcgLotFeeDetail 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,
  ACMFeeCurrency,
  ACMFeeQuantity,
  ACMFeeUoM,
  ACMFeeFrameworkAllocationMode,
  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_ACMTradingContractHdrFeeData
;

Learn More