I_CADocument

@AccessControl.authorizationCheck: #MANDATORY

@EndUserText.label: 'Contract Accounting Document'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: { representativeKey: 'CADocumentNumber',
                supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                                         #SQL_DATA_SOURCE,
                                         #CDS_MODELING_DATA_SOURCE ] }

@ObjectModel.usageType: { serviceQuality: #A,
                          sizeCategory: #XXL,
                          dataClass: #TRANSACTIONAL }

@VDM.viewType: #BASIC

define view entity I_CADocument
  as select from dfkkko

  association [0..1] to I_AccountingDocumentType    as _AccountingDocType         on  $projection.CADocumentTypeForGLTransfer    = _AccountingDocType.AccountingDocumentType  
  association [1..1] to I_CompanyCode               as _CompCode                  on  $projection.CATaxCompanyCode = _CompCode.CompanyCode
  association [1..1] to I_Currency                  as _Currency                  on  $projection.TransactionCurrency = _Currency.Currency
  association [1..1] to I_CAApplicationArea         as _ApplArea                  on  $projection.CAApplicationArea = _ApplArea.CAApplicationArea
  association [0..1] to I_CAClearingInformation     as _CAClearingInformation     on  $projection.CAClearingInformation = _CAClearingInformation.CAClearingInformation
  association [1..1] to I_CADocTransactionClass     as _CADocTransactionClass     on  $projection.CADocumentTransactionClass = _CADocTransactionClass.CADocumentTransactionClass
  association [0..1] to I_CADocumentClass           as _CADocumentClass           on  $projection.CADocumentClass = _CADocumentClass.CADocumentClass
  association [1..1] to I_CADocumentOriginCode      as _DocOriginCode             on  $projection.CADocumentOriginCode = _DocOriginCode.CADocumentOriginCode
  association [0..1] to I_CADocumentSupplement      as _CADocumentSupplement      on  $projection.CADocumentSupplements = _CADocumentSupplement.CADocumentSupplements
  association [1..1] to I_CADocumentType            as _DocType                   on  $projection.CADocumentType    = _DocType.CADocumentType
                                                                                  and $projection.CAApplicationArea = _DocType.CAApplicationArea
  association [0..1] to I_CADocumentVersion         as _CADocumentVersion         on  $projection.CADocumentVersion = _CADocumentVersion.CADocumentVersion
  association [0..1] to I_CAPostingReason           as _CAPostingReason           on  $projection.CADocumentOriginCode = _CAPostingReason.CADocumentOriginCode
                                                                                  and $projection.CAPostingReason      = _CAPostingReason.CAPostingReason
  association [0..*] to I_CAReturnReason            as _CAReturnReason            on  $projection.CAReturnReason = _CAReturnReason.CAReturnReason
                                                                                  and _CAReturnReason.HouseBank  is not initial
  association [1..1] to I_CARequestedSpecialPeriod  as _CARequestedSpecialPeriod  on  $projection.CARequestedPeriodForGLTransfer = _CARequestedSpecialPeriod.CARequestedPeriodForGLTransfer
  association [0..1] to I_CATaxSupplementStorageLoc as _CATaxSupplementStorageLoc on  $projection.CAStorageLocationOfTaxSuplmnt = _CATaxSupplementStorageLoc.CAStorageLocationOfTaxSuplmnt
  association [0..1] to I_CAWorkflowCheckReason     as _WorkflowCheckReason       on  $projection.CAWorkflowCheckReason = _WorkflowCheckReason.CAWorkflowCheckReason
  association [0..1] to I_CAWorkflowCheckProcess    as _WorkflowCheckProcess      on  $projection.CAWorkflowCheckProcess = _WorkflowCheckProcess.CAWorkflowCheckProcess

  association [1..1] to E_CADocumentHeader          as _Extension                 on  $projection.CADocumentNumber = _Extension.CADocumentNumber

{
  key opbel                                                    as CADocumentNumber,

      fikey                                                    as CAReconciliationKey,
      @ObjectModel.foreignKey.association: '_ApplArea'
      applk                                                    as CAApplicationArea,
      @ObjectModel.foreignKey.association: '_DocType'
      blart                                                    as CADocumentType,
      @ObjectModel.foreignKey.association: '_DocOriginCode'
      herkf                                                    as CADocumentOriginCode,
      cast(ernam as fclm_bam_created_by preserving type )      as CreatedByUser,
      cast(cpudt as fis_cpdat preserving type)                 as CreationDate,
      cast(cputm as ttet_dt_cr_time preserving type )          as CreationTime,
      @ObjectModel.foreignKey.association: '_Currency'
      cast(waers as fis_rwcur preserving type )                as TransactionCurrency,
      cast(bldat as fis_bldat preserving type )                as DocumentDate,
      budat                                                    as CAPostingDate,
      cast(wwert as vdm_v_exchange_rate_date preserving type ) as ExchangeRateDate,
      xblnr                                                    as CAReferenceDocument,
      @ObjectModel.foreignKey.association: '_CAReturnReason'
      rlgrd                                                    as CAReturnReason,
      @ObjectModel.foreignKey.association: '_CAPostingReason'
      abgrd                                                    as CAPostingReason,
      xeibh                                                    as CASeparateDocIsCreatedInGL,
      //xbwer

      cast(awtyp as fis_awtyp preserving type )                as ReferenceDocumentType,
      awkey                                                    as OriginalReferenceDocument,
      cast(stbel  as stbel_gfn_kk preserving type )            as CAReversedDocumentNumber,
      //stmet

      @ObjectModel.foreignKey.association: '_CADocumentClass'
      bltyp                                                    as CADocumentClass,
      @ObjectModel.foreignKey.association: '_CAClearingInformation'
      aginf                                                    as CAClearingInformation,
      @ObjectModel.foreignKey.association: '_CompCode'
      stbuk                                                    as CATaxCompanyCode,
      cast(storb as storb_gfn_kk preserving type )             as CAReversalDocumentNumber,
      @ObjectModel.foreignKey.association: '_CADocumentSupplement'
      appdx                                                    as CADocumentSupplements,
      awsys                                                    as LogicalSystem,
      @ObjectModel.foreignKey.association: '_CADocumentVersion'
      versn                                                    as CADocumentVersion,
      @ObjectModel.foreignKey.association: '_WorkflowCheckReason'
      c4eye                                                    as CAWorkflowCheckReason,
      @ObjectModel.foreignKey.association: '_WorkflowCheckProcess'
      c4eyp                                                    as CAWorkflowCheckProcess,
      @ObjectModel.foreignKey.association: '_CADocTransactionClass'
      tatyp                                                    as CADocumentTransactionClass,
      @ObjectModel.foreignKey.association: '_AccountingDocType'
      hbbla                                                    as CADocumentTypeForGLTransfer, 
      xcsha                                                    as CADocContainsCashFlowItems,
      @ObjectModel.foreignKey.association: '_CATaxSupplementStorageLoc'
      utloc                                                    as CAStorageLocationOfTaxSuplmnt,
      xtxch                                                    as CATaxCodeWasExchanged,
      cast(vatdate as vatdate preserving type )                as TaxReportingDate,
      //fulfilldate      

      @ObjectModel.foreignKey.association: '_CARequestedSpecialPeriod'
      wnper                                                    as CARequestedPeriodForGLTransfer,
      xsing                                                    as IsIndividualPosting,
      //keypp

      //_dataging

      xdaag                                                    as CADocumentIsAged,
      //trsla

      //locok

      //bttype

      //cbttype

      //closingstep

      chdate                                                   as LastChangeDate,
      chtime                                                   as LastChangeTime,
      //cadoctype

      glo_ref1_hd as CA1stCountrySpecificReference,
      glo_dat1_hd as CAFirstCountrySpecificDate,

      /* associations */
      _AccountingDocType,
      _ApplArea,
      _CAClearingInformation,
      _CADocTransactionClass,
      _CADocumentClass,
      _CADocumentSupplement,
      _CADocumentVersion,
      _CAPostingReason,
      _CAReturnReason,
      _CARequestedSpecialPeriod,
      _CATaxSupplementStorageLoc,
      _CompCode,
      _Currency,
      _DocType,
      _DocOriginCode,
      _WorkflowCheckProcess,
      _WorkflowCheckReason
}