P_TxRegIndrctTxJrnlEntrRefDoc

DDL: P_TXREGINDRCTTXJRNLENTRREFDOC Type: view_entity COMPOSITE
46 Fields 1 Data Sources

P_TxRegIndrctTxJrnlEntrRefDoc is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_TxRegIndirectTaxJournalEntry) and exposes 46 fields with key fields CompanyCode, AccountingDocument, FiscalYear, DocumentTaxItemNumber.

Data Sources (1)

SourceAliasJoin Type
I_TxRegIndirectTaxJournalEntry IndirectTax from

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (46)

KeyFieldSource TableSource FieldDescription
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
TaxCountry I_TxRegIndirectTaxJournalEntry TaxCountry Tax Ctry/Reg.
TaxCalculationProcedure I_TxRegIndirectTaxJournalEntry TaxCalculationProcedure Tax Procedure
ReferenceDocumentType I_TxRegIndirectTaxJournalEntry ReferenceDocumentType Reference Document Type
ReferenceDocumentLogicalSystem I_TxRegIndirectTaxJournalEntry ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
IsReversal I_TxRegIndirectTaxJournalEntry IsReversal Reversal doc.
IsReversed I_TxRegIndirectTaxJournalEntry IsReversed Reversed?
ReversalReferenceDocument I_TxRegIndirectTaxJournalEntry ReversalReferenceDocument Reversal Reference Document
ReversalReferenceDocumentCntxt I_TxRegIndirectTaxJournalEntry ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReferenceDocumentContext ReferenceDocument ReferenceDocumentContext Reference Document Context
ReferenceDocument ReferenceDocument ReferenceDocument Reference Document
ReversalReferenceDocumentType ReferenceDocument ReversalReferenceDocumentType
GLAccount I_TxRegIndirectTaxJournalEntry GLAccount General Ledger
TransactionTypeDetermination I_TxRegIndirectTaxJournalEntry TransactionTypeDetermination Transaction Key
ConditionType I_TxRegIndirectTaxJournalEntry ConditionType Condition type
TaxRateValidityStartDate I_TxRegIndirectTaxJournalEntry TaxRateValidityStartDate Tax Rate Validity Start Date
TaxRate I_TxRegIndirectTaxJournalEntry TaxRate Tax Rate
TaxItemIsReportingRelevant I_TxRegIndirectTaxJournalEntry TaxItemIsReportingRelevant
PostingDate I_TxRegIndirectTaxJournalEntry PostingDate Posting Date for GR
DocumentDate I_TxRegIndirectTaxJournalEntry DocumentDate Journal Entry Date
TaxFulfillmentDate I_TxRegIndirectTaxJournalEntry TaxFulfillmentDate Tax Settlement Date
TaxReportingDate I_TxRegIndirectTaxJournalEntry TaxReportingDate Tax Reporting Date
TaxItemGroup I_TxRegIndirectTaxJournalEntry TaxItemGroup Tax doc. item number
DebitCreditCode I_TxRegIndirectTaxJournalEntry DebitCreditCode Single-Character Flag
AccountingDocumentType I_TxRegIndirectTaxJournalEntry AccountingDocumentType Journal Entry Type
TaxBaseAmountInCoCodeCrcy I_TxRegIndirectTaxJournalEntry TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy I_TxRegIndirectTaxJournalEntry TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
CompanyCodeCurrency I_TxRegIndirectTaxJournalEntry CompanyCodeCurrency Local Currency
TaxBaseAmountInTransCrcy I_TxRegIndirectTaxJournalEntry TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmountInTransCrcy I_TxRegIndirectTaxJournalEntry TaxAmountInTransCrcy TaxAmt in Tran. Crcy
TransactionCurrency I_TxRegIndirectTaxJournalEntry TransactionCurrency Transaction Currency
TaxBaseAmountInRptgCrcy I_TxRegIndirectTaxJournalEntry TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy I_TxRegIndirectTaxJournalEntry TaxAmountInRptgCrcy Tax Rept. Crcy
ReportingCurrency I_TxRegIndirectTaxJournalEntry ReportingCurrency Currency
TaxCode I_TxRegIndirectTaxJournalEntry TaxCode Tax Code
CreationDateTime I_TxRegIndirectTaxJournalEntry CreationDateTime Timestamp
CreatedByUser I_TxRegIndirectTaxJournalEntry CreatedByUser User Name
TaxItemAcctgDocItemRef I_TxRegIndirectTaxJournalEntry TaxItemAcctgDocItemRef Tax doc. item number
_CompanyCodeCurrency I_TxRegIndirectTaxJournalEntry _CompanyCodeCurrency
_TransactionCurrency I_TxRegIndirectTaxJournalEntry _TransactionCurrency
_ReportingCurrency I_TxRegIndirectTaxJournalEntry _ReportingCurrency
_ReferenceDocumentType I_TxRegIndirectTaxJournalEntry _ReferenceDocumentType
_RefDocumentLogicalSystem I_TxRegIndirectTaxJournalEntry _RefDocumentLogicalSystem

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_TxRegIndrctTxJrnlEntrRefDoc.
-- 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_TxRegIndrctTxJrnlEntrRefDoc AS
SELECT
  IndirectTax.CompanyCode AS CompanyCode,
  IndirectTax.AccountingDocument AS AccountingDocument,
  IndirectTax.FiscalYear AS FiscalYear,
  IndirectTax.DocumentTaxItemNumber AS DocumentTaxItemNumber,
  IndirectTax.TaxCountry AS TaxCountry,
  IndirectTax.TaxCalculationProcedure AS TaxCalculationProcedure,
  IndirectTax.ReferenceDocumentType AS ReferenceDocumentType,
  IndirectTax.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  IndirectTax.IsReversal AS IsReversal,
  IndirectTax.IsReversed AS IsReversed,
  IndirectTax.ReversalReferenceDocument AS ReversalReferenceDocument,
  IndirectTax.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  ReferenceDocument.ReferenceDocumentContext AS ReferenceDocumentContext,
  ReferenceDocument.ReferenceDocument AS ReferenceDocument,
  ReferenceDocument.ReversalReferenceDocumentType AS ReversalReferenceDocumentType,
  IndirectTax.GLAccount AS GLAccount,
  IndirectTax.TransactionTypeDetermination AS TransactionTypeDetermination,
  IndirectTax.ConditionType AS ConditionType,
  IndirectTax.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  IndirectTax.TaxRate AS TaxRate,
  IndirectTax.TaxItemIsReportingRelevant AS TaxItemIsReportingRelevant,
  IndirectTax.PostingDate AS PostingDate,
  IndirectTax.DocumentDate AS DocumentDate,
  IndirectTax.TaxFulfillmentDate AS TaxFulfillmentDate,
  IndirectTax.TaxReportingDate AS TaxReportingDate,
  IndirectTax.TaxItemGroup AS TaxItemGroup,
  IndirectTax.DebitCreditCode AS DebitCreditCode,
  IndirectTax.AccountingDocumentType AS AccountingDocumentType,
  IndirectTax.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  IndirectTax.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  IndirectTax.CompanyCodeCurrency AS CompanyCodeCurrency,
  IndirectTax.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  IndirectTax.TaxAmountInTransCrcy AS TaxAmountInTransCrcy,
  IndirectTax.TransactionCurrency AS TransactionCurrency,
  IndirectTax.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  IndirectTax.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  IndirectTax.ReportingCurrency AS ReportingCurrency,
  IndirectTax.TaxCode AS TaxCode,
  IndirectTax.CreationDateTime AS CreationDateTime,
  IndirectTax.CreatedByUser AS CreatedByUser,
  IndirectTax.TaxItemAcctgDocItemRef AS TaxItemAcctgDocItemRef,
  IndirectTax._CompanyCodeCurrency AS _CompanyCodeCurrency,
  IndirectTax._TransactionCurrency AS _TransactionCurrency,
  IndirectTax._ReportingCurrency AS _ReportingCurrency,
  IndirectTax._ReferenceDocumentType AS _ReferenceDocumentType,
  IndirectTax._RefDocumentLogicalSystem AS _RefDocumentLogicalSystem
FROM I_TxRegIndirectTaxJournalEntry AS IndirectTax
;

Learn More