P_PH_PRWithhodlingTaxInfo1

DDL: P_PH_PRWITHHODLINGTAXINFO1 SQL: PPAYTRWITHTAX1 Type: view COMPOSITE

P_PH_PRWithhodlingTaxInfo1 is a Composite CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 24 fields with key fields WorkItemUUID, PaymentReceiptUUID, PaymentReceiptUUID, PaymentReceiptUUID.

6 data source(s) 24 fields

Data Sources (6)

SourceAliasJoin Type
I_PaymentReceiptRelatedDoc docItem from
I_PaymentReceiptRelatedDoc docItem union_all
I_PaymentReceiptRelatedDoc docItem union_all
I_OperationalAcctgDocItem GLAccountLineItem inner
I_OperationalAcctgDocItem GLAccountLineItem inner
I_OperationalAcctgDocItem GLAccountLineItem inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPAYTRWITHTAX1 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 (24)

KeyFieldSource TableSource FieldDescription
KEY WorkItemUUID I_PaymentReceiptRelatedDoc WorkItemUUID
KEY PaymentReceiptUUID I_PaymentReceiptRelatedDoc PaymentReceiptUUID
Ledger I_PaymentReceiptRelatedDoc Ledger
AccountingDocument I_PaymentReceiptRelatedDoc AccountingDocument
LedgerGLLineItem I_PaymentReceiptRelatedDoc LedgerGLLineItem
CompanyCode I_PaymentReceiptRelatedDoc CompanyCode
FiscalYear I_PaymentReceiptRelatedDoc FiscalYear
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency
WorkItemUUID
KEY PaymentReceiptUUID I_PaymentReceiptRelatedDoc PaymentReceiptUUID
Ledger I_PaymentReceiptRelatedDoc Ledger
AccountingDocument I_PaymentReceiptRelatedDoc AccountingDocument
LedgerGLLineItem I_PaymentReceiptRelatedDoc LedgerGLLineItem
CompanyCode I_PaymentReceiptRelatedDoc CompanyCode
FiscalYear I_PaymentReceiptRelatedDoc FiscalYear
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency
WorkItemUUID
KEY PaymentReceiptUUID I_PaymentReceiptRelatedDoc PaymentReceiptUUID
Ledger I_PaymentReceiptRelatedDoc Ledger
AccountingDocument I_PaymentReceiptRelatedDoc AccountingDocument
LedgerGLLineItem I_PaymentReceiptRelatedDoc LedgerGLLineItem
CompanyCode I_PaymentReceiptRelatedDoc CompanyCode
FiscalYear I_PaymentReceiptRelatedDoc FiscalYear
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency 
@AbapCatalog.sqlViewName: 'PPAYTRWITHTAX1'
@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_PRWithhodlingTaxInfo1 as select from I_PaymentReceiptRelatedDoc as docItem
    inner join I_OperationalAcctgDocItem  as GLAccountLineItem              on docItem.AccountingDocument    = GLAccountLineItem.AccountingDocument
                                                                           and docItem.LedgerGLLineItem      = GLAccountLineItem.AccountingDocumentItem
                                                                           and docItem.CompanyCode           = GLAccountLineItem.CompanyCode
                                                                           and docItem.FiscalYear            = GLAccountLineItem.FiscalYear
    left outer to one join P_PH_PRWithholdingTax      as Withholdingtax     on docItem.AccountingDocument = Withholdingtax.AccountingDocument
                                                                           and docItem.CompanyCode        = Withholdingtax.CompanyCode
                                                                           and docItem.FiscalYear         = Withholdingtax.FiscalYear
                                                                           and docItem.LedgerGLLineItem   = Withholdingtax.AccountingDocumentItem
{
      key docItem.WorkItemUUID,
      key docItem.PaymentReceiptUUID,
      docItem.Ledger,
      docItem.AccountingDocument,
      docItem.LedgerGLLineItem     as LedgerGLLineItem,
      docItem.CompanyCode,
      docItem.FiscalYear,
      GLAccountLineItem.TransactionCurrency,
      case when Withholdingtax.WhldgTaxAmtInTransacCrcy < 0
        then cast( 0 as fis_wsl )
        else Withholdingtax.WhldgTaxAmtInTransacCrcy  
      end as WhldgTaxAmtInTransacCrcy                                                                                                                                                                                                                                                                                                                      
}
//pick the payment part withholding tax

union all select from    I_PaymentReceiptRelatedDoc as docItem
    inner join I_OperationalAcctgDocItem  as GLAccountLineItem              on docItem.AccountingDocument    = GLAccountLineItem.AccountingDocument
                                                                           and docItem.LedgerGLLineItem      = GLAccountLineItem.AccountingDocumentItem
                                                                           and docItem.CompanyCode           = GLAccountLineItem.CompanyCode
                                                                           and docItem.FiscalYear            = GLAccountLineItem.FiscalYear
                                                                           and docItem.AccountingDocument    <> GLAccountLineItem.ClearingJournalEntry
    left outer to one join P_PH_PRWithholdingTax      as Withholdingtax     on GLAccountLineItem.ClearingJournalEntry = Withholdingtax.AccountingDocument
                                                                           and docItem.CompanyCode        = Withholdingtax.CompanyCode
                                                                           and docItem.FiscalYear         = Withholdingtax.FiscalYear
{
      key docItem.WorkItemUUID,
      key docItem.PaymentReceiptUUID,
      docItem.Ledger,
      docItem.AccountingDocument,
      docItem.LedgerGLLineItem     as LedgerGLLineItem,
      docItem.CompanyCode,
      docItem.FiscalYear,
      GLAccountLineItem.TransactionCurrency,
      case when Withholdingtax.WhldgTaxAmtInTransacCrcy < 0
        then cast( 0 as fis_wsl )
        else Withholdingtax.WhldgTaxAmtInTransacCrcy  
      end as WhldgTaxAmtInTransacCrcy
}
//pick the invoice part withholding tax 

union all select from    I_PaymentReceiptRelatedDoc as docItem
    inner join I_OperationalAcctgDocItem  as GLAccountLineItem              on docItem.AccountingDocument   = GLAccountLineItem.ClearingJournalEntry
                                                                           and docItem.CompanyCode          = GLAccountLineItem.CompanyCode
                                                                           and docItem.FiscalYear           = GLAccountLineItem.FiscalYear
                                                                           and docItem.AccountingDocument    <> GLAccountLineItem.AccountingDocument
    left outer to one join P_PH_PRWithholdingTax      as Withholdingtax     on GLAccountLineItem.AccountingDocument = Withholdingtax.AccountingDocument
                                                                           and docItem.CompanyCode        = Withholdingtax.CompanyCode
                                                                           and docItem.FiscalYear         = Withholdingtax.FiscalYear
{
      key docItem.WorkItemUUID,
      key docItem.PaymentReceiptUUID,
      docItem.Ledger,
      docItem.AccountingDocument,
      docItem.LedgerGLLineItem     as LedgerGLLineItem,
      docItem.CompanyCode,
      docItem.FiscalYear,
      GLAccountLineItem.TransactionCurrency,
      case when Withholdingtax.WhldgTaxAmtInTransacCrcy < 0
        then cast( 0 as fis_wsl )
        else Withholdingtax.WhldgTaxAmtInTransacCrcy  
      end as WhldgTaxAmtInTransacCrcy
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONALACCTGDOCITEM",
"I_PAYMENTRECEIPTRELATEDDOC",
"P_PH_PRWITHHOLDINGTAX"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More