P_AR_PurchaseTaxItemAggrgd

DDL: P_AR_PURCHASETAXITEMAGGRGD SQL: PARPURTXITMAGG Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_AR
44 Fields 1 Data Sources

Argentina Purchase Detail - Tax Item Aggregated

P_AR_PurchaseTaxItemAggrgd is a Consumption CDS View that provides data about "Argentina Purchase Detail - Tax Item Aggregated" in SAP S/4HANA. It reads from 1 data source (P_AR_PurTxItmAggrgdByTxCode) and exposes 44 fields with key fields CompanyCode, FiscalYear, AccountingDocument. Part of development package GLO_FIN_IS_VAT_AR.

Data Sources (1)

SourceAliasJoin Type
P_AR_PurTxItmAggrgdByTxCode P_AR_PurTxItmAggrgdByTxCode from

Parameters (2)

NameTypeDefault
P_AccrualCalculationMethod fiar_vat_compcredit
P_RptgAmountIsInTransCrcy fiar_use_transaction_currency

Annotations (10)

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

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode PurTxItmAggrgdByTxCode CompanyCode Receiver Company Code
KEY FiscalYear PurTxItmAggrgdByTxCode FiscalYear G/L Fiscal Year
KEY AccountingDocument PurTxItmAggrgdByTxCode AccountingDocument Journal Entry
CompanyCodeCountry PurTxItmAggrgdByTxCode CompanyCodeCountry Reporting Ctry/Reg.
FiscalPeriod PurTxItmAggrgdByTxCode FiscalPeriod Tax period
DocumentDate PurTxItmAggrgdByTxCode DocumentDate Journal Entry Date
PostingDate PurTxItmAggrgdByTxCode PostingDate Posting Date for GR
ReportingDate PurTxItmAggrgdByTxCode ReportingDate
IsReversal PurTxItmAggrgdByTxCode IsReversal Reversal doc.
IsReversed PurTxItmAggrgdByTxCode IsReversed Reversed?
ReverseDocument PurTxItmAggrgdByTxCode ReverseDocument Reversed With
ReversalReferenceDocument PurTxItmAggrgdByTxCode ReversalReferenceDocument Reversal Reference Document
OriginalReferenceDocument PurTxItmAggrgdByTxCode OriginalReferenceDocument Reference Key
ReferenceDocumentType PurTxItmAggrgdByTxCode ReferenceDocumentType Reference Document Type
DocumentReferenceID PurTxItmAggrgdByTxCode DocumentReferenceID Reference
AccountingDocumentType PurTxItmAggrgdByTxCode AccountingDocumentType Journal Entry Type
AR_OfficialDocumentType PurTxItmAggrgdByTxCode AR_OfficialDocumentType
AR_OfficialDocumentClass PurTxItmAggrgdByTxCode AR_OfficialDocumentClass
AR_Branch PurTxItmAggrgdByTxCode AR_Branch
AR_PrintCharacter PurTxItmAggrgdByTxCode AR_PrintCharacter
AR_OfficialDocumentNumber PurTxItmAggrgdByTxCode AR_OfficialDocumentNumber
AccountingDocumentHeaderText PurTxItmAggrgdByTxCode AccountingDocumentHeaderText Doc.Header Text
ExchangeRateDate PurTxItmAggrgdByTxCode ExchangeRateDate Translatn Date
ExchangeRate PurTxItmAggrgdByTxCode ExchangeRate Exchange rate
CompanyCodeCurrency PurTxItmAggrgdByTxCode CompanyCodeCurrency Local Currency
Supplier PurTxItmAggrgdByTxCode Supplier Supplier
BusinessPartnerName PurTxItmAggrgdByTxCode BusinessPartnerName Extracted Customer Name
TaxNumber1 PurTxItmAggrgdByTxCode TaxNumber1 VAT Reg. No.
TaxNumberType PurTxItmAggrgdByTxCode TaxNumberType Tax number type
BusinessPartnerCountry PurTxItmAggrgdByTxCode BusinessPartnerCountry BP Ctry/Reg.
FinancialAccountType PurTxItmAggrgdByTxCode FinancialAccountType Fin. Account Type
NetDueDate PurTxItmAggrgdByTxCode NetDueDate Net Due Date
ClearingDate PurTxItmAggrgdByTxCode ClearingDate Clearing Date
ClearingAccountingDocument PurTxItmAggrgdByTxCode ClearingAccountingDocument Clearing Journal Entry
TransactionCurrency PurTxItmAggrgdByTxCode TransactionCurrency Transaction Currency
ReportingCurrency PurTxItmAggrgdByTxCode ReportingCurrency Currency
IsDocumentBOrCAndNotDocType33 PurTxItmAggrgdByTxCode IsDocumentBOrCAndNotDocType33
NmbrOfVATRates PurTxItmAggrgdByTxCode NmbrOfVATRates
AR_LowestPriorityOfZeroVATRsn
TotalCreditAmountInTransCrcy
ForeignTaxAmount
OpenTotalTaxAmount
CalculatedTxAmtInCoCodeCrcy
_OneTimeAccountBP PurTxItmAggrgdByTxCode _OneTimeAccountBP

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_AR_PurchaseTaxItemAggrgd.
-- 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: PARPURTXITMAGG
-- Parameters: P_AccrualCalculationMethod : fiar_vat_compcredit, P_RptgAmountIsInTransCrcy : fiar_use_transaction_currency

CREATE VIEW P_AR_PurchaseTaxItemAggrgd AS
SELECT
  PurTxItmAggrgdByTxCode.CompanyCode AS CompanyCode,
  PurTxItmAggrgdByTxCode.FiscalYear AS FiscalYear,
  PurTxItmAggrgdByTxCode.AccountingDocument AS AccountingDocument,
  PurTxItmAggrgdByTxCode.CompanyCodeCountry AS CompanyCodeCountry,
  PurTxItmAggrgdByTxCode.FiscalPeriod AS FiscalPeriod,
  PurTxItmAggrgdByTxCode.DocumentDate AS DocumentDate,
  PurTxItmAggrgdByTxCode.PostingDate AS PostingDate,
  PurTxItmAggrgdByTxCode.ReportingDate AS ReportingDate,
  PurTxItmAggrgdByTxCode.IsReversal AS IsReversal,
  PurTxItmAggrgdByTxCode.IsReversed AS IsReversed,
  PurTxItmAggrgdByTxCode.ReverseDocument AS ReverseDocument,
  PurTxItmAggrgdByTxCode.ReversalReferenceDocument AS ReversalReferenceDocument,
  PurTxItmAggrgdByTxCode.OriginalReferenceDocument AS OriginalReferenceDocument,
  PurTxItmAggrgdByTxCode.ReferenceDocumentType AS ReferenceDocumentType,
  PurTxItmAggrgdByTxCode.DocumentReferenceID AS DocumentReferenceID,
  PurTxItmAggrgdByTxCode.AccountingDocumentType AS AccountingDocumentType,
  PurTxItmAggrgdByTxCode.AR_OfficialDocumentType AS AR_OfficialDocumentType,
  PurTxItmAggrgdByTxCode.AR_OfficialDocumentClass AS AR_OfficialDocumentClass,
  PurTxItmAggrgdByTxCode.AR_Branch AS AR_Branch,
  PurTxItmAggrgdByTxCode.AR_PrintCharacter AS AR_PrintCharacter,
  PurTxItmAggrgdByTxCode.AR_OfficialDocumentNumber AS AR_OfficialDocumentNumber,
  PurTxItmAggrgdByTxCode.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  PurTxItmAggrgdByTxCode.ExchangeRateDate AS ExchangeRateDate,
  PurTxItmAggrgdByTxCode.ExchangeRate AS ExchangeRate,
  PurTxItmAggrgdByTxCode.CompanyCodeCurrency AS CompanyCodeCurrency,
  PurTxItmAggrgdByTxCode.Supplier AS Supplier,
  PurTxItmAggrgdByTxCode.BusinessPartnerName AS BusinessPartnerName,
  PurTxItmAggrgdByTxCode.TaxNumber1 AS TaxNumber1,
  PurTxItmAggrgdByTxCode.TaxNumberType AS TaxNumberType,
  PurTxItmAggrgdByTxCode.BusinessPartnerCountry AS BusinessPartnerCountry,
  PurTxItmAggrgdByTxCode.FinancialAccountType AS FinancialAccountType,
  PurTxItmAggrgdByTxCode.NetDueDate AS NetDueDate,
  PurTxItmAggrgdByTxCode.ClearingDate AS ClearingDate,
  PurTxItmAggrgdByTxCode.ClearingAccountingDocument AS ClearingAccountingDocument,
  PurTxItmAggrgdByTxCode.TransactionCurrency AS TransactionCurrency,
  PurTxItmAggrgdByTxCode.ReportingCurrency AS ReportingCurrency,
  PurTxItmAggrgdByTxCode.IsDocumentBOrCAndNotDocType33 AS IsDocumentBOrCAndNotDocType33,
  PurTxItmAggrgdByTxCode.NmbrOfVATRates AS NmbrOfVATRates,
  min( PurTxItmAggrgdByTxCode.AR_LowestPriorityOfZeroVATRsn ) AS AR_LowestPriorityOfZeroVATRsn,
  sum( PurTxItmAggrgdByTxCode.TotalCreditAmountInTransCrcy ) AS TotalCreditAmountInTransCrcy,
  sum( PurTxItmAggrgdByTxCode.ForeignTaxAmount ) AS ForeignTaxAmount,
  sum( PurTxItmAggrgdByTxCode.OpenTotalTaxAmount ) AS OpenTotalTaxAmount,
  sum( PurTxItmAggrgdByTxCode.CalculatedTxAmtInCoCodeCrcy ) AS CalculatedTxAmtInCoCodeCrcy,
  PurTxItmAggrgdByTxCode._OneTimeAccountBP AS _OneTimeAccountBP
FROM P_AR_PurTxItmAggrgdByTxCode
;

Learn More