I_USFedProjectBasicDetail
Project Details
I_USFedProjectBasicDetail is a Basic CDS View (Dimension) that provides data about "Project Details" in SAP S/4HANA. It reads from 1 data source (I_ProjectBasicData) and exposes 6 fields with key field ProjectExternalID. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ProjectBasicData | I_ProjectBasicData | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_ControllingArea | _ControllingArea | $projection.ControllingArea = _ControllingArea.ControllingArea |
| [0..*] | I_ProfitCenter | _ProfitCenter2 | $projection.ControllingArea = _ProfitCenter2.ControllingArea and $projection.ProfitCenter = _ProfitCenter2.ProfitCenter |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Project Details | view | |
| VDM.viewType | #BASIC | view | |
| Analytics.internalName | #LOCAL | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_DIMENSION | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| ObjectModel.representativeKey | ProjectExternalID | view | |
| Analytics.dataExtraction.enabled | true | view | |
| Metadata.allowExtensions | true | view |
Fields (6)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ProjectExternalID | ProjectExternalID | ||
| ProjectDescription | ProjectDescription | |||
| ControllingArea | ControllingArea | |||
| ProfitCenter | ProfitCenter | |||
| _ControllingArea | _ControllingArea | |||
| _ProfitCenter2 | _ProfitCenter2 |
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Project Details'
@VDM.viewType: #BASIC
@Analytics.internalName:#LOCAL
@ObjectModel: { usageType:{ serviceQuality: #A,
sizeCategory: #S,
dataClass: #MIXED},
supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE, #SEARCHABLE_ENTITY],
modelingPattern: #ANALYTICAL_DIMENSION }
@Analytics: { dataCategory: #DIMENSION }
@ObjectModel.representativeKey: 'ProjectExternalID'
@Analytics.dataExtraction.enabled:true
@Metadata.allowExtensions:true
define view entity I_USFedProjectBasicDetail
as select from I_ProjectBasicData
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..*] to I_ProfitCenter as _ProfitCenter2 on $projection.ControllingArea = _ProfitCenter2.ControllingArea
and $projection.ProfitCenter = _ProfitCenter2.ProfitCenter
{
@ObjectModel.text.element: ['ProjectDescription']
key ProjectExternalID,
ProjectDescription,
ControllingArea,
ProfitCenter,
// Ass
_ControllingArea,
_ProfitCenter2
}
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