I_StandardWorkFmlaParamGroup

DDL: I_STANDARDWORKFMLAPARAMGROUP SQL: IPPSTDWFMPARGRP Type: view BASIC Package: VDM_PP_MD_WKC

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. Part of development package VDM_PP_MD_WKC.

Data Sources (1)

SourceAliasJoin Type
tc21 tc21 from

Associations (7)

CardinalityTargetAliasCondition
[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 (20)

NameValueLevelField
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
ObjectModel.sapObjectNodeType.name StandardWorkFmlaParamGroup view
Analytics.dataExtraction.enabled true view

Fields (14)

KeyFieldSource TableSource FieldDescription
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,#EXTRACTION_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
@ObjectModel.sapObjectNodeType.name: 'StandardWorkFmlaParamGroup'
@Analytics.dataExtraction.enabled: 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
};