C_SuplrListBusinessPartnerTP_2

DDL: C_SUPLRLISTBUSINESSPARTNERTP_2 Type: view_entity CONSUMPTION

Business Partner in Supplier List - TP

C_SuplrListBusinessPartnerTP_2 is a Consumption CDS View that provides data about "Business Partner in Supplier List - TP" in SAP S/4HANA. It reads from 1 data source (R_SuplrListBusinessPartnerTP) and exposes 21 fields with key field SuplrListBusinessPartnerUUID.

Data Sources (1)

SourceAliasJoin Type
R_SuplrListBusinessPartnerTP R_SuplrListBusinessPartnerTP projection

Annotations (16)

NameValueLevelField
VDM.viewType #CONSUMPTION view
EndUserText.label Business Partner in Supplier List - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.representativeKey SuplrListBusinessPartnerUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Search.searchable false view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SLB view
AbapCatalog.extensibility.quota.maximumFields 404 view
AbapCatalog.extensibility.quota.maximumBytes 40400 view
AbapCatalog.extensibility.allowNewCompositions true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SuplrListBusinessPartnerUUID _SuplrListBusinessPartnerTP SuplrListBusinessPartnerUUID Supplier List Business Partner UUID
BusinessPartnerUUID _SuplrListBusinessPartnerTP BusinessPartnerUUID UUID
Supplier _SuplrListBusinessPartnerTP Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
BusinessPartner _SuplrListBusinessPartnerTP BusinessPartner Issuing Authority
BusinessPartnerIsBlocked _SuplrListBusinessPartnerTP BusinessPartnerIsBlocked Central Block
SuplrListSupplierIsMandatory SuplrListSupplierIsMandatory Mandatory Supplier
SupplierListUUID _SuplrListBusinessPartnerTP SupplierListUUID Supplier List UUID
AddressID _SuplrListBusinessPartnerTP AddressID Ship-to address
SupplierCountryGroup _SuplrListBusinessPartnerTP SupplierCountryGroup Country/Region Group
SupplierCountryGroupText _SuplrListSuplrCntryGroupText SupplierCountryGroupText Country/Region Group
Region _Supplier Region Venue Region
RegionNameasRegionNamelocalized Region
IsDeleted IsDeleted TRUE
SuplrListSuplrProposalStatus SuplrListSuplrProposalStatus Prop. Suplr. status
SuplrListSuplrProposalAction SuplrListSuplrProposalAction Supplier Proposal Action
Country Country Venue: Ctry/Reg
CountryNamelocalized
EmailAddress _SuplrContactCard EmailAddress E-Mail Address
_SuplrContactCard _SuplrContactCard
_SuplrListSuplrCntryGroupText _SuplrListSuplrCntryGroupText

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_SuplrListBusinessPartnerTP_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_SuplrListBusinessPartnerTP_2 AS
SELECT
  _SuplrListBusinessPartnerTP.SuplrListBusinessPartnerUUID AS SuplrListBusinessPartnerUUID,
  _SuplrListBusinessPartnerTP.BusinessPartnerUUID AS BusinessPartnerUUID,
  _SuplrListBusinessPartnerTP.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  _SuplrListBusinessPartnerTP.BusinessPartner AS BusinessPartner,
  _SuplrListBusinessPartnerTP.BusinessPartnerIsBlocked AS BusinessPartnerIsBlocked,
  SuplrListSupplierIsMandatory,
  _SuplrListBusinessPartnerTP.SupplierListUUID AS SupplierListUUID,
  _SuplrListBusinessPartnerTP.AddressID AS AddressID,
  _SuplrListBusinessPartnerTP.SupplierCountryGroup AS SupplierCountryGroup,
  _SuplrListSuplrCntryGroupText.SupplierCountryGroupText AS SupplierCountryGroupText,
  _Supplier.Region AS Region,
  _RegionText.RegionName as RegionName : localized AS RegionNameasRegionNamelocalized,
  IsDeleted,
  SuplrListSuplrProposalStatus,
  SuplrListSuplrProposalAction,
  Country,
  _CountryText.CountryName : localized AS CountryNamelocalized,
  _SuplrContactCard.EmailAddress AS EmailAddress
FROM R_SuplrListBusinessPartnerTP
;