I_CADocumentCube

DDL: I_CADOCUMENTCUBE Type: view_entity COMPOSITE

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.

Data Sources (1)

SourceAliasJoin Type
I_CADocument I_CADocument from

Annotations (11)

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.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_CUBE 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 _ApplArea
_CompCode _CompCode
_Currency _Currency
_DocOriginCode _DocOriginCode
_DocType _DocType
_WorkflowCheckProcess _WorkflowCheckProcess
_WorkflowCheckReason _WorkflowCheckReason
@AbapCatalog.viewEnhancementCategory: [#NONE]

@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.supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                                      #SQL_DATA_SOURCE,
                                      #CDS_MODELING_DATA_SOURCE,
                                      #EXTRACTION_DATA_SOURCE,
                                      #ANALYTICAL_PROVIDER  ]

@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}

@ObjectModel.modelingPattern: #ANALYTICAL_CUBE

@VDM.viewType: #COMPOSITE

define view entity I_CADocumentCube
  as select from I_CADocument

{
  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 */
      _ApplArea,
      _CompCode,
      _Currency,
      _DocOriginCode,
      _DocType,
      _WorkflowCheckProcess,
      _WorkflowCheckReason
}