C_FinancialClosingRunDisplay

DDL: C_FINANCIALCLOSINGRUNDISPLAY Type: view_entity CONSUMPTION Package: ODATA_FI_CLS_ACT_LIST

Display Financial Closing Run

C_FinancialClosingRunDisplay is a Consumption CDS View that provides data about "Display Financial Closing Run" in SAP S/4HANA. It reads from 1 data source (R_FinancialClosingRun) and exposes 22 fields with key field FinancialClosingRunUUID. It has 3 associations to related views. It is exposed through 3 OData services (ASQL_F3753, FINANCIAL_CLOSING_RUN, UI_GENERALLEDGERCLOSINGRUN). Part of development package ODATA_FI_CLS_ACT_LIST.

Data Sources (1)

SourceAliasJoin Type
R_FinancialClosingRun R_FinancialClosingRun from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_FinClosingRunStartedByUser _FinClosingRunStartedByUser $projection.FinClosingRunStartedByUser = _FinClosingRunStartedByUser.FinClosingRunStartedByUser
[1..1] I_BusTransactionCategoryText _BusTransactionCategoryText $projection.BusinessTransactionCategory = _BusTransactionCategoryText.BusinessTransactionCategory and _BusTransactionCategoryText.Language = $session.system_language
[1..1] C_FinClsgRunGnrcConfiguration _FinClsgRunGnrcConfiguration $projection.FinancialClosingRunUUID = _FinClsgRunGnrcConfiguration.FinancialClosingRunUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Display Financial Closing Run view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #CONSUMPTION view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F3753 ASQL_F3753 C2 NOT_RELEASED
FINANCIAL_CLOSING_RUN
UI_GENERALLEDGERCLOSINGRUN UI_FINANCIALCLOSINGRUN_O4 V4 C1 NOT_RELEASED

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY FinancialClosingRunUUID FinancialClosingRunUUID
FinancialClosingRun FinancialClosingRun
FinClosingRunProcessingOption FinClosingRunProcessingOption
FinClosingRunExecutionStatus FinClosingRunExecutionStatus Execution Status
Ledger Ledger Ledger
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
BusinessTransactionCategory BusinessTransactionCategory Business Transaction Category
KeyDate KeyDate Maturity Key Date
FinClosingRunStartedByUser FinClosingRunStartedByUser
FinClsgRunBatchJobTemplate FinClsgRunBatchJobTemplate
ApplicationLogHandle ApplicationLogHandle Log Handle
_FinClosingRunExecutionStatus _FinClosingRunExecutionStatus
_FinClosingRunExecStatusText _FinClosingRunExecStatusText
_FinClsgRunProcessingOption _FinClsgRunProcessingOption
_FinClsgRunProcgOptionText _FinClsgRunProcgOptionText
_Ledger _Ledger
_CompanyCode _CompanyCode
_FinClsgRunBusTransCategory _FinClsgRunBusTransCategory
_BusTransactionCategoryText _BusTransactionCategoryText
_FinClosingRunStartedByUser _FinClosingRunStartedByUser
_FinClsgRunGnrcConfiguration _FinClsgRunGnrcConfiguration

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_FinancialClosingRunDisplay.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_FinancialClosingRunDisplay AS
SELECT
  FinancialClosingRunUUID,
  FinancialClosingRun,
  FinClosingRunProcessingOption,
  FinClosingRunExecutionStatus,
  Ledger,
  CompanyCode,
  CompanyCodeName,
  BusinessTransactionCategory,
  KeyDate,
  FinClosingRunStartedByUser,
  FinClsgRunBatchJobTemplate,
  ApplicationLogHandle
FROM R_FinancialClosingRun
LEFT OUTER JOIN C_FinClosingRunStartedByUser AS _FinClosingRunStartedByUser ON FinClosingRunStartedByUser = _FinClosingRunStartedByUser.FinClosingRunStartedByUser  -- association [1..1]
LEFT OUTER JOIN I_BusTransactionCategoryText AS _BusTransactionCategoryText ON BusinessTransactionCategory = _BusTransactionCategoryText.BusinessTransactionCategory AND _BusTransactionCategoryText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_FinClsgRunGnrcConfiguration AS _FinClsgRunGnrcConfiguration ON FinancialClosingRunUUID = _FinClsgRunGnrcConfiguration.FinancialClosingRunUUID  -- association [1..1]
;