C_SuplrListBusinessPartnerTP_2

DDL: C_SUPLRLISTBUSINESSPARTNERTP_2 Type: view_entity CONSUMPTION
21 Fields 1 Data Sources 2 OData Services 2 Fiori Apps

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. It is exposed through 2 OData services (UI_SRCGSUPPLIERLIST_MANAGE, UI_SUPPLIERLIST_MANAGE). It is used in 2 Fiori applications: Manage Preferred Supplier Lists, Manage Suppliers for Sourcing.

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

OData Services (2)

ServiceBindingVersionContractRelease
UI_SRCGSUPPLIERLIST_MANAGE UI_SRCGSUPPLIERLIST_MANAGE V2 C1 NOT_RELEASED
UI_SUPPLIERLIST_MANAGE UI_SUPPLIERLIST_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F4333 Manage Preferred Supplier Lists Transactional An application to maintain a list of suppliers for one or more material groups and company codes
F4536 Manage Suppliers for Sourcing Transactional An application to maintain the supplier lists of Soucing project

Manage Preferred Supplier Lists

Business Role: Purchaser

Manage Suppliers for Sourcing

Business Role: Purchaser

With this app, you as a central purchaser, can create and manage lists of suppliers that your company advises you to use during the sourcing process. You can manage standard supplier lists that are available for all users, as well as user-specified supplier lists that you create for your own use.For more information, read:https://help.sap.com/viewer/DRAFT/e296651f454c4284ade361292c633d69/2021.000/en-US/1828e1bd367a49ac859bfbc24d5cbd78.html

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
;

Learn More