P_TxRegItemCountCheck

DDL: P_TXREGITEMCOUNTCHECK Type: view_entity BASIC Package: FIN_TAXREG_DB
49 Fields 1 Data Sources

Used to find the missing entries in BSET

P_TxRegItemCountCheck is a Basic CDS View that provides data about "Used to find the missing entries in BSET" in SAP S/4HANA. It reads from 1 data source (P_TransactionalTaxItem) and exposes 49 fields with key field TaxItemUUID. Part of development package FIN_TAXREG_DB.

Data Sources (1)

SourceAliasJoin Type
P_TransactionalTaxItem P_TransactionalTaxItem from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Used to find the missing entries in BSET view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY TaxItemUUID TaxItemUUID Tax Item UUID
CompanyCode CompanyCode Receiver Company Code
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
TaxCountry TaxCountry Tax Ctry/Reg.
TaxationType TaxationType Taxation Type
SourceReferenceDocumentType SourceReferenceDocumentType Ref. procedure
SourceLogicalSystem SourceLogicalSystem Logical System
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt Refer. Org.Unit
SourceReferenceDocument SourceReferenceDocument Reference Doc.
RvsdReferenceDocumentType RvsdReferenceDocumentType ReversalRefTran
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt Reversal Reference Document Context
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
TaxDueCategory TaxDueCategory Due Category
GLAccount GLAccount General Ledger
ConditionType ConditionType Condition type
TaxRateInPercent TaxRateInPercent WithholdingRate
TaxRegisterPercentageUnit TaxRegisterPercentageUnit
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
TaxFulfillmentDate TaxFulfillmentDate Tax Settlement Date
TaxReportingDate TaxReportingDate Tax Reporting Date
TaxRateValidityStartDate TaxRateValidityStartDate Tax Rate Validity Start Date
TaxItemGroup TaxItemGroup Tax doc. item number
TaxLineItemStatus TaxLineItemStatus Line Item Status
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
TaxPayableDocument TaxPayableDocument Tax Payable Document Number
TaxPayableDocumentYear TaxPayableDocumentYear Tax Payable Document Year
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmountInTransCrcy TaxAmountInTransCrcy TaxAmt in Tran. Crcy
TransactionCurrency TransactionCurrency Transaction Currency
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy TaxAmountInRptgCrcy Tax Rept. Crcy
ReportingCurrency ReportingCurrency Currency
TaxLineItemPayableStatus TaxLineItemPayableStatus Status
TaxCode TaxCode Tax Code
TaxDeductibility TaxDeductibility Deductibility
DebitCreditCode DebitCreditCode Single-Character Flag
TaxItemIsReportingRelevant TaxItemIsReportingRelevant Is Reportable
TaxRegisterMigrationUUID TaxRegisterMigrationUUID UUID
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name

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_TxRegItemCountCheck.
-- 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_TxRegItemCountCheck AS
SELECT
  TaxItemUUID,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxCountry,
  TaxationType,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  RvsdReferenceDocumentType,
  ReversalReferenceDocument,
  ReversalReferenceDocumentCntxt,
  TransactionTypeDetermination,
  TaxDueCategory,
  GLAccount,
  ConditionType,
  TaxRateInPercent,
  TaxRegisterPercentageUnit,
  PostingDate,
  DocumentDate,
  TaxFulfillmentDate,
  TaxReportingDate,
  TaxRateValidityStartDate,
  TaxItemGroup,
  TaxLineItemStatus,
  IsReversal,
  IsReversed,
  TaxPayableDocument,
  TaxPayableDocumentYear,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  CompanyCodeCurrency,
  TaxBaseAmountInTransCrcy,
  TaxAmountInTransCrcy,
  TransactionCurrency,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  ReportingCurrency,
  TaxLineItemPayableStatus,
  TaxCode,
  TaxDeductibility,
  DebitCreditCode,
  TaxItemIsReportingRelevant,
  TaxRegisterMigrationUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM P_TransactionalTaxItem
;

Learn More