I_BPCustAddrDepdntInfoProcTP

DDL: I_BPCUSTADDRDEPDNTINFOPROCTP Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO

BP Customer Address Dependent Information - TP

I_BPCustAddrDepdntInfoProcTP is a Transactional CDS View that provides data about "BP Customer Address Dependent Information - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCustAddrDepdntInfoProcess) and exposes 28 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 4 associations to related views. Part of development package MDC_CUST_STAGING_BO.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCustAddrDepdntInfoProcess I_BPCustAddrDepdntInfoProcess from

Associations (4)

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..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
[0..1] E_BPCustAddrDepdntInfoProcess _ExtBPCustAddrDepdntInfoProc $projection.MasterDataChangeProcess = _ExtBPCustAddrDepdntInfoProc.MasterDataChangeProcess and $projection.MDChgProcessStep = _ExtBPCustAddrDepdntInfoProc.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _ExtBPCustAddrDepdntInfoProc.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _ExtBPCustAddrDepdntInfoProc.MDChgProcessSrceObject and $projection.AddressNumber = _ExtBPCustAddrDepdntInfoProc.AddressNumber

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Address Dependent Information - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY AddressNumber AddressNumber
KEY BPAssignmentID BPAssignmentID
Customer Customer
ExpressTrainStationName ExpressTrainStationName
TrainStationName TrainStationName
CityCode CityCode
County County
CustomerHasUnloadingPoint CustomerHasUnloadingPoint
ExciseControlCodeNumber ExciseControlCodeNumber
ExciseRegistrationNumber ExciseRegistrationNumber
ExciseRange ExciseRange
ExciseDivision ExciseDivision
ExciseCommissionerate ExciseCommissionerate
CustomerIsExciseTaxRelevant CustomerIsExciseTaxRelevant
IN_GSTTxDdctdAtSrceRegn IN_GSTTxDdctdAtSrceRegn
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
_Customer _Customer
_BusinessPartner _BusinessPartner
_RecordType _RecordType
_RecordMessages _RecordMessages
_KPIUpdateStatusText _KPIUpdateStatusText
_BPProtectedAddress _BPProtectedAddress 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Address Dependent Information - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustAddrDepdntInfoProcTP
  as select from I_BPCustAddrDepdntInfoProcess

  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        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
  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 MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key AddressNumber,
  key BPAssignmentID,
      Customer,
      ExpressTrainStationName,
      TrainStationName,
      CityCode,
      County,
      CustomerHasUnloadingPoint,
      ExciseControlCodeNumber,
      ExciseRegistrationNumber,
      ExciseRange,
      ExciseDivision,
      ExciseCommissionerate,
      @Semantics.booleanIndicator
      CustomerIsExciseTaxRelevant,
      IN_GSTTxDdctdAtSrceRegn,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      MDChgProcSrceLastChgdDateTime,
      cast(
        case
          when MDChgProcessSourceModified = '' then 'N'
          when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified
      ) as MDChgProcKPIUpdateStatus,

      _Customer,
      _BusinessPartner,
      _RecordType,
      _RecordMessages,
      _KPIUpdateStatusText,
      _BPProtectedAddress
}

Learn More