P_ContrAcctgTotalTaxPerTaxCode

DDL: P_CONTRACCTGTOTALTAXPERTAXCODE Type: view_entity COMPOSITE Package: FKK_ID_NO_SAFT
9 Fields 1 Data Sources

Total Tax for each taxcode in a trx

P_ContrAcctgTotalTaxPerTaxCode is a Composite CDS View that provides data about "Total Tax for each taxcode in a trx" in SAP S/4HANA. It reads from 1 data source (P_ContractAccountingGLTaxItem) and exposes 9 fields with key fields CADocumentNumber, TaxCode. Part of development package FKK_ID_NO_SAFT.

Data Sources (1)

SourceAliasJoin Type
P_ContractAccountingGLTaxItem P_ContractAccountingGLTaxItem from

Parameters (3)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to
P_CompanyCode bukrs

Annotations (8)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber Document Number
KEY TaxCode TaxCode Tax Code
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TransactionCurrency TransactionCurrency Transaction Currency
CATaxRate CATaxRate Tax rate
TaxamountinTransCrcy
TaxamountincocodeCrcy
TaxBaseAmountInLocalCurrency
TaxBaseAmount

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_ContrAcctgTotalTaxPerTaxCode.
-- 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.
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_CompanyCode : bukrs

CREATE VIEW P_ContrAcctgTotalTaxPerTaxCode AS
SELECT
  CADocumentNumber,
  TaxCode,
  CompanyCodeCurrency,
  TransactionCurrency,
  CATaxRate,
  sum( CAAmountInTransactionCurrency ) AS TaxamountinTransCrcy,
  sum( CAAmountInLocalCurrency ) AS TaxamountincocodeCrcy,
  sum(CATaxBaseAmountInLocalCurrency) AS TaxBaseAmountInLocalCurrency,
  sum(CATaxBaseAmount) AS TaxBaseAmount
FROM P_ContractAccountingGLTaxItem
;

Learn More