R_CADocumentTP_2
Contract Accounting Document - TP
R_CADocumentTP_2 is a Transactional CDS View that provides data about "Contract Accounting Document - TP" in SAP S/4HANA. It reads from 1 data source (I_CADocument) and exposes 68 fields with key field CADocumentNumber. It has 7 associations to related views. Part of development package RAP_FICA_CADOC.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CADocument | I_CADocument | from |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_CADocumentBPItemPaymentData | _CADocumentBPItemPaytData | $projection.CADocumentNumber = _CADocumentBPItemPaytData.CADocumentNumber |
| [0..*] | I_CADocumentGLItemPaymentData | _CADocumentGLItemPaytData | $projection.CADocumentNumber = _CADocumentGLItemPaytData.CADocumentNumber |
| [1..1] | I_CADocumentUI | _CADocumentUI | $projection.CADocumentNumber = _CADocumentUI.CADocumentNumber |
| [0..*] | I_ChangeDocument_2 | _CADocumentChangeDocument | _CADocumentChangeDocument.ChangeDocObjectClass = 'MKK_BELEG' and $projection.CADocumentNumber = _CADocumentChangeDocument.ChangeDocObject |
| [1..1] | E_CADocumentHeader | _Extension | $projection.CADocumentNumber = _Extension.CADocumentNumber |
| [0..*] | R_CADocumentBPItemTP_2 | _CADocumentBPItem | |
| [0..*] | R_CADocumentGLItemTP_2 | _CADocumentGLItem | |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Contract Accounting Document - TP | view | |
| ObjectModel.representativeKey | CADocumentNumber | view | |
| ObjectModel.sapObjectNodeType.name | ContrAcctgDocument | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| VDM.viewType | #TRANSACTIONAL | view |
Fields (68)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CADocumentNumber | CADocumentNumber | ||
| CAReconciliationKey | CAReconciliationKey | |||
| CAApplicationArea | CAApplicationArea | |||
| CADocumentType | CADocumentType | |||
| CADocumentOriginCode | CADocumentOriginCode | |||
| CreatedByUser | CreatedByUser | |||
| CreationDate | CreationDate | |||
| CreationTime | CreationTime | |||
| TransactionCurrency | TransactionCurrency | |||
| DocumentDate | DocumentDate | |||
| CAPostingDate | CAPostingDate | |||
| ExchangeRateDate | ExchangeRateDate | |||
| CAReferenceDocument | CAReferenceDocument | |||
| CAReturnReason | CAReturnReason | |||
| CAPostingReason | CAPostingReason | |||
| CASeparateDocIsCreatedInGL | CASeparateDocIsCreatedInGL | |||
| ReferenceDocumentType | ReferenceDocumentType | |||
| OriginalReferenceDocument | OriginalReferenceDocument | |||
| CAReversedDocumentNumber | CAReversedDocumentNumber | |||
| CADocumentClass | CADocumentClass | |||
| CAClearingInformation | CAClearingInformation | |||
| CATaxCompanyCode | CATaxCompanyCode | |||
| CAReversalDocumentNumber | CAReversalDocumentNumber | |||
| CADocumentSupplements | CADocumentSupplements | |||
| LogicalSystem | LogicalSystem | |||
| CADocumentVersion | CADocumentVersion | |||
| CAWorkflowCheckReason | CAWorkflowCheckReason | |||
| CAWorkflowCheckProcess | CAWorkflowCheckProcess | |||
| CADocumentTransactionClass | CADocumentTransactionClass | |||
| CADocumentTypeForGLTransfer | CADocumentTypeForGLTransfer | |||
| CADocContainsCashFlowItems | CADocContainsCashFlowItems | |||
| CATaxCodeWasExchanged | CATaxCodeWasExchanged | |||
| TaxReportingDate | TaxReportingDate | |||
| TaxFulfillmentDate | TaxFulfillmentDate | |||
| CARequestedPeriodForGLTransfer | CARequestedPeriodForGLTransfer | |||
| IsIndividualPosting | IsIndividualPosting | |||
| CADocumentIsAged | CADocumentIsAged | |||
| LastChangeDate | LastChangeDate | |||
| LastChangeTime | LastChangeTime | |||
| CAInvcgRefPostingDocType | CAInvcgRefPostingDocType | |||
| CAInvoicingDocument | CAInvoicingDocument | |||
| CA1stCountrySpecificReference | CA1stCountrySpecificReference | |||
| CAFirstCountrySpecificDate | CAFirstCountrySpecificDate | |||
| CAClassificationKey | CAClassificationKey | |||
| CreationDateTime | ||||
| _CADocumentBPItem | _CADocumentBPItem | |||
| _CADocumentGLItem | _CADocumentGLItem | |||
| _CADocumentBPItemPaytData | _CADocumentBPItemPaytData | |||
| _CADocumentGLItemPaytData | _CADocumentGLItemPaytData | |||
| _CADocumentChangeDocument | _CADocumentChangeDocument | |||
| _CADocumentUI | _CADocumentUI | |||
| _CAApplicationArea | _CAApplicationArea | |||
| _CAClearingInformation | _CAClearingInformation | |||
| _CADocTransactionClass | _CADocTransactionClass | |||
| _CADocumentClass | _CADocumentClass | |||
| _CADocumentOriginCode | _CADocumentOriginCode | |||
| _CADocumentSupplement | _CADocumentSupplement | |||
| _CADocumentType | _CADocumentType | |||
| _CADocumentVersion | _CADocumentVersion | |||
| _CAPostingReason | _CAPostingReason | |||
| _CAReturnReason | _CAReturnReason | |||
| _CARequestedSpecialPeriod | _CARequestedSpecialPeriod | |||
| _CATaxCompanyCode | _CATaxCompanyCode | |||
| _CATaxSupplementStorageLoc | _CATaxSupplementStorageLoc | |||
| _CAWorkflowCheckProcess | _CAWorkflowCheckProcess | |||
| _CAWorkflowCheckReason | _CAWorkflowCheckReason | |||
| _CreatedByUser | _CreatedByUser | |||
| _TransactionCurrency | _TransactionCurrency |
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.privilegedAssociations: [ '_CADocumentChangeDocument' ]
@EndUserText.label: 'Contract Accounting Document - TP'
@ObjectModel: { representativeKey: 'CADocumentNumber',
sapObjectNodeType.name: 'ContrAcctgDocument',
usageType: { dataClass: #TRANSACTIONAL,
sizeCategory: #XXL,
serviceQuality: #C } }
@VDM: { lifecycle.contract.type: #SAP_INTERNAL_API,
viewType: #TRANSACTIONAL }
define root view entity R_CADocumentTP_2
as select from I_CADocument
composition [0..*] of R_CADocumentBPItemTP_2 as _CADocumentBPItem
composition [0..*] of R_CADocumentGLItemTP_2 as _CADocumentGLItem
association [0..*] to I_CADocumentBPItemPaymentData as _CADocumentBPItemPaytData on $projection.CADocumentNumber = _CADocumentBPItemPaytData.CADocumentNumber
association [0..*] to I_CADocumentGLItemPaymentData as _CADocumentGLItemPaytData on $projection.CADocumentNumber = _CADocumentGLItemPaytData.CADocumentNumber
association [1..1] to I_CADocumentUI as _CADocumentUI on $projection.CADocumentNumber = _CADocumentUI.CADocumentNumber
association [0..*] to I_ChangeDocument_2 as _CADocumentChangeDocument on _CADocumentChangeDocument.ChangeDocObjectClass = 'MKK_BELEG'
and $projection.CADocumentNumber = _CADocumentChangeDocument.ChangeDocObject
// 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.CADocumentNumber = _Extension.CADocumentNumber
{
key CADocumentNumber,
CAReconciliationKey,
CAApplicationArea,
CADocumentType,
CADocumentOriginCode,
CreatedByUser,
CreationDate,
CreationTime,
TransactionCurrency,
DocumentDate,
CAPostingDate,
ExchangeRateDate,
CAReferenceDocument,
CAReturnReason,
CAPostingReason,
CASeparateDocIsCreatedInGL,
ReferenceDocumentType,
OriginalReferenceDocument,
CAReversedDocumentNumber,
CADocumentClass,
CAClearingInformation,
CATaxCompanyCode,
CAReversalDocumentNumber,
CADocumentSupplements,
LogicalSystem,
CADocumentVersion,
CAWorkflowCheckReason,
CAWorkflowCheckProcess,
CADocumentTransactionClass,
CADocumentTypeForGLTransfer,
CADocContainsCashFlowItems,
CAStorageLocationOfTaxSuplmnt,
CATaxCodeWasExchanged,
TaxReportingDate,
TaxFulfillmentDate,
CARequestedPeriodForGLTransfer,
IsIndividualPosting,
CADocumentIsAged,
LastChangeDate,
LastChangeTime,
CAInvcgRefPostingDocType,
CAInvoicingDocument,
CA1stCountrySpecificReference,
CAFirstCountrySpecificDate,
CAClassificationKey,
cast(dats_tims_to_tstmp(CreationDate, CreationTime, abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL') as vdm_creationdatetime) as CreationDateTime,
//etag
@Semantics.systemDateTime.lastChangedAt: true
case when ( LastChangeDate is initial or LastChangeDate is null )
then cast( dats_tims_to_tstmp( LastChangeDate, LastChangeTime, 'UTC', $session.client, 'NULL') as vdm_lastchangedon )
else cast( dats_tims_to_tstmp( CreationDate, CreationTime, 'UTC', $session.client, 'NULL') as vdm_lastchangedon )
end as LastChangeDateTime,
/* Associations */
// own association
_CADocumentBPItem,
_CADocumentGLItem,
_CADocumentBPItemPaytData,
_CADocumentGLItemPaytData,
_CADocumentChangeDocument,
_CADocumentUI,
// associations from I_CADocument
_CAApplicationArea,
_CAClearingInformation,
_CADocTransactionClass,
_CADocumentClass,
_CADocumentOriginCode,
_CADocumentSupplement,
_CADocumentType,
_CADocumentVersion,
_CAPostingReason,
_CAReturnReason,
_CARequestedSpecialPeriod,
_CATaxCompanyCode,
_CATaxSupplementStorageLoc,
_CAWorkflowCheckProcess,
_CAWorkflowCheckReason,
_CreatedByUser,
_TransactionCurrency
}
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