P_RU_INVOICECLEARING7

CDS View

P_RU_INVOICECLEARING7 is a CDS View in S/4HANA. 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

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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_RU_INVOICECLEARING3",
"P_RU_INVOICECLEARING4",
"P_RU_INVOICECLEARING5",
"P_RU_INVOICECLEARING6"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More