C_FinClosingRunValuatedAccount

DDL: C_FINCLOSINGRUNVALUATEDACCOUNT Type: view_entity CONSUMPTION
9 Fields 1 Data Sources 5 Associations

Vltd Accts for Financial Closing Runs

C_FinClosingRunValuatedAccount is a Consumption CDS View that provides data about "Vltd Accts for Financial Closing Runs" in SAP S/4HANA. It reads from 1 data source (R_FinClosingRunValuatedAccount) and exposes 9 fields with key fields FinancialClosingRunUUID, FinClosingValuationRuleStep, SemanticTag, GLAccount. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_FinClosingRunValuatedAccount R_FinClosingRunValuatedAccount from

Associations (5)

CardinalityTargetAliasCondition
[1..*] R_FrgnCrcyValnRunRsltListItm _FinClosingRunResultListItem $projection.FinancialClosingRunUUID = _FinClosingRunResultListItem.JrnlPerdEndClsgRunResultUUID
[1..*] R_FrgnCrcyValnRunValnRuleStep _FrgnCrcyValnRunValnRuleStep $projection.FinClosingValuationRuleStep = _FrgnCrcyValnRunValnRuleStep.FinClosingValuationRuleStep
[1..*] R_FrgnCrcyValnRunValnRuleStepT _FrgnCrcyValnRunValnRuleStepT $projection.FinClosingValuationRuleStep = _FrgnCrcyValnRunValnRuleStepT.FinClosingValuationRuleStep
[1..*] I_GLAccountText _GLAccountText $projection.GLAccount = _GLAccountText.GLAccount
[1..*] I_SemanticTagText _SemanticTagText $projection.SemanticTag = _SemanticTagText.SemanticTag

Annotations (8)

NameValueLevelField
EndUserText.label Vltd Accts for Financial Closing Runs view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY FinancialClosingRunUUID FinancialClosingRunUUID Closing Run UUID
KEY FinClosingValuationRuleStep FinClosingValuationRuleStep Rule Step
KEY SemanticTag SemanticTag Semantic Tag
KEY GLAccount GLAccount General Ledger
_FinClosingRunResultListItem _FinClosingRunResultListItem
_FrgnCrcyValnRunValnRuleStep _FrgnCrcyValnRunValnRuleStep
_SemanticTagText _SemanticTagText
_GLAccountText _GLAccountText
_FrgnCrcyValnRunValnRuleStepT _FrgnCrcyValnRunValnRuleStepT

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_FinClosingRunValuatedAccount.
-- 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_FinClosingRunValuatedAccount AS
SELECT
  FinancialClosingRunUUID,
  FinClosingValuationRuleStep,
  SemanticTag,
  GLAccount
FROM R_FinClosingRunValuatedAccount
LEFT OUTER JOIN R_FrgnCrcyValnRunRsltListItm AS _FinClosingRunResultListItem ON FinancialClosingRunUUID = _FinClosingRunResultListItem.JrnlPerdEndClsgRunResultUUID  -- association [1..*]
LEFT OUTER JOIN R_FrgnCrcyValnRunValnRuleStep AS _FrgnCrcyValnRunValnRuleStep ON FinClosingValuationRuleStep = _FrgnCrcyValnRunValnRuleStep.FinClosingValuationRuleStep  -- association [1..*]
LEFT OUTER JOIN R_FrgnCrcyValnRunValnRuleStepT AS _FrgnCrcyValnRunValnRuleStepT ON FinClosingValuationRuleStep = _FrgnCrcyValnRunValnRuleStepT.FinClosingValuationRuleStep  -- association [1..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount  -- association [1..*]
LEFT OUTER JOIN I_SemanticTagText AS _SemanticTagText ON SemanticTag = _SemanticTagText.SemanticTag  -- association [1..*]
;

Learn More