I_CmmdtyPrcgQtnPerdDetnRuleDef

DDL: I_CMMDTYPRCGQTNPERDDETNRULEDEF Type: view_entity BASIC
21 Fields 1 Data Sources

Quotation Period Determination Rule

I_CmmdtyPrcgQtnPerdDetnRuleDef is a Basic CDS View that provides data about "Quotation Period Determination Rule" in SAP S/4HANA. It reads from 1 data source (cpec_perioddet) and exposes 21 fields with key fields OriginSystem, PrcgCndnTrmQtnPerdDetnRule, CmmdtyPrcgValdtyStartDateTime.

Data Sources (1)

SourceAliasJoin Type
cpec_perioddet cpec_perioddet from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Quotation Period Determination Rule view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.entityBuffer.definitionAllowed true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY OriginSystem logsys Source system
KEY PrcgCndnTrmQtnPerdDetnRule perioddetrule Period Determ. Rule
KEY CmmdtyPrcgValdtyStartDateTime
PrcgCndnTrmQtnPerdDetnRoutine perioddetrout Period Det. Routine
PrcgCndnTrmQtnSrceRoutine sourcerout Source Routine
TrmQtnPerdDetnRefDateRoutine refdaterout Ref. Date Routine
TrmQtnPerdDetnDteOffsetRoutine dateoffsetrout Date Offset Routine
TrmQtnNrOfTmeUnitsForDteOffset offsetunits No. Time Units
TrmQtnPerdDetnTimeUnitRoutine timeuomrout Time UoM Routine
TrmQtnNrOfBfrBaseDateTmeUnits timeunitsbef Time Units Before
TrmQtnNrOfAftBaseDateTmeUnits timeunitsaft Time Units After
CndnTrmQtnBaseDateIsExcluded excl_basedate Exclude Base Date
PrcgCndnTrmQtnFxdPeriodStrtDte datefrom Valid From
PrcgCndnTrmQtnFxdPeriodStrtTme timefrom Time from
PrcgCndnTrmQtnFxdPeriodEndDate dateto Valid-To Date
PrcgCndnTrmQtnFxdPeriodEndTime timeto Valid-To Time
TrmQtnPerdDetnDateListRoutine datelistrout Date List Routine
PrcgCndnTrmQtnPerdDetnCalender perdetcalid Period Det. Calendar
TrmQtnPerdDetnMisgEntrRoutine missentryrout Miss. Entry Routine
TrmQtnClosedMarketDaysRoutine closeddaysrout Closed Days Routine
TrmQtnMaxElementWeightingValue 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_CmmdtyPrcgQtnPerdDetnRuleDef.
-- 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_CmmdtyPrcgQtnPerdDetnRuleDef AS
SELECT
  logsys AS OriginSystem,
  perioddetrule AS PrcgCndnTrmQtnPerdDetnRule,
  cast( cpec_perioddet.validto as cpet_validfrom_cds preserving type ) AS CmmdtyPrcgValdtyStartDateTime,
  perioddetrout AS PrcgCndnTrmQtnPerdDetnRoutine,
  sourcerout AS PrcgCndnTrmQtnSrceRoutine,
  refdaterout AS TrmQtnPerdDetnRefDateRoutine,
  dateoffsetrout AS TrmQtnPerdDetnDteOffsetRoutine,
  offsetunits AS TrmQtnNrOfTmeUnitsForDteOffset,
  timeuomrout AS TrmQtnPerdDetnTimeUnitRoutine,
  timeunitsbef AS TrmQtnNrOfBfrBaseDateTmeUnits,
  timeunitsaft AS TrmQtnNrOfAftBaseDateTmeUnits,
  excl_basedate AS CndnTrmQtnBaseDateIsExcluded,
  datefrom AS PrcgCndnTrmQtnFxdPeriodStrtDte,
  timefrom AS PrcgCndnTrmQtnFxdPeriodStrtTme,
  dateto AS PrcgCndnTrmQtnFxdPeriodEndDate,
  timeto AS PrcgCndnTrmQtnFxdPeriodEndTime,
  datelistrout AS TrmQtnPerdDetnDateListRoutine,
  perdetcalid AS PrcgCndnTrmQtnPerdDetnCalender,
  missentryrout AS TrmQtnPerdDetnMisgEntrRoutine,
  closeddaysrout AS TrmQtnClosedMarketDaysRoutine,
  maxweighting AS TrmQtnMaxElementWeightingValue
FROM cpec_perioddet
;

Learn More