I_REPartnerAssgmtAddl

DDL: I_REPARTNERASSGMTADDL SQL: IREPARTNERASSADD Type: view COMPOSITE Package: VDM_RE_BP
11 Fields 1 Data Sources 3 Associations

RE Partner Assignment additional

I_REPartnerAssgmtAddl is a Composite CDS View that provides data about "RE Partner Assignment additional" in SAP S/4HANA. It reads from 1 data source (I_REPartnerAssgmt) and exposes 11 fields with key fields InternalRealEstateNumber, BusinessPartner, BusinessPartnerRole, ValidityStartEndDateValue. It has 3 associations to related views. Part of development package VDM_RE_BP.

Data Sources (1)

SourceAliasJoin Type
I_REPartnerAssgmt I_REPartnerAssgmt from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_REContract _REContract $projection.InternalRealEstateNumber = _REContract.InternalRealEstateNumber
[1..1] I_BusinessPartnerSuplrRole _BusinessPartnerSuplrRole $projection.BusinessPartnerRole = _BusinessPartnerSuplrRole.Role
[1..1] I_BusinessPartnerCustRole _BusinessPartnerCustRole $projection.BusinessPartnerRole = _BusinessPartnerCustRole.Role

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IREPARTNERASSADD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label RE Partner Assignment additional view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY BusinessPartner BusinessPartner Issuing Authority
KEY BusinessPartnerRole BusinessPartnerRole BP Role
KEY ValidityStartEndDateValue
StreetNameasFormattedAddress
RECityCode
_REContract _REContract
_BusinessPartner _BusinessPartner
_BusinessPartnerRole _BusinessPartnerRole
_BusinessPartnerSuplrRole _BusinessPartnerSuplrRole
_BusinessPartnerCustRole _BusinessPartnerCustRole

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_REPartnerAssgmtAddl.
-- 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: IREPARTNERASSADD

CREATE VIEW I_REPartnerAssgmtAddl AS
SELECT
  InternalRealEstateNumber,
  BusinessPartner,
  BusinessPartnerRole,
  cast( concat (ValidityStartDate, ValidityEndDate ) as recadateperiod preserving type ) AS ValidityStartEndDateValue,
  concat (_BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber, concat ('-', _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName )) as FormattedAddress AS StreetNameasFormattedAddress,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityNumber AS RECityCode
FROM I_REPartnerAssgmt
LEFT OUTER JOIN I_REContract AS _REContract ON InternalRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartnerSuplrRole AS _BusinessPartnerSuplrRole ON BusinessPartnerRole = _BusinessPartnerSuplrRole.Role  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartnerCustRole AS _BusinessPartnerCustRole ON BusinessPartnerRole = _BusinessPartnerCustRole.Role  -- association [1..1]
;

Learn More