P_DeftaxInvoice

DDL: P_DEFTAXINVOICE SQL: PDEFTAXINVOICE Type: view COMPOSITE Package: FB_DEFTAX
71 Fields 1 Data Sources

Deferred Tax Invoice Data

P_DeftaxInvoice is a Composite CDS View that provides data about "Deferred Tax Invoice Data" in SAP S/4HANA. It reads from 1 data source (I_JournalEntry) and exposes 71 fields with key fields CompanyCode, FiscalYear, AccountingDocument. Part of development package FB_DEFTAX.

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry I_JournalEntry from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PDEFTAXINVOICE view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (71)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
AccountingDocumentType AccountingDocumentType Journal Entry Type
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
FiscalPeriod FiscalPeriod Tax period
AccountingDocumentCreationDate AccountingDocumentCreationDate Journal Entry Date
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
ExchangeRateDate ExchangeRateDate Translatn Date
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
TransactionCode TransactionCode Transaction Code
IntercompanyTransaction IntercompanyTransaction Intercompany Transaction
DocumentReferenceID DocumentReferenceID Reference
ReverseDocument ReverseDocument Reversed With
ReverseDocumentFiscalYear ReverseDocumentFiscalYear Year
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
TransactionCurrency TransactionCurrency Transaction Currency
ExchangeRate ExchangeRate Exchange rate
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
BusinessTransactionType BusinessTransactionType Bus.transaction
BatchInputSession BatchInputSession Session Name
ReferenceDocumentType ReferenceDocumentType Reference Document Type
OriginalReferenceDocument OriginalReferenceDocument Reference Key
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
ReversalIsPlanned ReversalIsPlanned Reversal Flag
PlannedReversalDate PlannedReversalDate Reversal Date
TaxIsCalculatedAutomatically TaxIsCalculatedAutomatically Tax Is Automatically Calculated
TaxBaseAmountIsNetAmount TaxBaseAmountIsNetAmount Tax Base Amount is Net Amount
SourceCompanyCode SourceCompanyCode Source CoCode
LogicalSystem LogicalSystem Logical System
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
TaxExchangeRate TaxExchangeRate Rate for Taxes
ReversalReason ReversalReason Reversal Reason
Branch Branch Repository branch
Reference1InDocumentHeader Reference1InDocumentHeader Reference 1
Reference2InDocumentHeader Reference2InDocumentHeader Reference 2
InvoiceReceiptDate InvoiceReceiptDate Invoice Receipt Date
Ledger Ledger Ledger
LedgerGroup LedgerGroup Ledger Group
TaxReportingDate TaxReportingDate Tax Reporting Date
AccountingDocumentClass AccountingDocumentClass Document Cat.
ExchangeRateType ExchangeRateType Exch. Rate Type
SenderLogicalSystem SenderLogicalSystem Sender Logical System
SenderCompanyCode SenderCompanyCode Sender Company Code
SenderAccountingDocument SenderAccountingDocument Sender Journal Entry
SenderFiscalYear SenderFiscalYear Sender FiscalYr
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
LatePaymentReason LatePaymentReason Reason f. Delay
SalesDocumentCondition SalesDocumentCondition Doc. Condition
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
_TaxItem _TaxItem
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_AccountingDocumentType _AccountingDocumentType
_CompanyCodeCurrency _CompanyCodeCurrency
_TransactionCurrency _TransactionCurrency
_FiscalPeriod _FiscalPeriod
_AccountingDocumentCategory _AccountingDocumentCategory
_BusinessTransactionType _BusinessTransactionType
_BusinessTransactionTypeText _BusinessTransactionTypeText
_ReferenceDocumentType _ReferenceDocumentType
_LogicalSystem _LogicalSystem
_RefDocumentLogicalSystem _RefDocumentLogicalSystem
_Ledger _Ledger
_LedgerText _LedgerText

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_DeftaxInvoice.
-- 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.
-- SQL view name: PDEFTAXINVOICE

CREATE VIEW P_DeftaxInvoice AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentType,
  DocumentDate,
  PostingDate,
  FiscalPeriod,
  AccountingDocumentCreationDate,
  CreationTime,
  LastChangeDate,
  ExchangeRateDate,
  AccountingDocCreatedByUser,
  TransactionCode,
  IntercompanyTransaction,
  DocumentReferenceID,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  AccountingDocumentHeaderText,
  TransactionCurrency,
  ExchangeRate,
  AccountingDocumentCategory,
  BusinessTransactionType,
  BatchInputSession,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  CompanyCodeCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  ReversalIsPlanned,
  PlannedReversalDate,
  TaxIsCalculatedAutomatically,
  TaxBaseAmountIsNetAmount,
  SourceCompanyCode,
  LogicalSystem,
  ReferenceDocumentLogicalSystem,
  TaxExchangeRate,
  ReversalReason,
  Branch,
  Reference1InDocumentHeader,
  Reference2InDocumentHeader,
  InvoiceReceiptDate,
  Ledger,
  LedgerGroup,
  TaxReportingDate,
  AccountingDocumentClass,
  ExchangeRateType,
  SenderLogicalSystem,
  SenderCompanyCode,
  SenderAccountingDocument,
  SenderFiscalYear,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  LatePaymentReason,
  SalesDocumentCondition,
  IsReversal,
  IsReversed
FROM I_JournalEntry
;

Learn More