C_SPQtnItmDmndDistrCompare

DDL: C_SPQTNITMDMNDDISTRCOMPARE Type: view_entity CONSUMPTION

Quotation Demand Distribution

C_SPQtnItmDmndDistrCompare is a Consumption CDS View that provides data about "Quotation Demand Distribution" in SAP S/4HANA. It reads from 1 data source (R_SrcgProjQtnItmDmndDistr) and exposes 15 fields with key field SrcgProjQtnDmndDistrUUID. It has 2 associations to related views. It is exposed through 2 OData services (UI_SOURCING_PROJECT_COMPARE, UI_SRCGPROJNEGTTN_MANAGE). It is used in 1 Fiori application: Manage Negotiations.

1 data source(s) Exposed by 2 service(s) Used in 1 Fiori app(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
R_SrcgProjQtnItmDmndDistr R_SrcgProjQtnItmDmndDistr from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_SPQtnItmDmndDistrDetCompare _SPQtnDmndDistrDetsCompare $projection.SrcgProjQtnDmndDistrUUID = _SPQtnDmndDistrDetsCompare.SrcgProjQtnDmndDistrUUID
[0..1] I_BackendPlantForPurg _Plant $projection.ProcmtHubPlantUniqueID = _Plant.ProcmtHubPlantUniqueID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SrcgProjQtnDmndDistrUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
EndUserText.label Quotation Demand Distribution view

OData Services (2)

ServiceBindingVersionContractRelease
UI_SOURCING_PROJECT_COMPARE UI_SRCGPROJ_COMPARE V2 C1 NOT_RELEASED
UI_SRCGPROJNEGTTN_MANAGE UI_SRCGPROJNEGTTN_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 (15)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjQtnDmndDistrUUID SrcgProjQtnDmndDistrUUID
SrcgProjQtnItemUUID SrcgProjQtnItemUUID
Plant Plant
ProcmtHubPlantUniqueID ProcmtHubPlantUniqueID
PlantName _Plant PlantName
ProcurementProject ProcurementProject
RequestedQuantityUnit RequestedQuantityUnit
SrcgProjItemDemandConfCodeName Demand
SourcingProjectReasonText Reason for Unconfirmed Demand
SourcingProjectItemUUID _SrcgProjQtnItem SourcingProjectItemUUID
SrcgProjQtnItemOfferingCode _SrcgProjQtnItem SrcgProjQtnItemOfferingCode
SrcgProjDmndDistributionUUID _SrcgProjDemandDistribution SrcgProjDmndDistributionUUID
SourcingProjectQuotationUUID SourcingProjectQuotationUUID
_SourcingProjectQuotation _SourcingProjectQuotation
_SPQtnDmndDistrDetsCompare _SPQtnDmndDistrDetsCompare 
@AccessControl.authorizationCheck: #MANDATORY

@ObjectModel: { representativeKey: 'SrcgProjQtnDmndDistrUUID',

                usageType.dataClass: #TRANSACTIONAL,
                usageType.serviceQuality:  #C,
                usageType.sizeCategory: #L

                }

@VDM.viewType: #CONSUMPTION

@EndUserText.label: 'Quotation Demand Distribution'

define view entity C_SPQtnItmDmndDistrCompare
  as select from R_SrcgProjQtnItmDmndDistr
  association [0..*] to C_SPQtnItmDmndDistrDetCompare as _SPQtnDmndDistrDetsCompare on $projection.SrcgProjQtnDmndDistrUUID = _SPQtnDmndDistrDetsCompare.SrcgProjQtnDmndDistrUUID
  association [0..1] to I_BackendPlantForPurg         as _Plant                     on $projection.ProcmtHubPlantUniqueID   = _Plant.ProcmtHubPlantUniqueID
{
      @UI.hidden: true
  key SrcgProjQtnDmndDistrUUID,

      @UI.hidden: true
      SrcgProjQtnItemUUID,
      
      Plant,
      @UI.hidden: true      
      ProcmtHubPlantUniqueID,
      @UI.hidden: true      
      _Plant.PlantName,

      ProcurementProject,

      RequestedQuantityUnit,
      
      @EndUserText.label: 'Demand'
      _SrcgProjDemandDistribution._SrcgProjItemDemandConfCode._Text[1:Language = $session.system_language ].SrcgProjItemDemandConfCodeName,
      
      @EndUserText.label: 'Reason for Unconfirmed Demand'
      _SrcgProjDemandDistribution._SourcingProjectReason._SourcingProjectReasonText[1:Language = $session.system_language ].ProductSourcingReasonText as SourcingProjectReasonText, 
      
      @UI.hidden: true
      _SrcgProjQtnItem.SourcingProjectItemUUID,
      @UI.hidden: true
      _SrcgProjQtnItem.SrcgProjQtnItemOfferingCode,
      
      @UI.hidden: true
      _SrcgProjDemandDistribution.SrcgProjDmndDistributionUUID,

      @UI.hidden: true
      SourcingProjectQuotationUUID,

      //DCL

      _SourcingProjectQuotation,
      //associations

      _SPQtnDmndDistrDetsCompare
}

Learn More