P_AR_VATPrintPurchaseDetail2

DDL: P_AR_VATPRINTPURCHASEDETAIL2 SQL: PARVATPRNTPURDT2 Type: view CONSUMPTION
43 Fields 1 Data Sources

P_AR_VATPrintPurchaseDetail2 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_AR_VATPrintPurchaseDetail) and exposes 43 fields with key fields CompanyCode, FiscalYear, AccountingDocument, Supplier.

Data Sources (1)

SourceAliasJoin Type
P_AR_VATPrintPurchaseDetail PurchaseDetail from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PARVATPRNTPURDT2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL 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 (43)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_AR_VATPrintPurchaseDetail CompanyCode Receiver Company Code
KEY FiscalYear P_AR_VATPrintPurchaseDetail FiscalYear G/L Fiscal Year
KEY AccountingDocument P_AR_VATPrintPurchaseDetail AccountingDocument Journal Entry
KEY Supplier P_AR_VATPrintPurchaseDetail Supplier Supplier
CompanyCodeCountry P_AR_VATPrintPurchaseDetail CompanyCodeCountry Reporting Ctry/Reg.
AR_OfficialDocumentClass CountrySpecificDocumentType AR_OfficialDocumentClass
ExchangeRateDate P_AR_VATPrintPurchaseDetail ExchangeRateDate Translatn Date
ExchangeRate P_AR_VATPrintPurchaseDetail ExchangeRate Exchange rate
AccountingDocumentType P_AR_VATPrintPurchaseDetail AccountingDocumentType Journal Entry Type
FiscalPeriod P_AR_VATPrintPurchaseDetail FiscalPeriod Tax period
PostingDate P_AR_VATPrintPurchaseDetail PostingDate Posting Date for GR
DocumentDate P_AR_VATPrintPurchaseDetail DocumentDate Journal Entry Date
ReportingDate P_AR_VATPrintPurchaseDetail ReportingDate
ReferenceDocumentType P_AR_VATPrintPurchaseDetail ReferenceDocumentType Reference Document Type
DocumentReferenceID P_AR_VATPrintPurchaseDetail DocumentReferenceID Reference
IsReversal P_AR_VATPrintPurchaseDetail IsReversal Reversal doc.
IsReversed P_AR_VATPrintPurchaseDetail IsReversed Reversed?
ReverseDocument P_AR_VATPrintPurchaseDetail ReverseDocument Reversed With
ReversalReferenceDocument P_AR_VATPrintPurchaseDetail ReversalReferenceDocument Reversal Reference Document
OriginalReferenceDocument P_AR_VATPrintPurchaseDetail OriginalReferenceDocument Reference Key
ClearingDate P_AR_VATPrintPurchaseDetail ClearingDate Clearing Date
ClearingAccountingDocument P_AR_VATPrintPurchaseDetail ClearingAccountingDocument Clearing Journal Entry
BusinessPartnerCountry P_AR_VATPrintPurchaseDetail BusinessPartnerCountry BP Ctry/Reg.
BusinessPartnerName P_AR_VATPrintPurchaseDetail BusinessPartnerName Extracted Customer Name
AR_Branch P_AR_VATPrintPurchaseDetail AR_Branch
TaxCode P_AR_VATPrintPurchaseDetail TaxCode Tax Code
VATRateAsText P_AR_VATPrintPurchaseDetail VATRateAsText
AR_PrintCharacter P_AR_VATPrintPurchaseDetail AR_PrintCharacter
AR_OfficialDocumentNumber P_AR_VATPrintPurchaseDetail AR_OfficialDocumentNumber
CompanyCodeCurrency P_AR_VATPrintPurchaseDetail CompanyCodeCurrency Local Currency
AR_CAE AR_SupplierCAI AR_CAI
TaxBaseAmountInCoCodeCrcy P_AR_VATPrintPurchaseDetail TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy P_AR_VATPrintPurchaseDetail TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TransactionCurrency P_AR_VATPrintPurchaseDetail TransactionCurrency Transaction Currency
NotTaxedAmount P_AR_VATPrintPurchaseDetail NotTaxedAmount
TaxExemptionAmount P_AR_VATPrintPurchaseDetail TaxExemptionAmount Tax Exemption
ImportAmountInCompanyCodeCrcy P_AR_VATPrintPurchaseDetail ImportAmountInCompanyCodeCrcy
RegisteredBPTaxAmount P_AR_VATPrintPurchaseDetail RegisteredBPTaxAmount
NotRegisteredBPTxAmtInCoCoCrcy P_AR_VATPrintPurchaseDetail NotRegisteredBPTxAmtInCoCoCrcy
PerceptionVATAmount P_AR_VATPrintPurchaseDetail PerceptionVATAmount
OtherTaxAmount P_AR_VATPrintPurchaseDetail OtherTaxAmount
GrossIncomeTaxAmount P_AR_VATPrintPurchaseDetail GrossIncomeTaxAmount
MunicipalTaxAmount P_AR_VATPrintPurchaseDetail MunicipalTaxAmount

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_VATPrintPurchaseDetail2.
-- 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: PARVATPRNTPURDT2

CREATE VIEW P_AR_VATPrintPurchaseDetail2 AS
SELECT
  PurchaseDetail.CompanyCode AS CompanyCode,
  PurchaseDetail.FiscalYear AS FiscalYear,
  PurchaseDetail.AccountingDocument AS AccountingDocument,
  PurchaseDetail.Supplier AS Supplier,
  PurchaseDetail.CompanyCodeCountry AS CompanyCodeCountry,
  CountrySpecificDocumentType.AR_OfficialDocumentClass AS AR_OfficialDocumentClass,
  PurchaseDetail.ExchangeRateDate AS ExchangeRateDate,
  PurchaseDetail.ExchangeRate AS ExchangeRate,
  PurchaseDetail.AccountingDocumentType AS AccountingDocumentType,
  PurchaseDetail.FiscalPeriod AS FiscalPeriod,
  PurchaseDetail.PostingDate AS PostingDate,
  PurchaseDetail.DocumentDate AS DocumentDate,
  PurchaseDetail.ReportingDate AS ReportingDate,
  PurchaseDetail.ReferenceDocumentType AS ReferenceDocumentType,
  PurchaseDetail.DocumentReferenceID AS DocumentReferenceID,
  PurchaseDetail.IsReversal AS IsReversal,
  PurchaseDetail.IsReversed AS IsReversed,
  PurchaseDetail.ReverseDocument AS ReverseDocument,
  PurchaseDetail.ReversalReferenceDocument AS ReversalReferenceDocument,
  PurchaseDetail.OriginalReferenceDocument AS OriginalReferenceDocument,
  PurchaseDetail.ClearingDate AS ClearingDate,
  PurchaseDetail.ClearingAccountingDocument AS ClearingAccountingDocument,
  PurchaseDetail.BusinessPartnerCountry AS BusinessPartnerCountry,
  PurchaseDetail.BusinessPartnerName AS BusinessPartnerName,
  PurchaseDetail.AR_Branch AS AR_Branch,
  PurchaseDetail.TaxCode AS TaxCode,
  PurchaseDetail.VATRateAsText AS VATRateAsText,
  PurchaseDetail.AR_PrintCharacter AS AR_PrintCharacter,
  PurchaseDetail.AR_OfficialDocumentNumber AS AR_OfficialDocumentNumber,
  PurchaseDetail.CompanyCodeCurrency AS CompanyCodeCurrency,
  AR_SupplierCAI.AR_CAI AS AR_CAE,
  PurchaseDetail.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  PurchaseDetail.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  PurchaseDetail.TransactionCurrency AS TransactionCurrency,
  PurchaseDetail.NotTaxedAmount AS NotTaxedAmount,
  PurchaseDetail.TaxExemptionAmount AS TaxExemptionAmount,
  PurchaseDetail.ImportAmountInCompanyCodeCrcy AS ImportAmountInCompanyCodeCrcy,
  PurchaseDetail.RegisteredBPTaxAmount AS RegisteredBPTaxAmount,
  PurchaseDetail.NotRegisteredBPTxAmtInCoCoCrcy AS NotRegisteredBPTxAmtInCoCoCrcy,
  PurchaseDetail.PerceptionVATAmount AS PerceptionVATAmount,
  PurchaseDetail.OtherTaxAmount AS OtherTaxAmount,
  PurchaseDetail.GrossIncomeTaxAmount AS GrossIncomeTaxAmount,
  PurchaseDetail.MunicipalTaxAmount AS MunicipalTaxAmount
FROM P_AR_VATPrintPurchaseDetail AS PurchaseDetail
;

Learn More