R_CAWriteOffTP

DDL: R_CAWRITEOFFTP Type: view_entity TRANSACTIONAL
52 Fields 1 Data Sources

Contract Accounting Write Off

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

Data Sources (1)

SourceAliasJoin Type
I_CAWriteOffDocument I_CAWriteOffDocument from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Contract Accounting Write Off view
ObjectModel.sapObjectNodeType.name ContrAcctgWriteOff view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY CAWriteOffDocumentNumber CAWriteOffDocumentNumber Document Number
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
CATaxCompanyCode CATaxCompanyCode Tax comp. code
CATaxCodeWasExchanged CATaxCodeWasExchanged New Tax Code
TaxReportingDate TaxReportingDate Tax Reporting Date
CAReconciliationKey CAReconciliationKey Reconcil. Key
CASeparateDocIsCreatedInGL CASeparateDocIsCreatedInGL Single Document
CARequestedPeriodForGLTransfer CARequestedPeriodForGLTransfer Special Period
CAApplicationArea CAApplicationArea ApplicationArea
CADocumentType CADocumentType Document Type
CADocumentOriginCode CADocumentOriginCode Document Origin
TransactionCurrency TransactionCurrency Transaction Currency
DocumentDate DocumentDate Journal Entry Date
CAWriteOffDate CAWriteOffDate Posting Date
ExchangeRateDate ExchangeRateDate Translatn Date
CAReferenceDocument CAReferenceDocument Reference
CAReturnReason CAReturnReason Return Reason
CAWriteOffReason CAWriteOffReason Posting Reason
ReferenceDocumentType ReferenceDocumentType Reference Document Type
OriginalReferenceDocument OriginalReferenceDocument Reference Key
CAReversedDocumentNumber CAReversedDocumentNumber Rev. Doc. For
CAClearingInformation CAClearingInformation Clearing Info
CAReversalDocumentNumber CAReversalDocumentNumber Revers.document
CADocumentSupplements CADocumentSupplements Doc supps
LogicalSystem LogicalSystem Logical System
CAWorkflowCheckReason CAWorkflowCheckReason Check Reason
CAWorkflowCheckProcess CAWorkflowCheckProcess Process
CADocumentTransactionClass CADocumentTransactionClass Transact.type
CADocContainsCashFlowItems CADocContainsCashFlowItems Cash Flow
CADocumentClass CADocumentClass Document Class
CADocumentVersion CADocumentVersion Version
IsIndividualPosting IsIndividualPosting Indiv. Posting
_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

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 R_CAWriteOffTP.
-- 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 R_CAWriteOffTP AS
SELECT
  CAWriteOffDocumentNumber,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeTime,
  CATaxCompanyCode,
  CATaxCodeWasExchanged,
  TaxReportingDate,
  CAReconciliationKey,
  CASeparateDocIsCreatedInGL,
  CARequestedPeriodForGLTransfer,
  CAApplicationArea,
  CADocumentType,
  CADocumentOriginCode,
  TransactionCurrency,
  DocumentDate,
  CAWriteOffDate,
  ExchangeRateDate,
  CAReferenceDocument,
  CAReturnReason,
  CAWriteOffReason,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  CAReversedDocumentNumber,
  CAClearingInformation,
  CAReversalDocumentNumber,
  CADocumentSupplements,
  LogicalSystem,
  CAWorkflowCheckReason,
  CAWorkflowCheckProcess,
  CADocumentTransactionClass,
  CADocContainsCashFlowItems,
  CADocumentClass,
  CADocumentVersion,
  IsIndividualPosting
FROM I_CAWriteOffDocument
;

Learn More