I_BPCUSTOMERUNLOADINGPOINTPROC

CDS View

BP Customer Partner Unloading Point Data

I_BPCUSTOMERUNLOADINGPOINTPROC is a CDS View in S/4HANA. BP Customer Partner Unloading Point Data. It contains 7 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 7 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BPCustUnldgPointProcChanges view_entity from TRANSACTIONAL BP Customer Unloading Point Process Changes
I_BPCustUnldgPointProcChanges view_entity union_all TRANSACTIONAL BP Customer Unloading Point Process Changes
I_BPCustUnloadingPointGov view_entity from COMPOSITE BP Customer Unloading Point Governance
I_BPCustUnloadingPointProcTP view_entity from TRANSACTIONAL BP Customer Partner Unloading Point Data Process - TP

Fields (7)

KeyField CDS FieldsUsed in Views
KEY BPAssignmentID BPAssignmentID 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
KEY UnloadingPointName MDChgProcessRecordObjectText,UnloadingPointName 1
MDChgProcessSourceModified MDChgProcessSourceModified 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'BP Customer Partner Unloading Point Data'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustomerUnloadingPointProc
  as select from knva_prc
  association [0..1] to I_BPCustomerProcess 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
{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key ablad                    as UnloadingPointName,
  key assignment_id            as BPAssignmentID,
      knfak                    as CustomerFactoryCalenderCode,
      wanid                    as BPGoodsReceivingHoursCode,
      defab                    as IsDfltBPUnloadingPoint,
      kunnr                    as Customer,
      moab1                    as MondayMorningOpeningTime,
      mobi1                    as MondayMorningClosingTime,
      moab2                    as MondayAfternoonOpeningTime,
      mobi2                    as MondayAfternoonClosingTime,
      diab1                    as TuesdayMorningOpeningTime,
      dibi1                    as TuesdayMorningClosingTime,
      diab2                    as TuesdayAfternoonOpeningTime,
      dibi2                    as TuesdayAfternoonClosingTime,
      miab1                    as WednesdayMorningOpeningTime,
      mibi1                    as WednesdayMorningClosingTime,
      miab2                    as WednesdayAfternoonOpeningTime,
      mibi2                    as WednesdayAfternoonClosingTime,
      doab1                    as ThursdayMorningOpeningTime,
      dobi1                    as ThursdayMorningClosingTime,
      doab2                    as ThursdayAfternoonOpeningTime,
      dobi2                    as ThursdayAfternoonClosingTime,
      frab1                    as FridayMorningOpeningTime,
      frbi1                    as FridayMorningClosingTime,
      frab2                    as FridayAfternoonOpeningTime,
      frbi2                    as FridayAfternoonClosingTime,
      saab1                    as SaturdayMorningOpeningTime,
      sabi1                    as SaturdayMorningClosingTime,
      saab2                    as SaturdayAfternoonOpeningTime,
      sabi2                    as SaturdayAfternoonClosingTime,
      soab1                    as SundayMorningOpeningTime,
      sobi1                    as SundayMorningClosingTime,
      soab2                    as SundayAfternoonOpeningTime,
      sobi2                    as SundayAfternoonClosingTime,
      source_recency           as MDChgProcSrceLastChgdDateTime,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      
      _Customer
}
where
     assignment_id = '000000000002'
  or assignment_id is initial

Learn More