C_KZ_FinancialStatementItemQ

DDL: C_KZ_FINANCIALSTATEMENTITEMQ SQL: CKZFINSTMNTITEMQ Type: view CONSUMPTION
45 Fields

Financial Statement Item - Query

C_KZ_FinancialStatementItemQ is a Consumption CDS View that provides data about "Financial Statement Item - Query" in SAP S/4HANA.

Parameters (8)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_FiscalYear srf_report_year
P_FinancialStatementHierarchy hryid
P_AlternativeGLAccountIsUsed figlkz_alt_account
P_Language sylangu
P_Ledger fins_ledger

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CKZFINSTMNTITEMQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Financial Statement Item - Query view
VDM.viewType #CONSUMPTION view
Analytics.query true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY ParentNode Parent Node
KEY GLAccount GLAccount General Ledger
FinancialStatementLeafItem FinancialStatementLeafItem Financial Statement Item
AlternativeGLAccount AlternativeGLAccount Group Account
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
HierarchyNode Node
AccountingDocument Journal Entry
Currency Currency Valuation Crcy
FiscalYear FiscalYear G/L Fiscal Year
YearlyBalAmtInDspCrcy
StartingBalAmtInDspCrcy
DebitAmountInDisplayCrcy
CreditAmountInDisplayCrcy
PeriodBalAmtInDspCrcy
EndingBalAmtInDspCrcy
HierarchyNodeText HierarchyNodeText
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingArea ControllingAreaName Long Text
Segment Segment Segment number
SegmentName
ProfitCenter ProfitCenter Profit Center
ProfitCenterName
CostCenter CostCenter Cost Center
BusinessArea BusinessArea Business Area
BusinessAreaName
FunctionalArea FunctionalArea Sendr Fctl Area
FunctionalAreaName
Supplier Supplier Supplier
SupplierFullName _Supplier SupplierFullName
Customer Customer Sold-to Party
CustomerFullName _Customer CustomerFullName Customer Name
Material Material Vehicle Model
MaterialName
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName
FiscalPeriod FiscalPeriod Tax period
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
AssetClass AssetClass Asset Class
AssignmentReference AssignmentReference Assignment Reference
InventoryValuationType InventoryValuationType Valuation Type
ValuationArea ValuationArea Valuation Area
Product Product Product Sold
ProductName

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_KZ_FinancialStatementItemQ.
-- 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: CKZFINSTMNTITEMQ
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_FiscalYear : srf_report_year, P_FinancialStatementHierarchy : hryid, P_AlternativeGLAccountIsUsed : figlkz_alt_account, P_Language : sylangu, P_Ledger : fins_ledger

CREATE VIEW C_KZ_FinancialStatementItemQ AS
SELECT
  cast( ParentNode as firu_item_code) AS ParentNode,
  GLAccount,
  FinancialStatementLeafItem,
  AlternativeGLAccount,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast(HierarchyNode as firu_finst_tech_item ) AS HierarchyNode,
  cast(AccountingDocument as farp_belnr_d) AS AccountingDocument,
  Currency,
  FiscalYear,
  cast(YearlyBalAmtInDspCrcy as firu_year_open_bal_amt) AS YearlyBalAmtInDspCrcy,
  cast(StartingBalAmtInDspCrcy as firu_open_bal_amt) AS StartingBalAmtInDspCrcy,
  cast(DebitAmountInDisplayCrcy as firu_debit_period_bal) AS DebitAmountInDisplayCrcy,
  cast(CreditAmountInDisplayCrcy as firu_credit_period_bal) AS CreditAmountInDisplayCrcy,
  cast(PeriodBalAmtInDspCrcy as firu_period_bal_amt) AS PeriodBalAmtInDspCrcy,
  cast(EndingBalAmtInDspCrcy as firu_closing_period_bal) AS EndingBalAmtInDspCrcy,
  HierarchyNodeText,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  Segment,
  _Segment._Text[1: Language = $session.system_language].SegmentName AS SegmentName,
  ProfitCenter,
  _ProfitCenter[1:ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date]._Text[1: Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  CostCenter,
  BusinessArea,
  _BusinessArea._Text[1: Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  FunctionalArea,
  _FunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  Supplier,
  _Supplier.SupplierFullName AS SupplierFullName,
  Customer,
  _Customer.CustomerFullName AS CustomerFullName,
  Material,
  _Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  AccountingDocumentType,
  _AccountingDocumentType._Text[1: Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  FiscalPeriod,
  MasterFixedAsset,
  FixedAsset,
  AssetClass,
  AssignmentReference,
  InventoryValuationType,
  ValuationArea,
  Product,
  _Product._Text[1: Language = $session.system_language].ProductName AS ProductName
;

Learn More