C_REContractPartAssgmtTP

DDL: C_RECONTRACTPARTASSGMTTP Type: view_entity CONSUMPTION
33 Fields 1 Data Sources

RE Contract Partner Assignments

C_REContractPartAssgmtTP is a Consumption CDS View that provides data about "RE Contract Partner Assignments" in SAP S/4HANA. It reads from 1 data source (R_REContrPartAssgmtTP) and exposes 33 fields with key fields REPartnerRelationUUID, InternalRealEstateNumber.

Data Sources (1)

SourceAliasJoin Type
R_REContrPartAssgmtTP R_REContrPartAssgmtTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label RE Contract Partner Assignments view
Metadata.allowExtensions true view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY REPartnerRelationUUID REPartnerRelationUUID GUID: BP/Object
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerRole BusinessPartnerRole Business Partner Role
ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
ValidityStartDate ValidityStartDate Validity Start Date
REPartnerRoleType REPartnerRoleType Role Type
AddressType AddressType Address Type
ValidityEndDate ValidityEndDate ValidTo
char150 Formatted Address
REIsMainPartner REIsMainPartner Main Partner
REEntryValidity REEntryValidity Entry Validity
REEntryValidityCriticality REEntryValidityCriticality
REMainPartnerCriticality REMainPartnerCriticality
LastName _BusinessPartner LastName Last Name
FirstName _BusinessPartner FirstName First Name
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName Business Partner Full Name
StreetName
HouseNumber
CityName
RECityCode
Country
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted Purpose Completed
OrganizationBPName1 _BusinessPartner OrganizationBPName1 Name 1
OrganizationBPName2 _BusinessPartner OrganizationBPName2 Name 2
OrganizationBPName3 _BusinessPartner OrganizationBPName3 Name 3
OrganizationBPName4 _BusinessPartner OrganizationBPName4 Name 4
REContractType _REContract REContractType Contract Type
RealEstateObjectType _REContract RealEstateObjectType Object Type
_BusinessPartner _BusinessPartner
_BusinessPartnerRole _BusinessPartnerRole
_REPartnerRoleType _REPartnerRoleType
_BusinessPartnerAddressType _BusinessPartnerAddressType

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 C_REContractPartAssgmtTP.
-- 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.

CREATE VIEW C_REContractPartAssgmtTP AS
SELECT
  REPartnerRelationUUID,
  InternalRealEstateNumber,
  BusinessPartner,
  BusinessPartnerRole,
  ValidityStartEndDateValue,
  ValidityStartDate,
  REPartnerRoleType,
  AddressType,
  ValidityEndDate,
  virtual FormattedAddress : abap.char( 150 ) AS char150,
  REIsMainPartner,
  REEntryValidity,
  REEntryValidityCriticality,
  REMainPartnerCriticality,
  _BusinessPartner.LastName AS LastName,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName AS StreetName,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber AS HouseNumber,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName AS CityName,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityNumber AS RECityCode,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country AS Country,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _BusinessPartner.OrganizationBPName3 AS OrganizationBPName3,
  _BusinessPartner.OrganizationBPName4 AS OrganizationBPName4,
  _REContract.REContractType AS REContractType,
  _REContract.RealEstateObjectType AS RealEstateObjectType
FROM R_REContrPartAssgmtTP
;

Learn More