FISVD_EXTERNALTAX_ITEM_INFO

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 FISVD_EXTERNALTAX_ITEM_INFO.
-- 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: FISCDSEXTAXINFO
-- Parameters: P_Language : sylangu

CREATE VIEW FISVD_EXTERNALTAX_ITEM_INFO AS
SELECT
  TID AS UniqueKey,
  TaxItem,
  JurisdictionLevel,
  DocumentNumber,
  CompanyCode,
  cast(_CompanyCode[1:Language = :P_Language].CompanyCodeName as butxt) AS CompanyCodeName,
  TaxRate,
  TaxAmount,
  TaxBaseAmount,
  ExemptAmount,
  ExemptReasonCode,
  GLTaxRate,
  GLTaxAmount,
  GLTaxBaseAmount,
  DebitCreditIndicator,
  cast(_DebitCreditCode._Text[1:Language = :P_Language].DebitCreditCodeName as fis_shkzg_name) AS DebitCreditCodeName,
  GLAccount,
  cast(_GLAccountInCompanyCode._Text[1:Language = :P_Language].GLAccountName as fis_txt30_skat) AS GLAccountName,
  cast(CONCAT(TaxItem, CONCAT('/', JurisdictionLevel)) as sstring) AS TaxInfoDesc,
  TaxDate,
  TaxJurisdiction,
  ShipToTaxJurisdiction,
  ShipFromTaxJurisdiction,
  OrderAccTaxJurisdiction,
  OrderOriginTaxJurisdiction,
  ExtDocNumber,
  ExtDocItem,
  TaxDocItem,
  SalesPurchasesCode,
  MMTaxDocItem,
  Groupingcode,
  TaxDepartureCountry,
  BusinessAreaDivisionCode,
  MaterialNumber,
  InternalProductCode,
  GroupProductCode,
  MaterialQuantity,
  UnitForQuantity,
  PricingReferenceMaterial,
  IndicatorForAPAR,
  TaxType,
  IsTaxExemptTaxable,
  TaxItemBaseAmount,
  TaxItemBaseAmountGross,
  FreightAmount,
  InternalExemptAmount,
  VendorCustomerAccountNumber,
  ClassificationOfAccount,
  CostObject,
  PointOfTitlePassage,
  CustomerTaxExemptionnumber,
  TaxExemptionReasonCode,
  UserSpecificField,
  StoreCode,
  UserSpecificReportData,
  TaxDefaultReason,
  JurisdictionCodeFforTaxCal,
  TotalTaxRate,
  TotalTaxAmount,
  CodeForMaterialTaxExemption,
  CodeForCustomerTaxExemption,
  CustomerExemptCertificate,
  TaxExtExemptionReasonCode,
  GLExtTaxRate,
  GLExtTaxAmount,
  PostingDate,
  IndicatorTaxCredit,
  BilledAmount,
  SoldToParty,
  ShipToParty,
  BillToParty,
  ReferenceGLAccount,
  CostCenter,
  DocumentDate,
  ReferencePostingDate,
  ServiceRenderDate,
  PurchasingDocument,
  SDDocument,
  SDDocumentCategory,
  TotalContractValue,
  WBSElement,
  BusTransTypeCode,
  ExtensionField001,
  ExtensionField002,
  ExtensionField003,
  ExtensionField004,
  ExtensionField005,
  ExtensionField006,
  ExtensionField007,
  ExtensionField008,
  ExtensionField009,
  ExtensionField010,
  ExtensionField011,
  ExtensionField012,
  ExtensionField013,
  ExtensionField014,
  ExtensionField015,
  ExtensionField016,
  ExtensionField017,
  ExtensionField018,
  ExtensionField019,
  ExtensionField020,
  ExtensionField021,
  ExtensionField022,
  ExtensionField023,
  ExtensionField024,
  ExtensionField025,
  ExtensionField026,
  ExtensionField027,
  ExtensionField028,
  ExtensionField029,
  ExtensionField030,
  ExtensionField031,
  ExtensionField032,
  ExtensionField033,
  ExtensionField034,
  ExtensionField035,
  ExtensionField036,
  ExtensionField037,
  ExtensionField038,
  ExtensionField039,
  ExtensionField040,
  ExtensionField041,
  ExtensionField042,
  ExtensionField043,
  ExtensionField044,
  ExtensionField045,
  ExtensionField046,
  ExtensionField047,
  ExtensionField048,
  ExtensionField049,
  ExtensionField050,
  TaxDateExpired,
  TaxCurrency,
  GLCurrency,
  ChartOfAccounts,
  FiscalYear,
  JurisdictionArea,
  cast(_Region._RegionText[1:Language = :P_Language].RegionName as fis_etxdc_txt20_region) AS TaxStateDescription,
  TaxState,
  TaxSourcing
FROM FISVD_EXTERNALTAX_ITEM_PROJ
;