P_REIntegObjToContrByKeyDate

DDL: P_REINTEGOBJTOCONTRBYKEYDATE Type: view_entity COMPOSITE Package: VDM_RE_IP

Integration Object Contract Assignment by Keydate

P_REIntegObjToContrByKeyDate is a Composite CDS View that provides data about "Integration Object Contract Assignment by Keydate" in SAP S/4HANA. It reads from 3 data sources (vicncn, viipobject, vibdobjass) and exposes 8 fields with key fields REStatusObjectSource, REObjectAssignmentType, CompanyCode, RealEstateContract, InternalRealEstateNumber. Part of development package VDM_RE_IP.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
vicncn _REContract inner
viipobject _REIntegrationObject inner
vibdobjass _REObjectAssgmt from

Parameters (1)

NameTypeDefault
P_KeyDate recakeydate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Integration Object Contract Assignment by Keydate view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY REStatusObjectSource vibdobjass objnrtrg
KEY REObjectAssignmentType vibdobjass objasstype
KEY CompanyCode vicncn bukrs
KEY RealEstateContract vicncn recnnr
KEY InternalRealEstateNumber viipobject intreno
REStatusObjectTarget vibdobjass objnrsrc
REContractActivateDate
REContractName 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Integration Object Contract Assignment by Keydate'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #L,
  dataClass: #MIXED
}
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity P_REIntegObjToContrByKeyDate
  with parameters
    P_KeyDate : recakeydate
  //  as select from I_REObjectAssgmt               as _REObjectAssgmt

  as select from vibdobjass as _REObjectAssgmt
  //    inner join   I_REIntegrationObjectBasicData as _REIntegrationObject on(

    inner join   viipobject as _REIntegrationObject on(
      _REIntegrationObject.objnr    = _REObjectAssgmt.objnrtrg
      and _REObjectAssgmt.validfrom <= $parameters.P_KeyDate
      and _REObjectAssgmt.validto   >= $parameters.P_KeyDate
    )
  //    inner join   I_REContract                   as _REContract          on  _REContract.REStatusObject    = _REObjectAssgmt.REStatusObjectSource

    inner join   vicncn     as _REContract          on  _REContract.objnr      = _REObjectAssgmt.objnrsrc
                                                    and _REContract.recnbeg    <= $parameters.P_KeyDate
                                                    and _REContract.recnendabs >= $parameters.P_KeyDate
{
  key _REObjectAssgmt.objnrtrg                                      as REStatusObjectSource,
  key _REObjectAssgmt.objasstype                                    as REObjectAssignmentType,
  key _REContract.bukrs                                             as CompanyCode,
  key _REContract.recnnr                                            as RealEstateContract,
  key _REIntegrationObject.intreno                                  as InternalRealEstateNumber,
      _REObjectAssgmt.objnrsrc                                      as REStatusObjectTarget,
      cast(_REContract.recndactiv as recnvdmdaktv preserving type ) as REContractActivateDate,
      cast(_REContract.recntxt as recnvdmcnname preserving type )   as REContractName
}
where
      _REObjectAssgmt.objasstype = '10'
  and _REObjectAssgmt.validfrom  <= $parameters.P_KeyDate
  and _REObjectAssgmt.validto    >= $parameters.P_KeyDate

Learn More