I_BPCUSTSALESTEXTGENERALPROC

CDS View

BP Customer Sales Desc General Proc Data

I_BPCUSTSALESTEXTGENERALPROC is a CDS View in S/4HANA. BP Customer Sales Desc General Proc Data. It contains 12 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 12 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BPCustSalesTextGeneralProcTP view_entity from TRANSACTIONAL BP Customer Sales Desc General - TP
I_BPCustSlsTextGeneralProcChgs view_entity from TRANSACTIONAL BP Customer Sales Desc Data Proc Changes
I_BPCustSlsTextGeneralProcChgs view_entity union_all TRANSACTIONAL BP Customer Sales Desc Data Proc Changes
I_BPCustSlsTextProcessChanges view_entity union_all TRANSACTIONAL BP Customer Sales Desc Changes

Fields (12)

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

  association [1..1] to I_BPCustomerProcess          as _Customer      on  knvv_stxh_prc.process_id      = _Customer.MasterDataChangeProcess
                                                                       and knvv_stxh_prc.process_step_no = _Customer.MDChgProcessStep
                                                                       and knvv_stxh_prc.source_system   = _Customer.MDChgProcessSrceSystem
                                                                       and knvv_stxh_prc.source_id       = _Customer.MDChgProcessSrceObject
  association [0..1] to I_BPCustomerSalesAreaProcess as _CustomerSales on  $projection.MasterDataChangeProcess = _CustomerSales.MasterDataChangeProcess
                                                                       and $projection.MDChgProcessStep        = _CustomerSales.MDChgProcessStep
                                                                       and $projection.MDChgProcessSrceSystem  = _CustomerSales.MDChgProcessSrceSystem
                                                                       and $projection.MDChgProcessSrceObject  = _CustomerSales.MDChgProcessSrceObject
                                                                       and $projection.BPAssignmentID          = _CustomerSales.BPAssignmentID
                                                                       and $projection.SalesOrganization       = _CustomerSales.SalesOrganization
                                                                       and $projection.DistributionChannel     = _CustomerSales.DistributionChannel
                                                                       and $projection.Division                = _CustomerSales.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 vkorg                    as SalesOrganization,
  key vtweg                    as DistributionChannel,
  key spart                    as Division,
      assignment_id            as BPAssignmentID,
      kunnr                    as Customer,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      source_recency           as MDChgProcSrceLastChgdDateTime,

      _Customer,
      _CustomerSales
}

Learn More