I_REDOCUMENTHEADER

CDS View

Real Estate Document Header

I_REDOCUMENTHEADER is a CDS View in S/4HANA. Real Estate Document Header. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_REJournalEntryValnObjMapping view_entity inner COMPOSITE RE Mapping between Journal Entry and Valuation Object 
@AbapCatalog.sqlViewName: 'IREDOCHEAD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Document Header'

@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_REDocumentHeader
  as select from viradoc

  association [0..1] to I_User                      as _CreatedByUser             on  $projection.CreatedByUser             = _CreatedByUser.UserID
  association [0..1] to I_User                      as _ChangedByUser             on  $projection.LastChangedByUser         = _ChangedByUser.UserID
  association [0..1] to I_AccountingDocument        as _AccountingDocument        on  $projection.OriginalReferenceDocument = _AccountingDocument.OriginalReferenceDocument
                                                                                  and $projection.FiscalYear                = _AccountingDocument.FiscalYear
  association [0..1] to I_AccountingPrinciple       as _AccountingPrinciple       on  $projection.AccountingPrinciple       = _AccountingPrinciple.AccountingPrinciple

  association [0..1] to I_RECurrencyTranslationRule as _RECurrencyTranslationRule on  $projection.RECurrencyTranslationRule = _RECurrencyTranslationRule.RECurrencyTranslationRule
  association [0..1] to I_REValuationRule           as _REValuationRule           on  $projection.REValuationRule           = _REValuationRule.REValuationRule

{
  key docguid      as RealEstateDocumentUUID,
      //PSTNGPROCEDURE

      //PROCESS

      //PROCESSGUID

      //PROCESSID

      fisc_year    as FiscalYear,
      //PSTNGPERIOD

      pstngdate    as PostingDate,
      docdate      as DocumentDate,
      //ACCSYSTYPE

      //      @ObjectModel.foreignKey.association: '_AccountingDocument'

      refdocid     as OriginalReferenceDocument,
      logsystem    as LogicalSystem,
      //REVID

      //REVDOCGUID

      //STATUS

      //TAXID

      //HASGLACCSYMB

      //REFERENCEDOCGUID

      //      @ObjectModel.foreignKey.association: '_CreatedByUser'

      rerf         as CreatedByUser,
      derf         as CreationDate,
      terf         as CreationTime,
      reher        as RESourceOfCreation,
      //      @ObjectModel.foreignKey.association: '_ChangedByUser'

      rbear        as LastChangedByUser,
      dbear        as LastChangeDate,
      tbear        as LastChangeTime,
      rbher        as RESourceOfChange,
      //FDELETE

      @ObjectModel.foreignKey.association: '_RECurrencyTranslationRule'
      ctrule       as RECurrencyTranslationRule,
      //CTRATE

      postcdcurr   as REIsPostInConditionCurrency,
      ctdatereq    as REPlndTranslationDate,
      ctdateact    as REActlTranslationDate,
      ctfccurrkey  as ForeignCurrency,
      //DOCSTATUS

      //SECONDDOCGUID

      //SPLITDOCGUID

      @ObjectModel.foreignKey.association: '_REValuationRule'
      cerule       as REValuationRule,
      @ObjectModel.foreignKey.association: '_AccountingPrinciple'
      accprinciple as AccountingPrinciple,
      //CEDOCTYPE



      _CreatedByUser,
      _ChangedByUser,
      _AccountingDocument,
      _AccountingPrinciple,

      _RECurrencyTranslationRule,
      _REValuationRule

}

Learn More