P_PL_SAFTTaxItemAgg

DDL: P_PL_SAFTTAXITEMAGG SQL: PPLSAFTTAXITMAGG Type: view COMPOSITE Package: GLO_FIN_IS_SAFT_PL
34 Fields 1 Data Sources 1 Associations

SAF-T PL Tax Item Basic

P_PL_SAFTTaxItemAgg is a Composite CDS View that provides data about "SAF-T PL Tax Item Basic" in SAP S/4HANA. It reads from 1 data source (P_PL_SAFTTaxItemBasicAgg) and exposes 34 fields with key fields TaxType, CompanyCode, AccountingDocument, FiscalYear. It has 1 association to related views. Part of development package GLO_FIN_IS_SAFT_PL.

Data Sources (1)

SourceAliasJoin Type
P_PL_SAFTTaxItemBasicAgg a from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Country _Country $projection.BusinessPartnerCountry = _Country.Country

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPLSAFTTAXITMAGG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY TaxType P_PL_SAFTTaxItemBasicAgg TaxType Tax Type
KEY CompanyCode P_PL_SAFTTaxItemBasicAgg CompanyCode Receiver Company Code
KEY AccountingDocument P_PL_SAFTTaxItemBasicAgg AccountingDocument Journal Entry
KEY FiscalYear P_PL_SAFTTaxItemBasicAgg FiscalYear G/L Fiscal Year
PL_SAFTTaxAmountBox P_PL_SAFTTaxItemBasicAgg PL_SAFTTaxAmountBox
PL_SAFTBaseAmountBoxMultiple P_PL_SAFTTaxItemBasicAgg PL_SAFTBaseAmountBoxMultiple
PL_SAFTDocumentType P_PL_SAFTTaxItemBasicAgg PL_SAFTDocumentType
PL_SAFTTaxItemHasMarginAmount P_PL_SAFTTaxItemBasicAgg PL_SAFTTaxItemHasMarginAmount
PL_SAFTAddlClassification P_PL_SAFTTaxItemBasicAgg PL_SAFTAddlClassification
PL_SAFTInvcExclRsnFromTotals P_PL_SAFTTaxItemBasicAgg PL_SAFTInvcExclRsnFromTotals
TaxReportingDate P_PL_SAFTTaxItemBasicAgg TaxReportingDate Tax Reporting Date
TaxReturnCountry P_PL_SAFTTaxItemBasicAgg TaxReturnCountry Reporting C/R
TaxCalculationProcedure P_PL_SAFTTaxItemBasicAgg TaxCalculationProcedure Tax Procedure
Customer P_PL_SAFTTaxItemBasicAgg Customer Sold-to Party
Supplier P_PL_SAFTTaxItemBasicAgg Supplier Supplier
ReferenceDocumentType P_PL_SAFTTaxItemBasicAgg ReferenceDocumentType Reference Document Type
OriginalReferenceDocument P_PL_SAFTTaxItemBasicAgg OriginalReferenceDocument Reference Key
DocumentItemText t DocumentItemText Text
BusinessPartnerCountry P_PL_SAFTTaxItemBasicAgg BusinessPartnerCountry BP Ctry/Reg.
VATRegistration P_PL_SAFTTaxItemBasicAgg VATRegistration VAT Registration No.
BusinessPartnerName P_PL_SAFTTaxItemBasicAgg BusinessPartnerName Extracted Customer Name
CustomerSupplierAddress P_PL_SAFTTaxItemBasicAgg CustomerSupplierAddress
DocumentReferenceID P_PL_SAFTTaxItemBasicAgg DocumentReferenceID Reference
DocumentDate P_PL_SAFTTaxItemBasicAgg DocumentDate Journal Entry Date
CompanyCodeCurrency P_PL_SAFTTaxItemBasicAgg CompanyCodeCurrency Local Currency
TaxAmountInCoCodeCrcy
TaxBaseAmountInCoCodeCrcy
DocumentCurrency P_PL_SAFTTaxItemBasicAgg DocumentCurrency Document Currency
TaxBaseAmountInCountryCrcy
TaxAmountInCountryCrcy
BillingDocument P_PL_SAFTTaxItemBasicAgg BillingDocument SD Document
VATCountry
_AccountingDocument P_PL_SAFTTaxItemBasicAgg _AccountingDocument
_Country _Country

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_PL_SAFTTaxItemAgg.
-- 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: PPLSAFTTAXITMAGG

CREATE VIEW P_PL_SAFTTaxItemAgg AS
SELECT
  a.TaxType AS TaxType,
  a.CompanyCode AS CompanyCode,
  a.AccountingDocument AS AccountingDocument,
  a.FiscalYear AS FiscalYear,
  a.PL_SAFTTaxAmountBox AS PL_SAFTTaxAmountBox,
  a.PL_SAFTBaseAmountBoxMultiple AS PL_SAFTBaseAmountBoxMultiple,
  a.PL_SAFTDocumentType AS PL_SAFTDocumentType,
  a.PL_SAFTTaxItemHasMarginAmount AS PL_SAFTTaxItemHasMarginAmount,
  a.PL_SAFTAddlClassification AS PL_SAFTAddlClassification,
  a.PL_SAFTInvcExclRsnFromTotals AS PL_SAFTInvcExclRsnFromTotals,
  a.TaxReportingDate AS TaxReportingDate,
  a.TaxReturnCountry AS TaxReturnCountry,
  a.TaxCalculationProcedure AS TaxCalculationProcedure,
  a.Customer AS Customer,
  a.Supplier AS Supplier,
  a.ReferenceDocumentType AS ReferenceDocumentType,
  a.OriginalReferenceDocument AS OriginalReferenceDocument,
  t.DocumentItemText AS DocumentItemText,
  a.BusinessPartnerCountry AS BusinessPartnerCountry,
  a.VATRegistration AS VATRegistration,
  a.BusinessPartnerName AS BusinessPartnerName,
  a.CustomerSupplierAddress AS CustomerSupplierAddress,
  a.DocumentReferenceID AS DocumentReferenceID,
  a.DocumentDate AS DocumentDate,
  a.CompanyCodeCurrency AS CompanyCodeCurrency,
  sum(a.TaxAmountInCoCodeCrcy) AS TaxAmountInCoCodeCrcy,
  sum(a.TaxBaseAmountInCoCodeCrcy) AS TaxBaseAmountInCoCodeCrcy,
  a.DocumentCurrency AS DocumentCurrency,
  sum(a.TaxBaseAmountInCountryCrcy) AS TaxBaseAmountInCountryCrcy,
  sum(a.TaxAmountInCountryCrcy) AS TaxAmountInCountryCrcy,
  a.BillingDocument AS BillingDocument,
  substring(a.VATRegistration,1,2) AS VATCountry,
  a._AccountingDocument AS _AccountingDocument
FROM P_PL_SAFTTaxItemBasicAgg AS a
LEFT OUTER JOIN I_Country AS _Country ON BusinessPartnerCountry = _Country.Country  -- association [0..1]
;

Learn More