P_AR_TaxItem

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_AR_TaxItem.
-- 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: PARTAXITEM

CREATE VIEW P_AR_TaxItem AS
SELECT
  I_TaxItem.CompanyCode AS CompanyCode,
  I_TaxItem.AccountingDocument AS AccountingDocument,
  I_TaxItem.FiscalYear AS FiscalYear,
  I_TaxItem.TaxItem AS TaxItem,
  I_TaxCode.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_TaxCode.TaxType AS TaxType,
  I_TaxCode.TaxCode AS TaxCode,
  I_TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  cast( division( I_TaxItem.TaxRate,10,2 ) as kbetr_tax ) AS TaxRate,
  cast( substring( coalesce( AR_TaxClassIdentification1.StRpTaxClassification, AR_TaxClassIdentification2.StRpTaxClassification ), 1, 2 ) as j_1ataxid_ ) AS StRpTaxClassification,
  coalesce( AR_TaxClassIdentification1.TransactionTypeDetermination, AR_TaxClassIdentification2.TransactionTypeDetermination ) AS TransTypeDeterminationTaxClass,
  cast( coalesce( AR_TaxClassIdentification1.TaxIsProRated, AR_TaxClassIdentification2.TaxIsProRated ) as figlar_prorated preserving type ) AS TaxIsProRated,
  cast( coalesce( AR_TaxClassIdentification1.AddressRegion, AR_TaxClassIdentification2.AddressRegion ) as regio preserving type ) AS AddressRegion,
  cast( coalesce( AR_TaxClassIdentification1.MunicipalJurisdiction, AR_TaxClassIdentification2.MunicipalJurisdiction ) as j_1amjc preserving type ) AS MunicipalJurisdiction,
  I_TaxItem.GLAccount AS GLAccount,
  I_TaxItem.TaxItemGroup AS TaxItemGroup,
  I_TaxItem.ConditionRecord AS ConditionRecord,
  I_TaxItem.ConditionType AS ConditionType,
  I_TaxItem.TaxReturnDate AS TaxReturnDate,
  I_TaxItem.TaxReportingDate AS TaxReportingDate,
  I_TaxItem.VATRegistration AS VATRegistration,
  I_TaxItem.DestinationCountry AS DestinationCountry,
  I_TaxItem.SupplyingCountry AS SupplyingCountry,
  I_TaxItem.TaxJurisdiction AS TaxJurisdiction,
  I_TaxItem.TaxDeterminationDate AS TaxDeterminationDate,
  I_TaxItem.BusinessPlace AS BusinessPlace,
  I_TaxItem.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  I_TaxItem.TaxJurisdictionLevel AS TaxJurisdictionLevel,
  I_TaxItem.TaxResultManualModification AS TaxResultManualModification,
  I_TaxItem.CompanyCodeCountry AS CompanyCodeCountry,
  cast( I_TaxItem.CompanyCodeCurrency as fis_hwaer preserving type ) AS CompanyCodeCurrency,
  cast( I_TaxItem.DocumentCurrency as fis_rwcur preserving type ) AS TransactionCurrency,
  I_TaxItem.AdditionalCurrency1 AS AdditionalCurrency1,
  I_TaxItem.AdditionalCurrency2 AS AdditionalCurrency2,
  I_TaxItem.CountryCurrency AS CountryCurrency,
  I_TaxItem._CompanyCodeCountry AS _CompanyCodeCountry,
  I_TaxItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_TaxItem._GLAccount AS _GLAccount,
  I_TaxItem._ReceivablesPayablesItem AS _ReceivablesPayablesItem,
  I_TaxItem._TaxJurisdiction AS _TaxJurisdiction,
  I_TaxCode._TaxType AS _TaxType,
  I_TaxCode._Text AS _TaxCodeText
FROM I_TaxItem
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_Country ON /* join condition not captured in parsed metadata */
INNER JOIN I_TaxCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AR_TaxClassIdentification AS AR_TaxClassIdentification1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AR_TaxClassIdentification AS AR_TaxClassIdentification2 ON /* join condition not captured in parsed metadata */
;