I_BPCUSTDOCUMENTASSGMTPROC

CDS View

BP Customer Document Assignment

I_BPCUSTDOCUMENTASSGMTPROC is a CDS View in S/4HANA. BP Customer Document Assignment. It contains 12 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 12 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPCustDocAssgmtProcChanges view_entity from TRANSACTIONAL BP Customer Document Assignment Changes
I_BPCustDocAssgmtProcChanges view_entity union_all TRANSACTIONAL BP Customer Document Assignment Changes
I_BPCustDocumentAssgmtProcTP view_entity from TRANSACTIONAL BP Customer Document Assignment - TP

Fields (12)

KeyField CDS FieldsUsed in Views
KEY DocObjectLinkCounter DocObjectLinkCounter 1
KEY DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber 1
KEY DocumentInfoRecordDocPart DocumentInfoRecordDocPart 1
KEY DocumentInfoRecordDocType DocumentInfoRecordDocType 1
KEY DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion 1
KEY LinkedSAPObject LinkedSAPObject 1
KEY LinkedSAPObjectKey LinkedSAPObjectKey 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
MDChgProcessSourceModified MDChgProcessSourceModified 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Document Assignment'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustDocumentAssgmtProc
  as select from kna1_drad_prc

  association [1..1] to I_BPCustomerProcess as _Customer on  kna1_drad_prc.process_id      = _Customer.MasterDataChangeProcess
                                                         and kna1_drad_prc.process_step_no = _Customer.MDChgProcessStep
                                                         and kna1_drad_prc.source_system   = _Customer.MDChgProcessSrceSystem
                                                         and kna1_drad_prc.source_id       = _Customer.MDChgProcessSrceObject
{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key dokar                    as DocumentInfoRecordDocType,
  key doknr                    as DocumentInfoRecordDocNumber,
  key dokvr                    as DocumentInfoRecordDocVersion,
  key doktl                    as DocumentInfoRecordDocPart,
  key dokob                    as LinkedSAPObject,
  key obzae                    as DocObjectLinkCounter,
  key objky                    as LinkedSAPObjectKey,
      assignment_id            as BPAssignmentID,
      kunnr                    as Customer,
      vrkstat                  as DocInfoRecdLinkStatus,
      vrkstat1                 as DocInfoRecdObjectLinkStatus,
      vobj                     as ObjectTypeDatabaseTable,
      vkey                     as DocInfoRecdAdditionalObjectKey,
      @Semantics.booleanIndicator: true
      vdir                     as DocLinkDirectionIsActive,
      viewflag                 as IsDefaultDocument,
      @Semantics.booleanIndicator: true
      delflag                  as DocInfoRecdIsMarkedForDeletion,
      @Semantics.uuid: true
      longtext_id              as DocInfoRecdLongTextUUID,
      @Semantics.booleanIndicator: true
      cad_pos                  as IsDocInfoRecdCreatedFromCAD,
      cm_fixed                 as DocInfoRecdConfignMgmtFixed,
      archflag                 as IsArchived,



      //      dummy_drad_incl_eew_ps   as DummyDradInclEewPs,

      //      target_assignment_id     as TargetAssignmentId,

      //      bo_altkey                as BoAltkey,


      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      source_recency           as MDChgProcSrceLastChgdDateTime,

      _Customer

}
where
     assignment_id = '000000000002'
  or assignment_id is initial

Learn More