R_TransactionalTaxItemTP

DDL: R_TRANSACTIONALTAXITEMTP Type: view_entity TRANSACTIONAL Package: FIN_TAXREG_DB
72 Fields 1 Data Sources 14 Associations

Transactional Tax Item

R_TransactionalTaxItemTP is a Transactional CDS View that provides data about "Transactional Tax Item" in SAP S/4HANA. It reads from 1 data source (I_TransactionalTaxItem) and exposes 72 fields with key field TaxItemUUID. It has 14 associations to related views. Part of development package FIN_TAXREG_DB.

Data Sources (1)

SourceAliasJoin Type
I_TransactionalTaxItem TransactionalTaxItem from

Associations (14)

CardinalityTargetAliasCondition
[0..1] I_TaxCode _TaxCode $projection.TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure and $projection.TaxCode = _TaxCode.TaxCode
[0..1] I_TaxCalculationProcedure _TaxCalculationProcedure $projection.TaxCalculationProcedure = _TaxCalculationProcedure.TaxCalculationProcedure
[0..1] I_TaxationType _TaxationType $projection.TaxationType = _TaxationType.TaxationType
[1..1] I_UserContactCard _CreatedByUserContactCard $projection.CreatedByUser = _CreatedByUserContactCard.ContactCardID
[0..1] I_UserContactCard _LastChangedByUserContactCard $projection.LastChangedByUser = _LastChangedByUserContactCard.ContactCardID
[0..*] I_TaxationTypeText _TaxationTypeTxt $projection.TaxationType = _TaxationTypeTxt.TaxationType
[0..*] I_TaxLineItemStatusText _TaxLineItemStatusText $projection.TaxLineItemStatus = _TaxLineItemStatusText.TaxLineItemStatus
[0..*] I_TaxLineItemPayableStatusText _TaxLineItemPayableStatusText $projection.TaxLineItemPayableStatus = _TaxLineItemPayableStatusText.TaxLineItemPayableStatus
[0..*] I_TaxDueCategoryText _TaxDueCategoryText $projection.TaxDueCategory = _TaxDueCategoryText.TaxDueCategory
[0..*] I_GlAccountTextInCompanycode _GLAccountTextInCompanyCode $projection.GLAccount = _GLAccountTextInCompanyCode.GLAccount and $projection.CompanyCode = _GLAccountTextInCompanyCode.CompanyCode
[0..*] I_TaxCodeText _TaxCodeText $projection.TaxCode = _TaxCodeText.TaxCode and $projection.TaxCalculationProcedure = _TaxCodeText.TaxCalculationProcedure
[0..*] I_TaxDeductibilityText _TaxDeductibilityText $projection.TaxDeductibility = _TaxDeductibilityText.TaxDeductibility
[0..*] I_CountryText _TaxCountryText $projection.TaxCountry = _TaxCountryText.Country
[1..1] I_TaxRegisterScopedFeature _TaxRegisterScopedFeature _TaxRegisterScopedFeature.TaxRegisterFeatureIdentifier = 'TXRG_DTI_TAX_FLOW'

Annotations (9)

NameValueLevelField
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Transactional Tax Item view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY TaxItemUUID TaxItemUUID Tax Item UUID
CompanyCode CompanyCode Receiver Company Code
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
TaxCode TaxCode Tax Code
AccountingDocumentType AccountingDocumentType Journal Entry Type
TaxCalculationProcedure _TaxCountry TaxCalculationProcedure Tax Procedure
TaxDueCategory TaxDueCategory Due Category
TaxCountry TaxCountry Tax Ctry/Reg.
TaxationType TaxationType Taxation Type
SourceReferenceDocumentType SourceReferenceDocumentType Ref. procedure
SourceLogicalSystem SourceLogicalSystem
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt
SourceReferenceDocument SourceReferenceDocument Reference Doc.
RvsdReferenceDocumentType RvsdReferenceDocumentType
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt Reversal Reference Document Context
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
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
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
_CompanyCode _CompanyCode
_CompanyCodeCurrency _CompanyCodeCurrency
_DocumentCurrency _DocumentCurrency
_GLAccount _GLAccount
_ReportingCurrency _ReportingCurrency
_TaxCountry _TaxCountry
_TaxRegMigration _TaxRegMigration
_TaxCode _TaxCode
_TaxCalculationProcedure _TaxCalculationProcedure
_TaxationType _TaxationType
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard
_TaxCodeText _TaxCodeText
_TaxCountryText _TaxCountryText
_TaxDueCategoryText _TaxDueCategoryText
_GLAccountTextInCompanyCode _GLAccountTextInCompanyCode
_TaxationTypeTxt _TaxationTypeTxt
_TaxLineItemStatusText _TaxLineItemStatusText
_TaxDeductibilityText _TaxDeductibilityText
_TaxLineItemPayableStatusText _TaxLineItemPayableStatusText
_TaxRegisterScopedFeature _TaxRegisterScopedFeature

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 R_TransactionalTaxItemTP.
-- 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 R_TransactionalTaxItemTP AS
SELECT
  TaxItemUUID,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxCode,
  AccountingDocumentType,
  _TaxCountry.TaxCalculationProcedure AS TaxCalculationProcedure,
  TaxDueCategory,
  TaxCountry,
  TaxationType,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  RvsdReferenceDocumentType,
  ReversalReferenceDocument,
  ReversalReferenceDocumentCntxt,
  TransactionTypeDetermination,
  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,
  TaxDeductibility,
  DebitCreditCode,
  TaxItemIsReportingRelevant,
  TaxRegisterMigrationUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_TransactionalTaxItem AS TransactionalTaxItem
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure AND TaxCode = _TaxCode.TaxCode  -- association [0..1]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON TaxCalculationProcedure = _TaxCalculationProcedure.TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_TaxationType AS _TaxationType ON TaxationType = _TaxationType.TaxationType  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON LastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_TaxationTypeText AS _TaxationTypeTxt ON TaxationType = _TaxationTypeTxt.TaxationType  -- association [0..*]
LEFT OUTER JOIN I_TaxLineItemStatusText AS _TaxLineItemStatusText ON TaxLineItemStatus = _TaxLineItemStatusText.TaxLineItemStatus  -- association [0..*]
LEFT OUTER JOIN I_TaxLineItemPayableStatusText AS _TaxLineItemPayableStatusText ON TaxLineItemPayableStatus = _TaxLineItemPayableStatusText.TaxLineItemPayableStatus  -- association [0..*]
LEFT OUTER JOIN I_TaxDueCategoryText AS _TaxDueCategoryText ON TaxDueCategory = _TaxDueCategoryText.TaxDueCategory  -- association [0..*]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountTextInCompanyCode ON GLAccount = _GLAccountTextInCompanyCode.GLAccount AND CompanyCode = _GLAccountTextInCompanyCode.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_TaxCodeText AS _TaxCodeText ON TaxCode = _TaxCodeText.TaxCode AND TaxCalculationProcedure = _TaxCodeText.TaxCalculationProcedure  -- association [0..*]
LEFT OUTER JOIN I_TaxDeductibilityText AS _TaxDeductibilityText ON TaxDeductibility = _TaxDeductibilityText.TaxDeductibility  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _TaxCountryText ON TaxCountry = _TaxCountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_TaxRegisterScopedFeature AS _TaxRegisterScopedFeature ON _TaxRegisterScopedFeature.TaxRegisterFeatureIdentifier = 'TXRG_DTI_TAX_FLOW'  -- association [1..1]
;

Learn More