I_BPCustTaxIndicatorProcChgs

Q: Which tables does I_BPCustTaxIndicatorProcChgs use?

I_BPCustTaxIndicatorProcChgs reads from 2 data source(s): I_BPCustomerTaxIndicatorProc, I_BPCustomerTaxIndicatorProc.

Q: How many fields does I_BPCustTaxIndicatorProcChgs have?

I_BPCustTaxIndicatorProcChgs has 37 fields. Key fields: MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, DepartureCountry.

DDL: I_BPCUSTTAXINDICATORPROCCHGS Type: view_entity TRANSACTIONAL

BP Customer Tax Indicator Process Changes

I_BPCustTaxIndicatorProcChgs is a Transactional CDS View that provides data about "BP Customer Tax Indicator Process Changes" in SAP S/4HANA. It reads from 2 data sources (I_BPCustomerTaxIndicatorProc, I_BPCustomerTaxIndicatorProc) and exposes 37 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, DepartureCountry. It has 3 associations to related views.

Data Sources (2)

Source	Alias	Join Type
I_BPCustomerTaxIndicatorProc	Current	from
I_BPCustomerTaxIndicatorProc	Current	union_all

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_BPCustomerProcess	_Customer	`$projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess and $projection.MDChgProcessStep = _Customer.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Customer.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Customer.MDChgProcessSrceObject`
[0..1]	I_CountryText	_CountryText	`$projection.DepartureCountry = _CountryText.Country and _CountryText.Language = $session.system_language`
[0..1]	I_ConditionTypeText	_TaxCategoryText	`$projection.CustomerTaxCategory = _TaxCategoryText.ConditionType and _TaxCategoryText.ConditionUsage = 'A' and _TaxCategoryText.ConditionApplication = 'V' and _TaxCategoryText.Language = $session.system_language`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	BP Customer Tax Indicator Process Changes	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#TRANSACTIONAL	view

Fields (37)

Key	Field	Source Table	Source Field
KEY	MasterDataChangeProcess	I_BPCustomerTaxIndicatorProc	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPCustomerTaxIndicatorProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPCustomerTaxIndicatorProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BPCustomerTaxIndicatorProc	MDChgProcessSrceObject
KEY	DepartureCountry	I_BPCustomerTaxIndicatorProc	DepartureCountry
KEY	CustomerTaxCategory	I_BPCustomerTaxIndicatorProc	CustomerTaxCategory
KEY	MDChgProcessModelTableName	ModelTable	MDChgProcessModelTableName
KEY	MDChangeProcessModelFieldName
KEY	char1000asMDChgProcessRecordObjectID
	MDChangeProcModelTableDesc	ModelTable	MDChangeProcModelTableDesc
	MDChangeProcessModelFieldDesc
	MDChgProcModelNodeExternalName
	MDChgProcModTableExternalName
	MDChgProcModFieldExternalName
	MDChgProcCurrentAttributeValue
	MDChgProcPrevAttributeValue
	MDChgProcessAttributeIsChanged
	MDChgProcessSourceModified	I_BPCustomerTaxIndicatorProc	MDChgProcessSourceModified
	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPCustomerTaxIndicatorProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPCustomerTaxIndicatorProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BPCustomerTaxIndicatorProc	MDChgProcessSrceObject
KEY	DepartureCountry	I_BPCustomerTaxIndicatorProc	DepartureCountry
KEY	CustomerTaxCategory	I_BPCustomerTaxIndicatorProc	CustomerTaxCategory
KEY	MDChgProcessModelTableName	ModelField	MDChgProcessModelTableName
KEY	MDChangeProcessModelFieldName	ModelField	MDChangeProcessModelFieldName
KEY	char1000asMDChgProcessRecordObjectID
	MDChangeProcModelTableDesc	ModelField	MDChangeProcModelTableDesc
	MDChangeProcessModelFieldDesc	ModelField	MDChangeProcessModelFieldDesc
	MDChgProcModelNodeExternalName
	MDChgProcModTableExternalName
	MDChgProcModFieldExternalName
	MDChgProcCurrentAttributeValue
	MDChgProcPrevAttributeValue
	MDChgProcessAttributeIsChanged
	MDChgProcessSourceModified	I_BPCustomerTaxIndicatorProc	MDChgProcessSourceModified
	_Customer		_Customer

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Tax Indicator Process Changes'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #TRANSACTIONAL
define view entity I_BPCustTaxIndicatorProcChgs
  as select from           I_BPCustomerTaxIndicatorProc as Current
    left outer to one join I_MDChangeProcessModelTable  as ModelTable on  ModelTable.MDChgProcessModelTableName     = 'KNVI'
                                                                      and ModelTable.MDChgProcessSrceObjectTypeCode = '147'
  association [1..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
  association [0..1] to I_CountryText       as _CountryText     on  $projection.DepartureCountry = _CountryText.Country
                                                                and _CountryText.Language        = $session.system_language
  association [0..1] to I_ConditionTypeText as _TaxCategoryText on  $projection.CustomerTaxCategory       = _TaxCategoryText.ConditionType
                                                                and _TaxCategoryText.ConditionUsage       = 'A'
                                                                and _TaxCategoryText.ConditionApplication = 'V'
                                                                and _TaxCategoryText.Language             = $session.system_language

{
  key Current.MasterDataChangeProcess,
  key Current.MDChgProcessStep,
  key Current.MDChgProcessSrceSystem,
  key Current.MDChgProcessSrceObject,
  key Current.DepartureCountry,
  key Current.CustomerTaxCategory,
  key ModelTable.MDChgProcessModelTableName,
  key cast ( '' as fieldname )                                              as MDChangeProcessModelFieldName,
  key cast( concat(
              concat(
                concat(
                  concat( Current.MDChgProcessSrceSystem, concat( '%%', Current.MDChgProcessSrceObject )),
                concat( '%%', Current.BPAssignmentID )),
              concat( '%%', Current.DepartureCountry )),
            concat( '%%', Current.CustomerTaxCategory ))
        as abap.char(1000) )                                                as MDChgProcessRecordObjectID,
      ModelTable.MDChangeProcModelTableDesc,
      cast ('' as as4text  )                                                as MDChangeProcessModelFieldDesc,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'BusPartCustomerTaxIndicator' as fieldname )                    as MDChgProcModelNodeExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'I_BPCustomerTaxIndicatorProcTP' as fieldname )                 as MDChgProcModTableExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_CUST_PROCTP_CALC_EXIT'
      cast( '' as fieldname )                                               as MDChgProcModFieldExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_CUST_PROCTP_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                                        as MDChgProcCurrentAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_CUST_PROCTP_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                                        as MDChgProcPrevAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_CUST_PROCTP_CALC_EXIT'
      cast( '' as boolean )                                                 as MDChgProcessAttributeIsChanged,
      Current.MDChgProcessSourceModified,
      concat_with_space(
        concat_with_space( coalesce(_CountryText.CountryName,''),
          concat( concat( '(', Current.DepartureCountry ), '),' ), 1),
        concat_with_space(coalesce(_TaxCategoryText.ConditionTypeName,''),
          concat( concat( '(', Current.CustomerTaxCategory ), ')' ), 1), 1) as MDChgProcessRecordObjectText,

      _Customer
}
where
     Current.MDChgProcessSourceModified = 'I'
  or Current.MDChgProcessSourceModified = 'D'

union all select from     I_BPCustomerTaxIndicatorProc as Current
  left outer to many join I_MDChangeProcessModelField  as ModelField on  ModelField.MDChgProcessModelTableName     = 'KNVI'
                                                                     and ModelField.MDChgProcessSrceObjectTypeCode = '147'
association [1..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
association [0..1] to I_CountryText       as _CountryText     on  $projection.DepartureCountry = _CountryText.Country
                                                              and _CountryText.Language        = $session.system_language
association [0..1] to I_ConditionTypeText as _TaxCategoryText on  $projection.CustomerTaxCategory       = _TaxCategoryText.ConditionType
                                                              and _TaxCategoryText.ConditionUsage       = 'A'
                                                              and _TaxCategoryText.ConditionApplication = 'V'
                                                              and _TaxCategoryText.Language             = $session.system_language

{
  key Current.MasterDataChangeProcess,
  key Current.MDChgProcessStep,
  key Current.MDChgProcessSrceSystem,
  key Current.MDChgProcessSrceObject,
  key Current.DepartureCountry,
  key Current.CustomerTaxCategory,
  key ModelField.MDChgProcessModelTableName,
  key ModelField.MDChangeProcessModelFieldName,
  key cast( concat(
              concat(
                concat(
                  concat( Current.MDChgProcessSrceSystem, concat( '%%', Current.MDChgProcessSrceObject )),
                concat( '%%', Current.BPAssignmentID )),
              concat( '%%', Current.DepartureCountry )),
            concat( '%%', Current.CustomerTaxCategory ))
        as abap.char(1000) )                                                as MDChgProcessRecordObjectID,
      ModelField.MDChangeProcModelTableDesc,
      ModelField.MDChangeProcessModelFieldDesc,
      cast( 'BusPartCustomerTaxIndicator' as fieldname )                    as MDChgProcModelNodeExternalName,
      cast( 'I_BPCustomerTaxIndicatorProcTP' as fieldname )                 as MDChgProcModTableExternalName,
      cast( '' as fieldname )                                               as MDChgProcModFieldExternalName,
      cast( '' as abap.char( 260 ) )                                        as MDChgProcCurrentAttributeValue,
      cast( '' as abap.char( 260 ) )                                        as MDChgProcPrevAttributeValue,
      cast( '' as boolean )                                                 as MDChgProcessAttributeIsChanged,
      Current.MDChgProcessSourceModified,
      concat_with_space(
        concat_with_space( coalesce(_CountryText.CountryName,''),
          concat( concat( '(', Current.DepartureCountry ), '),' ), 1),
        concat_with_space(coalesce(_TaxCategoryText.ConditionTypeName,''),
          concat( concat( '(', Current.CustomerTaxCategory ), ')' ), 1), 1) as MDChgProcessRecordObjectText,

      _Customer

}
where
  Current.MDChgProcessSourceModified = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCUSTOMERTAXINDICATORPROC",
"I_CONDITIONTYPETEXT",
"I_COUNTRYTEXT",
"I_MDCHANGEPROCESSMODELFIELD",
"I_MDCHANGEPROCESSMODELTABLE"
],
"ASSOCIATED":
[
"I_BPCUSTOMERPROCESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_BPCustTaxIndicatorProcChgs view_entity

I_BPCustomerTaxIndicatorProc view_entity
I_BPCustomerTaxIndicatorProc view_entity

C_BPCustTaxIndicatorProcChgs view_entity
I_BPCustProcessChangesUnion view_entity