I_CAWriteOffDocument

DDL: I_CAWRITEOFFDOCUMENT Type: view_entity COMPOSITE Package: FKK_WRITEOFF

Contract Accounting Write Off Document

I_CAWriteOffDocument is a Composite CDS View (Dimension) that provides data about "Contract Accounting Write Off Document" in SAP S/4HANA. It reads from 1 data source (I_CADocument) and exposes 52 fields with key field CAWriteOffDocumentNumber. It has 1 association to related views. Part of development package FKK_WRITEOFF.

Data Sources (1)

SourceAliasJoin Type
I_CADocument I_CADocument from

Associations (1)

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

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
EndUserText.label Contract Accounting Write Off Document view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey CAWriteOffDocumentNumber view
ObjectModel.sapObjectNodeType.name ContrAcctgWriteOff view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY CAWriteOffDocumentNumber CADocumentNumber
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
CATaxCompanyCode CATaxCompanyCode
CATaxCodeWasExchanged CATaxCodeWasExchanged
TaxReportingDate TaxReportingDate
CAReconciliationKey CAReconciliationKey
CASeparateDocIsCreatedInGL CASeparateDocIsCreatedInGL
CARequestedPeriodForGLTransfer CARequestedPeriodForGLTransfer
CAApplicationArea CAApplicationArea
CADocumentType CADocumentType
CADocumentOriginCode CADocumentOriginCode
TransactionCurrency TransactionCurrency
DocumentDate DocumentDate
CAWriteOffDate CAPostingDate
ExchangeRateDate ExchangeRateDate
CAReferenceDocument CAReferenceDocument
CAReturnReason CAReturnReason
CAWriteOffReason 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
_CAApplicationArea _CAApplicationArea
_CAClearingInformation _CAClearingInformation
_CADocTransactionClass _CADocTransactionClass
_CADocumentClass _CADocumentClass
_CADocumentOriginCode _CADocumentOriginCode
_CADocumentSupplement _CADocumentSupplement
_CADocumentType _CADocumentType
_CADocumentVersion _CADocumentVersion
_CAPostingReason _CAPostingReason
_CARequestedSpecialPeriod _CARequestedSpecialPeriod
_CAReturnReason _CAReturnReason
_CATaxSupplementStorageLoc _CATaxSupplementStorageLoc
_CATaxCompanyCode _CATaxCompanyCode
_CAWorkflowCheckProcess _CAWorkflowCheckProcess
_CAWorkflowCheckReason _CAWorkflowCheckReason
_TransactionCurrency _TransactionCurrency
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]

@AccessControl.authorizationCheck: #MANDATORY
                                                                    

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


@EndUserText.label: 'Contract Accounting Write Off Document'

@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true

@ObjectModel: { modelingPattern:#ANALYTICAL_DIMENSION,
                representativeKey: 'CAWriteOffDocumentNumber',
                sapObjectNodeType.name: 'ContrAcctgWriteOff',
                supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                                         #SQL_DATA_SOURCE,
                                         #CDS_MODELING_DATA_SOURCE,
                                         #ANALYTICAL_DIMENSION,
                                         #ANALYTICAL_PROVIDER,
                                         #EXTRACTION_DATA_SOURCE  
] }

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

@VDM.viewType: #COMPOSITE

define view entity I_CAWriteOffDocument
  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.CAWriteOffDocumentNumber = _Extension.CADocumentNumber
  
{
  key CADocumentNumber as CAWriteOffDocumentNumber,

      CreatedByUser,
      CreationDate,
      CreationTime,
      LastChangeDate,
      LastChangeTime,
      CATaxCompanyCode,
      CAStorageLocationOfTaxSuplmnt,
      CATaxCodeWasExchanged,
      TaxReportingDate,
      CAReconciliationKey,
      CASeparateDocIsCreatedInGL,
      CARequestedPeriodForGLTransfer,
      CAApplicationArea,
      CADocumentType,
      CADocumentOriginCode,
      TransactionCurrency,
      DocumentDate,
      CAPostingDate    as CAWriteOffDate,
      ExchangeRateDate,
      CAReferenceDocument,
      CAReturnReason,
      CAPostingReason  as CAWriteOffReason,
      ReferenceDocumentType,
      OriginalReferenceDocument,
      CAReversedDocumentNumber,
      CAClearingInformation,
      CAReversalDocumentNumber,
      CADocumentSupplements,
      LogicalSystem,
      CAWorkflowCheckReason,
      CAWorkflowCheckProcess,
      CADocumentTransactionClass,
      CADocContainsCashFlowItems,
      CADocumentClass,
      CADocumentVersion,
      IsIndividualPosting,

      /* Associations */
      _CAApplicationArea,
      _CAClearingInformation,
      _CADocTransactionClass,
      _CADocumentClass,
      _CADocumentOriginCode,
      _CADocumentSupplement,
      _CADocumentType,
      _CADocumentVersion,
      _CAPostingReason,
      _CARequestedSpecialPeriod,
      _CAReturnReason,
      _CATaxSupplementStorageLoc,
      _CATaxCompanyCode,
      _CAWorkflowCheckProcess,
      _CAWorkflowCheckReason,
      _TransactionCurrency

}
where
     CADocumentOriginCode = '16'
  or CADocumentOriginCode = '17'