I_BPCUSTOMERCOMPANYTEXTPROCESS

CDS View

Customer Company Descr Base

I_BPCUSTOMERCOMPANYTEXTPROCESS is a CDS View in S/4HANA. Customer Company Descr Base. It contains 11 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 11 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPCustomerCompanyTextProcTP view_entity from TRANSACTIONAL Customer Company Descr - TP
I_BPCustomerCompanyTxtProcChgs view_entity from TRANSACTIONAL Customer Company Descr Process Changes
I_BPCustomerCompanyTxtProcChgs view_entity union_all TRANSACTIONAL Customer Company Descr Process Changes

Fields (11)

KeyField CDS FieldsUsed in Views
KEY ApplicationTextObjectType ApplicationTextObjectType 1
KEY BPAssignmentID BPAssignmentID 1
KEY CompanyCode CompanyCode 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: 'Customer Company Descr Base'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustomerCompanyTextProcess
  as select from knb1_stxl_prc
  association [0..1] to I_BPCustomerProcess          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 [0..1] to I_BPCustCoTextGeneralProcess as _CustomerCompanyTextGeneral on  $projection.MasterDataChangeProcess   = _CustomerCompanyTextGeneral.MasterDataChangeProcess
                                                                                    and $projection.MDChgProcessStep          = _CustomerCompanyTextGeneral.MDChgProcessStep
                                                                                    and $projection.MDChgProcessSrceSystem    = _CustomerCompanyTextGeneral.MDChgProcessSrceSystem
                                                                                    and $projection.MDChgProcessSrceObject    = _CustomerCompanyTextGeneral.MDChgProcessSrceObject
                                                                                    and $projection.ApplicationTextObjectType = _CustomerCompanyTextGeneral.ApplicationTextObjectType
                                                                                    and $projection.TextObjectKey             = _CustomerCompanyTextGeneral.TextObjectKey
                                                                                    and $projection.LongTextID                = _CustomerCompanyTextGeneral.LongTextID
                                                                                    and $projection.Language                  = _CustomerCompanyTextGeneral.Language
                                                                                    and $projection.BPAssignmentID            = _CustomerCompanyTextGeneral.BPAssignmentID
                                                                                    and $projection.CompanyCode               = _CustomerCompanyTextGeneral.CompanyCode
{
  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,
  key assignment_id            as BPAssignmentID,
  key bukrs                    as CompanyCode,
  key line_counter             as MasterDataTextLineIdentifier,
      kunnr                    as Customer,
      tdformat                 as LineTextFormat,
      tdline                   as MasterDataLineText,
      source_recency           as MDChgProcSrceLastChgdDateTime,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      /* Associations */
      _Customer,
      _CustomerCompanyTextGeneral
}
where
  (
       assignment_id = '000000000002'
    or assignment_id is initial
  )
  and  srtf2         = 0

Learn More