I_BPMultipleAssignment

DDL: I_BPMULTIPLEASSIGNMENT SQL: IBPMLTAS Type: view BASIC Package: VDM_MD_BP
8 Fields 1 Data Sources 1 Associations

Business Partner Multiple Assignments

I_BPMultipleAssignment is a Basic CDS View (Dimension) that provides data about "Business Partner Multiple Assignments" in SAP S/4HANA. It reads from 1 data source (mdg_mlt_assgmnt) and exposes 8 fields with key fields BusinessPartner, BPAssignmentID. It has 1 association to related views. Part of development package VDM_MD_BP.

Data Sources (1)

SourceAliasJoin Type
mdg_mlt_assgmnt mdg_mlt_assgmnt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner _BusinessPartner.BusinessPartner = $projection.BusinessPartner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBPMLTAS view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Business Partner Multiple Assignments view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey BPAssignmentID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner partner With Partner
KEY BPAssignmentID assignment_id Assignment ID
BPAssignmentCategory assignment_cat Assignment Category
BPObjectID object_id Transaction ID
IsStandardAssignment standard Quality Standard
BPAssignmentReasonID reason_id Reason
AddressNumber addrno Address Number
_BusinessPartner _BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BPMultipleAssignment.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IBPMLTAS

CREATE VIEW I_BPMultipleAssignment AS
SELECT
  partner AS BusinessPartner,
  assignment_id AS BPAssignmentID,
  assignment_cat AS BPAssignmentCategory,
  object_id AS BPObjectID,
  standard AS IsStandardAssignment,
  reason_id AS BPAssignmentReasonID,
  addrno AS AddressNumber
FROM mdg_mlt_assgmnt
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = BusinessPartner  -- association [1..1]
;

Learn More