I_BPCustPartnerFunctionsProcTP

DDL: I_BPCUSTPARTNERFUNCTIONSPROCTP Type: view_entity TRANSACTIONAL

BP Customer Partner Functions Data - TP

I_BPCustPartnerFunctionsProcTP is a Transactional CDS View that provides data about "BP Customer Partner Functions Data - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCustPartnerFunctionsProc) and exposes 34 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, SalesOrganization. It has 8 associations to related views.

1 data source(s) 34 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCustPartnerFunctionsProc I_BPCustPartnerFunctionsProc from

Associations (8)

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..*] I_MDChgProcRecordMessages _RecordMessages $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordMessages.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject
[0..1] I_MDChangeProcessKPIRowVH _KPIUpdateStatusText $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
[1..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunction = _PartnerFunction.PartnerFunction
[0..1] I_ContactPerson _ContactPerson $projection.ContactPerson = _ContactPerson.ContactPerson
[0..1] I_PersonWorkAgreement_1 _PersonWorkAgreement $projection.PersonnelNumber = _PersonWorkAgreement.PersonWorkAgreement
[0..1] I_Customer _ReferenceCustomer $projection.BPCustomerNumber = _ReferenceCustomer.Customer
[0..1] I_Supplier _ReferenceSupplier $projection.Supplier = _ReferenceSupplier.Supplier

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Partner Functions Data - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY SalesOrganization SalesOrganization
KEY DistributionChannel DistributionChannel
KEY Division Division
KEY PartnerFunction PartnerFunction
KEY PartnerCounter PartnerCounter
KEY BPAssignmentID BPAssignmentID
Customer Customer
PartnerFunctionType PartnerFunctionType
PartnerFunctionPartnerNumber PartnerFunctionPartnerNumber
BPCustomerNumber BPCustomerNumber
Supplier Supplier
PersonnelNumber PersonnelNumber
ContactPerson ContactPerson
CustomerPartnerDescription CustomerPartnerDescription
DefaultPartner DefaultPartner
AddressID AddressID
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
_CustomerSalesArea _CustomerSalesArea
_Customer _Customer
_BusinessPartner _BusinessPartner
_RecordType _RecordType
_RecordMessages _RecordMessages
_KPIUpdateStatusText _KPIUpdateStatusText
_PartnerFunction _PartnerFunction
_ReferenceCustomer _ReferenceCustomer
_ReferenceSupplier _ReferenceSupplier
_ContactPerson _ContactPerson
_PersonWorkAgreement _PersonWorkAgreement 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Partner Functions Data - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
define view entity I_BPCustPartnerFunctionsProcTP
  as select from I_BPCustPartnerFunctionsProc
  association        to parent I_BPCustomerSalesAreaProcessTP as _CustomerSalesArea   on  $projection.MasterDataChangeProcess = _CustomerSalesArea.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _CustomerSalesArea.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _CustomerSalesArea.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _CustomerSalesArea.MDChgProcessSrceObject
                                                                                      and $projection.SalesOrganization       = _CustomerSalesArea.SalesOrganization
                                                                                      and $projection.DistributionChannel     = _CustomerSalesArea.DistributionChannel
                                                                                      and $projection.Division                = _CustomerSalesArea.Division
                                                                                      and $projection.BPAssignmentID          = _CustomerSalesArea.BPAssignmentID
  association        to 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..*] to I_MDChgProcRecordMessages             as _RecordMessages      on  $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _RecordMessages.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _RecordMessages.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _RecordMessages.MDChgProcessSrceObject
  association [0..1] to I_MDChangeProcessKPIRowVH             as _KPIUpdateStatusText on  $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
  association [1..1] to I_PartnerFunction                     as _PartnerFunction     on  $projection.PartnerFunction = _PartnerFunction.PartnerFunction
  association [0..1] to I_ContactPerson                       as _ContactPerson       on  $projection.ContactPerson = _ContactPerson.ContactPerson
  association [0..1] to I_PersonWorkAgreement_1               as _PersonWorkAgreement on  $projection.PersonnelNumber = _PersonWorkAgreement.PersonWorkAgreement
  association [0..1] to I_Customer                            as _ReferenceCustomer   on  $projection.BPCustomerNumber = _ReferenceCustomer.Customer
  association [0..1] to I_Supplier                            as _ReferenceSupplier   on  $projection.Supplier = _ReferenceSupplier.Supplier
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key SalesOrganization,
  key DistributionChannel,
  key Division,
  key PartnerFunction,
  key PartnerCounter,
  key BPAssignmentID,
      Customer,
      PartnerFunctionType,
      PartnerFunctionPartnerNumber,
      BPCustomerNumber,
      Supplier,
      PersonnelNumber,
      ContactPerson,
      CustomerPartnerDescription,
      DefaultPartner,
      AddressID,
      MDChgProcSrceLastChgdDateTime,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      cast(
        case
          when MDChgProcessSourceModified = '' then 'N'
          when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified
      ) as MDChgProcKPIUpdateStatus,

      _CustomerSalesArea,
      _Customer,
      _BusinessPartner,
      _RecordType,
      _RecordMessages,
      _KPIUpdateStatusText,
      _PartnerFunction,
      _ReferenceCustomer,
      _ReferenceSupplier,
      _ContactPerson,
      _PersonWorkAgreement
}

Learn More