P_PH_NotExcd1PMTaxItemTDT

DDL: P_PH_NOTEXCD1PMTAXITEMTDT SQL: PPHNEXCD1PMITMT Type: view COMPOSITE
40 Fields 2 Data Sources

P_PH_NotExcd1PMTaxItemTDT is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_PH_CapitalGoodsItemTDT, P_PH_MonthNotExceeding1PMTDT) and exposes 40 fields with key fields CompanyCode, CompanyCode2, AccountingDocument, FiscalYear, TaxItem.

Data Sources (2)

SourceAliasJoin Type
P_PH_CapitalGoodsItemTDT P_PH_CapitalGoodsItemTDT from
P_PH_MonthNotExceeding1PMTDT P_PH_MonthNotExceeding1PMTDT inner

Parameters (6)

NameTypeDefault
P_Language sylangu
P_CompanyCode fis_bukrs
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1

Annotations (10)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PPHNEXCD1PMITMT 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 (40)

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 TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate
KEY TaxBoxStructureType TaxBoxStructureType
KEY TaxGroup TaxGroup Tax Group
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate
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
TaxRateValidityStartDate TaxRateValidityStartDate Tax Rate Validity Start Date
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_NotExcd1PMTaxItemTDT.
-- 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: PPHNEXCD1PMITMT
-- Parameters: P_Language : sylangu, P_CompanyCode : fis_bukrs, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1

CREATE VIEW P_PH_NotExcd1PMTaxItemTDT 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,
  TaxBoxStrucValidityStartDate,
  TaxBoxStructureType,
  TaxGroup,
  TaxBoxStrucValidityEndDate,
  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,
  TaxRateValidityStartDate,
  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_CapitalGoodsItemTDT
INNER JOIN P_PH_MonthNotExceeding1PMTDT ON /* join condition not captured in parsed metadata */
;

Learn More