I_BPContactWbsteURLTP

DDL: I_BPCONTACTWBSTEURLTP SQL: IBPCPWBSTEURLTP Type: view TRANSACTIONAL
22 Fields 2 Data Sources 2 Associations

BO view for BP contact Website URL

I_BPContactWbsteURLTP is a Transactional CDS View that provides data about "BO view for BP contact Website URL" in SAP S/4HANA. It reads from 2 data sources (I_BpContactToAddress, I_AddressHomepageURL) and exposes 22 fields with key fields BusinessPartner1, BusinessPartner2, RelationshipNumber, ValidityEndDate, AddressID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BpContactToAddress ContactPerson from
I_AddressHomepageURL Website inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner1 = _BusinessPartner.BusinessPartner
[1..1] I_BPContactAddressTP _BPContactAddress $projection.BusinessPartner1 = _BPContactAddress.BusinessPartner1 and $projection.BusinessPartner2 = _BPContactAddress.BusinessPartner2 and $projection.RelationshipNumber = _BPContactAddress.RelationshipNumber and $projection.ValidityEndDate = _BPContactAddress.ValidityEndDate and $projection.AddressID = _BPContactAddress.AddressID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IBPCPWBSTEURLTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label BO view for BP contact Website URL view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
ObjectModel.writeDraftPersistence BPCP_WBSTE_D view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 I_BpContactToAddress BusinessPartnerCompany Busn. Partner
KEY BusinessPartner2 I_BpContactToAddress BusinessPartnerPerson Busn. Partner
KEY RelationshipNumber I_BpContactToAddress RelationshipNumber BP Rel. Number
KEY ValidityEndDate I_BpContactToAddress ValidityEndDate ValidTo
KEY AddressID I_BpContactToAddress AddressID Ship-to address
KEY OrdinalNumber I_AddressHomepageURL OrdinalNumber Sequence Number
BusinessPartner1ForEdit I_BpContactToAddress BusinessPartnerCompany Busn. Partner
BusinessPartner2ForEdit I_BpContactToAddress BusinessPartnerPerson Busn. Partner
ValidityEndDateForEdit I_BpContactToAddress ValidityEndDate ValidTo
AddressIDForEdit I_BpContactToAddress AddressID Ship-to address
OrdinalNumberForEdit I_AddressHomepageURL OrdinalNumber Sequence Number
RelationshipNumberForEdit I_BpContactToAddress RelationshipNumber BP Rel. Number
IsDefaultURLAddress I_AddressHomepageURL IsDefaultURLAddress Standard addr.
CommNumberIsNotUsed I_AddressHomepageURL CommNumberIsNotUsed Do not use
AddressCommunicationRemarkText
UniformResourceIdentifierType I_AddressHomepageURL UniformResourceIdentifierType URI type
URLFieldLength
CorporateWebsiteURL I_AddressHomepageURL WebsiteURL URI
_BusinessPartner1 _BusinessPartnerCompany
_BusinessPartner2 _BusinessPartnerPerson
_BusinessPartner _BusinessPartner
_BPContactAddress _BPContactAddress

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_BPContactWbsteURLTP.
-- 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: IBPCPWBSTEURLTP

CREATE VIEW I_BPContactWbsteURLTP AS
SELECT
  ContactPerson.BusinessPartnerCompany AS BusinessPartner1,
  ContactPerson.BusinessPartnerPerson AS BusinessPartner2,
  ContactPerson.RelationshipNumber AS RelationshipNumber,
  ContactPerson.ValidityEndDate AS ValidityEndDate,
  ContactPerson.AddressID AS AddressID,
  Website.OrdinalNumber AS OrdinalNumber,
  ContactPerson.BusinessPartnerCompany AS BusinessPartner1ForEdit,
  ContactPerson.BusinessPartnerPerson AS BusinessPartner2ForEdit,
  ContactPerson.ValidityEndDate AS ValidityEndDateForEdit,
  ContactPerson.AddressID AS AddressIDForEdit,
  Website.OrdinalNumber AS OrdinalNumberForEdit,
  ContactPerson.RelationshipNumber AS RelationshipNumberForEdit,
  Website.IsDefaultURLAddress AS IsDefaultURLAddress,
  Website.CommNumberIsNotUsed AS CommNumberIsNotUsed,
  Website._AddressCommunicationRemark.AddressCommunicationRemarkText AS AddressCommunicationRemarkText,
  Website.UniformResourceIdentifierType AS UniformResourceIdentifierType,
  cast(Website.URLFieldLength as abap.int4) AS URLFieldLength,
  Website.WebsiteURL AS CorporateWebsiteURL
FROM I_BpContactToAddress AS ContactPerson
INNER JOIN I_AddressHomepageURL AS Website ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner1 = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPContactAddressTP AS _BPContactAddress ON BusinessPartner1 = _BPContactAddress.BusinessPartner1 AND BusinessPartner2 = _BPContactAddress.BusinessPartner2 AND RelationshipNumber = _BPContactAddress.RelationshipNumber AND ValidityEndDate = _BPContactAddress.ValidityEndDate AND AddressID = _BPContactAddress.AddressID  -- association [1..1]
;

Learn More