C_BPRelshpCntctWbsteURLTP_2

DDL: C_BPRELSHPCNTCTWBSTEURLTP_2 Type: view_entity CONSUMPTION Package: MDC_BUPA_REL_BO
16 Fields 1 Data Sources 1 OData Services

Projection for Contact Website

C_BPRelshpCntctWbsteURLTP_2 is a Consumption CDS View that provides data about "Projection for Contact Website" in SAP S/4HANA. It reads from 1 data source (I_BPRelshpCntctPersnWbsteURLTP) and exposes 16 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory, AddressID. It is exposed through 1 OData service (C_BUSINESSPARTNERTP_2_SRV). Part of development package MDC_BUPA_REL_BO.

Data Sources (1)

SourceAliasJoin Type
I_BPRelshpCntctPersnWbsteURLTP I_BPRelshpCntctPersnWbsteURLTP projection

Annotations (6)

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

OData Services (1)

ServiceBindingVersionContractRelease
C_BUSINESSPARTNERTP_2_SRV C_BUSINESSPARTNERTP_2_SRV V2 C1 NOT_RELEASED

Fields (16)

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 OrdinalNumber OrdinalNumber Sequence Number
KEY BPRelshpCatIsInFwdDirection BPRelshpCatIsInFwdDirection Boolean Variable (X = True, - = False, Space = Unknown)
RelationshipNumber RelationshipNumber BP Rel. Number
IsDefaultURLAddress IsDefaultURLAddress Standard addr.
CommNumberIsNotUsed CommNumberIsNotUsed Do not use
AddressCommunicationRemarkText AddressCommunicationRemarkText Notes
UniformResourceIdentifier UniformResourceIdentifier
URLFieldLength URLFieldLength URI length
WebsiteURL WebsiteURL URI
_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_BPRelshpCntctWbsteURLTP_2.
-- 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_BPRelshpCntctWbsteURLTP_2 AS
SELECT
  BusinessPartner1,
  BusinessPartner2,
  ValidityEndDate,
  RelationshipCategory,
  AddressID,
  OrdinalNumber,
  BPRelshpCatIsInFwdDirection,
  RelationshipNumber,
  IsDefaultURLAddress,
  CommNumberIsNotUsed,
  AddressCommunicationRemarkText,
  UniformResourceIdentifier,
  URLFieldLength,
  WebsiteURL
FROM I_BPRelshpCntctPersnWbsteURLTP
;

Learn More