C_CnsldtnPstRlVariableTP

DDL: C_CNSLDTNPSTRLVARIABLETP Type: view_entity CONSUMPTION Package: FIN_CS_RT_CONF
28 Fields 1 Data Sources 2 OData Services

Rule Variable Projection

C_CnsldtnPstRlVariableTP is a Consumption CDS View that provides data about "Rule Variable Projection" in SAP S/4HANA. It reads from 1 data source (R_CnsldtnPstRlVariableTP) and exposes 28 fields with key field CnsldtnPostingRuleVariable. It is exposed through 2 OData services (ASQL_F8339, UI_FINCS_CNSLDTN_POSTING_RULE). Part of development package FIN_CS_RT_CONF.

Data Sources (1)

SourceAliasJoin Type
R_CnsldtnPstRlVariableTP R_CnsldtnPstRlVariableTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Rule Variable Projection view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F8339 ASQL_F8339 C2 NOT_RELEASED
UI_FINCS_CNSLDTN_POSTING_RULE UI_FINCS_CNSLDTN_POSTING_RULE V4 C1 NOT_RELEASED

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CnsldtnPostingRuleVariable CnsldtnPostingRuleVariable
CnsldtnPstRlVariableText CnsldtnPstRlVariableText
CnsldtnPstRlVariableLongText CnsldtnPstRlVariableLongText
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
ChangedBy ChangedBy User Name
ChangedDateTime ChangedDateTime Time Stamp
CnsldtnPstRlVariableStatus CnsldtnPstRlVariableStatus
ConsolidationSelection ConsolidationSelection
ConsolidationSelectionText _CnsldtnPstRlSelectionVH ConsolidationSelectionText
CnsldtnPstRlPerdSelVariable CnsldtnPstRlPerdSelVariable
CnsldtnPstRlVarblPerdFromType CnsldtnPstRlVarblPerdFromType
CnsldtnPstRlVarblPerdFromValue CnsldtnPstRlVarblPerdFromValue
CnsldtnPstRlVarblPerdToType CnsldtnPstRlVarblPerdToType
CnsldtnPstRlVarblPeriodToValue CnsldtnPstRlVarblPeriodToValue
CnsldtnPstRlVarblPerdYearType CnsldtnPstRlVarblPerdYearType
CnsldtnPstRlVarblPerdYearValue CnsldtnPstRlVarblPerdYearValue
CnsldtnPstRlVarblDataSource CnsldtnPstRlVarblDataSource
CnsldtnPstRlVarblMeasureField CnsldtnPstRlVarblMeasureField
Criticality Criticality Status Rating
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_Description _Description
_CnsldtnPstRlVariableStatusVH _CnsldtnPstRlVariableStatusVH
_CnsldtnPstRlPerdSelVarblVH _CnsldtnPstRlPerdSelVarblVH
_CnsldtnPstRlSelectionVH _CnsldtnPstRlSelectionVH
_CnsldtnPstRlVarblMsrVH _CnsldtnPstRlVarblMsrVH

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_CnsldtnPstRlVariableTP.
-- 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_CnsldtnPstRlVariableTP AS
SELECT
  CnsldtnPostingRuleVariable,
  CnsldtnPstRlVariableText,
  CnsldtnPstRlVariableLongText,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  ChangedBy,
  ChangedDateTime,
  CnsldtnPstRlVariableStatus,
  ConsolidationSelection,
  _CnsldtnPstRlSelectionVH.ConsolidationSelectionText AS ConsolidationSelectionText,
  CnsldtnPstRlPerdSelVariable,
  CnsldtnPstRlVarblPerdFromType,
  CnsldtnPstRlVarblPerdFromValue,
  CnsldtnPstRlVarblPerdToType,
  CnsldtnPstRlVarblPeriodToValue,
  CnsldtnPstRlVarblPerdYearType,
  CnsldtnPstRlVarblPerdYearValue,
  CnsldtnPstRlVarblDataSource,
  CnsldtnPstRlVarblMeasureField,
  Criticality
FROM R_CnsldtnPstRlVariableTP
;

Learn More