R_ACMTrdgContrHdrFeeDetsTP

DDL: R_ACMTRDGCONTRHDRFEEDETSTP SQL: RACMCONHDRFEETP Type: view_entity TRANSACTIONAL
17 Fields 1 Data Sources

Transaction Processing View: Contract Header Fee Details

R_ACMTrdgContrHdrFeeDetsTP is a Transactional CDS View that provides data about "Transaction Processing View: Contract Header Fee Details" in SAP S/4HANA. It reads from 1 data source (I_ACMTrdgContrFeeDets) and exposes 17 fields with key fields TradingContractNumber, ACMFeeFrameworkRefDocYear, FeeSequenceNumber, FeeFrameworkFeeID, FeeVersion.

Data Sources (1)

SourceAliasJoin Type
I_ACMTrdgContrFeeDets I_ACMTrdgContrFeeDets from

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: Contract Header Fee Details view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber TradingContractNumber Trading Contract
KEY ACMFeeFrameworkRefDocYear ACMFeeFrameworkRefDocYear
KEY FeeSequenceNumber ACMFeeFrameworkRefDocSqncNmbr
KEY FeeFrameworkFeeID FeeFrameworkFeeID
KEY FeeVersion FeeVersion
ACMFeeFrameworkDocTypeRef ACMFeeFrameworkDocTypeRef
TradingContractItem TradingContractItem Item Number
ACMFeeFrameworkRefDocSubItem ACMFeeFrameworkRefDocSubItem
ACMFeeValidStatus ACMFeeValidStatus
ACMFeeIsObsolete ACMFeeIsObsolete
FeeFrameworkFeeName FeeFrameworkFeeName
ACMFeeType ACMFeeType
ACMFeeAmount ACMFeeAmount
ACMFeeCurrency ACMFeeCurrency
ACMFeeQuantity ACMFeeQuantity
ACMFeeUoM ACMFeeUoM
_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_ACMTrdgContrHdrFeeDetsTP.
-- 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: RACMCONHDRFEETP

CREATE VIEW R_ACMTrdgContrHdrFeeDetsTP AS
SELECT
  TradingContractNumber,
  ACMFeeFrameworkRefDocYear,
  ACMFeeFrameworkRefDocSqncNmbr AS FeeSequenceNumber,
  FeeFrameworkFeeID,
  FeeVersion,
  ACMFeeFrameworkDocTypeRef,
  TradingContractItem,
  ACMFeeFrameworkRefDocSubItem,
  ACMFeeValidStatus,
  ACMFeeIsObsolete,
  FeeFrameworkFeeName,
  ACMFeeType,
  ACMFeeAmount,
  ACMFeeCurrency,
  ACMFeeQuantity,
  ACMFeeUoM
FROM I_ACMTrdgContrFeeDets
;

Learn More