C_JP_VATReturnDetailQuery

DDL: C_JP_VATRETURNDETAILQUERY SQL: CJPVATREQURY Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_JP
40 Fields 1 Data Sources

Japan VAT Return Detail Query

C_JP_VATReturnDetailQuery is a Consumption CDS View that provides data about "Japan VAT Return Detail Query" in SAP S/4HANA. It reads from 1 data source (C_JP_VATReturnDetailCube) and exposes 40 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. Part of development package GLO_FIN_IS_VAT_JP.

Data Sources (1)

SourceAliasJoin Type
C_JP_VATReturnDetailCube C_JP_VATReturnDetailCube from

Parameters (7)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_TaxReportingFromDate jpvat_fromvatdate
P_TaxReportingToDate jpvat_tovatdate
P_CompanyCode bukrs
P_Ledger fins_ledger

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CJPVATREQURY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.query true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Japan VAT Return Detail Query view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode AcctDocItm CompanyCode Receiver Company Code
KEY FiscalYear AcctDocItm FiscalYear G/L Fiscal Year
KEY AccountingDocument AcctDocItm AccountingDocument Journal Entry
KEY AccountingDocumentItem AcctDocItm AccountingDocumentItem Posting View Item
JP_VATReturnRules AcctDocItm JP_VATReturnRules
TaxReportingDate AcctDocItm TaxReportingDate Tax Reporting Date
TaxCode AcctDocItm TaxCode Tax Code
AccountingDocumentItemType AcctDocItm AccountingDocumentItemType Line Item ID
TaxItemGroup AcctDocItm TaxItemGroup Tax doc. item number
PostingKey AcctDocItm PostingKey Posting Key
DebitCreditCode AcctDocItm DebitCreditCode Single-Character Flag
GLAccount AcctDocItm GLAccount General Ledger
FinancialAccountType AcctDocItm FinancialAccountType Fin. Account Type
AmountInCompanyCodeCurrency AcctDocItm AmountInCompanyCodeCurrency Local Crcy Amt
ActualAmountInCompanyCodeCrcy AcctDocItm ActualAmountInCompanyCodeCrcy Initial Amount in Company Code Currency
AmountInTransactionCurrency AcctDocItm AmountInTransactionCurrency Pt Crcy Amt
BalanceTransactionCurrency AcctDocItm BalanceTransactionCurrency Currency
DistributedTaxAmountInCCrcy AcctDocItm DistributedTaxAmountInCCrcy
JP_DcblNatlPrtAmtInCoCodeCrcy AcctDocItm JP_DcblNatlPrtAmtInCoCodeCrcy
TransactionTypeDetermination AcctDocItm TransactionTypeDetermination Transaction Key
DocumentItemText AcctDocItm DocumentItemText Text
CostCenter AcctDocItm CostCenter Cost Center
FiscalPeriod AcctDocItm FiscalPeriod Tax period
PostingDate AcctDocItm PostingDate Posting Date for GR
DocumentDate AcctDocItm DocumentDate Journal Entry Date
TransactionCurrency AcctDocItm TransactionCurrency Transaction Currency
AccountingDocumentType AcctDocItm AccountingDocumentType Journal Entry Type
CompanyCodeCurrency AcctDocItm CompanyCodeCurrency Local Currency
PurchasingDocumentItem AcctDocItm PurchasingDocumentItem Purchasing Doc. Item
PurchasingDocument AcctDocItm PurchasingDocument Purchasing Document
Material AcctDocItm Material Vehicle Model
Quantity AcctDocItm Quantity Value
BaseUnit AcctDocItm BaseUnit Unit of Measure
OriginalReferenceDocument AcctDocItm OriginalReferenceDocument Reference Key
GLAccountInPurchaseOrg AcctDocItm GLAccountInPurchaseOrg
BusinessArea AcctDocItm BusinessArea Business Area
SystemMessageIdentification AcctDocItm SystemMessageIdentification Message ID
ReferenceDocumentType AcctDocItm ReferenceDocumentType Reference Document Type
CAReconciliationKey AcctDocItm CAReconciliationKey Reconcil. Key
StatryRptRun AcctDocItm StatryRptRun

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_JP_VATReturnDetailQuery.
-- 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: CJPVATREQURY
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_TaxReportingFromDate : jpvat_fromvatdate, P_TaxReportingToDate : jpvat_tovatdate, P_CompanyCode : bukrs, P_Ledger : fins_ledger

CREATE VIEW C_JP_VATReturnDetailQuery AS
SELECT
  AcctDocItm.CompanyCode AS CompanyCode,
  AcctDocItm.FiscalYear AS FiscalYear,
  AcctDocItm.AccountingDocument AS AccountingDocument,
  AcctDocItm.AccountingDocumentItem AS AccountingDocumentItem,
  AcctDocItm.JP_VATReturnRules AS JP_VATReturnRules,
  AcctDocItm.TaxReportingDate AS TaxReportingDate,
  AcctDocItm.TaxCode AS TaxCode,
  AcctDocItm.AccountingDocumentItemType AS AccountingDocumentItemType,
  AcctDocItm.TaxItemGroup AS TaxItemGroup,
  AcctDocItm.PostingKey AS PostingKey,
  AcctDocItm.DebitCreditCode AS DebitCreditCode,
  AcctDocItm.GLAccount AS GLAccount,
  AcctDocItm.FinancialAccountType AS FinancialAccountType,
  AcctDocItm.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  AcctDocItm.ActualAmountInCompanyCodeCrcy AS ActualAmountInCompanyCodeCrcy,
  AcctDocItm.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  AcctDocItm.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  AcctDocItm.DistributedTaxAmountInCCrcy AS DistributedTaxAmountInCCrcy,
  AcctDocItm.JP_DcblNatlPrtAmtInCoCodeCrcy AS JP_DcblNatlPrtAmtInCoCodeCrcy,
  AcctDocItm.TransactionTypeDetermination AS TransactionTypeDetermination,
  AcctDocItm.DocumentItemText AS DocumentItemText,
  AcctDocItm.CostCenter AS CostCenter,
  AcctDocItm.FiscalPeriod AS FiscalPeriod,
  AcctDocItm.PostingDate AS PostingDate,
  AcctDocItm.DocumentDate AS DocumentDate,
  AcctDocItm.TransactionCurrency AS TransactionCurrency,
  AcctDocItm.AccountingDocumentType AS AccountingDocumentType,
  AcctDocItm.CompanyCodeCurrency AS CompanyCodeCurrency,
  AcctDocItm.PurchasingDocumentItem AS PurchasingDocumentItem,
  AcctDocItm.PurchasingDocument AS PurchasingDocument,
  AcctDocItm.Material AS Material,
  AcctDocItm.Quantity AS Quantity,
  AcctDocItm.BaseUnit AS BaseUnit,
  AcctDocItm.OriginalReferenceDocument AS OriginalReferenceDocument,
  AcctDocItm.GLAccountInPurchaseOrg AS GLAccountInPurchaseOrg,
  AcctDocItm.BusinessArea AS BusinessArea,
  AcctDocItm.SystemMessageIdentification AS SystemMessageIdentification,
  AcctDocItm.ReferenceDocumentType AS ReferenceDocumentType,
  AcctDocItm.CAReconciliationKey AS CAReconciliationKey,
  AcctDocItm.StatryRptRun AS StatryRptRun
FROM C_JP_VATReturnDetailCube
;

Learn More