C_SourcingProjectQuotationTP

DDL: C_SOURCINGPROJECTQUOTATIONTP Type: view_entity CONSUMPTION

Quotation for Sourcing Project - TP

C_SourcingProjectQuotationTP is a Consumption CDS View that provides data about "Quotation for Sourcing Project - TP" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectQuotationTP) and exposes 78 fields with key field SourcingProjectQuotationUUID. It has 1 association to related views. It is exposed through 2 OData services (UI_SRCGPROJNEGTTN_MANAGE, UI_SRCGPROJQUOTATION_MANAGE). It is used in 1 Fiori application: Manage Negotiations.

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectQuotationTP R_SourcingProjectQuotationTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_SrcgProjQtnLegalTransaction _LegalTransaction _LegalTransaction.LglCntntMLinkdObj = $projection.LglCntntMLinkdObj and _LegalTransaction.LglCntntMIntegrationLink = 'SQN'

Annotations (16)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY 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 Quotation for Sourcing Project - TP view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SQH view
AbapCatalog.extensibility.quota.maximumFields 404 view
AbapCatalog.extensibility.quota.maximumBytes 40400 view
AbapCatalog.extensibility.allowNewCompositions true view

OData Services (2)

ServiceBindingVersionContractRelease
UI_SRCGPROJNEGTTN_MANAGE UI_SRCGPROJNEGTTN_MANAGE V2 C1 NOT_RELEASED
UI_SRCGPROJQUOTATION_MANAGE UI_SRCGPROJQTN_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5551 Manage Negotiations Transactional An application to manage the negotiation of Sourcing Project Quotations.

Manage Negotiations

Business Role: Purchaser

Fields (78)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectQuotationUUID SourcingProjectQuotationUUID
SourcingProjectQuotation SourcingProjectQuotation
SrcgProjQuotationVersion SrcgProjQuotationVersion
SourcingProjectQuotationType SourcingProjectQuotationType
SourcingProjectTypeTextlocalized
SourcingProjectQuotationName SourcingProjectQuotationName
SrcgProjQuotationIsSimulated SrcgProjQuotationIsSimulated
int1
Bidder Bidder
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName
CompanyCode CompanyCode
CompanyCodeName _CompanyCode CompanyCodeName
PurchasingGroup PurchasingGroup
PurchasingGroupName _PurchasingGroup PurchasingGroupName
PurchasingOrganization PurchasingOrganization
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName
SrcgProjQtnOfferCurrency SrcgProjQtnOfferCurrency
CurrencyNamelocalized
SrcgProjQtnTotNetAmt SrcgProjQtnTotNetAmt
SrcgProjQtnLifecycleStatus SrcgProjQtnLifecycleStatus
SrcgProjQtnLifecycleStatusNamelocalized
SrcgProjQtnRevisionSts SrcgProjQtnRevisionSts
SrcgProjQtnActvtnSts SrcgProjQtnActvtnSts
SrcgProjQtnSubmsnSts SrcgProjQtnSubmsnSts
SrcgProjQtnAwardingStatus SrcgProjQtnAwardingStatus
SourcingProjectUUID SourcingProjectUUID
SourcingProjectNegotiationUUID SourcingProjectNegotiationUUID
PricingProcedure PricingProcedure
LastChangedByUser LastChangedByUser
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
CreationDateTime CreationDateTime
SrcgProjAttchsAreForbidden SrcgProjAttchsAreForbidden
SrcgProjNotesAreForbidden SrcgProjNotesAreForbidden
SourcingOrigin SourcingOrigin
SrcgProjSourcingOriginTextlocalized
ExternalSourcingProjectQtnRef ExternalSourcingProjectQtnRef
QtnLatestSubmissionDateTime QtnLatestSubmissionDateTime
LogicalSystem LogicalSystem
SourceSrcgProjQuotationUUID SourceSrcgProjQuotationUUID
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
CashDiscount1Days CashDiscount1Days
CashDiscount2Days CashDiscount2Days
CashDiscount1Percent CashDiscount1Percent
CashDiscount2Percent CashDiscount2Percent
NetPaymentDays NetPaymentDays
MaterialGroup MaterialGroup
MaterialGroupNamelocalized
SourcingAwardingDate SourcingAwardingDate
LglCntntMLinkdObj LglCntntMLinkdObj
SrcgProjQtnSuitabilityTextlocalized
SrcgProjQtnSuitability SrcgProjQtnSuitability
SourcingProject _SourcingProject SourcingProject
SourcingProjectVersion _SourcingProject SourcingProjectVersion
ExchangeRateType _SourcingProject ExchangeRateType
SrcgProjTotalTargetAmount _SourcingProject SrcgProjTotalTargetAmount
DocumentCurrency _SourcingProject DocumentCurrency
SourcingProjectNegotiation _SourcingProjectNegotiation SourcingProjectNegotiation
SourcingProjectNegotiationName _SourcingProjectNegotiation SourcingProjectNegotiationName
SourcingProjectNegotiationType _SourcingProjectNegotiation SourcingProjectNegotiationType
SrcgProjectNegotiationTypeNamelocalized
char1
virtualSrcgProjQtnIsInPreparationboolean
char450
virtualUICT_CurrConvCriticalityint1
DeviationPercentUnit
_BusinessPartner _BusinessPartner
_CompanyCode _CompanyCode
_PurchasingGroup _PurchasingGroup
_PurchasingOrganization _PurchasingOrganization
_SourcingProject _SourcingProject
_SrcgProjQtnLifecycleSts _SrcgProjQtnLifecycleSts
_SrcgProjQtnOfferCurrency _SrcgProjQtnOfferCurrency
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_MaterialGroup _MaterialGroup
_LegalTransaction _LegalTransaction
_SourceSrcgProjQuotation _SourceSrcgProjQuotation
@AccessControl.authorizationCheck: #MANDATORY

@Search.searchable: true

@VDM: { viewType:#CONSUMPTION,
        usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]  }

@ObjectModel: { semanticKey: [ 'SrcgProjQuotationVersion', 'SourcingProjectQuotation' ],
                modelingPattern:        #TRANSACTIONAL_QUERY,
                supportedCapabilities: [#TRANSACTIONAL_PROVIDER],
                representativeKey: 'SourcingProjectQuotationUUID',
                usageType:{ dataClass: #MIXED,
                            serviceQuality: #C,
                            sizeCategory: #L }
              }

@AccessControl.privilegedAssociations: [ '_CreatedByUser', '_ChangedByUser','_LegalTransaction' ]

@Metadata.allowExtensions: true

@EndUserText.label: 'Quotation for Sourcing Project - TP'
@AbapCatalog.extensibility: {
  extensible: true,
  dataSources: ['SourcingProjectQuotationTP'],
  allowNewDatasources: false,
  elementSuffix: 'SQH',
  quota: { maximumFields: 404,
           maximumBytes: 40400 },
  allowNewCompositions: true }

define root view entity C_SourcingProjectQuotationTP
  provider contract transactional_query
  as projection on R_SourcingProjectQuotationTP as SourcingProjectQuotationTP

  association [0..*] to C_SrcgProjQtnLegalTransaction as _LegalTransaction on  _LegalTransaction.LglCntntMLinkdObj        = $projection.LglCntntMLinkdObj
                                                                           and _LegalTransaction.LglCntntMIntegrationLink = 'SQN'

{
  key      SourcingProjectQuotationUUID,

           SourcingProjectQuotation,
           SrcgProjQuotationVersion,
           @ObjectModel.text.element: ['SourcingProjectTypeText']
           SourcingProjectQuotationType,
           @UI.hidden: true
           _SourcingProjectTypeText.SourcingProjectTypeText                                          : localized,

           SourcingProjectQuotationName,

           SrcgProjQuotationIsSimulated,
           @UI.hidden: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  UICT_SrcgProjQtnIsSimulated    : abap.int1,
           @UI.hidden: true
           @Semantics.booleanIndicator: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  UICT_SrcgProjQtnIsSimHidden    : boolean,
           @Consumption.semanticObject: 'BusinessPartner'
           @ObjectModel.text.element: ['BusinessPartnerFullName']
           Bidder,
           _BusinessPartner.BusinessPartnerFullName,
           @ObjectModel.text.element: ['CompanyCodeName']
           CompanyCode,
           _CompanyCode.CompanyCodeName,

           @ObjectModel.text.element: ['PurchasingGroupName']
           PurchasingGroup,
           _PurchasingGroup.PurchasingGroupName,

           @ObjectModel.text.element: ['PurchasingOrganizationName']
           PurchasingOrganization,
           _PurchasingOrganization.PurchasingOrganizationName,

           @ObjectModel.text.element: ['CurrencyName']
           SrcgProjQtnOfferCurrency,
           _OfferCurrencyText.CurrencyName                                                           : localized,
           SrcgProjQtnTotNetAmt,

           @ObjectModel.text.element: ['SrcgProjQtnLifecycleStatusName']
           SrcgProjQtnLifecycleStatus,
           _SrcgProjQtnLifecycleSts._Text.SrcgProjQtnLifecycleStatusName                             : localized,

           SrcgProjQtnRevisionSts,
           SrcgProjQtnActvtnSts,
           SrcgProjQtnSubmsnSts,
           SrcgProjQtnAwardingStatus,
           SourcingProjectUUID,
           SourcingProjectNegotiationUUID,
           PricingProcedure,
           LastChangedByUser,
           CreatedByUser,
           LastChangeDateTime,
           CreationDateTime,
           SrcgProjAttchsAreForbidden,
           SrcgProjNotesAreForbidden,
           @ObjectModel.text.element: ['SrcgProjSourcingOriginText']
           SourcingOrigin,
           _SrcgProjSourcingOriginText.SrcgProjSourcingOriginText                                    : localized,
           ExternalSourcingProjectQtnRef,
           QtnLatestSubmissionDateTime,
           LogicalSystem,
           SourceSrcgProjQuotationUUID,
           IsEndOfPurposeBlocked,
           CashDiscount1Days,
           CashDiscount2Days,
           CashDiscount1Percent,
           CashDiscount2Percent,
           NetPaymentDays,
           @ObjectModel.text.element: ['MaterialGroupName']
           MaterialGroup,
           _MaterialGroupText.MaterialGroupName                                                      : localized,
           SourcingAwardingDate,
           LglCntntMLinkdObj,
           _SrcgProjQtnSuitabilityTxt.SrcgProjQtnSuitabilityText                                     : localized,
           @ObjectModel: { text.element: ['SrcgProjQtnSuitabilityText'] }
           SrcgProjQtnSuitability,
           @ObjectModel: { text.element: ['SrcgProjVersionConcatenated'] }
           @Consumption.semanticObject: 'SourcingProject'
           _SourcingProject.SourcingProject,
           _SourcingProject.SourcingProjectVersion,
           _SourcingProject.SrcgProjVersionConcatenated,
           _SourcingProject.ExchangeRateType,
           @Semantics.amount.currencyCode: 'DocumentCurrency'
           _SourcingProject.SrcgProjTotalTargetAmount,
           @ObjectModel.text.element: ['DocumentCurrencyName']
           _SourcingProject.DocumentCurrency,
           _SourcingProject._DocumentCurrency._Text.CurrencyName                                    as DocumentCurrencyName             : localized,
           @Consumption.semanticObject: 'SourcingProjectNegotiation'
           @ObjectModel.text.element: ['SourcingProjectNegotiationName']
           _SourcingProjectNegotiation.SourcingProjectNegotiation,
           _SourcingProjectNegotiation.SourcingProjectNegotiationName,
           @ObjectModel.text.element: ['SrcgProjectNegotiationTypeName']
           _SourcingProjectNegotiation.SourcingProjectNegotiationType,
           _SourcingProjectNegotiation._SrcgProjNegotiationType._Text.SrcgProjectNegotiationTypeName : localized,
           @UI.hidden: true
           @Semantics.booleanIndicator: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  SrcgProjQtnIsNotInNegotiation  : boolean,

           @UI.hidden: true
           @Semantics.booleanIndicator: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  SPQtnIsNotInOngoingNegotiation : boolean,

           @UI.hidden: true
           @Semantics.booleanIndicator: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  UICT_SPQNNotFrmAndNotSelForNGN : boolean, 

           @Semantics.booleanIndicator: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  IsChangeDocumentsEnabled       : abap_boolean,

           @UI.hidden: true
           @Semantics.booleanIndicator: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  IsLglTransIntegEnabled         : abap.char( 1 ),

           @UI.hidden: true
           @Semantics.booleanIndicator: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  SrcgProjQtnIsInPreparation     : boolean,

           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  NoteTypeListText               : abap.char( 450 ),

           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  SrcgProjQtnNegotiationStatus   : vdm_srcgprojqtnnegotiationsts,

           @UI.hidden: true
           @ObjectModel.virtualElement: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  SrcgProjQtnSutbltyCritlty      : mm_pur_spq_suitability_critlty,

           @UI.hidden: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  UICT_SPQtnSutbltyHidden        : abap_boolean,
           @UI.hidden: true
           @Semantics.booleanIndicator: true
           @ObjectModel.virtualElementCalculatedBy:  'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  UICT_ConfirmDemandEnablement   : abap_boolean,
           @UI.hidden: true
           @ObjectModel.virtualElement: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  UICT_ConfirmDemandRsnIsHidden  : abap_boolean,

           @UI.hidden: true
           @ObjectModel.sort.enabled: false
           @ObjectModel.filter.enabled: false
           @ObjectModel.virtualElement: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  UICT_ExclusionRsnIsEnabled     : abap_boolean,

           @UI.hidden: true
           @ObjectModel.sort.enabled: false
           @ObjectModel.filter.enabled: false
           @ObjectModel.virtualElement: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  UICT_ExclusionRsnIsDisabled    : abap_boolean,

           @Semantics.amount.currencyCode: 'SrcgProjQtnOfferCurrency'
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  SrcgProjQtnTotalTargetAmount   : vdm_srcgprojqtntottargetamount,


           @Semantics.amount.currencyCode: 'SrcgProjQtnOfferCurrency'
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  SrcgProjQtnDeviationAmount     : vdm_srcgprojqtndeviationamt,

           @Semantics.quantity.unitOfMeasure: 'DeviationPercentUnit'
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  SrcgProjQtnDeviationPercent    : vdm_srcgprojqtndeviationpct,

           @UI.hidden: true
           @ObjectModel.virtualElement: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MM_SPQTN_TRANS_EXIT'
  virtual  UICT_CurrConvCriticality       : int1,

           cast(_DeviationPercentUnit.UnitOfMeasure as vdm_deviation_percent_unit preserving type ) as DeviationPercentUnit,

           /* Associations */
           @ObjectModel.filter.enabled: false
           _SrcgProjQtnItem            : redirected to composition child C_SrcgProjQtnItemTP,
           _SrcgProjQtnAllowedCurrency : redirected to composition child C_SrcgProjQtnAllowedCurrencyTP,
           _SrcgProjQtnSupplierContact : redirected to composition child C_SrcgProjQtnSupplierContactTP,
           _BusinessPartner,
           _CompanyCode,
           _PurchasingGroup,
           _PurchasingOrganization,
           _SourcingProject,
           _SrcgProjQtnLifecycleSts,
           _SrcgProjQtnOfferCurrency,
           //tbd

           _CreatedByUser,
           _ChangedByUser,
           _MaterialGroup,
           _LegalTransaction,
           _SourceSrcgProjQuotation
}