I_BPAddlSuplrWhldgTaxTP

DDL: I_BPADDLSUPLRWHLDGTAXTP SQL: IBPADDSWTTP Type: view TRANSACTIONAL

BO view for Withholding Tax of Suppliers

I_BPAddlSuplrWhldgTaxTP is a Transactional CDS View that provides data about "BO view for Withholding Tax of Suppliers" in SAP S/4HANA. It reads from 2 data sources (I_BPMultipleAssignment, I_SupplierWithHoldingTax) and exposes 20 fields with key fields BusinessPartner, Supplier, CompanyCode, WithholdingTaxType. It has 4 associations to related views.

2 data source(s) 20 fields

Data Sources (2)

SourceAliasJoin Type
I_BPMultipleAssignment BPMultipleAssignment inner
I_SupplierWithHoldingTax BusinessPartnerSuppWhdgTax from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_BPAdditionalSupplierTP _BPAdditionalSupplier $projection.BusinessPartner = _BPAdditionalSupplier.BusinessPartner and $projection.Supplier = _BPAdditionalSupplier.Supplier
[1..1] I_BPAddlSuplrCompanyCodeTP _BusinessPartnerSupplierCo $projection.BusinessPartner = _BusinessPartnerSupplierCo.BusinessPartner and $projection.Supplier = _BusinessPartnerSupplierCo.Supplier and $projection.CompanyCode = _BusinessPartnerSupplierCo.CompanyCode
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IBPADDSWTTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label BO view for Withholding Tax of Suppliers view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.writeDraftPersistence BPADDSWTAX_D view
ObjectModel.draftEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPMultipleAssignment BusinessPartner
KEY Supplier I_SupplierWithHoldingTax Supplier
KEY CompanyCode I_SupplierWithHoldingTax CompanyCode
KEY WithholdingTaxType I_SupplierWithHoldingTax WithholdingTaxType
WithholdingTaxTypeForEdit I_SupplierWithHoldingTax WithholdingTaxType
CompanyCodeForEdit I_SupplierWithHoldingTax CompanyCode
SupplierForEdit I_SupplierWithHoldingTax Supplier
BusinessPartnerForEdit I_BPMultipleAssignment BusinessPartner
CountryCode _CompanyCode Country
WithholdingTaxCode I_SupplierWithHoldingTax WithholdingTaxCode
IsWithholdingTaxSubject I_SupplierWithHoldingTax IsWithholdingTaxSubject
RecipientType I_SupplierWithHoldingTax RecipientType
WithholdingTaxNumber I_SupplierWithHoldingTax WithholdingTaxNumber
ExemptionDateBegin I_SupplierWithHoldingTax ExemptionDateBegin
ExemptionDateEnd I_SupplierWithHoldingTax ExemptionDateEnd
WithholdingTaxExmptPercent I_SupplierWithHoldingTax WithholdingTaxExmptPercent
WithholdingTaxCertificate I_SupplierWithHoldingTax WithholdingTaxCertificate
ExemptionReason I_SupplierWithHoldingTax ExemptionReason
_BusinessPartner _BusinessPartner
_BusinessPartnerSupplierCo _BusinessPartnerSupplierCo 
@AbapCatalog.sqlViewName: 'IBPADDSWTTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'BO view for Withholding Tax of Suppliers'

@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeEnabled: true

@ObjectModel.createEnabled
@ObjectModel.deleteEnabled
@ObjectModel.updateEnabled

@ObjectModel.semanticKey: ['BusinessPartner', 'Supplier', 'CompanyCode', 'WithholdingTaxType']
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.writeDraftPersistence: 'BPADDSWTAX_D'
@ObjectModel.draftEnabled:true

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

define view I_BPAddlSuplrWhldgTaxTP
  as select from I_SupplierWithHoldingTax as BusinessPartnerSuppWhdgTax inner join I_BPMultipleAssignment as BPMultipleAssignment on BusinessPartnerSuppWhdgTax.Supplier  = BPMultipleAssignment.BPObjectID

  association [1..1] to I_BusinessPartnerTP as _BusinessPartner on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  association [1..1] to I_BPAdditionalSupplierTP as _BPAdditionalSupplier on $projection.BusinessPartner = _BPAdditionalSupplier.BusinessPartner
                                                                         and $projection.Supplier = _BPAdditionalSupplier.Supplier
                                                                         
  association [1..1] to I_BPAddlSuplrCompanyCodeTP as _BusinessPartnerSupplierCo on $projection.BusinessPartner = _BusinessPartnerSupplierCo.BusinessPartner
                                                                         and $projection.Supplier = _BusinessPartnerSupplierCo.Supplier
                                                                         and $projection.CompanyCode = _BusinessPartnerSupplierCo.CompanyCode
  
  association [1..1] to I_CompanyCode                 as _CompanyCode               on $projection.CompanyCode = _CompanyCode.CompanyCode


{
      key BPMultipleAssignment.BusinessPartner,
      key BusinessPartnerSuppWhdgTax.Supplier,
      key BusinessPartnerSuppWhdgTax.CompanyCode, 
      key BusinessPartnerSuppWhdgTax.WithholdingTaxType,
 
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'    
      BusinessPartnerSuppWhdgTax.WithholdingTaxType as WithholdingTaxTypeForEdit,
      BusinessPartnerSuppWhdgTax.CompanyCode as CompanyCodeForEdit,
      BusinessPartnerSuppWhdgTax.Supplier as SupplierForEdit,
      BPMultipleAssignment.BusinessPartner as BusinessPartnerForEdit,
  
       _CompanyCode.Country as CountryCode, 
      
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSuppWhdgTax.WithholdingTaxCode,
      
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSuppWhdgTax.IsWithholdingTaxSubject,
      
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSuppWhdgTax.RecipientType,
      
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSuppWhdgTax.WithholdingTaxNumber,
      
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSuppWhdgTax.ExemptionDateBegin,
      
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSuppWhdgTax.ExemptionDateEnd,
      
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSuppWhdgTax.WithholdingTaxExmptPercent,
        
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'  
      BusinessPartnerSuppWhdgTax.WithholdingTaxCertificate,
      
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSuppWhdgTax.ExemptionReason,


 
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _BusinessPartner,

      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _BusinessPartnerSupplierCo
            
}

where BPMultipleAssignment.IsStandardAssignment <> 'X' and BPMultipleAssignment.BPAssignmentCategory = 'SUPPL'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPMULTIPLEASSIGNMENT",
"I_COMPANYCODE",
"I_SUPPLIERWITHHOLDINGTAX"
],
"ASSOCIATED":
[
"I_BPADDITIONALSUPPLIERTP",
"I_BPADDLSUPLRCOMPANYCODETP",
"I_BUSINESSPARTNERTP",
"I_COMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More