SEPMRA_I_SlsOrdItemToTimeDim

DDL: SEPMRA_I_SLSORDITEMTOTIMEDIM Type: view Package: S_EPMRA_COMMON
11 Fields 1 Data Sources 2 Associations

Projection of SO Item to Time Dimension

SEPMRA_I_SlsOrdItemToTimeDim is a CDS View that provides data about "Projection of SO Item to Time Dimension" in SAP S/4HANA. It reads from 1 data source (SEPM_I_SlsOrdItemScheduleLine) and exposes 11 fields with key field SalesOrderItemUUID. It has 2 associations to related views. Part of development package S_EPMRA_COMMON.

Data Sources (1)

SourceAliasJoin Type
SEPM_I_SlsOrdItemScheduleLine ScheduleLine from

Associations (2)

CardinalityTargetAliasCondition
[0..1] SEPMRA_I_Month _DeliveryCalendarMonth $projection.DeliveryCalendarMonth = _DeliveryCalendarMonth.CalendarMonth
[0..1] SEPMRA_I_CalendarQuarter _DeliveryCalendarQuarter $projection.DeliveryCalendarQuarter = _DeliveryCalendarQuarter.CalendarQuarter

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SEPMRAISOI2TIME view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Projection of SO Item to Time Dimension view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderItemUUID SalesOrderItemUUID UUID
DeliveryDateTime DeliveryDateTime Time Stamp
DeliveryCalendarDate Time Stamp
DeliveryCalendarYear Time Stamp
DeliveryCalendarMonth Time Stamp
DeliveryCalendarDayOfMonth Time Stamp
DeliveryCalendarYearMonth Time Stamp
DeliveryCalendarQuarter Time Stamp
char111asDeliveryCalendarYearQuarter Time Stamp
_DeliveryCalendarMonth _DeliveryCalendarMonth
_DeliveryCalendarQuarter _DeliveryCalendarQuarter

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 SEPMRA_I_SlsOrdItemToTimeDim.
-- 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 SEPMRA_I_SlsOrdItemToTimeDim AS
SELECT
  SalesOrderItemUUID,
  DeliveryDateTime,
  cast(left(cast(DeliveryDateTime as abap.char(23)), 8) as abap.dats) AS DeliveryCalendarDate,
  cast( left( cast(DeliveryDateTime as abap.char(23)), 4) as abap.numc(4)) AS DeliveryCalendarYear,
  cast( substring( cast(DeliveryDateTime as abap.char(23)), 5, 2) as abap.numc(2)) AS DeliveryCalendarMonth,
  cast( substring( cast(DeliveryDateTime as abap.char(23)), 7, 2) as abap.numc(2)) AS DeliveryCalendarDayOfMonth,
  cast( left( cast(DeliveryDateTime as abap.char(23)), 6) as abap.numc(6)) AS DeliveryCalendarYearMonth,
  cast( left(cast(div( cast(cast(substring(cast(DeliveryDateTime as abap.char(23)), 5, 2) as abap.numc(2)) as abap.int4) + 2, 3) as abap.char(11)), 1) as sepmra_calendarquarter ) AS DeliveryCalendarQuarter,
  concat( left( cast(DeliveryDateTime as abap.char(23)), 4), left(cast(div( cast(cast(substring(cast(DeliveryDateTime as abap.char(23)), 5, 2) as abap.numc(2)) as abap.int4) + 2, 3) as abap.char(11)), 1) ) as DeliveryCalendarYearQuarter AS char111asDeliveryCalendarYearQuarter
FROM SEPM_I_SlsOrdItemScheduleLine AS ScheduleLine
LEFT OUTER JOIN SEPMRA_I_Month AS _DeliveryCalendarMonth ON DeliveryCalendarMonth = _DeliveryCalendarMonth.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_CalendarQuarter AS _DeliveryCalendarQuarter ON DeliveryCalendarQuarter = _DeliveryCalendarQuarter.CalendarQuarter  -- association [0..1]
;

Learn More