P_PH_InputTaxAllocation

DDL: P_PH_INPUTTAXALLOCATION SQL: PPHALLOCINPTTAX Type: view COMPOSITE Package: GLO_FIN_IS_VAT_PH
14 Fields 2 Data Sources

Calculate Input Tax Allocation

P_PH_InputTaxAllocation is a Composite CDS View that provides data about "Calculate Input Tax Allocation" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountInCompanyCode, I_OperationalAcctgDocItem) and exposes 14 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. Part of development package GLO_FIN_IS_VAT_PH.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountInCompanyCode GLAccountInCompanyCode left_outer
I_OperationalAcctgDocItem OperationalAcctgDocItem from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPHALLOCINPTTAX view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
TaxType I_OperationalAcctgDocItem TaxType Tax Type
TaxCode I_OperationalAcctgDocItem TaxCode Tax Code
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency Local Crcy Amt
TransactionTypeDetermination I_OperationalAcctgDocItem TransactionTypeDetermination Transaction Key
GLAccount I_OperationalAcctgDocItem GLAccount General Ledger
Supplier I_OperationalAcctgDocItem Supplier Supplier
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
DocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
Currency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
TaxCategory I_GLAccountInCompanyCode TaxCategory Tax Code

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_InputTaxAllocation.
-- 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: PPHALLOCINPTTAX

CREATE VIEW P_PH_InputTaxAllocation AS
SELECT
  OperationalAcctgDocItem.CompanyCode AS CompanyCode,
  OperationalAcctgDocItem.AccountingDocument AS AccountingDocument,
  OperationalAcctgDocItem.FiscalYear AS FiscalYear,
  OperationalAcctgDocItem.AccountingDocumentItem AS AccountingDocumentItem,
  OperationalAcctgDocItem.TaxType AS TaxType,
  OperationalAcctgDocItem.TaxCode AS TaxCode,
  OperationalAcctgDocItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  OperationalAcctgDocItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  OperationalAcctgDocItem.GLAccount AS GLAccount,
  OperationalAcctgDocItem.Supplier AS Supplier,
  OperationalAcctgDocItem.PostingDate AS PostingDate,
  OperationalAcctgDocItem.DocumentDate AS DocumentDate,
  OperationalAcctgDocItem.CompanyCodeCurrency AS Currency,
  GLAccountInCompanyCode.TaxCategory AS TaxCategory
FROM I_OperationalAcctgDocItem AS OperationalAcctgDocItem
LEFT OUTER JOIN I_GLAccountInCompanyCode AS GLAccountInCompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More