C_BPRelshpCntctPersnAddrVersTP

DDL: C_BPRELSHPCNTCTPERSNADDRVERSTP Type: view_entity CONSUMPTION
41 Fields 1 Data Sources

Projection for Contact Address Version

C_BPRelshpCntctPersnAddrVersTP is a Consumption CDS View that provides data about "Projection for Contact Address Version" in SAP S/4HANA. It reads from 1 data source (I_BPRelshpCntctPersnAddrVersTP) and exposes 41 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory, AddressID.

Data Sources (1)

SourceAliasJoin Type
I_BPRelshpCntctPersnAddrVersTP I_BPRelshpCntctPersnAddrVersTP projection

Annotations (6)

NameValueLevelField
EndUserText.label Projection for Contact Address Version view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
Search.searchable true view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 BusinessPartner1 Partner
KEY BusinessPartner2 BusinessPartner2 Partner
KEY ValidityEndDate ValidityEndDate ValidTo
KEY RelationshipCategory RelationshipCategory Relationsh.Cat.
KEY AddressID AddressID Ship-to address
KEY AddressRepresentationCode AddressRepresentationCode Address Version
KEY BPRelshpCatIsInFwdDirection BPRelshpCatIsInFwdDirection Boolean Variable (X = True, - = False, Space = Unknown)
AddrRepCodeForEdit AddrRepCodeForEdit Country/Region
RelationshipNumber RelationshipNumber BP Rel. Number
FormOfAddress FormOfAddress Title Key
FirstName FirstName First Name
LastName LastName Last Name
BirthName BirthName Name at Birth
MiddleName MiddleName Middle Name
AdditionalFamilyName AdditionalFamilyName Name at Birth
FullName FullName Name
PersonFullNameMaintStatus PersonFullNameMaintStatus Converted
AcademicTitle AcademicTitle Academic Title
AcademicTitle2 AcademicTitle2 2nd Academic
LastNamePrefix LastNamePrefix Prefix Key
LastNameSecondPrefix LastNameSecondPrefix 2nd prefix
NameSupplement NameSupplement Name Supplement
BusinessPartnerNicknameLabel BusinessPartnerNicknameLabel Nickname
Initials Initials Initials
NameFormat NameFormat Name Format
NameCountry NameCountry Country/Region
PersonProfessionName PersonProfessionName Profession
GenderCode GenderCode Sex-Specific
AddressSearchText1 AddressSearchText1 Sort string 1
AddressSearchText2 AddressSearchText2 Sort string 2
ContactRelationshipFunction ContactRelationshipFunction Function
ContactRelationshipDepartment ContactRelationshipDepartment Department
Floor Floor Floor
Building Building Building code
RoomNumber RoomNumber Room Number
CorrespondenceShortName CorrespondenceShortName Short name
InhouseMail InhouseMail Internal mail
AddressRepresentationDesclocalized
FormOfAddressNamelocalized
_BusinessPartner1 _BusinessPartner1
_BusinessPartner2 _BusinessPartner2

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_BPRelshpCntctPersnAddrVersTP.
-- 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_BPRelshpCntctPersnAddrVersTP AS
SELECT
  BusinessPartner1,
  BusinessPartner2,
  ValidityEndDate,
  RelationshipCategory,
  AddressID,
  AddressRepresentationCode,
  BPRelshpCatIsInFwdDirection,
  AddrRepCodeForEdit,
  RelationshipNumber,
  FormOfAddress,
  FirstName,
  LastName,
  BirthName,
  MiddleName,
  AdditionalFamilyName,
  FullName,
  PersonFullNameMaintStatus,
  AcademicTitle,
  AcademicTitle2,
  LastNamePrefix,
  LastNameSecondPrefix,
  NameSupplement,
  BusinessPartnerNicknameLabel,
  Initials,
  NameFormat,
  NameCountry,
  PersonProfessionName,
  GenderCode,
  AddressSearchText1,
  AddressSearchText2,
  ContactRelationshipFunction,
  ContactRelationshipDepartment,
  Floor,
  Building,
  RoomNumber,
  CorrespondenceShortName,
  InhouseMail,
  _AddressRepresentationText.AddressRepresentationDesc : localized AS AddressRepresentationDesclocalized,
  _BusinessPartnerFormOfAddrTxt.FormOfAddressName : localized AS FormOfAddressNamelocalized
FROM I_BPRelshpCntctPersnAddrVersTP
;

Learn More