P_RU_TaxItemIsNegativePosting

DDL: P_RU_TAXITEMISNEGATIVEPOSTING SQL: PRUTAXITEMISNP Type: view CONSUMPTION Package: GLO_FIN_IS_RU
35 Fields 2 Data Sources

RU Tax Item with Negative Posting indicator

P_RU_TaxItemIsNegativePosting is a Consumption CDS View that provides data about "RU Tax Item with Negative Posting indicator" in SAP S/4HANA. It reads from 2 data sources (P_RU_BSET, P_RU_BSET) and exposes 35 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocument, FiscalYear. Part of development package GLO_FIN_IS_RU.

Data Sources (2)

SourceAliasJoin Type
P_RU_BSET TaxItem from
P_RU_BSET TaxItem union_all

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUTAXITEMISNP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_RU_BSET CompanyCode Receiver Company Code
KEY AccountingDocument P_RU_BSET AccountingDocument Journal Entry
KEY FiscalYear P_RU_BSET FiscalYear G/L Fiscal Year
TaxItem P_RU_BSET TaxItem Tax Item
TaxCode P_RU_BSET TaxCode Tax Code
GLAccount P_RU_BSET GLAccount General Ledger
TaxItemGroup2 P_RU_BSET TaxItemGroup2 Tax off grpg
TaxItemGroup P_RU_BSET TaxItemGroup2 Tax off grpg
TaxRate P_RU_BSET TaxRate Tax Rate
TransactionTypeDetermination P_RU_BSET TransactionTypeDetermination Transaction Key
DebitCreditCode P_RU_BSET DebitCreditCode Single-Character Flag
TaxJurisdiction P_RU_BSET TaxJurisdiction Tax Jurisdiction
TaxCountry P_RU_BSET TaxCountry Tax Ctry/Reg.
TaxAmountInCoCodeCrcy P_RU_BSET TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy P_RU_BSET TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmount P_RU_BSET TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInTransCrcy P_RU_BSET TaxBaseAmountInTransCrcy Value-Added Tax
CompanyCode Receiver Company Code
KEY AccountingDocument P_RU_BSET AccountingDocument Journal Entry
KEY FiscalYear P_RU_BSET FiscalYear G/L Fiscal Year
TaxItem P_RU_BSET TaxItem Tax Item
TaxCode P_RU_BSET TaxCode Tax Code
GLAccount P_RU_BSET GLAccount General Ledger
TaxItemGroup2 P_RU_BSET TaxItemGroup2 Tax off grpg
TaxItemGroup P_RU_BSET TaxItemGroup2 Tax off grpg
TaxRate P_RU_BSET TaxRate Tax Rate
TransactionTypeDetermination P_RU_BSET TransactionTypeDetermination Transaction Key
DebitCreditCode P_RU_BSET DebitCreditCode Single-Character Flag
TaxJurisdiction P_RU_BSET TaxJurisdiction Tax Jurisdiction
TaxCountry P_RU_BSET TaxCountry Tax Ctry/Reg.
TaxAmountInCoCodeCrcy P_RU_BSET TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy P_RU_BSET TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmount P_RU_BSET TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInTransCrcy P_RU_BSET TaxBaseAmountInTransCrcy Value-Added Tax
IsNegativePosting BsegTaxItemNegPost IsNegativePosting Negative Posting

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_RU_TaxItemIsNegativePosting.
-- 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: PRUTAXITEMISNP

CREATE VIEW P_RU_TaxItemIsNegativePosting AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.GLAccount AS GLAccount,
  TaxItem.TaxItemGroup2 AS TaxItemGroup2,
  TaxItem.TaxItemGroup2 AS TaxItemGroup,
  TaxItem.TaxRate AS TaxRate,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxItem.DebitCreditCode AS DebitCreditCode,
  TaxItem.TaxJurisdiction AS TaxJurisdiction,
  TaxItem.TaxCountry AS TaxCountry,
  TaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  TaxItem.TaxAmount AS TaxAmount,
  TaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  BsegTaxItemNegPost.IsNegativePosting AS IsNegativePosting
FROM P_RU_BSET AS TaxItem
-- UNION ALL with additional select branch(es): P_RU_BSET
;

Learn More