P_RU_INVOICECLEARING7

CDS View

Invoice Partial Clearing 2

P_RU_INVOICECLEARING7 is a CDS View in S/4HANA. Invoice Partial Clearing 2. It contains 5 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 5 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RU_InvoiceClearing view from CONSUMPTION Invoice Clearing

Fields (5)

KeyField CDS FieldsUsed in Views
ChildDocument Payment 1
ChildDocumentFiscalYear PaymentFiscalYear 1
CompanyCode CompanyCode 1
Invoice Invoice 1
InvoiceFiscalYear InvoiceFiscalYear 1 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUINVOICECLR07'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
-- Partial Clearing: Payment - Clearing - Clearing - Invoice
define view P_RU_InvoiceClearing7
  as

  -- Invoice Clearing 1st level
  select from P_RU_InvoiceClearing3

{
  CompanyCode,
  Invoice,
  InvoiceFiscalYear,
  //ExternalInvoice,

  //InvoiceDate,

  ChildDocument,
  ChildDocumentFiscalYear
}
where
     Invoice           <> ChildDocument
  or InvoiceFiscalYear <> ChildDocumentFiscalYear

union all

-- Full Clearing: Payment - Clearing - Clearing - Invoice
select from P_RU_InvoiceClearing4

{
  CompanyCode,
  Invoice,
  InvoiceFiscalYear,
  //ExternalInvoice,

  //InvoiceDate,

  ChildDocument,
  ChildDocumentFiscalYear
}

union all

-- Partial Clearing: Payment - Clearing - Clearing - Invoice
select from P_RU_InvoiceClearing5

{
  CompanyCode,
  Invoice,
  InvoiceFiscalYear,
  //ExternalInvoice,

  //InvoiceDate,

  ChildDocument,
  ChildDocumentFiscalYear
}

union all

-- Partial Clearing: Payment - Clearing - Clearing - Invoice
select from P_RU_InvoiceClearing6

{
  CompanyCode,
  Invoice,
  InvoiceFiscalYear,
  //ExternalInvoice,

  //InvoiceDate,

  ChildDocument,
  ChildDocumentFiscalYear
}

Learn More