I_PT_SAFTPAYTSIGNATURECHECK

CDS View

Payment of digitally signed invoice

I_PT_SAFTPAYTSIGNATURECHECK is a CDS View in S/4HANA. Payment of digitally signed invoice. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_PT_SAFTPaymentDocumentC view_entity inner CONSUMPTION Payment Document Header - Cube
C_PT_SAFTPaytDocHeaderCube view_entity inner CONSUMPTION Payment Header for SAFT PT - Cube
I_PT_SAFTBillgPaytCust view_entity inner COMPOSITE Customer from Payment Document 
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Payment of digitally signed invoice'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
define view entity I_PT_SAFTPaytSignatureCheck
  as select from           I_OplAcctgDocItemClrgHist   as AccDoc
  
    left outer to one join I_PT_AcctgDocDgtlSgntr      as AcctgDgtlSgntr on  AccDoc.ClearedAccountingDocument = AcctgDgtlSgntr.AccountingDocument
                                                                         and AccDoc.ClearedCompanyCode        = AcctgDgtlSgntr.CompanyCode
                                                                         and AccDoc.ClearedFiscalYear         = AcctgDgtlSgntr.FiscalYear
{
  key AccDoc.ClearingCompanyCode as ClearingInfoCompanyCode,
  key AccDoc.ClearingAccountingDocument,
  key AccDoc.ClearingFiscalYear,
  key cast( case when AcctgDgtlSgntr.AccountingDocument is not initial
             then 'X'
             else ' '
           end as boole_d)       as CapacityIsToBeChecked
           
  //    AcctgDgtlSgntr.NumberRangeInterval

}
union select from P_PT_SAFTPaymentOrigDoc     as Orig

//  left outer to one join I_PT_BillgDocDgtlSgntr  as BillDgtlSgntr on  Orig.InvoiceDocumentNumber   = BillDgtlSgntr.BillingDocument

//                                                                  and Orig.ClearingInfoCompanyCode = BillDgtlSgntr.CompanyCode

{
  key Orig.ClearingInfoCompanyCode,
  key Orig.ClearingAccountingDocument,
  key Orig.FiscalYear         as ClearingFiscalYear,
  key cast( case when Orig._BillDgtlSgntr.BillingDocument is not initial
             then 'X'
             else ' '
           end   as boole_d ) as CapacityIsToBeChecked
           
  //    Orig._AcctgDgtlSgntr.NumberRangeInterval

}

Learn More