P_NO_SAFTTaxAmountSum

DDL: P_NO_SAFTTAXAMOUNTSUM Type: view_entity COMPOSITE
19 Fields 6 Data Sources

P_NO_SAFTTaxAmountSum is a Composite CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 19 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocument, FiscalYear.

Data Sources (6)

SourceAliasJoin Type
I_OperationalAcctgDocItem AcctDoc inner
I_TaxItem InputTax inner
P_T007B_GLO NonDeductCust inner
P_T007B_GLO NonDeductCust inner
I_TaxItem NonDeductTax union
I_TaxItem TaxItem from

Annotations (8)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_TaxItem CompanyCode Receiver Company Code
KEY AccountingDocument I_TaxItem AccountingDocument Journal Entry
KEY FiscalYear I_TaxItem FiscalYear G/L Fiscal Year
TaxCode I_TaxItem TaxCode Tax Code
TaxItemIsReportingRelevant
TaxRate Tax Rate
TaxAmountInCoCodeCrcy
TaxBaseAmountInCoCodeCrcy
TaxAmount
CompanyCode Receiver Company Code
KEY AccountingDocument I_TaxItem AccountingDocument Journal Entry
KEY FiscalYear I_TaxItem FiscalYear G/L Fiscal Year
TaxCode I_TaxItem TaxCode Tax Code
TaxItemIsReportingRelevant
TaxRate I_TaxItem TaxRate Tax Rate
TaxAmountInCoCodeCrcy
dec232endasTaxBaseAmountInCoCodeCrcy
TaxAmount
dec232endasTaxBaseAmountInTransCrcy

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_NO_SAFTTaxAmountSum.
-- 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.

CREATE VIEW P_NO_SAFTTaxAmountSum AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxCode AS TaxCode,
  '' AS TaxItemIsReportingRelevant,
  max(TaxItem.TaxRate) AS TaxRate,
  cast( sum(TaxItem.TaxAmountInCoCodeCrcy) as abap.dec(23,2)) AS TaxAmountInCoCodeCrcy,
  cast( max(TaxItem.TaxBaseAmountInCoCodeCrcy) as abap.dec(23,2)) AS TaxBaseAmountInCoCodeCrcy,
  cast( sum(TaxItem.TaxAmount) as abap.dec(23,2)) AS TaxAmount,
  case when AcctDoc.TaxCode = '**' and AcctDoc.TaxDistributionCode1 = NonDeductTax.TaxCode then cast( abs(AcctDoc.TaxBrkdwnAmount1InCoCodeCrcy) - InputTax.TaxAmountInCoCodeCrcy as abap.dec(23,2)) when AcctDoc.TaxCode = '**' and AcctDoc.TaxDistributionCode2 = NonDeductTax.TaxCode then cast( abs(AcctDoc.TaxBrkdwnAmount2InCoCodeCrcy) - InputTax.TaxAmountInCoCodeCrcy as abap.dec(23,2)) when AcctDoc.TaxCode = '**' and AcctDoc.TaxDistributionCode3 = NonDeductTax.TaxCode then cast( abs(AcctDoc.TaxBrkdwnAmount3InCoCodeCrcy) - InputTax.TaxAmountInCoCodeCrcy as abap.dec(23,2)) else cast( abs(AcctDoc.AmountInCompanyCodeCurrency) - InputTax.TaxAmountInCoCodeCrcy as abap.dec(23,2)) end as TaxBaseAmountInCoCodeCrcy AS dec232endasTaxBaseAmountInCoCodeCrcy,
  case when AcctDoc.TaxCode = '**' and AcctDoc.TaxDistributionCode1 = NonDeductTax.TaxCode then cast( abs(AcctDoc.TaxBrkdwnAmount1InTransCrcy) - InputTax.TaxAmount as abap.dec(23,2)) when AcctDoc.TaxCode = '**' and AcctDoc.TaxDistributionCode2 = NonDeductTax.TaxCode then cast( abs(AcctDoc.TaxBrkdwnAmount2InTransCrcy) - InputTax.TaxAmount as abap.dec(23,2)) when AcctDoc.TaxCode = '**' and AcctDoc.TaxDistributionCode3 = NonDeductTax.TaxCode then cast( abs(AcctDoc.TaxBrkdwnAmount3InTransCrcy) - InputTax.TaxAmount as abap.dec(23,2)) else cast( abs(AcctDoc.AmountInTransactionCurrency) - InputTax.TaxAmount as abap.dec(23,2)) end as TaxBaseAmountInTransCrcy AS dec232endasTaxBaseAmountInTransCrcy
FROM I_TaxItem AS TaxItem
INNER JOIN P_T007B_GLO AS NonDeductCust ON /* join condition not captured in parsed metadata */
INNER JOIN I_TaxItem AS InputTax ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationalAcctgDocItem AS AcctDoc ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_TaxItem
;

Learn More