P_ProcOrdOpLatestConf

DDL: P_PROCORDOPLATESTCONF Type: view_entity COMPOSITE Package: VDM_PP_PROC_ORD_MNG
12 Fields 1 Data Sources

Process order ops latest confirmation

P_ProcOrdOpLatestConf is a Composite CDS View that provides data about "Process order ops latest confirmation" in SAP S/4HANA. It reads from 1 data source (P_ProcOrdOpLatestConfAggrgn) and exposes 12 fields with key fields MfgOrderConfirmationGroup, OrderInternalBillOfOperations, OrderIntBillOfOperationsItem. Part of development package VDM_PP_PROC_ORD_MNG.

Data Sources (1)

SourceAliasJoin Type
P_ProcOrdOpLatestConfAggrgn _latestConf from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MfgOrderConfirmationGroup P_ProcOrdOpLatestConfAggrgn MfgOrderConfirmationGroup
KEY OrderInternalBillOfOperations P_ProcOrdOpLatestConfAggrgn OrderInternalBillOfOperations Order Internal Bill of Operations
KEY OrderIntBillOfOperationsItem P_ProcOrdOpLatestConfAggrgn OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
ProcessOrder P_ProcOrdOpLatestConfAggrgn ProcessOrder Order
MfgOrderConfirmation P_ProcOrdOpLatestConfAggrgn MfgOrderConfirmation
VarianceReasonCode _OrdConf VarianceReasonCode Reason
VarianceReasonName
ConfirmedProcessingStartDate _OrdConf ConfirmedProcessingStartDate
ConfirmedProcessingStartTime _OrdConf ConfirmedProcessingStartTime
ConfirmedProcessingEndDate _OrdConf ConfirmedProcessingEndDate
ConfirmedProcessingEndTime _OrdConf ConfirmedProcessingEndTime
numc15astimestampendasConfirmedDateTime

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 P_ProcOrdOpLatestConf.
-- 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 P_ProcOrdOpLatestConf AS
SELECT
  _latestConf.MfgOrderConfirmationGroup AS MfgOrderConfirmationGroup,
  _latestConf.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  _latestConf.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  _latestConf.ProcessOrder AS ProcessOrder,
  _latestConf.MfgOrderConfirmation AS MfgOrderConfirmation,
  _OrdConf.VarianceReasonCode AS VarianceReasonCode,
  _OrdConf._VarianceReason._Text[1: Language=$session.system_language].VarianceReasonName AS VarianceReasonName,
  _OrdConf.ConfirmedProcessingStartDate AS ConfirmedProcessingStartDate,
  _OrdConf.ConfirmedProcessingStartTime AS ConfirmedProcessingStartTime,
  _OrdConf.ConfirmedProcessingEndDate AS ConfirmedProcessingEndDate,
  _OrdConf.ConfirmedProcessingEndTime AS ConfirmedProcessingEndTime,
  case _OrdConf.ConfirmedProcessingEndTime when '240000' then cast(cast(concat(_OrdConf.ConfirmedProcessingEndDate,cast('235959' as tims))as abap.numc(15)) as timestamp) else cast(cast(concat(_OrdConf.ConfirmedProcessingEndDate , _OrdConf.ConfirmedProcessingEndTime)as abap.numc(15)) as timestamp) end as ConfirmedDateTime AS numc15astimestampendasConfirmedDateTime
FROM P_ProcOrdOpLatestConfAggrgn AS _latestConf
;

Learn More