I_CAWriteOffDocument
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)
| 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 | Field |
|---|---|---|---|
| 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 Table | Source Field | Description |
|---|---|---|---|---|
| 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'
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA