P_PH_ClearingDocTaxInfo

DDL: P_PH_CLEARINGDOCTAXINFO SQL: PPHCLEARINGDOC Type: view COMPOSITE

P_PH_ClearingDocTaxInfo is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_AccountingDocument, I_OperationalAcctgDocItem, P_PH_ClearingDocTaxAmount, P_PH_PRWithholdingTax) and exposes 16 fields with key fields CompanyCode, FiscalYear, AccountingDocument.

4 data source(s) 16 fields

Data Sources (4)

SourceAliasJoin Type
I_AccountingDocument AccountingDocument left_outer
I_OperationalAcctgDocItem GLAccountLineItem from
P_PH_ClearingDocTaxAmount TaxInfo left_outer
P_PH_PRWithholdingTax Withholdingtax left_outer

Annotations (7)

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

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem
DocumentDate I_OperationalAcctgDocItem DocumentDate
AmountInTransactionCurrency
Currency I_OperationalAcctgDocItem TransactionCurrency
ClearingAccountingDocument I_OperationalAcctgDocItem ClearingJournalEntry
AlternativeReferenceDocument I_AccountingDocument DocumentReferenceID
ExemptTaxBaseAmtInCoCodeCrcy
ZeroTaxBaseAmountInCoCodeCrcy
TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy
SalesAmtInCompanyCodeCurrency
TotalGrossAmount
WhldgTaxAmtInTransacCrcy P_PH_PRWithholdingTax WhldgTaxAmtInTransacCrcy 
@AbapCatalog.sqlViewName: 'PPHCLEARINGDOC'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@VDM.private: true
define view P_PH_ClearingDocTaxInfo
 as select from    I_OperationalAcctgDocItem  as GLAccountLineItem

    left outer join P_PH_ClearingDocTaxAmount as TaxInfo            on  GLAccountLineItem.AccountingDocument = TaxInfo.AccountingDocument
                                                                     and GLAccountLineItem.CompanyCode        = TaxInfo.CompanyCode
                                                                     and GLAccountLineItem.FiscalYear         = TaxInfo.FiscalYear
                                                                     and ( GLAccountLineItem.Supplier  = TaxInfo.Supplier
                                                                     or GLAccountLineItem.Customer  = TaxInfo.Customer)
    left outer join P_PH_PRWithholdingTax      as Withholdingtax     on  GLAccountLineItem.AccountingDocument = Withholdingtax.AccountingDocument
                                                                     and GLAccountLineItem.CompanyCode        = Withholdingtax.CompanyCode
                                                                     and GLAccountLineItem.FiscalYear         = Withholdingtax.FiscalYear
                                                                     and GLAccountLineItem.AccountingDocumentItem  = Withholdingtax.AccountingDocumentItem
    left outer join I_AccountingDocument       as AccountingDocument on  AccountingDocument.CompanyCode        = GLAccountLineItem.CompanyCode
                                                                     and AccountingDocument.AccountingDocument = GLAccountLineItem.AccountingDocument
                                                                     and AccountingDocument.FiscalYear         = GLAccountLineItem.FiscalYear
{
  key   GLAccountLineItem.CompanyCode,
  key   GLAccountLineItem.FiscalYear,
  key   GLAccountLineItem.AccountingDocument,
        GLAccountLineItem.AccountingDocumentItem,
        GLAccountLineItem.DocumentDate,
        abs(GLAccountLineItem.AmountInTransactionCurrency)                                                                                                                                                                                                                                                                                                                                                                                           as     AmountInTransactionCurrency,
        GLAccountLineItem.TransactionCurrency                                                                                                                                                                                                                                                                                                                                                                                                        as     Currency,
        //to be fixed

        GLAccountLineItem.ClearingJournalEntry as ClearingAccountingDocument,
        AccountingDocument.DocumentReferenceID                                                                                                                                                                                                                                                                                                                                                                                                       as     AlternativeReferenceDocument,
        cast (0 - ExemptTaxBaseAmtInCoCodeCrcy as hwbas)                                                                                                                                                                                                                                                                                                                                                                                             as     ExemptTaxBaseAmtInCoCodeCrcy,

        cast (0 - ZeroTaxBaseAmountInCoCodeCrcy as hwbas)                                                                                                                                                                                                                                                                                                                                                                                            as     ZeroTaxBaseAmountInCoCodeCrcy,

        cast(0 - TaxInfo.TaxBaseAmountInCoCodeCrcy as hwbas)                                                                                                                                                                                                                                                                                                                                                                                         as     TaxBaseAmountInCoCodeCrcy,

        cast(0 - TaxInfo.TaxAmountInCoCodeCrcy as hwbas)                                                                                                                                                                                                                                                                                                                                                                                             as     TaxAmountInCoCodeCrcy,

        cast(0 - ExemptTaxBaseAmtInCoCodeCrcy - ZeroTaxBaseAmountInCoCodeCrcy - TaxInfo.TaxBaseAmountInCoCodeCrcy  as hwbas)                                                                                                                                                                                                                                                                                                                         as     SalesAmtInCompanyCodeCurrency,
        cast(0 - ExemptTaxBaseAmtInCoCodeCrcy - ZeroTaxBaseAmountInCoCodeCrcy - TaxInfo.TaxBaseAmountInCoCodeCrcy - TaxInfo.TaxAmountInCoCodeCrcy  as hwbas)                                                                                                                                                                                                                                                                                         as     TotalGrossAmount,

        Withholdingtax.WhldgTaxAmtInTransacCrcy
}
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENT",
"I_OPERATIONALACCTGDOCITEM",
"P_PH_CLEARINGDOCTAXAMOUNT",
"P_PH_PRWITHHOLDINGTAX"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More