P_AU_STRPPAYTTMESRPTGPartPay

DDL: P_AU_STRPPAYTTMESRPTGPARTPAY Type: view_entity COMPOSITE Package: GLO_FIN_IS_AU

View for exposing the credit memos

P_AU_STRPPAYTTMESRPTGPartPay is a Composite CDS View that provides data about "View for exposing the credit memos" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 6 fields. Part of development package GLO_FIN_IS_AU.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem doc from

Parameters (3)

NameTypeDefault
P_AU_InvoiceIssueDateType fiau_invoice_issue_date_type
P_FromReportingDate figen_rep_date_from
P_ToReportingDate figen_rep_date_to

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode
InvoiceReference InvoiceReference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear
CompanyCodeCurrency CompanyCodeCurrency
AmountInCompanyCodeCurrency
CashDiscountAmtInCoCodeCrcy 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity P_AU_STRPPAYTTMESRPTGPartPay
  with parameters
    P_AU_InvoiceIssueDateType : fiau_invoice_issue_date_type,
    //P_OffsetDays              : fiau_offset_days,

    P_FromReportingDate       : figen_rep_date_from,
    P_ToReportingDate         : figen_rep_date_to
  as select from I_OperationalAcctgDocItem as doc
{
  CompanyCode,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  CompanyCodeCurrency,
  @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
  sum(AmountInCompanyCodeCurrency) * -1 as AmountInCompanyCodeCurrency,
  @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
  sum(CashDiscountAmtInCoCodeCrcy) * -1 as CashDiscountAmtInCoCodeCrcy
}
where
          (
               doc.PostingDate                not between $parameters.P_FromReportingDate and $parameters.P_ToReportingDate and
               doc.SpecialGLTransactionType = '' and // Clear Partial Payments

               doc.SpecialGLCode = '' and
               doc.InvoiceReference <> '' and
               doc.InvoiceReferenceFiscalYear <> '0000' and
               doc.InvoiceItemReference <> '000' and
               doc.ClearingAccountingDocument <> '' and
          (doc.FollowOnDocumentType = 'Z' or doc.FollowOnDocumentType = 'P'))
group by
  CompanyCode,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  CompanyCodeCurrency

Learn More