I_JP_VATReturnSummaryRuleDef

DDL: I_JP_VATRETURNSUMMARYRULEDEF SQL: IJPVATRULEDEF Type: view BASIC
11 Fields 1 Data Sources

Japan VAT RETURN Summary Rule Define

I_JP_VATReturnSummaryRuleDef is a Basic CDS View that provides data about "Japan VAT RETURN Summary Rule Define" in SAP S/4HANA. It reads from 1 data source (I_JP_VATReturnSummaryRule) and exposes 11 fields with key fields JP_VATReturnRule, JP_VATReturnRuleName, CompanyCode, TaxCode, AccountingDocumentType.

Data Sources (1)

SourceAliasJoin Type
I_JP_VATReturnSummaryRule Rule from

Annotations (10)

NameValueLevelField
EndUserText.label Japan VAT RETURN Summary Rule Define view
AbapCatalog.sqlViewName IJPVATRULEDEF view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private false view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY JP_VATReturnRule I_JP_VATReturnSummaryRule JP_VATReturnRule Tick.nr.rule
KEY JP_VATReturnRuleName I_JP_VATReturnSummaryRule JP_VATReturnRuleName Set Description
KEY CompanyCode RuleCfg bukrs Value
KEY TaxCode RuleCfg mwskz Tax Code
KEY AccountingDocumentType RuleCfg blart Rep. rec. doc. type
KEY CostCenter RuleCfg kostl Substitute CC
KEY BusinessArea RuleCfg gsber Business Area
KEY GLAccountInPurchaseOrg RuleCfg realglaccount
KEY GLAccount RuleCfg hkont Transfer acct
TaxRate I_JP_VATReturnSummaryRule TaxRate Tax Rate
JP_VATReturnRuleTaxRateDesc I_JP_VATReturnSummaryRule JP_VATReturnRuleTaxRateDesc

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_JP_VATReturnSummaryRuleDef.
-- 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: IJPVATRULEDEF

CREATE VIEW I_JP_VATReturnSummaryRuleDef AS
SELECT
  Rule.JP_VATReturnRule AS JP_VATReturnRule,
  Rule.JP_VATReturnRuleName AS JP_VATReturnRuleName,
  RuleCfg.bukrs AS CompanyCode,
  RuleCfg.mwskz AS TaxCode,
  RuleCfg.blart AS AccountingDocumentType,
  RuleCfg.kostl AS CostCenter,
  RuleCfg.gsber AS BusinessArea,
  RuleCfg.realglaccount AS GLAccountInPurchaseOrg,
  RuleCfg.hkont AS GLAccount,
  Rule.TaxRate AS TaxRate,
  Rule.JP_VATReturnRuleTaxRateDesc AS JP_VATReturnRuleTaxRateDesc
FROM I_JP_VATReturnSummaryRule AS Rule
;

Learn More