P_RU_AdvancePaymentDocument

DDL: P_RU_ADVANCEPAYMENTDOCUMENT SQL: PRUADVPAYMENTDOC Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU

Advance Payment Document

P_RU_AdvancePaymentDocument is a Consumption CDS View that provides data about "Advance Payment Document" in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, I_OperationalAcctgDocItem) and exposes 4 fields. Part of development package GLO_FIN_IS_VAT_RU.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from
I_OperationalAcctgDocItem I_OperationalAcctgDocItem union_all

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUADVPAYMENTDOC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode
AccountingDocument AccountingDocument
AccountingDocument InvoiceReference
FiscalYear InvoiceReferenceFiscalYear 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUADVPAYMENTDOC'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_AdvancePaymentDocument
  as select from I_OperationalAcctgDocItem
{
  CompanyCode,
  AccountingDocument,
  FiscalYear
}
where
       SpecialGLTransactionType   =  'A'
  and  ClearingAccountingDocument <> ''
  and  FollowOnDocumentType       =  ''
  and(
       ClearingAccountingDocument <> AccountingDocument
    or ClearingDocFiscalYear      <> FiscalYear
  )



union all select from I_OperationalAcctgDocItem
{
  CompanyCode,
  InvoiceReference                as AccountingDocument,
  InvoiceReferenceFiscalYear      as FiscalYear
}
where
      SpecialGLTransactionType   = 'A'
  and ClearingAccountingDocument = ''

Learn More