I_REOutputRequestBasic

DDL: I_REOUTPUTREQUESTBASIC Type: view_entity BASIC Package: VDM_RE_OM

Real Estate Output Requests Basic

I_REOutputRequestBasic is a Basic CDS View that provides data about "Real Estate Output Requests Basic" in SAP S/4HANA. It reads from 1 data source (R_OutputRequest) and exposes 8 fields with key field OutputRequestUUID. Part of development package VDM_RE_OM.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
R_OutputRequest R_OutputRequest from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey OutputRequestUUID view
EndUserText.label Real Estate Output Requests Basic view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY OutputRequestUUID OutputRequestUUID
OutputControlApplObjectType OutputControlApplObjectType
OutputControlApplicationObject OutputControlApplicationObject
OutputParameterText OutputParameterText
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.usageType: {
      serviceQuality: #B,
      sizeCategory : #L,
      dataClass: #TRANSACTIONAL }
@ObjectModel.representativeKey: 'OutputRequestUUID'
@EndUserText.label: 'Real Estate Output Requests Basic'
define view entity I_REOutputRequestBasic
  as select from R_OutputRequest
{
  key OutputRequestUUID,
      OutputControlApplObjectType,
      OutputControlApplicationObject,
      // Keys for Adjustments

      cast (case
      when OutputControlApplObjectType <> 'RE_CONTRACT_A520'
      then  substring(OutputControlApplicationObject,1,16)
      else ' '
      end as recavdmprocessid preserving type ) as RealEstateProcess,

      cast( case
      when OutputControlApplObjectType <> 'RE_CONTRACT_A520'
      then  substring(OutputControlApplicationObject,17,13)
            else ' '
      end as recnnumber preserving type )       as RealEstateContract,

      //Keys for fetching invoice data

      cast( case
        when OutputControlApplObjectType <> 'RE_CONTRACT_A520'
        then cast( substring(OutputControlApplicationObject,30,4) as abap.char(4))
        else cast( substring ( OutputControlApplicationObject, 1, 4 ) as abap.char(4))
      end as bukrs preserving type )            as CompanyCode,

      cast( case
        when OutputControlApplObjectType = 'RE_CONTRACT_A520'
        then substring ( OutputControlApplicationObject, 5, 10 )
        else ' '
      end as rerainvno )                        as REInvoiceNumber,

      cast (case
      when OutputControlApplObjectType = 'RE_CONTRACT_A520'
      then cast ( substring ( OutputControlApplicationObject, 15, 4 ) as abap.numc( 4 ) )
      else cast ( ' ' as abap.numc( 4 ) )
      end as gjahr preserving type )            as FiscalYear,


      OutputParameterText,
      CreationDateTime,
      CreatedByUser,
      LastChangeDateTime,
      LastChangedByUser
}
where
     OutputControlApplObjectType = 'RE_ADJUSTMENT'
  or OutputControlApplObjectType = 'RE_CONTRACT_A520'
  or OutputControlApplObjectType = 'RE_SALESBASEDRENT';

Learn More