A_CndnContrSettlmtCal

DDL: A_CNDNCONTRSETTLMTCAL Type: view_entity CONSUMPTION

Settlement Calendar

A_CndnContrSettlmtCal is a Consumption CDS View that provides data about "Settlement Calendar" in SAP S/4HANA. It reads from 1 data source (R_CndnContrSettlmtCalTP) and exposes 13 fields with key fields ConditionContract, SettlmtDate, SettlmtDateCat. It is exposed through 1 OData service (API_CONDITION_CONTRACT).

Data Sources (1)

SourceAliasJoin Type
R_CndnContrSettlmtCalTP R_CndnContrSettlmtCalTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Settlement Calendar view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

OData Services (1)

ServiceBindingVersionContractRelease
API_CONDITION_CONTRACT API_CONDITION_CONTRACT V4 C2 C1

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract ConditionContract Condition Contract
KEY SettlmtDate SettlmtDate Settlement Date
KEY SettlmtDateCat SettlmtDateCat Settlement Date Type
SettlmtDateSequentialID SettlmtDateSequentialID Settlement Date ID
CndnContrCalItemUUID CndnContrCalItemUUID
RefSettlmtDate RefSettlmtDate
RefSettlmtDateSequentialID RefSettlmtDateSequentialID
SettlmtExecutionDate SettlmtExecutionDate
SettlementFixedValueDate SettlementFixedValueDate
BusVolDateFrom BusVolDateFrom
BusVolDateTo BusVolDateTo
SettlmtDateUsage SettlmtDateUsage
CndnContrSourceCalItemUUID CndnContrSourceCalItemUUID

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 A_CndnContrSettlmtCal.
-- 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.

CREATE VIEW A_CndnContrSettlmtCal AS
SELECT
  ConditionContract,
  SettlmtDate,
  SettlmtDateCat,
  SettlmtDateSequentialID,
  CndnContrCalItemUUID,
  RefSettlmtDate,
  RefSettlmtDateSequentialID,
  SettlmtExecutionDate,
  SettlementFixedValueDate,
  BusVolDateFrom,
  BusVolDateTo,
  SettlmtDateUsage,
  CndnContrSourceCalItemUUID
FROM R_CndnContrSettlmtCalTP
;