I_ClosingFolder
Closing Folder
I_ClosingFolder is a Basic CDS View (Dimension) that provides data about "Closing Folder" in SAP S/4HANA. It reads from 1 data source (fcco_folder) and exposes 64 fields with key fields ClosingTemplate, ClosingTaskListInstance, FinancialTaskListContextType, ClosingFolder. It has 31 associations to related views. Part of development package FCCO_VDM_MD.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| fcco_folder | fcco_folder | from |
Associations (31)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_ClosingFolderText | _ClosingFolderText | $projection.ClosingTemplate = _ClosingFolderText.ClosingTemplate and $projection.ClosingTaskListInstance = _ClosingFolderText.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ClosingFolderText.FinancialTaskListContextType and $projection.ClosingFolder = _ClosingFolderText.ClosingFolder |
| [1..1] | I_ClosingTaskList | _ClosingTaskList | $projection.ClosingTemplate = _ClosingTaskList.ClosingTemplate and $projection.ClosingTaskListInstance = _ClosingTaskList.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ClosingTaskList.FinancialTaskListContextType |
| [1..1] | I_ClosingTemplate | _ClosingTemplate | $projection.ClosingTemplate = _ClosingTemplate.ClosingTemplate and $projection.FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType |
| [1..1] | I_FinTaskListContextType | _FinTaskListContextType | $projection.FinancialTaskListContextType = _FinTaskListContextType.FinancialTaskListContextType |
| [0..*] | I_FinTaskListContextTypeText | _FinTaskListContextTypeText | $projection.FinancialTaskListContextType = _FinTaskListContextTypeText.FinancialTaskListContextType |
| [0..*] | I_ClosingFolderParameter | _ClosingFolderParameter | $projection.ClosingTemplate = _ClosingFolderParameter.ClosingTemplate and $projection.ClosingTaskListInstance = _ClosingFolderParameter.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ClosingFolderParameter.FinancialTaskListContextType and $projection.ClosingFolder = _ClosingFolderParameter.ClosingFolder |
| [0..*] | I_ClosingFolderOrgUnit | _CompanyCode | $projection.ClosingTemplate = _CompanyCode.ClosingTemplate and $projection.ClosingTaskListInstance = _CompanyCode.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _CompanyCode.FinancialTaskListContextType and $projection.CompanyCodeClosingFolder = _CompanyCode.ClosingFolder |
| [0..*] | I_ClosingFolderOrgUnit | _ControllingArea | $projection.ClosingTemplate = _ControllingArea.ClosingTemplate and $projection.ClosingTaskListInstance = _ControllingArea.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ControllingArea.FinancialTaskListContextType and $projection.ControllingAreaClosingFolder = _ControllingArea.ClosingFolder |
| [0..*] | I_ClosingFolderOrgUnit | _Plant | $projection.ClosingTemplate = _Plant.ClosingTemplate and $projection.ClosingTaskListInstance = _Plant.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _Plant.FinancialTaskListContextType and $projection.PlantClosingFolder = _Plant.ClosingFolder |
| [0..1] | I_ClosingFolder | _CompanyCodeClosingFolder | $projection.ClosingTemplate = _CompanyCodeClosingFolder.ClosingTemplate and $projection.ClosingTaskListInstance = _CompanyCodeClosingFolder.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _CompanyCodeClosingFolder.FinancialTaskListContextType and $projection.CompanyCodeClosingFolder = _CompanyCodeClosingFolder.ClosingFolder |
| [0..1] | I_ClosingFolder | _ControllingAreaClosingFolder | $projection.ClosingTemplate = _ControllingAreaClosingFolder.ClosingTemplate and $projection.ClosingTaskListInstance = _ControllingAreaClosingFolder.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ControllingAreaClosingFolder.FinancialTaskListContextType and $projection.ControllingAreaClosingFolder = _ControllingAreaClosingFolder.ClosingFolder |
| [0..1] | I_ClosingFolder | _PlantClosingFolder | $projection.ClosingTemplate = _PlantClosingFolder.ClosingTemplate and $projection.ClosingTaskListInstance = _PlantClosingFolder.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _PlantClosingFolder.FinancialTaskListContextType and $projection.PlantClosingFolder = _PlantClosingFolder.ClosingFolder |
| [0..1] | I_ClosingTaskTemplateSet | _ClosingTaskTemplateSet | $projection.ClosingCommunicationProfile = _ClosingTaskTemplateSet.ClosingCommunicationProfile and $projection.ClosingTaskTemplateSet = _ClosingTaskTemplateSet.ClosingTaskTemplateSet |
| [0..*] | I_ClosingTaskTemplateSetText | _ClosingTaskTemplateSetText | $projection.ClosingCommunicationProfile = _ClosingTaskTemplateSetText.ClosingCommunicationProfile and $projection.ClosingTaskTemplateSet = _ClosingTaskTemplateSetText.ClosingTaskTemplateSet |
| [0..1] | P_MyUserGroup | _MyUserGroupAsResp | $projection.ClosingFolderResponsible = _MyUserGroupAsResp.ClosingUserGroup |
| [0..1] | P_MyUserGroupAsSubstitute | _MyUserGroupAsRespSubst | $projection.ClosingFolderResponsible = _MyUserGroupAsRespSubst.ClosingUserGroup |
| [0..1] | I_ClosingFolderType | _ClosingFolderType | $projection.ClosingFolderType = _ClosingFolderType.ClosingFolderType |
| [0..*] | I_ClosingFolderTypeText | _ClosingFolderTypeText | $projection.ClosingFolderType = _ClosingFolderTypeText.ClosingFolderType |
| [0..1] | I_ClosingNotificationConfign | _ClosingNotificationConfign | $projection.ClosingNotificationConfign = _ClosingNotificationConfign.ClosingNotificationConfign |
| [0..*] | I_ClsgNotificationConfignText | _ClsgNotificationConfignText | $projection.ClosingNotificationConfign = _ClsgNotificationConfignText.ClosingNotificationConfign |
| [0..1] | I_ClsgTaskListFactoryCal | _FactoryCalendar | $projection.ClosingCommunicationProfile = _FactoryCalendar.ClosingCommunicationProfile and $projection.FactoryCalendar = _FactoryCalendar.FactoryCalendar |
| [0..*] | I_ClsgTskListFactoryCalText | _FactoryCalendarText | $projection.ClosingCommunicationProfile = _FactoryCalendarText.ClosingCommunicationProfile and $projection.FactoryCalendar = _FactoryCalendarText.FactoryCalendar |
| [0..1] | I_ClosingTaskListLedger | _Ledger | $projection.ClosingCommunicationProfile = _Ledger.ClosingCommunicationProfile and $projection.Ledger = _Ledger.Ledger |
| [0..*] | I_ClosingTaskListLedgerText | _LedgerText | $projection.ClosingCommunicationProfile = _LedgerText.ClosingCommunicationProfile and $projection.Ledger = _LedgerText.Ledger |
| [0..1] | I_ClsgTaskListAcctgPrinciple | _AccountingPrinciple | $projection.ClosingCommunicationProfile = _AccountingPrinciple.ClosingCommunicationProfile and $projection.AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple |
| [0..*] | I_ClsgTskListAcctgPrncplText | _AccountingPrincipleText | $projection.ClosingCommunicationProfile = _AccountingPrincipleText.ClosingCommunicationProfile and $projection.AccountingPrinciple = _AccountingPrincipleText.AccountingPrinciple |
| [0..1] | I_ClsgTaskListFiscalYearVar | _FiscalYearVariant | $projection.ClosingCommunicationProfile = _FiscalYearVariant.ClosingCommunicationProfile and $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant |
| [0..*] | I_ClsgTskListFiscalYearVarText | _FiscalYearVariantText | $projection.ClosingCommunicationProfile = _FiscalYearVariantText.ClosingCommunicationProfile and $projection.FiscalYearVariant = _FiscalYearVariantText.FiscalYearVariant |
| [0..1] | I_ClosingCommProfile | _ClosingCommunicationProfile | $projection.ClosingCommunicationProfile = _ClosingCommunicationProfile.ClosingCommunicationProfile |
| [0..1] | I_ClsgTaskListCountry | _ClosingTaskListCountry | $projection.ClosingCommunicationProfile = _ClosingTaskListCountry.ClosingCommunicationProfile and $projection.Country = _ClosingTaskListCountry.Country |
| [0..*] | I_ClsgTskListCountryText | _ClsgTskListCountryText | $projection.ClosingCommunicationProfile = _ClsgTskListCountryText.ClosingCommunicationProfile and $projection.Country = _ClsgTskListCountryText.Country |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ICLSGFOLD | view | |
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| Analytics.internalName | #LOCAL | view | |
| EndUserText.label | Closing Folder | view | |
| VDM.viewType | #BASIC | view | |
| ObjectModel.representativeKey | ClosingFolder | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.allowExtensions | true | view |
Fields (64)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ClosingTemplate | profile | ||
| KEY | ClosingTaskListInstance | instance | ||
| KEY | FinancialTaskListContextType | flavor | ||
| KEY | ClosingFolder | org_id | ||
| ClosingFolderUUID | folder_uuid | |||
| ClosingFolderType | type | |||
| ClosingFolderDescription | text | |||
| ClosingFolderDfltDescription | ||||
| OrdinalNumber | pos | |||
| ClosingFolderIsActive | active | |||
| ClosingFolderResponsible | res_usr_id | |||
| ClosingFolderResponsibleType | res_usr_type | |||
| CompanyCodeClosingFolder | node_bukrs | |||
| ControllingAreaClosingFolder | node_kokrs | |||
| PlantClosingFolder | node_werks | |||
| LeadingOrgUnitClosingFolder | node_leading | |||
| HierarchyNodeLevel | hierarchy_level | |||
| NumberOfChildNodes | child_node_count | |||
| NumberOfTasks | task_count | |||
| MDHierNodeNumberOfChildNodes | descendant_count | |||
| CreatedByUser | created_by | |||
| CreationDateTime | created_on | |||
| LastChangedByUser | changed_by | |||
| LastChangeDateTime | changed_on | |||
| FactoryCalendar | factory_calendar | |||
| Ledger | rldnr | |||
| AccountingPrinciple | acc_principle | |||
| FiscalYearVariant | periv | |||
| ClosingNotificationConfign | noti_con | |||
| Country | country | |||
| ClosingCommunicationProfile | communication_profile | |||
| HasAttachment | has_attachment | |||
| ClsgFldrIsCrtedFromTaskTmplSet | iscreatedfromtemplate | |||
| ClosingTaskTemplateSet | taskset | |||
| WebsiteURL | do_not_use_url | |||
| _ClosingFolderParameter | _ClosingFolderParameter | |||
| _ClosingFolderText | _ClosingFolderText | |||
| _ClosingTaskList | _ClosingTaskList | |||
| _ClosingTemplate | _ClosingTemplate | |||
| _FinTaskListContextType | _FinTaskListContextType | |||
| _ClosingFolderType | _ClosingFolderType | |||
| _CompanyCode | _CompanyCode | |||
| _ControllingArea | _ControllingArea | |||
| _Plant | _Plant | |||
| _CompanyCodeClosingFolder | _CompanyCodeClosingFolder | |||
| _ControllingAreaClosingFolder | _ControllingAreaClosingFolder | |||
| _PlantClosingFolder | _PlantClosingFolder | |||
| _ClosingNotificationConfign | _ClosingNotificationConfign | |||
| _FactoryCalendar | _FactoryCalendar | |||
| _Ledger | _Ledger | |||
| _AccountingPrinciple | _AccountingPrinciple | |||
| _FiscalYearVariant | _FiscalYearVariant | |||
| _ClosingTaskListCountry | _ClosingTaskListCountry | |||
| _ClosingCommunicationProfile | _ClosingCommunicationProfile | |||
| _ClosingTaskTemplateSet | _ClosingTaskTemplateSet | |||
| _FinTaskListContextTypeText | _FinTaskListContextTypeText | |||
| _ClosingTaskTemplateSetText | _ClosingTaskTemplateSetText | |||
| _ClosingFolderTypeText | _ClosingFolderTypeText | |||
| _ClsgNotificationConfignText | _ClsgNotificationConfignText | |||
| _FactoryCalendarText | _FactoryCalendarText | |||
| _LedgerText | _LedgerText | |||
| _AccountingPrincipleText | _AccountingPrincipleText | |||
| _FiscalYearVariantText | _FiscalYearVariantText | |||
| _ClsgTskListCountryText | _ClsgTskListCountryText |
@AbapCatalog: {sqlViewName: 'ICLSGFOLD', preserveKey: true, compiler.compareFilter: true }
@AccessControl.authorizationCheck: #CHECK
@Analytics: {dataCategory: #DIMENSION , internalName: #LOCAL}
@EndUserText.label: 'Closing Folder'
@VDM.viewType: #BASIC
@ObjectModel: { representativeKey: 'ClosingFolder',
usageType.serviceQuality: #B,
usageType.sizeCategory: #L,
usageType.dataClass: #MASTER }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
define view I_ClosingFolder
as select from fcco_folder
association [0..*] to I_ClosingFolderText as _ClosingFolderText on $projection.ClosingTemplate = _ClosingFolderText.ClosingTemplate
and $projection.ClosingTaskListInstance = _ClosingFolderText.ClosingTaskListInstance
and $projection.FinancialTaskListContextType = _ClosingFolderText.FinancialTaskListContextType
and $projection.ClosingFolder = _ClosingFolderText.ClosingFolder
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_ClosingTemplate as _ClosingTemplate on $projection.ClosingTemplate = _ClosingTemplate.ClosingTemplate
and $projection.FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType
association [1..1] to I_FinTaskListContextType as _FinTaskListContextType on $projection.FinancialTaskListContextType = _FinTaskListContextType.FinancialTaskListContextType
association [0..*] to I_FinTaskListContextTypeText as _FinTaskListContextTypeText on $projection.FinancialTaskListContextType = _FinTaskListContextTypeText.FinancialTaskListContextType
association [0..*] to I_ClosingFolderParameter as _ClosingFolderParameter on $projection.ClosingTemplate = _ClosingFolderParameter.ClosingTemplate
and $projection.ClosingTaskListInstance = _ClosingFolderParameter.ClosingTaskListInstance
and $projection.FinancialTaskListContextType = _ClosingFolderParameter.FinancialTaskListContextType
and $projection.ClosingFolder = _ClosingFolderParameter.ClosingFolder
association [0..*] to I_ClosingFolderOrgUnit as _CompanyCode on $projection.ClosingTemplate = _CompanyCode.ClosingTemplate
and $projection.ClosingTaskListInstance = _CompanyCode.ClosingTaskListInstance
and $projection.FinancialTaskListContextType = _CompanyCode.FinancialTaskListContextType
and $projection.CompanyCodeClosingFolder = _CompanyCode.ClosingFolder
association [0..*] to I_ClosingFolderOrgUnit as _ControllingArea on $projection.ClosingTemplate = _ControllingArea.ClosingTemplate
and $projection.ClosingTaskListInstance = _ControllingArea.ClosingTaskListInstance
and $projection.FinancialTaskListContextType = _ControllingArea.FinancialTaskListContextType
and $projection.ControllingAreaClosingFolder = _ControllingArea.ClosingFolder
association [0..*] to I_ClosingFolderOrgUnit as _Plant on $projection.ClosingTemplate = _Plant.ClosingTemplate
and $projection.ClosingTaskListInstance = _Plant.ClosingTaskListInstance
and $projection.FinancialTaskListContextType = _Plant.FinancialTaskListContextType
and $projection.PlantClosingFolder = _Plant.ClosingFolder
association [0..1] to I_ClosingFolder as _CompanyCodeClosingFolder on $projection.ClosingTemplate = _CompanyCodeClosingFolder.ClosingTemplate
and $projection.ClosingTaskListInstance = _CompanyCodeClosingFolder.ClosingTaskListInstance
and $projection.FinancialTaskListContextType = _CompanyCodeClosingFolder.FinancialTaskListContextType
and $projection.CompanyCodeClosingFolder = _CompanyCodeClosingFolder.ClosingFolder
association [0..1] to I_ClosingFolder as _ControllingAreaClosingFolder on $projection.ClosingTemplate = _ControllingAreaClosingFolder.ClosingTemplate
and $projection.ClosingTaskListInstance = _ControllingAreaClosingFolder.ClosingTaskListInstance
and $projection.FinancialTaskListContextType = _ControllingAreaClosingFolder.FinancialTaskListContextType
and $projection.ControllingAreaClosingFolder = _ControllingAreaClosingFolder.ClosingFolder
association [0..1] to I_ClosingFolder as _PlantClosingFolder on $projection.ClosingTemplate = _PlantClosingFolder.ClosingTemplate
and $projection.ClosingTaskListInstance = _PlantClosingFolder.ClosingTaskListInstance
and $projection.FinancialTaskListContextType = _PlantClosingFolder.FinancialTaskListContextType
and $projection.PlantClosingFolder = _PlantClosingFolder.ClosingFolder
association [0..1] to I_ClosingTaskTemplateSet as _ClosingTaskTemplateSet on $projection.ClosingCommunicationProfile = _ClosingTaskTemplateSet.ClosingCommunicationProfile
and $projection.ClosingTaskTemplateSet = _ClosingTaskTemplateSet.ClosingTaskTemplateSet
association [0..*] to I_ClosingTaskTemplateSetText as _ClosingTaskTemplateSetText on $projection.ClosingCommunicationProfile = _ClosingTaskTemplateSetText.ClosingCommunicationProfile
and $projection.ClosingTaskTemplateSet = _ClosingTaskTemplateSetText.ClosingTaskTemplateSet
association [0..1] to P_MyUserGroup as _MyUserGroupAsResp on $projection.ClosingFolderResponsible = _MyUserGroupAsResp.ClosingUserGroup
association [0..1] to P_MyUserGroupAsSubstitute as _MyUserGroupAsRespSubst on $projection.ClosingFolderResponsible = _MyUserGroupAsRespSubst.ClosingUserGroup
association [0..1] to I_ClosingFolderType as _ClosingFolderType on $projection.ClosingFolderType = _ClosingFolderType.ClosingFolderType
association [0..*] to I_ClosingFolderTypeText as _ClosingFolderTypeText on $projection.ClosingFolderType = _ClosingFolderTypeText.ClosingFolderType
association [0..1] to I_ClosingNotificationConfign as _ClosingNotificationConfign on $projection.ClosingNotificationConfign = _ClosingNotificationConfign.ClosingNotificationConfign
association [0..*] to I_ClsgNotificationConfignText as _ClsgNotificationConfignText on $projection.ClosingNotificationConfign = _ClsgNotificationConfignText.ClosingNotificationConfign
association [0..1] to I_ClsgTaskListFactoryCal as _FactoryCalendar on $projection.ClosingCommunicationProfile = _FactoryCalendar.ClosingCommunicationProfile
and $projection.FactoryCalendar = _FactoryCalendar.FactoryCalendar
association [0..*] to I_ClsgTskListFactoryCalText as _FactoryCalendarText on $projection.ClosingCommunicationProfile = _FactoryCalendarText.ClosingCommunicationProfile
and $projection.FactoryCalendar = _FactoryCalendarText.FactoryCalendar
association [0..1] to I_ClosingTaskListLedger as _Ledger on $projection.ClosingCommunicationProfile = _Ledger.ClosingCommunicationProfile
and $projection.Ledger = _Ledger.Ledger
association [0..*] to I_ClosingTaskListLedgerText as _LedgerText on $projection.ClosingCommunicationProfile = _LedgerText.ClosingCommunicationProfile
and $projection.Ledger = _LedgerText.Ledger
association [0..1] to I_ClsgTaskListAcctgPrinciple as _AccountingPrinciple on $projection.ClosingCommunicationProfile = _AccountingPrinciple.ClosingCommunicationProfile
and $projection.AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple
association [0..*] to I_ClsgTskListAcctgPrncplText as _AccountingPrincipleText on $projection.ClosingCommunicationProfile = _AccountingPrincipleText.ClosingCommunicationProfile
and $projection.AccountingPrinciple = _AccountingPrincipleText.AccountingPrinciple
association [0..1] to I_ClsgTaskListFiscalYearVar as _FiscalYearVariant on $projection.ClosingCommunicationProfile = _FiscalYearVariant.ClosingCommunicationProfile
and $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
association [0..*] to I_ClsgTskListFiscalYearVarText as _FiscalYearVariantText on $projection.ClosingCommunicationProfile = _FiscalYearVariantText.ClosingCommunicationProfile
and $projection.FiscalYearVariant = _FiscalYearVariantText.FiscalYearVariant
association [0..1] to I_ClosingCommProfile as _ClosingCommunicationProfile on $projection.ClosingCommunicationProfile = _ClosingCommunicationProfile.ClosingCommunicationProfile
association [0..1] to I_ClsgTaskListCountry as _ClosingTaskListCountry on $projection.ClosingCommunicationProfile = _ClosingTaskListCountry.ClosingCommunicationProfile
and $projection.Country = _ClosingTaskListCountry.Country
association [0..*] to I_ClsgTskListCountryText as _ClsgTskListCountryText on $projection.ClosingCommunicationProfile = _ClsgTskListCountryText.ClosingCommunicationProfile
and $projection.Country = _ClsgTskListCountryText.Country
{
@ObjectModel.foreignKey.association: '_ClosingTemplate'
key profile as ClosingTemplate,
@ObjectModel.foreignKey.association: '_ClosingTaskList'
key instance as ClosingTaskListInstance,
@ObjectModel.foreignKey.association: '_FinTaskListContextType'
key flavor as FinancialTaskListContextType,
key org_id as ClosingFolder,
folder_uuid as ClosingFolderUUID,
@ObjectModel.foreignKey.association: '_ClosingFolderType'
type as ClosingFolderType,
//Set parent node of client folder to '999999999999', otherwise the client node is returned when it is expanded (where ParentNode = '000000000000')
cast(case
when type = 'MANDT'
then '999999999999'
else org_pid
end as fcco_folder_id) as ParentClosingFolder,
text as ClosingFolderDescription,
cast (text as fcco_folder_default_text) as ClosingFolderDfltDescription,
pos as OrdinalNumber,
active as ClosingFolderIsActive,
res_usr_id as ClosingFolderResponsible,
res_usr_type as ClosingFolderResponsibleType,
node_bukrs as CompanyCodeClosingFolder,
node_kokrs as ControllingAreaClosingFolder,
node_werks as PlantClosingFolder,
node_leading as LeadingOrgUnitClosingFolder,
hierarchy_level as HierarchyNodeLevel,
child_node_count as NumberOfChildNodes,
task_count as NumberOfTasks,
descendant_count as MDHierNodeNumberOfChildNodes,
cast(case
when (res_usr_type = 'US' and res_usr_id = $session.user) or
(res_usr_type = 'UG' and _MyUserGroupAsResp.ClosingUserGroup is not null)
then 'X'
else ''
end as fcco_is_resp) as UserIsClosingFolderResponsible,
cast(case
when (res_usr_type = 'US' and res_usr_id = $session.user) or
(res_usr_type = 'UG' and (_MyUserGroupAsResp.ClosingUserGroup is not null or
_MyUserGroupAsRespSubst.ClosingUserGroup is not null)) or
(res_usr_type = 'US' and _MyUserGroupAsRespSubst.ClosingUserGroup is not null)
then 'X'
else ''
end as fcco_is_resp_or_subst) as UserIsClsgFolderRespOrSubstit,
created_by as CreatedByUser,
created_on as CreationDateTime,
changed_by as LastChangedByUser,
changed_on as LastChangeDateTime,
@ObjectModel.foreignKey.association: '_FactoryCalendar'
factory_calendar as FactoryCalendar,
@ObjectModel.foreignKey.association: '_Ledger'
rldnr as Ledger,
@ObjectModel.foreignKey.association: '_AccountingPrinciple'
acc_principle as AccountingPrinciple,
@ObjectModel.foreignKey.association: '_FiscalYearVariant'
periv as FiscalYearVariant,
@ObjectModel.foreignKey.association: '_ClosingNotificationConfign'
noti_con as ClosingNotificationConfign,
country as Country,
@ObjectModel.foreignKey.association: '_ClosingCommunicationProfile'
communication_profile as ClosingCommunicationProfile,
//_ClosingTaskListCountry._ClsgCountryGroupCntryAssgmt.ClosingCountryGroup as ClosingCountryGroup,
has_attachment as HasAttachment,
iscreatedfromtemplate as ClsgFldrIsCrtedFromTaskTmplSet,
@ObjectModel.foreignKey.association: '_ClosingTaskTemplateSet'
taskset as ClosingTaskTemplateSet,
//WebsiteURL is just a workaround for the union of I_CLOSINGHIERARCHYNODETP. A cast of a string is currently not supported in CDS!
@Consumption.hidden: true
do_not_use_url as WebsiteURL,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_ClosingFolderParameter,
_ClosingFolderText,
_ClosingTaskList,
_ClosingTemplate,
_FinTaskListContextType,
_ClosingFolderType,
_CompanyCode,
_ControllingArea,
_Plant,
_CompanyCodeClosingFolder,
_ControllingAreaClosingFolder,
_PlantClosingFolder,
_ClosingNotificationConfign,
_FactoryCalendar,
_Ledger,
_AccountingPrinciple,
_FiscalYearVariant,
_ClosingTaskListCountry,
_ClosingCommunicationProfile,
_ClosingTaskTemplateSet,
/* Text Associations */
_FinTaskListContextTypeText,
_ClosingTaskTemplateSetText,
_ClosingFolderTypeText,
_ClsgNotificationConfignText,
_FactoryCalendarText,
_LedgerText,
_AccountingPrincipleText,
_FiscalYearVariantText,
_ClsgTskListCountryText
}
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