I_BPCustomerCompanyTextProcTP

DDL: I_BPCUSTOMERCOMPANYTEXTPROCTP Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO

Customer Company Descr - TP

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

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCustomerCompanyTextProcess I_BPCustomerCompanyTextProcess from

Associations (4)

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

Annotations (7)

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

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

Learn More