I_KR_CustVAT

DDL: I_KR_CUSTVAT SQL: IKRCUSTVAT Type: view BASIC Package: GLO_FIN_KR
18 Fields 1 Data Sources

VAT registration by time

I_KR_CustVAT (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Country or Region-Specific Functions for Finance

I_KR_CustVAT is a Basic CDS View that provides data about "VAT registration by time" in SAP S/4HANA. It reads from 1 data source (idkr_custvat) and exposes 18 fields with key fields Customer, TaxInvcNmbrValidityStartDate. Part of development package GLO_FIN_KR.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCountry or Region-Specific Functions for Finance
Application ComponentFI-LOC-FI-KR
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities,Enabled for UI Consumption
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageCountry/Region-Specific Functions for Finance for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business question:</p> <ul> <li> <p>What is the tax registration information of a South Korean customer by a certain time range?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
idkr_custvat idkr_custvat from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IKRCUSTVAT view
AbapCatalog.compiler.compareFilter true view
EndUserText.label VAT registration by time view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
Metadata.ignorePropagatedAnnotations true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Customer kunnr Customer Number
KEY TaxInvcNmbrValidityStartDate datab Validity period
TaxNumber1 stcd1 Tax Number 1
TaxNumber2 stcd2 Tax Number 2
BusinessType gestyp Type of Business
IndustryType indtyp Type of Industry
TaxInvoiceRepresentativeName repres Name of Representative
CustomerBusinessPlace business_place Business Place in VAT for South Korean Customers
ResponsibleDepartmentName1 department_name Responsible Department Name for Electronic Tax Invoice
ResponsibleDepartmentName2 rdepname2 Department of Person Responsible 2
ResponsiblePersonName1 person_name Name of Person Responsible
ResponsiblePersonName2 rpername2 Name of Person Responsible 2
ResponsiblePersonEmailAddress1 person_email1 Email Address of Person Responsible
ResponsiblePersonEmailAddress2 person_email2 Email Address of Person Responsible 2
ResponsiblePersonPhoneNumber1 person_phone1 Telephone Number of Person Responsible
ResponsiblePersonPhoneNumber2 person_phone2 Telephone Number of Person Responsible 2
CustomerIsSelfBilling selfbilling Self-Billing Customer
CustomerIsMonthlyTaxInvcCust monthtax Monthly Tax Invoice Customer

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_CustVAT.
-- 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: IKRCUSTVAT

CREATE VIEW I_KR_CustVAT AS
SELECT
  kunnr AS Customer,
  datab AS TaxInvcNmbrValidityStartDate,
  stcd1 AS TaxNumber1,
  stcd2 AS TaxNumber2,
  gestyp AS BusinessType,
  indtyp AS IndustryType,
  repres AS TaxInvoiceRepresentativeName,
  business_place AS CustomerBusinessPlace,
  department_name AS ResponsibleDepartmentName1,
  rdepname2 AS ResponsibleDepartmentName2,
  person_name AS ResponsiblePersonName1,
  rpername2 AS ResponsiblePersonName2,
  person_email1 AS ResponsiblePersonEmailAddress1,
  person_email2 AS ResponsiblePersonEmailAddress2,
  person_phone1 AS ResponsiblePersonPhoneNumber1,
  person_phone2 AS ResponsiblePersonPhoneNumber2,
  selfbilling AS CustomerIsSelfBilling,
  monthtax AS CustomerIsMonthlyTaxInvcCust
FROM idkr_custvat
;

Learn More