What is I_CAWriteOffDocument in SAP S/4HANA?

I_CAWriteOffDocument is a composite CDS view in SAP S/4HANA. Contract Accounting Write Off Document It contains 52 fields.

Which tables does I_CAWriteOffDocument read from?

I_CAWriteOffDocument reads data from: I_CADocument.

What VDM layer is I_CAWriteOffDocument?

I_CAWriteOffDocument is classified as a Composite view that combines data from multiple basic views.

I_CAWriteOffDocument

DDL: I_CAWRITEOFFDOCUMENT Type: view_entity COMPOSITE Package: FKK_WRITEOFF

52 Fields 1 Data Sources 1 Associations

Contract Accounting Write Off Document

I_CAWriteOffDocument (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Contract Accounting Write-Off · Contract Accounting

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.

SAP Help Documentation

Category	CDS Views for Transaction Data
Data Category	Dimension

Purpose
This CDS view represents the write-off header data of a wite-off document in Contract Accounting . The most important data in the header structure of the write-off document is comprised of the posting date, reconciliation key, and write-off reason. This CDS view provides the prerequisites for answering the following business questions: How many write-offs were posted in Contract Accounting with a special write-off reason? How many premium write-offs were posted in Contract Accounting this year? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations The SAP_A4C_BC_DEV_TST_FICA_PC ( Development - API Test - Contract Accounting ) business catalog needs to be assigned to a user to be able to use this CDS view.

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture. Corresponding DataSource (Extractor) SAP does not deliver an extractor for write-offs. In SAP Business Warehouse (SAP BW) write-offs can be determined by the 0FC_CI_01 (FICA Cleared Items for Interval) DataSource.

View on SAP Help Portal →

SAP API Hub

Category	Composite
State	C1
Line of Business	Contract Accounting
Application Component	FI-CA-2CL
Capabilities	Data Source for Data Extraction,Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities,Analytical Dimension,Data Provider for Analytical Queries
Extensible (Key User)	Yes
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Contract Accounting for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view represents the write-off header data of a wite-off document in Contract Accounting.</p> <p>The most important data in the header structure of the write-off document is comprised of the posting date, reconciliation key, and write-off reason.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>How many write-offs were posted in Contract Accounting with a special write-off reason?</p></li> <li><p>How many premium write-offs were posted in Contract Accounting this year?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_CADocument	I_CADocument	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	E_CADocumentHeader	_Extension	`$projection.CAWriteOffDocumentNumber = _Extension.CADocumentNumber`

Annotations (14)

Name	Value	Level
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)

Key	Field	Source Field	Description
KEY	CAWriteOffDocumentNumber	CADocumentNumber	Number of a FI-CA Document
	CreatedByUser	CreatedByUser	Name of Person Responsible for Creating the Object
	CreationDate	CreationDate	Day On Which Accounting Document Was Entered
	CreationTime	CreationTime	Time of Change
	LastChangeDate	LastChangeDate	Last Changed On
	LastChangeTime	LastChangeTime	Time at Which the Object Was Last Changed
	CATaxCompanyCode	CATaxCompanyCode	Tax Company Code
	CATaxCodeWasExchanged	CATaxCodeWasExchanged	Tax Codes Were Exchanged
	TaxReportingDate	TaxReportingDate	Tax Reporting Date
	CAReconciliationKey	CAReconciliationKey	Reconciliation Key for General Ledger
	CASeparateDocIsCreatedInGL	CASeparateDocIsCreatedInGL	Create Separate Document in General Ledger
	CARequestedPeriodForGLTransfer	CARequestedPeriodForGLTransfer	Requested Special Period for Transfer to General Ledger
	CAApplicationArea	CAApplicationArea	Application Area
	CADocumentType	CADocumentType	Document Type
	CADocumentOriginCode	CADocumentOriginCode	Document Origin Key
	TransactionCurrency	TransactionCurrency	Transaction Currency
	DocumentDate	DocumentDate	Document Date in Document
	CAWriteOffDate	CAPostingDate	Posting Date in the Document
	ExchangeRateDate	ExchangeRateDate	Translation Date
	CAReferenceDocument	CAReferenceDocument	Reference Document Number
	CAReturnReason	CAReturnReason	Return Reason
	CAWriteOffReason	CAPostingReason	Posting Reason (For Write-Offs And Transfer Postings)
	ReferenceDocumentType	ReferenceDocumentType	Reference Document Type
	OriginalReferenceDocument	OriginalReferenceDocument	Reference Key
	CAReversedDocumentNumber	CAReversedDocumentNumber	Number of Reversed Document
	CAClearingInformation	CAClearingInformation	Clearing Information
	CAReversalDocumentNumber	CAReversalDocumentNumber	Number of Reversal Document
	CADocumentSupplements	CADocumentSupplements	Existing document supplements
	LogicalSystem	LogicalSystem	Logical System of Source Document
	CAWorkflowCheckReason	CAWorkflowCheckReason	Check Reason for Workflows Acc. to Dual Control Principle
	CAWorkflowCheckProcess	CAWorkflowCheckProcess	Editing Process to Be Confirmed
	CADocumentTransactionClass	CADocumentTransactionClass	Transaction Class of Document
	CADocContainsCashFlowItems	CADocContainsCashFlowItems	Document Contains Assignments from Cash Flows
	CADocumentClass	CADocumentClass	Document Class
	CADocumentVersion	CADocumentVersion	Version Number
	IsIndividualPosting	IsIndividualPosting	Individual Posting
	_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CAWriteOffDocument.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CAWriteOffDocument AS
SELECT
  CADocumentNumber AS CAWriteOffDocumentNumber,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeTime,
  CATaxCompanyCode,
  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
FROM I_CADocument
LEFT OUTER JOIN E_CADocumentHeader AS _Extension ON CAWriteOffDocumentNumber = _Extension.CADocumentNumber  -- association [1..1]
;

Depth:

I_CAWriteOffDocument view_entity

I_CADocument view_entity

R_CAWriteOffTP view_entity