R_ACMTrdgContrItmFeeDetsTP

DDL: R_ACMTRDGCONTRITMFEEDETSTP SQL: RACMCONITMFEETP Type: view_entity TRANSACTIONAL
18 Fields 1 Data Sources 1 Associations

Transaction Processing View: Fee Details

R_ACMTrdgContrItmFeeDetsTP is a Transactional CDS View that provides data about "Transaction Processing View: Fee Details" in SAP S/4HANA. It reads from 1 data source (I_ACMTrdgContrFeeDets) and exposes 18 fields with key fields TradingContractNumber, TradingContractItem, ACMFeeFrameworkRefDocYear, FeeSequenceNumber, FeeFrameworkFeeID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ACMTrdgContrFeeDets I_ACMTrdgContrFeeDets from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_ACMTrdgContrHdrTP _ContractHeader $projection.TradingContractNumber = _ContractHeader.TradingContractNumber

Annotations (7)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transaction Processing View: Fee Details view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber TradingContractNumber Trading Contract
KEY TradingContractItem TradingContractItem Item Number
KEY ACMFeeFrameworkRefDocYear ACMFeeFrameworkRefDocYear
KEY FeeSequenceNumber ACMFeeFrameworkRefDocSqncNmbr
KEY FeeFrameworkFeeID FeeFrameworkFeeID
KEY FeeVersion FeeVersion
ACMFeeFrameworkDocTypeRef ACMFeeFrameworkDocTypeRef
ACMFeeFrameworkRefDocSubItem ACMFeeFrameworkRefDocSubItem
ACMFeeValidStatus ACMFeeValidStatus
ACMFeeIsObsolete ACMFeeIsObsolete
FeeFrameworkFeeName FeeFrameworkFeeName
ACMFeeType ACMFeeType
ACMFeeAmount ACMFeeAmount
ACMFeeCurrency ACMFeeCurrency
ACMFeeQuantity ACMFeeQuantity
ACMFeeUoM ACMFeeUoM
_ContractItem _ContractItem
_ContractHeader _ContractHeader

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 R_ACMTrdgContrItmFeeDetsTP.
-- 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: RACMCONITMFEETP

CREATE VIEW R_ACMTrdgContrItmFeeDetsTP AS
SELECT
  TradingContractNumber,
  TradingContractItem,
  ACMFeeFrameworkRefDocYear,
  ACMFeeFrameworkRefDocSqncNmbr AS FeeSequenceNumber,
  FeeFrameworkFeeID,
  FeeVersion,
  ACMFeeFrameworkDocTypeRef,
  ACMFeeFrameworkRefDocSubItem,
  ACMFeeValidStatus,
  ACMFeeIsObsolete,
  FeeFrameworkFeeName,
  ACMFeeType,
  ACMFeeAmount,
  ACMFeeCurrency,
  ACMFeeQuantity,
  ACMFeeUoM
FROM I_ACMTrdgContrFeeDets
LEFT OUTER JOIN R_ACMTrdgContrHdrTP AS _ContractHeader ON TradingContractNumber = _ContractHeader.TradingContractNumber  -- association [1..1]
;

Learn More