I_StandardWorkFmlaParamGroup
Standard Work Formula Parameter Group
I_StandardWorkFmlaParamGroup is a Basic CDS View (Dimension) that provides data about "Standard Work Formula Parameter Group" in SAP S/4HANA. It reads from 1 data source (tc21) and exposes 14 fields with key field StandardWorkFormulaParamGroup. It has 7 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| tc21 | tc21 | from |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_StandardWorkFmlaParamGrpText | _Text | $projection.StandardWorkFormulaParamGroup = _Text.StandardWorkFormulaParamGroup |
| [0..1] | I_StandardWorkFormulaParameter | _StandardWorkFormulaParameter1 | $projection.StandardWorkFormulaParam1 = _StandardWorkFormulaParameter1.StandardWorkFormulaParameter |
| [0..1] | I_StandardWorkFormulaParameter | _StandardWorkFormulaParameter2 | $projection.StandardWorkFormulaParam2 = _StandardWorkFormulaParameter2.StandardWorkFormulaParameter |
| [0..1] | I_StandardWorkFormulaParameter | _StandardWorkFormulaParameter3 | $projection.StandardWorkFormulaParam3 = _StandardWorkFormulaParameter3.StandardWorkFormulaParameter |
| [0..1] | I_StandardWorkFormulaParameter | _StandardWorkFormulaParameter4 | $projection.StandardWorkFormulaParam4 = _StandardWorkFormulaParameter4.StandardWorkFormulaParameter |
| [0..1] | I_StandardWorkFormulaParameter | _StandardWorkFormulaParameter5 | $projection.StandardWorkFormulaParam5 = _StandardWorkFormulaParameter5.StandardWorkFormulaParameter |
| [0..1] | I_StandardWorkFormulaParameter | _StandardWorkFormulaParameter6 | $projection.StandardWorkFormulaParam6 = _StandardWorkFormulaParameter6.StandardWorkFormulaParameter |
Annotations (18)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IPPSTDWFMPARGRP | view | |
| AbapCatalog.buffering.status | #ACTIVE | view | |
| AbapCatalog.buffering.type | #GENERIC | view | |
| AbapCatalog.buffering.numberOfKeyFields | 001 | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_DIMENSION | view | |
| ObjectModel.representativeKey | StandardWorkFormulaParamGroup | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.dataClass | #CUSTOMIZING | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| VDM.viewType | #BASIC | view | |
| EndUserText.label | Standard Work Formula Parameter Group | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (14)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | StandardWorkFormulaParamGroup | vgwts | ||
| StandardWorkFormulaParam1 | par01 | |||
| StandardWorkFormulaParam2 | par02 | |||
| StandardWorkFormulaParam3 | par03 | |||
| StandardWorkFormulaParam4 | par04 | |||
| StandardWorkFormulaParam5 | par05 | |||
| StandardWorkFormulaParam6 | par06 | |||
| _StandardWorkFormulaParameter1 | _StandardWorkFormulaParameter1 | |||
| _StandardWorkFormulaParameter2 | _StandardWorkFormulaParameter2 | |||
| _StandardWorkFormulaParameter3 | _StandardWorkFormulaParameter3 | |||
| _StandardWorkFormulaParameter4 | _StandardWorkFormulaParameter4 | |||
| _StandardWorkFormulaParameter5 | _StandardWorkFormulaParameter5 | |||
| _StandardWorkFormulaParameter6 | _StandardWorkFormulaParameter6 | |||
| _Text | _Text |
@AbapCatalog.sqlViewName: 'IPPSTDWFMPARGRP'
@AbapCatalog.buffering: {status: #ACTIVE, type: #GENERIC, numberOfKeyFields: 001}
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.representativeKey: 'StandardWorkFormulaParamGroup'
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Standard Work Formula Parameter Group'
@Metadata.ignorePropagatedAnnotations: true
define view I_StandardWorkFmlaParamGroup
as select from tc21
association [0..*] to I_StandardWorkFmlaParamGrpText as _Text on $projection.StandardWorkFormulaParamGroup = _Text.StandardWorkFormulaParamGroup
association [0..1] to I_StandardWorkFormulaParameter as _StandardWorkFormulaParameter1 on $projection.StandardWorkFormulaParam1 = _StandardWorkFormulaParameter1.StandardWorkFormulaParameter
association [0..1] to I_StandardWorkFormulaParameter as _StandardWorkFormulaParameter2 on $projection.StandardWorkFormulaParam2 = _StandardWorkFormulaParameter2.StandardWorkFormulaParameter
association [0..1] to I_StandardWorkFormulaParameter as _StandardWorkFormulaParameter3 on $projection.StandardWorkFormulaParam3 = _StandardWorkFormulaParameter3.StandardWorkFormulaParameter
association [0..1] to I_StandardWorkFormulaParameter as _StandardWorkFormulaParameter4 on $projection.StandardWorkFormulaParam4 = _StandardWorkFormulaParameter4.StandardWorkFormulaParameter
association [0..1] to I_StandardWorkFormulaParameter as _StandardWorkFormulaParameter5 on $projection.StandardWorkFormulaParam5 = _StandardWorkFormulaParameter5.StandardWorkFormulaParameter
association [0..1] to I_StandardWorkFormulaParameter as _StandardWorkFormulaParameter6 on $projection.StandardWorkFormulaParam6 = _StandardWorkFormulaParameter6.StandardWorkFormulaParameter
{
@ObjectModel.text.association: '_Text'
key vgwts as StandardWorkFormulaParamGroup,
@ObjectModel.foreignKey.association: '_StandardWorkFormulaParameter1'
par01 as StandardWorkFormulaParam1,
@ObjectModel.foreignKey.association: '_StandardWorkFormulaParameter2'
par02 as StandardWorkFormulaParam2,
@ObjectModel.foreignKey.association: '_StandardWorkFormulaParameter3'
par03 as StandardWorkFormulaParam3,
@ObjectModel.foreignKey.association: '_StandardWorkFormulaParameter4'
par04 as StandardWorkFormulaParam4,
@ObjectModel.foreignKey.association: '_StandardWorkFormulaParameter5'
par05 as StandardWorkFormulaParam5,
@ObjectModel.foreignKey.association: '_StandardWorkFormulaParameter6'
par06 as StandardWorkFormulaParam6,
// Associations
_StandardWorkFormulaParameter1,
_StandardWorkFormulaParameter2,
_StandardWorkFormulaParameter3,
_StandardWorkFormulaParameter4,
_StandardWorkFormulaParameter5,
_StandardWorkFormulaParameter6,
_Text
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TC21"
],
"ASSOCIATED":
[
"I_STANDARDWORKFMLAPARAMGRPTEXT",
"I_STANDARDWORKFORMULAPARAMETER"
],
"BASE":
[],
"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