I_BPCUSTOMERSALESTEXTPROCESS

CDS View

BP Customer Sales Desc Process Data

I_BPCUSTOMERSALESTEXTPROCESS is a CDS View in S/4HANA. BP Customer Sales Desc Process Data. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BPCustomerSalesTextProcessTP view_entity from TRANSACTIONAL BP Customer Sales Desc Process Data - TP
I_BPCustSlsTextProcessChanges view_entity from TRANSACTIONAL BP Customer Sales Desc Changes 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Sales 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_BPCustomerSalesTextProcess
  as select from knvv_stxl_prc
  association [1..1] to I_BPCustomerProcess          as _Customer                 on  knvv_stxl_prc.process_id      = _Customer.MasterDataChangeProcess
                                                                                  and knvv_stxl_prc.process_step_no = _Customer.MDChgProcessStep
                                                                                  and knvv_stxl_prc.source_system   = _Customer.MDChgProcessSrceSystem
                                                                                  and knvv_stxl_prc.source_id       = _Customer.MDChgProcessSrceObject

  association [0..1] to I_BPCustSalesTextGeneralProc as _CustomerSalesTextGeneral on  $projection.MasterDataChangeProcess   = _CustomerSalesTextGeneral.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep          = _CustomerSalesTextGeneral.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem    = _CustomerSalesTextGeneral.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject    = _CustomerSalesTextGeneral.MDChgProcessSrceObject
                                                                                  and $projection.ApplicationTextObjectType = _CustomerSalesTextGeneral.ApplicationTextObjectType
                                                                                  and $projection.TextObjectKey             = _CustomerSalesTextGeneral.TextObjectKey
                                                                                  and $projection.LongTextID                = _CustomerSalesTextGeneral.LongTextID
                                                                                  and $projection.Language                  = _CustomerSalesTextGeneral.Language
                                                                                  and $projection.BPAssignmentID            = _CustomerSalesTextGeneral.BPAssignmentID
                                                                                  and $projection.SalesOrganization         = _CustomerSalesTextGeneral.SalesOrganization
                                                                                  and $projection.DistributionChannel       = _CustomerSalesTextGeneral.DistributionChannel
                                                                                  and $projection.Division                  = _CustomerSalesTextGeneral.Division

{

  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 line_counter             as MasterDataTextLineIdentifier,
  key vkorg                    as SalesOrganization,
  key vtweg                    as DistributionChannel,
  key spart                    as Division,
      assignment_id            as BPAssignmentID,
      kunnr                    as Customer,
      tdformat                 as LineTextFormat,
      tdline                   as MasterDataLineText,
      source_recency           as MDChgProcSrceLastChgdDateTime,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      /* Associations */
      _Customer,
      _CustomerSalesTextGeneral
}
where
  (
       assignment_id = '000000000002'
    or assignment_id is initial
  )
  and  srtf2         = 0

Learn More