I_SI_CntrlBkRptgRblsPyblsLog

DDL: I_SI_CNTRLBKRPTGRBLSPYBLSLOG Type: view_entity BASIC

SI Central Bank Reporting KRD Log

I_SI_CntrlBkRptgRblsPyblsLog is a Basic CDS View that provides data about "SI Central Bank Reporting KRD Log" in SAP S/4HANA. It reads from 1 data source (fiis_krd_log) and exposes 14 fields with key fields CompanyCode, Ledger, AccountingDocument, LedgerGLLineItem, FiscalYear.

Data Sources (1)

SourceAliasJoin Type
fiis_krd_log fiis_krd_log from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label SI Central Bank Reporting KRD Log view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode company_code Company Code
KEY Ledger ledger Ledger
KEY AccountingDocument accounting_document Journal Entry
KEY LedgerGLLineItem ledger_gl_lineitem Journal Entry Item
KEY FiscalYear fiscal_year Tax Item Fiscal Year
SI_FinancialSector sector Sector
SI_IntlInstitutionCode institution_code Inst. code
SI_CapitalRelationship cap_relationship Capital Relationship
SI_FinancialInstrumentType fin_instrument_type Fin. Instrument Type
SI_FinancialInstrumentMaturity maturity Maturity Date
IsDisabled isdisabled TRUE
SI_IncomeType income_type Income Type
LastChangedAtDateTime last_changed_at Timestamp
LocalLastChangedAtDateTime local_last_changed_at Time Stamp

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 I_SI_CntrlBkRptgRblsPyblsLog.
-- 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 I_SI_CntrlBkRptgRblsPyblsLog AS
SELECT
  company_code AS CompanyCode,
  Ledger,
  accounting_document AS AccountingDocument,
  ledger_gl_lineitem AS LedgerGLLineItem,
  fiscal_year AS FiscalYear,
  sector AS SI_FinancialSector,
  institution_code AS SI_IntlInstitutionCode,
  cap_relationship AS SI_CapitalRelationship,
  fin_instrument_type AS SI_FinancialInstrumentType,
  maturity AS SI_FinancialInstrumentMaturity,
  IsDisabled,
  income_type AS SI_IncomeType,
  last_changed_at AS LastChangedAtDateTime,
  local_last_changed_at AS LocalLastChangedAtDateTime
FROM fiis_krd_log
;