R_REIntegObjectObjAssgmtTP

DDL: R_REINTEGOBJECTOBJASSGMTTP SQL: RREINTEGOBJASSTP Type: view_entity TRANSACTIONAL Package: RAP_RE_IP

IntegrationObject Object Assignment TP

R_REIntegObjectObjAssgmtTP is a Transactional CDS View that provides data about "IntegrationObject Object Assignment TP" in SAP S/4HANA. It reads from 1 data source (I_REObjectAssgmtHier) and exposes 22 fields with key fields REStatusObjectSource, REObjectAssignmentType, REStatusObjectTarget, ValidityStartEndDateValue, InternalRealEstateNumber. Part of development package RAP_RE_IP.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_REObjectAssgmtHier _REObjectAssgmt from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey REStatusObjectTarget view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label IntegrationObject Object Assignment TP view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY REStatusObjectSource REStatusObjectSource
KEY REObjectAssignmentType REObjectAssignmentType
KEY REStatusObjectTarget REStatusObjectTarget
KEY ValidityStartEndDateValue
KEY InternalRealEstateNumber InternalRealEstateNumber
ValidityStartDate
ValidityEndDate
REOnlyInfoAssgmt REOnlyInfoAssgmt
REStatusObjectSourceIsArchived REStatusObjectSourceIsArchived
REGenerationType REGenerationType
REIsMainAsset REIsMainAsset
REAssignmentHasMultiple REAssignmentHasMultiple
REObjectPossessionStartDate REObjectPossessionStartDate
REObjectPossessionEndDate REObjectPossessionEndDate
REGroupNumber REGroupNumber
REObjectGroupName REObjectGroupName
REIsLeadingObject REIsLeadingObject
_REObjectTypeDetails _REObjectTypeDetails
_REObjectAssignmentType _REObjectAssignmentType
_REGenerationType _REGenerationType
_REIntegrationObjectTP _REIntegrationObjectTP
_REAccountingObject _REAccountingObject 
//@AbapCatalog.sqlViewName: 'RREINTEGOBJASSTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]

@ObjectModel.representativeKey: 'REStatusObjectTarget' 
@ObjectModel.semanticKey: ['REStatusObjectSource', 'REObjectAssignmentType', 'REStatusObjectTarget', 'ValidityStartDate'  ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@EndUserText.label: 'IntegrationObject Object Assignment TP'
//@ClientHandling.algorithm: #SESSION_VARIABLE

define view entity R_REIntegObjectObjAssgmtTP
  as select from I_REObjectAssgmtHier as _REObjectAssgmt
  association to parent R_REIntegrationObjectTP as _REIntegrationObjectTP on $projection.InternalRealEstateNumber = _REIntegrationObjectTP.InternalRealEstateNumber
  association[0..1] to I_REAccountingObject as _REAccountingObject on $projection.REStatusObjectTarget = _REAccountingObject.REAccountingObject
{
  key REStatusObjectSource,
  key REObjectAssignmentType,
  key REStatusObjectTarget,
//  key ValidityStartDate,

  key cast(concat(ValidityStartDate, ValidityEndDate ) as recadateperiod) as ValidityStartEndDateValue,
  key InternalRealEstateNumber,
      @Semantics.businessDate.from: true
      cast( coalesce(ValidityStartDate, '00000000') as rebdvdmvalidfrom ) as ValidityStartDate,
      @Semantics.businessDate.to: true  
      cast( coalesce(ValidityEndDate, '99991231') as rebdvdmvalidto )     as ValidityEndDate,  
      REOnlyInfoAssgmt,
      REStatusObjectSourceIsArchived,
      REGenerationType,
      REIsMainAsset,
      REAssignmentHasMultiple,
      REObjectPossessionStartDate,
      REObjectPossessionEndDate,
      
      REGroupNumber,
      REObjectGroupName,
      REIsLeadingObject,
      
      _REObjectTypeDetails,
      
      _REObjectAssignmentType,
      _REGenerationType,
      
      _REIntegrationObjectTP,
      
      _REAccountingObject
}
where //_REIntegrationObjectTP.RealEstateObjectType = 'J5'

  InternalRealEstateNumber like 'J5%'

Learn More