I_MfgOrderOperationDurnCube
Manufacturing Order Operation Duration - Cube
I_MfgOrderOperationDurnCube is a Composite CDS View (Cube) that provides data about "Manufacturing Order Operation Duration - Cube" in SAP S/4HANA. It reads from 3 data sources (P_PPH_ReportingDate3, I_OrderItem, I_MfgOrderOperationCube) and exposes 123 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem. It has 5 associations to related views.
Data Sources (3)
| Source | Alias | Join Type |
|---|---|---|
| P_PPH_ReportingDate3 | date | inner |
| I_OrderItem | item | inner |
| I_MfgOrderOperationCube | oper | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_CalendarDate | _EndDate | $projection.ActualExecutionEndDate = _EndDate.CalendarDate |
| [0..1] | I_WeekDay | _EndDateWeekDay | $projection.EndDateWeekDay = _EndDateWeekDay.WeekDay |
| [0..1] | I_CalendarMonth | _EndDateMonth | $projection.EndDateMonth = _EndDateMonth.CalendarMonth |
| [0..1] | I_CalendarYear | _EndDateYear | $projection.EndDateYear = _EndDateYear.CalendarYear |
| [0..1] | I_ReportingPeriod | _ReportingPeriod | $projection.ReportingPeriod = _ReportingPeriod.ReportingPeriod |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IPPMFGORDEROPDC | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| Analytics.dataCategory | #CUBE | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ClientHandling.type | #CLIENT_DEPENDENT | view | |
| Metadata.allowExtensions | true | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_CUBE | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.viewType | #COMPOSITE | view | |
| EndUserText.label | Manufacturing Order Operation Duration - Cube | view |
Fields (123)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | OrderInternalBillOfOperations | I_MfgOrderOperationCube | OrderInternalBillOfOperations | Order Internal Bill of Operations |
| KEY | OrderIntBillOfOperationsItem | I_MfgOrderOperationCube | OrderIntBillOfOperationsItem | Order Internal Bill of Operations Item |
| ManufacturingOrder | I_MfgOrderOperationCube | ManufacturingOrder | Order | |
| ManufacturingOrderSequence | I_MfgOrderOperationCube | ManufacturingOrderSequence | ||
| ManufacturingOrderOperation | I_MfgOrderOperationCube | ManufacturingOrderOperation | Activity | |
| ManufacturingOrderSubOperation | I_MfgOrderOperationCube | ManufacturingOrderSubOperation | ||
| ManufacturingOrderCategory | I_MfgOrderOperationCube | ManufacturingOrderCategory | ||
| ManufacturingOrderType | I_MfgOrderOperationCube | ManufacturingOrderType | ||
| ProductionSupervisor | I_MfgOrderOperationCube | ProductionSupervisor | Prodn Supervisor | |
| MRPPlant | I_OrderItem | MRPPlant | Plant | |
| Material | I_OrderItem | Material | Vehicle Model | |
| MfgOrderOperationText | I_MfgOrderOperationCube | MfgOrderOperationText | ||
| Language | I_MfgOrderOperationCube | Language | Report Text Language | |
| MfgOrderOperationIsPhase | I_MfgOrderOperationCube | MfgOrderOperationIsPhase | ||
| MfgOrderPhaseSuperiorOperation | I_MfgOrderOperationCube | MfgOrderPhaseSuperiorOperation | ||
| NumberOfCapacities | I_MfgOrderOperationCube | NumberOfCapacities | Number | |
| NumberOfConfirmationSlips | I_MfgOrderOperationCube | NumberOfConfirmationSlips | No. of Conf. Slips | |
| NumberOfOperationConfirmations | I_MfgOrderOperationCube | NumberOfOperationConfirmations | ||
| OperationImportance | I_MfgOrderOperationCube | OperationImportance | ||
| OperationIsCreated | I_MfgOrderOperationCube | OperationIsCreated | ||
| OperationIsReleased | I_MfgOrderOperationCube | OperationIsReleased | ||
| OperationIsPrinted | I_MfgOrderOperationCube | OperationIsPrinted | ||
| OperationIsConfirmed | I_MfgOrderOperationCube | OperationIsConfirmed | ||
| OperationIsPartiallyConfirmed | I_MfgOrderOperationCube | OperationIsPartiallyConfirmed | ||
| OperationIsTechlyCompleted | I_MfgOrderOperationCube | OperationIsTechlyCompleted | ||
| OperationIsClosed | I_MfgOrderOperationCube | OperationIsClosed | ||
| OperationIsScheduled | I_MfgOrderOperationCube | OperationIsScheduled | ||
| OperationIsPartiallyDelivered | I_MfgOrderOperationCube | OperationIsPartiallyDelivered | ||
| OperationIsDelivered | I_MfgOrderOperationCube | OperationIsDelivered | ||
| ProductionPlant | I_MfgOrderOperationCube | ProductionPlant | Prod plnt | |
| WorkCenterInternalID | I_MfgOrderOperationCube | WorkCenterInternalID | Work Center | |
| WorkCenterTypeCode | I_MfgOrderOperationCube | WorkCenterTypeCode | Object Type | |
| WorkCenter | I_MfgOrderOperationCube | WorkCenter | Work Center | |
| OperationControlProfile | I_MfgOrderOperationCube | OperationControlProfile | Control Key | |
| BillOfOperationsType | I_MfgOrderOperationCube | BillOfOperationsType | Task List Type | |
| OperationConfirmation | I_MfgOrderOperationCube | OperationConfirmation | ||
| CapacityRequirement | I_MfgOrderOperationCube | CapacityRequirement | ||
| CapacityRequirementItem | I_MfgOrderOperationCube | CapacityRequirementItem | ||
| CompanyCode | I_MfgOrderOperationCube | CompanyCode | Receiver Company Code | |
| ControllingArea | I_MfgOrderOperationCube | ControllingArea | Controlling Area | |
| OpErlstSchedldExecStrtDte | I_MfgOrderOperationCube | OpErlstSchedldExecStrtDte | Earl.start date | |
| OpErlstSchedldExecStrtTme | I_MfgOrderOperationCube | OpErlstSchedldExecStrtTme | ||
| OpErlstSchedldProcgStrtDte | I_MfgOrderOperationCube | OpErlstSchedldProcgStrtDte | ||
| OpErlstSchedldProcgStrtTme | I_MfgOrderOperationCube | OpErlstSchedldProcgStrtTme | ||
| OpErlstSchedldTrdwnStrtDte | I_MfgOrderOperationCube | OpErlstSchedldTrdwnStrtDte | ||
| OpErlstSchedldTrdwnStrtTme | I_MfgOrderOperationCube | OpErlstSchedldTrdwnStrtTme | ||
| OpErlstSchedldExecEndDte | I_MfgOrderOperationCube | OpErlstSchedldExecEndDte | EarliestEndDate | |
| OpErlstSchedldExecEndTme | I_MfgOrderOperationCube | OpErlstSchedldExecEndTme | ||
| OpLtstSchedldExecStrtDte | I_MfgOrderOperationCube | OpLtstSchedldExecStrtDte | Latest start | |
| OpLtstSchedldExecStrtTme | I_MfgOrderOperationCube | OpLtstSchedldExecStrtTme | ||
| OpLtstSchedldProcgStrtDte | I_MfgOrderOperationCube | OpLtstSchedldProcgStrtDte | ||
| OpLtstSchedldProcgStrtTme | I_MfgOrderOperationCube | OpLtstSchedldProcgStrtTme | ||
| OpLtstSchedldTrdwnStrtDte | I_MfgOrderOperationCube | OpLtstSchedldTrdwnStrtDte | ||
| OpLtstSchedldTrdwnStrtTme | I_MfgOrderOperationCube | OpLtstSchedldTrdwnStrtTme | ||
| OpLtstSchedldExecEndDte | I_MfgOrderOperationCube | OpLtstSchedldExecEndDte | Lat.finish date | |
| OpLtstSchedldExecEndTme | I_MfgOrderOperationCube | OpLtstSchedldExecEndTme | ||
| OperationConfirmedStartDate | I_MfgOrderOperationCube | OperationConfirmedStartDate | ||
| OperationConfirmedEndDate | I_MfgOrderOperationCube | OperationConfirmedEndDate | ||
| OpActualExecutionStartDate | I_MfgOrderOperationCube | OpActualExecutionStartDate | Execution Start Date | |
| OpActualExecutionStartTime | I_MfgOrderOperationCube | OpActualExecutionStartTime | ||
| OpActualSetupEndDate | I_MfgOrderOperationCube | OpActualSetupEndDate | ||
| OpActualSetupEndTime | I_MfgOrderOperationCube | OpActualSetupEndTime | ||
| OpActualProcessingStartDate | I_MfgOrderOperationCube | OpActualProcessingStartDate | ||
| OpActualProcessingStartTime | I_MfgOrderOperationCube | OpActualProcessingStartTime | ||
| OpActualProcessingEndDate | I_MfgOrderOperationCube | OpActualProcessingEndDate | ||
| OpActualProcessingEndTime | I_MfgOrderOperationCube | OpActualProcessingEndTime | ||
| OpActualTeardownStartDate | I_MfgOrderOperationCube | OpActualTeardownStartDate | ||
| OpActualTeardownStartTme | I_MfgOrderOperationCube | OpActualTeardownStartTme | ||
| OpActualExecutionEndDate | I_MfgOrderOperationCube | OpActualExecutionEndDate | Execution End Date | |
| OpActualExecutionEndTime | I_MfgOrderOperationCube | OpActualExecutionEndTime | ||
| ReportingPeriod | ||||
| ActualExecutionEndDate | I_MfgOrderOperationCube | OpActualExecutionEndDate | Execution End Date | |
| ActualExecutionEndTime | I_MfgOrderOperationCube | OpActualExecutionEndTime | ||
| EndDateHour | ||||
| EndDateWeekDay | P_PPH_ReportingDate3 | ReportingDateWeekDay | ||
| EndDateWeek | P_PPH_ReportingDate3 | ReportingDateWeek | ||
| EndDateMonth | P_PPH_ReportingDate3 | ReportingDateMonth | ||
| EndDateYear | P_PPH_ReportingDate3 | ReportingDateYear | ||
| EndDateYearMonth | ||||
| PlannedActualStartDateDvtnDurn | I_MfgOrderOperationCube | PlannedActualStartDateDvtnDurn | ||
| PlannedActualEndDateDvtnDurn | I_MfgOrderOperationCube | PlannedActualEndDateDvtnDurn | ||
| PlannedCurrentStrtDateDvtnDurn | I_MfgOrderOperationCube | PlannedCurrentStrtDateDvtnDurn | ||
| PlannedCurrentEndDateDvtnDurn | I_MfgOrderOperationCube | PlannedCurrentEndDateDvtnDurn | ||
| DurationUnit | I_MfgOrderOperationCube | DurationUnit | Unit | |
| ActualWorkdayDurnInSeconds | ||||
| PlannedWorkdayDurnInSeconds | ||||
| DeviationWorkdayDurnInSeconds | ||||
| HoursUnitOfMeasure | I_MfgOrderOperationCube | HoursUnitOfMeasure | Unit of Measure | |
| ActualDurationUnit | ||||
| PlannedDurationUnit | ||||
| DeviationDurationUnit | ||||
| _ManufacturingOrder | I_MfgOrderOperationCube | _ManufacturingOrder | ||
| _OrderInternalID | I_MfgOrderOperationCube | _OrderInternalID | ||
| _OrdInternalBillOfOperations | I_MfgOrderOperationCube | _OrdInternalBillOfOperations | ||
| _MfgOrder | I_MfgOrderOperationCube | _MfgOrder | ||
| _MfgOrderSequence | I_MfgOrderOperationCube | _MfgOrderSequence | ||
| _MfgOrderCategory | I_MfgOrderOperationCube | _MfgOrderCategory | ||
| _MfgOrderType | I_MfgOrderOperationCube | _MfgOrderType | ||
| _ProductionPlant | I_MfgOrderOperationCube | _ProductionPlant | ||
| _ProductionSupervisor | I_MfgOrderOperationCube | _ProductionSupervisor | ||
| _OperationControlProfile | I_MfgOrderOperationCube | _OperationControlProfile | ||
| _BillOfOperationsType | I_MfgOrderOperationCube | _BillOfOperationsType | ||
| _WorkCenter | I_MfgOrderOperationCube | _WorkCenter | ||
| _WorkCenterType | I_MfgOrderOperationCube | _WorkCenterType | ||
| _WorkCenterBySemanticKey | I_MfgOrderOperationCube | _WorkCenterBySemanticKey | ||
| _Material | I_OrderItem | _Material | ||
| _MRPPlant | I_OrderItem | _MRPPlant | ||
| _CapacityRequirement | I_MfgOrderOperationCube | _CapacityRequirement | ||
| _CapacityRequirementItem | I_MfgOrderOperationCube | _CapacityRequirementItem | ||
| _OperationConfirmation | I_MfgOrderOperationCube | _OperationConfirmation | ||
| _CompanyCode | I_MfgOrderOperationCube | _CompanyCode | ||
| _ControllingArea | I_MfgOrderOperationCube | _ControllingArea | ||
| _Language | I_MfgOrderOperationCube | _Language | ||
| _DurationUnit | I_MfgOrderOperationCube | _DurationUnit | ||
| _DurationUnitHours | I_MfgOrderOperationCube | _DurationUnitHours | ||
| _ActualDurationUnit | I_MfgOrderOperationCube | _ActualDurationUnit | ||
| _PlannedDurationUnit | I_MfgOrderOperationCube | _PlannedDurationUnit | ||
| _DeviationDurationUnit | I_MfgOrderOperationCube | _DeviationDurationUnit | ||
| _ReportingPeriod | _ReportingPeriod | |||
| _EndDate | _EndDate | |||
| _EndDateWeekDay | _EndDateWeekDay | |||
| _EndDateMonth | _EndDateMonth | |||
| _EndDateYear | _EndDateYear |
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_MfgOrderOperationDurnCube.
-- 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.
-- SQL view name: IPPMFGORDEROPDC
CREATE VIEW I_MfgOrderOperationDurnCube AS
SELECT
oper.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
oper.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
oper.ManufacturingOrder AS ManufacturingOrder,
oper.ManufacturingOrderSequence AS ManufacturingOrderSequence,
oper.ManufacturingOrderOperation AS ManufacturingOrderOperation,
oper.ManufacturingOrderSubOperation AS ManufacturingOrderSubOperation,
oper.ManufacturingOrderCategory AS ManufacturingOrderCategory,
oper.ManufacturingOrderType AS ManufacturingOrderType,
oper.ProductionSupervisor AS ProductionSupervisor,
item.MRPPlant AS MRPPlant,
item.Material AS Material,
oper.MfgOrderOperationText AS MfgOrderOperationText,
oper.Language AS Language,
oper.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
oper.MfgOrderPhaseSuperiorOperation AS MfgOrderPhaseSuperiorOperation,
oper.NumberOfCapacities AS NumberOfCapacities,
oper.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
oper.NumberOfOperationConfirmations AS NumberOfOperationConfirmations,
oper.OperationImportance AS OperationImportance,
oper.OperationIsCreated AS OperationIsCreated,
oper.OperationIsReleased AS OperationIsReleased,
oper.OperationIsPrinted AS OperationIsPrinted,
oper.OperationIsConfirmed AS OperationIsConfirmed,
oper.OperationIsPartiallyConfirmed AS OperationIsPartiallyConfirmed,
oper.OperationIsTechlyCompleted AS OperationIsTechlyCompleted,
oper.OperationIsClosed AS OperationIsClosed,
oper.OperationIsScheduled AS OperationIsScheduled,
oper.OperationIsPartiallyDelivered AS OperationIsPartiallyDelivered,
oper.OperationIsDelivered AS OperationIsDelivered,
oper.ProductionPlant AS ProductionPlant,
oper.WorkCenterInternalID AS WorkCenterInternalID,
oper.WorkCenterTypeCode AS WorkCenterTypeCode,
oper.WorkCenter AS WorkCenter,
oper.OperationControlProfile AS OperationControlProfile,
oper.BillOfOperationsType AS BillOfOperationsType,
oper.OperationConfirmation AS OperationConfirmation,
oper.CapacityRequirement AS CapacityRequirement,
oper.CapacityRequirementItem AS CapacityRequirementItem,
oper.CompanyCode AS CompanyCode,
oper.ControllingArea AS ControllingArea,
oper.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
oper.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
oper.OpErlstSchedldProcgStrtDte AS OpErlstSchedldProcgStrtDte,
oper.OpErlstSchedldProcgStrtTme AS OpErlstSchedldProcgStrtTme,
oper.OpErlstSchedldTrdwnStrtDte AS OpErlstSchedldTrdwnStrtDte,
oper.OpErlstSchedldTrdwnStrtTme AS OpErlstSchedldTrdwnStrtTme,
oper.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
oper.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
oper.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
oper.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
oper.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
oper.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
oper.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
oper.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
oper.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
oper.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
oper.OperationConfirmedStartDate AS OperationConfirmedStartDate,
oper.OperationConfirmedEndDate AS OperationConfirmedEndDate,
oper.OpActualExecutionStartDate AS OpActualExecutionStartDate,
oper.OpActualExecutionStartTime AS OpActualExecutionStartTime,
oper.OpActualSetupEndDate AS OpActualSetupEndDate,
oper.OpActualSetupEndTime AS OpActualSetupEndTime,
oper.OpActualProcessingStartDate AS OpActualProcessingStartDate,
oper.OpActualProcessingStartTime AS OpActualProcessingStartTime,
oper.OpActualProcessingEndDate AS OpActualProcessingEndDate,
oper.OpActualProcessingEndTime AS OpActualProcessingEndTime,
oper.OpActualTeardownStartDate AS OpActualTeardownStartDate,
oper.OpActualTeardownStartTme AS OpActualTeardownStartTme,
oper.OpActualExecutionEndDate AS OpActualExecutionEndDate,
oper.OpActualExecutionEndTime AS OpActualExecutionEndTime,
cast(date.ReportingPeriod as pph_reportingperiod preserving type) AS ReportingPeriod,
oper.OpActualExecutionEndDate AS ActualExecutionEndDate,
oper.OpActualExecutionEndTime AS ActualExecutionEndTime,
cast(left(oper.OpActualExecutionEndTime,2) as enddatehour) AS EndDateHour,
date.ReportingDateWeekDay AS EndDateWeekDay,
date.ReportingDateWeek AS EndDateWeek,
date.ReportingDateMonth AS EndDateMonth,
date.ReportingDateYear AS EndDateYear,
cast(concat( date.ReportingDateYear, date.ReportingDateMonth ) as vdm_yearmonth) AS EndDateYearMonth,
oper.PlannedActualStartDateDvtnDurn AS PlannedActualStartDateDvtnDurn,
oper.PlannedActualEndDateDvtnDurn AS PlannedActualEndDateDvtnDurn,
oper.PlannedCurrentStrtDateDvtnDurn AS PlannedCurrentStrtDateDvtnDurn,
oper.PlannedCurrentEndDateDvtnDurn AS PlannedCurrentEndDateDvtnDurn,
oper.DurationUnit AS DurationUnit,
cast(oper.ActualWorkdayDurnInSeconds as actualdurationinsec preserving type) AS ActualWorkdayDurnInSeconds,
cast(oper.PlannedWorkdayDurnInSeconds as planneddurationinsec preserving type) AS PlannedWorkdayDurnInSeconds,
cast(oper.DeviationWorkdayDurnInSeconds as deviationdurationinsec preserving type) AS DeviationWorkdayDurnInSeconds,
oper.HoursUnitOfMeasure AS HoursUnitOfMeasure,
cast(oper.ActualDurationUnit as actualdurationunit preserving type) AS ActualDurationUnit,
cast(oper.PlannedDurationUnit as planneddurationunit preserving type) AS PlannedDurationUnit,
cast(oper.DeviationDurationUnit as deviationdurationunit preserving type) AS DeviationDurationUnit,
oper._ManufacturingOrder AS _ManufacturingOrder,
oper._OrderInternalID AS _OrderInternalID,
oper._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
oper._MfgOrder AS _MfgOrder,
oper._MfgOrderSequence AS _MfgOrderSequence,
oper._MfgOrderCategory AS _MfgOrderCategory,
oper._MfgOrderType AS _MfgOrderType,
oper._ProductionPlant AS _ProductionPlant,
oper._ProductionSupervisor AS _ProductionSupervisor,
oper._OperationControlProfile AS _OperationControlProfile,
oper._BillOfOperationsType AS _BillOfOperationsType,
oper._WorkCenter AS _WorkCenter,
oper._WorkCenterType AS _WorkCenterType,
oper._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
item._Material AS _Material,
item._MRPPlant AS _MRPPlant,
oper._CapacityRequirement AS _CapacityRequirement,
oper._CapacityRequirementItem AS _CapacityRequirementItem,
oper._OperationConfirmation AS _OperationConfirmation,
oper._CompanyCode AS _CompanyCode,
oper._ControllingArea AS _ControllingArea,
oper._Language AS _Language,
oper._DurationUnit AS _DurationUnit,
oper._DurationUnitHours AS _DurationUnitHours,
oper._ActualDurationUnit AS _ActualDurationUnit,
oper._PlannedDurationUnit AS _PlannedDurationUnit,
oper._DeviationDurationUnit AS _DeviationDurationUnit
FROM I_MfgOrderOperationCube AS oper
INNER JOIN I_OrderItem AS item ON /* join condition not captured in parsed metadata */
INNER JOIN P_PPH_ReportingDate3 AS date ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS _EndDate ON ActualExecutionEndDate = _EndDate.CalendarDate -- association [1..1]
LEFT OUTER JOIN I_WeekDay AS _EndDateWeekDay ON EndDateWeekDay = _EndDateWeekDay.WeekDay -- association [0..1]
LEFT OUTER JOIN I_CalendarMonth AS _EndDateMonth ON EndDateMonth = _EndDateMonth.CalendarMonth -- association [0..1]
LEFT OUTER JOIN I_CalendarYear AS _EndDateYear ON EndDateYear = _EndDateYear.CalendarYear -- association [0..1]
LEFT OUTER JOIN I_ReportingPeriod AS _ReportingPeriod ON ReportingPeriod = _ReportingPeriod.ReportingPeriod -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA