P_JP_VATReturnSummaryRuleDef

DDL: P_JP_VATRETURNSUMMARYRULEDEF SQL: PJPVATRULEDEF Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_JP
18 Fields 1 Data Sources

Japan VAT RETURN Summary Rule Define

P_JP_VATReturnSummaryRuleDef is a Consumption CDS View that provides data about "Japan VAT RETURN Summary Rule Define" in SAP S/4HANA. It reads from 1 data source (I_JP_VATReturnSummaryRuleDef) and exposes 18 fields with key fields JP_VATReturnRule, JP_VATReturnRuleName, CompanyCode, TaxCode, AccountingDocumentType. Part of development package GLO_FIN_IS_VAT_JP.

Data Sources (1)

SourceAliasJoin Type
I_JP_VATReturnSummaryRuleDef Rule from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PJPVATRULEDEF view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY JP_VATReturnRule I_JP_VATReturnSummaryRuleDef JP_VATReturnRule
KEY JP_VATReturnRuleName I_JP_VATReturnSummaryRuleDef JP_VATReturnRuleName
KEY CompanyCode I_JP_VATReturnSummaryRuleDef CompanyCode Receiver Company Code
KEY TaxCode I_JP_VATReturnSummaryRuleDef TaxCode Tax Code
KEY AccountingDocumentType I_JP_VATReturnSummaryRuleDef AccountingDocumentType Journal Entry Type
KEY CostCenter I_JP_VATReturnSummaryRuleDef CostCenter Cost Center
KEY BusinessArea I_JP_VATReturnSummaryRuleDef BusinessArea Business Area
KEY GLAccountInPurchaseOrg I_JP_VATReturnSummaryRuleDef GLAccountInPurchaseOrg
KEY GLAccount I_JP_VATReturnSummaryRuleDef GLAccount General Ledger
TaxRate I_JP_VATReturnSummaryRuleDef TaxRate Tax Rate
JP_VATReturnRuleTaxRateDesc I_JP_VATReturnSummaryRuleDef JP_VATReturnRuleTaxRateDesc
IsCompanyCodeNull
IsTaxCodeNull
IsCostCenterNull
IsDocumentTypeNull
IsBusinessAreaNull
IsGLInPurchaseNull
IsGLAccountNull

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 P_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: PJPVATRULEDEF

CREATE VIEW P_JP_VATReturnSummaryRuleDef AS
SELECT
  Rule.JP_VATReturnRule AS JP_VATReturnRule,
  Rule.JP_VATReturnRuleName AS JP_VATReturnRuleName,
  Rule.CompanyCode AS CompanyCode,
  Rule.TaxCode AS TaxCode,
  Rule.AccountingDocumentType AS AccountingDocumentType,
  Rule.CostCenter AS CostCenter,
  Rule.BusinessArea AS BusinessArea,
  Rule.GLAccountInPurchaseOrg AS GLAccountInPurchaseOrg,
  Rule.GLAccount AS GLAccount,
  Rule.TaxRate AS TaxRate,
  Rule.JP_VATReturnRuleTaxRateDesc AS JP_VATReturnRuleTaxRateDesc,
  case when Rule.CompanyCode <> '' then 1 else 0 end AS IsCompanyCodeNull,
  case when Rule.TaxCode <> '' then 1 else 0 end AS IsTaxCodeNull,
  case when Rule.CostCenter <> '' then 1 else 0 end AS IsCostCenterNull,
  case when Rule.AccountingDocumentType <> '' then 1 else 0 end AS IsDocumentTypeNull,
  case when Rule.BusinessArea <> '' then 1 else 0 end AS IsBusinessAreaNull,
  case when Rule.GLAccountInPurchaseOrg <> '' then 1 else 0 end AS IsGLInPurchaseNull,
  case when Rule.GLAccount <> '' then 1 else 0 end AS IsGLAccountNull
FROM I_JP_VATReturnSummaryRuleDef AS Rule
;

Learn More