C_SuplrListPrpsdSupplierTP_2

DDL: C_SUPLRLISTPRPSDSUPPLIERTP_2 Type: view_entity CONSUMPTION

Proposed Supplier for Supplier List - TP

C_SuplrListPrpsdSupplierTP_2 is a Consumption CDS View that provides data about "Proposed Supplier for Supplier List - TP" in SAP S/4HANA. It reads from 1 data source (R_SuplrListProposedSupplierTP) and exposes 25 fields with key field SuplrListProposedSupplierUUID.

Data Sources (1)

SourceAliasJoin Type
R_SuplrListProposedSupplierTP R_SuplrListProposedSupplierTP projection

Annotations (17)

NameValueLevelField
VDM.viewType #CONSUMPTION view
EndUserText.label Proposed Supplier for Supplier List - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.representativeKey SuplrListProposedSupplierUUID 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.entityBuffer.propagationAllowed true view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SLP view
AbapCatalog.extensibility.quota.maximumFields 204 view
AbapCatalog.extensibility.quota.maximumBytes 4080 view
AbapCatalog.extensibility.allowNewCompositions true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY SuplrListProposedSupplierUUID _SuplrListProposedSupplierTP SuplrListProposedSupplierUUID Proposed Supplier UUID
BusinessPartnerUUID _SuplrListProposedSupplierTP BusinessPartnerUUID UUID
Supplier _SuplrListProposedSupplierTP Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
BusinessPartner _SuplrListProposedSupplierTP BusinessPartner Issuing Authority
SupplierProposedByUser SupplierProposedByUser Created By
SuplrListSuplrProposedDateTime _SuplrListProposedSupplierTP SuplrListSuplrProposedDateTime Proposed On
SuplrListSupplierProposalText _SuplrListProposedSupplierTP SuplrListSupplierProposalText Proposal Comments
BusinessPartnerIsBlocked _SuplrListProposedSupplierTP BusinessPartnerIsBlocked Central Block
SuplrListSupplierApprovalText _SuplrListProposedSupplierTP SuplrListSupplierApprovalText Approval Comments
SupplierListUUID _SuplrListProposedSupplierTP SupplierListUUID Supplier List UUID
AddressID _SuplrListProposedSupplierTP AddressID Ship-to address
SuplrListSuplrProposalStatus SuplrListSuplrProposalStatus Prop. Suplr. status
IsDeleted IsDeleted TRUE
SuplrListSuplrProposalAction SuplrListSuplrProposalAction Supplier Proposal Action
Country Country Venue: Ctry/Reg
CountryNamelocalized
SupplierCountryGroup _SuplrListProposedSupplierTP SupplierCountryGroup Country/Region Group
SupplierCountryGroupText _SuplrListSuplrCntryGroupText SupplierCountryGroupText Country/Region Group
EmailAddress _SuplrContactCard EmailAddress E-Mail Address
SuplrListPrpslSitnTriggerCode SuplrListPrpslSitnTriggerCode Prop. Suplr. status
FullName _ProposedByUser FullName Name
_ProposedByUser _ProposedByUser
_SuplrContactCard _SuplrContactCard
_CountryText _CountryText

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_SuplrListPrpsdSupplierTP_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_SuplrListPrpsdSupplierTP_2 AS
SELECT
  _SuplrListProposedSupplierTP.SuplrListProposedSupplierUUID AS SuplrListProposedSupplierUUID,
  _SuplrListProposedSupplierTP.BusinessPartnerUUID AS BusinessPartnerUUID,
  _SuplrListProposedSupplierTP.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  _SuplrListProposedSupplierTP.BusinessPartner AS BusinessPartner,
  SupplierProposedByUser,
  _SuplrListProposedSupplierTP.SuplrListSuplrProposedDateTime AS SuplrListSuplrProposedDateTime,
  _SuplrListProposedSupplierTP.SuplrListSupplierProposalText AS SuplrListSupplierProposalText,
  _SuplrListProposedSupplierTP.BusinessPartnerIsBlocked AS BusinessPartnerIsBlocked,
  _SuplrListProposedSupplierTP.SuplrListSupplierApprovalText AS SuplrListSupplierApprovalText,
  _SuplrListProposedSupplierTP.SupplierListUUID AS SupplierListUUID,
  _SuplrListProposedSupplierTP.AddressID AS AddressID,
  SuplrListSuplrProposalStatus,
  IsDeleted,
  SuplrListSuplrProposalAction,
  Country,
  _CountryText.CountryName : localized AS CountryNamelocalized,
  _SuplrListProposedSupplierTP.SupplierCountryGroup AS SupplierCountryGroup,
  _SuplrListSuplrCntryGroupText.SupplierCountryGroupText AS SupplierCountryGroupText,
  _SuplrContactCard.EmailAddress AS EmailAddress,
  SuplrListPrpslSitnTriggerCode,
  _ProposedByUser.FullName AS FullName
FROM R_SuplrListProposedSupplierTP
;