I_KR_NoneDcblVATItemCube

DDL: I_KR_NONEDCBLVATITEMCUBE SQL: IKRNODEVATITMQRC Type: view COMPOSITE Package: GLO_FIN_NON_DEDUCTIBLE_VAT
38 Fields 1 Data Sources 3 Associations

KR Non Deductible VAT Item - Cube

I_KR_NoneDcblVATItemCube is a Composite CDS View (Cube) that provides data about "KR Non Deductible VAT Item - Cube" in SAP S/4HANA. It reads from 1 data source (I_KR_RptdNoneDcblVATItmDetail) and exposes 38 fields with key fields StatryRptRunID, StatryRptgEntity, StatryRptCategory, CompanyCode, AccountingDocument. It has 3 associations to related views. Part of development package GLO_FIN_NON_DEDUCTIBLE_VAT.

Data Sources (1)

SourceAliasJoin Type
I_KR_RptdNoneDcblVATItmDetail RptdNoneDcblVATItmDetail from

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_StRpTaxItem _taxitem _taxitem.CompanyCode = RptdNoneDcblVATItmDetail.CompanyCode and _taxitem.AccountingDocument = RptdNoneDcblVATItmDetail.AccountingDocument and _taxitem.FiscalYear = RptdNoneDcblVATItmDetail.FiscalYear and _taxitem.TaxItem = RptdNoneDcblVATItmDetail.TaxItem and _taxitem.TaxItemUUID = _taxitem.TaxItemUUID
[1..1] I_Customer _Customer _taxitem.Customer = _Customer.Customer
[1..1] I_Supplier _Supplier _taxitem.Supplier = _Supplier.Supplier

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IKRNODEVATITMQRC view
EndUserText.label KR Non Deductible VAT Item - Cube view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
AbapCatalog.preserveKey true view
Analytics.internalName #LOCAL view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY StatryRptRunID I_KR_RptdNoneDcblVATItmDetail StatryRptRunID Report Run ID
KEY StatryRptgEntity I_KR_RptdNoneDcblVATItmDetail StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_KR_RptdNoneDcblVATItmDetail StatryRptCategory Report ID
KEY CompanyCode I_KR_RptdNoneDcblVATItmDetail CompanyCode Receiver Company Code
KEY AccountingDocument I_KR_RptdNoneDcblVATItmDetail AccountingDocument Journal Entry
KEY FiscalYear I_KR_RptdNoneDcblVATItmDetail FiscalYear G/L Fiscal Year
KEY TaxItem I_KR_RptdNoneDcblVATItmDetail TaxItem Tax Item
KEY ReportingDate I_KR_RptdNoneDcblVATItmDetail ReportingDate Date
KEY DeclarationPeriodNumber I_KR_RptdNoneDcblVATItmDetail DeclarationPeriodNumber Reporting Times
KR_NoneDeductibleInputVATCat I_KR_RptdNoneDcblVATItmDetail KR_NoneDeductibleInputVATCat Non-Deductible Cat.
KR_NoneDeductibleInputVATSts I_KR_RptdNoneDcblVATItmDetail KR_NoneDeductibleInputVATSts Non-Deductible Sts
FinancialAccountType I_KR_RptdNoneDcblVATItmDetail FinancialAccountType Fin. Account Type
KR_TaxExemptRevenueInCCCrcy I_KR_RptdNoneDcblVATItmDetail KR_TaxExemptRevenueInCCCrcy Tax Exempt Revenue
TotalRevenueInCoCodeCrcy I_KR_RptdNoneDcblVATItmDetail TotalRevenueInCoCodeCrcy Total Revenue
IsCompleted I_KR_RptdNoneDcblVATItmDetail IsCompleted
CompanyCodeCurrency I_KR_RptdNoneDcblVATItmDetail Currency Valuation Crcy
CreatedByUser I_KR_RptdNoneDcblVATItmDetail CreatedByUser User Name
CaseCreatedOn I_KR_RptdNoneDcblVATItmDetail CaseCreatedOn Created At
ChangedByUserName I_KR_RptdNoneDcblVATItmDetail ChangedByUserName User Name
CaseLastChangedOn I_KR_RptdNoneDcblVATItmDetail CaseLastChangedOn Last Changed At
TaxAmountInCoCodeCrcy _taxitem TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy _taxitem TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxItemGroup _taxitem TaxItemGroup Tax doc. item number
TaxCode _taxitem TaxCode Tax Code
TaxType _taxitem TaxType Tax Type
BusinessPlace _taxitem BusinessPlace Business place
BusinessPartner
AccountingDocumentType _taxitem AccountingDocumentType Journal Entry Type
PostingDate _taxitem PostingDate Posting Date for GR
DocumentDate _taxitem DocumentDate Journal Entry Date
Customer _taxitem Customer Sold-to Party
Supplier _taxitem Supplier Supplier
CAReconciliationKey _taxitem CAReconciliationKey Reconcil. Key
ReferenceDocumentType _taxitem ReferenceDocumentType Reference Document Type
StatryRptRun
_taxitem _taxitem
_Customer _Customer
_Supplier _Supplier

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_KR_NoneDcblVATItemCube.
-- 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: IKRNODEVATITMQRC
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW I_KR_NoneDcblVATItemCube AS
SELECT
  RptdNoneDcblVATItmDetail.StatryRptRunID AS StatryRptRunID,
  RptdNoneDcblVATItmDetail.StatryRptgEntity AS StatryRptgEntity,
  RptdNoneDcblVATItmDetail.StatryRptCategory AS StatryRptCategory,
  RptdNoneDcblVATItmDetail.CompanyCode AS CompanyCode,
  RptdNoneDcblVATItmDetail.AccountingDocument AS AccountingDocument,
  RptdNoneDcblVATItmDetail.FiscalYear AS FiscalYear,
  RptdNoneDcblVATItmDetail.TaxItem AS TaxItem,
  RptdNoneDcblVATItmDetail.ReportingDate AS ReportingDate,
  RptdNoneDcblVATItmDetail.DeclarationPeriodNumber AS DeclarationPeriodNumber,
  RptdNoneDcblVATItmDetail.KR_NoneDeductibleInputVATCat AS KR_NoneDeductibleInputVATCat,
  RptdNoneDcblVATItmDetail.KR_NoneDeductibleInputVATSts AS KR_NoneDeductibleInputVATSts,
  RptdNoneDcblVATItmDetail.FinancialAccountType AS FinancialAccountType,
  RptdNoneDcblVATItmDetail.KR_TaxExemptRevenueInCCCrcy AS KR_TaxExemptRevenueInCCCrcy,
  RptdNoneDcblVATItmDetail.TotalRevenueInCoCodeCrcy AS TotalRevenueInCoCodeCrcy,
  RptdNoneDcblVATItmDetail.IsCompleted AS IsCompleted,
  RptdNoneDcblVATItmDetail.Currency AS CompanyCodeCurrency,
  RptdNoneDcblVATItmDetail.CreatedByUser AS CreatedByUser,
  RptdNoneDcblVATItmDetail.CaseCreatedOn AS CaseCreatedOn,
  RptdNoneDcblVATItmDetail.ChangedByUserName AS ChangedByUserName,
  RptdNoneDcblVATItmDetail.CaseLastChangedOn AS CaseLastChangedOn,
  _taxitem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  _taxitem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  _taxitem.TaxItemGroup AS TaxItemGroup,
  _taxitem.TaxCode AS TaxCode,
  _taxitem.TaxType AS TaxType,
  _taxitem.BusinessPlace AS BusinessPlace,
  cast ( _taxitem.BusinessPartner as bu_partner ) AS BusinessPartner,
  _taxitem.AccountingDocumentType AS AccountingDocumentType,
  _taxitem.PostingDate AS PostingDate,
  _taxitem.DocumentDate AS DocumentDate,
  _taxitem.Customer AS Customer,
  _taxitem.Supplier AS Supplier,
  _taxitem.CAReconciliationKey AS CAReconciliationKey,
  _taxitem.ReferenceDocumentType AS ReferenceDocumentType,
  cast(concat_with_space( concat_with_space( StatryRptgEntity,StatryRptCategory,1),StatryRptRunID,1 ) as srf_reportrun) AS StatryRptRun
FROM I_KR_RptdNoneDcblVATItmDetail AS RptdNoneDcblVATItmDetail
LEFT OUTER JOIN I_StRpTaxItem AS _taxitem ON _taxitem.CompanyCode = RptdNoneDcblVATItmDetail.CompanyCode AND _taxitem.AccountingDocument = RptdNoneDcblVATItmDetail.AccountingDocument AND _taxitem.FiscalYear = RptdNoneDcblVATItmDetail.FiscalYear AND _taxitem.TaxItem = RptdNoneDcblVATItmDetail.TaxItem AND _taxitem.TaxItemUUID = _taxitem.TaxItemUUID  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _taxitem.Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _taxitem.Supplier = _Supplier.Supplier  -- association [1..1]
;

Learn More