I_BPMULTIPLEASSIGNMENT

CDS View

Business Partner Multiple Assignments

I_BPMULTIPLEASSIGNMENT is a CDS View in S/4HANA. Business Partner Multiple Assignments. It contains 6 fields. 29 CDS views read from this table.

Used by 29 CDS view(s) 6 fields

CDS Views using this table (29)

ViewTypeJoinVDMDescription
I_BPAdditionalCustomerTP view from TRANSACTIONAL BO view for Additional Customers of BP
I_BPAdditionalSupplierTP view inner TRANSACTIONAL BO view for Additional Supplier of BP
I_BPAddlCustCompanyCodeTP view inner TRANSACTIONAL BO view for Company Code of Customers
I_BPAddlCustDunningTP view inner TRANSACTIONAL BO view for Additional Customer Dunning
I_BPAddlCustEmailAddressTP view inner TRANSACTIONAL BO view for email for MLTAS customers
I_BPAddlCustFaxNumberTP view inner TRANSACTIONAL BO view for Fax Numb of MLTAS Customers
I_BPAddlCustMblPhNumberTP view inner TRANSACTIONAL BO view for Mob Ph of MLTAS Customers
I_BPAddlCustPartFuncTP view inner TRANSACTIONAL BO view for Additional Partner Functions
I_BPAddlCustSalesAreaTaxTP view inner TRANSACTIONAL BO view for sales area tax of customer
I_BPAddlCustSalesAreaTP view inner TRANSACTIONAL BO view for sales area of supplier
I_BPAddlCustTelNmbrTP view inner TRANSACTIONAL BO view for Tel nos of MLTAS Customers
I_BPAddlCustWebsiteURLTP view inner TRANSACTIONAL BO view for Website URL of MLTAS Customers
I_BPAddlCustWhldgTaxTP view inner TRANSACTIONAL BO view for Withholding Tax of Customers
I_BPAddlSuplrCompanyCodeTP view inner TRANSACTIONAL BO view for Company Code for Suppliers
I_BPAddlSuplrDunningTP view inner TRANSACTIONAL BO view for Additional Supplier Dunning
I_BPAddlSuplrEmailAddressTP view inner TRANSACTIONAL BO view for email for MLTAS suppliers
I_BPAddlSuplrFaxNumberTP view inner TRANSACTIONAL BO view for fax num for MLTAS suppliers
I_BPAddlSuplrMblPhNumberTP view inner TRANSACTIONAL BO view for Mobile nos of MLTAS Suppliers
I_BPAddlSuplrPartFuncTP view inner TRANSACTIONAL Additional Supplier Partner Function
I_BPAddlSuplrPurgOrgTP view inner TRANSACTIONAL BO view for purg org for addl suppliers
I_BPAddlSuplrTelNmbrTP view inner TRANSACTIONAL BO view for Tel nos of MLTAS Suppliers
I_BPAddlSuplrWebsiteURLTP view inner TRANSACTIONAL BO view for Website URL of MLTAS Suppliers
I_BPAddlSuplrWhldgTaxTP view inner TRANSACTIONAL BO view for Withholding Tax of Suppliers
I_MDQAnlytsScrBPCust view_entity inner BASIC Basic Score for Customer
I_MDQAnlytsScrBPCustCoCode view_entity inner BASIC Basic Score for Customer Company Code
I_MDQAnlytsScrBPCustSls view_entity inner BASIC Basic Score for Customer Sales
I_MDQAnlytsScrBPSuplr view_entity inner BASIC Basic Score for Supplier General
I_MDQAnlytsScrBPSuplrCoCode view_entity inner BASIC Basic Score for Supplier Company Code
I_MDQAnlytsScrBPSuplrPur view_entity inner BASIC Basic Score for Supplier Purchase

Fields (6)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner,BusinessPartnerForEdit,Partner 23
AddressNumber AddressNumber 2
BPAssignmentCategory BPAssignmentCategory 2
BPAssignmentID BPAssignmentID 2
BPAssignmentReasonID BPAssignmentReasonID 2
IsStandardAssignment IsStandardAssignment 2 
@AbapCatalog.sqlViewName: 'IBPMLTAS'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Business Partner Multiple Assignments'
@Analytics.dataCategory: #DIMENSION //or #CUBE or #FACT

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'BPAssignmentID'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm : #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@Metadata.allowExtensions: true

define view I_BPMultipleAssignment as select from mdg_mlt_assgmnt
association [1..1] to I_BusinessPartner as _BusinessPartner on _BusinessPartner.BusinessPartner  = $projection.BusinessPartner
 {
  @ObjectModel.foreignKey.association: '_BusinessPartner'
  key partner as BusinessPartner,
  key assignment_id as BPAssignmentID,
  assignment_cat as BPAssignmentCategory,
  object_id as BPObjectID,
  standard as IsStandardAssignment,
  reason_id as BPAssignmentReasonID,
  addrno as AddressNumber,
  
 _BusinessPartner
}

Learn More