A_SourcingProjectQuotation

DDL: A_SOURCINGPROJECTQUOTATION Type: view_entity CONSUMPTION

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
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
}