C_CollectionsAccountKeyFigure

DDL: C_COLLECTIONSACCOUNTKEYFIGURE Type: view_entity CONSUMPTION

Collections Account Key Figure

C_CollectionsAccountKeyFigure is a Consumption CDS View that provides data about "Collections Account Key Figure" in SAP S/4HANA. It reads from 1 data source (R_CollectionsAccountKeyFigure) and exposes 12 fields with key fields BusinessPartner, CollectionSegment.

Data Sources (1)

SourceAliasJoin Type
R_CollectionsAccountKeyFigure R_CollectionsAccountKeyFigure projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Collections Account Key Figure view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey CollectionSegment view
Metadata.allowExtensions true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
KEY CollectionSegment CollectionSegment Segment
CollectionStrategy CollectionStrategy
CollectionsStrategyVersion CollectionsStrategyVersion
CollectionWorklistRun CollectionWorklistRun
WorklistItemCreationDate WorklistItemCreationDate
OutstandingAmount OutstandingAmount
Currency Currency Valuation Crcy
virtualUICT_CollectableAmountboolean
_BusinessPartner _BusinessPartner
_CollectionSegment _CollectionSegment
_CollectionsStrategy _CollectionsStrategy

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 C_CollectionsAccountKeyFigure.
-- 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.

CREATE VIEW C_CollectionsAccountKeyFigure AS
SELECT
  BusinessPartner,
  CollectionSegment,
  CollectionStrategy,
  CollectionsStrategyVersion,
  CollectionWorklistRun,
  WorklistItemCreationDate,
  OutstandingAmount,
  Currency,
  virtual UICT_CollectableAmount : boolean AS virtualUICT_CollectableAmountboolean
FROM R_CollectionsAccountKeyFigure
;