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.

2 data source(s) 50 fields

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
KEY FiscalYear P_AR_VATPrintPurchaseDetail2 FiscalYear
KEY AccountingDocument P_AR_VATPrintPurchaseDetail2 AccountingDocument
KEY StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID
KEY Supplier P_AR_VATPrintPurchaseDetail2 Supplier
ExchangeRateDate P_AR_VATPrintPurchaseDetail2 ExchangeRateDate
ExchangeRate P_AR_VATPrintPurchaseDetail2 ExchangeRate
AccountingDocumentType P_AR_VATPrintPurchaseDetail2 AccountingDocumentType
AR_OfficialDocumentClass P_AR_VATPrintPurchaseDetail2 AR_OfficialDocumentClass
FiscalPeriod P_AR_VATPrintPurchaseDetail2 FiscalPeriod
PostingDate P_AR_VATPrintPurchaseDetail2 PostingDate
DocumentDate P_AR_VATPrintPurchaseDetail2 DocumentDate
ReportingDate P_AR_VATPrintPurchaseDetail2 ReportingDate
ReferenceDocumentType P_AR_VATPrintPurchaseDetail2 ReferenceDocumentType
DocumentReferenceID P_AR_VATPrintPurchaseDetail2 DocumentReferenceID
IsReversal P_AR_VATPrintPurchaseDetail2 IsReversal
IsReversed P_AR_VATPrintPurchaseDetail2 IsReversed
ReverseDocument P_AR_VATPrintPurchaseDetail2 ReverseDocument
ReversalReferenceDocument P_AR_VATPrintPurchaseDetail2 ReversalReferenceDocument
OriginalReferenceDocument P_AR_VATPrintPurchaseDetail2 OriginalReferenceDocument
ClearingDate P_AR_VATPrintPurchaseDetail2 ClearingDate
ClearingAccountingDocument P_AR_VATPrintPurchaseDetail2 ClearingAccountingDocument
BusinessPartnerCountry P_AR_VATPrintPurchaseDetail2 BusinessPartnerCountry
BusinessPartnerName P_AR_VATPrintPurchaseDetail2 BusinessPartnerName
TaxNumber1 P_AR_VATPrintPurchaseDetail2 TaxNumber1
TaxNumberType P_AR_VATPrintPurchaseDetail2 TaxNumberType
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
VATRateAsText P_AR_VATPrintPurchaseDetail2 VATRateAsText
CompanyCodeCurrency P_AR_VATPrintPurchaseDetail2 CompanyCodeCurrency
TransactionCurrency P_AR_VATPrintPurchaseDetail2 TransactionCurrency
TaxedAmountInCoCoCrcy P_AR_VATPrintPurchaseDetail2 TaxedAmountInCoCoCrcy
NotTaxedAmount P_AR_VATPrintPurchaseDetail2 NotTaxedAmount
TaxExemptionAmount P_AR_VATPrintPurchaseDetail2 TaxExemptionAmount
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
AmountInCompanyCodeCurrency P_AR_VATPrintPurchaseDetail2 AmountInCompanyCodeCurrency 
@AbapCatalog.sqlViewName: 'CARSTRPVATPJEC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #CONSUMPTION
@Analytics: { dataCategory: #CUBE }
@Analytics.internalName:#LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@Metadata.allowExtensions:true
@EndUserText.label: 'Argentina VAT Print Purchase - Cube'
define view C_AR_StRpVATPrintPurJrnlEntrC
  as select from P_AR_VATPrintPurchaseDetail2 as VATPrintPurchase

    inner join   I_StRpJournalEntryLog        as StRpJournalEntryLog
                    on  StRpJournalEntryLog.CompanyCode        = VATPrintPurchase.CompanyCode
                    and StRpJournalEntryLog.FiscalYear         = VATPrintPurchase.FiscalYear
                    and StRpJournalEntryLog.AccountingDocument = VATPrintPurchase.AccountingDocument
{
  key VATPrintPurchase.CompanyCode,
  key VATPrintPurchase.FiscalYear,
  key VATPrintPurchase.AccountingDocument,
  key StRpJournalEntryLog.StatryRptgEntity,
  key StRpJournalEntryLog.StatryRptCategory,
  key StRpJournalEntryLog.StatryRptRunID,
  key VATPrintPurchase.Supplier,
      VATPrintPurchase.ExchangeRateDate,
      VATPrintPurchase.ExchangeRate,
      VATPrintPurchase.AccountingDocumentType,
      VATPrintPurchase.AR_OfficialDocumentClass,
      VATPrintPurchase.FiscalPeriod,
      VATPrintPurchase.PostingDate,
      VATPrintPurchase.DocumentDate,
      VATPrintPurchase.ReportingDate,
      VATPrintPurchase.ReferenceDocumentType,
      VATPrintPurchase.DocumentReferenceID,
      VATPrintPurchase.IsReversal,
      VATPrintPurchase.IsReversed,
      VATPrintPurchase.ReverseDocument,
      VATPrintPurchase.ReversalReferenceDocument,
      VATPrintPurchase.OriginalReferenceDocument,
      VATPrintPurchase.ClearingDate,
      VATPrintPurchase.ClearingAccountingDocument,
      VATPrintPurchase.BusinessPartnerCountry,
      VATPrintPurchase.BusinessPartnerName,
      VATPrintPurchase.TaxNumber1,
      VATPrintPurchase.TaxNumberType,
      VATPrintPurchase.AR_Branch,
      VATPrintPurchase.AR_PrintCharacter,
      VATPrintPurchase.AR_OfficialDocumentNumber,
      VATPrintPurchase.AR_OfficialDocumentType,
      VATPrintPurchase.AR_OfficialDocTypeLongDesc,
      VATPrintPurchase.AR_CAE,
      VATPrintPurchase.TaxCode,
      VATPrintPurchase.VATRateAsText,

      VATPrintPurchase.CompanyCodeCurrency,
      VATPrintPurchase.TransactionCurrency,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      VATPrintPurchase.TaxedAmountInCoCoCrcy,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      VATPrintPurchase.NotTaxedAmount,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      VATPrintPurchase.TaxExemptionAmount,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      VATPrintPurchase.ImportAmountInCompanyCodeCrcy,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      VATPrintPurchase.RegisteredBPTaxAmount,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      VATPrintPurchase.NotRegisteredBPTxAmtInCoCoCrcy,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      VATPrintPurchase.PerceptionVATAmount,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      VATPrintPurchase.OtherTaxAmount,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      VATPrintPurchase.GrossIncomeTaxAmount,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      VATPrintPurchase.MunicipalTaxAmount,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      VATPrintPurchase.TotalAmountInCoCodeCrcy,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      VATPrintPurchase.AmountInCompanyCodeCurrency

}

Learn More