P_CommitmentKey

DDL: P_COMMITMENTKEY SQL: PCOMMITMENTKEY Type: view COMPOSITE Package: ODATA_COMMITMENT_REPORTING
28 Fields

Commitments Keys

P_CommitmentKey is a Composite CDS View that provides data about "Commitments Keys" in SAP S/4HANA. Part of development package ODATA_COMMITMENT_REPORTING.

Parameters (3)

NameTypeDefault
P_StartDate datum
P_EndDate datum
P_PlanningCategory fis_category

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCOMMITMENTKEY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (28)

KeyFieldSource TableSource FieldDescription
LedgerGLLineItem LedgerGLLineItem Journal Entry Item
SourceLedger SourceLedger Source Ledger
AccountingDocument AccountingDocument Journal Entry
Ledger Ledger Ledger
CompanyCode CompanyCode Receiver Company Code
CostElement GLAccount General Ledger
CostCenter CostCenter Cost Center
ControllingArea ControllingArea Controlling Area
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
FiscalYearVariant FiscalYearVariant FY Variant
ValidityEndDate _CostCenter ValidityEndDate ValidTo
ValidityStartDate _CostCenter ValidityStartDate Validity Start Date
FiscalPeriodStartDate _FiscalYearPeriod FiscalPeriodStartDate
SourceLedger Source Ledger
AccountingDocument Journal Entry
Ledger Ledger
CompanyCode CompanyCode Receiver Company Code
CostElement GLAccount General Ledger
CostCenter CostCenter Cost Center
ControllingArea ControllingArea Controlling Area
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
FiscalYearVariant FiscalYearVariant FY Variant
ValidityEndDate _CostCenter ValidityEndDate ValidTo
ValidityStartDate _CostCenter ValidityStartDate Validity Start Date
FiscalPeriodStartDate _FiscalYearPeriod FiscalPeriodStartDate
FiscalPeriodEndDate _FiscalYearPeriod FiscalPeriodEndDate

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_CommitmentKey.
-- 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: PCOMMITMENTKEY
-- Parameters: P_StartDate : datum, P_EndDate : datum, P_PlanningCategory : fis_category

CREATE VIEW P_CommitmentKey AS
SELECT
  LedgerGLLineItem,
  SourceLedger,
  AccountingDocument,
  Ledger,
  CompanyCode,
  GLAccount AS CostElement,
  CostCenter,
  ControllingArea,
  FiscalYear,
  FiscalPeriod,
  FiscalYearVariant,
  _CostCenter.ValidityEndDate AS ValidityEndDate,
  _CostCenter.ValidityStartDate AS ValidityStartDate,
  _FiscalYearPeriod.FiscalPeriodStartDate AS FiscalPeriodStartDate,
  _FiscalYearPeriod.FiscalPeriodEndDate AS FiscalPeriodEndDate
;

Learn More