Which tables does I_ClosingFolderOrgUnit use?

I_ClosingFolderOrgUnit reads from 1 data source(s): fcco_fol_org_ass.

I_ClosingFolderOrgUnit

Q: How many fields does I_ClosingFolderOrgUnit have?

I_ClosingFolderOrgUnit has 14 fields. Key fields: ClosingTemplate, ClosingTaskListInstance, FinancialTaskListContextType, ClosingFolder, OrganizationalUnit.

DDL: I_CLOSINGFOLDERORGUNIT Type: view BASIC Package: FCCO_VDM_MD

Closing Folder Organizational Unit

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

Data Sources (1)

Source	Alias	Join Type
fcco_fol_org_ass	fcco_fol_org_ass	from

Associations (7)

Cardinality	Target	Alias	Condition
[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`
[1..1]	I_ClosingFolderType	_ClosingFolderType	`$projection.ClosingFolderType = _ClosingFolderType.ClosingFolderType`
[0..1]	I_ClosingCommProfile	_ClosingCommunicationProfile	`$projection.ClosingCommunicationProfile = _ClosingCommunicationProfile.ClosingCommunicationProfile`
[0..1]	I_ClosingTaskListOrgUnit	_ClosingTaskListOrgUnit	`$projection.ClosingCommunicationProfile = _ClosingTaskListOrgUnit.ClosingCommunicationProfile and $projection.ClosingFolderType = _ClosingTaskListOrgUnit.ClosingFolderType and $projection.OrganizationalUnit = _ClosingTaskListOrgUnit.OrganizationalUnit`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	ICLSGFOLDORGU	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Closing Folder Organizational Unit	view
VDM.viewType	#BASIC	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MASTER	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (14)

Key	Field	Source Field
KEY	ClosingTemplate	profile
KEY	ClosingTaskListInstance	instance
KEY	FinancialTaskListContextType	flavor
KEY	ClosingFolder	org_id
KEY	OrganizationalUnit	value
	ClosingFolderType	type
	ClosingCommunicationProfile	communication_profile
	_ClosingTemplate	_ClosingTemplate
	_ClosingTaskList	_ClosingTaskList
	_FinTaskListContextType	_FinTaskListContextType
	_ClosingFolder	_ClosingFolder
	_ClosingFolderType	_ClosingFolderType
	_ClosingCommunicationProfile	_ClosingCommunicationProfile
	_ClosingTaskListOrgUnit	_ClosingTaskListOrgUnit

@AbapCatalog: {sqlViewName: 'ICLSGFOLDORGU', preserveKey: true}
@EndUserText.label: 'Closing Folder Organizational Unit'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #A,
                usageType.sizeCategory: #M,
                usageType.dataClass: #MASTER }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_ClosingFolderOrgUnit
  as select from fcco_fol_org_ass

  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 [1..1] to I_ClosingFolderType      as _ClosingFolderType           on  $projection.ClosingFolderType = _ClosingFolderType.ClosingFolderType
  association [0..1] to I_ClosingCommProfile     as _ClosingCommunicationProfile on  $projection.ClosingCommunicationProfile = _ClosingCommunicationProfile.ClosingCommunicationProfile
  association [0..1] to I_ClosingTaskListOrgUnit as _ClosingTaskListOrgUnit      on  $projection.ClosingCommunicationProfile = _ClosingTaskListOrgUnit.ClosingCommunicationProfile
                                                                                 and $projection.ClosingFolderType           = _ClosingTaskListOrgUnit.ClosingFolderType
                                                                                 and $projection.OrganizationalUnit          = _ClosingTaskListOrgUnit.OrganizationalUnit
{
         @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: '_ClosingTaskListOrgUnit'
  key    value                                      as       OrganizationalUnit,

         @ObjectModel.foreignKey.association: '_ClosingFolderType'
         type                                       as       ClosingFolderType,
         @ObjectModel.foreignKey.association: '_ClosingCommunicationProfile'
         communication_profile                      as       ClosingCommunicationProfile,

         _ClosingTemplate,
         _ClosingTaskList,
         _FinTaskListContextType,
         _ClosingFolder,
         _ClosingFolderType,
         _ClosingCommunicationProfile,
         _ClosingTaskListOrgUnit
}

Depth:

I_ClosingFolderOrgUnit view

fcco_fol_org_ass