P_CCLdngLdgrPerDates

DDL: P_CCLDNGLDGRPERDATES SQL: PCCLLPDATES Type: view BASIC
5 Fields 5 Data Sources

P_CCLdngLdgrPerDates is a Basic CDS View in SAP S/4HANA. It reads from 5 data sources (P_CompanyCodePeriods, I_Ledger, I_LedgerCompanyCodeCrcyRoles, I_FiscalPeriodForVariant, I_FiscalPeriodForVariant) and exposes 5 fields with key field CompanyCode.

Data Sources (5)

SourceAliasJoin Type
P_CompanyCodePeriods ccp from
I_Ledger ld inner
I_LedgerCompanyCodeCrcyRoles ldcmp inner
I_FiscalPeriodForVariant lffp inner
I_FiscalPeriodForVariant vmfp inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCCLLPDATES view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_CompanyCodePeriods CompanyCode Receiver Company Code
CurrentFiscalPeriodStartDate I_FiscalPeriodForVariant FiscalPeriodStartDate Start Date
CurrentFiscalPeriodEndDate I_FiscalPeriodForVariant FiscalPeriodEndDate End Date
PreviousFiscalPeriodStartDate I_FiscalPeriodForVariant FiscalPeriodStartDate Start Date
PreviousFiscalPeriodEndDate I_FiscalPeriodForVariant FiscalPeriodEndDate End Date

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 P_CCLdngLdgrPerDates.
-- 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: PCCLLPDATES

CREATE VIEW P_CCLdngLdgrPerDates AS
SELECT
  ccp.CompanyCode AS CompanyCode,
  lffp.FiscalPeriodStartDate AS CurrentFiscalPeriodStartDate,
  lffp.FiscalPeriodEndDate AS CurrentFiscalPeriodEndDate,
  vmfp.FiscalPeriodStartDate AS PreviousFiscalPeriodStartDate,
  vmfp.FiscalPeriodEndDate AS PreviousFiscalPeriodEndDate
FROM P_CompanyCodePeriods AS ccp
INNER JOIN I_Ledger AS ld ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCompanyCodeCrcyRoles AS ldcmp ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalPeriodForVariant AS lffp ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalPeriodForVariant AS vmfp ON /* join condition not captured in parsed metadata */
;

Learn More