I_CmmdtyPrcCrcyPerdDetnRuleDef

DDL: I_CMMDTYPRCCRCYPERDDETNRULEDEF Type: view_entity BASIC Package: LOG_CMM_PRC_CUSTOMIZING_VDM
20 Fields 1 Data Sources

Period Determination Rule Definition

I_CmmdtyPrcCrcyPerdDetnRuleDef is a Basic CDS View that provides data about "Period Determination Rule Definition" in SAP S/4HANA. It reads from 1 data source (cpec_perioddet) and exposes 20 fields with key fields OriginSystem, PrcgCndnTrmCrcyPerdDetnRule, CmmdtyPrcgValdtyStartDateTime. Part of development package LOG_CMM_PRC_CUSTOMIZING_VDM.

Data Sources (1)

SourceAliasJoin Type
cpec_perioddet cpec_perioddet from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Period Determination Rule Definition view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY OriginSystem logsys Source system
KEY PrcgCndnTrmCrcyPerdDetnRule perioddetrule Period Determ. Rule
KEY CmmdtyPrcgValdtyStartDateTime
PrcgCndnTrmCrcyPerdDetnRoutine perioddetrout Period Det. Routine
PrcgCndnTrmExchRateSrceRoutine sourcerout Source Routine
TrmCrcyPerdDetnRefDateRoutine refdaterout Ref. Date Routine
TrmCrcyPerdDetnDteOffstRoutine dateoffsetrout Date Offset Routine
TrmExchRatesNrOfUnitsDteOffst offsetunits No. Time Units
TrmCrcyPerdDetnTimeUnitRoutine timeuomrout Time UoM Routine
ExchRateNrOfBfrBaseDteTmeUnits timeunitsbef Time Units Before
CndnTrmExchRatesBaseDteIsExcld excl_basedate Exclude Base Date
CndnTrmExchRatesFxdPerdStrtDte datefrom Valid From
CndnTrmExchRatesFxdPerdStrtTme timefrom Time from
CndnTrmExchRatesFxdPerdEndDate dateto Valid-To Date
CndnTrmExchRatesFxdPerdEndTime timeto Valid-To Time
TrmCrcyPerdDetnDateListRoutine datelistrout Date List Routine
PrcgCndnTrmCrcyPerdDetnCal perdetcalid Period Det. Calendar
TrmCrcyPerdDetnMisgEntrRoutine missentryrout Miss. Entry Routine
TrmExchRatesClsdMktDaysRoutine closeddaysrout Closed Days Routine
TrmExchRatesMaxElmntWgtngValue maxweighting Max. Weighting

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 I_CmmdtyPrcCrcyPerdDetnRuleDef.
-- 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 I_CmmdtyPrcCrcyPerdDetnRuleDef AS
SELECT
  logsys AS OriginSystem,
  perioddetrule AS PrcgCndnTrmCrcyPerdDetnRule,
  cast( cpec_perioddet.validto as cpet_validfrom_cds preserving type ) AS CmmdtyPrcgValdtyStartDateTime,
  perioddetrout AS PrcgCndnTrmCrcyPerdDetnRoutine,
  sourcerout AS PrcgCndnTrmExchRateSrceRoutine,
  refdaterout AS TrmCrcyPerdDetnRefDateRoutine,
  dateoffsetrout AS TrmCrcyPerdDetnDteOffstRoutine,
  offsetunits AS TrmExchRatesNrOfUnitsDteOffst,
  timeuomrout AS TrmCrcyPerdDetnTimeUnitRoutine,
  timeunitsbef AS ExchRateNrOfBfrBaseDteTmeUnits,
  excl_basedate AS CndnTrmExchRatesBaseDteIsExcld,
  datefrom AS CndnTrmExchRatesFxdPerdStrtDte,
  timefrom AS CndnTrmExchRatesFxdPerdStrtTme,
  dateto AS CndnTrmExchRatesFxdPerdEndDate,
  timeto AS CndnTrmExchRatesFxdPerdEndTime,
  datelistrout AS TrmCrcyPerdDetnDateListRoutine,
  perdetcalid AS PrcgCndnTrmCrcyPerdDetnCal,
  missentryrout AS TrmCrcyPerdDetnMisgEntrRoutine,
  closeddaysrout AS TrmExchRatesClsdMktDaysRoutine,
  maxweighting AS TrmExchRatesMaxElmntWgtngValue
FROM cpec_perioddet
;

Learn More