R_CADocumentTP
Contract Accounting Document - TP
R_CADocumentTP 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 | _BPItemPaytData | $projection.CADocumentNumber = _BPItemPaytData.CADocumentNumber |
| [0..*] | I_CADocumentGLItemPaymentData | _GLItemPaytData | $projection.CADocumentNumber = _GLItemPaytData.CADocumentNumber |
| [1..1] | I_CADocumentUI | _DocUI | $projection.CADocumentNumber = _DocUI.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 | _BPItem | |
| [0..*] | R_CADocumentGLItemTP | _GLItem | |
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 | ||||
| _BPItem | _BPItem | |||
| _GLItem | _GLItem | |||
| _BPItemPaytData | _BPItemPaytData | |||
| _GLItemPaytData | _GLItemPaytData | |||
| _DocUI | _DocUI | |||
| _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 | |||
| _CADocumentChangeDocument | _CADocumentChangeDocument |
@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
as select from I_CADocument
composition [0..*] of R_CADocumentBPItemTP as _BPItem
composition [0..*] of R_CADocumentGLItemTP as _GLItem
association [0..*] to I_CADocumentBPItemPaymentData as _BPItemPaytData on $projection.CADocumentNumber = _BPItemPaytData.CADocumentNumber
association [0..*] to I_CADocumentGLItemPaymentData as _GLItemPaytData on $projection.CADocumentNumber = _GLItemPaytData.CADocumentNumber
association [1..1] to I_CADocumentUI as _DocUI on $projection.CADocumentNumber = _DocUI.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
_BPItem,
_GLItem,
_BPItemPaytData,
_GLItemPaytData,
_DocUI,
// associations from I_CADocument
_CAApplicationArea,
_CAClearingInformation,
_CADocTransactionClass,
_CADocumentClass,
_CADocumentOriginCode,
_CADocumentSupplement,
_CADocumentType,
_CADocumentVersion,
_CAPostingReason,
_CAReturnReason,
_CARequestedSpecialPeriod,
_CATaxCompanyCode,
_CATaxSupplementStorageLoc,
_CAWorkflowCheckProcess,
_CAWorkflowCheckReason,
_CreatedByUser,
_TransactionCurrency,
_CADocumentChangeDocument
}
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