C_CndnContrSettlmtCal_F3594A

DDL: C_CNDNCONTRSETTLMTCAL_F3594A Type: view_entity CONSUMPTION Package: WCB_UI_CC_F3594A
29 Fields 1 Data Sources 2 Associations 2 OData Services

Settlement Dates for Condition Contract Object Page

C_CndnContrSettlmtCal_F3594A is a Consumption CDS View that provides data about "Settlement Dates for Condition Contract Object Page" in SAP S/4HANA. It reads from 1 data source (R_CndnContrSettlmtCalTP) and exposes 29 fields with key fields ConditionContract, SettlmtDate, SettlmtDateCat. It has 2 associations to related views. It is exposed through 2 OData services (ASQL_F3594A, UI_LO_SETMAN_CC_OPG). Part of development package WCB_UI_CC_F3594A.

Data Sources (1)

SourceAliasJoin Type
R_CndnContrSettlmtCalTP R_CndnContrSettlmtCalTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_SettlmtDoc_F3594A _SettlementDocuments $projection.ConditionContract = _SettlementDocuments.SettlmtReltdCndnContr and $projection.SettlmtDate = _SettlementDocuments.SettlmtDate and $projection.SettlmtDateCat = _SettlementDocuments.SettlmtDateCat
[0..*] C_PersSettlmtDoc_F3594A _PersonnelSettlementDocuments $projection.ConditionContract = _PersonnelSettlementDocuments.SettlmtReltdCndnContr and $projection.SettlmtDate = _PersonnelSettlementDocuments.SettlmtDate and $projection.SettlmtDateCat = _PersonnelSettlementDocuments.SettlmtDateCat

Annotations (10)

NameValueLevelField
EndUserText.label Settlement Dates for Condition Contract Object Page view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F3594A ASQL_F3594A C2 NOT_RELEASED
UI_LO_SETMAN_CC_OPG UI_LO_SETMAN_CC_OPG V4 C1 NOT_RELEASED

Fields (29)

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
CndnContrUUID
CndnContrType
CndnContrSuplrSettlmtCat
SettlmtDateCatNamelocalized
CndnContrPrtlSettlmtCat
virtualSettlmtMgmtSchedgWlwlf_swl_id
virtualUICT_Hdr_Settlement_Statusboolean
virtualUICT_Coll_Gen_Infoboolean
virtualUICT_Coll_SDocsboolean
virtualUICT_Coll_PSDocsboolean
virtualUICT_Fldgrp_Date_Detailsboolean
virtualUICT_Fldgrp_BusVol_Datesboolean
virtualUICT_Fldgrp_SWLboolean
virtualUICT_PrtlSettlmtCatboolean
_SettlementDocuments _SettlementDocuments
_PersonnelSettlementDocuments _PersonnelSettlementDocuments

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_CndnContrSettlmtCal_F3594A.
-- 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 C_CndnContrSettlmtCal_F3594A AS
SELECT
  ConditionContract,
  SettlmtDate,
  SettlmtDateCat,
  SettlmtDateSequentialID,
  CndnContrCalItemUUID,
  RefSettlmtDate,
  RefSettlmtDateSequentialID,
  SettlmtExecutionDate,
  SettlementFixedValueDate,
  BusVolDateFrom,
  BusVolDateTo,
  SettlmtDateUsage,
  CndnContrSourceCalItemUUID,
  R_CndnContrSettlmtCalTP._ConditionContract.CndnContrUUID AS CndnContrUUID,
  R_CndnContrSettlmtCalTP._ConditionContract.CndnContrType AS CndnContrType,
  R_CndnContrSettlmtCalTP._ConditionContract.CndnContrSuplrSettlmtCat AS CndnContrSuplrSettlmtCat,
  R_CndnContrSettlmtCalTP._SettlmtDateCat._Text.SettlmtDateCatName : localized AS SettlmtDateCatNamelocalized,
  _ConditionContract._CndnContrType.CndnContrPrtlSettlmtCat AS CndnContrPrtlSettlmtCat,
  virtual SettlmtMgmtSchedgWl : wlf_swl_id AS virtualSettlmtMgmtSchedgWlwlf_swl_id,
  virtual UICT_Hdr_Settlement_Status : boolean AS virtualUICT_Hdr_Settlement_Statusboolean,
  virtual UICT_Coll_Gen_Info : boolean AS virtualUICT_Coll_Gen_Infoboolean,
  virtual UICT_Coll_SDocs : boolean AS virtualUICT_Coll_SDocsboolean,
  virtual UICT_Coll_PSDocs : boolean AS virtualUICT_Coll_PSDocsboolean,
  virtual UICT_Fldgrp_Date_Details : boolean AS virtualUICT_Fldgrp_Date_Detailsboolean,
  virtual UICT_Fldgrp_BusVol_Dates : boolean AS virtualUICT_Fldgrp_BusVol_Datesboolean,
  virtual UICT_Fldgrp_SWL : boolean AS virtualUICT_Fldgrp_SWLboolean,
  virtual UICT_PrtlSettlmtCat : boolean AS virtualUICT_PrtlSettlmtCatboolean
FROM R_CndnContrSettlmtCalTP
LEFT OUTER JOIN C_SettlmtDoc_F3594A AS _SettlementDocuments ON ConditionContract = _SettlementDocuments.SettlmtReltdCndnContr AND SettlmtDate = _SettlementDocuments.SettlmtDate AND SettlmtDateCat = _SettlementDocuments.SettlmtDateCat  -- association [0..*]
LEFT OUTER JOIN C_PersSettlmtDoc_F3594A AS _PersonnelSettlementDocuments ON ConditionContract = _PersonnelSettlementDocuments.SettlmtReltdCndnContr AND SettlmtDate = _PersonnelSettlementDocuments.SettlmtDate AND SettlmtDateCat = _PersonnelSettlementDocuments.SettlmtDateCat  -- association [0..*]
;

Learn More