A_SourcingProjectQuotation
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)
| Source | Alias | Join Type |
|---|---|---|
| R_SourcingProjectQuotationTP | R_SourcingProjectQuotationTP | projection |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| API_SOURCINGPROJECTQUOTATION | API_SRCGPROJQUOTATION | V4 | C2 | C1 |
Fields (33)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SourcingProjectQuotationUUID | SourcingProjectQuotationUUID | ||
| SourcingProjectQuotation | SourcingProjectQuotation | |||
| SrcgProjQuotationVersion | SrcgProjQuotationVersion | |||
| SourcingProjectQuotationType | SourcingProjectQuotationType | |||
| SourcingProjectQuotationName | SourcingProjectQuotationName | |||
| Bidder | Bidder | |||
| CompanyCode | CompanyCode | |||
| PurchasingGroup | PurchasingGroup | |||
| PurchasingOrganization | PurchasingOrganization | |||
| DocumentCurrency | _SourcingProject | DocumentCurrency | ||
| MaterialGroup | MaterialGroup | |||
| SrcgProjQtnOfferCurrency | SrcgProjQtnOfferCurrency | |||
| SrcgProjQtnTotNetAmt | SrcgProjQtnTotNetAmt | |||
| SrcgProjQtnLifecycleStatus | SrcgProjQtnLifecycleStatus | |||
| QtnLatestSubmissionDateTime | QtnLatestSubmissionDateTime | |||
| SrcgProjQtnRevisionSts | SrcgProjQtnRevisionSts | |||
| SrcgProjQtnActvtnSts | SrcgProjQtnActvtnSts | |||
| SrcgProjQtnSubmsnSts | SrcgProjQtnSubmsnSts | |||
| SourcingProjectUUID | SourcingProjectUUID | |||
| SourcingProjectNegotiationUUID | SourcingProjectNegotiationUUID | |||
| PricingProcedure | PricingProcedure | |||
| LastChangedByUser | LastChangedByUser | |||
| CreatedByUser | CreatedByUser | |||
| LastChangeDateTime | LastChangeDateTime | |||
| CreationDateTime | CreationDateTime | |||
| SrcgProjAttchsAreForbidden | SrcgProjAttchsAreForbidden | |||
| SrcgProjNotesAreForbidden | SrcgProjNotesAreForbidden | |||
| SourcingOrigin | SourcingOrigin | |||
| ExternalSourcingProjectQtnRef | ExternalSourcingProjectQtnRef | |||
| LogicalSystem | LogicalSystem | |||
| IsEndOfPurposeBlocked | IsEndOfPurposeBlocked | |||
| SourcingAwardingDate | SourcingAwardingDate | |||
| SrcgProjQtnSuitability | SrcgProjQtnSuitability |
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations:true
@VDM: {
viewType : #CONSUMPTION,
lifecycle.contract.type: #PUBLIC_REMOTE_API,
usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
}
//
@ObjectModel: {
representativeKey: 'SourcingProjectQuotationUUID',
semanticKey: ['SourcingProjectQuotation'],
modelingPattern: #TRANSACTIONAL_QUERY,
supportedCapabilities: [#TRANSACTIONAL_PROVIDER],
usageType.dataClass: #TRANSACTIONAL,
usageType.serviceQuality: #B,
usageType.sizeCategory: #L
}
@EndUserText.label: 'Supplier Quotation for Sourcing Project'
@OData.entityType.name: 'SourcingProjectQuotation_Type'
@AbapCatalog.extensibility: {
extensible: true,
dataSources: ['SourcingProjectQuotationTP'],
allowNewDatasources: false,
elementSuffix: 'SQH',
quota: { maximumFields: 204,
maximumBytes: 4080 },
allowNewCompositions: true }
define root view entity A_SourcingProjectQuotation
provider contract transactional_query
as projection on R_SourcingProjectQuotationTP as SourcingProjectQuotationTP
{
key SourcingProjectQuotationUUID,
SourcingProjectQuotation,
SrcgProjQuotationVersion,
@ObjectModel.sapObjectNodeTypeReference: 'SourcingProjectQuotationType'
SourcingProjectQuotationType,
SourcingProjectQuotationName,
Bidder,
@ObjectModel.sapObjectNodeTypeReference: 'CompanyCode'
CompanyCode,
@ObjectModel.sapObjectNodeTypeReference: 'PurchasingGroup'
PurchasingGroup,
@ObjectModel.sapObjectNodeTypeReference: 'PurchasingOrganization'
PurchasingOrganization,
@ObjectModel.sapObjectNodeTypeReference: 'Currency'
_SourcingProject.DocumentCurrency,
MaterialGroup,
@ObjectModel.sapObjectNodeTypeReference: 'Currency'
SrcgProjQtnOfferCurrency,
@Semantics.amount.currencyCode: 'SrcgProjQtnOfferCurrency'
SrcgProjQtnTotNetAmt,
@ObjectModel.sapObjectNodeTypeReference: 'SrcgProjQtnLifecycleStatus'
SrcgProjQtnLifecycleStatus,
QtnLatestSubmissionDateTime,
@ObjectModel.sapObjectNodeTypeReference: 'SrcgProjQtnRevisionSts'
SrcgProjQtnRevisionSts,
@ObjectModel.sapObjectNodeTypeReference: 'SrcgProjQtnActivationStatus'
SrcgProjQtnActvtnSts,
@ObjectModel.sapObjectNodeTypeReference: 'SrcgProjQtnSubmsnSts'
SrcgProjQtnSubmsnSts,
SourcingProjectUUID,
SourcingProjectNegotiationUUID,
PricingProcedure,
LastChangedByUser,
CreatedByUser,
LastChangeDateTime,
CreationDateTime,
SrcgProjAttchsAreForbidden,
SrcgProjNotesAreForbidden,
@ObjectModel.sapObjectNodeTypeReference: 'SourcingOrigin'
SourcingOrigin,
ExternalSourcingProjectQtnRef,
LogicalSystem,
IsEndOfPurposeBlocked,
SourcingAwardingDate,
@ObjectModel.sapObjectNodeTypeReference: 'SrcgProjQtnSuitability'
SrcgProjQtnSuitability,
// /* Associations */
_SrcgProjQtnItem : redirected to composition child A_SrcgProjQtnItem,
_SrcgProjQtnAllowedCurrency : redirected to composition child A_SrcgProjQtnAllowedCurrency,
_SrcgProjQtnSupplierContact : redirected to composition child A_SrcgProjQtnSupplierContact,
_SrcgProjQtnNote : redirected to composition child A_SrcgProjQtnNote
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA