I_SettlementGroupFeeDetails

DDL: I_SETTLEMENTGROUPFEEDETAILS SQL: ISTLGRPFEE Type: view COMPOSITE
20 Fields 4 Data Sources

Interface Layer for Settlement Group Fee Data

I_SettlementGroupFeeDetails (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

I_SettlementGroupFeeDetails is a Composite CDS View that provides data about "Interface Layer for Settlement Group Fee Data" in SAP S/4HANA. It reads from 4 data sources (I_ACMFeeDetails, P_GenericDomainVH, P_GenericDomainVH, P_GenericDomainVH) and exposes 20 fields with key fields FeeDocumentLevel, ACMFeeReferenceDocumentID, ACMFeeReferenceDocumentItem, ACMFeeReferenceDocumentSubItem, RefDocumentYear.

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentLO-AGR-STL
CapabilitiesData Source for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (4)

SourceAliasJoin Type
I_ACMFeeDetails I_ACMFeeDetails from
P_GenericDomainVH P_GenericDomainVH left_outer
P_GenericDomainVH P_GenericDomainVH left_outer
P_GenericDomainVH P_GenericDomainVH left_outer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISTLGRPFEE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Interface Layer for Settlement Group Fee Data view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY FeeDocumentLevel FeeDocumentLevel TSW Document type
KEY ACMFeeReferenceDocumentID ACMFeeReferenceDocumentID Reference Document ID
KEY ACMFeeReferenceDocumentItem ACMFeeReferenceDocumentItem Reference Document Item
KEY ACMFeeReferenceDocumentSubItem ACMFeeReferenceDocumentSubItem Reference Document Sub-Item
KEY RefDocumentYear RefDocumentYear Reference Document Year
KEY FeeSequenceNumber FeeSequenceNumber Reference Document Sequence Number
KEY FeeFrameworkFeeID FeeFrameworkFeeID Fee ID (Fee Framework)
KEY FeeVersion FeeVersion Fee Version
FeeFrameworkFeeName FeeFrameworkFeeName Fee Name
FeeFrameworkFeeRate FeeFrameworkFeeRate Tax Rate
ACMFeeCurrency ACMFeeCurrency Valuation Crcy
PriceUnitQty PriceUnitQty Price unit
UnitOfMeasure UnitOfMeasure Unit of Measure for Fee
FeeAllocationMode FeeAllocationMode Allocation Mode
FeeAllocationModeName AllocationMode DomainText Short Text for Fixed Values
ACMFeeIsObsolete ACMFeeIsObsolete Fee Marked Obsolete
ACMAssignedFeeDecimalPlaces ACMAssignedFeeDecimalPlaces Decimal Places
ACMFeeValidStatus ACMFeeValidStatus Fee Valid Status
ACMFeeValidStatusName ValidStatus DomainText Short Text for Fixed Values
FeeDocumentLevelName FeeDocType DomainText Short Text for Fixed Values

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_SettlementGroupFeeDetails.
-- 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: ISTLGRPFEE

CREATE VIEW I_SettlementGroupFeeDetails AS
SELECT
  FeeDocumentLevel,
  ACMFeeReferenceDocumentID,
  ACMFeeReferenceDocumentItem,
  ACMFeeReferenceDocumentSubItem,
  RefDocumentYear,
  FeeSequenceNumber,
  FeeFrameworkFeeID,
  FeeVersion,
  FeeFrameworkFeeName,
  FeeFrameworkFeeRate,
  ACMFeeCurrency,
  PriceUnitQty,
  UnitOfMeasure,
  FeeAllocationMode,
  AllocationMode.DomainText AS FeeAllocationModeName,
  ACMFeeIsObsolete,
  ACMAssignedFeeDecimalPlaces,
  ACMFeeValidStatus,
  ValidStatus.DomainText AS ACMFeeValidStatusName,
  FeeDocType.DomainText AS FeeDocumentLevelName
FROM I_ACMFeeDetails
LEFT OUTER JOIN P_GenericDomainVH ON /* join condition not captured in parsed metadata */
;

Learn More