I_BPMultipleAssignment

DDL: I_BPMULTIPLEASSIGNMENT SQL: IBPMLTAS Type: view BASIC
7 Fields 1 Data Sources

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 7 fields with key fields BusinessPartner, BPAssignmentID.

Data Sources (1)

SourceAliasJoin Type
mdg_mlt_assgmnt mdg_mlt_assgmnt from

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 (7)

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

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
;

Learn More