I_CnsldtnFSItemTypeSignLogic

DDL: I_CNSLDTNFSITEMTYPESIGNLOGIC Type: view_entity BASIC Package: FIN_CS_MD_FSITEM

Consolidation FS Item Type Sign Logic

I_CnsldtnFSItemTypeSignLogic is a Basic CDS View (Dimension) that provides data about "Consolidation FS Item Type Sign Logic" in SAP S/4HANA. It reads from 1 data source (P_CnsldtnDomain) and exposes 2 fields with key field ConsolidationFSItemType. It has 2 associations to related views. Part of development package FIN_CS_MD_FSITEM.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
P_CnsldtnDomain P_CnsldtnDomain from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CnsldtnGlobalSetting _CnsldtnGlobalSetting _CnsldtnGlobalSetting.SequenceNumber = '1'
[1..1] I_CnsldtnSignLogicType _CnsldtnSignLogicType $projection.ConsolidationSignLogicType = _CnsldtnSignLogicType.ConsolidationSignLogicType

Annotations (13)

NameValueLevelField
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.representativeKey ConsolidationFSItemType view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Consolidation FS Item Type Sign Logic view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationFSItemType
_CnsldtnSignLogicType _CnsldtnSignLogicType 
@Analytics: {
  dataCategory: #DIMENSION,
  internalName: #LOCAL
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata:{
  ignorePropagatedAnnotations: true
  }
@ObjectModel:{
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #B,
    sizeCategory: #S},
    resultSet.sizeCategory: #XS,
  representativeKey: 'ConsolidationFSItemType',
  modelingPattern: #ANALYTICAL_DIMENSION,
  supportedCapabilities: [#CDS_MODELING_DATA_SOURCE,
                          #CDS_MODELING_ASSOCIATION_TARGET,
                          #SQL_DATA_SOURCE,
                          #ANALYTICAL_DIMENSION]
}
@VDM:{
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
  }
@EndUserText.label: 'Consolidation FS Item Type Sign Logic'
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view entity I_CnsldtnFSItemTypeSignLogic
  as select from           P_CnsldtnDomain(P_DomainName : 'FINCS_ITTYPE') as _Domain //select to domain-values to handle missing best-prectice content


    left outer to one join P_CnsldtnFSItemTypeSetting                     as _Source on _Source.ConsolidationFSItemType = _Domain.DomainValue

  association [0..1] to I_CnsldtnGlobalSetting as _CnsldtnGlobalSetting on _CnsldtnGlobalSetting.SequenceNumber = '1'

  association [1..1] to I_CnsldtnSignLogicType as _CnsldtnSignLogicType on $projection.ConsolidationSignLogicType = _CnsldtnSignLogicType.ConsolidationSignLogicType

{

      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_CnsldtnFinStmntItemTypeVH', element: 'ConsolidationFSItemType' } }]
  key cast( _Domain.DomainValue as fincs_fsitemtype preserving type ) as ConsolidationFSItemType,

      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_CnsldtnSignLogicTypeVH', element: 'ConsolidationSignLogicType' } }]
      @ObjectModel.foreignKey.association: '_CnsldtnSignLogicType'
      case
        when ( _CnsldtnGlobalSetting.CnsldtnCustomSignLogicIsActive = 'X' and _Source.ConsolidationSignLogicType is not null )
          then _Source.ConsolidationSignLogicType
        else
         cast ('D' as fincs_signlogictype preserving type )
      end                                                             as ConsolidationSignLogicType,


      /* associations */
      _CnsldtnSignLogicType

}

Learn More