I_ProjectDemandTP

DDL: I_PROJECTDEMANDTP Type: view_entity TRANSACTIONAL

Project Demand - TP

I_ProjectDemandTP is a Transactional CDS View that provides data about "Project Demand - TP" in SAP S/4HANA. It reads from 1 data source (R_ProjectDemand) and exposes 55 fields with key field ProjectDemandUUID. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProjectDemand ProjectDemand from

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_ProjectDemandWorkPackageText _ProjectElementData $projection.ReferencedObjectUUID = _ProjectElementData.ProjectElementUUID
[0..1] I_MngProjDmndSrvcPurReqnOrd _MngProjDmndSrvcPurReqnOrd $projection.ProjectDemandUUID = _MngProjDmndSrvcPurReqnOrd.ProjectDemandUUID
[0..1] I_MngProjDmndMatlPurReqnOrd _ProjDmndMatlPurReqnOrd $projection.ProjectDemandUUID = _ProjDmndMatlPurReqnOrd.ProjectDemandUUID
[1] I_ProjDmndCalcdCatSpcfcFields _ProjDmndCalcCatSpecFields $projection.ProjectDemandUUID = _ProjDmndCalcCatSpecFields.ProjectDemandUUID
[1..1] E_ProjectDemand _ProjectDemandExtension $projection.ProjectDemandUUID = _ProjectDemandExtension.ProjectDemandUUID
[0..1] I_ProjectDemandMaterialTP _Material
[0..1] I_ProjectDemandServiceTP _Service
[0..1] I_ProjectDemandWorkTP _Work
[0..1] R_ProjectDemandExpenseTP _Expense

Annotations (16)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.sapObjectNodeType.name ProjectDemand view
ObjectModel.representativeKey ProjectDemandUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix PDM view
AbapCatalog.extensibility.quota.maximumFields 300 view
AbapCatalog.extensibility.quota.maximumBytes 45000 view
EndUserText.label Project Demand - TP view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandUUID ProjectDemandUUID
ProjectDemand ProjectDemand
ProjectDemandName ProjectDemandName
ProjectDemandDescription ProjectDemandDescription
ProjectDemandCategory ProjectDemandCategory
ProjectDemandType ProjectDemandType
ProjectUUID ProjectUUID
ReferencedObjectUUID ReferencedObjectUUID
ProjectDemandStatus ProjectDemandStatus
ProjectDemandDateMaintenance ProjectDemandDateMaintenance
ProjectDemandStartDate ProjectDemandStartDate
ProjectDemandEndDate ProjectDemandEndDate
ProjectDemandReleasedDateTime ProjectDemandReleasedDateTime
ProjDmndActualSupplyDate ProjDmndActualSupplyDate
ProjectDemandPerUnitAmount ProjectDemandPerUnitAmount
ProjectDemandRequestCurrency ProjectDemandRequestCurrency
ProjDmndRequestedQuantityUnit ProjDmndRequestedQuantityUnit
PriceUnitQty PriceUnitQty
ProjectDemandRequestNetAmount ProjectDemandRequestNetAmount
ProjDmndReqNetAmountCurrency ProjDmndReqNetAmountCurrency
ProjectDemandOverallAmount ProjectDemandOverallAmount
ProjDmndRequestedQuantity ProjDmndRequestedQuantity
Plant Plant
PurchasingGroup PurchasingGroup
PurchasingOrganization PurchasingOrganization
ProjectDemandLastUpdateSource ProjectDemandLastUpdateSource
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
ProjectDemandLastChangedByUser ProjectDemandLastChangedByUser
ProjDemandLastChangeDateTime ProjDemandLastChangeDateTime
ProjDmndExternalReferenceUUID ProjDmndExternalReferenceUUID
_Material _Material
_Service _Service
_Work _Work
_Expense _Expense
_ProjectDemandCategory _ProjectDemandCategory
_ProjectDemandType _ProjectDemandType
_Project _Project
_WorkPackage _WorkPackage
_ProjectDemandStatus _ProjectDemandStatus
_ProjDmndLastUpdateSource _ProjDmndLastUpdateSource
_ProjectDemandCurrency _ProjectDemandCurrency
_ProjectDemandNetCurrency _ProjectDemandNetCurrency
_ProjDmndQuantityUnit _ProjDmndQuantityUnit
_ProjectElementData _ProjectElementData
_Plant _Plant
_PurchasingGroup _PurchasingGroup
_PurchasingOrganisation _PurchasingOrganisation
_MngProjDmndSrvcPurReqnOrd _MngProjDmndSrvcPurReqnOrd
_ProjDmndMatlPurReqnOrd _ProjDmndMatlPurReqnOrd
_ProjDmndCalcCatSpecFields _ProjDmndCalcCatSpecFields
_ProjectDemandVH _ProjectDemandVH
_EnterpriseProjectForUser _EnterpriseProjectForUser
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

@AbapCatalog: {
 //   sqlViewName: 'IPROJECTDEMANDTP',

//    compiler.compareFilter: true,

    dataMaintenance: #RESTRICTED
 //   preserveKey:true

}

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

//@ClientHandling.algorithm: #SESSION_VARIABLE


@ObjectModel: {
   transactionalProcessingEnabled: true,

   sapObjectNodeType:{name: 'ProjectDemand'},
   semanticKey:       [ 'ProjectDemand' ],
   representativeKey: 'ProjectDemandUUID',

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

@AbapCatalog.extensibility : {
                              extensible    : true,
                              elementSuffix : 'PDM',
                              quota.maximumFields:  300 ,
                              quota.maximumBytes  : 45000 ,
                              dataSources : [ '_ProjectDemandExtension' ] 
                             }


@EndUserText.label: 'Project Demand - TP'
define root view entity I_ProjectDemandTP
  as select from R_ProjectDemand as ProjectDemand

  composition [0..1] of I_ProjectDemandMaterialTP      as _Material // will be limited by coding, validation required


  composition [0..1] of I_ProjectDemandServiceTP       as _Service  // will be limited by coding, validation required


  composition [0..1] of I_ProjectDemandWorkTP          as _Work     // will be limited by coding, validation required


  composition [0..1] of R_ProjectDemandExpenseTP       as _Expense


  //RAP migration changes . Bringing assocoation 1 level down

  association [0..1] to I_ProjectDemandWorkPackageText as _ProjectElementData           on $projection.ReferencedObjectUUID = _ProjectElementData.ProjectElementUUID
  association [0..1] to I_MngProjDmndSrvcPurReqnOrd    as _MngProjDmndSrvcPurReqnOrd    on $projection.ProjectDemandUUID = _MngProjDmndSrvcPurReqnOrd.ProjectDemandUUID
  association [0..1] to I_MngProjDmndMatlPurReqnOrd    as _ProjDmndMatlPurReqnOrd       on $projection.ProjectDemandUUID = _ProjDmndMatlPurReqnOrd.ProjectDemandUUID
  association [1]    to I_ProjDmndCalcdCatSpcfcFields  as _ProjDmndCalcCatSpecFields    on $projection.ProjectDemandUUID = _ProjDmndCalcCatSpecFields.ProjectDemandUUID
  association [1..1] to E_ProjectDemand                as _ProjectDemandExtension       on $projection.ProjectDemandUUID = _ProjectDemandExtension.ProjectDemandUUID
  // do NOT add the childrens children here, only put them into their parents especially this is then no composition!


{
      //I_ProjectDemand


  key ProjectDemandUUID,


      ProjectDemand,



      ProjectDemandName,


      ProjectDemandDescription,

      // this is derived from the Type and set implicitly!

      ProjectDemandCategory, // category not mandatory as being set by determination


      // can be changed only when created usually


      ProjectDemandType,
      
      ProjectUUID,

      // can only be changed until transfer


      ReferencedObjectUUID,

      // can only be changed until transfer

      ProjectDemandStatus,


      ProjectDemandDateMaintenance,
      // can be changed only when not synched

      // required before transfer

      ProjectDemandStartDate,
      // can be changed only when not synched

      // required before transfer

      ProjectDemandEndDate,

      ProjectDemandReleasedDateTime,

      ProjDmndActualSupplyDate,

      // can be changed only when created usually

      ProjectDemandPerUnitAmount,
      // can be changed only when created usually

      ProjectDemandRequestCurrency,

      // can be changed only when created usually

      ProjDmndRequestedQuantityUnit,
      // can be changed only when created usually

      PriceUnitQty,

      // can be changed only when created usually

      // can be changed only when created usually

      ProjectDemandRequestNetAmount,

      // can be changed only when created usually

      ProjDmndReqNetAmountCurrency,


      // can be changed only when created usually

      ProjectDemandOverallAmount,


      ProjDmndRequestedQuantity,

      // Mandatory before requested

      Plant,

      // Mandatory before requested

      PurchasingGroup,


      PurchasingOrganization,

      ProjectDemandLastUpdateSource,

      CreatedByUser,

      CreationDateTime,

      LastChangedByUser,

      LastChangeDateTime,

      ProjectDemandLastChangedByUser,

      ProjDemandLastChangeDateTime,
      
      ProjDmndExternalReferenceUUID,
      
      /* Associations */
      // BO internal associations


      _Material,

      _Service,

      _Work,
      _Expense,

      // external associations


      //I_ProjectDemand

      _ProjectDemandCategory,
      _ProjectDemandType,
      _Project,
      _WorkPackage,
      _ProjectDemandStatus,
      _ProjDmndLastUpdateSource,

      _ProjectDemandCurrency,
      _ProjectDemandNetCurrency,
      _ProjDmndQuantityUnit,
      _ProjectElementData,
      _Plant,
      _PurchasingGroup,
      _PurchasingOrganisation,
      _MngProjDmndSrvcPurReqnOrd,
      _ProjDmndMatlPurReqnOrd,
      _ProjDmndCalcCatSpecFields,
      _ProjectDemandVH,
      @Consumption.hidden: true
      _EnterpriseProjectForUser
//      _ProjectdemandExtension

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PROJECTDEMAND"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_ENTERPRISEPROJECT",
"I_ENTERPRISEPROJECTELEMENT_2",
"I_ENTERPRISEPROJECTFORUSER",
"I_MNGPROJDMNDMATLPURREQNORD",
"I_MNGPROJDMNDSRVCPURREQNORD",
"I_PLANTSTDVH",
"I_PROJDMNDCALCDCATSPCFCFIELDS",
"I_PROJDMNDLASTUPDATESOURCE",
"I_PROJECTDEMANDCATEGORY",
"I_PROJECTDEMANDMATERIALTP",
"I_PROJECTDEMANDSERVICETP",
"I_PROJECTDEMANDSITUATION",
"I_PROJECTDEMANDSTATUS",
"I_PROJECTDEMANDTYPE",
"I_PROJECTDEMANDWORKPACKAGETEXT",
"I_PROJECTDEMANDWORKTP",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_UNITOFMEASURESTDVH",
"R_PROJECTDEMANDEXPENSETP"
],
"BASE":
[
"R_PROJECTDEMAND"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/