I_BPCUSTOMERTEXTGENERALPROCESS

CDS View

BP Customer Gerneral Desc Process Data

I_BPCUSTOMERTEXTGENERALPROCESS is a CDS View in S/4HANA. BP Customer Gerneral Desc Process Data. It contains 9 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPCustomerTextGeneralProcTP view_entity from TRANSACTIONAL BP Customer Gerneral Desc Process Data - TP
I_BPCustTextGeneralProcChgs view_entity from TRANSACTIONAL BP Customer Desc Data Process Changes
I_BPCustTextGeneralProcChgs view_entity union_all TRANSACTIONAL BP Customer Desc Data Process Changes

Fields (9)

KeyField CDS FieldsUsed in Views
KEY ApplicationTextObjectType ApplicationTextObjectType 1
KEY Language Language 1
KEY LongTextID LongTextID 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
KEY TextObjectKey TextObjectKey 1
MDChgProcessSourceModified MDChgProcessSourceModified 1
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Gerneral Desc Process Data'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustomerTextGeneralProcess
  as select from kna1_stxh_prc

  association [1..1] to I_BPCustomerProcess as _Customer on  kna1_stxh_prc.process_id      = _Customer.MasterDataChangeProcess
                                                         and kna1_stxh_prc.process_step_no = _Customer.MDChgProcessStep
                                                         and kna1_stxh_prc.source_system   = _Customer.MDChgProcessSrceSystem
                                                         and kna1_stxh_prc.source_id       = _Customer.MDChgProcessSrceObject

{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key tdobject                 as ApplicationTextObjectType,
  key tdname                   as TextObjectKey,
  key tdid                     as LongTextID,
  key tdspras                  as Language,
      assignment_id            as BPAssignmentID,
      kunnr                    as Customer,
      //      target_assignment_id     as TargetAssignmentId,

      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      source_recency           as MDChgProcSrceLastChgdDateTime,
      /* Associations */
      _Customer
}
where
     assignment_id = '000000000002'
  or assignment_id is initial