I_BusPartIndustryProcTP

DDL: I_BUSPARTINDUSTRYPROCTP Type: view_entity TRANSACTIONAL

Business Partner Industry (Process Data)

I_BusPartIndustryProcTP is a Transactional CDS View that provides data about "Business Partner Industry (Process Data)" in SAP S/4HANA. It reads from 1 data source (I_BusPartIndustryProc) and exposes 18 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, IndustrySystemType. It has 5 associations to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_BusPartIndustryProc I_BusPartIndustryProc from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_BusPartIndustryKey _BusPartIndustryKey $projection.IndustrySystemType = _BusPartIndustryKey.IndustrySystemType and $projection.IndustrySector = _BusPartIndustryKey.IndustrySector
[0..1] I_BusPartIndustrySystem _BusPartIndustrySystem $projection.IndustrySystemType = _BusPartIndustrySystem.IndustrySystemType
[0..1] I_BPProcessKPIRecordType _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 (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Partner Industry (Process Data) view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY IndustrySystemType IndustrySystemType
KEY IndustrySector IndustrySector
BusinessPartner BusinessPartner
IsStandardIndustry IsStandardIndustry
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
AddressLine1Text
_BusinessPartner _BusinessPartner
_BusPartIndustryKey _BusPartIndustryKey
_BusPartIndustrySystem _BusPartIndustrySystem
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Partner Industry (Process Data)'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view entity I_BusPartIndustryProcTP
  as select from I_BusPartIndustryProc
  association        to parent I_BusinessPartnerProcessTP as _BusinessPartner       on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                                    and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                                    and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                                    and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject
  association [0..1] to I_BusPartIndustryKey              as _BusPartIndustryKey    on  $projection.IndustrySystemType = _BusPartIndustryKey.IndustrySystemType
                                                                                    and $projection.IndustrySector     = _BusPartIndustryKey.IndustrySector
  association [0..1] to I_BusPartIndustrySystem           as _BusPartIndustrySystem on  $projection.IndustrySystemType = _BusPartIndustrySystem.IndustrySystemType
  association [0..1] to I_BPProcessKPIRecordType          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 IndustrySystemType,
      @Search.defaultSearchElement: true
  key IndustrySector,
      BusinessPartner,
      IsStandardIndustry,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      MDChgProcSrceLastChgdDateTime,
      
      /* Record Identification */
      /* Has been moved to a virtual field in the projection layer, therefore the dummy entry */
      cast( '' as abap.char(209) )  as AddressLine1Text,
      cast( case
        when MDChgProcessSourceModified = '' then 'N'
        when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified ) as MDChgProcKPIUpdateStatus,

      _BusinessPartner,
      _BusPartIndustryKey,
      _BusPartIndustrySystem,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSPARTINDUSTRYPROC"
],
"ASSOCIATED":
[
"I_BPPROCESSKPIRECORDTYPE",
"I_BUSINESSPARTNERPROCESSTP",
"I_BUSPARTINDUSTRYKEY",
"I_BUSPARTINDUSTRYSYSTEM",
"I_MDCHANGEPROCESSKPIROWVH",
"I_MDCHGPROCRECORDMESSAGES"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More