I_ClosingFolderParameter

DDL: I_CLOSINGFOLDERPARAMETER Type: view BASIC Package: FCCO_VDM_MD

Closing Folder Parameter

I_ClosingFolderParameter is a Basic CDS View that provides data about "Closing Folder Parameter" in SAP S/4HANA. It reads from 1 data source (fcco_fldpar) and exposes 18 fields with key fields ClosingTemplate, ClosingTaskListInstance, FinancialTaskListContextType, ClosingFolder, ClosingFolderParameterType. It has 7 associations to related views. Part of development package FCCO_VDM_MD.

Data Sources (1)

SourceAliasJoin Type
fcco_fldpar fcco_fldpar from

Associations (7)

CardinalityTargetAliasCondition
[1..1] I_ClosingTemplate _ClosingTemplate $projection.ClosingTemplate = _ClosingTemplate.ClosingTemplate and $projection.FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType
[1..1] I_ClosingTaskList _ClosingTaskList $projection.ClosingTemplate = _ClosingTaskList.ClosingTemplate and $projection.ClosingTaskListInstance = _ClosingTaskList.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ClosingTaskList.FinancialTaskListContextType
[1..1] I_FinTaskListContextType _FinTaskListContextType $projection.FinancialTaskListContextType = _FinTaskListContextType.FinancialTaskListContextType
[1..1] I_ClosingFolder _ClosingFolder $projection.ClosingTemplate = _ClosingFolder.ClosingTemplate and $projection.ClosingTaskListInstance = _ClosingFolder.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ClosingFolder.FinancialTaskListContextType and $projection.ClosingFolder = _ClosingFolder.ClosingFolder
[0..1] I_ClosingFldrParamType _ClosingFolderParameterType $projection.ClosingCommunicationProfile = _ClosingFolderParameterType.ClosingCommunicationProfile and $projection.ClosingFolderParameterType = _ClosingFolderParameterType.ClosingFolderParameterType
[0..*] I_ClosingFldrParamTypeText _ClsgFolderParameterTypeText $projection.ClosingCommunicationProfile = _ClsgFolderParameterTypeText.ClosingCommunicationProfile and $projection.ClosingFolderParameterType = _ClsgFolderParameterTypeText.ClosingFolderParameterType
[0..1] I_ClosingCommProfile _ClosingCommunicationProfile $projection.ClosingCommunicationProfile = _ClosingCommunicationProfile.ClosingCommunicationProfile

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICLSGFOLDPARA view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Closing Folder Parameter view
VDM.viewType #BASIC view
ObjectModel.representativeKey ClosingFolderParameter view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ClosingTemplate profile
KEY ClosingTaskListInstance instance
KEY FinancialTaskListContextType flavor
KEY ClosingFolder org_id
KEY ClosingFolderParameterType parameter_type
KEY ClosingFolderParameter seqnr
LowerBndryClsgFolderParamRule value_low
UpperBndryClsgFolderParamRule value_high
InclusionExclusionCode sign
CompareOperatorCode opt
ClosingCommunicationProfile communication_profile
_ClosingTemplate _ClosingTemplate
_ClosingTaskList _ClosingTaskList
_FinTaskListContextType _FinTaskListContextType
_ClosingFolder _ClosingFolder
_ClosingFolderParameterType _ClosingFolderParameterType
_ClsgFolderParameterTypeText _ClsgFolderParameterTypeText
_ClosingCommunicationProfile _ClosingCommunicationProfile
@AbapCatalog: {sqlViewName: 'ICLSGFOLDPARA', preserveKey: true}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Closing Folder Parameter'
@VDM.viewType: #BASIC

@ObjectModel: { representativeKey: 'ClosingFolderParameter',
                usageType.serviceQuality: #A,
                usageType.sizeCategory: #M,
                usageType.dataClass: #MASTER }
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_ClosingFolderParameter
  as select from fcco_fldpar

  association [1..1] to I_ClosingTemplate          as _ClosingTemplate             on  $projection.ClosingTemplate              = _ClosingTemplate.ClosingTemplate
                                                                                   and $projection.FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType
  association [1..1] to I_ClosingTaskList          as _ClosingTaskList             on  $projection.ClosingTemplate              = _ClosingTaskList.ClosingTemplate
                                                                                   and $projection.ClosingTaskListInstance      = _ClosingTaskList.ClosingTaskListInstance
                                                                                   and $projection.FinancialTaskListContextType = _ClosingTaskList.FinancialTaskListContextType
  association [1..1] to I_FinTaskListContextType   as _FinTaskListContextType      on  $projection.FinancialTaskListContextType = _FinTaskListContextType.FinancialTaskListContextType
  association [1..1] to I_ClosingFolder            as _ClosingFolder               on  $projection.ClosingTemplate              = _ClosingFolder.ClosingTemplate
                                                                                   and $projection.ClosingTaskListInstance      = _ClosingFolder.ClosingTaskListInstance
                                                                                   and $projection.FinancialTaskListContextType = _ClosingFolder.FinancialTaskListContextType
                                                                                   and $projection.ClosingFolder                = _ClosingFolder.ClosingFolder
  association [0..1] to I_ClosingFldrParamType     as _ClosingFolderParameterType  on  $projection.ClosingCommunicationProfile = _ClosingFolderParameterType.ClosingCommunicationProfile
                                                                                   and $projection.ClosingFolderParameterType  = _ClosingFolderParameterType.ClosingFolderParameterType
  association [0..*] to I_ClosingFldrParamTypeText as _ClsgFolderParameterTypeText on  $projection.ClosingCommunicationProfile = _ClsgFolderParameterTypeText.ClosingCommunicationProfile
                                                                                   and $projection.ClosingFolderParameterType  = _ClsgFolderParameterTypeText.ClosingFolderParameterType
  association [0..1] to I_ClosingCommProfile       as _ClosingCommunicationProfile on  $projection.ClosingCommunicationProfile = _ClosingCommunicationProfile.ClosingCommunicationProfile
{
         @ObjectModel.foreignKey.association: '_ClosingTemplate'
  key    profile                                    as       ClosingTemplate,
         @ObjectModel.foreignKey.association: '_ClosingTaskList'
  key    instance                                   as       ClosingTaskListInstance,
         @ObjectModel.foreignKey.association: '_FinTaskListContextType'
  key    flavor                                     as       FinancialTaskListContextType,
         @ObjectModel.foreignKey.association: '_ClosingFolder'
  key    org_id                                     as       ClosingFolder,
         @ObjectModel.foreignKey.association: '_ClosingFolderParameterType'
  key    parameter_type                             as       ClosingFolderParameterType,
  key    seqnr                                      as       ClosingFolderParameter,

         value_low                                  as       LowerBndryClsgFolderParamRule,
         value_high                                 as       UpperBndryClsgFolderParamRule,
         sign                                       as       InclusionExclusionCode,
         opt                                        as       CompareOperatorCode,
         communication_profile                      as       ClosingCommunicationProfile,


         /* Associations */
         _ClosingTemplate,
         _ClosingTaskList,
         _FinTaskListContextType,
         _ClosingFolder,
         _ClosingFolderParameterType,
         _ClsgFolderParameterTypeText,
         _ClosingCommunicationProfile
}