I_ProjectDemandMaterialTP

DDL: I_PROJECTDEMANDMATERIALTP SQL: IPROJDMNDMATLTP Type: view_entity TRANSACTIONAL

Project Demand for Material - TP

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

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemandMaterial R_ProjectDemandMaterial from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MngProjDmndMatlPurReqnOrd _ProjDmndMatlPurReqnOrd $projection.ProjectDemandUUID = _ProjDmndMatlPurReqnOrd.ProjectDemandUUID
[0..1] I_ProjDemandMaterialSupplyTP _MaterialSupply

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 Material - TP view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandMaterialUUID ProjectDemandMaterialUUID
ProjectDemandUUID ProjectDemandUUID
Material Material
StorageLocation StorageLocation
MaterialGroup MaterialGroup
Supplier Supplier
PurchasingInfoRecord PurchasingInfoRecord
PurchaseContract PurchaseContract
PurchaseContractItem PurchaseContractItem
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_MaterialNumber _MaterialNumber
_MaterialText _MaterialText
_MaterialGroup _MaterialGroup
_MaterialGroupText _MaterialGroupText
_Supplier _Supplier
_PurchasingInfoRecord _PurchasingInfoRecord
_ProjDmndMatlPurReqnOrd _ProjDmndMatlPurReqnOrd
_RootTP _RootTP
_MaterialSupply _MaterialSupply 
//@AbapCatalog.sqlViewName: 'IPROJDMNDMATLTP'

//@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: ['ProjectDemandMaterialUUID'],

   //alternativeKey: ['ProjectDemandUUID'],

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

@EndUserText.label: 'Project Demand for Material - TP'
define view entity I_ProjectDemandMaterialTP
  as select from R_ProjectDemandMaterial

  association        to parent I_ProjectDemandTP     as _RootTP                 on $projection.ProjectDemandUUID = _RootTP.ProjectDemandUUID
  association [0..1] to I_MngProjDmndMatlPurReqnOrd  as _ProjDmndMatlPurReqnOrd on $projection.ProjectDemandUUID = _ProjDmndMatlPurReqnOrd.ProjectDemandUUID

  composition [0..1] of I_ProjDemandMaterialSupplyTP as _MaterialSupply
{
  key ProjectDemandMaterialUUID,


      ProjectDemandUUID,


      Material,


      StorageLocation,



      MaterialGroup,


      Supplier,


      PurchasingInfoRecord,


      PurchaseContract,


      PurchaseContractItem,



      MaterialPlannedDeliveryDurn,

      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,

      _MaterialNumber,
      _MaterialText,
      _MaterialGroup,
      _MaterialGroupText,
      _Supplier,
      _PurchasingInfoRecord,
      _ProjDmndMatlPurReqnOrd,


      _RootTP,
      //_Root,


      _MaterialSupply
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PROJECTDEMANDMATERIAL"
],
"ASSOCIATED":
[
"I_MNGPROJDMNDMATLPURREQNORD",
"I_PRODUCTDESCRIPTION",
"I_PRODUCTGROUPTEXT_2",
"I_PRODUCTGROUP_2",
"I_PRODUCTSTDVH",
"I_PROJDEMANDMATERIALSUPPLYTP",
"I_PROJECTDEMANDTP",
"I_PURCHASINGINFORECORD",
"I_SUPPLIER"
],
"BASE":
[
"R_PROJECTDEMANDMATERIAL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More