P_TxRegItemHealthCheck

DDL: P_TXREGITEMHEALTHCHECK Type: view_entity BASIC
50 Fields 2 Data Sources

View to compare TAX_REG_ITEM and BSET

P_TxRegItemHealthCheck is a Basic CDS View that provides data about "View to compare TAX_REG_ITEM and BSET" in SAP S/4HANA. It reads from 2 data sources (I_TxRegIndirectTaxJournalEntry, P_TransactionalTaxItem) and exposes 50 fields with key fields TaxitemUuid, CompanyCode, AccountingDocument, FiscalYear, DocumentTaxItemNumber.

Data Sources (2)

SourceAliasJoin Type
I_TxRegIndirectTaxJournalEntry Bset from
P_TransactionalTaxItem TransactionalTaxItem inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View to compare TAX_REG_ITEM and BSET view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY TaxitemUuid P_TransactionalTaxItem TaxItemUUID Tax Item UUID
KEY CompanyCode I_TxRegIndirectTaxJournalEntry CompanyCode Receiver Company Code
KEY AccountingDocument I_TxRegIndirectTaxJournalEntry AccountingDocument Journal Entry
KEY FiscalYear I_TxRegIndirectTaxJournalEntry FiscalYear G/L Fiscal Year
KEY DocumentTaxItemNumber I_TxRegIndirectTaxJournalEntry DocumentTaxItemNumber
AccountingDocumentType I_TxRegIndirectTaxJournalEntry AccountingDocumentType Journal Entry Type
DocumentDate I_TxRegIndirectTaxJournalEntry DocumentDate Journal Entry Date
PostingDate I_TxRegIndirectTaxJournalEntry PostingDate Posting Date for GR
TaxReportingDate I_TxRegIndirectTaxJournalEntry TaxReportingDate Tax Reporting Date
TaxFulfillmentDate I_TxRegIndirectTaxJournalEntry TaxFulfillmentDate Tax Settlement Date
TaxCountry I_TxRegIndirectTaxJournalEntry TaxCountry Tax Ctry/Reg.
TaxRateValidityStartDate I_TxRegIndirectTaxJournalEntry TaxRateValidityStartDate Tax Rate Validity Start Date
TransactionTypeDetermination I_TxRegIndirectTaxJournalEntry TransactionTypeDetermination Transaction Key
ConditionType I_TxRegIndirectTaxJournalEntry ConditionType Condition type
TaxDeterminationDate I_TxRegIndirectTaxJournalEntry TaxDeterminationDate Tx Determination Dte
TaxRate
TransactionCurrency I_TxRegIndirectTaxJournalEntry TransactionCurrency Transaction Currency
ReportingCurrency I_TxRegIndirectTaxJournalEntry ReportingCurrency Currency
TaxBaseAmountInCoCodeCrcy I_TxRegIndirectTaxJournalEntry TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy I_TxRegIndirectTaxJournalEntry TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy I_TxRegIndirectTaxJournalEntry TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmountInTransCrcy I_TxRegIndirectTaxJournalEntry TaxAmountInTransCrcy TaxAmt in Tran. Crcy
TaxBaseAmountInRptgCrcy I_TxRegIndirectTaxJournalEntry TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy I_TxRegIndirectTaxJournalEntry TaxAmountInRptgCrcy Tax Rept. Crcy
TaxCode I_TxRegIndirectTaxJournalEntry TaxCode Tax Code
TaxItemGroup I_TxRegIndirectTaxJournalEntry TaxItemGroup Tax doc. item number
DebitCreditCode I_TxRegIndirectTaxJournalEntry DebitCreditCode Single-Character Flag
TxRegDocumentDate P_TransactionalTaxItem DocumentDate Journal Entry Date
TxRegPostingDate P_TransactionalTaxItem PostingDate Posting Date for GR
TxRegTaxReportingDate P_TransactionalTaxItem TaxReportingDate Tax Reporting Date
TxRegTaxFulfillmentDate P_TransactionalTaxItem TaxFulfillmentDate Tax Settlement Date
TxRegTaxCountry P_TransactionalTaxItem TaxCountry Tax Ctry/Reg.
TxRegTaxRateValidityStartDate P_TransactionalTaxItem TaxRateValidityStartDate Tax Rate Validity Start Date
TxRegConditionType P_TransactionalTaxItem ConditionType Condition type
TxRegTransactionTypeDetermntn P_TransactionalTaxItem TransactionTypeDetermination Transaction Key
TxRegTaxRateInPercent
TxRegTaxBaseAmountInCoCodeCrcy P_TransactionalTaxItem TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TxRegTaxAmountInCoCodeCrcy P_TransactionalTaxItem TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TxRegTaxBaseAmountInTransCrcy P_TransactionalTaxItem TaxBaseAmountInTransCrcy Value-Added Tax
TxRegTaxAmountInTransCrcy P_TransactionalTaxItem TaxAmountInTransCrcy TaxAmt in Tran. Crcy
TxRegTaxBaseAmountInRptgCrcy P_TransactionalTaxItem TaxBaseAmountInRptgCrcy Base Amount
TxRegTaxAmountInRptgCrcy P_TransactionalTaxItem TaxAmountInRptgCrcy Tax Rept. Crcy
TxRegTaxCode P_TransactionalTaxItem TaxCode Tax Code
TxRegTaxItemGroup P_TransactionalTaxItem TaxItemGroup Tax doc. item number
TxRegDebitCreditCode P_TransactionalTaxItem DebitCreditCode Single-Character Flag
CreationDateTime P_TransactionalTaxItem CreationDateTime Timestamp
CreatedByUser P_TransactionalTaxItem CreatedByUser User Name
LastChangeDateTime P_TransactionalTaxItem LastChangeDateTime Timestamp
LastChangedByUser P_TransactionalTaxItem LastChangedByUser User Name
TaxRegisterMigrationUUID P_TransactionalTaxItem TaxRegisterMigrationUUID UUID

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_TxRegItemHealthCheck.
-- 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_TxRegItemHealthCheck AS
SELECT
  TransactionalTaxItem.TaxItemUUID AS TaxitemUuid,
  Bset.CompanyCode AS CompanyCode,
  Bset.AccountingDocument AS AccountingDocument,
  Bset.FiscalYear AS FiscalYear,
  Bset.DocumentTaxItemNumber AS DocumentTaxItemNumber,
  Bset.AccountingDocumentType AS AccountingDocumentType,
  Bset.DocumentDate AS DocumentDate,
  Bset.PostingDate AS PostingDate,
  Bset.TaxReportingDate AS TaxReportingDate,
  Bset.TaxFulfillmentDate AS TaxFulfillmentDate,
  Bset.TaxCountry AS TaxCountry,
  Bset.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  Bset.TransactionTypeDetermination AS TransactionTypeDetermination,
  Bset.ConditionType AS ConditionType,
  Bset.TaxDeterminationDate AS TaxDeterminationDate,
  Bset.TaxRate / 10 AS TaxRate,
  Bset.TransactionCurrency AS TransactionCurrency,
  Bset.ReportingCurrency AS ReportingCurrency,
  Bset.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  Bset.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  Bset.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  Bset.TaxAmountInTransCrcy AS TaxAmountInTransCrcy,
  Bset.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  Bset.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  Bset.TaxCode AS TaxCode,
  Bset.TaxItemGroup AS TaxItemGroup,
  Bset.DebitCreditCode AS DebitCreditCode,
  TransactionalTaxItem.DocumentDate AS TxRegDocumentDate,
  TransactionalTaxItem.PostingDate AS TxRegPostingDate,
  TransactionalTaxItem.TaxReportingDate AS TxRegTaxReportingDate,
  TransactionalTaxItem.TaxFulfillmentDate AS TxRegTaxFulfillmentDate,
  TransactionalTaxItem.TaxCountry AS TxRegTaxCountry,
  TransactionalTaxItem.TaxRateValidityStartDate AS TxRegTaxRateValidityStartDate,
  TransactionalTaxItem.ConditionType AS TxRegConditionType,
  TransactionalTaxItem.TransactionTypeDetermination AS TxRegTransactionTypeDetermntn,
  cast( TransactionalTaxItem.TaxRateInPercent as abap.dec(9,2)) AS TxRegTaxRateInPercent,
  TransactionalTaxItem.TaxBaseAmountInCoCodeCrcy AS TxRegTaxBaseAmountInCoCodeCrcy,
  TransactionalTaxItem.TaxAmountInCoCodeCrcy AS TxRegTaxAmountInCoCodeCrcy,
  TransactionalTaxItem.TaxBaseAmountInTransCrcy AS TxRegTaxBaseAmountInTransCrcy,
  TransactionalTaxItem.TaxAmountInTransCrcy AS TxRegTaxAmountInTransCrcy,
  TransactionalTaxItem.TaxBaseAmountInRptgCrcy AS TxRegTaxBaseAmountInRptgCrcy,
  TransactionalTaxItem.TaxAmountInRptgCrcy AS TxRegTaxAmountInRptgCrcy,
  TransactionalTaxItem.TaxCode AS TxRegTaxCode,
  TransactionalTaxItem.TaxItemGroup AS TxRegTaxItemGroup,
  TransactionalTaxItem.DebitCreditCode AS TxRegDebitCreditCode,
  TransactionalTaxItem.CreationDateTime AS CreationDateTime,
  TransactionalTaxItem.CreatedByUser AS CreatedByUser,
  TransactionalTaxItem.LastChangeDateTime AS LastChangeDateTime,
  TransactionalTaxItem.LastChangedByUser AS LastChangedByUser,
  TransactionalTaxItem.TaxRegisterMigrationUUID AS TaxRegisterMigrationUUID
FROM I_TxRegIndirectTaxJournalEntry AS Bset
INNER JOIN P_TransactionalTaxItem AS TransactionalTaxItem ON /* join condition not captured in parsed metadata */
;

Learn More