I_ProjectDemandServiceTP

DDL: I_PROJECTDEMANDSERVICETP SQL: IPROJDMNDSRVCTP Type: view_entity TRANSACTIONAL

Project Demand for Service - TP

I_ProjectDemandServiceTP is a Transactional CDS View that provides data about "Project Demand for Service - TP" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemandService) and exposes 22 fields with key field ProjectDemandServiceUUID. It has 2 associations to related views.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemandService R_ProjectDemandService from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MngProjDmndSrvcPurReqnOrd _MngProjDmndSrvcPurReqnOrd $projection.ProjectDemandUUID = _MngProjDmndSrvcPurReqnOrd.ProjectDemandUUID
[0..1] I_ProjectDemandServiceSupplyTP _ServiceSupply

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Project Demand for Service - TP view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandServiceUUID ProjectDemandServiceUUID
ProjectDemandUUID ProjectDemandUUID
Material Material
MaterialGroup MaterialGroup
Supplier Supplier
PurchasingInfoRecord PurchasingInfoRecord
PurchaseContract PurchaseContract
PurchaseContractItem PurchaseContractItem
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_RootTP _RootTP
_ServiceSupply _ServiceSupply
_Material _Material
_MaterialText _MaterialText
_MaterialGroup _MaterialGroup
_MaterialGroupText _MaterialGroupText
_Supplier _Supplier
_MngProjDmndSrvcPurReqnOrd _MngProjDmndSrvcPurReqnOrd
_PurchasingInfoRecord _PurchasingInfoRecord 
//@AbapCatalog.sqlViewName: 'IPROJDMNDSRVCTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {

                                              






   semanticKey:       ['Material'],
   //representativeKey: ['ProjectDemandServiceUUID' ],

   //alternativeKey:    ['ProjectDemandUUID'],


   usageType: {
     serviceQuality:  #B,
     dataClass:       #TRANSACTIONAL,
     sizeCategory:    #XL
   }

}
@EndUserText.label: 'Project Demand for Service - TP'
define view entity I_ProjectDemandServiceTP
  as select from R_ProjectDemandService

  association        to parent I_ProjectDemandTP       as _RootTP                    on $projection.ProjectDemandUUID = _RootTP.ProjectDemandUUID
  composition [0..1] of I_ProjectDemandServiceSupplyTP as _ServiceSupply
  association [0..1] to I_MngProjDmndSrvcPurReqnOrd    as _MngProjDmndSrvcPurReqnOrd on $projection.ProjectDemandUUID = _MngProjDmndSrvcPurReqnOrd.ProjectDemandUUID

{
  key ProjectDemandServiceUUID,


      ProjectDemandUUID,
      // Mandatory before requested

      Material,


      MaterialGroup,

      Supplier,

      PurchasingInfoRecord,

      PurchaseContract,

      PurchaseContractItem,


      MaterialPlannedDeliveryDurn,
      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,



      _RootTP,


      _ServiceSupply,

      _Material,
      _MaterialText,
      _MaterialGroup,
      _MaterialGroupText,
      _Supplier,
      _MngProjDmndSrvcPurReqnOrd,
      _PurchasingInfoRecord


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PROJECTDEMANDSERVICE"
],
"ASSOCIATED":
[
"I_MNGPROJDMNDSRVCPURREQNORD",
"I_PRODUCTDESCRIPTION",
"I_PRODUCTGROUPTEXT_2",
"I_PRODUCTGROUP_2",
"I_PRODUCTSTDVH",
"I_PROJECTDEMANDSERVICESUPPLYTP",
"I_PROJECTDEMANDTP",
"I_PURCHASINGINFORECORD",
"I_SUPPLIER"
],
"BASE":
[
"R_PROJECTDEMANDSERVICE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More