I_BPCustSalesTextGeneralProc

DDL: I_BPCUSTSALESTEXTGENERALPROC Type: view_entity BASIC Package: MDC_CUST_STAGING_BO

BP Customer Sales Desc General Proc Data

I_BPCustSalesTextGeneralProc is a Basic CDS View that provides data about "BP Customer Sales Desc General Proc Data" in SAP S/4HANA. It reads from 1 data source (knvv_stxh_prc) and exposes 18 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, ApplicationTextObjectType. It has 2 associations to related views. Part of development package MDC_CUST_STAGING_BO.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
knvv_stxh_prc knvv_stxh_prc from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BPCustomerProcess _Customer 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
[0..1] I_BPCustomerSalesAreaProcess _CustomerSales $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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Sales Desc General Proc Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess process_id
KEY MDChgProcessStep process_step_no
KEY MDChgProcessSrceSystem source_system
KEY MDChgProcessSrceObject source_id
KEY ApplicationTextObjectType tdobject
KEY TextObjectKey tdname
KEY LongTextID tdid
KEY Language tdspras
KEY SalesOrganization vkorg
KEY DistributionChannel vtweg
KEY Division spart
BPAssignmentID assignment_id
Customer kunnr
MDChgProcessSourceModified source_modified
MDChgProcessSourceModifBinary source_modification_blip
MDChgProcSrceLastChgdDateTime source_recency
_Customer _Customer
_CustomerSales _CustomerSales 
@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