I_FinCopItemCube

DDL: I_FINCOPITEMCUBE SQL: IFCOPITEMCUBE Type: view COMPOSITE

Cop Item - Cube

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.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_CashFlow flow from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IFCOPITEMCUBE view
EndUserText.label Cop Item - Cube view
Analytics.dataCategory #CUBE view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.sapObjectNodeType.name CashFlowCertaintyLevel view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY OriginSystem I_CashFlow OriginSystem
KEY OriginApplication I_CashFlow OriginApplication
KEY OriginDocument I_CashFlow OriginDocument
KEY OriginTransaction I_CashFlow OriginTransaction
KEY OriginTransactionQualifier I_CashFlow OriginTransactionQualifier
KEY CashFlow I_CashFlow CashFlow
KEY ValidFrom I_CashFlow ValidFrom
KEY ValidTo I_CashFlow ValidTo
KEY BankAccountInternalID I_CashFlow BankAccountInternalID
CompanyCode CompanyCode
CertaintyLevel CertaintyLevel
LiquidityItem LiquidityItem
TransactionCurrency TransactionCurrency
TransactionDate TransactionDate
AmountInTransactionCurrency AmountInTransactionCurrency 
@AbapCatalog.sqlViewName: 'IFCOPITEMCUBE'
@EndUserText.label: 'Cop Item - Cube'
@Analytics: { dataCategory: #CUBE }
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true
@AbapCatalog.preserveKey:true
//@Analytics.readClassName: 'CL_FCLM_LM_BALANCE_CDS'

@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.sapObjectNodeType.name:'CashFlowCertaintyLevel'
@ObjectModel.supportedCapabilities:[ #ANALYTICAL_PROVIDER ]
@ObjectModel.modelingPattern:[ #ANALYTICAL_CUBE ]
define view I_FinCopItemCube
  //with parameters

  //P_KeyDate : sydate,

  as select from I_CashFlow as flow

{
  key flow.OriginSystem,
  key flow.OriginApplication,
  key flow.OriginDocument,
  key flow.OriginTransaction,
  key flow.OriginTransactionQualifier,
  key flow.CashFlow,
  key flow.ValidFrom,
  key flow.ValidTo,
  key flow.BankAccountInternalID,
      CompanyCode,
      CertaintyLevel,
      LiquidityItem,
      @Semantics.currencyCode: true
      TransactionCurrency,
      TransactionDate,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      AmountInTransactionCurrency

}
where
      TransactionDate > '00010101'
  and IsValid         = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CASHFLOW"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More