P_StRpTaxItmWithEUTaxClass5

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_StRpTaxItmWithEUTaxClass5.
-- 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: PSRTIEUTAXCLS5

CREATE VIEW P_StRpTaxItmWithEUTaxClass5 AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxCode,
  TransactionTypeDetermination,
  TaxItem,
  Debtor,
  _kna1.BPCustomerName AS CustomerName,
  Creditor,
  _lfa1.BPSupplierName AS SupplierName,
  VATRegistrationFromBSEG,
  cast(substring(VATRegistrationFromBSEG, 1, 2) as stceg_l) AS VATRegistrationFromBSEGCountry,
  cast (coalesce(_kna1.IsOneTimeAccount, _lfa1.IsOneTimeAccount) as xcpdk) AS IsOneTimeAccount,
  cast (coalesce(_kna1.AuthorizationGroup, _lfa1.AuthorizationGroup) as brgru) AS AuthorizationGroup,
  TaxItemGroup,
  TaxJurisdiction,
  Country,
  AmountInReportingCurrency,
  TaxCountry,
  ReportingCountry,
  TaxReturnCountry,
  ReportingCurrency,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxBaseAmountInCountryCrcy,
  CompanyCodeCurrency,
  DocumentCurrency,
  CountryCurrency,
  IsReversal,
  IsReversed,
  TaxableEntity,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  IsEUTriangularDeal,
  DelivOfGoodsDestCountry,
  DelivOfGoodsOriginCountry,
  TaxDebitCreditCode,
  ReferenceDocumentType,
  TaxRate,
  SpecialGLTransactionType,
  ConditionType
FROM P_StRpTaxItmWithEUTaxClass4
LEFT OUTER JOIN I_Customer_to_BusinessPartner AS _CustomerToBusinessPartner ON Debtor = _CustomerToBusinessPartner.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier_to_BusinessPartner AS _SupplierToBusinessPartner ON Creditor = _SupplierToBusinessPartner.Supplier  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID  -- association [0..1]
;