A_SourcingProjectQuotation

DDL: A_SOURCINGPROJECTQUOTATION Type: view_entity CONSUMPTION
33 Fields 1 Data Sources 1 OData Services

Supplier Quotation for Sourcing Project

A_SourcingProjectQuotation is a Consumption CDS View that provides data about "Supplier Quotation for Sourcing Project" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectQuotationTP) and exposes 33 fields with key field SourcingProjectQuotationUUID. It is exposed through 1 OData service (API_SOURCINGPROJECTQUOTATION).

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectQuotationTP R_SourcingProjectQuotationTP projection

Annotations (17)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.representativeKey SourcingProjectQuotationUUID view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Supplier Quotation for Sourcing Project view
OData.entityType.name SourcingProjectQuotation_Type view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SQH view
AbapCatalog.extensibility.quota.maximumFields 204 view
AbapCatalog.extensibility.quota.maximumBytes 4080 view
AbapCatalog.extensibility.allowNewCompositions true view

OData Services (1)

ServiceBindingVersionContractRelease
API_SOURCINGPROJECTQUOTATION API_SRCGPROJQUOTATION V4 C2 C1

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectQuotationUUID SourcingProjectQuotationUUID Supplier Quotation UUID
SourcingProjectQuotation SourcingProjectQuotation Supplier Quotation
SrcgProjQuotationVersion SrcgProjQuotationVersion Version
SourcingProjectQuotationType SourcingProjectQuotationType Sourcing Project Quotation Type
SourcingProjectQuotationName SourcingProjectQuotationName Name
Bidder Bidder Business Partner
CompanyCode CompanyCode Receiver Company Code
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
DocumentCurrency _SourcingProject DocumentCurrency Document Currency
MaterialGroup MaterialGroup Product Group
SrcgProjQtnOfferCurrency SrcgProjQtnOfferCurrency Quotation Currency
SrcgProjQtnTotNetAmt SrcgProjQtnTotNetAmt Total Amount
SrcgProjQtnLifecycleStatus SrcgProjQtnLifecycleStatus Status
QtnLatestSubmissionDateTime QtnLatestSubmissionDateTime Submission Deadline
SrcgProjQtnRevisionSts SrcgProjQtnRevisionSts Revision Status
SrcgProjQtnActvtnSts SrcgProjQtnActvtnSts Activation Status
SrcgProjQtnSubmsnSts SrcgProjQtnSubmsnSts Submission Status
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
SourcingProjectNegotiationUUID SourcingProjectNegotiationUUID Negotiation UUID
PricingProcedure PricingProcedure Procedure
LastChangedByUser LastChangedByUser User Name
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
CreationDateTime CreationDateTime Timestamp
SrcgProjAttchsAreForbidden SrcgProjAttchsAreForbidden Forbid Attachments
SrcgProjNotesAreForbidden SrcgProjNotesAreForbidden Forbid Notes
SourcingOrigin SourcingOrigin Sourcing Origin
ExternalSourcingProjectQtnRef ExternalSourcingProjectQtnRef External Reference
LogicalSystem LogicalSystem Logical System
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
SourcingAwardingDate SourcingAwardingDate Awarded On
SrcgProjQtnSuitability SrcgProjQtnSuitability Suitability

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 A_SourcingProjectQuotation.
-- 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 A_SourcingProjectQuotation AS
SELECT
  SourcingProjectQuotationUUID,
  SourcingProjectQuotation,
  SrcgProjQuotationVersion,
  SourcingProjectQuotationType,
  SourcingProjectQuotationName,
  Bidder,
  CompanyCode,
  PurchasingGroup,
  PurchasingOrganization,
  _SourcingProject.DocumentCurrency AS DocumentCurrency,
  MaterialGroup,
  SrcgProjQtnOfferCurrency,
  SrcgProjQtnTotNetAmt,
  SrcgProjQtnLifecycleStatus,
  QtnLatestSubmissionDateTime,
  SrcgProjQtnRevisionSts,
  SrcgProjQtnActvtnSts,
  SrcgProjQtnSubmsnSts,
  SourcingProjectUUID,
  SourcingProjectNegotiationUUID,
  PricingProcedure,
  LastChangedByUser,
  CreatedByUser,
  LastChangeDateTime,
  CreationDateTime,
  SrcgProjAttchsAreForbidden,
  SrcgProjNotesAreForbidden,
  SourcingOrigin,
  ExternalSourcingProjectQtnRef,
  LogicalSystem,
  IsEndOfPurposeBlocked,
  SourcingAwardingDate,
  SrcgProjQtnSuitability
FROM R_SourcingProjectQuotationTP
;

Learn More