C_KR_InputVATItem

DDL: C_KR_INPUTVATITEM SQL: CKRNINVATITM Type: view CONSUMPTION Package: GLO_FIN_NON_DEDUCTIBLE_VAT
30 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Non Deductible Input VAT Item-KR

C_KR_InputVATItem is a Consumption CDS View that provides data about "Non Deductible Input VAT Item-KR" in SAP S/4HANA. It reads from 1 data source (I_KR_InputVATItem) and exposes 30 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem. It is exposed through 1 OData service (GLO_FIN_KR_NONDEDINPUTVAT). It is used in 1 Fiori application: Manage Non-Deductible Input VAT - South Korea. Part of development package GLO_FIN_NON_DEDUCTIBLE_VAT.

Data Sources (1)

SourceAliasJoin Type
I_KR_InputVATItem I_KR_InputVATItem from

Parameters (2)

NameTypeDefault
P_FromReportingDate idkr_rptdat_from
P_ToReportingDate idkr_rptdat_to

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CKRNINVATITM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true 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 Input VAT Item-KR view

OData Services (1)

ServiceBindingVersionContractRelease
GLO_FIN_KR_NONDEDINPUTVAT GLO_FIN_KR_NONDEDINPUTVAT V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5455 Manage Non-Deductible Input VAT - South Korea Transactional An application to maintain non-deductible input VAT

Manage Non-Deductible Input VAT - South Korea

Business Role: General Ledger Accountant for South Korea

You can use this app to get an overview of the input VAT items based on company code, reporting period, business place, and tax code. And then you identify and categorize the non-deductible input VAT. In this way, you prepare the declaration data to be used for generating the Non-Deductible Purchase Tax Amount Statement file in the Non-Deductible Input VAT Declaration report in advanced compliance reporting (ACR). This app is an embedded activity in the Non-Deductible Input VAT Declaration report.

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode taxitem CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY TaxItem TaxItem Line Item No.
TaxCode TaxCode Tax Code
TaxCodeName
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
AuthorizationGroup AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
BusinessPlace BusinessPlace Business Place
CompanyCodeName CompanyCodeName Company Name
IsChanged
JrnlEntryCntrySpecificRef1 JrnlEntryCntrySpecificRef1 Country/Region Specific Reference 1
InvoiceDate InvoiceDate Transfer Date
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName AccountingDocumentTypeName
StatryRptRunStatus StatryRptRunStatus
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
DocumentReferenceID DocumentReferenceID Reference
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
CaseLastChangedOn CaseLastChangedOn Last Changed At
_CompanyCode _CompanyCode
_CategoryText _CategoryText
_Comments _Comments
_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_InputVATItem.
-- 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: CKRNINVATITM
-- Parameters: P_FromReportingDate : idkr_rptdat_from, P_ToReportingDate : idkr_rptdat_to

CREATE VIEW C_KR_InputVATItem AS
SELECT
  taxitem.CompanyCode AS CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  TaxCode,
  _TaxCodeText[Language = $session.system_language].TaxCodeName AS TaxCodeName,
  Supplier,
  SupplierName,
  AuthorizationGroup,
  IsBusinessPurposeCompleted,
  BusinessPlace,
  CompanyCodeName,
  cast( '' as char1) AS IsChanged,
  JrnlEntryCntrySpecificRef1,
  InvoiceDate,
  DocumentDate,
  PostingDate,
  AccountingDocumentType,
  AccountingDocumentTypeName,
  StatryRptRunStatus,
  AccountingDocumentHeaderText,
  DocumentReferenceID,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInCoCodeCrcy,
  CompanyCodeCurrency,
  CaseLastChangedOn
FROM I_KR_InputVATItem
;

Learn More