I_BPCustCoTextGeneralProcessTP

DDL: I_BPCUSTCOTEXTGENERALPROCESSTP Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO

Customer Company Descr General - TP

I_BPCustCoTextGeneralProcessTP is a Transactional CDS View that provides data about "Customer Company Descr General - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCustCoTextGeneralProcess) and exposes 21 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) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCustCoTextGeneralProcess I_BPCustCoTextGeneralProcess 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
[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
[0..*] I_BPCustomerCompanyTextProcTP _CustomerCompanyText

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Customer Company Descr General - 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 (21)

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 CompanyCode CompanyCode
KEY BPAssignmentID BPAssignmentID
Customer Customer
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
_CustomerCompanyCode _CustomerCompanyCode
_Customer _Customer
_BusinessPartner _BusinessPartner
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages
_CustomerCompanyText _CustomerCompanyText 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Customer Company Descr General - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustCoTextGeneralProcessTP
  as select from I_BPCustCoTextGeneralProcess
  association        to parent I_BPCustomerCompanyProcessTP as _CustomerCompanyCode on  $projection.MasterDataChangeProcess = _CustomerCompanyCode.MasterDataChangeProcess
                                                                                    and $projection.MDChgProcessStep        = _CustomerCompanyCode.MDChgProcessStep
                                                                                    and $projection.MDChgProcessSrceSystem  = _CustomerCompanyCode.MDChgProcessSrceSystem
                                                                                    and $projection.MDChgProcessSrceObject  = _CustomerCompanyCode.MDChgProcessSrceObject
                                                                                    and $projection.BPAssignmentID          = _CustomerCompanyCode.BPAssignmentID
                                                                                    and $projection.CompanyCode             = _CustomerCompanyCode.CompanyCode

  association        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 [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 [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

  composition [0..*] of I_BPCustomerCompanyTextProcTP       as _CustomerCompanyText
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key ApplicationTextObjectType,
  key TextObjectKey,
  key LongTextID,
  key Language,
  key CompanyCode,
  key BPAssignmentID,
      Customer,
      MDChgProcSrceLastChgdDateTime,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      cast(
        case
          when MDChgProcessSourceModified = '' then 'N'
          when MDChgProcessSourceModified = 'X' then 'M'
          else MDChgProcessSourceModified
        end as mdc_source_modified
      ) as MDChgProcKPIUpdateStatus,

      /* Associations */
      _CustomerCompanyCode,
      _Customer,
      _BusinessPartner,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages,
      _CustomerCompanyText
}

Learn More