I_BPCustClfnClAssgmtProcessTP

DDL: I_BPCUSTCLFNCLASSGMTPROCESSTP Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO

Customer classification class assignment - TP

I_BPCustClfnClAssgmtProcessTP is a Transactional CDS View that provides data about "Customer classification class assignment - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCustClfnClAssgmtProcess) and exposes 20 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, ClfnObjectType. It has 4 associations to related views. Part of development package MDC_CUST_STAGING_BO.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCustClfnClAssgmtProcess I_BPCustClfnClAssgmtProcess from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_BPProcessKPIRecordType _RecordType $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordType.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject
[0..1] I_MDChangeProcessKPIRowVH _KPIUpdateStatusText $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
[0..1] I_ClfnClassTypeBasic _ClfnClassType $projection.ClassType = _ClfnClassType.ClassType
[0..1] I_ClfnClass _ClfnClass $projection.ClassInternalID = _ClfnClass.ClassInternalID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Customer classification class assignment - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY ClfnObjectType ClfnObjectType
KEY ClassType ClassType
KEY TimeIntervalNumber TimeIntervalNumber
KEY ClassInternalID ClassInternalID
KEY BPAssignmentID BPAssignmentID
ClassPositionNumber ClassPositionNumber
Class Class
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
_Customer _Customer
_BusinessPartner _BusinessPartner
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_ClfnClassType _ClfnClassType
_ClfnClass _ClfnClass 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Customer classification class assignment - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustClfnClAssgmtProcessTP
  as select from I_BPCustClfnClAssgmtProcess
  association        to parent I_BPCustomerProcessTP 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        to I_BusinessPartnerProcessTP   as _BusinessPartner     on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject
  association [0..1] to I_BPProcessKPIRecordType     as _RecordType          on  $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _RecordType.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _RecordType.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _RecordType.MDChgProcessSrceObject
  association [0..1] to I_MDChangeProcessKPIRowVH    as _KPIUpdateStatusText on  $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
  association [0..1] to I_ClfnClassTypeBasic         as _ClfnClassType       on  $projection.ClassType = _ClfnClassType.ClassType
  association [0..1] to I_ClfnClass                  as _ClfnClass           on  $projection.ClassInternalID = _ClfnClass.ClassInternalID
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key ClfnObjectType,
  key ClassType,
  key TimeIntervalNumber,
  key ClassInternalID,
  key BPAssignmentID,
      ClassPositionNumber,
      Class,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      MDChgProcSrceLastChgdDateTime,
      cast(
        case
          when MDChgProcessSourceModified = '' then 'N'
          when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified preserving type
      ) as MDChgProcKPIUpdateStatus,
      _Customer,
      _BusinessPartner,
      _RecordType,
      _KPIUpdateStatusText,
      _ClfnClassType,
      _ClfnClass
}

Learn More