P_SrcgProjCalctQuotationDate

DDL: P_SRCGPROJCALCTQUOTATIONDATE Type: view COMPOSITE Package: VDM_MM_PUR_SRCGPROJ

Calculate Submission Date of Published Sourcing Project

P_SrcgProjCalctQuotationDate is a Composite CDS View that provides data about "Calculate Submission Date of Published Sourcing Project" in SAP S/4HANA. It reads from 1 data source (R_SourcingProject) and exposes 12 fields with key field SourcingProjectUUID. Part of development package VDM_MM_PUR_SRCGPROJ.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
R_SourcingProject _SourcingProject from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.sqlViewName PSPCALCTQTNDATE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey SourcingProjectUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectUUID SourcingProjectUUID
SourcingProject SourcingProject
SourcingProjectVersion SourcingProjectVersion
QtnLatestSubmissionDateTime QtnLatestSubmissionDateTime
QuotationLatestSubmissionDate
QuotationLatestSubmissionTime
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
SourcingProjectType SourcingProjectType
CompanyCode CompanyCode
MaterialGroup MaterialGroup
_SourcingProjectType _SourcingProjectType 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@AbapCatalog :{
      sqlViewName: 'PSPCALCTQTNDATE',
      compiler.compareFilter: true,
      preserveKey: true
}
@ObjectModel:{ 
      representativeKey: 'SourcingProjectUUID',
      usageType: {
          dataClass: #TRANSACTIONAL,
          serviceQuality: #A,
          sizeCategory: #M
      }
}
@VDM: {
      private: true,
      viewType: #COMPOSITE
}

define view P_SrcgProjCalctQuotationDate 
  as select from R_SourcingProject as _SourcingProject 
{
    key SourcingProjectUUID,
        SourcingProject,
        SourcingProjectVersion,
        QtnLatestSubmissionDateTime,            
        tstmp_to_dats(QtnLatestSubmissionDateTime, $session.user_timezone, $session.client, 'NULL') as QuotationLatestSubmissionDate,
        tstmp_to_tims(QtnLatestSubmissionDateTime, $session.user_timezone, $session.client, 'NULL') as QuotationLatestSubmissionTime,
        PurchasingOrganization,
        PurchasingGroup,
        SourcingProjectType,
        CompanyCode,
        MaterialGroup,
        _SourcingProjectType
}
where SrcgProjLifecycleStatus     = '02'

Learn More