C_SuplrListPrpsdSupplierTP_2

DDL: C_SUPLRLISTPRPSDSUPPLIERTP_2 Type: view_entity CONSUMPTION Package: ODATA_MM_PUR_SUPLRLIST_MAINTN

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. It is exposed through 1 OData service (UI_SUPPLIERLIST_MANAGE). Part of development package ODATA_MM_PUR_SUPLRLIST_MAINTN.

Data Sources (1)

SourceAliasJoin Type
R_SuplrListProposedSupplierTP R_SuplrListProposedSupplierTP projection

Annotations (16)

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.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

OData Services (1)

ServiceBindingVersionContractRelease
UI_SUPPLIERLIST_MANAGE UI_SUPPLIERLIST_MANAGE V2 C1 NOT_RELEASED

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
;