P_ReportedPayableTaxItem

DDL: P_REPORTEDPAYABLETAXITEM Type: view_entity COMPOSITE
55 Fields 2 Data Sources

P_ReportedPayableTaxItem is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_ReportedTaxItem, I_TransactionalTaxItem) and exposes 55 fields with key field TaxItemUUID.

Data Sources (2)

SourceAliasJoin Type
P_ReportedTaxItem reportedItems inner
I_TransactionalTaxItem taxItems from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (55)

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

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_ReportedPayableTaxItem.
-- 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_ReportedPayableTaxItem AS
SELECT
  taxItems.TaxItemUUID AS TaxItemUUID,
  taxItems.CompanyCode AS CompanyCode,
  taxItems.AccountingDocument AS AccountingDocument,
  taxItems.FiscalYear AS FiscalYear,
  taxItems.TaxCountry AS TaxCountry,
  taxItems.TaxationType AS TaxationType,
  taxItems.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  taxItems.SourceLogicalSystem AS SourceLogicalSystem,
  taxItems.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  taxItems.SourceReferenceDocument AS SourceReferenceDocument,
  taxItems.RvsdReferenceDocumentType AS RvsdReferenceDocumentType,
  taxItems.ReversalReferenceDocument AS ReversalReferenceDocument,
  taxItems.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  taxItems.TransactionTypeDetermination AS TransactionTypeDetermination,
  taxItems.TaxDueCategory AS TaxDueCategory,
  taxItems.GLAccount AS GLAccount,
  taxItems.ConditionType AS ConditionType,
  taxItems.TaxRateInPercent AS TaxRateInPercent,
  taxItems.TaxRegisterPercentageUnit AS TaxRegisterPercentageUnit,
  taxItems.PostingDate AS PostingDate,
  taxItems.DocumentDate AS DocumentDate,
  taxItems.TaxFulfillmentDate AS TaxFulfillmentDate,
  taxItems.TaxReportingDate AS TaxReportingDate,
  taxItems.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  taxItems.TaxItemGroup AS TaxItemGroup,
  taxItems.TaxLineItemStatus AS TaxLineItemStatus,
  taxItems.IsReversal AS IsReversal,
  taxItems.IsReversed AS IsReversed,
  taxItems.TaxPayableDocument AS TaxPayableDocument,
  taxItems.TaxPayableDocumentYear AS TaxPayableDocumentYear,
  taxItems.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  taxItems.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  taxItems.CompanyCodeCurrency AS CompanyCodeCurrency,
  taxItems.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  taxItems.TaxAmountInTransCrcy AS TaxAmountInTransCrcy,
  taxItems.TransactionCurrency AS TransactionCurrency,
  taxItems.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  taxItems.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  taxItems.ReportingCurrency AS ReportingCurrency,
  taxItems.TaxLineItemPayableStatus AS TaxLineItemPayableStatus,
  taxItems.TaxCode AS TaxCode,
  taxItems.TaxDeductibility AS TaxDeductibility,
  taxItems.CreationDateTime AS CreationDateTime,
  taxItems.CreatedByUser AS CreatedByUser,
  taxItems.LastChangeDateTime AS LastChangeDateTime,
  taxItems.LastChangedByUser AS LastChangedByUser,
  reportedItems.StatryRptCategory AS StatryRptCategory,
  reportedItems.StatryRptgEntity AS StatryRptgEntity,
  reportedItems.StatryRptRunID AS StatryRptRunID,
  taxItems._CompanyCode AS _CompanyCode,
  taxItems._DocumentCurrency AS _DocumentCurrency,
  taxItems._CompanyCodeCurrency AS _CompanyCodeCurrency,
  taxItems._ReportingCurrency AS _ReportingCurrency,
  taxItems._GLAccount AS _GLAccount,
  taxItems._TaxCountry AS _TaxCountry
FROM I_TransactionalTaxItem AS taxItems
INNER JOIN P_ReportedTaxItem AS reportedItems ON /* join condition not captured in parsed metadata */
;

Learn More