R_CADocumentTP

DDL: R_CADOCUMENTTP Type: view_entity TRANSACTIONAL

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 60 fields with key field CADocumentNumber. It has 6 associations to related views.

1 data source(s) 60 fields

Data Sources (1)

SourceAliasJoin Type
I_CADocument I_CADocument from

Associations (6)

CardinalityTargetAliasCondition
[0..*] I_CADocumentBPItemLogicalEnhcd _LogicalBPItem $projection.CADocumentNumber = _LogicalBPItem.CADocumentNumber
[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..*] R_CADocumentBPItemTP _BPItem
[0..*] R_CADocumentGLItemTP _GLItem

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK 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 (60)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
CreationDateTime
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
CAPostingDate CAPostingDate
ExchangeRateDate ExchangeRateDate
CAReferenceDocument CAReferenceDocument
CAReturnReason CAReturnReason
CAPostingReason 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
CADocumentIsAged CADocumentIsAged
_BPItem _BPItem
_GLItem _GLItem
_BPItemPaytData _BPItemPaytData
_GLItemPaytData _GLItemPaytData
_LogicalBPItem _LogicalBPItem
_DocUI _DocUI
_ApplArea _ApplArea
_CAClearingInformation _CAClearingInformation
_CADocTransactionClass _CADocTransactionClass
_CADocumentClass _CADocumentClass
_CADocumentSupplement _CADocumentSupplement
_CADocumentVersion _CADocumentVersion
_CAPostingReason _CAPostingReason
_CAReturnReason _CAReturnReason
_CARequestedSpecialPeriod _CARequestedSpecialPeriod
_CATaxSupplementStorageLoc _CATaxSupplementStorageLoc
_CompCode _CompCode
_Currency _Currency
_DocType _DocType
_DocOriginCode _DocOriginCode
_WorkflowCheckProcess _WorkflowCheckProcess
_WorkflowCheckReason _WorkflowCheckReason 
@AccessControl.authorizationCheck: #CHECK

@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_CADocumentBPItemLogicalEnhcd as _LogicalBPItem on $projection.CADocumentNumber = _LogicalBPItem.CADocumentNumber
  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
{
      //I_CADocument

  key CADocumentNumber,
      CreatedByUser,
      
      CreationDate,
      CreationTime,
      cast(dats_tims_to_tstmp(CreationDate, CreationTime, abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL') as vdm_creationdatetime) as CreationDateTime,

      LastChangeDate,
      LastChangeTime,
      CATaxCompanyCode,
      CAStorageLocationOfTaxSuplmnt,
      CATaxCodeWasExchanged,
      TaxReportingDate,
      CAReconciliationKey,
      CASeparateDocIsCreatedInGL,
      CARequestedPeriodForGLTransfer,
      CAApplicationArea,
      CADocumentType,
      CADocumentOriginCode,
      TransactionCurrency,
      DocumentDate,
      CAPostingDate,
      ExchangeRateDate,
      CAReferenceDocument,
      CAReturnReason,
      CAPostingReason,
      ReferenceDocumentType,
      OriginalReferenceDocument,
      CAReversedDocumentNumber,
      CAClearingInformation,
      CAReversalDocumentNumber,
      CADocumentSupplements,
      LogicalSystem,
      CAWorkflowCheckReason,
      CAWorkflowCheckProcess,
      CADocumentTransactionClass,
      CADocContainsCashFlowItems,
      CADocumentClass,
      CADocumentVersion,
      IsIndividualPosting,
      CADocumentIsAged,

      

      //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,
      _LogicalBPItem,
      _DocUI,
      // associations from I_CADocument

      _ApplArea,
      _CAClearingInformation,
      _CADocTransactionClass,
      _CADocumentClass,
      _CADocumentSupplement,
      _CADocumentVersion,
      _CAPostingReason,
      _CAReturnReason,
      _CARequestedSpecialPeriod,
      _CATaxSupplementStorageLoc,
      _CompCode,
      _Currency,
      _DocType,
      _DocOriginCode,
      _WorkflowCheckProcess,
      _WorkflowCheckReason
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CADOCUMENT"
],
"ASSOCIATED":
[
"I_CAAPPLICATIONAREA",
"I_CACLEARINGINFORMATION",
"I_CADOCTRANSACTIONCLASS",
"I_CADOCUMENTBPITEMLOGICALENHCD",
"I_CADOCUMENTBPITEMPAYMENTDATA",
"I_CADOCUMENTCLASS",
"I_CADOCUMENTGLITEMPAYMENTDATA",
"I_CADOCUMENTORIGINCODE",
"I_CADOCUMENTSUPPLEMENT",
"I_CADOCUMENTTYPE",
"I_CADOCUMENTUI",
"I_CADOCUMENTVERSION",
"I_CAPOSTINGREASON",
"I_CAREQUESTEDSPECIALPERIOD",
"I_CARETURNREASON",
"I_CATAXSUPPLEMENTSTORAGELOC",
"I_CAWORKFLOWCHECKPROCESS",
"I_CAWORKFLOWCHECKREASON",
"I_COMPANYCODE",
"I_CURRENCY",
"R_CADOCUMENTBPITEMTP",
"R_CADOCUMENTGLITEMTP"
],
"BASE":
[
"I_CADOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More