C_KR_StRpTrialBalanceItemQuery

DDL: C_KR_STRPTRIALBALANCEITEMQUERY SQL: CKRSRTRLBALITEMQ Type: view CONSUMPTION
39 Fields 1 Data Sources

South Korea Trial Balance Query

C_KR_StRpTrialBalanceItemQuery is a Consumption CDS View that provides data about "South Korea Trial Balance Query" in SAP S/4HANA. It reads from 1 data source (I_StRpTrialBalanceItemCube) and exposes 39 fields.

Data Sources (1)

SourceAliasJoin Type
I_StRpTrialBalanceItemCube I_StRpTrialBalanceItemCube from

Parameters (4)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to
P_FromFiscalPeriod fis_period_from
P_ToFiscalPeriod fis_period_to

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CKRSRTRLBALITEMQ view
VDM.viewType #CONSUMPTION view
Analytics.query true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label South Korea Trial Balance Query view

Fields (39)

KeyFieldSource TableSource FieldDescription
StatryRptCategory StatryRptCategory Report ID
StatryRptgEntity StatryRptgEntity Reporting Entity
StatryRptRunID StatryRptRunID Report Run ID
Ledger Ledger Ledger
CompanyCode CompanyCode Receiver Company Code
SourceLedger SourceLedger Source Ledger
ChartOfAccounts ChartOfAccounts Node Class
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocument AccountingDocument Journal Entry
LedgerGLLineItem LedgerGLLineItem Journal Entry Item
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
GLAccount GLAccount General Ledger
GLAccountLongName GLAccountLongName Long Text
BusinessArea BusinessArea Business Area
FinancialAccountType FinancialAccountType Fin. Account Type
SpecialGLCode SpecialGLCode Special G/L Ind
AccountingDocumentType AccountingDocumentType Journal Entry Type
PostingKey PostingKey Posting Key
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
DebitCreditCode DebitCreditCode Single-Character Flag
CompanyCodeCurrency CompanyCodeCurrency Local Currency
DebitCarryFwdBalAmtInCCCrcy DebitCarryFwdBalAmtInCCCrcy
CreditCarryFwdBalAmtInCCCrcy CreditCarryFwdBalAmtInCCCrcy
CarryFwdBalAmtInCCCrcy CarryFwdBalAmtInCCCrcy
DebitPrevPeriodYTDAmtInCCCrcy DebitPrevPeriodYTDAmtInCCCrcy
CreditPrevPeriodYTDAmtInCCCrcy CreditPrevPeriodYTDAmtInCCCrcy
PrevPeriodYTDAmtInCCCrcy PrevPeriodYTDAmtInCCCrcy
StartingBalanceAmtInCoCodeCrcy StartingBalanceAmtInCoCodeCrcy
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
YTDAmtInLoclCrcy YTDAmtInLoclCrcy
YTDDebitAmtInCoCodeCrcy YTDDebitAmtInCoCodeCrcy
YTDCrdtAmtInCoCodeCrcy YTDCrdtAmtInCoCodeCrcy
DebitEndingBalAmtInCCCrcy DebitEndingBalAmtInCCCrcy
CreditEndingBalAmtInCCCrcy CreditEndingBalAmtInCCCrcy
EndingBalanceAmtInCoCodeCrcy EndingBalanceAmtInCoCodeCrcy

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_KR_StRpTrialBalanceItemQuery.
-- 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: CKRSRTRLBALITEMQ
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to

CREATE VIEW C_KR_StRpTrialBalanceItemQuery AS
SELECT
  StatryRptCategory,
  StatryRptgEntity,
  StatryRptRunID,
  Ledger,
  CompanyCode,
  SourceLedger,
  ChartOfAccounts,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  PostingDate,
  DocumentDate,
  GLAccount,
  GLAccountLongName,
  BusinessArea,
  FinancialAccountType,
  SpecialGLCode,
  AccountingDocumentType,
  PostingKey,
  AccountingDocumentCategory,
  AccountingDocCreatedByUser,
  DebitCreditCode,
  CompanyCodeCurrency,
  DebitCarryFwdBalAmtInCCCrcy,
  CreditCarryFwdBalAmtInCCCrcy,
  CarryFwdBalAmtInCCCrcy,
  DebitPrevPeriodYTDAmtInCCCrcy,
  CreditPrevPeriodYTDAmtInCCCrcy,
  PrevPeriodYTDAmtInCCCrcy,
  StartingBalanceAmtInCoCodeCrcy,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  AmountInCompanyCodeCurrency,
  YTDAmtInLoclCrcy,
  YTDDebitAmtInCoCodeCrcy,
  YTDCrdtAmtInCoCodeCrcy,
  DebitEndingBalAmtInCCCrcy,
  CreditEndingBalAmtInCCCrcy,
  EndingBalanceAmtInCoCodeCrcy
FROM I_StRpTrialBalanceItemCube
;

Learn More