I_REDOCUMENTITEM

//@AbapCatalog.sqlViewName: 'IREDOCITEM'

@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@EndUserText.label: 'Real Estate Document Item'
@Analytics.internalName: #LOCAL
@ObjectModel: {
  representativeKey: 'RealEstateDocumentUUID',
  usageType: {
    dataClass: #MIXED,
    serviceQuality: #C,
    sizeCategory: #L
  },
  modelingPattern: #NONE,
  supportedCapabilities: [
    #CDS_MODELING_ASSOCIATION_TARGET
  ]
}
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC

define view entity I_REDocumentItem
  as select from viradocitem
  association [1..1] to I_REDocumentHeader    as _REDocumentHeader    on  $projection.RealEstateDocumentUUID = _REDocumentHeader.RealEstateDocumentUUID
  association [0..1] to I_BusinessArea        as _BusinessArea        on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [1..1] to I_CompanyCode         as _CompanyCode         on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_ProfitCenter        as _ProfitCenter        on  $projection.ProfitCenter        = _ProfitCenter.ProfitCenter
                                                                     and $projection.ControllingArea     = _ProfitCenter.ControllingArea
                                                                     and _ProfitCenter.ValidityEndDate   >= $session.system_date
                                                                     and _ProfitCenter.ValidityStartDate <= $session.system_date
{
  key docguid                                                    as RealEstateDocumentUUID,
  key itemno                                                     as RealEstateDocumentItem,
      refitemno                                                  as REReferenceDocumentItem,
      bukrs                                                      as CompanyCode,
      _CompanyCode.ControllingArea                               as ControllingArea,
      itemtype                                                   as REDocumentItemType,
      refdate                                                    as SettlementReferenceDate,
      process                                                    as REProcessType,
      processguid                                                as REProcessUUID,
      //      clearingstatus,

      clearngprocessid                                           as RealEstateClearingProcess, 
      //      payedstatus,

      //      dunningstatus,

      refguidorigin                                              as REDocumentReferenceOrigin,
      refguid                                                    as REDocumentReferenceUUID,
      objnr                                                      as REStatusObject,
      pfrom                                                      as CalculationPeriodStartDate,
      pto                                                        as CalculationPeriodEndDate,
      blinedate                                                  as DueCalculationBaseDate,
      origduedate                                                as REOriglDueDate,
      condtype                                                   as REConditionType,
      //      isadvancepayment,

      flowtype                                                   as REFlowType,
      dcindicator                                                as DebitCreditCode,
      //      taxgroupid,

      taxdate                                                    as RETaxCalcDate,
      //      termnooa             as RETermNumber, //termnopy has same element

      gsber                                                      as BusinessArea,
      prctr                                                      as ProfitCenter,
      //      addobjnr,

      cast( fund as bp_geber )                                   as Fund,
      cast( fundscenter as fm_fictr )                            as FundsCenter,
      cast( commitmentitem as fm_fipex preserving type )         as CommitmentItem,
      cast( functionalarea as fm_farea )                         as FunctionalArea,
      cast( grantnumber   as reravdmgrantnumber preserving type) as REFundsManagementGrantID,
      //      measure,

      //      budgetperiod,

      //      termnopy             as RETermNumber, //termnooa has same element

      //      cdsplitno,

      //            pymtmeth as REPaymentMethod,

      //      pymtmethcrmo,

      //      pymtblock,

      //      pymtterm,

      //      housebkid,

      //      housebkacc,

      //      bankdetailid,

      //      notetopayee,

      //      dunnarea,

      //      dunnkey,

      //      dunnblock,

      //      accdetkey,

      //      taxtype,

      //      taxgroup,

      //      isgross,

      //      taxcountry,

      //      partner,

      //      partnerobjnr,

      //      txjcd,

      //      iscdsplit,

      //      ctrule,

      //      ispartnerblocked,

      //      sepamndid,

      //      separeccrdid,

      //      termnowt,

      //      acctype,

      //      glaccsymb,

      //      glaccount,

      //      amount         as AmountInTransactionCurrency,

      //      grossamount,

      //      netamount,

      //      taxamount,

      //      currency       as TransactionCurrency,

      //      ctlcamount     as AmountInCompanyCodeCurrency,

      //      @Semantics.amount.currencyCode: 'RECashFlowLoclCurrency'

      //      ctlcgrossamount                                            as RETrnsltnRuleLoclGrossAmount,

      //      @Semantics.amount.currencyCode: 'RECashFlowLoclCurrency'

      //      ctlcnetamount                                              as RETrnsltnRuleLoclNetAmount,

      //      @Semantics.amount.currencyCode: 'RECashFlowLoclCurrency'

      //      ctlctaxamount                                              as RETrnsltnRuleLoclTaxAmount,

      //      ctlccurrkey    as CompanyCodeCurrency,

      //      ctfcamount     as AmountInBalanceTransacCrcy,

      //      ctfcgrossamount,

      //      ctfcnetamount,

      //      ctfctaxamount,

      //      ctfccurrkey    as BalanceTransactionCurrency

      //      taxrate,

      //      exttaxcode,

      //      extref1,

      //      extref2,

      //      extref3,

      //      extref4,

      assetobjnr                                         as REStatusObjectAsset,
      //      assetvaluedate,

      //      assetprocedure,

      iscompleteretirement                               as REValnIsCompleteRetirement,
      //      reduction_percentage


      /* Associations */
      _REDocumentHeader,
      _BusinessArea,
      _ProfitCenter

}