I_CADocumentCube

DDL: I_CADOCUMENTCUBE Type: view_entity COMPOSITE Package: FKK_DOCUMENT

Contract Accounting Document - Cube

I_CADocumentCube is a Composite CDS View (Cube) that provides data about "Contract Accounting Document - Cube" in SAP S/4HANA. It reads from 1 data source (I_CADocument) and exposes 42 fields with key field CADocumentNumber. It has 1 association to related views. Part of development package FKK_DOCUMENT.

Data Sources (1)

SourceAliasJoin Type
I_CADocument I_CADocument from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_CADocumentHeader _Extension $projection.CADocumentNumber = _Extension.CADocumentNumber

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
EndUserText.label Contract Accounting Document - Cube view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ObjectModel.sapObjectNodeType.name ContrAcctgDocument view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
CATaxCompanyCode CATaxCompanyCode
CATaxCodeWasExchanged CATaxCodeWasExchanged
TaxReportingDate TaxReportingDate
CAReconciliationKey CAReconciliationKey
CASeparateDocIsCreatedInGL CASeparateDocIsCreatedInGL
CARequestedPeriodForGLTransfer CARequestedPeriodForGLTransfer
CAApplicationArea CAApplicationArea
CADocumentType CADocumentType
CADocumentOriginCode CADocumentOriginCode
TransactionCurrency TransactionCurrency
DocumentDate DocumentDate
CAPostingDate CAPostingDate
ExchangeRateDate ExchangeRateDate
CAReferenceDocument CAReferenceDocument
CAReturnReason CAReturnReason
CAPostingReason CAPostingReason
ReferenceDocumentType ReferenceDocumentType
OriginalReferenceDocument OriginalReferenceDocument
CAReversedDocumentNumber CAReversedDocumentNumber
CAClearingInformation CAClearingInformation
CAReversalDocumentNumber CAReversalDocumentNumber
CADocumentSupplements CADocumentSupplements
LogicalSystem LogicalSystem
CAWorkflowCheckReason CAWorkflowCheckReason
CAWorkflowCheckProcess CAWorkflowCheckProcess
CADocumentTransactionClass CADocumentTransactionClass
CADocContainsCashFlowItems CADocContainsCashFlowItems
CADocumentClass CADocumentClass
CADocumentVersion CADocumentVersion
IsIndividualPosting IsIndividualPosting
CADocumentIsAged CADocumentIsAged
_ApplArea _CAApplicationArea
_DocOriginCode _CADocumentOriginCode
_DocType _CADocumentType
_CompCode _CATaxCompanyCode
_WorkflowCheckProcess _CAWorkflowCheckProcess
_WorkflowCheckReason _CAWorkflowCheckReason
_Currency _TransactionCurrency
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]

@AccessControl.authorizationCheck: #NOT_REQUIRED

@Analytics: { dataCategory: #CUBE,
              internalName: #LOCAL,
              dataExtraction: { enabled: true,
                                delta.changeDataCapture: { mapping:[ { table           : 'dfkkko',role: #MAIN,
                                                                       viewElement     : ['CADocumentNumber' ],
                                                                       tableElement    : ['opbel' ] } ] } } }

@EndUserText.label: 'Contract Accounting Document - Cube'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel:{ modelingPattern: #ANALYTICAL_CUBE,
               sapObjectNodeType.name: 'ContrAcctgDocument',
               supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                                        #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE,
                                        #EXTRACTION_DATA_SOURCE,
                                        #ANALYTICAL_PROVIDER  ],
               usageType:{ serviceQuality: #C,
                           sizeCategory: #XXL,
                           dataClass: #TRANSACTIONAL } }

@VDM.viewType: #COMPOSITE

define view entity I_CADocumentCube
  as select from I_CADocument
  
  // Key User Extensibility. Is registerd in transaction SCFD_REGISTRY. Do not change E_CADocumentHeader or alias _Extension without adopting CFD regestry entry

  association [1..1] to E_CADocumentHeader as _Extension on  $projection.CADocumentNumber = _Extension.CADocumentNumber

{
  key CADocumentNumber,
      CreatedByUser,
      CreationDate,
      CreationTime,
      @ObjectModel.foreignKey.association: '_CompCode'
      CATaxCompanyCode,
      CAStorageLocationOfTaxSuplmnt,
      CATaxCodeWasExchanged,
      TaxReportingDate,
      CAReconciliationKey,
      CASeparateDocIsCreatedInGL,
      CARequestedPeriodForGLTransfer,
      @ObjectModel.foreignKey.association: '_ApplArea'
      CAApplicationArea,
      @ObjectModel.foreignKey.association: '_DocType'
      CADocumentType,
      @ObjectModel.foreignKey.association: '_DocOriginCode'
      CADocumentOriginCode,
      @ObjectModel.foreignKey.association: '_Currency'
      TransactionCurrency,
      DocumentDate,
      CAPostingDate,
      ExchangeRateDate,
      CAReferenceDocument,
      CAReturnReason,
      CAPostingReason,
      ReferenceDocumentType,
      OriginalReferenceDocument,
      CAReversedDocumentNumber,
      CAClearingInformation,
      CAReversalDocumentNumber,
      CADocumentSupplements,
      LogicalSystem,
      @ObjectModel.foreignKey.association: '_WorkflowCheckReason'
      CAWorkflowCheckReason,
      @ObjectModel.foreignKey.association: '_WorkflowCheckProcess'
      CAWorkflowCheckProcess,
      CADocumentTransactionClass,
      CADocContainsCashFlowItems,
      CADocumentClass,
      CADocumentVersion,
      IsIndividualPosting,
      CADocumentIsAged,

      /* Associations */
      _CAApplicationArea      as _ApplArea,
      _CADocumentOriginCode   as _DocOriginCode,
      _CADocumentType         as _DocType,
      _CATaxCompanyCode       as _CompCode,
      _CAWorkflowCheckProcess as _WorkflowCheckProcess,
      _CAWorkflowCheckReason  as _WorkflowCheckReason,
      _TransactionCurrency    as _Currency
}