C_APInvcProcessingStatistics

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_APInvcProcessingStatistics.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CAPINVCPRCG
-- Parameters: P_KeyDate : vdm_v_key_date, P_TodayDate : sydate, P_Language : sylangu, P_IsCurrentFiscalPeriod : char1, P_FiscalPeriodStartDate : sydate

CREATE VIEW C_APInvcProcessingStatistics AS
SELECT
  lookupEntity: 'C_APMinFiscalPeriodStartDate' AS lookupEntityC_APMinFiscalPeriodStartDate,
  resultElement: 'FiscalPeriodStartDate' AS resultElementFiscalPeriodStartDate,
  binding: [{ targetParameter: 'P_TodayDate', type : #SYSTEM_FIELD, value : '#SYSTEM_DATE' AS P_KeyDate,
  P_TodayDate: $parameters.P_TodayDate AS P_TodayDate,
  P_Language: $parameters.P_Language AS P_Language,
  AccountingDocument,
  FiscalYear,
  cast(FiscalYearPeriod as fincs_fiscalyearperiod) AS FiscalYearPeriod,
  SupplierBasicAuthorizationGrp,
  FinancialAccountType,
  Supplier,
  SupplierCountry,
  SupplierFinsAuthorizationGrp,
  AccountingClerk,
  cast (ReconciliationAccount as farp_akont ) AS ReconciliationAccount,
  cast(concat( concat( right( FiscalYearPeriod, 2 ), '.'), left( FiscalYearPeriod, 4 ) ) as cacsmonthyear) AS YearMonth,
  fltp_to_dec( FromIssuedToPostedDays as abap.dec(10,2) ) AS FromIssuedToPostedDays,
  fltp_to_dec( FromDueToPayDays as abap.dec(10,2) ) AS FromDueToPayDays,
  fltp_to_dec( FromParkedToPostedDays as abap.dec(10,2) ) AS FromParkedToPostedDays,
  cast('' as char20) AS DataPeriodName,
  cast('' as char20) AS SAPObjectCategoryName,
  cast('' as char20) AS FromParkedToPostedDaysCatName,
  cast('1' as abap.int4) AS NumberOfInvoices,
  IsCleared,
  IsParked,
  PostingDate,
  BusinessArea,
  Debtor,
  AccountingDocumentType
FROM I_APInvcProcessingStatistics
;