I_BPCustDocumentAssgmtProcTP

DDL: I_BPCUSTDOCUMENTASSGMTPROCTP Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO

BP Customer Document Assignment - TP

I_BPCustDocumentAssgmtProcTP is a Transactional CDS View that provides data about "BP Customer Document Assignment - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCustDocumentAssgmtProc) and exposes 32 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, DocumentInfoRecordDocType. It has 4 associations to related views. Part of development package MDC_CUST_STAGING_BO.

1 data source(s) 32 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCustDocumentAssgmtProc I_BPCustDocumentAssgmtProc from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerProcessTP _BusinessPartner $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject
[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..*] I_MDChgProcRecordMessages _RecordMessages $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordMessages.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Document Assignment - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY DocumentInfoRecordDocType DocumentInfoRecordDocType
KEY DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber
KEY DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion
KEY DocumentInfoRecordDocPart DocumentInfoRecordDocPart
KEY LinkedSAPObject LinkedSAPObject
KEY LinkedSAPObjectKey LinkedSAPObjectKey
KEY DocObjectLinkCounter DocObjectLinkCounter
KEY BPAssignmentID BPAssignmentID
Customer Customer
DocInfoRecdLinkStatus DocInfoRecdLinkStatus
DocInfoRecdObjectLinkStatus DocInfoRecdObjectLinkStatus
ObjectTypeDatabaseTable ObjectTypeDatabaseTable
DocInfoRecdAdditionalObjectKey DocInfoRecdAdditionalObjectKey
DocLinkDirectionIsActive DocLinkDirectionIsActive
IsDefaultDocument IsDefaultDocument
DocInfoRecdIsMarkedForDeletion DocInfoRecdIsMarkedForDeletion
DocInfoRecdLongTextUUID DocInfoRecdLongTextUUID
IsDocInfoRecdCreatedFromCAD IsDocInfoRecdCreatedFromCAD
DocInfoRecdConfignMgmtFixed DocInfoRecdConfignMgmtFixed
IsArchived IsArchived
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages
_Customer _Customer
_BusinessPartner _BusinessPartner 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Document Assignment - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustDocumentAssgmtProcTP 
 as select from I_BPCustDocumentAssgmtProc

  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 [1..1] 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..*] 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

{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key DocumentInfoRecordDocType,
  key DocumentInfoRecordDocNumber,
  key DocumentInfoRecordDocVersion,
  key DocumentInfoRecordDocPart,
  key LinkedSAPObject,
  key LinkedSAPObjectKey,
  key DocObjectLinkCounter,
  key BPAssignmentID,
      Customer,
      DocInfoRecdLinkStatus,
      DocInfoRecdObjectLinkStatus,
      ObjectTypeDatabaseTable,
      DocInfoRecdAdditionalObjectKey,
      @Semantics.booleanIndicator: true
      DocLinkDirectionIsActive,
      IsDefaultDocument,
      @Semantics.booleanIndicator: true
      DocInfoRecdIsMarkedForDeletion,
      @Semantics.uuid: true
      DocInfoRecdLongTextUUID,
      @Semantics.booleanIndicator: true
      IsDocInfoRecdCreatedFromCAD,
      DocInfoRecdConfignMgmtFixed,
      IsArchived,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      MDChgProcSrceLastChgdDateTime,
      cast( case
      when MDChgProcessSourceModified = '' then 'N'
      when MDChgProcessSourceModified = 'X' then 'M'
      else MDChgProcessSourceModified end as mdc_source_modified ) as MDChgProcKPIUpdateStatus,
      /* Associations */
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages,
      _Customer,
      _BusinessPartner
}

Learn More