C_IndirectTaxItem

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 C_IndirectTaxItem.
-- 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 C_IndirectTaxItem AS
SELECT
  TaxItemUUID,
  CompanyCode,
  AccountingDocument,
  TaxCountry,
  TaxationType,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  RvsdReferenceDocumentType,
  ReversalReferenceDocument,
  ReversalReferenceDocumentCntxt,
  TransactionTypeDetermination,
  TaxDueCategory,
  GLAccount,
  ConditionType,
  TaxRateInPercent,
  TaxRegisterPercentageUnit,
  PostingDate,
  DocumentDate,
  cast( TaxFulfillmentDate as txrg_fulfilldate_lbl preserving type ) AS TaxFulfillmentDate,
  TaxReportingDate,
  TaxRateValidityStartDate,
  TaxItemGroup,
  TaxLineItemStatus,
  IsReversed,
  IsReversal,
  TaxPayableDocument,
  TaxPayableDocumentYear,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  CompanyCodeCurrency,
  TaxBaseAmountInTransCrcy,
  TaxAmountInTransCrcy,
  TransactionCurrency,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  ReportingCurrency,
  TaxCode,
  TaxDeductibility,
  DebitCreditCode,
  TaxLineItemPayableStatus,
  Criticality,
  TaxCalculationProcedure,
  TaxItemIsReportingRelevant,
  TaxRegisterMigrationUUID,
  _TaxRegMigration.TaxRegisterMigrationNumber AS TaxRegisterMigrationNumber,
  CreationDateTime,
  CreatedByUser,
  _CreatedByUserContactCard.UserDescription AS CreatedByUserName,
  LastChangeDateTime,
  LastChangedByUser,
  _LastChangedByUserContactCard.UserDescription AS LastChangedByUserName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _TaxCountryText.CountryName as CountryName : localized AS CountryNameasCountryNamelocalized,
  _GLAccountTextInCompanyCode.GLAccountName as GLAccountName : localized AS GLAccountNameasGLAccountNamelocalized,
  _TaxCodeText.TaxCodeName as TaxCodeName : localized AS TaxCodeNameasTaxCodeNamelocalized
FROM R_TransactionalTaxItemTP
LEFT OUTER JOIN C_TaxItemProcessFlow AS _TaxItemProcessFlow ON TaxItemUUID = _TaxItemProcessFlow.TaxItemUUID  -- association [0..*]
;