I_APDaysPyblOutStdgIndrctCube

DDL: I_APDAYSPYBLOUTSTDGINDRCTCUBE SQL: IAPDPOIND Type: view COMPOSITE
20 Fields 1 Data Sources

Overview Page DPO Ind - Cube

I_APDaysPyblOutStdgIndrctCube is a Composite CDS View (Cube) that provides data about "Overview Page DPO Ind - Cube" in SAP S/4HANA. It reads from 1 data source (I_DaysPayablesOutstanding) and exposes 20 fields with key fields CompanyCode, Supplier, CalendarYear, CalendarMonth, GLAccount.

Data Sources (1)

SourceAliasJoin Type
I_DaysPayablesOutstanding I_DaysPayablesOutstanding from

Parameters (5)

NameTypeDefault
P_PyblsRollingAverageMonths fis_pybls_rolling_avg_months
P_PurRollingAverageMonths fis_pur_rolling_avg_months
P_TodayDate sydate
P_DisplayCurrency vdm_v_display_currency
P_ExchangeRateType kurst

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IAPDPOIND view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Overview Page DPO Ind - Cube view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Metadata.allowExtensions true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY Supplier Supplier Supplier
KEY CalendarYear CalendarYear Year
KEY CalendarMonth CalendarMonth Calendar Month
KEY GLAccount GLAccount General Ledger
KEY SpecialGLCode SpecialGLCode Special G/L Ind
KEY FinancialAccountType FinancialAccountType Fin. Account Type
YearMonth YearMonth Year Month
ExchangeRateType ExchangeRateType Exch. Rate Type
SupplierCountry SupplierCountry
SupplierRegion SupplierRegion
AccountingClerk AccountingClerk Clerk Abbrev.
ReconciliationAccount ReconciliationAccount Recon. account
DurationUnit DurationUnit Unit
SupplierAccountGroup SupplierAccountGroup Account group
AuthorizationGroup AuthorizationGroup AuthorizGroup
SupplierFinsAuthorizationGrp SupplierFinsAuthorizationGrp AuthorizGroup
DisplayCurrency DisplayCurrency Display Currency
CreditAmtInDisplayCrcy CreditAmtInDisplayCrcy
PurchaseAmtInDisplayCrcy PurchaseAmtInDisplayCrcy

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 I_APDaysPyblOutStdgIndrctCube.
-- 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: IAPDPOIND
-- Parameters: P_PyblsRollingAverageMonths : fis_pybls_rolling_avg_months, P_PurRollingAverageMonths : fis_pur_rolling_avg_months, P_TodayDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst

CREATE VIEW I_APDaysPyblOutStdgIndrctCube AS
SELECT
  CompanyCode,
  Supplier,
  CalendarYear,
  CalendarMonth,
  GLAccount,
  SpecialGLCode,
  FinancialAccountType,
  YearMonth,
  ExchangeRateType,
  SupplierCountry,
  SupplierRegion,
  AccountingClerk,
  ReconciliationAccount,
  DurationUnit,
  SupplierAccountGroup,
  AuthorizationGroup,
  SupplierFinsAuthorizationGrp,
  DisplayCurrency,
  CreditAmtInDisplayCrcy,
  PurchaseAmtInDisplayCrcy
FROM I_DaysPayablesOutstanding
;

Learn More