C_KR_OutputVATItem

DDL: C_KR_OUTPUTVATITEM SQL: CKRNOUTVATITM Type: view CONSUMPTION
32 Fields 1 Data Sources

Non Deductible Output VAT Item-KR

C_KR_OutputVATItem is a Consumption CDS View that provides data about "Non Deductible Output VAT Item-KR" in SAP S/4HANA. It reads from 1 data source (I_KR_OutputVATItem) and exposes 32 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem.

Data Sources (1)

SourceAliasJoin Type
I_KR_OutputVATItem taxitem from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CKRNOUTVATITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Non Deductible Output VAT Item-KR view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_KR_OutputVATItem CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY TaxItem TaxItem Line Item No.
Customer Customer Sold-to Party
Supplier Supplier Supplier
BusinessPlace BusinessPlace Business Place
CustomerName CustomerName Name of Customer
TaxCode TaxCode Tax Code
TaxCodeName TaxCodeName Tax Code Name
KR_TaxInvoiceTypeText KR_TaxInvoiceTypeText
TaxRate TaxRate Tax Rate
TaxRateValidityStartDate TaxRateValidityStartDate Valid-From Date of the Tax Rate
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
CompanyCodeName CompanyCodeName Company Name
CompanyCodeCurrency CompanyCodeCurrency Local Currency
JrnlEntryCntrySpecificRef1 JrnlEntryCntrySpecificRef1 Approval Number
InvoiceDate InvoiceDate Run On
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
KR_InputVATFiscalYear KR_InputVATFiscalYear
KR_InputVATCompanyCode KR_InputVATCompanyCode
KR_InputVATAccountingDocument KR_InputVATAccountingDocument
KR_InputVATItem KR_InputVATItem
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName AccountingDocumentTypeName
StatryRptRunStatus StatryRptRunStatus
ClaimIsSelected ClaimIsSelected
_CompanyCode _CompanyCode
_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 C_KR_OutputVATItem.
-- 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: CKRNOUTVATITM

CREATE VIEW C_KR_OutputVATItem AS
SELECT
  taxitem.CompanyCode AS CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  Customer,
  Supplier,
  BusinessPlace,
  CustomerName,
  TaxCode,
  TaxCodeName,
  KR_TaxInvoiceTypeText,
  TaxRate,
  TaxRateValidityStartDate,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  CompanyCodeName,
  CompanyCodeCurrency,
  JrnlEntryCntrySpecificRef1,
  InvoiceDate,
  DocumentDate,
  PostingDate,
  KR_InputVATFiscalYear,
  KR_InputVATCompanyCode,
  KR_InputVATAccountingDocument,
  KR_InputVATItem,
  AccountingDocumentType,
  AccountingDocumentTypeName,
  StatryRptRunStatus,
  ClaimIsSelected
FROM I_KR_OutputVATItem AS taxitem
;

Learn More