I_BPCustomerTaxGroupingProcTP

DDL: I_BPCUSTOMERTAXGROUPINGPROCTP Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO

BP Customer Tax Grouping Process Data - TP

I_BPCustomerTaxGroupingProcTP is a Transactional CDS View that provides data about "BP Customer Tax Grouping Process Data - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCustomerTaxGroupingProcess) and exposes 21 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, BPAssignmentID. It has 3 associations to related views. Part of development package MDC_CUST_STAGING_BO.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCustomerTaxGroupingProcess I_BPCustomerTaxGroupingProcess from

Associations (3)

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..1] I_TaxGroupingCode _CustomerTaxGroupingCode $projection.CustomerTaxGroupingCode = _CustomerTaxGroupingCode.TaxGroupingCode and _CustomerTaxGroupingCode.AccountType = 'D'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Tax Grouping Process Data - 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 (21)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY BPAssignmentID BPAssignmentID
KEY CustomerTaxGroupingCode CustomerTaxGroupingCode
Customer Customer
CustTaxGroupSubjectedStartDate CustTaxGroupSubjectedStartDate
CustTaxGroupSubjectedEndDate CustTaxGroupSubjectedEndDate
CustTaxGrpExemptionCertificate CustTaxGrpExemptionCertificate
CustTaxGroupExemptionRate CustTaxGroupExemptionRate
CustTaxGroupExemptionStartDate CustTaxGroupExemptionStartDate
CustTaxGroupExemptionEndDate CustTaxGroupExemptionEndDate
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
_BusinessPartner _BusinessPartner
_Customer _Customer
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_CustomerTaxGroupingCode _CustomerTaxGroupingCode 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Tax Grouping Process Data - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustomerTaxGroupingProcTP
  as select from I_BPCustomerTaxGroupingProcess
  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..1] to I_TaxGroupingCode            as _CustomerTaxGroupingCode on  $projection.CustomerTaxGroupingCode  = _CustomerTaxGroupingCode.TaxGroupingCode
                                                                                 and _CustomerTaxGroupingCode.AccountType = 'D'



{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key BPAssignmentID,
  key CustomerTaxGroupingCode,
      Customer,
      CustTaxGroupSubjectedStartDate,
      CustTaxGroupSubjectedEndDate,
      CustTaxGrpExemptionCertificate,
      CustTaxGroupExemptionRate,
      CustTaxGroupExemptionStartDate,
      CustTaxGroupExemptionEndDate,
      MDChgProcSrceLastChgdDateTime,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      cast(
        case
          when MDChgProcessSourceModified = '' then 'N'
          when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified
      ) as MDChgProcKPIUpdateStatus,

      _BusinessPartner,
      _Customer,
      _RecordType,
      _KPIUpdateStatusText,
      _CustomerTaxGroupingCode
}

Learn More