P_PH_NotExcd1PMTaxItem

DDL: P_PH_NOTEXCD1PMTAXITEM SQL: PPHNEXCD1PMITM Type: view COMPOSITE Package: GLO_FIN_IS_VAT_PH
38 Fields 2 Data Sources

Schedule 2 for PH VAT

P_PH_NotExcd1PMTaxItem is a Composite CDS View that provides data about "Schedule 2 for PH VAT" in SAP S/4HANA. It reads from 2 data sources (P_PH_CapitalGoodsItem, P_PH_MonthNotExceeding1PM) and exposes 38 fields with key fields CompanyCode, CompanyCode2, AccountingDocument, FiscalYear, TaxItem. Part of development package GLO_FIN_IS_VAT_PH.

Data Sources (2)

SourceAliasJoin Type
P_PH_CapitalGoodsItem P_PH_CapitalGoodsItem from
P_PH_MonthNotExceeding1PM P_PH_MonthNotExceeding1PM inner

Parameters (2)

NameTypeDefault
P_Language sylangu
P_CompanyCode fis_bukrs

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPHNEXCD1PMITM view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #MIXED view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_PH_CapitalGoodsItem CompanyCode Receiver Company Code
KEY CompanyCode2 CompanyCode2 Receiver Company Code
KEY AccountingDocument P_PH_CapitalGoodsItem AccountingDocument Journal Entry
KEY FiscalYear P_PH_CapitalGoodsItem FiscalYear G/L Fiscal Year
KEY TaxItem P_PH_CapitalGoodsItem TaxItem Tax Item
KEY TaxCode P_PH_CapitalGoodsItem TaxCode Tax Code
KEY TransactionTypeDetermination P_PH_CapitalGoodsItem TransactionTypeDetermination Transaction Key
KEY TaxBox P_PH_CapitalGoodsItem TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType TaxDeclnAmountType
KEY TaxItemGroupingVersion TaxItemGroupingVersion Tax Grping Ver.
KEY ValidFrom ValidFrom Vers.Valid From
KEY TaxBoxStructureType TaxBoxStructureType
KEY TaxGroup TaxGroup Tax Group
ReportingDate ReportingDate
PostingDate P_PH_CapitalGoodsItem PostingDate Posting Date for GR
DocumentDate P_PH_CapitalGoodsItem DocumentDate Journal Entry Date
TaxReportingDate TaxReportingDate Tax Reporting Date
FiscalPeriod P_PH_CapitalGoodsItem FiscalPeriod Tax period
TaxJurisdiction P_PH_CapitalGoodsItem TaxJurisdiction Tax Jurisdiction
GLAccount P_PH_CapitalGoodsItem GLAccount General Ledger
BusinessPlace BusinessPlace Business place
TaxRate TaxRate Tax Rate
TaxType P_PH_CapitalGoodsItem TaxType Tax Type
TaxItemGroup P_PH_CapitalGoodsItem TaxItemGroup Tax doc. item number
AccountingDocumentType P_PH_CapitalGoodsItem AccountingDocumentType Journal Entry Type
MasterFixedAsset MasterFixedAsset Fixed Asset
AssetValueDate AssetValueDate Reference date
FixedAsset FixedAsset Sub-number
AssetClass _FixedAsset AssetClass Asset Class
AssetClassName
CompanyCodeCurrency P_PH_CapitalGoodsItem CompanyCodeCurrency Local Currency
DocumentCurrency DocumentCurrency Document Currency
TaxBaseAmountInCoCodeCrcy P_PH_CapitalGoodsItem TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy P_PH_CapitalGoodsItem TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy P_PH_CapitalGoodsItem TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount P_PH_CapitalGoodsItem TaxAmount Tax Amt in Rptg Crcy
ReportingCountry ReportingCountry
_ReportedItemsLog _ReportedItemsLog

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_PH_NotExcd1PMTaxItem.
-- 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: PPHNEXCD1PMITM
-- Parameters: P_Language : sylangu, P_CompanyCode : fis_bukrs

CREATE VIEW P_PH_NotExcd1PMTaxItem AS
SELECT
  P_PH_CapitalGoodsItem.CompanyCode AS CompanyCode,
  CompanyCode2,
  P_PH_CapitalGoodsItem.AccountingDocument AS AccountingDocument,
  P_PH_CapitalGoodsItem.FiscalYear AS FiscalYear,
  P_PH_CapitalGoodsItem.TaxItem AS TaxItem,
  P_PH_CapitalGoodsItem.TaxCode AS TaxCode,
  P_PH_CapitalGoodsItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  P_PH_CapitalGoodsItem.TaxBox AS TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  ValidFrom,
  TaxBoxStructureType,
  TaxGroup,
  ReportingDate,
  P_PH_CapitalGoodsItem.PostingDate AS PostingDate,
  P_PH_CapitalGoodsItem.DocumentDate AS DocumentDate,
  TaxReportingDate,
  P_PH_CapitalGoodsItem.FiscalPeriod AS FiscalPeriod,
  P_PH_CapitalGoodsItem.TaxJurisdiction AS TaxJurisdiction,
  P_PH_CapitalGoodsItem.GLAccount AS GLAccount,
  BusinessPlace,
  TaxRate,
  P_PH_CapitalGoodsItem.TaxType AS TaxType,
  P_PH_CapitalGoodsItem.TaxItemGroup AS TaxItemGroup,
  P_PH_CapitalGoodsItem.AccountingDocumentType AS AccountingDocumentType,
  MasterFixedAsset,
  AssetValueDate,
  FixedAsset,
  _FixedAsset.AssetClass AS AssetClass,
  _FixedAsset._AssetClass._Text[1:Language = $parameters.P_Language].AssetClassName AS AssetClassName,
  P_PH_CapitalGoodsItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  DocumentCurrency,
  P_PH_CapitalGoodsItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_PH_CapitalGoodsItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  P_PH_CapitalGoodsItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  P_PH_CapitalGoodsItem.TaxAmount AS TaxAmount,
  ReportingCountry
FROM P_PH_CapitalGoodsItem
INNER JOIN P_PH_MonthNotExceeding1PM ON /* join condition not captured in parsed metadata */
;

Learn More