I_FinCopItemCube

DDL: I_FINCOPITEMCUBE Type: view_entity COMPOSITE Package: FCLM_PLANNING

Cop Item - Cube

I_FinCopItemCube (Composite)

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

Cash Flow Certainty Level · Financial Operations

I_FinCopItemCube is a Composite CDS View (Cube) that provides data about "Cop Item - Cube" in SAP S/4HANA. It reads from 1 data source (I_CashFlow) and exposes 15 fields with key fields OriginSystem, OriginApplication, OriginDocument, OriginTransaction, OriginTransactionQualifier. Part of development package FCLM_PLANNING.

SAP Help Documentation

CategoryCDS Views for Cash and Liquidity Management
Data CategoryCube
Purpose
This CDS view provides the data to get some fields of valid cash flows. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: F_FDSR_BUK in Company Code The activity level with the display authorization

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute OriginSystem Logical system Attribute OriginApplication Source Application Attribute OriginDocument Source Document ID Attribute OriginTransaction Source Transaction ID Attribute OriginTransactionQualifier Source Transaction Qualifier Attribute CashFlow Line Item in Source Document Attribute ValidFrom UTC Time Stamp in Long Form (YYYYMMDD) Measure ValidTo UTC Time Stamp in Long Form (YYYYMMDD) Measure BankAccountInternalID Bank Account Technical ID Attribute CompanyCode Company Code Attribute CertaintyLevel Certainty Level Attribute LiquidityItem Liquidity Item Attribute TransactionCurrency Currency Attribute TransactionDate Transaction Date Attribute AmountInTransactionCurrency Amount Measure

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-CLM-2CL
CapabilitiesData Provider for Analytical Queries
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageFinancial Operations for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the data to get some fields of valid cash flows.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_CashFlow flow from

Annotations (14)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed false view
EndUserText.label Cop Item - Cube view
Analytics.dataCategory #CUBE view
Analytics.technicalName IFCOPITEMCUBE view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.sapObjectNodeType.name CashFlowCertaintyLevel view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY OriginSystem I_CashFlow OriginSystem LogSys: Formula
KEY OriginApplication I_CashFlow OriginApplication Origin Application
KEY OriginDocument I_CashFlow OriginDocument Source Document ID
KEY OriginTransaction I_CashFlow OriginTransaction Source Transaction ID
KEY OriginTransactionQualifier I_CashFlow OriginTransactionQualifier Source Transaction Qualifier
KEY CashFlow I_CashFlow CashFlow Line Item in Source Document
KEY ValidFrom I_CashFlow ValidFrom UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
KEY ValidTo I_CashFlow ValidTo UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
KEY BankAccountInternalID I_CashFlow BankAccountInternalID Bank Account Technical ID
CompanyCode CompanyCode Receiver Company Code
CertaintyLevel CertaintyLevel Certainty Level
LiquidityItem LiquidityItem Liquidity Item
TransactionCurrency TransactionCurrency Transaction Currency
TransactionDate TransactionDate Transaction Date
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt

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_FinCopItemCube.
-- 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 I_FinCopItemCube AS
SELECT
  flow.OriginSystem AS OriginSystem,
  flow.OriginApplication AS OriginApplication,
  flow.OriginDocument AS OriginDocument,
  flow.OriginTransaction AS OriginTransaction,
  flow.OriginTransactionQualifier AS OriginTransactionQualifier,
  flow.CashFlow AS CashFlow,
  flow.ValidFrom AS ValidFrom,
  flow.ValidTo AS ValidTo,
  flow.BankAccountInternalID AS BankAccountInternalID,
  CompanyCode,
  CertaintyLevel,
  LiquidityItem,
  TransactionCurrency,
  TransactionDate,
  AmountInTransactionCurrency
FROM I_CashFlow AS flow
;