I_CAWriteOffDocument

DDL: I_CAWRITEOFFDOCUMENT Type: view_entity COMPOSITE

Contract Accounting Write Off Document

I_CAWriteOffDocument is a Composite CDS View that provides data about "Contract Accounting Write Off Document" in SAP S/4HANA. It reads from 1 data source (I_CADocument) and exposes 53 fields with key field CAWriteOffDocumentNumber.

Data Sources (1)

SourceAliasJoin Type
I_CADocument I_CADocument from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Contract Accounting Write Off Document view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CAWriteOffDocumentNumber view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (53)

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
CADocumentIsAged CADocumentIsAged
_ApplArea _ApplArea
_CAClearingInformation _CAClearingInformation
_CADocTransactionClass _CADocTransactionClass
_CADocumentClass _CADocumentClass
_CADocumentSupplement _CADocumentSupplement
_CADocumentVersion _CADocumentVersion
_CAPostingReason _CAPostingReason
_CARequestedSpecialPeriod _CARequestedSpecialPeriod
_CAReturnReason _CAReturnReason
_CATaxSupplementStorageLoc _CATaxSupplementStorageLoc
_CompCode _CompCode
_Currency _Currency
_DocOriginCode _DocOriginCode
_DocType _DocType
_WorkflowCheckProcess _WorkflowCheckProcess
_WorkflowCheckReason _WorkflowCheckReason
@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #MANDATORY

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

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: { representativeKey: 'CAWriteOffDocumentNumber',
                supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                                         #SQL_DATA_SOURCE,
                                         #CDS_MODELING_DATA_SOURCE ] }

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

@VDM.viewType: #COMPOSITE

define view entity I_CAWriteOffDocument
  as select from I_CADocument

{
  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,
      CADocumentIsAged,

      /* Associations */
      _ApplArea,
      _CAClearingInformation,
      _CADocTransactionClass,
      _CADocumentClass,
      _CADocumentSupplement,
      _CADocumentVersion,
      _CAPostingReason,
      _CARequestedSpecialPeriod,
      _CAReturnReason,
      _CATaxSupplementStorageLoc,
      _CompCode,
      _Currency,
      _DocOriginCode,
      _DocType,
      _WorkflowCheckProcess,
      _WorkflowCheckReason

}
where
     CADocumentOriginCode = '16'
  or CADocumentOriginCode = '17'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CADOCUMENT"
],
"ASSOCIATED":
[
"I_CAAPPLICATIONAREA",
"I_CACLEARINGINFORMATION",
"I_CADOCTRANSACTIONCLASS",
"I_CADOCUMENTCLASS",
"I_CADOCUMENTORIGINCODE",
"I_CADOCUMENTSUPPLEMENT",
"I_CADOCUMENTTYPE",
"I_CADOCUMENTVERSION",
"I_CAPOSTINGREASON",
"I_CAREQUESTEDSPECIALPERIOD",
"I_CARETURNREASON",
"I_CATAXSUPPLEMENTSTORAGELOC",
"I_CAWORKFLOWCHECKPROCESS",
"I_CAWORKFLOWCHECKREASON",
"I_COMPANYCODE",
"I_CURRENCY"
],
"BASE":
[
"I_CADOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/