P_PH_InputTaxAllocation

DDL: P_PH_INPUTTAXALLOCATION SQL: PPHALLOCINPTTAX Type: view COMPOSITE

P_PH_InputTaxAllocation is a Composite CDS View 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.

2 data source(s) 14 fields

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
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem
TaxType I_OperationalAcctgDocItem TaxType
TaxCode I_OperationalAcctgDocItem TaxCode
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency
TransactionTypeDetermination I_OperationalAcctgDocItem TransactionTypeDetermination
GLAccount I_OperationalAcctgDocItem GLAccount
Supplier I_OperationalAcctgDocItem Supplier
PostingDate I_OperationalAcctgDocItem PostingDate
DocumentDate I_OperationalAcctgDocItem DocumentDate
Currency I_OperationalAcctgDocItem CompanyCodeCurrency
TaxCategory I_GLAccountInCompanyCode TaxCategory 
@AbapCatalog.sqlViewName: 'PPHALLOCINPTTAX'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_PH_InputTaxAllocation
as select from I_OperationalAcctgDocItem as OperationalAcctgDocItem
left outer join I_GLAccountInCompanyCode as GLAccountInCompanyCode on OperationalAcctgDocItem.CompanyCode = GLAccountInCompanyCode.CompanyCode
and OperationalAcctgDocItem.GLAccount = GLAccountInCompanyCode.GLAccount

 {
key OperationalAcctgDocItem.CompanyCode,
key OperationalAcctgDocItem.AccountingDocument,
key OperationalAcctgDocItem.FiscalYear,
key OperationalAcctgDocItem.AccountingDocumentItem,
OperationalAcctgDocItem.TaxType,
OperationalAcctgDocItem.TaxCode,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'Currency'} }
OperationalAcctgDocItem.AmountInCompanyCodeCurrency,
OperationalAcctgDocItem.TransactionTypeDetermination,
OperationalAcctgDocItem.GLAccount,
OperationalAcctgDocItem.Supplier,
OperationalAcctgDocItem.PostingDate,
OperationalAcctgDocItem.DocumentDate,
@Semantics.currencyCode: true
OperationalAcctgDocItem.CompanyCodeCurrency as Currency,
GLAccountInCompanyCode.TaxCategory as TaxCategory
 
}where GLAccountInCompanyCode.TaxCategory = '<'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTINCOMPANYCODE",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More