I_REDOCUMENTITEM

@AbapCatalog.sqlViewName: 'IREDOCITEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Document Item'

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.representativeKey: 'RealEstateDocumentUUID'

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ClientHandling.algorithm: #SESSION_VARIABLE

define view 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,

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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"VIRADOCITEM"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_PROFITCENTER",
"I_REDOCUMENTHEADER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/