I_BPCntctPersnWebsiteURLProcTP

DDL: I_BPCNTCTPERSNWEBSITEURLPROCTP Type: view_entity TRANSACTIONAL

Business Partner Workplace Website Proc - TP

I_BPCntctPersnWebsiteURLProcTP is a Transactional CDS View that provides data about "Business Partner Workplace Website Proc - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCntctPersnWebsiteURLProc) and exposes 19 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 4 associations to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCntctPersnWebsiteURLProc I_BPCntctPersnWebsiteURLProc from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_BusPartRelationshipProcessTP _BPRelProcess $projection.MasterDataChangeProcess = _BPRelProcess.MasterDataChangeProcess and $projection.MDChgProcessStep = _BPRelProcess.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BPRelProcess.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BPRelProcess.MDChgProcessSrceObject
[0..1] I_BPRelshpProcessKPIRecordType _RecordType $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordType.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject
[0..1] I_MDChangeProcessKPIRowVH _KPIUpdateStatusText $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
[0..*] I_MDChgProcRecordMessages _RecordMessages $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordMessages.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Partner Workplace Website Proc - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY AddressNumber AddressNumber
KEY OrdinalNumber OrdinalNumber
IsDefaultURLAddress IsDefaultURLAddress
CommNumberIsNotUsed CommNumberIsNotUsed
UniformResourceIdentifierType UniformResourceIdentifierType
SearchURLAddress SearchURLAddress
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
URLFieldLength URLFieldLength
WebsiteURL WebsiteURL
_BPRelProcess _BPRelProcess
_WorkplaceAddress _WorkplaceAddress
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Partner Workplace Website Proc - TP'
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
define view entity I_BPCntctPersnWebsiteURLProcTP
  as select from I_BPCntctPersnWebsiteURLProc
  
  association [1..1] to I_BusPartRelationshipProcessTP        as _BPRelProcess        on  $projection.MasterDataChangeProcess = _BPRelProcess.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _BPRelProcess.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _BPRelProcess.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _BPRelProcess.MDChgProcessSrceObject
  association        to parent I_BPContactPersonAddressProcTP as _WorkplaceAddress    on  $projection.MasterDataChangeProcess = _WorkplaceAddress.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _WorkplaceAddress.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _WorkplaceAddress.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _WorkplaceAddress.MDChgProcessSrceObject
                                                                                      and $projection.AddressNumber           = _WorkplaceAddress.AddressNumber
  association [0..1] to I_BPRelshpProcessKPIRecordType        as _RecordType          on  $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _RecordType.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _RecordType.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _RecordType.MDChgProcessSrceObject
  association [0..1] to I_MDChangeProcessKPIRowVH             as _KPIUpdateStatusText on  $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
  association [0..*] to I_MDChgProcRecordMessages             as _RecordMessages      on  $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _RecordMessages.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _RecordMessages.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _RecordMessages.MDChgProcessSrceObject
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key AddressNumber,
  key OrdinalNumber,
      IsDefaultURLAddress,
      CommNumberIsNotUsed,
      UniformResourceIdentifierType,
      SearchURLAddress,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      /* Record Identification */
      case
        when _WorkplaceAddress.BusinessPartnerFullName <> ''
          then
            case
              when _WorkplaceAddress.AddressNumber <> ''
                then
                concat_with_space(_WorkplaceAddress.BusinessPartnerFullName,
                  concat_with_space(
                    concat_with_space(
                      concat_with_space(
                        concat_with_space(_WorkplaceAddress.StreetName,_WorkplaceAddress.HouseNumber,1)
                      ,_WorkplaceAddress.PostalCode,1)
                    ,_WorkplaceAddress.CityName,1)
                  ,_WorkplaceAddress.Country,1),1)
              else _WorkplaceAddress.BusinessPartnerName
            end
        else ''
      end                                                            as AddressLine1Text,
      cast( case
        when MDChgProcessSourceModified = '' then 'N'
        when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified ) as MDChgProcKPIUpdateStatus,
      URLFieldLength,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      WebsiteURL,

      _BPRelProcess,
      _WorkplaceAddress,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCNTCTPERSNWEBSITEURLPROC",
"I_BPCONTACTPERSONADDRESSPROCTP"
],
"ASSOCIATED":
[
"I_BPCONTACTPERSONADDRESSPROCTP",
"I_BPRELSHPPROCESSKPIRECORDTYPE",
"I_BUSPARTRELATIONSHIPPROCESSTP",
"I_MDCHANGEPROCESSKPIROWVH",
"I_MDCHGPROCRECORDMESSAGES"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More