I_BPAddlCustFaxNumberTP

DDL: I_BPADDLCUSTFAXNUMBERTP SQL: IBPADDCFNTP Type: view TRANSACTIONAL Package: VDM_MD_BP

BO view for Fax Numb of MLTAS Customers

I_BPAddlCustFaxNumberTP is a Transactional CDS View that provides data about "BO view for Fax Numb of MLTAS Customers" in SAP S/4HANA. It reads from 3 data sources (I_BPFaxNumber, I_BPMultipleAssignment, I_Customer) and exposes 13 fields with key fields BusinessPartner, Customer, AddressID, Person, OrdinalNumber. It has 2 associations to related views. Part of development package VDM_MD_BP.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
I_BPFaxNumber BPFaxNumber from
I_BPMultipleAssignment BPMultipleAssignment inner
I_Customer Customer inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_BPAdditionalCustomerTP _BPAdditionalCustomer $projection.BusinessPartner = _BPAdditionalCustomer.BusinessPartner and $projection.Customer = _BPAdditionalCustomer.Customer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBPADDCFNTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label BO view for Fax Numb of MLTAS Customers view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
Search.searchable true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.writeDraftPersistence BPADDCFN_D view
ObjectModel.draftEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPMultipleAssignment BusinessPartner
KEY Customer I_Customer Customer
KEY AddressID I_BPFaxNumber AddressID
KEY Person I_BPFaxNumber Person
KEY OrdinalNumber I_BPFaxNumber OrdinalNumber
IsDefaultFaxNumber I_BPFaxNumber IsDefaultFaxNumber
FaxCountry I_BPFaxNumber FaxCountry
FaxNumber I_BPFaxNumber FaxNumber
FaxNumberExtension I_BPFaxNumber FaxNumberExtension
InternationalFaxNumber I_BPFaxNumber InternationalFaxNumber
AddressCommunicationRemarkText
_BusinessPartner _BusinessPartner
_BPAdditionalCustomer _BPAdditionalCustomer 
@AbapCatalog.sqlViewName: 'IBPADDCFNTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'BO view for Fax Numb of MLTAS Customers'

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

@ObjectModel.deleteEnabled
@ObjectModel.updateEnabled
@Search.searchable: true
@ObjectModel.semanticKey: ['BusinessPartner', 'Customer', 'Person', 'AddressID', 'OrdinalNumber' ]
@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel.writeDraftPersistence: 'BPADDCFN_D'
@ObjectModel.draftEnabled:true

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_BPAddlCustFaxNumberTP as select from I_BPFaxNumber as BPFaxNumber inner join I_BPMultipleAssignment as BPMultipleAssignment on BPFaxNumber.AddressID = BPMultipleAssignment.AddressNumber inner join I_Customer as Customer on BPMultipleAssignment.BPObjectID = Customer.Customer
  
association [1..1] to I_BusinessPartnerTP as _BusinessPartner on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [1..1] to I_BPAdditionalCustomerTP as _BPAdditionalCustomer on  $projection.BusinessPartner = _BPAdditionalCustomer.BusinessPartner
                                                                             and $projection.Customer = _BPAdditionalCustomer.Customer


{
    key BPMultipleAssignment.BusinessPartner, 
    key Customer.Customer as Customer,
    key BPFaxNumber.AddressID, 
    key BPFaxNumber.Person, 
    key BPFaxNumber.OrdinalNumber, 
    BPFaxNumber.IsDefaultFaxNumber, 
    BPFaxNumber.FaxCountry, 
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8
    @Search.ranking: #HIGH    
    BPFaxNumber.FaxNumber, 
    BPFaxNumber.FaxNumberExtension, 
    BPFaxNumber.InternationalFaxNumber,
//    cast('' as ad_remark2 ) as AddressCommunicationRemarkText,

    BPFaxNumber._AddressCommunicationRemark.CommunicationRemarkText as AddressCommunicationRemarkText,
   
    @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
    _BusinessPartner,      
    @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
    _BPAdditionalCustomer
   
}
where BPMultipleAssignment.IsStandardAssignment <> 'X' and BPMultipleAssignment.BPAssignmentCategory = 'CUST'

Learn More