I_BPCUSTADDRDEPDNTINFOPROCESS

CDS View

BP Customer Address Dependent Information

I_BPCUSTADDRDEPDNTINFOPROCESS is a CDS View in S/4HANA. BP Customer Address Dependent Information. It contains 7 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 7 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPCustAddrDepdntInfoProcChgs view_entity from TRANSACTIONAL BP Cust Address Dependent Information Proc Changes
I_BPCustAddrDepdntInfoProcChgs view_entity union_all TRANSACTIONAL BP Cust Address Dependent Information Proc Changes
I_BPCustAddrDepdntInfoProcTP view_entity from TRANSACTIONAL BP Customer Address Dependent Information - TP

Fields (7)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber 1
KEY BPAssignmentID BPAssignmentID 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
MDChgProcessSourceModified MDChgProcessSourceModified 1 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'BP Customer Address Dependent Information'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #BASIC

@Search.searchable: true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustAddrDepdntInfoProcess
  as select from kna1_addr_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
  association [0..1] to I_BusPartProtectedAddressProc as _BPProtectedAddress          on  $projection.MasterDataChangeProcess = _BPProtectedAddress.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _BPProtectedAddress.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _BPProtectedAddress.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _BPProtectedAddress.MDChgProcessSrceObject
                                                                                      and $projection.AddressNumber           = _BPProtectedAddress.AddressNumber
  association [0..1] to E_BPCustAddrDepdntInfoProcess as _ExtBPCustAddrDepdntInfoProc on  $projection.MasterDataChangeProcess = _ExtBPCustAddrDepdntInfoProc.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _ExtBPCustAddrDepdntInfoProc.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _ExtBPCustAddrDepdntInfoProc.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _ExtBPCustAddrDepdntInfoProc.MDChgProcessSrceObject
                                                                                      and $projection.AddressNumber           = _ExtBPCustAddrDepdntInfoProc.AddressNumber
{

  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key source_addrnumber        as AddressNumber,
  key '000000000002'           as BPAssignmentID, //asigment_id

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      kunnr                    as Customer,
      //adrnr as AddressID,

      bahne                    as ExpressTrainStationName,
      bahns                    as TrainStationName,
      cityc                    as CityCode,
      counc                    as County,
      exabl                    as CustomerHasUnloadingPoint,

      // kna1_addr_eew_cust as Kna1AddrEewCust,

      j_1iexcd                 as ExciseControlCodeNumber,
      j_1iexrn                 as ExciseRegistrationNumber,
      j_1iexrg                 as ExciseRange,
      j_1iexdi                 as ExciseDivision,
      j_1iexco                 as ExciseCommissionerate,
      @Semantics.booleanIndicator
      j_1iexcicu               as CustomerIsExciseTaxRelevant,
      gst_tds                  as IN_GSTTxDdctdAtSrceRegn,

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

}
//where

//     assignment_id = '000000000002'

//  or assignment_id is initial

Learn More