I_FixedAssetTaxItem

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 I_FixedAssetTaxItem.
-- 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: IFATAXITEM
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_StatryRptRunType : srf_report_run_type, P_StatryRptRefNmbrPrefixValue : idtw_ref_num_prefix

CREATE VIEW I_FixedAssetTaxItem AS
SELECT
  AcctgDocItem.AccountingDocument AS AccountingDocument,
  AcctgDocItem.CompanyCode AS CompanyCode,
  AcctgDocItem.FiscalYear AS FiscalYear,
  AcctgDocItem.AccountingDocumentItem AS AccountingDocumentItem,
  taxItem.TaxGroup AS TaxGroup,
  AcctgDocItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  AcctgDocItem.Quantity AS Quantity,
  AcctgDocItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( AcctgDocItem.AmountInCompanyCodeCurrency as abap.curr(10, 2)) AS AmountInCompanyCodeCurrency,
  remove decimal_shift function AcctgDocItem.DocumentDate AS DocumentDate,
  AcctgDocItem.PostingDate AS PostingDate,
  taxItem.ReportingDate AS ReportingDate,
  substring(cast(AcctgDocItem.DocumentDate as sstring),5, 2) AS FiscalPeriod,
  taxItem.TaxAmount AS TaxAmount,
  taxItem.TaxItemGroup AS TaxItemGroup,
  taxItem.BusinessPlace AS BusinessPlace,
  taxItem.TaxCode AS TaxCode,
  taxItem.TaxRate AS TaxRate,
  taxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  taxItem.Supplier AS Supplier,
  taxItem.Customer AS Customer,
  taxItem.CustomerCountry AS CustomerCountry,
  taxItem.SupplierCountry AS SupplierCountry,
  taxItem.FormatCode AS AccountingDocumentClass,
  fixedAsset.FixedAssetDescription AS FixedAssetDescription,
  fixedAsset.AssetAdditionalDescription AS AssetAdditionalDescription
FROM P_TW_TaxItem
INNER JOIN I_OperationalAcctgDocItem AS AcctgDocItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FixedAsset AS fixedAsset ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS cur ON /* join condition not captured in parsed metadata */
;