P_REActVlnForCoCodeContrType

DDL: P_REACTVLNFORCOCODECONTRTYPE Type: view_entity COMPOSITE Package: VDM_RE_CE
3 Fields 3 Data Sources

Valuation Rule

P_REActVlnForCoCodeContrType is a Composite CDS View that provides data about "Valuation Rule" in SAP S/4HANA. It reads from 3 data sources (tivcerule, tivcerulecc, tivcerulect) and exposes 3 fields with key fields REContractType, CompanyCode. Part of development package VDM_RE_CE.

Data Sources (3)

SourceAliasJoin Type
tivcerule _ValuationRule inner
tivcerulecc _ValuationRuleCC inner
tivcerulect _ValuationRuleCT from

Annotations (3)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY REContractType tivcerulect contracttype ContractTp
KEY CompanyCode tivcerulecc bukrs Value
REValuationRuleIsActive tivcerulect ceactive Val. Active

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_REActVlnForCoCodeContrType.
-- 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 P_REActVlnForCoCodeContrType AS
SELECT
  _ValuationRuleCT.contracttype AS REContractType,
  _ValuationRuleCC.bukrs AS CompanyCode,
  _ValuationRuleCT.ceactive AS REValuationRuleIsActive
FROM tivcerulect AS _ValuationRuleCT
INNER JOIN tivcerule AS _ValuationRule ON /* join condition not captured in parsed metadata */
INNER JOIN tivcerulecc AS _ValuationRuleCC ON /* join condition not captured in parsed metadata */
;

Learn More