C_BPAddlCustWebsiteURL

DDL: C_BPADDLCUSTWEBSITEURL SQL: CBPADDCWEBURL Type: view CONSUMPTION Package: VDM_MD_BP
14 Fields 1 Data Sources 3 Associations

C view for Web URL of MLTAS Customers

C_BPAddlCustWebsiteURL is a Consumption CDS View that provides data about "C view for Web URL of MLTAS Customers" in SAP S/4HANA. It reads from 1 data source (I_BPAddlCustWebsiteURLTP) and exposes 14 fields with key fields BusinessPartner, Customer, AddressID, Person, OrdinalNumber. It has 3 associations to related views. Part of development package VDM_MD_BP.

Data Sources (1)

SourceAliasJoin Type
I_BPAddlCustWebsiteURLTP BPCustWebsiteURL from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BPAdditionalCustomer _BPAdditionalCustomer $projection.BusinessPartner = _BPAdditionalCustomer.BusinessPartner and $projection.Customer = _BPAdditionalCustomer.Customer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CBPADDCWEBURL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label C view for Web URL of MLTAS Customers view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPAddlCustWebsiteURLTP BusinessPartner Issuing Authority
KEY Customer I_BPAddlCustWebsiteURLTP Customer Sold-to Party
KEY AddressID I_BPAddlCustWebsiteURLTP AddressID Ship-to address
KEY Person I_BPAddlCustWebsiteURLTP Person Person/ Farm/ Field
KEY OrdinalNumber I_BPAddlCustWebsiteURLTP OrdinalNumber Sequence Number
KEY ValidityStartDate I_BPAddlCustWebsiteURLTP ValidityStartDate Validity Start Date
KEY IsDefaultURLAddress I_BPAddlCustWebsiteURLTP IsDefaultURLAddress Standard addr.
SearchURLAddress I_BPAddlCustWebsiteURLTP SearchURLAddress URI address
AddressCommunicationRemarkText I_BPAddlCustWebsiteURLTP AddressCommunicationRemarkText Notes
URLFieldLength I_BPAddlCustWebsiteURLTP URLFieldLength URI length
WebsiteURL I_BPAddlCustWebsiteURLTP WebsiteURL URI
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_BPAdditionalCustomer _BPAdditionalCustomer

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_BPAddlCustWebsiteURL.
-- 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: CBPADDCWEBURL

CREATE VIEW C_BPAddlCustWebsiteURL AS
SELECT
  BPCustWebsiteURL.BusinessPartner AS BusinessPartner,
  BPCustWebsiteURL.Customer AS Customer,
  BPCustWebsiteURL.AddressID AS AddressID,
  BPCustWebsiteURL.Person AS Person,
  BPCustWebsiteURL.OrdinalNumber AS OrdinalNumber,
  BPCustWebsiteURL.ValidityStartDate AS ValidityStartDate,
  BPCustWebsiteURL.IsDefaultURLAddress AS IsDefaultURLAddress,
  BPCustWebsiteURL.SearchURLAddress AS SearchURLAddress,
  BPCustWebsiteURL.AddressCommunicationRemarkText AS AddressCommunicationRemarkText,
  BPCustWebsiteURL.URLFieldLength AS URLFieldLength,
  BPCustWebsiteURL.WebsiteURL AS WebsiteURL
FROM I_BPAddlCustWebsiteURLTP AS BPCustWebsiteURL
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BPAdditionalCustomer AS _BPAdditionalCustomer ON BusinessPartner = _BPAdditionalCustomer.BusinessPartner AND Customer = _BPAdditionalCustomer.Customer  -- association [1..1]
;

Learn More