I_ProjectDemandTP
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)
| Source | Alias | Join Type |
|---|---|---|
| R_ProjectDemand | ProjectDemand | from |
Associations (9)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA