C_SrcgProjAwdgScenQuotation

DDL: C_SRCGPROJAWDGSCENQUOTATION Type: view_entity CONSUMPTION Package: ODATA_MM_PUR_SRCGPROJAWD_MAINT

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)

SourceAliasJoin Type
R_SourcingProjectQuotation _SourcingProjectQuotation from

Parameters (1)

NameTypeDefault
P_DisplayCurrency displaycurrency

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartnerSupplier _BusinessPartnerSupplier $projection.Bidder = _BusinessPartnerSupplier.BusinessPartner
[1..1] E_SourcingProjectQuotation _Extension $projection.SourcingProjectQuotationUUID = _Extension.SourcingProjectQuotationUUID

Annotations (15)

NameValueLevelField
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)

ServiceBindingVersionContractRelease
UI_SRCGPROJAWDSCEN_MANAGE UI_SRCGPROJAWDSCEN_MANAGE V2 C1 NOT_RELEASED

Fields (1)

KeyFieldSource TableSource FieldDescription
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

}