R_CADocumentTP

DDL: R_CADOCUMENTTP Type: view_entity TRANSACTIONAL Package: RAP_FICA_CADOC

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)

SourceAliasJoin Type
I_CADocument I_CADocument from

Associations (7)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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
}