P_EG_StRpTaxItmWithTxCodeGrpg

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_EG_StRpTaxItmWithTxCodeGrpg.
-- 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_TaxReportingFromDate : vatdate, P_AdjustmentDocumentIsDerived : glo_derive_adjustment, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW P_EG_StRpTaxItmWithTxCodeGrpg AS
SELECT
  item.StatryRptgEntity AS StatryRptgEntity,
  item.StatryRptCategory AS StatryRptCategory,
  item.StatryRptRunID AS StatryRptRunID,
  item.CompanyCode AS CompanyCode,
  item.FiscalYear AS FiscalYear,
  item.AccountingDocument AS AccountingDocument,
  item.TaxItem AS TaxItem,
  TaxGroup.TaxBox AS TaxBox,
  TaxGroup.TaxDeclnAmountType AS TaxDeclnAmountType,
  TaxGroup.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  TaxGroup.TaxGroupOperation AS TaxGroupOperation,
  TaxGroup.TaxGroupFreeClassification AS TaxGroupFreeClassification,
  cast( substring( taxgroupfreeclassification, 1, 1 ) as fieg_tax_type ) AS EG_TaxType,
  cast( substring( taxgroupfreeclassification, 2, 1 ) as fieg_schedule_tax_type ) AS EG_ScheduleTaxType,
  cast( substring( taxgroupfreeclassification, 3, 1 ) as fieg_doc_item_nature ) AS EG_DocumentItemNature,
  cast( substring( taxgroupfreeclassification, 4, 5 ) as fieg_doc_item_type ) AS EG_DocumentItemType,
  item.SenderLogicalSystem AS SenderLogicalSystem,
  item.TaxCode AS TaxCode,
  item.TaxRate AS TaxRate,
  item.TaxItemGroup AS TaxItemGroup,
  item.TransactionTypeDetermination AS TransactionTypeDetermination,
  item.TaxType AS TaxType,
  item.DebitCreditCode AS DebitCreditCode,
  item.AccountingDocumentType AS AccountingDocumentType,
  item.CompleteAddress AS CompleteAddress,
  item.ReportingCountry AS ReportingCountry,
  item.CompanyCodeCountry AS CompanyCodeCountry,
  item.ReportingDate AS ReportingDate,
  item.PostingDate AS PostingDate,
  item.DocumentDate AS DocumentDate,
  item.TaxReportingDocumentDate AS TaxReportingDocumentDate,
  item.DocumentCurrency AS DocumentCurrency,
  item.CompanyCodeCurrency AS CompanyCodeCurrency,
  item.ReportingCurrency AS ReportingCurrency,
  item.CountryCurrency AS CountryCurrency,
  item.AdditionalCurrency1 AS AdditionalCurrency1,
  item.AdditionalCurrency2 AS AdditionalCurrency2,
  item.TaxNumber1 AS TaxNumber1,
  item.TaxNumber2 AS TaxNumber2,
  item.TaxNumber3 AS TaxNumber3,
  item.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  item.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  item.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  item.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  item.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  item.TaxAmount AS TaxAmount,
  item.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  item.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  item.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  item.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  item.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  item.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  item.OriginalReferenceDocument AS OriginalReferenceDocument,
  item.IsReversal AS IsReversal,
  item.IsReversed AS IsReversed,
  item.ReverseDocument AS ReverseDocument,
  item.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  item.Customer AS Customer,
  item.Supplier AS Supplier,
  item.BusinessPartnerCountry AS BusinessPartnerCountry,
  item.BusinessPartner AS BusinessPartner,
  item.BusinessPartnerName AS BusinessPartnerName,
  item.IsNaturalPerson AS IsNaturalPerson,
  item.LegalEntityOfOrganization AS LegalEntityOfOrganization,
  item.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  item._Customer AS _Customer,
  item.ReferenceDocumentType AS ReferenceDocumentType,
  item.GLAccount AS GLAccount,
  item._CustomerSupplierLineItem AS _CustomerSupplierLineItem,
  item._Supplier AS _Supplier,
  TaxGroup.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  TaxGroup.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate
FROM P_EG_StRpTaxLineItem AS item
INNER JOIN P_StRpTaxItemGrpgWithDocType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_BusinessPartnerLegalEntity AS _LegalEntity ON _LegalEntity.BPOrganisationLegalEntity = LegalEntityOfOrganization  -- association [1..1]
LEFT OUTER JOIN I_Businesspartnertaxnumber AS _TaxNumber1 ON _TaxNumber1.BusinessPartner = BusinessPartner AND _TaxNumber1.BPTaxType = 'EG2'  -- association [0..1]
LEFT OUTER JOIN I_Businesspartnertaxnumber AS _TaxNumber2 ON _TaxNumber2.BusinessPartner = BusinessPartner AND _TaxNumber2.BPTaxType = 'EG4'  -- association [0..1]
LEFT OUTER JOIN I_BuPaIdentification AS _TaxNumber3 ON _TaxNumber3.BusinessPartner = BusinessPartner AND _TaxNumber3.BPIdentificationType = 'FS0002'  -- association [0..1]
;