C_SrcgProjAwdgScenQuotation
Quotations related to Awarding Scenario
C_SrcgProjAwdgScenQuotation is a Consumption CDS View that provides data about "Quotations related to Awarding Scenario" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectQuotation) and exposes 1 field. It has 2 associations to related views. It is exposed through 1 OData service (UI_SRCGPROJAWDSCEN_MANAGE). Part of development package ODATA_MM_PUR_SRCGPROJAWD_MAINT.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_SourcingProjectQuotation | _SourcingProjectQuotation | from |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_DisplayCurrency | displaycurrency |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_BusinessPartnerSupplier | _BusinessPartnerSupplier | $projection.Bidder = _BusinessPartnerSupplier.BusinessPartner |
| [1..1] | E_SourcingProjectQuotation | _Extension | $projection.SourcingProjectQuotationUUID = _Extension.SourcingProjectQuotationUUID |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| Search.searchable | false | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.representativeKey | SourcingProjectQuotationUUID | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| Metadata.allowExtensions | true | view | |
| EndUserText.label | Quotations related to Awarding Scenario | view | |
| AbapCatalog.extensibility.extensible | true | view | |
| AbapCatalog.extensibility.allowNewDatasources | false | view | |
| AbapCatalog.extensibility.elementSuffix | SAQ | 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 |
|---|---|---|---|---|
| UI_SRCGPROJAWDSCEN_MANAGE | UI_SRCGPROJAWDSCEN_MANAGE | V2 | C1 | NOT_RELEASED |
Fields (1)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| SourcingProjectVersion |
@AccessControl.authorizationCheck: #MANDATORY
@Search.searchable: false
@VDM: { viewType:#CONSUMPTION }
@ObjectModel: { representativeKey: 'SourcingProjectQuotationUUID',
usageType:{ dataClass: #MIXED,
serviceQuality: #C,
sizeCategory: #L }
}
@Metadata.allowExtensions: true
@EndUserText.label: 'Quotations related to Awarding Scenario'
@AbapCatalog.extensibility: {
extensible: true,
allowNewDatasources: false,
elementSuffix: 'SAQ',
quota: { maximumFields: 204,
maximumBytes: 4080 },
allowNewCompositions: true }
define view entity C_SrcgProjAwdgScenQuotation
with parameters
@Consumption.valueHelpDefinition: [{ entity: { name : 'I_Currency', element : 'Currency' } }]
@UI.hidden:true
P_DisplayCurrency : displaycurrency
as select from R_SourcingProjectQuotation as _SourcingProjectQuotation
association [0..1] to I_BusinessPartnerSupplier as _BusinessPartnerSupplier on $projection.Bidder = _BusinessPartnerSupplier.BusinessPartner
//Extension
association [1..1] to E_SourcingProjectQuotation as _Extension on $projection.SourcingProjectQuotationUUID = _Extension.SourcingProjectQuotationUUID
{
@UI.hidden: true
key SourcingProjectQuotationUUID,
_SourcingProjectQuotation.SourcingProjectQuotationType,
_SourcingProjectQuotation.IsEndOfPurposeBlocked,
_SourcingProjectQuotation.SourcingProjectQuotation as SourcingProjectQuotation,
_SourcingProjectQuotation.SrcgProjQuotationVersion as SrcgProjQuotationVersion,
_SourcingProjectQuotation.SourcingProjectQuotationName as SourcingProjectQuotationName,
_SourcingProjectQuotation.SrcgProjQuotationIsSimulated,
@ObjectModel.text.element: ['SrcgProjQtnLifecycleStatusName']
_SourcingProjectQuotation.SrcgProjQtnLifecycleStatus,
@ObjectModel.text.element: ['BusinessPartnerName']
_SourcingProjectQuotation.Bidder,
_BusinessPartnerSupplier.Supplier,
_SourcingProjectQuotation._BusinessPartner.BusinessPartnerName,
@Semantics.amount.currencyCode: 'DisplayCurrency'
cast(currency_conversion( amount => SrcgProjQtnTotNetAmt,
source_currency => SrcgProjQtnOfferCurrency,
round => 'X',
target_currency => $parameters.P_DisplayCurrency,
exchange_rate_date => cast($session.system_date as abap.dats),
exchange_rate_type => cast(_SourcingProject.ExchangeRateType as kurst),
error_handling => 'SET_TO_NULL' ) as vdm_srcgprojqtntotnetamt preserving type ) as SrcgProjQtnTotNetAmt,
@Consumption.filter.hidden: true
$parameters.P_DisplayCurrency as DisplayCurrency,
_SourcingProjectQuotation.SrcgProjQtnOfferCurrency as SrcgProjQtnOfferCurrency,
@ObjectModel.text.element: ['CompanyCodeName']
_SourcingProjectQuotation.CompanyCode as CompanyCode,
@ObjectModel.text.element: ['PurchasingGroupName']
_SourcingProjectQuotation.PurchasingGroup as PurchasingGroup,
@ObjectModel.text.element: ['PurchasingOrganizationName']
_SourcingProjectQuotation.PurchasingOrganization as PurchasingOrganization,
_SourcingProjectQuotation._CompanyCode.CompanyCodeName as CompanyCodeName,
_SourcingProjectQuotation._PurchasingGroup.PurchasingGroupName as PurchasingGroupName,
_SourcingProjectQuotation._PurchasingOrganization.PurchasingOrganizationName as PurchasingOrganizationName,
@Semantics.text: true
_SourcingProjectQuotation._SrcgProjQtnLifecycleSts._Text[1: Language = $session.system_language].SrcgProjQtnLifecycleStatusName,
_SourcingProjectQuotation.SourcingProjectUUID as SourcingProjectUUID,
_SourcingProjectQuotation.SourcingProjectNegotiationUUID as SourcingProjectNegotiationUUID,
@Semantics.systemDateTime.lastChangedAt: true
_SourcingProjectQuotation.LastChangeDateTime as LastChangeDateTime,
@Semantics.systemDateTime.createdAt: true
_SourcingProjectQuotation.CreationDateTime as CreationDateTime,
_SourcingProjectQuotation.LogicalSystem as LogicalSystem,
@ObjectModel.text.element: ['MaterialGroupName']
_SourcingProjectQuotation.MaterialGroup as MaterialGroup,
@Semantics.text: true
_SourcingProjectQuotation._MaterialGroup._Text[1: Language = $session.system_language].MaterialGroupName,
_SourcingProject.SourcingProject,
_SourcingProject.SourcingProjectVersion
}
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