C_SettlmtDocsCntNotRvsd

DDL: C_SETTLMTDOCSCNTNOTRVSD Type: view_entity CONSUMPTION Package: WCB_UI_CC_F4964

Settlmt Docs Count Not Reversed

C_SettlmtDocsCntNotRvsd is a Consumption CDS View that provides data about "Settlmt Docs Count Not Reversed" in SAP S/4HANA. It reads from 1 data source (R_SettlmtMgmtDoc) and exposes 5 fields with key fields SettlmtReltdCndnContr, SettlmtDate, SettlmtDateCat. It is exposed through 8 OData services (ASQL_F4964, ASQL_F7846, ASQL_F7847, ...). Part of development package WCB_UI_CC_F4964.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtMgmtDoc R_SettlmtMgmtDoc from

Annotations (7)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view
EndUserText.label Settlmt Docs Count Not Reversed view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

OData Services (8)

ServiceBindingVersionContractRelease
ASQL_F4964 ASQL_F4964 C2 NOT_RELEASED
ASQL_F7846 ASQL_F7846 C2 NOT_RELEASED
ASQL_F7847 ASQL_F7847 C2 NOT_RELEASED
ASQL_F7848 ASQL_F7848 C2 NOT_RELEASED
ASQL_F7849 ASQL_F7849 C2 NOT_RELEASED
ASQL_F7850 ASQL_F7850 C2 NOT_RELEASED
ASQL_F7851 ASQL_F7851 C2 NOT_RELEASED
UI_LO_SETMAN_CC_SETDATES UI_LO_SETMAN_CC_SETDATES V4 C1 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SettlmtReltdCndnContr SettlmtReltdCndnContr Related Condition Contract
KEY SettlmtDate SettlmtDate Settlement Date
KEY SettlmtDateCat SettlmtDateCat Settlement Date Type
SettlmtDateSequentialID SettlmtDateSequentialID Settlement Date ID
NumberOfSettlementDocuments

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_SettlmtDocsCntNotRvsd.
-- 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_SettlmtDocsCntNotRvsd AS
SELECT
  SettlmtReltdCndnContr,
  SettlmtDate,
  SettlmtDateCat,
  SettlmtDateSequentialID,
  count(*) AS NumberOfSettlementDocuments
FROM R_SettlmtMgmtDoc
;