C_AR_StRpVATPrintPurJrnlEntrC

DDL: C_AR_STRPVATPRINTPURJRNLENTRC SQL: CARSTRPVATPJEC Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_AR_PRINT

Argentina VAT Print Purchase - Cube

C_AR_StRpVATPrintPurJrnlEntrC is a Consumption CDS View (Cube) that provides data about "Argentina VAT Print Purchase - Cube" in SAP S/4HANA. It reads from 2 data sources (I_StRpJournalEntryLog, P_AR_VATPrintPurchaseDetail2) and exposes 50 fields with key fields CompanyCode, FiscalYear, AccountingDocument, StatryRptgEntity, StatryRptCategory. Part of development package GLO_FIN_IS_VAT_AR_PRINT.

Data Sources (2)

SourceAliasJoin Type
I_StRpJournalEntryLog StRpJournalEntryLog inner
P_AR_VATPrintPurchaseDetail2 VATPrintPurchase from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CARSTRPVATPJEC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.allowExtensions true view
EndUserText.label Argentina VAT Print Purchase - Cube view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_AR_VATPrintPurchaseDetail2 CompanyCode Receiver Company Code
KEY FiscalYear P_AR_VATPrintPurchaseDetail2 FiscalYear G/L Fiscal Year
KEY AccountingDocument P_AR_VATPrintPurchaseDetail2 AccountingDocument Journal Entry
KEY StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID Report Run ID
KEY Supplier P_AR_VATPrintPurchaseDetail2 Supplier Supplier
ExchangeRateDate P_AR_VATPrintPurchaseDetail2 ExchangeRateDate Translatn Date
ExchangeRate P_AR_VATPrintPurchaseDetail2 ExchangeRate Exchange rate
AccountingDocumentType P_AR_VATPrintPurchaseDetail2 AccountingDocumentType Journal Entry Type
AR_OfficialDocumentClass P_AR_VATPrintPurchaseDetail2 AR_OfficialDocumentClass
FiscalPeriod P_AR_VATPrintPurchaseDetail2 FiscalPeriod Tax period
PostingDate P_AR_VATPrintPurchaseDetail2 PostingDate Posting Date for GR
DocumentDate P_AR_VATPrintPurchaseDetail2 DocumentDate Journal Entry Date
ReportingDate P_AR_VATPrintPurchaseDetail2 ReportingDate
ReferenceDocumentType P_AR_VATPrintPurchaseDetail2 ReferenceDocumentType Reference Document Type
DocumentReferenceID P_AR_VATPrintPurchaseDetail2 DocumentReferenceID Reference
IsReversal P_AR_VATPrintPurchaseDetail2 IsReversal Reversal doc.
IsReversed P_AR_VATPrintPurchaseDetail2 IsReversed Reversed?
ReverseDocument P_AR_VATPrintPurchaseDetail2 ReverseDocument Reversed With
ReversalReferenceDocument P_AR_VATPrintPurchaseDetail2 ReversalReferenceDocument Reversal Reference Document
OriginalReferenceDocument P_AR_VATPrintPurchaseDetail2 OriginalReferenceDocument Reference Key
ClearingDate P_AR_VATPrintPurchaseDetail2 ClearingDate Clearing Date
ClearingAccountingDocument P_AR_VATPrintPurchaseDetail2 ClearingAccountingDocument Clearing Journal Entry
BusinessPartnerCountry P_AR_VATPrintPurchaseDetail2 BusinessPartnerCountry BP Ctry/Reg.
BusinessPartnerName P_AR_VATPrintPurchaseDetail2 BusinessPartnerName Extracted Customer Name
TaxNumber1 P_AR_VATPrintPurchaseDetail2 TaxNumber1 VAT Reg. No.
TaxNumberType P_AR_VATPrintPurchaseDetail2 TaxNumberType Tax number type
AR_Branch P_AR_VATPrintPurchaseDetail2 AR_Branch
AR_PrintCharacter P_AR_VATPrintPurchaseDetail2 AR_PrintCharacter
AR_OfficialDocumentNumber P_AR_VATPrintPurchaseDetail2 AR_OfficialDocumentNumber
AR_OfficialDocumentType P_AR_VATPrintPurchaseDetail2 AR_OfficialDocumentType
AR_OfficialDocTypeLongDesc P_AR_VATPrintPurchaseDetail2 AR_OfficialDocTypeLongDesc
AR_CAE P_AR_VATPrintPurchaseDetail2 AR_CAE
TaxCode P_AR_VATPrintPurchaseDetail2 TaxCode Tax Code
VATRateAsText P_AR_VATPrintPurchaseDetail2 VATRateAsText
CompanyCodeCurrency P_AR_VATPrintPurchaseDetail2 CompanyCodeCurrency Local Currency
TransactionCurrency P_AR_VATPrintPurchaseDetail2 TransactionCurrency Transaction Currency
TaxedAmountInCoCoCrcy P_AR_VATPrintPurchaseDetail2 TaxedAmountInCoCoCrcy
NotTaxedAmount P_AR_VATPrintPurchaseDetail2 NotTaxedAmount
TaxExemptionAmount P_AR_VATPrintPurchaseDetail2 TaxExemptionAmount Tax Exemption
ImportAmountInCompanyCodeCrcy P_AR_VATPrintPurchaseDetail2 ImportAmountInCompanyCodeCrcy
RegisteredBPTaxAmount P_AR_VATPrintPurchaseDetail2 RegisteredBPTaxAmount
NotRegisteredBPTxAmtInCoCoCrcy P_AR_VATPrintPurchaseDetail2 NotRegisteredBPTxAmtInCoCoCrcy
PerceptionVATAmount P_AR_VATPrintPurchaseDetail2 PerceptionVATAmount
OtherTaxAmount P_AR_VATPrintPurchaseDetail2 OtherTaxAmount
GrossIncomeTaxAmount P_AR_VATPrintPurchaseDetail2 GrossIncomeTaxAmount
MunicipalTaxAmount P_AR_VATPrintPurchaseDetail2 MunicipalTaxAmount
TotalAmountInCoCodeCrcy P_AR_VATPrintPurchaseDetail2 TotalAmountInCoCodeCrcy Total Amt In Co Crcy
AmountInCompanyCodeCurrency P_AR_VATPrintPurchaseDetail2 AmountInCompanyCodeCurrency Local Crcy Amt

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_AR_StRpVATPrintPurJrnlEntrC.
-- 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: CARSTRPVATPJEC

CREATE VIEW C_AR_StRpVATPrintPurJrnlEntrC AS
SELECT
  VATPrintPurchase.CompanyCode AS CompanyCode,
  VATPrintPurchase.FiscalYear AS FiscalYear,
  VATPrintPurchase.AccountingDocument AS AccountingDocument,
  StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  VATPrintPurchase.Supplier AS Supplier,
  VATPrintPurchase.ExchangeRateDate AS ExchangeRateDate,
  VATPrintPurchase.ExchangeRate AS ExchangeRate,
  VATPrintPurchase.AccountingDocumentType AS AccountingDocumentType,
  VATPrintPurchase.AR_OfficialDocumentClass AS AR_OfficialDocumentClass,
  VATPrintPurchase.FiscalPeriod AS FiscalPeriod,
  VATPrintPurchase.PostingDate AS PostingDate,
  VATPrintPurchase.DocumentDate AS DocumentDate,
  VATPrintPurchase.ReportingDate AS ReportingDate,
  VATPrintPurchase.ReferenceDocumentType AS ReferenceDocumentType,
  VATPrintPurchase.DocumentReferenceID AS DocumentReferenceID,
  VATPrintPurchase.IsReversal AS IsReversal,
  VATPrintPurchase.IsReversed AS IsReversed,
  VATPrintPurchase.ReverseDocument AS ReverseDocument,
  VATPrintPurchase.ReversalReferenceDocument AS ReversalReferenceDocument,
  VATPrintPurchase.OriginalReferenceDocument AS OriginalReferenceDocument,
  VATPrintPurchase.ClearingDate AS ClearingDate,
  VATPrintPurchase.ClearingAccountingDocument AS ClearingAccountingDocument,
  VATPrintPurchase.BusinessPartnerCountry AS BusinessPartnerCountry,
  VATPrintPurchase.BusinessPartnerName AS BusinessPartnerName,
  VATPrintPurchase.TaxNumber1 AS TaxNumber1,
  VATPrintPurchase.TaxNumberType AS TaxNumberType,
  VATPrintPurchase.AR_Branch AS AR_Branch,
  VATPrintPurchase.AR_PrintCharacter AS AR_PrintCharacter,
  VATPrintPurchase.AR_OfficialDocumentNumber AS AR_OfficialDocumentNumber,
  VATPrintPurchase.AR_OfficialDocumentType AS AR_OfficialDocumentType,
  VATPrintPurchase.AR_OfficialDocTypeLongDesc AS AR_OfficialDocTypeLongDesc,
  VATPrintPurchase.AR_CAE AS AR_CAE,
  VATPrintPurchase.TaxCode AS TaxCode,
  VATPrintPurchase.VATRateAsText AS VATRateAsText,
  VATPrintPurchase.CompanyCodeCurrency AS CompanyCodeCurrency,
  VATPrintPurchase.TransactionCurrency AS TransactionCurrency,
  VATPrintPurchase.TaxedAmountInCoCoCrcy AS TaxedAmountInCoCoCrcy,
  VATPrintPurchase.NotTaxedAmount AS NotTaxedAmount,
  VATPrintPurchase.TaxExemptionAmount AS TaxExemptionAmount,
  VATPrintPurchase.ImportAmountInCompanyCodeCrcy AS ImportAmountInCompanyCodeCrcy,
  VATPrintPurchase.RegisteredBPTaxAmount AS RegisteredBPTaxAmount,
  VATPrintPurchase.NotRegisteredBPTxAmtInCoCoCrcy AS NotRegisteredBPTxAmtInCoCoCrcy,
  VATPrintPurchase.PerceptionVATAmount AS PerceptionVATAmount,
  VATPrintPurchase.OtherTaxAmount AS OtherTaxAmount,
  VATPrintPurchase.GrossIncomeTaxAmount AS GrossIncomeTaxAmount,
  VATPrintPurchase.MunicipalTaxAmount AS MunicipalTaxAmount,
  VATPrintPurchase.TotalAmountInCoCodeCrcy AS TotalAmountInCoCodeCrcy,
  VATPrintPurchase.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency
FROM P_AR_VATPrintPurchaseDetail2 AS VATPrintPurchase
INNER JOIN I_StRpJournalEntryLog AS StRpJournalEntryLog ON /* join condition not captured in parsed metadata */
;