FINOC_CHECK_REC_02_KEYDATE

DDL: FINOC_CHECK_REC_02_KEYDATE Type: view_entity
12 Fields 1 Data Sources

Org. Change: PRCTRS at KEYDATE

FINOC_CHECK_REC_02_KEYDATE is a CDS View that provides data about "Org. Change: PRCTRS at KEYDATE" in SAP S/4HANA. It reads from 1 data source (FINOC_CHECK_REC_01_PRCTRS) and exposes 12 fields with key field intreno.

Data Sources (1)

SourceAliasJoin Type
FINOC_CHECK_REC_01_PRCTRS FINOC_CHECK_REC_01_PRCTRS from

Parameters (1)

NameTypeDefault
iv_effective_date finoc_effective_date

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Org. Change: PRCTRS at KEYDATE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY intreno intreno Source Object
recnnr recnnr Contract No.
bukrs bukrs Value
moa_termtype moa_termtype Term Type
moa_termno moa_termno Term Number
moa_validto moa_validto Vers.Valid To
val_termno val_termno Term Number
val_valid_to val_valid_to Valid To
moa_prctr moa_prctr Profit Centers
by_moa by_moa
by_val by_val
by_subj by_subj

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 FINOC_CHECK_REC_02_KEYDATE.
-- 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.
-- Parameters: iv_effective_date : finoc_effective_date

CREATE VIEW FINOC_CHECK_REC_02_KEYDATE AS
SELECT
  intreno,
  recnnr,
  bukrs,
  moa_termtype,
  moa_termno,
  moa_validto,
  val_termno,
  val_valid_to,
  moa_prctr,
  by_moa,
  by_val,
  by_subj
FROM FINOC_CHECK_REC_01_PRCTRS
;

Learn More