I_BPCustomerTextProcessTP

DDL: I_BPCUSTOMERTEXTPROCESSTP Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO

BP Customer Description - TP

I_BPCustomerTextProcessTP is a Transactional CDS View that provides data about "BP Customer Description - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCustomerTextProcess) and exposes 22 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, ApplicationTextObjectType. It has 5 associations to related views. Part of development package MDC_CUST_STAGING_BO.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCustomerTextProcess I_BPCustomerTextProcess from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerProcessTP _BusinessPartner $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject
[1..1] I_BPCustomerProcessTP _Customer $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess and $projection.MDChgProcessStep = _Customer.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Customer.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Customer.MDChgProcessSrceObject and $projection.BPAssignmentID = _Customer.BPAssignmentID
[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 (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Description - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY ApplicationTextObjectType ApplicationTextObjectType
KEY TextObjectKey TextObjectKey
KEY LongTextID LongTextID
KEY Language Language
KEY MasterDataTextLineIdentifier MasterDataTextLineIdentifier
KEY BPAssignmentID BPAssignmentID
Customer Customer
LineTextFormat LineTextFormat
MasterDataLineText MasterDataLineText
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
_Customer _Customer
_BusinessPartner _BusinessPartner
_CustomerTextGeneral _CustomerTextGeneral
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Description - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustomerTextProcessTP
  as select from I_BPCustomerTextProcess
  association [1..1] to 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 [1..1] to I_BPCustomerProcessTP                as _Customer            on  $projection.MasterDataChangeProcess   = _Customer.MasterDataChangeProcess
                                                                                     and $projection.MDChgProcessStep          = _Customer.MDChgProcessStep
                                                                                     and $projection.MDChgProcessSrceSystem    = _Customer.MDChgProcessSrceSystem
                                                                                     and $projection.MDChgProcessSrceObject    = _Customer.MDChgProcessSrceObject
                                                                                     and $projection.BPAssignmentID            = _Customer.BPAssignmentID
  association        to parent I_BPCustomerTextGeneralProcTP as _CustomerTextGeneral on  $projection.MasterDataChangeProcess   = _CustomerTextGeneral.MasterDataChangeProcess
                                                                                     and $projection.MDChgProcessStep          = _CustomerTextGeneral.MDChgProcessStep
                                                                                     and $projection.MDChgProcessSrceSystem    = _CustomerTextGeneral.MDChgProcessSrceSystem
                                                                                     and $projection.MDChgProcessSrceObject    = _CustomerTextGeneral.MDChgProcessSrceObject
                                                                                     and $projection.ApplicationTextObjectType = _CustomerTextGeneral.ApplicationTextObjectType
                                                                                     and $projection.TextObjectKey             = _CustomerTextGeneral.TextObjectKey
                                                                                     and $projection.LongTextID                = _CustomerTextGeneral.LongTextID
                                                                                     and $projection.Language                  = _CustomerTextGeneral.Language
                                                                                     and $projection.BPAssignmentID            = _CustomerTextGeneral.BPAssignmentID
  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 ApplicationTextObjectType,
  key TextObjectKey,
  key LongTextID,
  key Language,
  key MasterDataTextLineIdentifier,
  key BPAssignmentID,
      Customer,
      LineTextFormat,
      MasterDataLineText,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      MDChgProcSrceLastChgdDateTime,
      cast(
        case
          when MDChgProcessSourceModified = '' then 'N'
          when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified preserving type
      ) as MDChgProcKPIUpdateStatus,
      /* Associations */
      _Customer,
      _BusinessPartner,
      _CustomerTextGeneral,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}

Learn More