P_BE_ANNSLSLISTCANOTXGRPBPITEM

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_BE_ANNSLSLISTCANOTXGRPBPITEM.
-- 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_BE_ANNSLSLISTCANOTXGRPBPITEM AS
SELECT
  itm.CompanyCode AS CompanyCode,
  yr.FiscalYear AS FiscalYear,
  itm.CADocumentNumber AS CADocumentNumber,
  cast(substring(tx_item.CAGLItemNumber,2,3) as taxitem ) AS TaxItem,
  tx_item.CAReconciliationKey AS CAReconciliationKey,
  cast('' as farp_belnr_d) AS AccountingDocument,
  tx_item.TaxCode AS TaxCode,
  tx_item.CATransactionKeyAccountDetn AS TransactionTypeDetermination,
  tx_item.CATaxBaseAmountInLocalCurrency AS TaxBaseAmountInCoCodeCrcy,
  tx_item.CAAmountInLocalCurrency AS TaxAmountInCoCodeCrcy,
  tx_item.CATaxBaseAmountInLocalCurrency AS TaxBaseAmountInCountryCrcy,
  tx_item.CATaxBaseAmountInLocalCurrency AS TaxAmountInCountryCrcy,
  itm.Country AS TaxCountry,
  itm.Country AS TaxReturnCountry,
  itm.CATaxAmountInTransCurrency AS TaxAmount,
  tx_item.CATaxBaseAmount AS TaxBaseAmountInTransCrcy,
  itm._CompCode.Country AS CompanyCodeCountry,
  itm.CADocumentType AS AccountingDocumentType,
  itm.DocumentDate AS DocumentDate,
  itm.CAPostingDate AS PostingDate,
  cast(itm.CAPostingDate as vatdate preserving type) AS TaxReportingDate,
  itm.CAPostingDate AS ReportingDate,
  yr.FiscalPeriod AS FiscalPeriod,
  tx_item.Currency AS DocumentCurrency,
  itm._CompCode.Currency AS CompanyCodeCurrency,
  bp.OrganizationBPName1 AS OrganizationBPName1,
  bp.OrganizationBPName2 AS OrganizationBPName2,
  itm.Country AS Country,
  itm.BPTaxNumber AS TaxNumber2,
  itm.BPTaxNumber AS VATRegistrationFromLineItem,
  itm.VATRegistrationCountry AS VATRegistrationLineItemCountry,
  itm.VATRegistrationCountry AS VATRegistrationCountry,
  itm.BusinessPartner AS BusinessPartner,
  itm.TaxCalculationProcedure AS TaxCalculationProcedure,
  itm._Country.CountryCurrency AS CountryCurrency,
  txc.TaxType AS TaxType,
  txc.TargetTaxCode AS TargetTaxCode,
  txc.EUTaxClassification AS EUTaxClassification,
  txc.EUAcqnInputTaxCode AS EUAcqnInputTaxCode,
  txc.EUAcqnOutputTaxCode AS EUAcqnOutputTaxCode,
  cast('' as xcpdk) AS IsOneTimeAccount,
  t007b.stgrp AS stgrp,
  t007b.stazf AS stazf
FROM P_BE_AnnSlsListCA AS itm
LEFT OUTER JOIN I_BE_CADocumentTaxReporting AS txrpt_vat ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TaxCode AS txc ON txc.TaxCalculationProcedure = itm.TaxCalculationProcedure AND txc.TaxCode = tx_item.TaxCode  -- association [0..1]
LEFT OUTER JOIN I_FiscCalendarDateForCompCode AS yr ON itm.CompanyCode = yr.CompanyCode AND itm.CAPostingDate = yr.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS bp ON bp.BusinessPartner = itm.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN P_SlsPurListBPTaxItem00 AS t007b ON tx_item.CATransactionKeyAccountDetn = t007b.TransactionTypeDetermination  -- association [0..1]
;