C_JP_VATReturnDetailCube

DDL: C_JP_VATRETURNDETAILCUBE SQL: CJPVATRECUBE Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_JP
42 Fields 2 Data Sources 4 Associations

Japan VAT Return Detail Cube

C_JP_VATReturnDetailCube is a Consumption CDS View (Cube) that provides data about "Japan VAT Return Detail Cube" in SAP S/4HANA. It reads from 2 data sources (C_StRpRptdJournalEntry, P_JP_VATReturnDetailItems) and exposes 42 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. It has 4 associations to related views. Part of development package GLO_FIN_IS_VAT_JP.

Data Sources (2)

SourceAliasJoin Type
C_StRpRptdJournalEntry C_StRpRptdJournalEntry left_outer
P_JP_VATReturnDetailItems P_JP_VATReturnDetailItems 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

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
[0..1] I_Currency _TransactionCurrency $projection.TransactionCurrency = _TransactionCurrency.Currency
[0..1] I_Currency _BalanceTransactionCurrency $projection.BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CJPVATRECUBE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
Analytics.internalName #LOCAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Japan VAT Return Detail Cube view

Fields (42)

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
ReferenceDocumentType AcctDocItm ReferenceDocumentType Reference Document Type
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
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
_CompanyCode _CompanyCode
_BalanceTransactionCurrency _BalanceTransactionCurrency
_TransactionCurrency _TransactionCurrency
_CompanyCodeCurrency _CompanyCodeCurrency

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_VATReturnDetailCube.
-- 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: CJPVATRECUBE
-- 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_VATReturnDetailCube 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.ReferenceDocumentType AS ReferenceDocumentType,
  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
FROM P_JP_VATReturnDetailItems
LEFT OUTER JOIN C_StRpRptdJournalEntry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BalanceTransactionCurrency ON BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;

Learn More