I_BPCustAddrDepdntTaxIndProcTP

DDL: I_BPCUSTADDRDEPDNTTAXINDPROCTP Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO

Address Dependant Tax Indicator - TP

I_BPCustAddrDepdntTaxIndProcTP is a Transactional CDS View that provides data about "Address Dependant Tax Indicator - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCustAddrDepdntTaxIndProc) and exposes 22 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 7 associations to related views. Part of development package MDC_CUST_STAGING_BO.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCustAddrDepdntTaxIndProc I_BPCustAddrDepdntTaxIndProc from

Associations (7)

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
[0..1] I_Country _Country $projection.DepartureCountry = _Country.Country
[0..1] I_ConditionType _TaxCategory $projection.CustomerTaxCategory = _TaxCategory.ConditionType and _TaxCategory.ConditionUsage = 'A' and _TaxCategory.ConditionApplication = 'V'
[0..1] I_CustomerTaxClassification _TaxClassification $projection.CustomerTaxClassification = _TaxClassification.CustomerTaxClassification and $projection.CustomerTaxCategory = _TaxClassification.CustomerTaxCategory

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Address Dependant Tax Indicator - 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 (22)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY AddressNumber AddressNumber
KEY DepartureCountry DepartureCountry
KEY CustomerTaxCategory CustomerTaxCategory
KEY BPAssignmentID BPAssignmentID
Customer Customer
CustomerTaxClassification CustomerTaxClassification
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
_Customer _Customer
_BPProtectedAddress _BPProtectedAddress
_BusinessPartner _BusinessPartner
_RecordType _RecordType
_RecordMessages _RecordMessages
_KPIUpdateStatusText _KPIUpdateStatusText
_Country _Country
_TaxCategory _TaxCategory
_TaxClassification _TaxClassification 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Address Dependant Tax Indicator - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustAddrDepdntTaxIndProcTP
  as select from I_BPCustAddrDepdntTaxIndProc
  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
  association [0..1] to I_Country                    as _Country             on  $projection.DepartureCountry = _Country.Country
  association [0..1] to I_ConditionType              as _TaxCategory         on  $projection.CustomerTaxCategory   = _TaxCategory.ConditionType
                                                                             and _TaxCategory.ConditionUsage       = 'A'
                                                                             and _TaxCategory.ConditionApplication = 'V'
  association [0..1] to I_CustomerTaxClassification  as _TaxClassification   on  $projection.CustomerTaxClassification = _TaxClassification.CustomerTaxClassification
                                                                             and $projection.CustomerTaxCategory       = _TaxClassification.CustomerTaxCategory
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key AddressNumber,
  key DepartureCountry,
  key CustomerTaxCategory,
  key BPAssignmentID,
      Customer,
//      Adrnr,

      CustomerTaxClassification,
      MDChgProcSrceLastChgdDateTime,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      cast(
        case
          when MDChgProcessSourceModified = '' then 'N'
          when MDChgProcessSourceModified = 'X' then 'M'
          else MDChgProcessSourceModified
        end as mdc_source_modified
      ) as MDChgProcKPIUpdateStatus,
      
      /* Associations */
      _Customer,
      _BPProtectedAddress,
      _BusinessPartner,
      _RecordType,
      _RecordMessages,
      _KPIUpdateStatusText,
      _Country,
      _TaxCategory,
      _TaxClassification
}

Learn More