FAC_DART_Z3_FSV_Header

DDL: FAC_DART_Z3_FSV_HEADER SQL: FAC_DZFSVH Type: view Package: FINS_FI_DART_Z3
16 Fields 2 Data Sources

Financial Statement Version Header

FAC_DART_Z3_FSV_Header is a CDS View that provides data about "Financial Statement Version Header" in SAP S/4HANA. It reads from 2 data sources (hrrp_dir_n, hrrp_dirt_n) and exposes 16 fields with key fields FinancialStatementHierarchy, ValidityEndDate, ValidityStartDate. Part of development package FINS_FI_DART_Z3.

Data Sources (2)

SourceAliasJoin Type
hrrp_dir_n hrrp_dir_n from
hrrp_dirt_n hrrp_dirt_n left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZFSVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Financial Statement Version Header view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementHierarchy hrrp_dir_n hryid_42 Hierarchy ID
KEY ValidityEndDate hrrp_dir_n hryvalto Valid To
KEY ValidityStartDate hrrp_dir_n hryvalfrom Valid From
HierarchyType hrrp_dir_n hrytyp Hierarchy Type
LastChangedByUser hrrp_dir_n upduser Changed By
LastChangeTime hrrp_dir_n updtime Updated At
HierarchyText hrrp_dirt_n hrytxt Description
ChartOfAccounts hrrp_dir_n ktopl Chart Of Accounts on Header
AssetKey hrrp_dir_n aktva Assets
LiabilityKey hrrp_dir_n pssva Liabilities
NetLossKey hrrp_dir_n ergak Net Loss
NetProfitKey hrrp_dir_n ergpa Net Profit/Year
PLResultKey hrrp_dir_n erggv P+L Profit
NotAssignKey hrrp_dir_n zuord Not Assignable
FSNotesKey hrrp_dir_n anhng Fin.Stmt Notes
Source hrrp_dir_n hrysource Source

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 FAC_DART_Z3_FSV_Header.
-- 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.
-- SQL view name: FAC_DZFSVH

CREATE VIEW FAC_DART_Z3_FSV_Header AS
SELECT
  hrrp_dir_n.hryid_42 AS FinancialStatementHierarchy,
  hrrp_dir_n.hryvalto AS ValidityEndDate,
  hrrp_dir_n.hryvalfrom AS ValidityStartDate,
  hrrp_dir_n.hrytyp AS HierarchyType,
  hrrp_dir_n.upduser AS LastChangedByUser,
  hrrp_dir_n.updtime AS LastChangeTime,
  hrrp_dirt_n.hrytxt AS HierarchyText,
  hrrp_dir_n.ktopl AS ChartOfAccounts,
  hrrp_dir_n.aktva AS AssetKey,
  hrrp_dir_n.pssva AS LiabilityKey,
  hrrp_dir_n.ergak AS NetLossKey,
  hrrp_dir_n.ergpa AS NetProfitKey,
  hrrp_dir_n.erggv AS PLResultKey,
  hrrp_dir_n.zuord AS NotAssignKey,
  hrrp_dir_n.anhng AS FSNotesKey,
  hrrp_dir_n.hrysource AS Source
FROM hrrp_dir_n
LEFT OUTER JOIN hrrp_dirt_n ON /* join condition not captured in parsed metadata */
;

Learn More